While setting up a new machine I just noticed I did never post about Jeremy Zawodny's great top clone for MySql - mytop ... an essential tool for every linux / mysql server running a couple of databases...

Main Page

Readme for installation

Download MyTop Version 1.4

it even supports the transaction part of MySql - InnoDb - altough the level of information greatly differs between MyISAM and InnoDb...

But it rocks - set it up today... just take care you have the extra perl libs installed.

And while we're at it - a nice extended my.cnf MYSQL config disabling all innodb overheads and setting some things nice for a DUAL-XEON/2-3GIG server follows here ... feedback is appreciated as always

[mysqld]

set-variable = max_connections=1200

slave_net_timeout=10

max_connect_errors=10000

ft_min_word_len=2

max_allowed_packet=256M</p>

<p>log-slow-queries=slow-queries.log

long_query_time=4

safe-show-database

skip-innodb

connect_timeout = 10

wait_timeout = 900

bulk_insert_buffer_size = 16M</p>

<p>query_cache_limit = 2M

query_cache_size = 96M

query_cache_type = 1

query_prealloc_size = 16384

query_alloc_block_size = 16384</p>

<p>key_buffer = 32M

myisam_sort_buffer_size = 64M

join_buffer_size = 1M

read_buffer_size = 1M

sort_buffer_size = 2M

table_cache = 1800</p>

<p>[mysqld_safe]

open_files_limit = 8192</p>

<p>[mysqldump]

quick

max_allowed_packet = 16M</p>

<p>[myisamchk]

key_buffer = 64M

sort_buffer = 64M

read_buffer = 16M

write_buffer = 16M</p>

<p>