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