… MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table. mysql> show processlist… like above and either kill FLUSH TABLES WITH READ LOCK and fail backup or kill long running SELECT queries to let backup to… you’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… in ACTIVE state. Especially ACTIVE transactions which do not currently run any query are suspicious. There are however cases when screaming fire about ACTIVE… 1 MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process no 1098… case even if you get rouge transaction it will be killed quickly instead of stalling for potentially many hours.
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… tables and so MySQL running out of memory (and getting killed by kernel). It could not even be MySQL but some… reserve for spikes) than to have slowdown caused by swapping activities in case memory overcommit occurs you may be better off… as well as have tools to resolve them quickly (ie killing runaway queries) keeping swap file enabled may be right for you…
Post: Living with backups
November 6, 2008 By 28 Comments
… and executed which converts into slower queries execution and significantly degraded performance. Anything else…a clear conflict between the regular database activities, which need fast response times, and …0; } if ($is_running == 1 && $was_running == 0) { kill 18, $pid; $was_running= 1; } … my $…
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…when filtering only 4 out of hundreds of active clients). While this is lower than without …| ssh $REMOTEHOST — “cat – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both…
Comment: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… you should fix these first. You also can consider killing previous page view queries in some cases. Regarding session purge – this is… (last_active) column the delete should only traverse rows which were not active for a while and so chance they are active now…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log –filter ‘($… 0 9.42k 1.67 0 110.38 0 # Killed 0 0 0 0 0 0 0 # Last errn… during backup recovery trials when you’re doing this activity anyway. Using this way you can also measure “cold” …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…to them. With DRBD you have the choice of killing one of the nodes and re-syncing from …the data at the same time as running reporting queries on last month. All last month will be …got use to SAN based high availability solutions with active-passive management software. Quite often these guys would …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…area of optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full …the rows if they were not matched by query where clause when it was not resolved …: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… You also see the other threads: —TRANSACTION 0 228527423, ACTIVE 0 sec, process no 30034, OS thread id … not touching the same tables as the other queries; it’s just touching the same internal structures. …. The solution I chose in this case? mysql> KILL 7; Immediately afterward everything cleared …
