MySQL load

Report bugs and workarounds
Post Reply
BliXem
Posts: 80
Joined: 27 Mar 2017 19:17

MySQL load

Post by BliXem »

Hello,

My mYSQL load is after some time around 100%. When I want to restart mysqld:

[root@mailscanner ~]# service mysqld restart
Shutting down MySQL...........Could not use Custom Function code MailScanner::CustomConfig::InitMailWatchLogging, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBI connect('database=mailscanner;host=localhost','mailwatch',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/share/MailScanner/perl/custom/MailWatch.pm line 97
) at /usr/share/MailScanner/perl/MailScanner/Config.pm line 1053
Could not use Custom Function code MailScanner::CustomConfig::InitSQLWhitelist, it could not be "eval"ed. Make sure the module is correct with perl -wc (Error: DBI connect('database=mailscanner;host=localhost','mailwatch',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /usr/share/MailScanner/perl/custom/MailWatch.pm line 97
) at /usr/share/MailScanner/perl/MailScanner/Config.pm line 1053

SUCCESS!
Starting MySQL.170423 12:11:19 mysqld_safe Logging to '/var/lib/mysql/mailscanner.err'.
170423 12:11:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
SUCCESS!
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: MySQL load

Post by pdwalker »

still a problem?

I saw that error briefly while updating from 3.0.1.8 to 3.0.1.9 but then it went away in a later stage of the process.
BliXem
Posts: 80
Joined: 27 Mar 2017 19:17

Re: MySQL load

Post by BliXem »

Every night it's 100%. Don't know what it does. Restart mysql and it's fixed and the load is low again.
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: MySQL load

Post by pdwalker »

If 'top' shows a load of 100%, and mysqld is the culprit, you'll need to find out why at the time it is happening. The best way is to use mysqladmin and see what queries are running with the following commands:

Code: Select all

mysqladmin status -uroot -p`grep ROOT /etc/EFA-Config | awk -F: '{print $2}'`
mysqladmin processlist -uroot -p`grep ROOT /etc/EFA-Config | awk -F: '{print $2}'`
Also useful is to get some information about the system

Code: Select all

uptime
iostat
vmstat
Once you have this information, you can post the results here.

Here is the results from my machine (with no load issues

Code: Select all

[root@efa ~]# mysqladmin status -uroot -p`grep ROOT /etc/EFA-Config | awk -F: '{print $2}'`
Uptime: 59515  Threads: 2  Questions: 255934  Slow queries: 0  Opens: 148  Flush tables: 1  Open tables: 129  Queries per second avg: 4.300

[root@efa ~]# mysqladmin processlist -uroot -p`grep ROOT /etc/EFA-Config | awk -F: '{print $2}'`
+------+-----------+-----------+-------------+---------+------+-------+------------------+----------+
| Id   | User      | Host      | db          | Command | Time | State | Info             | Progress |
+------+-----------+-----------+-------------+---------+------+-------+------------------+----------+
| 4181 | mailwatch | localhost | mailscanner | Sleep   | 89   |       |                  | 0.000    |
| 4493 | root      | localhost |             | Query   | 0    | init  | show processlist | 0.000    |
+------+-----------+-----------+-------------+---------+------+-------+------------------+----------+

[root@efa ~]# uptime
 12:07:16 up 16:33,  1 user,  load average: 0.11, 0.52, 0.52

[root@efa ~]# iostat
Linux 2.6.32-696.1.1.el6.x86_64 (efa.example.com) 	04/25/2017 	_x86_64_	(4 CPU)

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           1.55    1.19    0.33    2.32    0.00   94.61

Device:            tps   Blk_read/s   Blk_wrtn/s   Blk_read   Blk_wrtn
sda              14.91        68.10       531.76    4058318   31690642
dm-0              1.70        15.77         7.73     939708     460464
dm-1              3.97         0.03        31.75       2018    1891864
dm-2             62.30        51.86       492.29    3090418   29338304

[root@efa ~]# vmstat
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id wa st
 0  0      0 2798260 269456 2731024    0    0     9    67   84   59  3  0 95  2  0
Post Reply