… slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed… are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero. It looks… but because the access type to the tables is “const” MySQL does not count it as access to two tables. In…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…dumped by setuid processes (and MySQL Server is most commonly ran changing user from “root” to “mysql“). Before … can do kill -sigsegv `pidof mysqld` which will trigger the same code as if MySQL crashes … to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… and so if you close connection MySQL can clean them up. Killing connections (or stopping related applications) and … and forgot to remove (or still use for processing). Of course you will see these tables going… to detect memory leaks like valgrind are too slow to run in production. So the best thing…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…); … Causes MySQL to “leak” 1MB of memory per second with no apparent good reason – no slow queries or queries in the PROCESS LIST… of memory: Killed process 1081 (mysqld). automount invoked oom-killer: gfp_mask=0x201d2, order=0, oomkilladj=0 Out of memory: Killed process 1081 (mysqld…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… cause confusion about which queries are really slow. Recently, I got more than 60% dropped … 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: 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 …server in a replication environment, the process can be speed up by … threshold specified, it will be killed. This prevents users from blocking purge…. #830199 (Oleg Tsarev). Variable log-slow-admin-statements was not listed …
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…death-by-swapping, which would be extremely slow on this machine, so we need to…process no 30034, OS thread id 1159956816 starting index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL…top. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything…
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…transaction and so you can get system to slow down because of maintaining many old row versions….if you get rouge transaction it will be killed quickly instead of stalling for potentially many …
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 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737… to use only half of system CPU resources for query processing was not too bad, however with 16,32,64 cores…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
… discarding the page will cause extra IO slowing things down. Skewing up all Algorithms The …swapping does for concurrent (multi CPU, multi client) processing. Database Locks/Latches are typically designed to …you may prefer to see slowdown instead of MySQL being killed because of out of memory but …
