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:
Anyone can help please?
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