My win98 is rebooting after a while which is very odd, I reckon someone from the
list has hacked people from on this list
Andrew
When I had Win'98 it would reboot twice a day. Win'98 is a garbage OS that was as stable as a 3 legged card table. No one on this list has been hacked so please don't spread those rumors. The only culprits are the twits at Microsoft who can't write a stable OS if their lives depended on it. Wouldn't it be great if every time a Windows OS crashed, or rebooted unexpectedly, instead of sending a crash report to MS that no one reads, send a small electrical shock to the programmer who wrote that procedure that caused the crash and also send a shock to Mr. Bill Gates himself. MS could also have a website where people would vote on where the electrodes would be attached. :)
Mike
>-----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 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.
>
>Regards
>
>Ian
>--
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.9.11 - Release Date: 14/04/2005
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.11 - Release Date: 14/04/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
