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
> >
> > 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
is 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 |
> | Ope
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