June 20, 2013

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(title, body) AGAINST (‘arizona business recordsINto its MyISAM counterpart, and what kinds of tricks can we use to make it go faster? Stay tuned to find

Post: Choosing proper innodb_log_file_size

in case of MySQL crash or power failure it may take long time before MySQL Server is operational again. So how to findto find log records which only have been applied in memory and do not exist in tablespace. Log records for modifications which did not make it to