Thank you for your answers.
They are all in the same schema, the file system is ext3.
I cannot modify the app so it uses a table of table names, instead of show
tables.
I'll try a renice on the mysql process, so it doesn't kill the server.
Santiago Soares
Fone: (41) 8488-0537
On T
By the way, the 'show tables' commands get stuck in the 'checking
permissions' state.
Santiago Soares
Fone: (41) 8488-0537
On Thu, Feb 10, 2011 at 4:48 PM, Santiago Soares
wrote:
> Hello, thanks for your answers.
> All of my tables are MyISAM.
> I found out that
Hello, thanks for your answers.
All of my tables are MyISAM.
I found out that the application runs a lot of 'show tables' commands.
These commands take a lot of time to run, due to the high number of tables
(~160k).
Is there anything I can do to make 'show tables' run faster?
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
wrote:
> Hello,
>
> We have a database with about 160k tables. Th
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
; try to repair it
Server load increases a lot, and MySQL eventually crashes.
My question is: how can I find out what query is using so much tmpdir space?
How much space should I allocate to this disk?
Santiago Soares
Fone: (41) 8488-0537