rendered paste body[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-slow-queries = /var/log/mysql_slow_query_log
key_buffer = 384M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 8M
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 264M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
tail mysql_slow_query_log
/usr/sbin/mysqld, Version: 4.1.21-standard-log. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
/usr/sbin/mysqld, Version: 4.1.21-standard-log. started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
top - 17:38:43 up 3 days, 12:50, 4 users, load average: 6.00, 4.15, 3.75
Tasks: 260 total, 8 running, 249 sleeping, 0 stopped, 3 zombie
Cpu(s): 33.2% us, 26.8% sy, 0.5% ni, 36.2% id, 3.3% wa, 0.0% hi, 0.0% si
Mem: 8310548k total, 7044460k used, 1266088k free, 287520k buffers
Swap: 2040212k total, 144k used, 2040068k free, 5004260k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14022 mysql 15 0 755m 78m 3068 S 83 1.0 3:25.36 mysqld
26033 nobody 15 0 28408 15m 3996 R 71 0.2 2:21.99 httpd