Hot answers tagged


In 1GB of RAM, you may be able to set innodb_buffer_pool_size to 50M, maybe 100M. But definitely not 800M. The 80% advice is predicated on having at least 4GB of RAM, and 80% is too high even for that. Having other things on the same machine (Apache?) adds to the cramped quarters. If you have Apache, lower MaxClients to 10. Other things to keep out of ...

Only top voted, non community-wiki answers of a minimum length are eligible