Bug #49786 Increase default table_open_cache
Submitted: 17 Dec 2009 21:50 Modified: 22 Dec 2009 7:45
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Options Severity:S5 (Performance)
Version:5.0, 5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[17 Dec 2009 21:50] Olaf van der Spek 
Description:
The default table_open_cache = 64. Isn't this way too low? It seems barely enough for a single connection. Could it be increased to a more reasonable value?

How to repeat:
-
[18 Dec 2009 4:32] Valeriy Kravchuk 
It is 400 already in MySQL 5.5. Please, check.

Maybe we can increase default for 5.0+ also, at least if it is NOT on Windows.
[18 Dec 2009 8:21] Olaf van der Spek 
Haven't tried 5.5 yet. Why can't Windows have a proper table open cache?
[21 Dec 2009 23:53] Olaf van der Spek 
Why?

-Status:               Verified
+Status:               Closed
[22 Dec 2009 7:45] Valeriy Kravchuk 
Let me quote private comment from development:

"Fixed in 5.5 will not be changed in 5.1"