EmergencyEMERGENCY? Get 24/7 Help Now!

Box for some tests anyone ?

 | March 15, 2007 |  Posted In: Events and Announcements

We’d like to test few things in regards to MySQL and Innodb scalability with multiple CPUs but we seems to be short of boxes right now, all stuff we have access to is in production right now which makes it not good for benchmark. Could anyone lend us access to the box with at least […]

Read More

To UUID or not to UUID ?

 | March 13, 2007 |  Posted In: Insight for Developers

Brian recently posted an article comparing UUID and auto_increment primary keys, basically advertising to use UUID instead of primary keys. I wanted to clarify this a bit as I’ve seen it being problems in so many cases. First lets look at the benchmark – we do not have full schema specified in the article itself […]

Read More

Mail clients and Databases

 | March 13, 2007 |  Posted In: Insight for Developers

I get a lot of mail and I prefer to store it for long time if not forever. With modern hard disk sizes it should not be problem at all, but because of how mailing programs are written it causes a lot of problems. I’ve tried a lot of programs – Kmail, Evolution, Thunderbird on […]

Read More

Figuring out what limits MySQL Replication

 | March 7, 2007 |  Posted In: Insight for DBAs

Today I was cloning the master using LVM Snapshot and found it was taking quite a while to catch up, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query […]

Read More

Is it query which needs to be optimized ?

 | March 6, 2007 |  Posted In: Insight for Developers

Last few days I had a lot of a lot of questions at MySQL Performance Forum as well as from our customers regarding query optimization… which had one thing in common – It is not query which needed to be optimized. Way too frequently people design schema first and then think how the queries they […]

Read More

Power of MySQL Storage Engines

 | March 5, 2007 |  Posted In: Insight for DBAs

Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines and we can see solutions as Solid and PBXT . Plus there is Falcon storage engine being developed inside MySQL. All of these […]

Read More