Hello,
This server has dual intel xeon 5430 cpu, 8GB ram and 2x15k rpm sa-scsi hard drives on raid1. It is a web server and thus apache and mysql run on the same machine for now. We have innodb databases which are several gigabytes big (mediawiki with 12000 articles and some vbulletin forums).
[B]Quote:[/B] |
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
max_user_connections = 350
max_connections = 500
# interactive_timeout = 10
# wait_timeout = 10
# connect_timeout = 10
thread_cache_size = 128
key_buffer_size = 128M
join_buffer = 64MB
max_allowed_packet = 16M
table_cache = 1024
record_buffer = 1M
innodb_buffer_pool_size = 1024M
innodb_log_buffer_size = 16M
innodb_log_file_size = 128M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
sort_buffer_size = 8M
myisam_sort_buffer_size = 8M
max_heap_table_size = 128M
tmp_table_size = 128M
max_connect_errors = 10
thread_concurrency = 8
safe-show-database
long_query_time = 1
server-id = 1
#[mysql.server] [safe_mysqld] #[mysqldump] [mysql] [isamchk] [myisamchk] [mysqlhotcopy] |
[B]Quote:[/B] |
mysqlreport
__ Key ____________________________________________________________ _____ __ Questions ___________________________________________________________ __ SELECT and Sort _____________________________________________________ __ Query Cache _________________________________________________________ __ Table Locks _________________________________________________________ __ Tables ____________________________________________________________ __ __ Connections _________________________________________________________ __ Created Temp ________________________________________________________ __ Threads ____________________________________________________________ _ __ Aborted ____________________________________________________________ _ __ Bytes ____________________________________________________________ ___ __ InnoDB Buffer Pool __________________________________________________ __ InnoDB Lock _________________________________________________________ __ InnoDB Data, Pages, Rows ____________________________________________ Pages Rows |
Any assistance or advice would be greatly appreciated, thanks.