…: 0 Killed: 0 # Query_time: 9.031233 Lock_time: 0… up to the top level MySQL part for processing ….id | 1 | | +—-+————-+——-+——–+—————+———+———+————-+——+——-+ 2 rows in set (0.00 sec) In this… but rather helps to understand how much optimization is …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to monitor in MySQL. Those are only suggestions; any given deployment might want to monitor only some of them, as appropriate, and might need to…to swap until it is unresponsive and has to be power cycled. In addition, other processes…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…I also had to forward the tcpdump output to another host for processing …to capture tcpdump data in seconds (1200 = 20 min) TMP=’/tmp’ LOCKFILE=”$self.lockfile” TMPfile=”$self.temp” RESfile=”$self.result” # check lock… – > $TMP/$TMPfile” & PID=$! sleep $SLEEPTIME kill $PID # set trap to be sure both…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL…to remove (or still use for processing). Of course you will see these tables going away if you close connection. In…Lock…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…how we could further improve lock times here when non-transactional tables are used Almost no locking, if not using myisam tables Built in…to deal with this issue is we have a guardian process that runs during a backup. It then kills any process…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…to tune how that statistics are calculated but we need to wait until the gathering process triggers again to…in our efforts to get a better execution plan for another query we run ANALYZE TABLE: mysql…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
…to the swap. This causes swapping and causes performance problems. This much is obvious. But how…in MySQL makes a special effort to avoid (delay) IO. If it happens to go to… client) processing. Database Locks/Latches are typically designed to be … prefer to see slowdown instead of MySQL being killed …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…kills Innodb, such as copying binary tables between the servers. It is important the team understands Innodb and knows how to handle it, or be able to learn it. It is also important to adjust processes as required to…in the MySQL server – in…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… memory process can allocate so make sure to leave space for other MySQL needs while factoring this in. The next step would be to decide How… try locking MySQL in memory by using –memlock – just be careful as in case you have memory usage spike you may have MySQL Server being killed…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy optimizations possible. Q8: How…to try it out. Q14: Are there any plans to fix Innodb so it unlocks (or never locks… in MySQL 5.1 Q15: How frequently …MySQL process. Q20: We’ve migrated to …
