We have been using Percona 5.1.43 for sometime now and have found it to be a great MySQL Build. It includes many high performance patches, and full support for XtraDB which is a tuned InnoDB implementation.
To install painlessly, create a file called Percona.repo in your /etc/yum.repos.d directory. Add the following to the file:
[percona]
name=CentOS-$releasever – Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
gpgcheck=0
Then install using Yum or Apt.
This release includes:
Performance improvements
- Improved buffer_pool scalability
- Fast recovery
- Improved IO path
- Improved rollback segment scalability
- Separate purge thread
- Limited size of data dictionary in memory
- Increased number of concurrent write transactions (undo slots) ( up to 4000 )
- Fast checksums ( in release process )
- Support of different pagesizes ( 4K, 8K, 16K) ( in release process )
Usability / operations
- Show content of buffer_pool
- Import / export of dedicated tables
- Import / export of buffer_pool
- Transactional replication
- Show internal InnoDB data dictionary
- Show InnoDB locking/io profiling in slow.log
Post a Comment