Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 10, 2010
Reasons for run-away main Innodb Tablespace
So you’re running MySQL With innodb_file_per_table option but your ibdata1 file which holds main (or system) tablespace have grown dramatically [...]
June 8, 2010
Table locks in SHOW INNODB STATUS
Quite frequently I see people confused what table locks reported by SHOW INNODB STATUS really mean. Check this out for [...]
June 8, 2010
Making Deletions Fast, by Avoiding Disk Seeks
In my last post, I discussed how fractal tree data structures can be up to two orders of magnitude faster [...]
June 7, 2010
Performance Optimization and Six Sigma
You might be familiar with Six Sigma business management strategy which is employed by variety of the companies in relationship [...]
June 2, 2010
FlashCache: tpcc workload with FusionIO card as cache
This run is very similar what I had on Intel SSD X25-M card, but now I use FusionIO 80GB SLC [...]
June 2, 2010
PBXT in tpcc-like benchmark
Finally I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was bug with did not allow [...]
June 2, 2010
Disk seeks are evil, so let’s avoid them, pt. 3 (Deletions)
As mentioned in parts 1 and 2, having many disk seeks are bad (they slow down performance). Fractal tree data [...]
June 2, 2010
Security fixes for MySQL 4.0 and 4.1
In Percona Server security fix releases I mentioned patches for MySQL 4.0 and 4.1. I am happy to announce that [...]
June 2, 2010
Color code your performance numbers
When analyzing how good or bad response time is it is not handy to look at the averages, min or [...]
May 31, 2010
On Good Instrumentation
In so many cases troubleshooting applications I keep thinking how much more efficient things could be going if only there [...]
May 26, 2010
Percona Welcomes Justin Swanhart
Percona is pleased to officially welcome Justin Swanhart to our team of consultants. Before joining Percona, Justin worked as a [...]
May 25, 2010
FlashCache: tpcc workload
This is my last post in series on FlashCache testing when the cache is placed on Intel SSD card. This [...]
May 25, 2010
Disk seeks are evil, so let’s avoid them, pt. 2
In part 1, I discussed why having many disk seeks are bad (they slow down performance), and how fractal tree [...]
May 24, 2010
Tuning InnoDB Concurrency Tickets
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter [...]
May 23, 2010
Percona Server security fix releases
As you may know MySQL ® announced 5.0.91 and 5.1.47 with serious security fixes, so we provide binary releases of [...]
May 22, 2010
Extending Index for Innodb tables can hurt performance in a surprising way
One schema optimization we often do is extending index when there are queries which can use more key part. Typically [...]
May 20, 2010
Disk Seeks are Evil, so Let’s Avoid Them, Part 1
Disk seeks are expensive. Typically, a disk can perform no more than a few hundred seeks per second. So, any [...]
May 19, 2010
Beyond great cache hit ratio
I worked with application recently which has great memcached hit ratio – over 99% but yet still has average page [...]
May 19, 2010
A workaround for the performance problems of TEMPTABLE views
MySQL supports two different algorithms for views: the MERGE algorithm and the TEMPTABLE algorithm. These two algorithms differ greatly. A [...]
May 19, 2010
Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
Customers have always asked me to make NDB Cluster starts automatically upon startup of the servers. For the ones who [...]