… | select … | 6360 | user | | NULL | 6361 | user | | NULL +——+——————+—————-+————- Notice all those processes in ‘statistics’ status. Why is that happening? Look … the top. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything cleared …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…the Percona Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona…a slave server in a replication environment, the process can be speed up by having prefetch …seconds than the threshold specified, it will be killed. This prevents users from blocking purge by mistake…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… a situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will not shut down unless a manual kill -9 is run. Our mysql db contains… at all. This can be a security enhancement, # if all processes that need to connect to mysqld run on the same host. # All interaction…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona…a slave server in a replication environment, the process can be speed up by having prefetch …seconds than the threshold specified, it will be killed. This prevents users from blocking purge by mistake…
Comment: MariaDB 5.3 is released as GA!
March 14, 2012 By 17 Comments
… Oracle is going to “kill” MySQL after all the investments they’ve been making. There’s no evidence of killing, there’s just evidence… to me — I interpret that as Oracle wanting all of their development processes to be run consistently. The motive is quite clear… it and moved on. I was a vocal critic of MySQL AB’s policies when I thought it would make a…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than… the tcpdump output to another host for processing because the database host couldn’t handle… | ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…the choice of killing one of the nodes and re-syncing from another one while with MySQL Replication you …with MyISAM (check required) so you need to have processes to ensure your application does not uses this … time as running reporting queries on last month. All last month will be hot on the slave …
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
…MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process… see transactions ACTIVE for very long time at all but the ones having locks is really the … if you get rouge transaction it will be killed quickly instead of stalling for potentially many …
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…the Percona Software Repositories). Based on MySQL 5.1.65, including all the bug fixes in it, Percona… Bug fixed #712055 (George Ormond Lorch III). The kill idle transactions feature in XtraDB (if enabled) …hold LRU_list_mutex during the entire dump process. Now the mutex is periodically released in …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…equipment which magically going to solve all performance problems, with magically means nobody…processing (and extra trip) involved. This in particular hurts log writes which are very latency critical. Now what is about MySQL… with multiple power supplies ECC memory kill-chip and RAID is more reliable…
