Heavy Load but very few connections

maverick23

• January 09, 2016 12:32

Hello Everyone! I needed help to optimise my server. i have only 15 wordpress sites on my server but the traffic on these sites is pretty high. I am currently using the server with below configuration:- Dual processor E5-2620, 32 GB RAM and SSD drives. the concurrent users are not more than 100 (i have implemented the limit on the apache connections). But i still see that my server load doesn't go below 8 or 9. When i run top command i see most of the resources are consumed by MYSQL and there are multiple processes running for apache. Is there a way that i can control the resources consumed by mysql? Thanks Rajat

• 

  24x7server

  • January 10, 2016 11:37

  Hello :), I will suggest you please try to optimize your mysql with the mysql tuner scripts and monitor your server performance for some time. You can check live mysql process through following command.
  mysqladmin proc
  

  0
• 

  maverick23

  • January 10, 2016 11:43

  i tried doing it but this doesn't show me more than 4-5 queries running at any given point in time. example:- | 312681 | leechprotect | localhost | leechprotect | Sleep | 1542 | | | | 321301 | xxxxxxxxxxxxxx | localhost | xxxxxxxxxxxxxx | Sleep | 0 | | | | 321302 | xxxxxxxxxxxxxx | localhost | xxxxxxxxxxxxxx | Sleep | 1 | | | | 321303 | xxxxxxxxxxxxxx | localhost | xxxxxxxxxxxxxx | Query | 0 | Sending data | SELECT post_id, meta_key, meta_value FROM xxxxxxxxxxxxxx WHERE post_id IN (13068) ORDER BY meta_id A | | 321304 | xxxxxxxxxxxx | localhost | xxxxxxxxxxx | Sleep | 0 | | | | 321305 | xxxxxxxxxxxx | localhost | xxxxxxxxxxxxxx | Sleep | 0 | | | | 321306 | root | localhost | | Query | 0 | | show processlist

  0
• 

  Infopro

  • January 10, 2016 13:57

  You should find this thread of some use: Troubleshooting high server loads on Linux servers

  0
• 

  maverick23

  • January 10, 2016 15:17

  Thank you, link is very helpful. i see that memory consumed for my server is also ways very high.. 1 minute load avg: 4 Swap used: 66520 kB Mem used: 30114264 kB packets received (2 secs): 43015 packets sent (2 secs): 531419

  0
• 

  cPanelMichael

  • January 11, 2016 17:37

  i see that memory consumed for my server is also ways very high..

  
  Hello :) Were any of the troubleshooting steps in the thread you were linked to helpful in determining the cause of the memory usage? Thank you.

  0
• 

  maverick23

  • January 11, 2016 18:13

  Hi Michael, Thank you for checking up. I see that even after all the optimisation with mysqltuner and other things my DB load still high. the script that was there shows be below results :- [L: 2] [P: 516] [Swap Use: 00% ] [pps in: 46397 pps out: 1364273] [L: 3] [P: 534] [Swap Use: 00% ] [pps in: 38741 pps out: 306077] [L: 2] [P: 513] [Swap Use: 00% ] [pps in: 68804 pps out: 1941925] is there anything else i can do? Thanks Rajat

  0
• 

  cPanelMichael

  • January 11, 2016 23:30

  things my DB load still high.

  
  How high is the load, and have you attempted to determined which database is at fault through the use of the "mysqladmin processlist" command again since the recent optimizations? Thank you.

  0

Please sign in to leave a comment.