Percona's MySQL & InnoDB performance and scalability blog
…caption id=”attachment_13334″ align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] …, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior… to take the MyISAM full-text parser code, convert it to a plugin, and use it for InnoDB FT indexes where you…
… a dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master and two… their copy of the data The important tables were all InnoDB Having a backup, customer has first attempted to restore from… all pages. Note however that only works for text in uncompressed text columns (varchar, char, text) but what if tables don’t have…
… Innodb couple of more times to see how values change: mysql> analyze table antest_innodb; +——————–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————–+———+———-+———-+ | test.antest_innodb…0.00 sec) mysql> analyze table antest_innodb; +——————–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————–+———+———-+———-+ | test.antest_innodb | analyze | status | OK | +——————–+———+———-+———-+ 1 row…
… huge innodb table with a set of TEXT fields. We’ve been trying to optimize this server before by playing with various innodb… that with DYNAMIC row format InnoDB was able to keep an entire PRIMARY index in memory (TEXT and BLOB fields are stored… down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every large TEXT field could become as small…
… way. For instance, when testing the InnoDB FT index, I made sure to increase innodb_buffer_pool_size to 50% of my… to memory was that when I tried to create an InnoDB FT index before declaring the `FTS_DOC_ID` primary key… changes. This is an important consideration for choosing a full-text solution, because updating the index can become quite complex. Solr…
… more information. But lest first start with feature request for Innodb Team: All ways I mention here are hacks and they… native support. It would be great if Innodb would implement command to preload table to Innodb buffer pool, which would simply go… in memory neither it does externally stored objects – BLOB and TEXT fields. If you would like some non PRIMARY Indexes preloaded…
… may not see a “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb policy replacement algorithm takes into account page… MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That… InnoBD handles blobs/text fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/blob in the…
… Innodb tablespace got corrupted. In such cases Innodb will typically print something like this: InnoDB: Database page corruption on disk or a failed InnoDB… you can create or drop Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error | Got…
…is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a … | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.t | optimize | note …
… to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.