Gathering queries from a server with Maatkit and tcpdump
For the last couple of months, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s an observer of the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time resolution. With this new functionality, it becomes possible for mk-query-digest to stand on the sidelines and watch querie
To pack or not to pack - MyISAM Key compression
MyISAM storage engine has key compression which makes its indexes much smaller, allowing better fit in caches and so improving performance dramatically. Actually packed indexes not a bit longer rows is frequent reason of MyISAM performing better than Innodb. In this article I’ll get in a bit more details about packed keys and performance implications it causes. First lets see how key compression w
Ultimate MySQL variable and status reference list
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar bookmark: an option and variable reference for all three sites in one! abort_slave_event_count blog perc
Technical Presentations
All of Percona’s open source software products, in one place, to download as much or as little as you need.
Impact of the number of idle connections in MySQL
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Neat Tricks for the MySQL Command-line Pager
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
xtrabackup-0.3, binaries and stream backup
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
How SHOW SLAVE STATUS relates to CHANGE MASTER TO
All of Percona’s open-source software products, in one place, to download as much or as little as you need.
Why you don't want to shard.
Note: This blog post is part 1 of 4 on building our training workshop. The Percona training workshop will not cover sharding. If you follow our blog, you’ll notice we don’t talk much about the subject; in some cases it makes sense, but in many we’ve seen that it causes architectures to be prematurely complicated. So let me state it: You don’t want to shard. Optimize everything else first, and then
1
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
Home
Moving from MyISAM to Innodb or XtraDB. Basics