… who needed to reduce their database size on disk quickly without a…name as table_name, all_indexes.index_name as index_name from all_indexes left join used_indexes using (TABLE_SCHEMA, TABLE_NAME, INDEX_NAME… for your table by simply doing: mysql> alter table mytable ENGINE=Innodb; However, this…
Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!
March 4, 2013 By 7 Comments
… simply a matter of upgrading to 5.6 and running ALTER TABLE foo ENGINE=InnoDB. In theory, yes. In practice, not… looking for someone’s full name, which I knew to be present only once in the database, and I used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name…
