似乎是在服务器负担较重,例如复制大文件(超过2G)时,我的mysql就无故重启。有人能告诉我怎么回事,或者怎么避免吗?
错误日志如下:080805 09:56:04 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 9:56:04 [Note] Plugin 'InnoDB' disabled by command line option
080805 9:56:05 [Note] Event Scheduler: Loaded 0 events
080805 9:56:05 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
080805 10:04:03 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080805 10:04:03 [Note] Event Scheduler: Purging the queue. 0 events
080805 10:04:06 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080805 10:04:06 mysqld_safe mysqld from pid file /file/mysql/www.eceel.com.pid ended
080805 10:04:07 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 10:04:07 [Note] Plugin 'InnoDB' disabled by command line option
080805 10:04:08 [Note] Event Scheduler: Loaded 0 events
080805 10:04:08 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
080805 10:12:35 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080805 10:12:35 [Note] Event Scheduler: Purging the queue. 0 events
080805 10:12:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080805 10:12:35 mysqld_safe mysqld from pid file /file/mysql/www.eceel.com.pid ended
080805 10:12:36 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 10:12:36 [Note] Plugin 'InnoDB' disabled by command line option
080805 10:12:37 [Note] Event Scheduler: Loaded 0 events
080805 10:12:37 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
错误日志如下:080805 09:56:04 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 9:56:04 [Note] Plugin 'InnoDB' disabled by command line option
080805 9:56:05 [Note] Event Scheduler: Loaded 0 events
080805 9:56:05 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
080805 10:04:03 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080805 10:04:03 [Note] Event Scheduler: Purging the queue. 0 events
080805 10:04:06 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080805 10:04:06 mysqld_safe mysqld from pid file /file/mysql/www.eceel.com.pid ended
080805 10:04:07 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 10:04:07 [Note] Plugin 'InnoDB' disabled by command line option
080805 10:04:08 [Note] Event Scheduler: Loaded 0 events
080805 10:04:08 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
080805 10:12:35 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown080805 10:12:35 [Note] Event Scheduler: Purging the queue. 0 events
080805 10:12:35 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete080805 10:12:35 mysqld_safe mysqld from pid file /file/mysql/www.eceel.com.pid ended
080805 10:12:36 mysqld_safe Starting mysqld daemon with databases from /file/mysql
080805 10:12:36 [Note] Plugin 'InnoDB' disabled by command line option
080805 10:12:37 [Note] Event Scheduler: Loaded 0 events
080805 10:12:37 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
http://topic.csdn.net/u/20080725/14/98c55d11-9675-47ac-b584-50ac429c0ae1.html
帮我试试看,在linux机器上复制10G这么大的一个文件 另外,我mysql数据库是很庞大的,好几个数据文件超过了4G。但数据库负担一般不重:很少有复杂的语句,一般的操作都只针对一条数据。show processlist往往都是空闲的。
Linux www.eceel.com 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:08:39 EDT 2005 i686 i686 i386 GNU/Linuxmysql
Version: '5.1.22-rc' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
所以最好的办法就是构建M-S,然后在S上进行操作!