From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Tue Feb 01 2005 - 02:05:14 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello.

The MySQL server can be started without a configuration file, only
with command line options. You can manually specify the location
of my.cnf file with --defaults-file=path command line option. See:
  http://dev.mysql.com/doc/mysql/en/program-options.html

sol beach <sol.beachgmail.com> wrote:
> I have inhertited this old Solaris x86 system with MYSQL installed on it.
>
> mdb:/tmp 15:38:08 [539]# uname -a
> SunOS mdb.hitbox.com 5.7 Generic_106542-24 i86pc i386 i86pc
>
> I would rate myself as an advanced novice WRT MYSQL
> To a large deree this system is running OK.
>
> However, it does seem to be smacking into the limit of 100 concurrent
> connections.
> AFAIK, no /etc/my.cnf file & no $HOME/.my.cnf file exist.
> I've looked & looked at the startup scripts & do not see any
> "--config-file" qualifier be specified.
>
> datadir=/a/mysqldata/ and there is no *cnf file in this folder either
>
> # find / -name \*cnf -ls
> 94133 3 -rw-rw---- 1 root dba 2179 Apr 9 2002
> /a/home/mysql/mysql-3.23.49/support-files/my-small.cnf
> 94134 3 -rw-rw---- 1 root dba 2464 Apr 9 2002
> /a/home/mysql/mysql-3.23.49/support-files/my-medium.cnf
> 94135 3 -rw-rw---- 1 root dba 2480 Apr 9 2002
> /a/home/mysql/mysql-3.23.49/support-files/my-large.cnf
> 94136 3 -rw-rw---- 1 root dba 2502 Apr 9 2002
> /a/home/mysql/mysql-3.23.49/support-files/my-huge.cnf
> 382629 3 -rw-r--r-- 1 root dba 2179 Nov 15 09:57
> /a/home/mysql/mysql-3.23.49/share/mysql/my-small.cnf
> 382630 3 -rw-r--r-- 1 root dba 2464 Nov 15 09:57
> /a/home/mysql/mysql-3.23.49/share/mysql/my-medium.cnf
> 382631 3 -rw-r--r-- 1 root dba 2480 Nov 15 09:57
> /a/home/mysql/mysql-3.23.49/share/mysql/my-large.cnf
> 382632 3 -rw-r--r-- 1 root dba 2502 Nov 15 09:57
> /a/home/mysql/mysql-3.23.49/share/mysql/my-huge.cnf
> 696215 7 -rw-r--r-- 1 root other 7146 Jul 11 2002
> /a/local/ssl/openssl.cnf
>
> I may be wrong but I am convinced that MYSQL is reading some file to
> acquire values for its varialbles.
> How do I identify which file it is using?
>

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __ ___ ___ ____ __
  / |/ /_ __/ __/ __ \/ / Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]