… fast stored routines are in MySQL? I just ran a quick micro-benchmark to compare the speed of a stored function against… then executing the subquery for each row: mysql> explain select ….\G *************************** 1. row *************************** id: 1 select_type: PRIMARY table: ci type: ALL possible….Code = c; > return res; > end// mysql> delimiter ; Now the query can be rewritten as this: mysql> select sql_no_cache sum(ci.Population…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
…. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index by declaring… the following statements: mysql> insert into dir_test_innodb3 (fts_doc_id, full_name) values (1, ‘john smith’); mysql> select * from dir_test… what happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb’; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from…
