สอบถาม error >> [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted

[invisible_deaw]

มันขึ้น error อันนี้รัวๆเลยครับ ไม่รู้เป็นที่สาเหตุอะไร >>> [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted

[host4thai.com]

ช่วย post log ทั้งหมดได้ไหมครับ

[invisible_deaw]

130831 10:20:57 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:21:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:21:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:21:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:22:43 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:22:44 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:22:44 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:22:44 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:23:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:29:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:31:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:31:31 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:31:31 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:33:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:33:30 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:33:30 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:33:51 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:33:51 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:37:51 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:45:10 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:45:11 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:45:11 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:45:11 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:45:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:46:56 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:46:56 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:46:56 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:48:48 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:50:30 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:51:29 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:53:27 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:53:28 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:53:28 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:53:28 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted
130831 10:54:37 [ERROR] /usr/local/mysql/libexec/mysqld: Sort aborted

[host4thai.com]

รบกวนหาบรรทัด ก่อนหน้าข้อความว่า Sort aborted หน่อยครับ
ที่ส่งมายังไม่เห็นต้นเหตุปัญหา

[dotAtainer]

ยกมาทั้งไฟล์เลยครับ

[invisible_deaw]

คือผมติดปัญหาคือ จะเจอ error นี้ทุกเสาเลยครับ
ไฟร์ .err ตามเเนบครับ

[pop_hosxp]

ใช้ MySQL 5.1.42 น่าจะ upgrade เป็น 5.5.3x หรือไม่ก็ลงใหม่ แล้วใช้ BMSxTraBackup ช่วย config my.cnf ให้ครับ

[dotAtainer]

สั่ง cat  /etc/my.cnf  |  grep  log_slow_queries มาดูหน่อยครับ