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 >-----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]
