Percona XtraDB Storage Engine, scalling betten than innodb
From http://www.mysqlperformanceblog.com
Percona XtraDB includes all of InnoDB’s ACID-compliant design and advanced MVCC architecture, and adds features, more tunability, more metrics, more scalability on many cores, and better memory usage. We choose features and fixes based on customer requests and on our best judgment of real-world needs. We have not included all the InnoDB patches available. For example Google’s well-known InnoDB patch set is omitted (at least for now).
The first version of our new storage engine is 1.0.2-1, which is forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is InnoDB-plugin base source code. Percona XtraDB is released only under the GPL v2 with no dual-licensing, and commercial support is available from Percona.
So what’s new in the engine? Here is a list of new features and enhancements:
- INFORMATION_SCHEMA.XTRADB_ENHANCEMENTS. This table contains information about the differences between the Percona XtraDB and the same version number of standard InnoDB, so you can always learn what your engine can do. documentation
- Improvements to SHOW INNODB STATUS. We’ve added more memory information and lock information, and fixed problems with lock information. documentation
- Improvements to InnoDB IO. Improvements of InnoDB IO subsystem, such as multiple read and write threads, read-ahead control, control io capacity and adaptive checkpointing. documentation
- InnoDB RW-lock fixes Improvements to scalability for systems with 8+ cores. documentation
- Buffer pool fixes Improvements of buffer_pool scalability. documentation
- innodb_buffer_pool_pages Information about content of buffer_pool pages. documentation
That’s a thing I will try for my new Internet server 😉 let’s see if #Joomla! appreciate and MySQL span better on a quad core server.
