I am following this solution here http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#comment14041132_4056261 and tried to increase my
innodb_buffer_pool_size to 4G and later 1G (also 1024M) in addition to the log file size, but mysql wont start with those values.
If I put it back to 512M mysql starts fine.
How can I solve this? My server is a 16GB one, and according to Webmin sysinfo:
Real memory 15.62 GB total, 3.13 GB used
Meanwhile I found the error log as well:
120529 10:29:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120529 10:29:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120529 10:29:33 [Note] Plugin 'FEDERATED' is disabled.
120529 10:29:33 InnoDB: The InnoDB memory heap is disabled
120529 10:29:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120529 10:29:33 InnoDB: Compressed tables use zlib 1.2.3
120529 10:29:33 InnoDB: Using Linux native AIO
120529 10:29:33 InnoDB: Initializing buffer pool, size = 1.0G
120529 10:29:33 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 134217728 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!