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.