EmergencyEMERGENCY? Get 24/7 Help Now!

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 …

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. …

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 …

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. …

Read More
 
Interactive Debugging of Transaction Conflicts with TokuDB

I am developing a concurrent application that uses TokuDB to store its database. Sometimes, one of my SQL statements returns with a ‘lock wait timeout exceeded’ error. How do I identify the cause of this …

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 …

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 …

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 …

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 …

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 …

Read More
 

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.