List:General Discussion« Previous MessageNext Message »
From:Santiago Soares Date:February 10 2011 1:39pm
Subject:Re: High disk usage
View as plain text  
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
<santiagosoares@stripped>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
>
>
>

Thread
High disk usageSantiago Soares10 Feb
  • Re: High disk usageSantiago Soares10 Feb
    • Re: High disk usageJohnny Withers10 Feb
  • Re: High disk usageJohan De Meersman10 Feb
    • Re: High disk usageSantiago Soares10 Feb
      • Re: High disk usageSantiago Soares10 Feb
      • Re: High disk usageElizabeth Mattijsen10 Feb
Re: High disk usageSantiago Soares10 Feb