Hello, We have a database with about 160k tables. This database is causing very high disk usage. I'd like to know if there is anything we can do to optimize the database, in order to reduce disk usage.
With a show global status I see a strange behavior: | Open_files | 286 | | Opened_files | 1050743 | At this time the database has just started (about 10 minutes). Here is our my.cnf: [mysqld2] socket=/var/lib/mysql/mysql2.sock port = 3306 bind-address = 172.31.235.52 pid-file = /var/lib/mysql/mysql2.pid datadir = /var/lib/mysql/DB2 language = /usr/share/mysql/english user=mysql old_passwords=1 log-slow-queries = /var/log/mysql2-slow.log innodb_file_per_table query_cache_size = 128M join_buffer_size = 3M tmp_table_size = 256M max_heap_table_size = 256M thread_cache_size = 4 table_cache = 6608 innodb_buffer_pool_size = 2G long_query_time = 10 log-error=/var/log/mysqld2.log tmpdir = /tmp/tmpdir Is there anything I can do? Thank you. Santiago