我有我的MySQL服务器的错误信息。 具有8 GB内存的Linux。
/usr/sbin/mysqld: Sort aborted /usr/sbin/mysqld: Sort aborted /usr/sbin/mysqld: Sort aborted 我有InnoDB数据库，这里是我的my.cnfconfiguration。
[mysqld] #basedir = /var/lib datadir = /CMS/database/editorial/primary port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking skip-name-resolve key_buffer = 512M max_allowed_packet = 8M table_cache = 256 sort_buffer_size = 256M read_buffer_size = 256M read_rnd_buffer_size = 256M myisam_sort_buffer_size = 256M thread_cache_size =16 query_cache_size= 512M max_connections=1000 join_buffer_size=256M lower_case_table_names = 1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_data_home_dir = /CMS/database/editorial/primary/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /CMS/database/editorial/logs/ innodb_log_arch_dir = /CMS/database/editorial/log-archive/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 2048M innodb_additional_mem_pool_size = 256M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 #lower_case_table_names = 0
我经常看到mysqld崩溃时Sort aborted消息。 如果mysqld仍在运行，可能是由mysqld_safe重新启动。 它也可能是由于手动重新启动mysql。
你应该看看下面这些行，看看MySQL是否重新启动了短语'准备好连接'
Sort aborted消息也可能是由于正在忙于执行SQL查询的数据库连接的大量查杀而导致的。