Emergency

Search Results for: fragmented

Illustrating Primary Key models in InnoDB and their impact on disk usage

On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to …

Read More
 

MySQL upgrade best practices

MySQL upgrades are necessary tasks and we field a variety of questions here at Percona Support regarding MySQL upgrade best practices. This post highlights recommended ways to upgrade MySQL in different scenarios. Why are MySQL …

Read More
 

Feature preview: Compact backups in Percona XtraBackup

We continue to improve Percona XtraBackup, and today I would like to give a preview for one feature which comes in next Percona XtraBackup 2.1 release. This feature is “Compact backups”, and let me explain …

Read More
 

MySQL Indexing Best Practices: Webinar Questions Followup

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others …

Read More
 

Adrian Roston, CTO, Frequency

by:

The ability to change schemas and indexes on the fly and no need to repair fragmented indexes has led to a simplification of our environment and reduced maintenance windows

Read More
 

Tokutek and PalominoDB Partner to Bring Scale, Performance to Database Deployments

by:

MySQL storage engine provider joins forces with leading database consultants to deliver support for growing number of MySQL and MariaDB customers Lexington, MA – (May 2, 2012) – Tokutek, the leader in high-performance and agile …

Read More
 

Evidenzia Upgrades to TokuDB v5.2 to Address Storage Growth and Scale Performance

by:

Ensuring sufficient disk I/O to catch copyright violations at network speed. Evidenzia GmbH & Co. KG Issues addressed: Storage growth, including maxed-out disk I/O utilization Performance issues and business impact due to slow selects Inability to revise …

Read More
 

Improved InnoDB fast index creation

One of the serious limitations in the fast index creation feature introduced in the InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE or CREATE INDEX. Peter has already …

Read More
 

We’ll Bring the Pie

by:

Yesterday, Tokutek was invited (thanks to David Hughson, Vice-Consul of the British Consulate) to the Massachusetts State House for a forum on international business, hosted by Governor Deval Patrick. I felt pretty good about our …

Read More
 

Percona Server and XtraBackup weekly news, April 4th

Here’s the weekly review of Percona Server and XtraBackup news. Before I begin, let me briefly address a common question. We are sometimes asked about our plans in light of developments in the market such …

Read More