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!