Sagewire Logo

innodb_log_file_size variable makes the server crash

2 Message(s) by 2 Author(s) originally posted in mysql discussion


From: ctobini Date:   Wednesday, October 24, 2007
Hello,

I have a problem when setting the innodb_log_file _size variable in
my.cnf (MySQL 5.0 with Ubuntu 7.04, 2GB RAM).

When I start MySQL I have a 'failed' error status.

Here is the InnoDB variables I fixed in the conf file :

innodb_data_file_path = ibdata1:1000M:autoextend
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M

I commented line by line the InnoDB variables, only
innodb_log_file_size makes the server crash at startup.

Could you see what the problem could be ?

Thanks,

C. Tobini


From: lark Date:   Thursday, October 25, 2007
wrote in message:
Hello,
I have a problem when setting the innodb_log_file_size variable in
my.cnf (MySQL 5.0 with Ubuntu 7.04, 2GB RAM).
When I start MySQL I have a 'failed' error status.
Here is the InnoDB variables I fixed in the conf file :
innodb_data_file_path = ibdata1:1000M:autoextend
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 256M
innodb_log_buffer_size = 8M
I commented line by line the InnoDB variables, only
innodb_log_file_size makes the server crash at startup.
Could you see what the problem could be ?
Thanks,
C. Tobini



can you post the section of error log that pertains to this error?



Next Message: Help I deleted root@xxxxxxxxxxx!



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional