"query time" of 4294967294 with 4.0.14

2003-10-01 Thread Ask Bjørn Hansen
ime: 031001 15:39:59, # [EMAIL PROTECTED]: blaze[blaze] @ host.beep [192.168.134.111], # Query_time: 4294967294 Lock_time: 0 Rows_sent: 0 Rows_examined: 0, SELECT value, FROM options, WHERE name='max_current_crawls'; - ask -- http://www.askbjoernhansen.com/ -- MySQL General Mailin

Re: Corrupt index = mysqld freeze?

2003-08-14 Thread Ask Bjørn Hansen
database to IP addresses) you might want to consider upgrading FreeBSD to something more recent than 4.1 (unless that was a typo). 4.1 is over 3 years old. If skip-name-resolve doesn't help then it might be worthwhile to consider converting the tables to InnoDB to see if that changes anythi

get a certain element in a GROUP BY

2003-07-17 Thread Ask Bjørn Hansen
--+---+---+ In this case I wanted to get row 3 (with level 1) for group 1 for example. I think I understand why MySQL can't guess what I want in this case; how can I explain it better in SQL? :-) - ask -- http://www.askbjoernhansen.com/ -- MySQL General Mailing List For

Re: InnoDB crash report; fatal failure on restarts too!

2003-03-07 Thread Ask Bjoern Hansen
man.html#Forcing_recovery No, I will try that right away. Thank you. - ask -- ask bjoern hansen, http://www.askbjoernhansen.com/ !try; do(); - Before posting, please check: http://www.mysql.com/manual.php (the manual

InnoDB crash report; fatal failure on restarts too!

2003-03-06 Thread Ask Bjoern Hansen
y be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. 030306 16:12:18 mysqld ended -- ask bjoern hansen, http://www.askbjoernhansen.com/ !try; do();

optimization problem in where clause (f1="Foo" or f2="Foo")

2001-10-04 Thread Ask Bjoern Hansen
probably can gather from the above). What am I missing? What kind of thing can I do to make the above query go faster? Any hints would be appreciated. - ask -- ask bjoern hansen, http://ask.netcetera.dk/ !try; do(

Factory of Table and Bed Linens

2001-07-19 Thread ask
Dear Sir/Madam: We wonder if you might have the interest in importing embroidered and spray printed tablecloths and bedsheets from our owned factory in Xiamen, China. We as a manufacturer and an exporter has over 300 workers with 20 years experience of making table and bed linens using fabri