… Storage Engine API is called. But back to what the above strace shows. In MySQL 5.5 you can find in sql/datadict.cc a… this is used is that in the DROP TABLE code path, MySQL uses this magic byte to work out which Storage Engine to ask to drop the table. The main consequence of this bit of code is that MySQL…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…find it interesting. In many cases what I find good or bad would base of my MySQL use…one is probably a bit…table (or data which is locally stored but in random order). In my opinion this however should have been implemented outside of MySQL Storage Engine…out where which are optimized for Innodb which…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Storage engine makes a big difference In general, a column store performs about 8x-10x better than a row store for queries which access a…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… storage engine, which Innobase released at the MySQL … +—————————————-+ The _CMP tables show statistics about compression; they contain a lot of useful…tables are fully documented in the InnoDB plugin manual, along with extensive examples of how to use them to find out…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…a database isn’t owned by MySQL, you won’t have any problems until you try to create or drop a table…find evidence of problems in the server as well as the storage engine. For example, a…uses a threshold for which…
Post: MySQL Performance Engineer opening
May 13, 2008 By Leave a Comment
…findings on MySQL Performance Blog. However recently we got too busy with serving out customers and the backlog of things to take a…find the truth source code is your best friend. One should have good MySQL knowledge including main storage engines, and best have experience using…which…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…storage engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL…find out what benefits, if any, do the additional purge threads bring. The test workload makes a…table, and the InnoDB team advises using…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…Storage Engine developers showcase as one of keynotes. Today let me start with most popular transactional storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…which is large enough to contain largest record in the given table which is held until table is closed. Federated Storage Engine…which are not tuned as buffers. Watch for these especially now with many storage engines being released for MySQL…find out…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…storage engine interface Sun/MySQL spends some time to make things consistent. There should be general high level error codes which can be portable across storage engines – for example something with meaning of “Storage engine is out of resources” together with ability for storage engine…
