Posted
13 days
ago
by
Xaprb
You used to use mk-query-digest to aggregate and report on MySQL’s slow query log. Then it got the ability to grab query events from polling SHOW PROCESSLIST. Next we thought, really, how hard can it be to implement the libmysql wire protocol, so
... [More]
we can sniff TCP packets? … it’s hard, but not [...]
Related posts:An alternative to the MySQL Query Analyzer MySQL justSeeking input on a badness score for query execution Suppose thAnalyze and optimize memcached usage with Maatkit Ryan poste
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
26 days
ago
by
Xaprb
MySQL Proxy is a really neat tool. I remember a few years back when I first saw Jan talking about it. Back in those days it was significantly different than it is now, but the concept remains the same: direct your database traffic through a
... [More]
man-in-the-middle. Chris Calender’s post on capturing erroneous queries [...]
Related posts:How to find un-indexed queries in MySQL, without using the log You probabFinding queries with duplicate columns A while agLearn about Maatkit at the MySQL Conference I’m
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
29 days
ago
by
Xaprb
As an alternative to another recent blog post that answered the question “how can I truncate all the tables in my database,” I thought I’d show another way to do it, which does not use the INFORMATION_SCHEMA.
$ wget
... [More]
http://www.maatkit.org/get/mk-find
$ perl mk-find --exec 'TRUNCATE TABLE %D.%N'
The other example is how to alter MyISAM tables to be [...]
Related posts:Making Maatkit more Open Source one step at a time If youXtrabackup is for InnoDB tables too, not just XtraDB Just thougRestoring from a mysqldump into tables with triggers This is ac
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
about 1 month
ago
by
Xaprb
Maatkit’s mk-loadavg tool is a helpful way to gather information about infrequent conditions on your database server (or any other server, really). We wrote it at Percona to help with those repeated cases of things like “every two weeks, my
... [More]
database stops processing queries for 30 seconds, but it’s not locked up and during [...]
Related posts:A metric for MySQL load average If you werMaatkit version 3119 released Your monthAn alternative to the MySQL Query Analyzer MySQL just
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
about 1 month
ago
by
Xaprb
Yesterday I attended CPOSC 2009. The conference was great. It was very well run, and I liked the sessions. I would definitely attend this conference again, and will recommend that Percona sponsor it next year. I attended the following
... [More]
talks:
Stop Worrying and Start Monitoring with Nagios (Andrew Libby)
DRBD, Network Raid, High [...]
Related posts:Recap of Southeast Linux Fest 2009 Last weekeSpeaking at CPOSC 2009
ISpeaking about Maatkit at CPOSC I’m
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
about 1 month
ago
by
Xaprb
I’ll be attending and presenting at the 2009 Central Pennsylvania Open-Source Conference. My session is on Maatkit. I see Tom Clark has a session on MySQL performance! I hope to see you there — I’ve really become a fan of these regional
... [More]
conferences.
By the way, I’ve also created a speaker badge by [...]
Related posts:Speaking about Maatkit at CPOSC I’m Speaking at EdUI Conference 2009 I’m Speaking at Enterprise LAMP Summit 2009
I am s
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
3 months
ago
by
Xaprb
A short time ago in a galaxy nearby, Domas Mituzas wrote about contention profiling with GDB stack traces. Mark Callaghan found the technique useful, and contributed an awk script (in the comments) to aggregate stack traces and identify which things
... [More]
are blocking most threads. I’ve used it myself a time or five. [...]
Related posts:A tweak to column alignment for the mext script I tweaked The unexpected consequences of SELinux I’ve
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
3 months
ago
by
Xaprb
I’m going to present on Maatkit at the CPOSC conference in central Pennsylvania on Saturday, October 17th 2009. I’ll give an overview of the toolkit, which is no longer an easy task in a single session. I see a number of other interesting
... [More]
sessions have been accepted. It looks like it’ll be [...]
Related posts:Speaking at EdUI Conference 2009 I’m Learn about Maatkit at the MySQL Conference I’m Presentation uploaded for Maatkit talk at MySQL Conference The slides
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
3 months
ago
by
Xaprb
You probably know that it’s possible to set configuration variables to log queries that don’t use indexes to the slow query log in MySQL. This is a good way to find tables that might need indexes.
But what if the slow query log isn’t
... [More]
enabled and you are using (or consulting on) MySQL 5.0 or [...]
Related posts:Finding queries with duplicate columns A while agLearn about Maatkit at the MySQL Conference I’m Maatkit version 3119 released Your month
Related posts brought to you by Yet Another Related Posts Plugin. [Less]
Posted
4 months
ago
by
Xaprb
Do you test your application systematically when you upgrade or reconfigure your database server? You should! Here’s a real (anonymized) story of what happens if you don’t.
When we upgraded to 5.0.62 (from 5.0.27 and 5.0.45), our code
... [More]
broke for queries like this:
SELECT SUM(amt) FROM daily_amt
WHERE day = FROM_UNIXTIME(1222889772);
The problem here was a wrong DATE/DATETIME comparison [...]
Related posts:Idea: a reverse changelog for MySQL Most softwMySQL Cacti templates version 1.1.1 released I’veMaatkit version 4334 released Maatkit ve
Related posts brought to you by Yet Another Related Posts Plugin. [Less]