I just can't do it, I tried everything - I think - as below:
mysql soft nofile 24000
mysql hard nofile 32000
su - mysql bash
and ulimit -n 5000
All did not went well.
My file-max under proc/sys is good
Can somebody please tell me what can I do to go over the 1024 limit?
Oh and I've also did it from mysql command line:
set open_files_limit = 5000;
ERROR 1238 (HY000): Variable 'open_files_limit' is a read only variable
Also rebooted the server after setting these limits, but without any help.
Any suggestion please?