In the last episode (Nov 18), Jrgen Winqvist said:
> I'm working with an application that uses a lot of tables. Apx 50k
> tables are accessed every 5 minuts and they are openened/closed
> constantly. There is a performance problem and i've changed the
> filesystem to reiserfs for better handling ma
out this one, but
it's a though
> -Original Message-
> From: Jörgen Winqvist [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 18, 2003 11:02 AM
> To: Chris Nolan
> Cc: [EMAIL PROTECTED]
> Subject: Re: 50 000 tables - table_cache
>
>
> Hi Chris,
>
Hi Chris,
I know its not good to have that many tables but that's the way its
done. I can't see why a merge would help. It still has to open all the
tables.
regards
/jorgen
Chris Nolan wrote:
Hi!
Looking through the docs, MySQL's internals don't seem to lend
themselves well to having this
Hi!
Looking through the docs, MySQL's internals don't seem to lend
themselves well to having this many tables. Is there any chance you
could use MERGE tables to chuck a few of them together (admittedly I'm
guessing here).
Regards,
Chris
Jörgen Winqvist wrote:
I'm working with an application
I'm working with an application that uses a lot of tables. Apx 50k
tables are accessed every 5 minuts and they are openened/closed
constantly. There is a performance problem and i've changed the
filesystem to reiserfs for better handling many files. I also increased
the open-file limit in both
