Fwd: Mixing Latin and UTF

Hello, I hope that this is the right list. I have a database that has been running for years in latin1 but a software update changed it in to utf8 that would be no big deal if we know it right away so we could change the database. The big problem is that the database has been running for 2 mon

Re: Recommended swap partition size

Yeah. One of the telltale signs of something amiss is excessive swap activity. You're not going to be happy with the performance when the swap space is actually in use heavily. Kyong On Tue, Apr 13, 2010 at 8:15 PM, Dan Nelson wrote: > In the last episode (Apr 13), Joe Hammerman said: >> My organ

Re: Recommended swap partition size

In the last episode (Apr 13), Joe Hammerman said: > My organization has a dedicated MySQL server. The system has 32Gb of > memory, and is running CentOS 5.3. The default engine will be InnoDB. > Does anyone know how much space should be dedicated to swap? I say zero swap, or if for some reason y

Re: InnoDB - 16GB Data

Also, if you have read heavy workload, you might want to try using and tuning your query cache. Start off with something like 32M and incrementally tune it. You can monitor some query cache related server variables. Kyong On Sat, Apr 10, 2010 at 4:28 PM, Rob Wultsch wrote: > On Sat, Apr 10, 2010

Recommended swap partition size

Hello all, My organization has a dedicated MySQL server. The system has 32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB. Does anyone know how much space should be dedicated to swap? Thanks!

Re: difference btw Analyze and Optimize table..

Analyze table : Analyze table analyzes and stores the key distribution for a table. For more details check the below URL http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html Optimize table : OPTIMIZE TABLE is useful when we do more deleted operations on a table with variable columns. It w

Re: MySQLClient 3.x compatible with MySQL 5.x?

Yes, If it is a password problem. do a update with password=old_password('xxpasswdxx'); It will work. If you are facing any other problems, paste it. On Tue, Apr 13, 2010 at 10:37 PM, Pecas On Line wrote: > Hello, > > I need to have a MySQL 3.x client to be compatible with a new MySQL 5.x > serve

MySQL 5.5.3-m3 and MyQL 5.5.4-m4 have been released

Dear MySQL users, MySQL Server 5.5.3-m3, a new version of the popular Open Source Database Management System, has been released. We've also released MySQL Server 5.5.4-m3 for Linux on x86_64 only at this time; it contains a new version of InnoDB including several performance enhancements in comp

MySQLClient 3.x compatible with MySQL 5.x?

Hello, I need to have a MySQL 3.x client to be compatible with a new MySQL 5.x server, is it possible? What do I need to change on my MySQL 5.x server to allow old clients to work? Also, what do I need to change to allow old PHP 4.x code to talk to a MySQL 5.x server? Thanks, POL.

Re: INSERT INTO multiple tables

; >>>>>> >>>>>> >>>>>> >>>>> >>>>>> $fname=($_POST['fname']); >>>>>> $lname=($_POST['lname']); >>>>>> $street=($_POST['street']); >>>>>> $tow

Re: INSERT INTO multiple tables

#x27;zip']); >> >>> > $phone=($_POST['phone']); >> >>> > $fax=($_POST['fax']); >> >>> > $email=($_POST['email']); >> >>> > $comments=($_POST['comments']); >> >>> > $REMOTE_ADDR=$_SERVER['REMOTE_ADDR']; >> >>> > >> >>> > $dbc=mysqli_connect('localhost','root','','test'); >> >>> > $query="INSERT INTO address (street, town, state, >> >>> > zip)"."VALUES('$street','$town','$state','$zip')". >> >>> > "INSERT INTO comments(comments)"."VALUES('$comments')". >> >>> > "INSERT INTO >> >>> > contact(phone,fax,email)"."VALUES('$phone','$fax','$email')". >> >>> > "INSERT >> >>> > INTO name (fname, lname)"."VALUES('$fname','$lname')"; >> >>> > >> >>> > $result = mysqli_query($dbc, $query) >> >>> > or die('Error querying database.'); >> >>> > >> >>> > mysqli_close($dbc); >> >>> > >> >>> > ?> >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > __ Information from ESET Smart Security, version of virus >> >>> > signature database 5017 (20100411) __ >> >>> > >> >>> > The message was checked by ESET Smart Security. >> >>> > >> >>> > http://www.eset.com >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > >> >>> > -- >> >>> > MySQL General Mailing List >> >>> > For list archives: http://lists.mysql.com/mysql >> >>> > To unsubscribe: >> >>> > http://lists.mysql.com/mysql?unsub=kali...@gmail.com >> >> >> >> -- >> >> It is easy to find fault, if one has that disposition. There was once >> >> a >> >> man >> >> who, not being able to find any other fault with his coal, complained >> >> that >> >> there were too many prehistoric toads in it. >> >> -- Mark Twain, "Pudd'nhead Wilson's Calendar" >> >> >> >> __ Information from ESET Smart Security, version of virus >> >> signature database 5021 (20100412) __ >> >> >> >> The message was checked by ESET Smart Security. >> >> >> >> http://www.eset.com >> > >> > __ Information from ESET Smart Security, version of virus >> > signature database 5021 (20100412) __ >> > >> > The message was checked by ESET Smart Security. >> > >> > http://www.eset.com >> > >> > >> > >> > >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com >> > > -- > Q: What's the difference between an Irish wedding and an Irish wake? > A: One less drunk. > > __ Information from ESET Smart Security, version of virus > signature database 5023 (20100412) __ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __ Information from ESET Smart Security, version of virus signature database 5025 (20100413) __ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: INSERT INTO multiple tables

I have no idea how you got here but there is no reason to do it that way. This will work just fine and I do it every day in php. However I don't use mysqli I still use ... mysql_connect mysql_select_db mysql_real_escape_string mysql_query Don't forget to use the mysql_real_escape_string funct

RE: difference btw Analyze and Optimize table..

http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html The entire page is highly recommended due to the number of helpful information. Regards, m -Original Message- From: F.A.I.Z.A.L [mailto:sac.fai...@gmail.com] Sent: Tuesday, April 13, 2010 10:56 AM To: River wubx Cc: mysql; mysql

Re: difference btw Analyze and Optimize table..

hi River thanks for your mail. could you please tel me the correct syntax for optimize table command. i plan to put this in cronjob and execute every 8 hours in a day. optimize table tab1; is that correct or anything need to add with his statement. my environment is solaria Cheers Faizal S GS

Re: reshaping challenge

Are you quite sure there can never be more than 16 orders per ID ? The form your table is in now is actually the preferred form. It's called an associative table, and logic suggests that it sits between a table that holds more info on the IDs, and a table that holds more info on the orders. On M

Re: difference btw Analyze and Optimize table..

OPTIMIZE TABLE tablename; analyze table ,stores the key distribution for a table ,reclaim the unused space and to defragment the data file. ANALYZE TABLE tablename; This action only analyze table and stores the key distribution for a table. 2010-04-13 River wubx Gtalk: wubin...@gmail.com

difference btw Analyze and Optimize table..

hi all what is the difference between OPTIMIZE TABLE tablename; and ANALYZE TABLE tablename; thank you Cheers Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com