I'm not sure I made myself clear:
The problem is not disk usage, but CPU time waiting for I/O, which is very
Fone: (41) 8488-0537
On Thu, Feb 10, 2011 at 11:15 AM, Santiago Soares
> 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:
> 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
> log-slow-queries = /var/log/mysql2-slow.log
> 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
> tmpdir = /tmp/tmpdir
> Is there anything I can do?
> Thank you.