I'll give you an example: I start mysqld as such:
mysqld -O max_allowed_packet=2M
This set the option. You can do it also in my.cnf:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=16M
set-varia
At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote:
>It's so easy, you won't think of it: start mysqld with parameter
>-h (=help):
>
>mysqld -h
>
>shows all parameters and current settings
Isn't that:
mysqladmin variables
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
At 6:41 PM +0200 7/9/01, Sascha Mantscheff wrote:
>Alas, it does not. It shows a couple of variable settings, but not the syntax
Something that may be of help are the sample .cnf files that are included in:
/usr/local/share/mysql/
(on my system at least)
Look for my-small.cnf, my-big.cnf, my-h
Easy as can be: for example
mysqld -O max_allowed_packet=2M
> Alas, it does not. It shows a couple of variable settings, but not the syntax
> for tha various logging options and the like. So the question for a complete
> options syntax of my.cnf remains open.
--
Herzlich
Werner Stuerenburg
Ihre Nachricht vom Monday 09 July 2001 17:10:
> It's so easy, you won't think of it: start mysqld with parameter
> -h (=help):
>
> mysqld -h
>
> shows all parameters and current settings
Alas, it does not. It shows a couple of variable settings, but not the syntax
for tha various logging options
It's so easy, you won't think of it: start mysqld with parameter
-h (=help):
mysqld -h
shows all parameters and current settings
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 4
http://www.calevans.com
*
- Original Message -
From: "Sascha Mantscheff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 09:10
Subject: Where to find options / my.cnf documentation?
> Where do I find a complete documentation of all options and entries in
Where do I find a complete documentation of all options and entries in my.cnf
and the mysqld start options? I searched the mysql.com site, but to no avail.
Neither does the online documentation doesn't seem to have a chapter on it.
s.m.
Qualimedic AG
Sascha Mant
