June 18, 2013

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… never had a full-text index on it, and then I create one, the following warning is generated: mysql> alter table dir_test… like case-sensitivity in my table or column names to begin with (I may be one of the few people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case-sensitivity only matters…

Post: What to tune in MySQL Server after installation

lower but still at least 16-32Mb so it is large enough to accommodate indexes for temporary tables which are created… Innodb tables. Innodb tables are much more sensitive to buffer size compared to MyISAM. MyISAM… as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data …