Tag - Percona Server for MySQL

Percona Server for MySQL® is a free, fully compatible, enhanced, open source drop-in replacement for MySQL that provides superior performance, scalability and instrumentation. With over 3,000,000 downloads, Percona Server’s self-tuning algorithms and support for extremely high-performance hardware delivers excellent performance and reliability.

Percona Server wins ‘Top Innovator in SQL Technologies’ award!

Percona Server Wins Developer Week 2013 Award; Named Top Innovator in SQL Technologies Category
Percona Server has won a 2013 DeveloperWeek Best of Tech award, being named Top Innovator in the SQL Technologies category!
We’re proud to accept this award, which is determined by a combination of peer voting and review from an independent panel of […]

Read more

Announcing Percona Server 5.5.28-29.3

Percona is glad to announce the release of Percona Server 5.5.28-29.3 on January 8th, 2012 (Downloads are available here and from the Percona Software Repositories).
Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.3 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Read more

Vote for Percona Server in the 2013 DeveloperWeek Awards

Are you a fan of Percona Server? You can show your support by casting a vote for Percona Server in the SQL Technologies Top Innovator 2013 category of the DeveloperWeek Awards.
You can vote through January 7, and voting is easy. Just login, select Percona from the alphabetical list, and cast your vote
Why bother to […]

Read more

Is there room for more MySQL IO Optimization?

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, […]

Read more

Optimizing slow web pages with mk-query-digest

I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This time I’d like to […]

Read more

Percona Server 5.5.8 Beta Release

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights:

Performance and scalability improvements throughout the server and storage engine
Optimizations for flash storage such as SSD, Virident, and FusionIO
Optimizations for cloud computing
The HandlerSocket plugin for […]

Read more

Different flavors of InnoDB flushing

In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size, like 13GB, 52GB, and 144GB, for testing the tpcc-mysql database with size 100G. This was needed in order to test different memory/dataset size ratios. But why is it important, and how does it affect how InnoDB […]

Read more

Percona Server 5.1.54-12.5

Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version.
Functionality Added or Changed

Percona Server 5.1.54-12.5 is based on MySQL 5.1.54.
New Features Added: None
Other Changes:

Added system variable innodb_log_block_size and new value “keep_average” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita)
Added new value “ALL_O_DIRECT” to […]

Read more

Percona Server Fast-Restart White Paper Posted

I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down and restarting or rebooting the server, it can be back to full performance in a couple of minutes. That’s minutes, not hours or days. This matters a lot for keeping uptime […]

Read more