What settings for my.conf can help me to consume less CPU and lesse memory?
I am having problems with high cpu and high memory consumptions with mysqld.
Thank you
CPU and Memory Usage: Less usage settings for my.conf
Re: CPU and Memory Usage: Less usage settings for my.conf
That entirely depends on your hardware and work load. Unfortunately there is no silver bullet solution. Some people dedicate their entire work to achieving the optimal settings for database servers. You could start at reading the documentation carefully, and read in on stuff like the Percona blog, but in your case you might just be better off when hiring a specialist.
http://www.mysql.com/why-mysql/performance/
https://www.percona.com/blog/
https://mariadb.com/kb/en/mariadb/confi ... rformance/
http://www.mysql.com/why-mysql/performance/
https://www.percona.com/blog/
https://mariadb.com/kb/en/mariadb/confi ... rformance/
Lemonbit Internet Dedicated Server Management
Re: CPU and Memory Usage: Less usage settings for my.conf
And be careful with tools like mysqltuner!
It can get you into a lot of trouble by recommending things that will help speed things up, but at the same time will consume massive amounts of memory.
tuning MySQL is really a pain, as it is always a balance between performance and memory usage.
It can get you into a lot of trouble by recommending things that will help speed things up, but at the same time will consume massive amounts of memory.
tuning MySQL is really a pain, as it is always a balance between performance and memory usage.
--------------------------------
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
<advert>
If you want to rent a UK-based VPS that comes with friendly advice and support from a fellow ART fan, please get in touch.
</advert>
- mikeshinn
- Atomicorp Staff - Site Admin
- Posts: 4149
- Joined: Thu Feb 07, 2008 7:49 pm
- Location: Chantilly, VA
Re: CPU and Memory Usage: Less usage settings for my.conf
Very true. In general the two are mutually exclusive. You cant have low memory usage and high performance, you have to make trade offs. Memory is fast, disks are slow. So in general the more you do in memory the fast the DB will be, the less you do in memory the slower.tuning MySQL is really a pain, as it is always a balance between performance and memory usage.
Michael Shinn
Atomicorp - Security For Everyone
Atomicorp - Security For Everyone