… seen connection in the SHOW PROCESSLIST output which is in “Sleep” state for a long time and you have no idea why… frequently indicates serious problems in the application. If you do not use persistent connections and you have connection in Sleep stage for… “bt” command output which also hinted what could be the problem. By the way does anyone know any debugger which can…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
Thanks very much peter. I found the problem of slow down of our site with small load of ….conf do great harm to so many mysql connections in sleep state for so long time(wait_timeout). Original timeout was set… httpd.conf, all seems to be ok. Mysql connections in sleep state only are available for short duration and there are no…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… is number of processes which are in “running” state or in “uninterruptable sleep” state which typically corresponds to disk IO. You can also…. Low Load Average does not mean there are no performance problems, for example if you run single batch job on the…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…OS waits per second it may be the problem. The other way to look at it is…status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is quite …purging, flusing logs, doing insert buffer merge. Values for “state” field are rather self explanatory. You can also…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even… will suffer. So what you can do to prevent this problem from happening ? The answer is easy. Throttle the side load… this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea. It also often…
Post: Percona Toolkit by example - pt-stalk
January 3, 2013 By 3 Comments
… can diagnose intermittent problems that you cannot… (–daemonize). $ pt-stalk –sleep=3600 –threshold=0 –iterations=24 … Id | User | Host | db | Command | Time | State | Info | #+—–+———-+———–+—-+———+——+——-+——————+ # trg_plugin() { mysqladmin $EXT…
Comment: Apache PHP MySQL and Runaway Scripts
May 21, 2008 By 20 Comments
… back stating it. Without this information interchange it’s not possible to detect the client disconnect. It’s not a PHP problem, it’s a web app problem. Probably a solution will be to send… the application is prone to SQL Injection, one can inject SLEEP(99999999) (choose your number) and disconnect. Doing it till there…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… to call it stable. We have a montoring tool that states that we often hit the “max_connections” threshold (650) connections… or so. We cache alot but still we have db problems. a. The thing that I really, really would like to….00, 0.95 328 processes: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… RAM. This server is a dedicated database server. So, my problems are, the mysql process always use 1 cpu core at…see cpu4 use 100% usage while others like at idle state. top – 18:27:53 up 103 days, 7:14, 3…, 1.07, 1.02 Tasks: 191 total, 1 running, 190 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0% us, 0.3…
