Thread "Optimize tables in Mariadb"

Tabs

  • kzimmermann
    kzimmermann | kzimmermann | 6. Nov 2018, 13:26
    Optimize tables in Mariadb
    Hello,

    our database was migrated from Mysql to Mariadb 10.1 some time ago. All tables are InnoDB. Our ILIAS version is 5.3.9.

    Is it recommended to optimize tables frequently in Mariadb? What is the best practice for this? In Mysql, we used a script with "mysqlcheck --optimize" every night.

    Best regards, Klaus
  • kzimmermann
    kzimmermann | kzimmermann | 7. Nov 2018, 12:04
    Re: Optimize tables in Mariadb
    It seems that our Mariadb is already configured to do the defragmenting automatically. Yesterday mysqltuner complained that 1 table required an "Optimize table", but today it reports 0 defragmented tables.

    Klaus