There are a few important tunables that you may run into like MAXUP,
  ULIMIT, and MAXLINK.  Search your http://localhost:457/ pages for
  Tunable Parameters and read about them.  The first three sections are
  the important ones.  Here's a summary:

  To view a tunable:      /etc/conf/bin/idtune -g MAXUP
  To set a tunable:       /etc/conf/bin/idtune -m MAXUP 250

  Now there are two types of tunable parameters, internet and KERNEL.

    *  internet:  parameter names are lower case
                  tunables stored in /etc/inet/dfl

    *  KERNEL:    parameter names are upper case
                  tunables are stored in /etc/conf/mtune.d
                                         /etc/conf/autotune.d

  Important ones are:                             Default Value:

    *  ULIMIT    block size of the largest file          2097151
                 listed in /etc/default/login

    *  MAXLINK   Maximum number of subdirectories           1000
                 allowed in a directory
                 changed with idtune.

    *  MAXUP     Maximum number of processes an               80
                 unprivileged user can run.
                 changed with idtune.

    *  NPROC     The maximum number of processes             400
                 possible on the system.
                 changed with idtune.

    *  SFSZLIM   Soft size limit for a user file           3FFFFFFF
       HFSZLIM   Hard size limit for a user file           3FFFFFFF

    *  SFNOLIM   Soft limit on the number of files a user opens.
       HFNOLIM   Hard limit on the number of files a user opens.

    *  NUMREGPT
    *  NUMSCOPT

    *  RSTCHOWN
    *  CONSOLE_SECURITY
    *  USER_RDTSC

    *  SHMMAX
    *  SEGKMEM_BYTES

For MySQL I have found that these are the best.

 MAXULWP 1000
 MAXUP   3000
 NPROC   6000
 SFNOLIM 2048
 HSTKLIM 0x2E000000
 SSTKLIM 0x1A000000
 HDATLIM 0x2C000000
 HVMMLIM 0x3E000000
 SVMMLIM 0x2A000000
 SCORLIM 0xA000000
 HCORLIM 0x1A000000
 SDATLIM 0x1A000000

<mschalit@pacbell.net>
gerberb@zenez.com