…wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in testing …to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql… 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… then finally in the third installment, we’ll look at query performance. In the event that a new release of 5.6… possible to CREATE more than one at a time. If you try it, this is what happens: mysql> alter table dir_test_innodb….00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table…
