Re: shall i jump from 5.1 to 5.5

I've been running some bench marking between 5.1 and 5.5 myself and haven't notice any huge performance improvements on 5.5. Even though white papers claim it put performs 5.1. Any noticing the same or have some input in my findings? Regards, Alvin On Aug 16, 2011, at 3:55 PM, Prabhat Kumar

RE: shall i jump from 5.1 to 5.5

suggestions, anything I should change on the 5.5 server? The hardware and OS is identical from the 5.1 server. Thanks! Alvin Ramos From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J. Wang Sent: Tuesday, August 16, 2011 4:08 PM To: Alvin Ramos Cc: Prabhat Kumar; Reindl

Re: shall i jump from 5.1 to 5.5

Thanks for the suggestions. I will change the tables to in innodb and change my php coding. Then I will revisit the benchmarking with hopefully improving results. Thanks again! Regards, Alvin On Aug 16, 2011, at 7:57 PM, Johnny Withers joh...@pixelated.net wrote: This is a poor benchmark

queries take too many time

was going on. Under the column State I saw the value copying to tmp table which lasted a good 6 seconds. So I'm thinking that the copying to tmp table is slowing down the query - but I don't know why. I think I'm not the only one. Anyone can help me? -- Best regards, Alvin

VB Application using myODBC?

to connection and open the database for mySQL using myODBC?? I have already setup myODBC and tested the data source. It works! :P Please help! Thanks! alvin - Before posting, please check: http://www.mysql.com/manual.php

ODBC for VB application

to the Access database. Can anyone please advise how i could go abt it and what are the things i should look out for? Can i just install myODBC and export Access database to mySQL? Not sure how to do that too... Please help! Alvin

Installation problem

informations, pls let me know. Thanks. Alvin - 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

Re: Best way to generate laser-printed reports from mysql

ooking to see if there is any Perl modules/Bundles/Packages for generating postscript reports. What I have found is fairly primative. Does anybody have any suggestions?? -- Alvin Starr || voice: (416)585-9971 Interlink Connectivity

Re: FW: potential vulnerability of mysqld running with root privileges

p://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 -- Alvin Starr || v