…a modular system where the storage engines themselves owned their own metadata. This was a… not the true limit. To find out what the actual limit… used to only get three characters after a dot in a …which is exactly the same as what I can create. That’s right folks, in MySQL 5.6 you can create a table…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… find out and then test that the ENUM limit of 65,535 has never been true (but now is in Drizzle), produce a CREATE TABLE statement that took over four minutes to execute and get a more complete view of how the Storage Engine API is… 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…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…which are done specially for Falcon you might find those aspects positive. [-] No Spinlocks Falcon does not use… one is probably a bit contradicting…data reads Unlike other storage engines which will read… out where which are optimized for Innodb which…table rebuild even though for other storage engines…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… pluggable storage engine, which Innobase released at the… | +—————————————-+ 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: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…finding 10 last queries is not fast. The good thing however you’re allowed to change table to other storage engine…Which just recreates table which should be fast. Interesting enough however what would happen if one would use storage engine for log table which…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…find out appropriate binary log position. Be careful however – cloning slave from the slave also clones inconsistences in data which…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got error -1 from storage engine…
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… Innodb table…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 is…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
…tables. Storage engines such as InnoDB also don’t have features such as midpoint insertion algorithms for cache control, so a single table…A lot of people use an RRDTool-based system, such as Cacti. Again, it doesn’t really matter which one you use…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…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…
