… Now let’s move on to the benchmarks, to see the difference….89G 1.53G Innodb_data_reads 120552 123872 100551 … scans had to be performed. As in the table above you …to MySQL 5.5 MRR clearly changes the access pattern to sequential, and hence InnoDB is able to do many read_aheads. Another thing to…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… whom the prudent move would be a migration to InnoDB, but due to their use of MyISAM FTS, the idea of a complete or partial migration was, for one reason or another…data into the table, run an OPTIMIZE or two, delete some data, and see what happens: mysql> set global innodb_ft_aux_table…
