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 Thu, Feb 10, 201
FWIW, I've found MySQL information_schema related features to be quite useless
when you're dealing with that many tables. Not only do they take long, they
also activate a lot of locks (or so it seems). So I created a script that runs
every minute on each db server that basically does an "ls" i
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 the application runs a lot of 's
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?
Santiago Soares
Fone:
On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares
wrote:
> 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).
>
That's quite a
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
wrote:
> I'm not su
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. This database is c
