Alright, the load on the server is less than 40%. Also I'm using MyISAM, would switching to InnoDB have a significant performance increase?
Also what would you suggest on how to optimise my MySQL server. I'm using this config currently:
Code:
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
innodb_file_per_table = 1
myisam_sort_buffer_size = 8M
read_rnd_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
sort_buffer_size = 512K
table_cache = 64
max_allowed_packet = 12M
key_buffer = 16M
default-storage-engine = MyISAM
wait_timeout=28800
thread_cache_size=128
query_cache_type=1
query_cache_size = 100M
query_cache_limit=32M
connect_timeout=30
big-tables
bind-address = xxx
max_connections = 1000
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[myisamchk]
write_buffer=2M
read_buffer=2M
sort_buffer_size=256M
key_buffer=256M
[mysqlhotcopy]
interactive-timeout=21000
And is it safe to assume that the bottleneck is the MySQL server?
Thanks!
Bookmarks