…to use oprofile and see if there are sleep() statements). What did I see in ‘top’ but… And there were funny things like a “merovingian” process (think “angel”) that had to be started before… and the like. The query timer is in milliseconds (why doesn’t mysql show query times in microseconds? I…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… user, load average: 0.79, 1.00, 0.95 328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu… 10 mysql conf: [mysqld] server-id=5908 port=3309 socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Comment: Debugging sleeping connections with MySQL
December 1, 2011 By 30 Comments
We are having a problem with Sleeping queries slowing down our servers – its become quiet frequent now and … the mysql server to see the process, it just displays mysqld as Established – is there a better way to track where these queries… problem to occur again and then dynamically enable Mysql general query log to see what queries are being thrown to the server – we…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… create excellent free tools for MySQL administrators. There is one really …up offsets and modulos and set sleep times and throttle the tool …the stuffing out of it with query failures, deadlocks, high/changing load, replication… to our testing and development process, as well as rewriting pt-…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…: —TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query id 728900 localhost root show innodb…, process no 3396, OS thread id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query…. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…version of mysql, with this patch applied (we compile mysql from … # Process the query log, and build a couple of hashes from it: # # Hash 1: %queries… @{$queries{$connection}{$datetime}}, $query if length($query); $connection = $1; $starttime{$connection} = $datetime if (($datetime $_) { sleep $now -…
Post: Living with backups
November 6, 2008 By 28 Comments
… the browser. Moreover, reads sent from backup process usually want many sequential blocks of data… MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries …if ($kid > 0) { last; } sleep(1); } What this script does is to check MySQL status every second…
Comment: Debugging sleeping connections with MySQL
March 9, 2009 By 30 Comments
…it’s been sitting idle. The MySQL docs seem to say the same thing: “Sleep – The thread is waiting … displays the current commands being processed by the server, ignores threads with the Sleep command, I believe for the … “Query” could be a problem if it has a large Time value, but I don’t think Sleep …
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
…mysql connections in sleep…processes even if actual traffic is not overloaded. So mysql connection opened in slow HTTP connection reaches to wait_timeout and MySQL…
Comment: MySQL for Hosting Providers - how do they manage ?
November 29, 2008 By 15 Comments
… you can see SLEEP in processlist but What if you would do the sleep in the application…variable as a side effect of the query to obfuscate things. As I mentioned …MySQL 
The Shell Access/PHP Access etc is solved on the different level – the process accounting, the MySQL is however single process…
