… both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes…(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int…, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_B` ( `id` int…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… for common patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets… \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to… hot. (See my Fosdem 2013 slides for information about discarded designs and benchmarks.) First, we set long_query_time to 0…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should… base of my MySQL use with existing applications – if you design new applications which are done specially for Falcon you might… 8-16M as you need with page cache. There are design techniques though to improve page cache efficiency in this respect…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…. The interesting note Solid proposes High Availability solution for Solid Engine, which can be replacement of MySQL replication (the solution was… presented and details only available from marketing materials: NitroEDB The engine promises to handle in very fast way aggregative functions on… and read-only engine designed for DataWarehouse applications with compression rate from 10:1 to 30:1 ScaleDB The engine based on special…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… try it”. PBXT is a general purpose transactional storage engine, designed to perform well on a broad range of tasks, much… have very few configuration parameters.  Was this an intentional design decision, and do you see it creating opportunities for you… tuning parameters that are absolutely necessary, PBXT is not specifically designed to be self-tuning, because I believe that is a…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… environments. Percona XtraDB includes all of InnoDB’s ACID-compliant design and advanced MVCC architecture, and adds features, more tunability, more… small variations from standard InnoDB. Percona will improve this storage engine using our own ideas, as well as incorporate improvements specifically…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… “zero copy” design one may have streaming data from memory when it fits there. Optimizer and Execution Storage engines are not created… transaction engines have their own ! Quality Assurance Multiple storage engines are much more complicated to test. And I believe multi-storage engine use… have to deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… will not be easy to figure out which storage engine or storage engine mix is best match for you. Believe me people… I think happens with custom storage engines which are not designed to be run as core storage engines and are not match of… external search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines which are…
