please check my.cnf

Portal Home > Knowledgebase > Articles Database > please check my.cnf

Posted by gillboss, 04-19-2010, 06:36 AM
my server get over load when many user online at my sites there are alot of mysql connection and mysql table are optimized already such as indexes etc and could some one check mysql my.cnf is ok or not please ? i have 3 gb ram here is server information Processor #2 Vendor: GenuineIntel Processor #2 Name: Intel(R) Core(TM)2 Duo CPU E6550 @ 2.33GHz Processor #2 speed: 2333.000 MHz Processor #2 cache size: 4096 KB Current Memory Usage total used free shared buffers cached Mem: 3105756 2675028 430728 0 469272 1630536 -/+ buffers/cache: 575220 2530536 Swap: 4192924 0 4192924 Total: 7298680 2675028 4623652 PHP Version 5.2.9 here is my.cnf on whm its show like this attached image and some time its goes up like 80 cpu % Attached Thumbnails Last edited by gillboss; 04-19-2010 at 06:44 AM.
Posted by gillboss, 04-19-2010, 07:10 AM
here is more information Load Averages: 3.77 3.24 2.83 mysqladmin status Uptime: 92206 Threads: 1 Questions: 55481684 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.714 root@server [~]# mysqladmin status Uptime: 92216 Threads: 2 Questions: 55482596 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.659 root@server [~]# mysqladmin status Uptime: 92227 Threads: 9 Questions: 55491587 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.684 root@server [~]# mysqladmin status Uptime: 92239 Threads: 5 Questions: 55501658 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.715 root@server [~]# mysqladmin status Uptime: 92241 Threads: 3 Questions: 55501860 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.704 root@server [~]# mysqladmin status mysqladmin statusUptime: 92252 Threads: 3 Questions: 55505467 Slow queries: 1 Opens: 1071 Flush tables: 1 Open tables: 817 Queries per second avg: 601.672
Posted by madaboutlinux, 04-19-2010, 08:19 AM
You can check the mysql queries that is been accessed the most when the server load average is high Also execute the 'top' command at the same time and forward us the output. Do your website becomes inaccessible/slow when such a problem occurs OR is it just that the server load average that is worrying you? And btw, what is the constant server load average?
Posted by net, 04-19-2010, 08:35 AM
Moved > Hosting Security and Technology .
Posted by ksv2nash, 04-19-2010, 08:53 AM
Hello, It is your whm server?
Posted by gillboss, 04-19-2010, 10:24 AM
yes i have whm server with CENTOS 5.4

Add to Favourites Print this Article