mysql 日志如下:110222 15:25:18 [Note] Event Scheduler: Killing the scheduler thread, thread id 1 110222 15:25:18 [Note] Event Scheduler: Waiting for the scheduler thread to reply 110222 15:25:18 [Note] Event Scheduler: Stopped 110222 15:25:18 [Note] Event Scheduler: Purging the queue. 0 events 110222 15:25:20 InnoDB: Starting shutdown... 110222 15:25:20 InnoDB: Shutdown completed; log sequence number 0 275188 110222 15:25:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete110222 15:25:20 mysqld_safe mysqld from pid file /var/mysql/dataw.mic.com.pid ended 110222 15:25:30 mysqld_safe Starting mysqld daemon with databases from /var/mysql/ 110222 15:25:30 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead. 110222 15:25:30 [Warning] Although a path was specified for the --log_slow_queries option, log tables are used. To enable logging to files use the --log-output=file option. 110222 15:25:31 [Note] Plugin 'FEDERATED' is disabled. 110222 15:25:31 InnoDB: Started; log sequence number 0 275188 110222 15:25:31 [Note] Event Scheduler: Loaded 0 events 110222 15:25:31 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.1.40-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 110222 15:25:31 [Note] Event Scheduler: scheduler thread started with id 1 110222 15:26:01 mysqld_safe A mysqld process already exists 110222 15:27:01 mysqld_safe A mysqld process already exists
110222 15:25:31 [Note] Event Scheduler: scheduler thread started with id 1 110222 15:26:01 mysqld_safe A mysqld process already exists 110222 15:27:01 mysqld_safe A mysqld process already exists在31秒的时候,MYSQL服务已经很正常的启动了 后面每隔一秒产生一个提示信息,难道有计划任务在启动MYSQLD?
要启动第二个服务器,提供不同的--socket和--port选项值,并且传递一个--datadir=path选项给mysqld_safe,以便服务器使用一个不同的数据目录。mysqld_multi可以管理多个帧听不同Unix套接字文件和TCP/IP端口的连接的mysqld 进程。它可以启动或停止服务器,或报告它们的当前状态。
mysqld_multi [options] {start|stop|report}用 service mysqld restart 重启下服务器
或 mysqld_multi report 检查下配置文件
看看
110222 15:25:18 [Note] Event Scheduler: Waiting for the scheduler thread to reply
110222 15:25:18 [Note] Event Scheduler: Stopped
110222 15:25:18 [Note] Event Scheduler: Purging the queue. 0 events
110222 15:25:20 InnoDB: Starting shutdown...
110222 15:25:20 InnoDB: Shutdown completed; log sequence number 0 275188
110222 15:25:20 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete110222 15:25:20 mysqld_safe mysqld from pid file /var/mysql/dataw.mic.com.pid ended
110222 15:25:30 mysqld_safe Starting mysqld daemon with databases from /var/mysql/
110222 15:25:30 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow_query_log'/'--slow_query_log_file' instead.
110222 15:25:30 [Warning] Although a path was specified for the --log_slow_queries option, log tables are used. To enable logging to files use the --log-output=file option.
110222 15:25:31 [Note] Plugin 'FEDERATED' is disabled.
110222 15:25:31 InnoDB: Started; log sequence number 0 275188
110222 15:25:31 [Note] Event Scheduler: Loaded 0 events
110222 15:25:31 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.40-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
110222 15:25:31 [Note] Event Scheduler: scheduler thread started with id 1
110222 15:26:01 mysqld_safe A mysqld process already exists
110222 15:27:01 mysqld_safe A mysqld process already exists
110222 15:26:01 mysqld_safe A mysqld process already exists
110222 15:27:01 mysqld_safe A mysqld process already exists在31秒的时候,MYSQL服务已经很正常的启动了
后面每隔一秒产生一个提示信息,难道有计划任务在启动MYSQLD?
2 看来允许(除了root和mysql这两个用户之外的)任何人运行mysqld是个杯具,linux unix却没什么好办法解决。