xampp and innodb settings problem

Problems with the Windows version of XAMPP, questions, comments, and anything related.

xampp and innodb settings problem

Postby kerios83 » 23. July 2011 21:58

when I change my.ini file settings related with innodb mysql don't want to start:

Code: Select all
# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/data"
#innodb_log_arch_dir = "C:/xampp/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50


when i change even one thing here mysql dont want to start ! End i must change those settings cause I cant import my database...

Code: Select all
INSERT INTO `cache_menu` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES ('links:management:tree-data:en:ec99d3452fef1ede622e66c68ba908b1dad455aa71f5e68648aeec6488b89c88', 0x613a323a7b733a343a2274726565223b613a313a7b693a313b613a323a7b733a343a226c696e6b223b613a34343a7b733a393a226d656e755f6
e616d65223b733a31303a226d616e6167656d656e74223b733a343a226d6c6964223b733a313a2231223b733a343a22706c6964223b733a313a22
30223b733a393a226c696e6b5f70617468223b733a353a2261646d696e223b733a31313a22726f757465725f70617468223b733a353a2261646d69
6e223b733a31303a226c696e6b5f7469746c65223b733a31343a2241646d696e697374726174696f6e223b733a373a226f7074696f6e73223b733a3
63a22613a303a7b7d223b733a363a226d6f64756c65223b733a363a2273797374656d223b733a363a2268696464656e223b733a313a2230223b733
a383a2265787465726e616c223b733a313a2230223b733a31323a226861735f6368696c6472656e223b733a313a2231223b733a383a22657870616
e646564223b733a313a2230223b733a363a22776569676874223b733a313a2239223b733a353a226465707468223b733a313a2231223b7[...]

MySQL zwrócił komunikat: 
 #2006 - MySQL server has gone away


plz help cause I don't know what to do.
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15

Re: xampp and innodb settings problem

Postby kerios83 » 24. July 2011 13:20

Nobody ?
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15

Re: xampp and innodb settings problem

Postby smokealone » 24. July 2011 13:52

мне тозе скоро менат надо будет незнаю ишо до етого недоходил :)
ето типа снемаэт загруску с процесора ?

its my.ini work ok

Code: Select all
# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampp/mysql/data"
#innodb_log_arch_dir = "C:/xampp/mysql/data"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
smokealone
 
Posts: 5
Joined: 24. July 2011 08:04

Re: xampp and innodb settings problem

Postby kerios83 » 24. July 2011 15:21

Hi. Yea it works ok ! But I need to change those values to higher (cause I can't import my database - see above error), and when i change it - even for a small amount it wont work :(

For example if I change innodb_buffer_pool_size = 16M to innodb_buffer_pool_size = 32M mysql wont start... I don't know what to do...

Greetings from Poland!
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15

Re: xampp and innodb settings problem

Postby smokealone » 24. July 2011 15:36

i dont know but i set 160m is work any way :D





kerios83 wrote:Hi. Yea it works ok ! But I need to change those values to higher (cause I can't import my database - see above error), and when i change it - even for a small amount it wont work :(

For example if I change innodb_buffer_pool_size = 16M to innodb_buffer_pool_size = 32M mysql wont start... I don't know what to do...

Greetings from Poland!
smokealone
 
Posts: 5
Joined: 24. July 2011 08:04

Re: xampp and innodb settings problem

Postby kerios83 » 24. July 2011 17:16

I have reinstall xampp - same think, I can't change any innodb setting... Is there is something more to change so I can do that ?

this error #2006 - MySQL server has gone away - I have double all my php.ini values:

default_socket_timeout = 120
max_input_time = 120
max_execution_time = 60
-upload_max_filesize
-memory_limit
-post_max_size

etc.


and I have doubled all start setting (not related to innodb) in my.ini file

Code: Select all
# The MySQL server
[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error="mysql_error.log"


Comon it's only 16MB database - WTF is going on ?:P
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15

Re: xampp and innodb settings problem

Postby kerios83 » 24. July 2011 18:14

I'm waiting for an idea. Should I try reintall xampp again ?
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15

Re: xampp and innodb settings problem

Postby JonB » 25. July 2011 02:11

if you actually want to 'import' your database (not insert records into one) - why not use the mysql.exe CLI OR MySQL Workbench???

:shock:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: xampp and innodb settings problem

Postby kerios83 » 06. August 2011 16:58

ok, after many many tries, i have manage it to work. I did reintall my system and xampp and it start working as it should ! THX for ideas !
kerios83
 
Posts: 7
Joined: 17. August 2009 01:15


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 147 guests