var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
MySQL getting started and stopped all the time (by Innodb ?)
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
Any ideas ?
>A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
That would probably indicate that it's being done by a cron, have you checked there aren't any crons running?
█ Dan Kitchen | Technical Director | Razorblue
█ ddi: (+44) (0)1748 900 680 | e: [email protected]
█ UK Intensive Managed Hosting, Clusters and Colocation.
█ HP Servers, Cisco/Juniper Powered BGP Network (AS15692).
Bingo...cron is causing the issue. But I really wonder why because none of the lines in /etc/crontab could trigger the issue... Maybe one of my customer's cronjob.
With cron being on the issue occurs pretty much exactly every 20 seconds.
Ah damn... I know what it is ! I had set up a MySQL database that a perl script would query for monitoring reasons. Then I forgot about it and a few days ago I found that database and wondered what it was so I deleted it because I thought I didn't need it. Now my monitoring script would restart MySQL every 20 seconds... LOL !