…in our plans to create excellent free tools for MySQL administrators. There is one really big thing to talk…is a lot of load and set up pt-kill to kill the queries if they happen to run too… ton of great improvements to our testing and development process, as well as rewriting pt-diskstats from awk to…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…’t shut down the slave, I just stopped the replication processes. This is safe to do even when temporary tables are… until position 207, kill it, and restart it: slave1 > show slave status\G *************************** 1. row *************************** Master_Log_File: mysql-bin.000006 Read_Master…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data, at… memcache) is often implemented to offload MySQL. When it comes to large scale data processing other techniques are used. Google uses some… of data and kill them. Now think what happens if you Search Google or engage in any other processing intensive activity. If…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking Apache would kill the script after “Timeout… which you can enable and which gives you access to process control system calls including pcntl_alarm. Using this function you… some cleanup work – for example you can open another MySQL connection to kill the query which was running (otherwise query may well…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… and initialize two chunks of 40 GB from two separate processes, but not 80 GB from one. In fact, 80GB allocation… process so as to overrun physical memory + swap. Both allocations were successful, one initialized successfully, the other was killed by the OOM kill…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… temporary tables and so MySQL running out of memory (and getting killed by kernel). It could not even be MySQL but some script… killing runaway queries) keeping swap file enabled may be right for you. Myself I tend to keep swap enabled on MySQL server… large spikes in memory requirements, as well as you have processes and discipline to make sure it is kept stable.
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… | select … | 6360 | user | | NULL | 6361 | user | | NULL +——+——————+—————-+————- Notice all those processes in ‘statistics’ status. Why is that happening? Look at SHOW…, process no 30034, OS thread id 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL…;” at the top. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything cleared up.
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…a slave server in a replication environment, the process can be speed up by having prefetch … than the threshold specified, it will be killed. This prevents users from blocking purge by mistake…PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug …a slave server in a replication environment, the process can be speed up by having prefetch threads…seconds than the threshold specified, it will be killed. This prevents users from blocking purge by mistake…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… had to forward the tcpdump output to another host for processing because the database host couldn’t handle the additional IO… clean up the temp file too trap ‘rm -f $LOCKFILE; kill $PID; ssh $REMOTEHOST — “rm -f $TMP/$TMPfile”; exit’ INT TERM…>/dev/null \ | ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both remote files are…
