… – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking Apache would kill the script after “Timeout… which simply runs in tight loop “forever” Script which runs in tight loop but doing a lot of sleep() calls – so it takes… some cleanup work – for example you can open another MySQL connection to kill the query which was running (otherwise query may well continue…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…/`date +%s`-tcpdump & mysql -e ‘show innodb status\Gshow full processlist’ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If this… in loops and update data, unless you make them commit between iterations. And watch your server to find idle-in-transaction connections…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual …thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_…
