Emergency

Search Results for: mysql php speed

Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN

I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment.  They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against …


Testing Percona Replication Manager (prm) with Vagrant

If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. …


Top Ten for 2011

  It’s almost the end of the year – that means holiday cards, shopping, cooking, parties, and the inevitable year-end top lists (including gems like this one). In the spirit of end of year list …


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 …


Query Planner Gotchas

Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t …


TokuDB FAQ

Links to the FAQ Sections can be found here: General Information Open Source Technical Details Best Practices and Tools General Information ANY CHARACTER HERE 1.    What is TokuDB? TokuDB is an ACID compliant storage engine for …


XtraDB storage engine release 1.0.3-7

Dear Community, Today we are announcing XtraDB release 7. This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL …


Improving InnoDB recovery time

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes, it may takes long time to start. Also it affects …


The Depth of a B-tree

Schlomi Noach recently wrote a useful primer on the depth of B-trees and how that plays out for point queries — in both clustered indexes, like InnoDB, and in unclustered indexes, like MyISAM. Here, I’d …


Goal driven performance optimization

When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort …