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...
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>
Recent comments
15 hours 24 min ago
15 hours 28 min ago
2 years 8 weeks ago
2 years 8 weeks ago
2 years 10 weeks ago
2 years 11 weeks ago
2 years 11 weeks ago
2 years 20 weeks ago
2 years 20 weeks ago
2 years 21 weeks ago