Hi, we have 3.23.42 official binaries running on Linux 2.4.17. It seems mysqld does not read in from /etc/my.cnf the value for net_buffer_length.
When having in the config file: [mysqld] set-variable = net_buffer_length=16M set-variable = max_allowed_packet=16M [...] I get | net_buffer_length | 1047552 | max_allowed_packet | 16776192 Another approach: [mysqld] set-variable = net_buffer_length=16776176 set-variable = max_allowed_packet=16776192 show variables reports: | max_allowed_packet | 16775168 | net_buffer_length | 1047552 It seems mysqld manipulates the numbers set in the config file and ignores somehow the net_buffer_length settings? I started to be curious, if we have to set the net_buffer_length before setting the max_allowed_packet, because of "The maximum size of one packet. The message buffer is initialised to net_buffer_length bytes, but can grow up to ...." at http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html But as you see, I already tried this but no luck. Also, the above page shows: | net_buffer_length | 16384 is that in kB ? Or was the number that low in 3.23.29a ? When trying to hope that I can first set the net_buffer_length huge and then set max_allowed_packet to it's maximum: [mysqld] set-variable = net_buffer_length=18M set-variable = max_allowed_packet=16M | net_buffer_length | 1047552 | max_allowed_packet | 16776192 So far, I'm not able to raise the net_buffer_length value in server at all. -------------------------- Regarding the client side, when I have in /etc/my.cnf or ~/.my.cnf: [client] port = 3306 socket = /tmp/mysql.sock set-variable = net_buffer_length=16M set-variable = max_allowed_packet=16M I get: $ mysqladmin variables | grep buffer No variable match for: -O 'net_buffer_length=16M' $ Any ideas what I'm doing wrong? Please Cc: me in replies. Thanks. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
