MySQL Forums
Forum List  »  Knowledge Base

Mysql suddendly very slow
Posted by: Peter Fedeux
Date: November 13, 2009 02:35AM

Site just died yesterday and started taking forever to complete the simplest queries, mostly slow when doing mysql update, removed loads of indexes from 1 table which uses a few for a stats page

And in error log i get this
"091113 04:45:56 mysqld ended

091113 04:45:57 mysqld started
091113 4:45:57 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091113 4:45:57 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
/usr/libexec/mysqld: File '/var/log/mysql/slow_queries.log' not found (Errcode: 2)
091113 4:45:57 [ERROR] Could not use /var/log/mysql/slow_queries.log for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091113 4:45:57 InnoDB: Started; log sequence number 2 952290533
091113 4:45:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
091113 4:51:07 [Note] /usr/libexec/mysqld: Normal shutdown

091113 4:51:07 InnoDB: Starting shutdown...
091113 4:52:09 InnoDB: Shutdown completed; log sequence number 2 1294714176
091113 4:52:09 [Note] /usr/libexec/mysqld: Shutdown complete

091113 04:52:09 mysqld ended

091113 04:56:03 mysqld started
091113 4:56:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091113 4:56:03 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
/usr/libexec/mysqld: File '/var/log/mysql/slow_queries.log' not found (Errcode: 2)
091113 4:56:03 [ERROR] Could not use /var/log/mysql/slow_queries.log for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091113 4:56:03 InnoDB: Started; log sequence number 2 1294714176
091113 4:56:03 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
091113 9:18:27 [Note] /usr/libexec/mysqld: Normal shutdown

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 732 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 731 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 729 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 728 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 727 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 725 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 723 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 722 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 721 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 720 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 718 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 717 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 714 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 712 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 711 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 708 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 705 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 696 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 693 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 692 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 691 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 689 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 688 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 687 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 686 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 680 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 679 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 674 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 670 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 666 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 564 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 431 user: 'root'

091113 9:18:29 [Warning] /usr/libexec/mysqld: Forcing close of thread 120 user: 'root'

091113 9:18:32 InnoDB: Starting shutdown...
091113 9:18:33 InnoDB: Shutdown completed; log sequence number 2 1295163982
091113 9:18:33 [Note] /usr/libexec/mysqld: Shutdown complete

091113 09:18:33 mysqld ended

091113 09:18:34 mysqld started
091113 9:18:34 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091113 9:18:34 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
/usr/libexec/mysqld: File '/var/log/mysql/slow_queries.log' not found (Errcode: 2)
091113 9:18:34 [ERROR] Could not use /var/log/mysql/slow_queries.log for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091113 9:18:34 InnoDB: Started; log sequence number 2 1295163982
091113 9:18:34 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
091113 9:26:35 [Note] /usr/libexec/mysqld: Normal shutdown

091113 9:26:36 [ERROR] /usr/libexec/mysqld: Sort aborted
091113 9:26:37 InnoDB: Starting shutdown...
091113 9:26:39 InnoDB: Shutdown completed; log sequence number 2 1305712595
091113 9:26:39 [Note] /usr/libexec/mysqld: Shutdown complete

091113 09:26:39 mysqld ended

091113 09:26:39 mysqld started
091113 9:26:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091113 9:26:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
/usr/libexec/mysqld: File '/var/log/mysql/slow_queries.log' not found (Errcode: 2)
091113 9:26:39 [ERROR] Could not use /var/log/mysql/slow_queries.log for logging (error 2). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it.
091113 9:26:40 InnoDB: Started; log sequence number 2 1305712595
091113 9:26:40 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
"


If i restart mysql it loads normally for about 2 minutes then goes very slow again, nothing has been changed, no new pages or code has been added

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql suddendly very slow
4601
November 13, 2009 02:35AM
2038
November 13, 2009 03:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.