Re: MySQL 5.1 queries 1000x slower than 5.0 - OPTIMIZER BUG

2009-01-11 Thread Baron Schwartz
On Sun, Jan 11, 2009 at 9:31 PM, mos wrote: > At 03:25 PM 1/11/2009, you wrote: >> >> On Sun, Jan 11, 2009 at 2:24 PM, mos 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 >> > S

Re: MySQL 5.1 queries 1000x slower than 5.0 - OPTIMIZER BUG

2009-01-11 Thread mos
At 03:25 PM 1/11/2009, you wrote: On Sun, Jan 11, 2009 at 2:24 PM, mos 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

Re: crosstab with percent change between years

2009-01-11 Thread Baron Schwartz
I would create the query as you've shown for the current year, and then the same for the previous year, and join the two, like this: select from ( ) as this_year inner join ( ) as last_year using (year, month); This is probably something a little like what you are trying to do, logically; b

Re: Lookup record with same id and match it's status

2009-01-11 Thread Baron Schwartz
You need to use a join. Specifically, a left outer join. I won't explain this in great detail; figuring out how this works can be your research topic ;) but try this: select a.id, a.from, a.to, a.message, a.insertdate, b.insertdate from messages as a left outer join messages as b on a.id = b.

Re: MySQL 5.1 queries 1000x slower than 5.0

2009-01-11 Thread Baron Schwartz
On Sun, Jan 11, 2009 at 2:24 PM, mos 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 dec

MySQL 5.1 queries 1000x slower than 5.0

2009-01-11 Thread mos
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 t

Re: VC++ 2008 / MySQL debug / Unhandled exception

2009-01-11 Thread Patrick Sherrill
I seem to recall the issue with the debug library, but don't recall the fix. Do you get the same permissions (access) error with the release library? Pat... - Original Message - From: "Miguel Cardenas" To: Sent: Saturday, January 10, 2009 10:22 AM Subject: VC++ 2008 / MySQL debug / U

RE: VC++ 2008 / MySQL debug / Unhandled exception

2009-01-11 Thread Martin Gainty
if Memory serves the LIBCMTD.lib library that you're excluding IS the MultiThreaded Library? Generally if you can run it thru debug you can get the CodeStack and InstructionPointer which will at least point to the exact location where it abended Saludos Cordiales desde EEUU!Martin