I always like mytop. It's a handy tool which allow you to see what exactly happens with your MySQL. Unfortunately MySQL 5.0 (I'm not sure about 4.1) statistics about qps, qps now, cache & etc are wrong. The reason is missing 'global' in show queries. With a slight modification mytop is back in game.
В общи линии идеята е да се добави "global" при всички "show" заявки.
my @variables = Hashes("show variables");
my @variables = Hashes("show global variables");
write new comment