MySQL

Category to track posts in PlanetMySQL

How (not) to find unused indexes

I’ve seen a few people link to an INFORMATION_SCHEMA query to be able to find any indexes that have low cardinality, in an effort to find out what indexes should be removed.  This method is flawed – here’s the first reason why:

Shell

CREATE TABLE `sales` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) DEFAULT NULL,
`status` enum(‘archived’,’active’) DEFAULT […]

Read more

MySQL-Memcached or NOSQL Tokyo Tyrant – part 2

Part 1 of our series set-up our “test”  application and looked at boosting performance of the application by buffer MySQL with memcached.  Our test application is simple and requires only 3 basic operations per transaction 2 reads and 1 write.  Using memcached combined with MySQL we ended up nearly getting a 10X performance boost […]

Read more

MySQL-Memcached or NOSQL Tokyo Tyrant – part 1

All to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to there problem. Why?  Because their other applications use it, so why not the new application?  Over the past couple of months I have been doing a ton of work for clients […]

Read more

Tuning for heavy writing workloads

For the my previous post, there was comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads.
At first, <tuning peak performance>. The next, <tuning purge operation> to stabilize […]

Read more

Percona welcomes Devananda van der Veen

On the heels of our earlier announcement of Fernando and Yves, I’m happy to welcome Devananda van der Veen to our team.
Devananda, also known as Deva, is a talented, detail-oriented MySQL expert and systems administrator. His previous job was at Hydra, an advertising network, where he was sole DBA and half of the […]

Read more

XtraDB storage engine release 1.0.4-8

Dear Community,
We are glad to present you release 8 of XtraDB.
The release includes following new features:

The release is base on 1.0.4 version of InnoDB plugin. We thank Schooner Information Technology for sponsoring and testing the port of XtraDB to 1.0.4
MySQL 5.1.39 as a base release

Fixed bugs:

Bugs#413858: Crash from failed assertion in dict0dict.c
Bug#417751:
XtraDB crashes on […]

Read more

5.0.86-build19 Percona binaries

Dear Community,
As of today the 19-th build of MySQL server with Percona patches is available.
Comparing to the previous release it has following new features:

The build is based on MySQL-5.0.86
Fix from Neil Katin to userstatv2.patch
fix InnoDB slowness with large queries

Fixed bugs in the build:

Bug #413858 in Percona patches: “Crash from failed assertion in dict0dict.c”

You can […]

Read more

Finding your MySQL High-Availability solution – The definitions

As my first contribution to the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL.  I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB cluster and […]

Read more

Percona welcomes Yves Trudeau and Fernando Ipar

I’m happy to extend a warm welcome to two new members of the Percona team.
First is Yves Trudeau, about whom I can say many things:
One of the top MySQL Cluster (NDB Cluster) experts in the world.
An expert on all things High Availability, including DRBD and Heartbeat.
Many years of experience with Huge Data.
Half of the […]

Read more