EmergencyEMERGENCY? Get 24/7 Help Now!

Joining Peter for MySQL Consulting

 | September 4, 2006 |  Posted In: Events and Announcements

Starting September I’m leaving MySQL to partner with Peter on practice as well as work with him on some Web projects. I really enjoyed working under Peter’s guidance while working for MySQL and it is great we now can work together as a partners. I thanks MySQL for two great years I had. I also […]

Read More

Even minor upgrades are not always safe

 | September 4, 2006 |  Posted In: Insight for DBAs

I already wrote couple of weeks ago I keep most of my systems on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do not want to likely loose a bit of performance and possibly deal with new bugs and changes introduced in MySQL 5.0 (You never know where […]

Read More

MySQL ORDER BY LIMIT Performance Optimization

 | September 1, 2006 |  Posted In: Insight for Developers

Suboptimal MySQL ORDER BY  implementation, especially together with LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems. MySQL ORDER BY with LIMIT is most common use of ORDER BY in interactive applications with large data sets being sorted. On many […]

Read More

MySQL wins C’T Database Contest

 | August 29, 2006 |  Posted In: Benchmarks, Events and Announcements

Today MySQL published the press release with results of Database Contest (results on German available here http://www.mysql.de/ct-dbcontest). Peter and me spent quite some time working on this project while being employed by MySQL and it is great to see results finally publicly available. The story began about year ago when C’T magazine had called for […]

Read More

Watch out for Marketing benchmarks

 | August 23, 2006 |  Posted In: Benchmarks

Whenever I see benchmark results I try to understand if it is technical benchmark – made by people seeking the truth or it is done by Marketing department to wash your brains. Watch out. Whenever you treat marketing benchmarks as technical ones, you make make wrong decision. Take a look at MySQL 5.0 Benchmarks Whitepaper […]

Read More

Using LVM for MySQL Backup and Replication Setup

 | August 21, 2006 |  Posted In: Insight for DBAs

If someone asks me about MySQL Backup advice my first question would be if they have LVM installed or have some systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would work as well. What is really needed is ability to create atomic snapshot […]

Read More

MySQL Performance Forum: Hot Topics

 | August 18, 2006 |  Posted In: Events and Announcements

As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance discussions as it names says. I spend planty of time replying questions and thought it would be good idea to provide weekly overviews of most interesting topic discussed. Here is the list for last week: Ways to perform full […]

Read More

SysBench – benchmark tool

 | August 18, 2006 |  Posted In: Benchmarks

Sysbench is benchmark developed by Alexey Kopytov (software engineer @ MySQL AB) – http://sysbench.sourceforge.net/ and I want to write a short intro about this tool as sysbench is one of software for my everyday use. For example, SUN published their Solaris vs RedHat stuff based on sysbench’s results (Peter and me provided performance consutling for […]

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.