CPU and Memory Usage: Less usage settings for my.conf

Support/Development for MySQL, MariaDB, and other database systems
vdTOG
New Forum User
New Forum User
Posts: 4
Joined: Sat Feb 13, 2016 10:45 pm
Location: Brazil

CPU and Memory Usage: Less usage settings for my.conf

Unread post by vdTOG »

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
prupert
Forum Regular
Forum Regular
Posts: 573
Joined: Tue Aug 01, 2006 2:45 pm
Location: Netherlands

Re: CPU and Memory Usage: Less usage settings for my.conf

Unread post by prupert »

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/
Lemonbit Internet Dedicated Server Management
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Re: CPU and Memory Usage: Less usage settings for my.conf

Unread post by faris »

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.
--------------------------------
<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>
User avatar
mikeshinn
Atomicorp Staff - Site Admin
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

Unread post by mikeshinn »

tuning MySQL is really a pain, as it is always a balance between performance and memory usage.
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.
Post Reply