I'm not sure I made myself clear: The problem is not disk usage, but CPU time waiting for I/O, which is very high.
Any ideas? Santiago Soares Fone: (41) 8488-0537 On Thu, Feb 10, 2011 at 11:15 AM, Santiago Soares <santiagosoa...@gmail.com>wrote: > 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 > > >