Monthly Archives - October 2013

InnoDB scalability issues due to tables without primary keys

Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability issues. Hence there was another one I wanted to highlight:
Scalability issues due to tables without primary keys
This scalability issue is caused by the usage of tables without primary keys. This issue typically shows itself […]

Read more

Percona Toolkit 2.2.5 is now available

Percona is glad to announce the release of Percona Toolkit 2.2.5 on October 17th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series.
New Features:

Query_time histogram has been added to the pt-query-digest JSON output, not the actual chart but the values necessary to […]

Read more

Measuring Max Replication Throughput on Percona XtraDB Cluster with wsrep_desync

Checking throughput with async MySQL replication
Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition).  In MySQL async replication this is important to know because the single-threaded apply nature of async replication can be a write performance bottleneck.  In a production system, we can tell […]

Read more

Visit Tokutek at MongoDB Boston on October 25

Tokutek is proud to be a sponsor of the MongoDB Boston 2013 event in Boston next Friday, October 25. The annual one-day conference is dedicated to MongoDB and is featuring all new advanced sessions this year. A few things to look forward to according to MongoDB’s website are:

New and exciting features from the most recent […]

Read more

utf8 data on latin1 tables: converting to utf8 without downtime or double encoding

Here’s a problem some or most of us have encountered. You have a latin1 table defined like below, and your application is storing utf8 data to the column on a latin1 connection. Obviously, double encoding occurs. Now your development team decided to use utf8 everywhere, but during the process you can only have as […]

Read more

Using keepalived for HA on top of Percona XtraDB Cluster

Percona XtraDB Cluster (PXC) itself manages quorum and node failure.  Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity.  Nodes in such a state will be easily detectable via SHOW GLOBAL STATUS variables.
It’s common to use HAproxy with PXC for load balancing purposes, but […]

Read more

Announcing TokuDB v7.1

Today we released TokuDB v7.1, which includes the following important features and fixes:

Added ability for users to view lock information via information_schema.tokudb_trx, information_schema.tokudb_locks, and information_schema.tokudb_lock_waits tables.
Changed the default compression to zlib and default basement node size to 64K.
Changed default analyze time to 5 seconds.
Added server variable to control amount of memory allocated for each bulk […]

Read more

Innotop: A real-time, advanced investigation tool for MySQL

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Cacti, Zabbix, Ganglia, Nagios, etc. But each […]

Read more

Percona Server 5.6 Webinar: Enterprise-grade MySQL

A week ago we launched our first GA release of Percona Server 5.6 and it’s a real game-changer for us. The release of Percona Server 5.6 (our enhanced, drop-in replacement for MySQL) not only provides stability and performance but also provides key features only available in Oracle’s MySQL 5.6 Enterprise Edition. As usual, Percona […]

Read more