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:
Expand|Select|Wrap|Line Numbers
- mysql> SET GLOBAL key_buffer_size=4917467096;
- Query OK,0 rows affected(0.0 seconds)
Please let me know how can I change it.
Thanks,
Harita