Hi .. Free disk space: 32GB
Thats not the problem I guess. -Mat -----Original Message----- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Freitag, 7. März 2003 22:03 To: Mathias Berchtold Cc: [EMAIL PROTECTED] Subject: Re: MATCH / AGAINST bug/problem I you run low on temp filesystem space, mysqld will wait until disk space becomes available. Are you getting low when it appears to hang? Mathias Berchtold wrote: >MATCH / AGAINST problem/bug >======================== > >MySQL version: 4.0.11-gamma >OS : Windows 2000 SP3 > >Under some circumstances this query does never terminate. The win32 >service cannot be stopped either. > >SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST >('550') AS score FROM file as f, filesys as fs WHERE f.id = fs.fileid >HAVING score > 0 ORDER by score DESC > >mysqladmin -proc Output >=================== > >| 25850 | kb | localhost | kb | Query | 17497 | Copying to tmp table >| SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST >('2147220991') AS score FROM file | >OR >| 37522 | kb | localhost | kb | Query | 1323 | Copying to tmp table >| SELECT f.id as id, fs.name as name, MATCH (f.title,f.body) AGAINST >('550') AS score FROM file as f, | > > >Table Structure >=========== > ># ># Table structure for table `file` ># > >CREATE TABLE file ( > id int(11) NOT NULL auto_increment, > title text, > version varchar(255) default NULL, > created int(11) NOT NULL default '0', > modified int(11) default NULL, > body text, > hits int(11) NOT NULL default '0', > PRIMARY KEY (id), > KEY modified (modified), > KEY hits (hits), > KEY created (created), > FULLTEXT KEY titlebody (title,body), > FULLTEXT KEY body (body) >) TYPE=MyISAM; > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
