This article describes how to resolve a problem that may occur when you try to run MySQL server with a limited amount of memory.
When you try to run MySQL server, it either runs out of memory or does not start at all.
You can resolve this problem by reducing the amount of memory that MySQL uses. To do this, modify the my.cnf configuration file and restart the MySQL server as follows:
set-variable = max_allowed_packet=1M set-variable = thread_stack=64K set-variable = table_cache=4 set-variable = sort_buffer=64K set-variable = net_buffer_length=2K set-variable = key_buffer_size=2095104 skip-innodb skip-networking skip-bdb skip-ndbcluster
Restart MySQL server. To do this, type the appropriate command for your Linux distribution:
service mysqld restart
For Debian and Ubuntu, type:
service mysql restart
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.