On Sun, Jan 11, 2009 at 9:31 PM, mos <mo...@fastmail.fm> wrote: > At 03:25 PM 1/11/2009, you wrote: >> >> On Sun, Jan 11, 2009 at 2:24 PM, mos <mo...@fastmail.fm> wrote: >> > Yesterday I decided to take the plunge and upgrade from MySQL 5.01 to >> > 5.1.30 >> > because after all, it was Saturday and what else is there to do on a >> > Saturday? >> > >> > I'm running it on XP Pro with 3gb ram and used the my.ini for very large >> > system. I decided not to tweak any of these settings except for the >> > datadir >> > and I commented out skip-networking since my old my.ini file didn't have >> > it >> > either. I'm using only MyISAM tables so skip-innodb is enabled. >> >> Why didn't you re-use your my.ini from your 5.0 system? > > I wanted to see what the default settings would do.
Well, then you're not comparing apples to apples! > I discovered the problem I'm having is the query optimization in 5.1! MYSQL > 5.01 had no problem with these queries. Then you should file a bug report against this. It sounds like you have a pretty easily reproduceable test case, and that's what they need to fix bugs. -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
