… thanked by a lot of people running MySQL in wild. I also wanted to… if you close connection MySQL can clean them up. Killing connections (or stopping related …and Com_stmt_send_long_data to see whenever sending long data feature is… to remove (or still use for processing). Of course you will see these…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB is getting stuck, has long-running…MySQL on the same files in the data directory, and refusing to shut down MySQL so that it is killed…memory. A runaway server process, or poorly optimized …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… this box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill extremely long running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL… to use only half of system CPU resources for query processing was not too bad, however with 16,32,64 cores…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…GB of disk space. It can also take very long time to write this amount of data to … you can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes accessing … `pidof mysqld`” select “continue” and let MySQL run. If it crashes you will have process ready to work with GDB, …
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…behavior for scripts running very long time. For simplicity I did not use MySQL, but other system call…enable and which gives you access to process control system calls including pcntl_alarm. …another MySQL connection to kill the query which was running (otherwise query may well continue to run even…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… our plans to create excellent free tools for MySQL administrators. There is one really big thing to… and set up pt-kill to kill the queries if they happen to run too long and schedule downtime in… of great improvements to our testing and development process, as well as rewriting pt-diskstats from awk…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… spending very long time in ACTIVE state. In the perfect world if you’re running online …MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process… you get rouge transaction it will be killed quickly instead of stalling for potentially many…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… a bunch of processes waiting to finish. Also, mysql will not shut down unless a manual kill -9 is run. Our mysql db contains a mix of innodb and myism tables and run… max_length_for_sort_data=2048 max_sort_length=2048 long-query-time=5 log-slow-queries=/apps/log/slow-query…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… it believes took longer than the servers long-query-time of 1 second tcpdump traffic … the tcpdump output to another host for processing because the database host couldn’t handle …-f $LOCKFILE; kill $PID; ssh $REMOTEHOST — “rm -f $TMP/$TMPfile”; exit’ INT TERM EXIT touch $TMP/$LOCKFILE # run the …
Comment: New MySQL Community Release Policies published
November 8, 2007 By 9 Comments
… you can only make money selling code is gonna kill MySQL AB in the long run. I truly hope a vibrant Open Source community…, you mention that bug fixes are going through a long and elaborate process. Does this apply to all bug fixes, or just… totally understand a more involved and careful QA and reviewing process for patches to stable versions. But dev versions don’t…
