Submitted by amitashok9999 on Wed, 07/03/2013 - 13:51
i changed the Key buffer size and saved it and then restarted the mysql server .
My.cnf was updated and the valse was saved as 'set-variable=key_buffer=2G'
The correct value should have been 'key_buffer= 2G
Status:
Active
Comments
Submitted by JamieCameron on Wed, 07/03/2013 - 15:19 Comment #1
Which MySQL version are you running there (as shown on the main page of the MySQL module in Virtualmin) ?
Submitted by amitashok9999 on Thu, 07/04/2013 - 04:25 Comment #2
HI ,
I am having MySQL version 5.5.27 .
Thanks Amit Ashok
Submitted by JamieCameron on Fri, 07/05/2013 - 03:42 Comment #3
I had a look at some docs, and it appears that using set-variable is actually OK for key_buffer.
For example, see http://www.mysqlab.net/knowledge/kb/detail/topic/performance/id/5114
What error message did MySQL crash with when you made this setting?
Submitted by amitashok9999 on Fri, 07/12/2013 - 08:36 Comment #4
The mysql server fails to start and the error log complaints that set variable is an unknow variable , i do not have the exact message with me. the problem is fully replica table and many people have discussed it over the net .
I was able to start my server after removing the set variable text from my.cnf.
Thanks Amit Ashok
Submitted by JamieCameron on Fri, 07/12/2013 - 21:02 Comment #5
I would be very interested to see the exact error message, as this doesn't happen on our test systems.
Also, exactly which Linux distribution and version are you running there?