| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jörgen Winqvist | Date: | November 18 2003 2:12pm |
| Subject: | 50 000 tables - table_cache | ||
| View as plain text | |||
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 mysql and linux but i can't increase table_cache more than 16384 tables. Any ideas? Regards - Jorgen
| Thread | ||
|---|---|---|
| • 50 000 tables - table_cache | Jörgen Winqvist | 18 Nov |
| • Re: 50 000 tables - table_cache | Chris Nolan | 18 Nov |
| • Re: 50 000 tables - table_cache | Jörgen Winqvist | 18 Nov |
| • Re: 50 000 tables - table_cache | Dan Nelson | 18 Nov |
| • RE: 50 000 tables - table_cache | Dan Greene | 18 Nov |
