Setting ulimit for MySQL - Red Hat
Posted on 2007-08-07
I have the duty of installing a large PHP / MySQL application on a Red Hat server. I've almost finished, but the data to be imported is very large - and still growing. Part of the documentation told me to:
Launch the MySQL daemon with the following options:
ulimit diskspace>3GB memory>high
I have set the max allowed packet size successfully in my.cnf, but I do not know how to go about setting the ulimit as suggested. Please provide help regarding what file needs to be edited, and the command to be inserted. The table keeps growing (over 1.5 GB now) and I don't know what may happen if we get over 3 GB. MySQL version 4.1.20.
Thanks a lot