EmergencyEMERGENCY? Get 24/7 Help Now!

Testing InnoDB “Barracuda” format with compression

 | April 23, 2008 |  Posted In: Insight for DBAs

New features of InnoDB – compression format and fast index creation sound so promising so I spent some time to research time and sizes on data we have on our production. The schema of one of shards is

Read More

MySQL and plugin binaries

 | April 20, 2008 |  Posted In: Insight for DBAs

It seems there is interesting problem with compatibility of MySQL binaries and binaries of third-party plugins. I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work with lastest 5.1.24-rc binaries. It was very charming move from MySQL side to release new incompatible binary on the second day after […]

Read More

Idea: Couple of more string types

 | April 18, 2008 |  Posted In: Insight for Developers

MySQL has a lot of string data types – CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it is not enough 🙂 I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and SHA1() efficiently. With […]

Read More

All thouse new MySQL Storage Engines

 | April 17, 2008 |  Posted In: Insight for DBAs

MySQL Users Conference 2008 has number of Storage Engines presented which claim to Kick Ass. Walking in exhibition hall you could see KickFire, Infobright, Tokutek, ScaleDB. I have not seen NitroDB in the exhibition call this year but they are also worth to mention. It is interesting to see all of them showing benchmarks with […]

Read More

A note about Pythian

 | April 17, 2008 |  Posted In: Events and Announcements

On Monday I had a chance to have a chat with Paul Vallee from Pythian. This was quite an enlightening talk, and I was very impressed by Paul openness and willing to share with me a lot of internal operations details. I wish there would be more people out where as open and helpful even […]

Read More

Future InnoDB File Formats

 | April 15, 2008 |  Posted In: Insight for DBAs

Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar, Kangaroo, Leopard, Moose, Nautilus, Ocelot, Porpoise, Quail, Rabbit, Shark, Tiger, Urchin, Viper, Whale, X, Y and Zebra. Aren’t there animals starting on X and Y?

Read More