RE: Computer reboots during long table join

2005-04-15 Thread mos
e >-Original Message- >From: Ian Gibbons [mailto:[EMAIL PROTECTED] >Sent: 15 April 2005 16:22 >To: mos; mysql@lists.mysql.com >Subject: Re: Computer reboots during long table join > > >On 15 Apr 2005 at 9:47, mos wrote: > >> I'm running MySQL 4.1.10 on XP and I

Re: Computer reboots during long table join

2005-04-15 Thread Gleb Paharenko
Hello. I think MySQL is able to join even lager tables. We don't have enough information to make a conclusion. Searching in bugs database with version 4.1.10 and OS windows returned several similar bugs. Upgrade to the latest release (4.1.11 now) and search in the bugs database as well:

Re: Computer reboots during long table join

2005-04-15 Thread Andy Pieters
On Friday 15 April 2005 17:52, mos wrote: > 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 h

Re: Computer reboots during long table join

2005-04-15 Thread mos
At 10:21 AM 4/15/2005, Ian Gibbons wrote: 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

Re: Computer reboots during long table join

2005-04-15 Thread Frank Bax
At 11:21 AM 4/15/05, Ian Gibbons wrote: 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 t

RE: Computer reboots during long table join

2005-04-15 Thread Andrew Maynes
omputer reboots during long table join > > >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.

Re: Computer reboots during long table join

2005-04-15 Thread Ian Gibbons
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 sec