Emergency

Search Results for: fast_index_creation

Why ALTER TABLE runs faster on Percona Server 5.5 vs. MySQL 5.5

Some of us Perconians are at OpenStack summit this week in Atlanta. Matt Griffin, our director of product management, tweeted about the turbo-hipster CI talk about their experience of ALTER TABLEs running faster on Percona …

Read More
 

How to monitor ALTER TABLE progress in MySQL

While working on a recent support issue as a Percona Support Engineer,  I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the …

Read More
 

Announcing Percona Server for MySQL 5.6.10-60.2

Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2 on March 14, 2013.  (Downloads are available here and from the experimental Percona Software Repositories). Based on MySQL 5.6.10, including all the bug fixes in it, Percona Server 5.6.10-60.2 …

Read More
 

Announcing Percona Server 5.6.6-60.1 Alpha

Percona is glad to announce the ALPHA release of Percona Server 5.6.6-60.1 on September 14, 2012 (Downloads are available here and from the EXPERIMENTAL Percona Software Repositories, although currently only for RHEL/CentOS as we are working on ensuring compatibility with …

Read More
 

Announcing Percona XtraDB Cluster 5.5.27-23.6

Percona is glad to announce the release of Percona XtraDB Cluster on September 7th, 2012. Binaries are available from downloads area or from our software repositories. Features: Percona XtraDB Cluster supports tunable buffer size for …

Read More
 

Announcing Percona Server 5.5.27-28.0

Percona is glad to announce the release of Percona Server 5.5.27-28.0 on August 23rd, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.27, including all the bug fixes in it, Percona Server 5.5.27-28.0 is now the current …

Read More
 

MySQL Upgrade Webinar Questions Followup

I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer during Webinar, following Jay’s Lead I decided to post them as a Blog Post. Q: …

Read More
 

ALTER TABLE: Creating Index by Sort and Buffer Pool Size

Today I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool sizes. Results are pretty interesting. I used modified Sysbench table for these tests because original …

Read More
 

Building Indexes by Sorting In Innodb (AKA Fast Index Creation)

Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion, especially for tables much larger than memory and large uncorrelated indexes you might …

Read More
 

Using innodb_sys_tables and innodb_sys_indexes

I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. The point I’m looking to make though it would be very hard to catch this …

Read More