/ Register

Join the community today
Register Now

Flush table_open_cache or not?

Discussion in 'System Administration' started by pamamolf, Sep 17, 2014.

Previous Thread Next Thread
Loading...
  1. Sep 17, 2014 #1
    pamamolf

    pamamolf Premium Member Premium Member

    3,148
    303
    83
    May 31, 2014
    Ratings:
    +542
    Local Time:
    12:28 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    Hi
    I am having about 8.000 open tables and i want to ask if it is ok and good to flush them every x hours/days or not?

    And how?

    Thanks
     
  2. Sep 17, 2014 #2
    eva2000

    eva2000 Administrator Staff Member

    37,685
    8,247
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,698
    Local Time:
    8:28 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Optimisation of MySQL is left to end user as Centmin Mod is provided as is. However, you should read Optimizing table_open_cache - MariaDB Knowledge Base to decide whether or not to flush it - which you shouldn't really do for reasons outlined in that link ;)
     
    • Like Like x 1
Previous Thread Next Thread
Loading...
..

.