mysql insert query not responding

Question

i try to insert data to mysql with php code or phpmyadmin but the server waiting for a long and finally prints "not responding error". i can add value to db with logging in mysql using ssh connection. PHP Version 5.1.6 Mysql Client API version 5.0.77

i see error in the log Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution this error i see in the log

Answer 1

Have you checked the MySQL error logs?

If you set the log warnings level above 1 aborted connections are written to the error log (as per http://dev.mysql.com/doc/refman/5.1/en/error-log.html)

As such, this is probably a good first port of call.