Sergei, Thom.. I am interested in seeing this thread followed through. As developers at my work have experienced similar performance issues between 3.23.x and 4. Our database is also of similar size and a full optimize has been run.
Regards, Lachlan -----Original Message----- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: Tuesday, 13 July 2004 8:11 PM To: Hickey,Thom Cc: [EMAIL PROTECTED] Subject: Re: 4.1 performance Hi! On Jul 12, Hickey,Thom wrote: > I've been comparing the performance of 4.1 with the MySQL 3.23.58 that came > with our Rocks cluster software. > > I'm finding that 4.1 is running approximately 1/3 slower (e.g. a 0.075 > second query goes to 0.100 seconds) than 3.23.58. Size of buffers, etc. > seems to have little effect. The database is fairly large with about 3 gig > spread over a half-dozen tables. The largest table has 62 million rows. What kind of queires do you run ? What does EXPLAIN show ? Are all tables ANALYZE'd ? 4.1 can use more complex query transformations and join methods that should bring more performance. Of course if the statistical data are incorrect, the optimizer cannot jugde what is "more" and what it "less", so new features may expose problems that were hidden in the old version. Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
