When I try to change the key_buffer_size to 4GB, it doesnt get effective. I don’t see the key_buffer_size changing to 4GB. I am not sure why it doesnt get changed.
Here is the command that I followed from this forum:
mysql> SET GLOBAL key_buffer_size=4917467096;
Query OK,0 rows affected(0.0 seconds)
After this if I say show variables like “key_buffer_size”, it gives me the old number as 8388600.
Please let me know how can I change it.