there is a mysql 5.6 server with innodb tables, there is a table with a full-text index and a 1GB volume. After the table passed for 1GB, the search slowed down dramatically as the size of the innodb_pool is just 1GB. And apparently the table does not fit completely and work begins with the disk. Will splitting the table into partitions help? For example, split by the criterion of the year of creation?

  • 2
    Transfer this task to tools designed for full-text search - vp_arth
  • This will complicate the decision and plus, this table has too much live content ..... many updates ... - yavafree

0