Need Help - Troubleshoot Connection Problems

[Jay Friedman]

I'm a real novice at this and really need help. MySQL started causing problems on a VPS but I've made not changes. The server has been operating normally for a few years. MySQL shows it is running but my applications (Plesk, Drupal) can't connect. The only thing I see in the mysql.log file is:

150830 11:05:59InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (877 search iterations)! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possible that in your Unix version
InnoDB: fsync is very slow, or completely frozen inside
InnoDB: the OS kernel. Then upgrading to a newer version
InnoDB: of your operating system may help. Look at the
InnoDB: number of fsyncs in diagnostic info below.
InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0
InnoDB: 363 OS file reads, 67 OS file writes, 14 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.

The my.cnf is as follows:

[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=100M
innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2

(Based on information I found on the web, I increased the indoor_log_buffer_size from 500K to 100M but that has had no effect.)


Any help is appreciated!