Re: [URGENT] Mysql crash every 2-3days
Tips on converting to InnoDB:
http://mysql.rjweb.org/doc.php/myisam2innodb
Note especially the changes to my.cnf.
You have 8GB of RAM? Are there other applications taking some of that space?
Try (in my.cnf)
key_buffer_size = 600M
innodb_buffer_pool_size = 2500M
After converting all of your tables to InnoDB, try
key_buffer_size = 20M
innodb_buffer_pool_size = 5000M
You are using version 5.5.43. Consider upgrading to 5.6.
Heed the Warnings about spelling of options in my.cnf.
Subject
Written By
Posted
Re: [URGENT] Mysql crash every 2-3days
May 24, 2016 10:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.