EmergencyEMERGENCY? Get 24/7 Help Now!

InnoDB in self-compiled MySQL 5.1

 | September 13, 2007 |  Posted In: Insight for DBAs

If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is

and then, for example, load the dump of InnoDB from previous version:

I bet you will not notice all your […]

Read More

Query Profiling with MySQL: Bypassing caches

 | September 12, 2007 |  Posted In: Insight for Developers

Quite frequently I run into question like this “I’m using SQL_NO_CACHE but my query is still much faster second time I run it, why is that ? The answer to this question is simple – because SQL_NO_CACHE only bypasses query cache but it has no change on other caches, which are MySQL Caches – Innodb […]

Read More

Read Buffers, mmap, malloc and MySQL Performance

 | September 12, 2007 |  Posted In: Insight for DBAs

Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would expect right ? me too. Not only global user data is expected to be cached on startup but even if it is not why would you do full table scan to fetch single user information ? […]

Read More

VOIP Advice requested

 | September 10, 2007 |  Posted In: Events and Announcements

As one of my last posts about issues with hosting provider got great response and We got a lot of good advice and offers I decided to ask for advice another problem we have as we’re growing our company – organizing good phone communications. Our goals are rather simple though the fact we’re globally distributed […]

Read More

Speaking on HighLoad Conference, Moscow, Russia

 | September 3, 2007 |  Posted In: Events and Announcements

HighLoad.RU is the conference focused on Building High Performance Systems and has speakers from most of top Russian Internet companies. It is taking place in Moscow, Russia 24-25 of September and you should know a bit of Russian to attend 🙂 The conference has some international flavor though there are few people coming from other […]

Read More

Looking for High Performance MySQL Interns

 | September 2, 2007 |  Posted In: Events and Announcements

We have yet another opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to work on project of MySQL Performance research and analysis, developing and running benchmarks under our guidance, writing WhitePapers and articles. We feel this would be perfect part time position for the Computer Science student interested in High […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.