… to the mysqld process. Use the mysql console or mysqladmin utility to FLUSH LOGS; These options should be equivalent, but MySQL bug 65481… practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time into @lqt_save; set global long_query_time=2000; select sleep(2); FLUSH LOGS; select sleep…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… is slow again. MySQL load is not going very high. We have also noticed that many process stay in sleeping condition for long time like 200-300 processes. Current Server Details (Dedicated Server): Software: Apache Version – 2.2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL… Info | +—-+———-+———–+——+———+——+———————————+———————————-+ | 1 | msandbox | localhost | test | Sleep | 403 | | NULL | | 3 | msandbox |…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… time critical process I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system too much in this case throttling by having relatively short queries and introducing “sleeps” between them…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… see that the multiple purge threads achieve their goal of processing the history list faster. Of course, this is achieved at… replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve made a tiny change… purge sleeps is not enough to solve them. However, MySQL 5.6.2 is experimental code and I am sure that next MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot… have created and forgot to remove (or still use for processing). Of course you will see these tables going away if… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…”,1000000); select sleep(1); SET @a12:=repeat(“a”,1000000); select sleep(1); SET @a13:=repeat(“a”,1000000); select sleep(1); … Causes MySQL to “leak” 1MB of memory per second with no apparent good reason – no slow queries or queries in the PROCESS LIST… stalled for few minutes before that: Out of memory: Killed process 1081 (mysqld). automount invoked oom-killer: gfp_mask=0x201d2, order…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… which connections does this process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same…. This way you will see the URL which that process is processing and so get few more hints on what may be… our what is happening with the process are not only helpful to debug sleeping connections with MySQL but many other cases when you…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
….php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2….php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2… 10%. I also hacked a bit the “run_mysql.sh” script to allow more processing threads (100) instead of the max of…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… long time. For simplicity I did not use MySQL, but other system call – sleep() which has similar behavior for sake of experiment… which you can enable and which gives you access to process control system calls including pcntl_alarm. Using this function you… are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL queries this would be counted…
