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]
