Thread "Optimize tables in Mariadb"

Tabs

Functions

  • 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
     Print 
  • 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
     Print 

Functions