Do you queries stay stuck in any particular status? (Writing to net, Opening/Closing tables, Copying to temp table?) What kind of disk sub system do you have? What other hardware do you have? What is the primary engine type?
JW On Thu, Feb 10, 2011 at 7:39 AM, Santiago Soares <santiagosoa...@gmail.com>wrote: > 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 > > > > > > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net
