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 NoSQL access
- There’s an Amazon OS repository, as well as Yum and Apt repositories
- Improvements to replication, partitioning, stored procedures
- More diagnostics and tunability
- More pluggability, including pluggable authentication
In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases:
New Features
- InnoDB adaptive hash function searches can now be spread across multiple partitions (see Multiple Adaptive Hash Search Partitions. Bug fixed: #688866. (Yasufumi Kinoshita)
- Information from SHOW INNODB STATUS was made available in new status variables in InnoDB Show Status. Bug fixed:#698797.
Variable Changes
- New variable innodb_adaptive_flushing_method was added.
- New variable innodb_use_global_flush_log_at_trx_commit was added. Bug fixed: #635399. (Yasufumi Kinoshita)
- New variable log_warnings_silence replaced old variable suppress_log_warning_1592. Bug fixed: #692413. (Oleg Tsarev)
- Old variable innodb_adaptive_checkpoint was deleted. Bug fixed: #689450. (Yasufumi Kinoshita)
- Old variable innodb_flush_log_at_trx_commit_session was deleted. Bug fixed: #635399. (Yasufumi Kinoshita)
- Old variable use_global_long_query_time was deleted. (Oleg Tsarev) Bug fixed: #692415.
- Old variable innodb_ibuf_accel_rate was renamed to innodb_ibuf_merge_rate. Bug fixed: #695906 (Yasufumi Kinoshita)
- Old variable innodb_ibuf_active_contract was renamed to innodb_ibuf_active_merge. Bug fixed: #695906 (Yasufumi Kinoshita)
- Old variable enable_query_response_time_stats was renamed to query_response_time_stats. (Oleg Tsarev)
- Existing variable log_slow_verbosity had two new values added:profiling and profiling_use_getrusage. (Oleg Tsarev)
- Existing variables profiling_server and profiling_use_getrusage were merged into the Slow Query Log page. (Oleg Tsarev)
Other Changes
- Additional information was added to the LOG section of the SHOW STATUS command. Bug fixed: #693269. (Yasufumi Kinoshita)
- The SHOW PATCHES command was removed. (Vadim Tkachenko)
- The INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita)
- Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS were renamed. Bug fixed: #691777. (Yasufumi Kinoshita)
- The XtraDB version was set to 20.0. (Aleksandr Kuzminsky)
- Many InnoDB compilation warnings were fixed. Bug fixed:#695273. (Yasufumi Kinoshita)
- An Amazon OS repository was created. Bug fixed: #691996. (Aleksandr Kuzminsky)
For more information, please see the following links:
- Downloads – binary distributions and Percona Software Repositories
- Installation instructions
- Consulting, support, training, and custom development
- Release notes
- Documentation
- Developer discussion group
About the Author
Fred LinhossFred is a former Percona employee. Fred has a long history in software development and has held positions in both programming and technical management. He holds a degree in Computer Science from Virginia Tech.
Good to see the beginnings of sanity with naming conventions.
Has Percona Server implemented MySQL 5.5’s async IO and multiple buffer pools? I seem to remember reading about Percona’s reservation about the effectiveness of those features.
Yes, to both. Async I/O is really important; I don’t think anyone has commented negatively on that, have we? I do not believe that multiple buffer pools are the ultimate solution for scalability (although it is a rather time-honored approach), but it is easy to configure to use a single buffer pool, so I think it’s a win-win to have more options for different situations. I would not be surprised if one of us posts an article here someday showing a case where multiple buffer pools were a really good solution for something particular.
Dalin, actually the naming convention hasn’t changed for a long time.
why remove SHOW PATCHES command?
and how about adding innodb_check_fragmentation patch to it, i think it is very useful,thanks
Can you add Debian Squeeze support to your APT repositories ?
+1 for Debian Squeeze repositories
+1 for Debian Squeeze. (officially released now)
Agree with preceding commentators.
When should we wait version for Squeeze?
tried to install Percona server on EC2 Ubuntu Lucid and could not find repositories which contain package percona-server-server-5.5
Tried both http://repo.percona.com/apt and http://repo.percona.com/apt-rc
good news for us :),thx
Why my comment got deleted don’t know. But i have tried to make Percona-server-server 5.5.8 pakage from source for my Ubuntu Lucid and the good thing is that this build is really fast as compared to original mysql5.5 build. But will wait for stable release from percona for our website server.
Why my comment got deleted don’t know. But i have tried to make Percona-server-server 5.5.8 pakage from source for my Ubuntu Lucid and the good thing is that this build is really fast as compared to original mysql5.5 build. But will wait for stable release from percona for our website server.
good news for us
,thx
Yes there is no repositories for ubuntu which contain percona-server-server-5.5
Yes there is not repositories for ubuntu which contain percona-server-server-5.5
Tested it works well, Once Stable release is available we can start using it in production.
Great work. We are planning to use in our production.
+1 for this great work.
we have implemented in our production….it works greats thanks for this….
I Think Persona Is Much faster than MySQL 5.5.with XtraDB can be more than an order of magnitude faster, as compared to the same version of standard MySQL.And it is compatible with MYSQL. i want to know about what
is Percona XtraDB Cluster ?
POBTS offers services that help consumers buy and sell. For those looking to buy (Car, Mobile, and Electronics etc) the site offers listings of new and used. Sellers can list directly for sale to a buyer or the site can also offer to sell it with various levels of service.