Dim, To provide optimal my.cnf we should know your workload and server characteristics. And what is much worse – can you show some numbers ?
Post: InnoDB Full-text Search in MySQL 5.6 (part 1)
… likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that … +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1028261 | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count | | | optimize_start_time | | | optimize…

