Memory Reduction
There are a lot of things you can do to save memory, but you can easily cut your memory usage in half by adjusting mysqld to reasonable settings. If you don’t do that your server performance will really suffer, and you’ll have difficulty with some tasks that require a lot of resources (like some updates might). You can expect mysqld to consume about 280 mb of memory as delivered, but you can easily lower that figure to 60-80 mb while still making ample database resources available to your subscribers.
To lower mysql memory usage login to webmin. Click the Others icon at the top of webmin and then click the File Manager icon. Open the /etc directory and click once on the my.conf file to select it. Click the edit key. Paste the following entry immediately below [mysqld], which should be at the top of the file.
skip-innodb
Save & close. Apply changes by restarting mysqld.
# service mysqld restart
Your entire server should now be running at around 200 mb of memory.
To lower mysql memory usage login to webmin. Click the Others icon at the top of webmin and then click the File Manager icon. Open the /etc directory and click once on the my.conf file to select it. Click the edit key. Paste the following entry immediately below [mysqld], which should be at the top of the file.
skip-innodb
Save & close. Apply changes by restarting mysqld.
# service mysqld restart
Your entire server should now be running at around 200 mb of memory.
No comments:
Post a Comment