… and ready to save someone’s life (or …database status and if any problems were noticed, the monitoring would simply pause the copying. I did a simple Perl script to…script does is to check MySQL status every second and in case the number of connected threads goes above 50, it sends STOP signal to…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…life. It’s worth running this script on a seperate box with lot’s of cores – it’s very thread-hungry. The script… is used to actually runt he queries, the second is used to # avoid fork… { my $dt = $_; while((time() – $offset) connect(“DBI:mysql:database=$DBNAME;host=$DBHOST”, “$DBUSER”, “$DBPASS”) ||…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL…script data in associative array. If you have some data read from database…
