Buy Percona ServicesBuy Now!

A piece of Sun/MySQL Marketing

 | February 27, 2008 |  Posted In: Benchmarks, Events and Announcements

I got first Sun/MySQL Newsletter Today which among other things lead to the site publishing among other things links to various stuff related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing needs as they show sun stuff is so much cooler […]

Read More

Back to USA

 | February 14, 2008 |  Posted In: Events and Announcements

As some of you surely know already I’m moving back to USA, so does Vadim. From very beginning we had much more business from US than from rest of the world combined so this is a great step in company development having more comfortable time zones for our customers (without having to work nights) as […]

Read More

How to check MySQL Config files

 | February 12, 2008 |  Posted In: Insight for DBAs

Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching SET GLOBAL command to do it in run time) but either because option is misspelled or because given version does not support such option the server when would refuse to start […]

Read More

How Fast Can Updates Run?

 | February 11, 2008 |  Posted In: Tokutek, TokuView

Last time, I introduced the notion of strict and lenient updates. Now it’s time to see what the performance characteristics are of each. Just to rehash, we are focusing on the storage engine (a la MySQL) level, and we are looking at a database on a single disk — the one we are using for […]

Read More

MySQL Full Text Search in Action

 | February 7, 2008 |  Posted In: Insight for Developers

Preparing to move I’m selling stuff on GumTree which is UK based clone of Craigslist offering similar functionality but with Ads 🙂 Similarly to Craigslist GumTree is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for […]

Read More

MySQL 6.0 Subquery optimizations are published.

 | February 6, 2008 |  Posted In: Insight for DBAs

Sergey Petrunia brought to my attention the work Optimizer Team has done in MySQL 6.0 related to SubQuery Optimization. I am excited to see this information published honestly outlining the things which are fixed now and things which are still not handled well. According to the bug sampling done by Optimizer Team 68% of reported […]

Read More

Updates & Discipline

 | February 5, 2008 |  Posted In: Tokutek, TokuView

So far, I’ve analyzed point and range queries. Now it’s time to talk about insertions and deletions. We’ll call the combination updates. Updates come in two flavors, and today we’ll cover both. Depending on the exact settings of your database, the updates give a varying amount of feedback. For example, when a key is deleted, […]

Read More

Speaking on MySQL Users Conference 2008

 | February 3, 2008 |  Posted In: Events and Announcements

Guess what ? I also will be speaking at MySQL Users Conference 2008, which is always excited. According to session schedule I’ll have one talk about Innodb Scalability Limits and another one together with Andrew Aksenoff about Sphinx. Looking back at Proposals (+1) I’m surprised only one talk was chosen and also this particular one. […]

Read More