Global Transaction Identifiers – why, what, and howIn MySQL 5.6 we introduced a new replication feature called Global Transaction Identifiers, or GTIDs. While there are many use cases, our primary motivation for introducing GTIDs is that it ... 続きを読む
I’m using innotop again every day, for the first time in a few years. I found that I didn’t like the tool that the younger and less experienced version of me created. It is very flexible and has the ability to surface a lot of information a... 続きを読む
MySQL実は1.0.0が2010年12月にリリースされていたのに全く知名度の無い"MySQL Utilities"。実は便利な機能が複数用意されているので、スクリプトを手作りしなくても済む可能性大です。またリリースに向けて新たなマイルストーンリリースが出てきたMySQL 5.6での... 続きを読む
Mydumper and Myloader InnoDB backup and restore benchmarks against mysqldump method. Multi-threaded backup tools tests for faster InnoDB backup and restores.MySQL Back up & Restore: Faster InnoDB database backup / restore using Mydumper and M... 続きを読む
MySQLのRANGEパーティションのお話です。 MySQL5.1からサポートされているパーティショニングですが、ログテーブル等、レコード数が多くなりがちなテーブルに日付でパーティショニングしてます。 最初から遠い未来までのパーティションを切るのは気持ち悪いし、... 続きを読む
mysql 5.5になり、パーティションの機能もバージョンアップしました。MySQL 5.1では以前、当ブログにて書きましたが、今回は、MySQL 5.5で書きたいと思います。 後ろの行で、MySQL 5.1 と 5.5の比較(のようなもの)を書きましたのでご確認ください。 では、さ... 続きを読む
innotop is a 'top' clone for MySQL with more features and flexibility than similar tools. completely customizable; it even has a plugin interface monitors many servers at once and can aggregate across them a complete superset of similar tools... 続きを読む
On Wednesday May 16th, we ran a webinar to provide an overview of all of the new replication features and enhancements that are previewed in the MySQL 5.6 Development Release – including Global Transaction IDs, auto-failover and self-healing... 続きを読む
Mydumper (aka. MySQL Data Dumper) is a high-performance multi-threaded backup (and restore) toolset for MySQL and Drizzle. The main developers originally worked as Support Engineers at MySQL (one has moved to Facebook and another to SkySQL) ... 続きを読む
We are always looking for interesting articles about MySQL! Have you written something and would like to it published here? Please contact us via feedback form » Global Transaction IDs & Utilities for Self-Healing Replication Clusters The new... 続きを読む