Sefan, Stefan Hinz wrote:
Richard,Yikes!!! I knew that running "default configuration" gave you SOME values, but I didn't know they were so small. I've placed the my-medium.cnf as "my.cnf" in /etc on the Sparc 20, and also in C:\ on the W2K machine. Database access is much improved on both.
Hmmmm. On the solaris machines (both), there is currently NO "my.cnf"
file anywhere, yet MySQL has been working "just fine". I imagine default values are being used for everything. I'll have to select one of the .cnf files from "support-files". I'll let you know how it works.
set-variable = max_allowed_packet=16M
If this variable isn't set, the communication buffer (between client and server) is just 1 MB big. This is a common source of problems, especially when you are using extended inserts (i.e. INSERT ... VALUES (...),(...),(...)) like mysqldump would produce with the --opt option.
Now, if people would get off the production server so I could restart MySQL... <G>
Cheers,
-Richard
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
[filter fodder: sql, mysql, query]
--------------------------------------------------------------------- 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