EmergencyEMERGENCY? Get 24/7 Help Now!

On Good Instrumentation

 | May 31, 2010 |  Posted In: Insight for Developers, MySQL

In so many cases troubleshooting applications I keep thinking how much more efficient things could be going if only there would be a good instrumentation available. Most of applications out there have very little code to help understand what is going on and if it is there it is frequently looking at some metrics which […]

Read More

Percona Welcomes Justin Swanhart

 | May 26, 2010 |  Posted In: Events and Announcements, MySQL

Percona is pleased to officially welcome Justin Swanhart to our team of consultants. Before joining Percona, Justin worked as a MySQL DBA at Gazillion, Yahoo, and Kickfire. Justin has become a regular contributor here on the MySQL Performance Blog as well as being an active blogger at http://swanhart.livejournal.com/. He is very active in the community, […]

Read More

FlashCache: tpcc workload

 | May 25, 2010 |  Posted In: Benchmarks, MySQL

This is my last post in series on FlashCache testing when the cache is placed on Intel SSD card. This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data) on Dell PowerEdge R900 with 32GB of RAM, 22GB allocated for buffer pool and I put 70GB on FlashCache partition […]

Read More

Disk seeks are evil, so let’s avoid them, pt. 2

 | May 25, 2010 |  Posted In: Tokutek, TokuView

In part 1, I discussed why having many disk seeks are bad (they slow down performance), and how fractal tree data structures minimize disk seeks on ad-hoc insertions, whereas B-trees practically guarantee that disk seeks are performed on ad-hoc insertions. As a result, fractal tree data structures can insert data up to two orders of […]

Read More

Tuning InnoDB Concurrency Tickets

 | May 24, 2010 |  Posted In: Benchmarks, Insight for DBAs, MySQL

InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB concurrently is determined by the innodb_thread_concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the number of threads has already reached the concurrency limit. When a thread […]

Read More

Percona Server security fix releases

 | May 23, 2010 |  Posted In: MySQL, Percona Software

As you may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of Percona Server 5.0 and Percona Server / XtraDB 5.1 with security patches. Fixed bugs: Bug#53371, CVE-2010-1848 Bug#53237, CVE-2010-1850 Bug#50974, CVE-2010-1849 Release Percona Server 5.0.91-rel22 is available in our download area: https://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2 […]

Read More

Disk Seeks are Evil, so Let’s Avoid Them, Part 1

 | May 20, 2010 |  Posted In: Tokutek, TokuView

Disk seeks are expensive. Typically, a disk can perform no more than a few hundred seeks per second. So, any database operation that induces a disk seek is going to be slow, perhaps unacceptably slow. Adding disks can sometimes help performance, but that approach is expensive, adds complexity, and anyhow minimizing the disk seeks helps […]

Read More

Beyond great cache hit ratio

 | May 19, 2010 |  Posted In: Insight for DBAs, MySQL

I worked with application recently which has great memcached hit ratio – over 99% but yet still has average page response time over 500ms. Reason ? There are hundreds memcached gets and even though they have some 0.4ms response time they add up to add hundreds of ms to the total response time.

Read More

A workaround for the performance problems of TEMPTABLE views

 | May 19, 2010 |  Posted In: Insight for Developers, MySQL

MySQL supports two different algorithms for views: the MERGE algorithm and the TEMPTABLE algorithm. These two algorithms differ greatly. A view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over TEMPTABLE views. A view which uses the TEMPTABLE algorithm will have to compute the […]

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.