store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Wed Aug 21, 2019 4:16 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: CPU and Memory Usage: Less usage settings for my.conf
Unread postPosted: Sat Feb 13, 2016 11:13 pm 
Offline
New Forum User
New Forum User

Joined: Sat Feb 13, 2016 10:45 pm
Posts: 4
Location: Brazil
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


Top
 Profile  
Reply with quote  
 Post subject: Re: CPU and Memory Usage: Less usage settings for my.conf
Unread postPosted: Tue Feb 16, 2016 4:44 am 
Offline
Forum Regular
Forum Regular

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


Top
 Profile  
Reply with quote  
 Post subject: Re: CPU and Memory Usage: Less usage settings for my.conf
Unread postPosted: Tue Feb 16, 2016 10:00 pm 
Offline
Long Time Forum Regular
Long Time Forum Regular

Joined: Thu Dec 09, 2004 11:19 am
Posts: 2321
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>


Top
 Profile  
Reply with quote  
 Post subject: Re: CPU and Memory Usage: Less usage settings for my.conf
Unread postPosted: Thu Feb 18, 2016 2:53 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
User avatar

Joined: Thu Feb 07, 2008 7:49 pm
Posts: 4082
Location: Chantilly, VA
Quote:
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.

_________________
Michael Shinn
Atomicorp - Security For Everyone


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group