Bug #16262 All connections to DB dropped when key_buffer_size was set through mysql shell
Submitted: 6 Jan 2006 19:25 Modified: 8 Feb 2006 11:10
Reporter: Joseph Breu Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.14-Max OS:Linux (FC3)
Assigned to: CPU Architecture:Any

[6 Jan 2006 19:25] Joseph Breu 
Description:
While tuning mysql db, I set key_buffer_size to 512M through the mysql shell with the following command:

set @@global.key_buffer_size=536870912;

All 300+ connections to the server were dropped and the variable did not change.

How to repeat:
Change key buffer size at command line.
[8 Jan 2006 11:10] Valeriy Kravchuk 
Thank you for a problem report. Please, send the error log content for the appropriate period, describe your hardware (RAM size, first of all), and send the my.cnf content.
[9 Feb 2006 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".