Am 20.12.2013 um 20:28 schrieb Reindl Harald: ... But I found in the syslog since yesterday noon every 2 minutes (!!!) these entries:
Dec 19 12:02:12 myserver kernel: [1315576.363594] init: mysql main process (9025) terminated with status 1 Dec 19 12:02:12 myserver kernel: [1315576.363659] init: mysql main process ended, respawning Dec 19 12:02:12 myserver /etc/mysql/debian-start[10200]: Upgrading MySQL tables if necessary. Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: Looking for 'mysql' as: /usr/bin/mysql Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Dec 19 12:02:12 myserver /etc/mysql/debian-start[10203]: This installation of MySQL is already upgraded to 5.5.34-MariaDB, use --force if you still need to run mysql_upgrade Dec 19 12:02:12 myserver /etc/mysql/debian-start[10214]: Checking for insecure root accounts. Dec 19 12:02:12 myserver /etc/mysql/debian-start[10219]: Triggering myisam-recover for all MyISAM tables
(I replaced my server's name with myserver)
Do I understand this right, that every 2 minutes mysql server is crashing (terminated with status 1)??? I don't find a hint in the syslog what could crash mysql.
And to restart mysql (service mysql restart) it takes about a minute! This seems unnormal too. I think I have a problem.
Oh my god! I my trouble I just restarted the server (I know this "trick" from Windows OS) and look here! Now it is working!!!
No more errors when I questionize the EVENT table in information_schema, no more error entries like above in syslog.
Heurekah!
Uff.
Thanks for the helps.
franks