EmergencyEMERGENCY? Get 24/7 Help Now!

How to use tcpdump on very busy hosts

 | April 18, 2011 |  Posted In: Insight for DBAs, MySQL

Often I run into problems when trying to use mk-query-digest with tcpdump on “very” busy hosts. You might be thinking, “very busy is a relative and unquantifiable term,” and you’d be right, so I’ll phrase this differently. Let me give a little background to the problem first. Mk-query-digest tries to handle dropped or missing packets […]

Read More

Effect of adaptive_flushing

 | December 4, 2009 |  Posted In: Benchmarks, MySQL

I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about previously here and here. The server in question was Solaris 10 with 8 disk RAID10 and 2 32GB SSDs used for ZIL and L2ARC, 72G RAM and 40G buffer pool. […]

Read More