Buy Percona ServicesBuy Now!

Percona Server 5.6.23-72.1 is now available

 | March 4, 2015 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona is glad to announce the release of Percona Server 5.6.23-72.1 on March 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.23, including all the bug fixes in it, Percona Server 5.6.23-72.1 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Read More

Percona Server 5.6.22-72.0 is now available

 | February 6, 2015 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona is glad to announce the release of Percona Server 5.6.22-72.0 on February 6, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server 5.6.22-72.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Read More

Percona Server 5.6.22-71.0 is now available

 | January 12, 2015 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona is glad to announce the release of Percona Server 5.6.22-71.0 on January 12, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server 5.6.22-71.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source […]

Read More

Percona Server 5.6.21-70.0 is now available

 | November 3, 2014 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona is glad to announce the release of Percona Server 5.6.21-70.0 on October 30, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. We’re also happy to announce that Ubuntu 14.10 and CentOS 7 users can download, install, and upgrade Percona Server 5.6 from Percona’s software repositories. Based on MySQL 5.6.21, […]

Read More

MySQL compression: Compressed and Uncompressed data size

 | October 10, 2014 |  Posted In: InnoDB, MySQL, Percona Server for MySQL, TokuDB

MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression. And this is where inconsistency is born. Lets take a look at the same table […]

Read More

More then 1000 columns – get transactional with TokuDB

 | September 25, 2014 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MySQL, TokuDB

Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for MyISAM. It is usually about full text search or […]

Read More

When (and how) to move an InnoDB table outside the shared tablespace

 | August 22, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona MySQL Support, Percona Server for MySQL, TokuDB

In my last post, “A closer look at the MySQL ibdata1 disk space issue and big tables,” I looked at the growing ibdata1 problem under the perspective of having big tables residing inside the so-called shared tablespace. In the particular case that motivated that post, we had a customer running out of disk space in his […]

Read More

Why TokuDB hates Transparent HugePages

 | July 23, 2014 |  Posted In: MySQL, TokuDB

If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message: 2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with transparent huge pages enabled. 2014-07-17 19:02:55 13865 [ERROR] Please disable them to continue. 2014-07-17 19:02:55 13865 [ERROR] (echo never > /sys/kernel/mm/transparent_hugepage/enabled) You might be curious […]

Read More

Reference architecture for a write-intensive MySQL deployment

 | July 22, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Cloud Tools, Percona Server for MySQL, TokuDB

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let me describe what we use, and later I will explain […]

Read More