Hello,
I'm new to OpenPKG, but I like what I see so far.
I've got a question about the right way to handle the following situation:
In my mysql error log, I get the following message:
Warning: setrlimit couldn't increase number of open files to more than
1024 (request: 5010)
The MySQL docs recommend that I set the ulimit in mysqld_safe. I see
the option for this in that file: --open-files. So, I figure I can
change this in etc/rc.d/rc.mysql:
49 cd /openpkg
50 /openpkg/bin/mysqld_safe >/dev/null 2>&1 51
--mysqld=mysqld 52 --open-files=6144 53 --pid-file=""
54 --err-log="" &
But it doesn't seem to do any good. I still get the same mysql error
message. My OS file limit is set much higher, and I don't have enough
open processes that they would all be used already.
An and cpu time (seconds, -t) unlimited
file size (512-blocks, -f) 390625
data seg size (kbytes, -d) 524288
stack size (kbytes, -s) 65536
core file size (512-blocks, -c) unlimited
max memory size (kbytes, -m) unlimited
locked memory (kbytes, -l) unlimited
max user processes (-u) 7390
open files (-n) 1024
virtual mem size (kbytes, -v) unlimited
sbsize (bytes, -b) unlimited shows that:
open files (-n) 6144
Does anyone have any hints as to how I can solve this problem?
BTW,
in etc/rc.d/rc.mysql:
--err-log="" &
was
--err-log="" &
Before I changed it. mysql_log_err is not defined, so I took this to
be a bug and corrected it.
My mysql version is: mysql-4.0.21-2.2.1
OpenPKG version: openpkg-2.2.0-2.2.0
Thanks,
- Dimitri
______________________________________________________________________
The OpenPKG Project www.openpkg.org
User Communication List [email protected]
