Ubuntu上的MySQL每30秒重生一次

由于我不知道在另外一个问题中提出问题是否恰当，所以我打开了一个新问题 – 我可能遇到同样的问题： mysql服务器每30秒重新启动一次

但是：我的MaSQL没有loggingconfiguration错误（事实上，我在configuration中弄坏了某些东西，因为他没有logging，但他启动了（我可以连接/使用它），但服务器变得非常慢，过了一段时间，他没有回应，必须重新设置。

有人可以帮我检查configuration文件吗？ 我会把它放在下面 – 好的知道：这是一个多实例设置。 至less情况2有这个问题

这是一个Ubuntu 10.10，MySQL 5.1。 我的系统日志看起来像这样：

• MySQL无法连接
• MySQL备份不覆盖新行
• 服务器内存不足 – 如何诊断（vim error_log？）
• 如何确认（在线）RHEL 5.6当前支持的MySQL版本？
• 如何在“使用dbname;”中使用“-A”

Jan 16 10:03:06 testing2 init: mysql main process (22245) terminated with status 1 Jan 16 10:03:06 testing2 init: mysql main process ended, respawning Jan 16 10:03:37 testing2 init: mysql post-start process (22246) terminated with status 1 Jan 16 10:03:37 testing2 init: mysql main process (22314) terminated with status 1 Jan 16 10:03:37 testing2 init: mysql main process ended, respawning Jan 16 10:04:07 testing2 init: mysql post-start process (22315) terminated with status 1 Jan 16 10:04:08 testing2 init: mysql main process (22383) terminated with status 1 Jan 16 10:04:08 testing2 init: mysql main process ended, respawning Jan 16 10:04:38 testing2 init: mysql post-start process (22384) terminated with status 1 Jan 16 10:04:39 testing2 init: mysql main process (22452) terminated with status 1 Jan 16 10:04:39 testing2 init: mysql main process ended, respawning Jan 16 10:05:01 testing2 CRON[22519]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1) Jan 16 10:05:09 testing2 init: mysql post-start process (22453) terminated with status 1 Jan 16 10:05:09 testing2 init: mysql main process (22540) terminated with status 1 Jan 16 10:05:09 testing2 init: mysql main process ended, respawning 

CONF：

 [mysqld_multi] mysqld = /usr/sbin/mysqld mysqladmin = /usr/bin/mysqladmin user = debian-sys-maint password = iYOO9xwrplvgTG5D [mysqld1] user = mysql pid-file = /export/dat/mysql/mysqld1/mysqld.pid socket = /export/dat/mysql/mysqld1/mysqld.sock port = 3307 basedir = /usr datadir = /export/dat/mysql/mysqld1/data #tmpdir = /tmp/mysqld1 tmpdir = /export1/mysqltmp/mysqld1 language = /usr/share/mysql/english log = /var/log/mysql/mysql1.log log-error = /var/log/mysql/mysql1.error skip-external-locking key_buffer = 16M max_allowed_packet = 64M thread_stack = 128K thread_cache_size = 8 query_cache_limit = 1M query_cache_size = 256M expire_logs_days = 10 max_binlog_size = 100M character_set_server =utf8 default-character-set =utf8 innodb_buffer_pool_size =700M innodb_additional_mem_pool_size=10M innodb_log_file_size =100M innodb_log_buffer_size =4M innodb_flush_log_at_trx_commit=0 innodb_data_home_dir =/export/dat/mysql/mysqld1/innodbfiles innodb_file_per_table lower_case_table_names=1 table_cache=512 tmp_table_size=18M innodb_flush_log_at_trx_commit=0 innodb_thread_concurrency=8 # Log slow queries, time threshold set by 'long_query_time', #log_slow_queries = /var/log/mysql_query.log #log_output = FILE # 5.1 only #long_query_time = 5 ignore_builtin_innodb plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 [mysqld2] user = mysql pid-file = /export/dat/mysql/mysqld2/mysqld.pid socket = /export/dat/mysql/mysqld2/mysqld.sock port = 3306 basedir = /usr datadir = /export/dat/mysql/mysqld2/data #tmpdir = /tmp/mysqld2 tmpdir = /export1/mysqltmp/mysqld2 language = /usr/share/mysql/english log = /var/log/mysql/mysql2.log log-error = /var/log/mysql/mysql2.error skip-external-locking key_buffer = 16M max_allowed_packet = 64M thread_stack = 128K thread_cache_size = 8 query_cache_limit = 1M query_cache_size = 256M expire_logs_days = 10 max_binlog_size = 100M character_set_server =utf8 default-character-set =utf8 innodb_buffer_pool_size =700M innodb_additional_mem_pool_size=10M innodb_log_file_size =100M innodb_log_buffer_size =4M innodb_flush_log_at_trx_commit=0 loose_innodb_data_home_dir =/export/dat/mysql/mysqld2/innodbfiles #innodb_file_per_table lower_case_table_names=1 table_cache=512 tmp_table_size=18M innodb_flush_log_at_trx_commit=0 innodb_thread_concurrency=8 # Log slow queries, time threshold set by 'long_query_time', #log_slow_queries = /var/log/mysql_query.log #log_output = FILE # 5.1 only #long_query_time = 3 ignore_builtin_innodb plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 

谢谢

 service mysql stop update-rc.d -f mysql remove