Bug #50425 Better defaults (key buffer, thread_cache_size)

• Submitted: 18 Jan 2010 17:42
• Modified: 18 Jan 2010 18:13
• Reporter: Olaf van der Spek (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.5.1-m2-community
• OS: Any
• CPU Architecture: Any
• Tags: qc

[18 Jan 2010 17:42] Olaf van der Spek

Description:
These defaults (no my.cnf) are so 1990s...

key buffer size = 8 m
thread cache size = 0

Could they be increased (in the source/binary, not in the .cnf)?
Key buffer to at least 64 m, maybe 256 m.
Thread cache to at least 16.

How to repeat:
-

[18 Jan 2010 18:13] Valeriy Kravchuk

Thank you for the feature request.

[19 Jan 2010 21:59] Omer Barnir

triage: this is a border line feature request / minor bug as values can be set in cnf file and the code values are just default. - setting tag to CHECKED