Hi Pete, Thanks for the answer, I will search a bit better in the MySQL manual for info about the .cnf files.. (Already did, but couldn't 123 found the information you gave me.)
What I understand is that changing the packet size doesn't have a very negative impact, sounds that it works as a protection against faulty query strings.. Thanks for the tip, I am going to play a bit with the configuration file. On the moment I don't have any cnf file, someone pointed me to the directory it should be in, but I already did a 'locate my.cnf' on my unix box, and there wasn't any file on the whole disc... The values used now are in between the my-medium and my-small files.. Maybe it wouldn't be bad to try the my-medium. The memory on my machine allows it, and MySQL is used very intensively. I do thought like to leave things that work well alone, but I will try and see what happens.. Thanks for the help and info.. With kind regards, David Bouw > If your default settings are working fine I suggest you only include > the "max_allowed_packet" variable in your my.cnf > > [mysqld] > set-variable = max_allowed_packet=2M > > >>>My question is what is the disadvantage when I change the >>>max-packet-size > (to a higher value)?<< > > From the manual > > a.. max_allowed_packet The maximum size of one packet. The message > buffer is initialised to net_buffer_length bytes, but can grow up to > max_allowed_packet bytes when needed. This value by default is small, > to catch big (possibly wrong) packets. You must increase this value if > you are using big BLOB columns. It should be as big as the biggest BLOB > you want to use. The protocol limits for max_allowed_packet is 16M in > MySQL 3.23 and 2G in MySQL 4.0. > > > > Pete Kelly > TrafficG.com > > > > > > ----- Original Message ----- > From: "David Bouw" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 09, 2002 9:55 AM > Subject: My.cnf and large packet size.. > > >> Hi, >> >> I am not sure on the following question and hope someone can spare >> some time to answer it: Due to the fact that I had problems storing a > relatively >> huge text string (> 1 Megabyte) with PHP I found out that (by >> default???) MySQL has a packet size limitation which prevented me from >> doing this.. >> >> Searching through some mailling lists, I found out you can alter the >> max packet size in my.cnf. >> >> Problem is that I don't have a my.cnf file, I did see that there are >> some ready-to-use files for various kinds of 'machines'. I also looked >> at these files. My question is what is the disadvantage when I change >> the > max-packet- >> size (to a higher value)? >> >> Also, will there be a lot of changes when I copy a configuration file >> to my.cnf. We use MySQL very intensively. (I now have 10 million >> queries in 8 days!). The database runs on a pentium III - 700 with 128 >> Megabyte (if meminfo is right - I thought it was a 256 Megabyte >> machine). >> >> I will probably use my-medium.cnf, Mysql (3.23.43) runs with Apache + >> PHP on the same machine.. >> >> Thanks for any help or pointers.. >> >> With kind regards, >> David >> >> >> >> --------------------------------------------------------------------- >> 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 --------------------------------------------------------------------- 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
