…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log…
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
February 26, 2013 By 1 Comment
… people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case… happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config…
