Buy Percona ServicesBuy Now!

RAID and Scale Out Discussions

 | June 12, 2007 |  Posted In: Hardware and Storage

Just found this wonderful summary of articles by Jeremy and wanted to give some of my thoughts on the topic. First lets speak about death of the RAID. I think this is far from the case especially if you consider Software RAID here. For many workloads you would like to get RAID just for the […]

Read More

MySQL 4 to MySQL 5 Upgrade performance regressions

 | June 6, 2007 |  Posted In: Insight for DBAs

This week I already had two serious performance regression cases when upgrading from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to generally fatter code. The problem in both cases was MySQL 5.0 broken group commit bug. First […]

Read More

Microslow patch for 5.0.37

 | June 6, 2007 |  Posted In: Insight for DBAs

Just short message that patch enables microsecond resolution in slow-log (see more https://www.percona.com/blog/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.percona.com/blog/files/patches/patch.slow-micro.5.0.37.diff The patch for 5.0.41 : www.percona.com/blog/files/patches/patch.slow-micro.5.0.41.diff

Read More

MySQL Slow query log in the table

 | May 31, 2007 |  Posted In: Insight for DBAs

As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. We rarely would use this feature as it is incompatible with our slow query analyses patch and tools Fixing this is not trivial while staying 100% compatible to standard format as TIME […]

Read More

MySQL – to use or not to use

 | May 28, 2007 |  Posted In: Insight for DBAs

Reading this slashdot article today and two CIO magazine articles linked from it. Such discussions started at right place at right time always attract a lot of flamers and can be fun to read. What hit me this time is quality of the articles in CIO magazine. If this is what managers suppose to use […]

Read More

Predicting how long data load would take

 | May 24, 2007 |  Posted In: Insight for DBAs

I had this question asked many times during last week, and there is really no easy answer. There are just way too many variables to consider especially while loading large schemas with a lot of different table structures. So which variables affect the load speed: Table Structure This one is tricky. The shorter rows you […]

Read More

MySQL Geek Job Openings

 | May 24, 2007 |  Posted In: Events and Announcements

The consulting load keeps increasing so we’re looking for some help. This job would be perfect for someone interested in high performance and scaling with decent knowledge of MySQL and eagerness to learn more. We do encourage people from all countries to apply.

Read More

Percona’s widely read Percona Database 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.