Timestamp problem.

2005-07-13 Thread Antonio Gulli
I have the following part in a schema describe feeds . | pubdate | timestamp| YES | | CURRENT_TIMESTAMP | | show create table feeds; `pubdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, when i make an INSERT INTO

Re: Can't recover a bad corrupeted table...

2001-04-03 Thread Antonio Gulli
| Msg_text | +---+--+--+--+ | queries.keywordsn | optimize | status | OK | +---+--+--+--+ 1 row in set (11 min 26.70 sec) Antonio gulli wrote: Bob Hall wrote: Hello Bob, first at all thank you for your support. Bob Hall wrote: Let m

Re: Full Text Search Question

2001-04-03 Thread Antonio Gulli
://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 -- -- Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300 [EMAIL

Re: How to have faster select?

2001-04-01 Thread Antonio Gulli
To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300 [EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 0

Re: Can't recover a bad corrupeted table...

2001-03-31 Thread Antonio Gulli
? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery

Re: Can't recover a bad corrupeted table...

2001-03-30 Thread Antonio Gulli
, and it looks like you only tried myisamchk with the -r -q option combination. Try it with just -r. If that doesn't work, try it with -o. If that doesn't work, restore from backup. Got backup? Bob Hall Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor

Can't recover a bad corrupeted table...

2001-03-29 Thread Antonio gulli
Antonio gulli wrote: Any help is appreciated Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 158 to server version: 3.23.36-log myisamchk -V myisamchk Ver 1.45 for pc-linux-gnu at i686 a) Trying a recovery. myisamchk -r -q -Osort_key_blocks

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
-- -- Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300 [EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583 whois: AG2-ORG I-56126 Pisa, Italy http://www.ideare.com net: print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"

Re: How to have faster select?

2001-03-29 Thread Antonio Gulli
quest this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -- Antonio Gulli'Ideare S.p.a tel: (+39) 050 575300 [EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
Hi, my problem is that now the second time the performance of my f740 goes down every day. i solved the prob with increasing maxfiles (no to the max for the volume). after that the cpu of the filer, which went up from 25% peak to 90% peak in 5 days, goes down again. any ideas why