…storage engine, “Percona XtraDB”, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with standard… MySQL-5.1.30 installation http://www.percona.com/mysql/…storage engine, and not just a patchset? Because we are taking this as a serious project to evolve a new storage engine…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines and we… there is no way to hook it up to standard order by and group by functions so it is implemented in rather…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… of storage engines as plugins. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL… I’d like to see MySQL Scaling to large amount of CPUs for all storage engines all operation systems and all workloads. Well this… not SQL Standard compatible but help you if you’re web developer a lot. In my Early years in MySQL I have…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
…storage engine. Here is a list of enhancements: split-buffer_pool_mutex The patch splits global InnoDB buffer_pool mutex into several and…standard InnoDB the number of undo slots is fixed value. This patch expands the maximum number of undo slots to 4072 and… is compiled in into MySQL-5.1.30 RPM …
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
…MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as… query analyses patch and tools Fixing this is not trivial while staying 100% compatible to standard format as… you’re allowed to change table to other storage engine and add extra indexes as you require. Doing so…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method comes with the Galera distribution, and it…. The downside of MySQL/Galera is that it is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… ) ENGINE=MyISAM mysql> show table status like ‘bbool’ \G *************************** 1. row *************************** Name: bbool Engine: MyISAM…column for boolean flag storage in Innodb (not accounting for standard row overhead) … optimal structure both for MyISAM and Innodb tables, however it is …
Comment: Air traffic queries in InfiniDB: early alpha
November 3, 2009 By 19 Comments
…other solutions, we have the ability to interact with MySQL using the standard storage engine API. By setting vtable_mode = 2, you enable …going through the standard storage engine API. In this setting, InfiniDB does not take responsibility for aggregation and join steps, only scans and filters. …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… local disk based storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines. Fast Backup You… Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on this…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL version is getting more and more complicated. MySQL architecture has to be additionally complicated to support modular storage engines with all their interactions and…of standard MySQL distribution so it, just as MySQL Enterprise, gets significantly less testing by community than standard MySQL…
