One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… to use. Do push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work from…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…: Script which is same as previous one but which also outputs some data in the loop: Script which checks connection status in the loop… discovery (and so script abortion) worked only in case script was outputing something. If script is just doing something like scripts or MySQL calls and does…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…tracking down what that long-running transaction is doing. Of course, in some cases it’s …script that I use quite a bit. I simply start a screen session and run it in a loop…and port ${port} > /root/tcpdumps/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`…
Post: High availability for MySQL on Amazon EC2 - Part 5 - The instance monitoring script
October 22, 2010 By Leave a Comment
… the monitoring script that run on the MySQL node. At its smallest expression, the instance monitoring script is a simple empty loop that will… # initial sleep to give time to MySQL to recover InnoDB /bin/sleep 60 while [ 1 ]; do sleep 60 STATUS=`$BASEDIR/bin/mysqladmin… the restart of the MySQL node, the instance restart script on the Monitor node will loop and restart again the MySQL node. Stopping the…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… is important is that nested-loop joins on large data sets are very expensive. If MySQL supported sort-merge or hash…, you can store it on the filesystem and write custom scripts to do special-purpose tasks on it. Storing a little… problem is that MySQL doesn’t tend to perform well on a data warehousing workload. The nested-loop joins are not…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…/sysbench The used LUA script for sysbench http://www.mysqlperformanceblog.com/files/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script to run whole loop… tree. I think InnoDB team should solve this problem, I do not know Oracle plans about. It is also interesting to…
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…ve found. I’m using PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10,…a coding bug. So the insert happens, but the script dies doing some other stuff before the commit() occurs. I…standard (I haven’t tuned anything). So your script could loop for 5000 seconds. Perhaps a better solution is to…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
… version of mysql, with this patch applied (we compile mysql from source … earlier through the below perl script. It’s very quick, very …Log))//) { # If we enter this loop, it means a new query/type … ###print “died\n”; exit; # very important. } else { # Don’t do this. #waitpid($pid,0); } } } # done!!!…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…mysql_query and than handle the result in loop mysql…mysql_query() does. So mysql_query buffers all rows on client side. Let’s try our script with mysql_unbuffered_query instead of mysql…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… you want to have, if you’re writing scripts to look at SHOW INNODB STATUS it is …sync_spin_loops can be used to ballance between wasting CPU time running spin locks and doing unneeded context switches…, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id …
