… important implications: when the data does not fit in the buffer pool, fast index creation provides even better performance as compared to… pages to the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb_buffer_pool_sizeset to…, a small buffer pool had a huge impact on ALTER TABLE with the optimization disabled, and absolutely no effect on the optimized case, which…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… here is to note that the InnoDB buffer pool for my 5.6 instance is 128MB…innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config; +—————————+——–+ | KEY | VALUE | +—————————+——–+ | optimize…
