When I edit my.cnf in MySQL 5.0 in filemanager and add the following settings, I get logged out automatically from Kloxo and when I remove these line and restart server everything is ok then:
innodb_buffer_pool_size = 50M
innodb_log_file_size = 15M
but when I add the following line and restart I have no problem and this setting has been set:
bulk_insert_buffer_size=25M
Why is this happening?
P.S.:
I should note that Horde_groupware database have innoDB tables, when everything is messed up and I SELECT * FROM Horde_groupware.tblname
I get the error says bad information in .frm file.
Best Answer
The next time you start mysql successfully, please run these
This will show you the size of the InnoDB Log Files. The names of those files are (by default)
In order to change the size of the InnoDB Log Files, you must
innodb_log_file_size = 15M
to my.cnfservice mysql stop
rm -f /var/lib/mysql/ib_logfile*
service mysql start
(InnoDB Log Files Get Recreated)I wrote about this before : How to safely change MySQL innodb variable 'innodb_log_file_size'?
This will recreate the InnoDB Log Files.
With regard to
If
Horde_groupware.tblname
is an InnoDB table and you get this error, run this:You should see all the supported storage engines for the mysql instance. With the erro you are see on that table, there is one of three possiblilities: