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!
MySQL load
Re: MySQL load
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.
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.
Re: MySQL load
Every night it's 100%. Don't know what it does. Restart mysql and it's fixed and the load is low again.
Re: MySQL load
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:
Also useful is to get some information about the system
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
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}'`
Code: Select all
uptime
iostat
vmstat
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