Slow server (MySQL / IOPs)

I have a VPS with 6x3,2GHz and 16GB RAM.

It was responding slow, so I decided to do a reboot. The reboot took a lot of time, but finally it worked.

Right now it's responding extremely slow. Server load is 25; the primary consumer is probably MySQL, top:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1877 mysql 20 0 8755m 1.1g 5732 S 2.7 6.8 2:23.33 mysqld

although I guess that heavy IOPs is the main cause:

Trans./Sec 35.15
Blocks Read/sec 1289.24
Blocks Written/Sec 393.83
Total Blocks Read 2005588
Total Blocks Written 612648

executing tuning-primer.sh freezes (or seems to freeze, it's been there for quite some minutes) at INNODB status.

I haven't changed the my.cnf file in months, but here it is:

Code:

[myisamchk]
read_buffer=32M
write_buffer=32M
key_buffer=128M
sort_buffer=128M

[mysqld]
table_definition_cache=1600
query_cache_type=1
read_buffer_size=16M
join_buffer_size=3M
max_user_connections=300
low_priority_updates=1
thread_cache_size=512
tmp_table_size=256M
query_cache_size=64M
sort_buffer_size=8M
max_heap_table_size=256M
innodb_log_buffer_size=4M
innodb_file_per_table=1
open_files_limit=12010
key_buffer=2048M
table_cache=3072
query_cache_limit=3M
concurrent_insert=2
myisam_sort_buffer_size=512M
max_allowed_packet=268435456
max_connections=300
innodb_buffer_pool_size=3G

[isamchk]
read_buffer=32M
write_buffer=32M
key_buffer=128M
sort_buffer=128M

Anyone can help please?

 

Thank you for your reply. I already tried to run tuning-primer.sh again, but it hangs again on INNODB status. I'm going to contact my provider now.

 

Right now my server load is 16, being the top user mysql (command: mysqld). mysqladmin processlist says:
+---------+--------------+-----------+--------------+----------------+------+--------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+--------------+-----------+--------------+----------------+------+--------------------+------------------+
| 121 | DELAYED | localhost | eximstats | Delayed insert | 1 | Waiting for INSERT | |
| 419267 | eximstats | localhost | eximstats | Sleep | 1 | | |
| 1144633 | leechprotect | localhost | leechprotect | Sleep | 4694 | | |
| 1205799 | DELAYED | localhost | eximstats | Delayed insert | 215 | Waiting for INSERT | |
| 1209751 | root | localhost | | Query | 0 | | show processlist |
+---------+--------------+-----------+--------------+----------------+------+--------------------+------------------+

- - - Updated - - -

Right now, Load Averages: 10.83 12.12 14.69

top:
1877 mysql 20 0 8990m 2.4g 6360 S 10.6 15.3 156:55.97 mysqld
.. and a three PHP processes that use much less CPU
.. and a lot of stuff that uses 0.0

 

The issue has been solved by moving the VPS to another server. Load at peak is < 0.5 so everything is great again. The server is not identical (6x3,4GHz instead of 6x3,2GHz), but I suppose that it was caused by hard disk overloading.