View Single Post
  #4   (View Single Post)  
Old 22nd May 2008
TerryP's Avatar
TerryP TerryP is offline
Arp Constable
 
Join Date: May 2008
Location: USofA
Posts: 1,547
Default

I can't say I'm very smart on login.conf but, su allows you to define the login class used when called as root. For example, on my test machine I start mysqld by executing the following:

Code:
su -c _mysql root -c '/usr/local/bin/mysqld_safe >/dev/null 2>&1 &'

Where _mysql is the login class, root is the user to launch it initially and the second -c is passed onto /bin/sh along with it's arguments.


You might find it a useful trick. Although I've never tried to push the limits I've had no probs; here is the login.conf entry for good measure:

Code:
#
# This class is used when running MySQL from /etc/rc.local
# XXX: It will *N_O_T* be used when starting/stopping mysqld manually!!
#
_mysql:\
        :ignorenologin:\
        :datasize=infinity:\
        :maxproc=infinity:\
        :openfiles=3580:\       # I've set this to sysctl::kern.maxfiles
        :stacksize-cur=8M:\
        :localcipher=blowfish,8:\
        :tc=daemon:
footnote: it's running off an OpenBSD 4.3 machine
__________________
My Journal

Thou shalt check the array bounds of all strings (indeed, all arrays), for surely where thou typest ``foo'' someone someday shall type ``supercalifragilisticexpialidocious''.
Reply With Quote