On 15 Apr 2005 at 9:47, mos wrote:
> I'm running MySQL 4.1.10 on XP and I was doing a 2 table equi join join on
> a date field that was indexed. There are It was taking quite a long time so
> I let it run overnight. There are 200 million rows in the first table, but
> a Where clause on the second table would have reduced this to around 50
> million rows. This morning I got in and the computer had rebooted itself
> sometime during the night. (This is usually not a good sign before the
> first cup of coffee.<g>)
>
> There were no errors in the MySQL.Err log file. Explain said they were
> using an index for both tables.
>
> 1) Can MySQL join two tables of this size?
> 2) Is there a problem using a Date join? I noticed before doing date joins
> was extremely slow, even when indexed.
> 3) Is throwing more RAM at the problem going to help? Is there any way of
> knowing how much RAM is enough?
Hi,
The first thing to do is turn off that anoying XP *feature* of rebooting when there is
an error - most of the time you don't need it.
I think the option is in My Computer > Properties somewhere.
Mysql may get a chance to print an error message then, or it will be displayed on
screen.
Ian, Good suggestion but the auto reboot feature is already disabled.
I found out what the problem was. The computer rebooted at 3AM. I checked the event log and good old MS auto installed updates at 3AM every day. I NEVER have this option turned on but somehow something turned it on. Good old @#$!@ MS *hit hit the windshield of life yet again. Maybe I need bigger wipers.<g>
Mike
Regards
Ian --
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
