…] @ localhost [] # Thread_id: 64914 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent: 0… query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query… the tables is “const” MySQL does not count it as access to two tables. In case of “real” access to the data…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… – for example you can open another MySQL connection to kill the query which was running (otherwise query may well continue to run even if… with sleep() function is wrong and if I would use real MySQL queries this would be counted to max_execution_time and so… this time on MySQL time) one is doing single query another 1000 queries 1 second length each. Neither of them gets killed: Another one…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…: Alert only on things that reliably indicate a real problem. Do not alert on a threshold that …MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed…the server is alive and responds to a query. The pmp-check-mysql-status is also very flexible and …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… You can kind of workaround this issue by killing transactions which are too old though proper … Tree The query is internally presented using parse tree inside MySQL which of course depends on query size … queries to perform order of magnitude slower than in normal case. Some of these comes from real…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…query blocks any READ queries to execute on the table. mysql> show processlist; … very unfortunate. As the real solution I’d love …kill FLUSH TABLES WITH READ LOCK and fail backup or kill long running SELECT queries…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…: use “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it …to say, this doesn’t actually solve the real problem of dropped packets, it just applies… | ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… blog post. Tips/Tricks: run with –kill-long-queries to avoid nasty problems with “FLUSH TABLES …, you can now pull binary logs in real time to another server using “mysqlbinlog … –read-…, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…real size, and also explains what takes so much space. Queries First count start query …queries: (again look on comparison with other engines in Google Spreadsheet or in summary table at the bottom) Query Q1: mysql… it was totally idle, but query stuck. I killed query, restarted mysqld but could not…
Comment: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…282 | root | localhost | NULL | Query | 3 | init | select sleep(10) | +—–+——+———–+——+———+——+——-+———————–+ 2 rows in set (0.00 sec) mysql> kill 282 You…holder ? Slow query log is not a real solution because you want to stop the queries taking resources …
Comment: Analyzing air traffic performance with InfoBright and MonetDB
October 7, 2009 By 50 Comments
…! I really appreciate the use of real world data because in my experience …queries really have to be optimized and that is a challenge without explain. We’re not using joins (but unlike mysql…query time). But if you mess up & run a query with curdate() in it, oh boy is that slow. Then do NOT kill…
