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 feeds(,

Re: Full Text Search Question

2001-04-03 Thread Antonio Gulli
-- > 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

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

2001-04-03 Thread Antonio Gulli
+--+ | Table | Op | Msg_type | Msg_text | +---+--+--+--+ | queries.keywordsn | optimize | status | OK | +---+--+--+--+ 1 row in set (11 min 26.70 sec) Antonio gulli wrote: Bob Hall wrote: >>

Re: How to have faster select?

2001-04-01 Thread Antonio Gulli
m/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.

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

2001-03-31 Thread Antonio Gulli
t looks like you only tried m >> > > > >>> 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? >>>

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

2001-03-30 Thread Antonio Gulli
low, 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 gul

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 i

Re: How to have faster select?

2001-03-29 Thread Antonio Gulli
re 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: ht

Re: mysql over nfs on netapp filer

2001-03-29 Thread Antonio Gulli
OTECTED]> > 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 575583 whois: AG2-ORG I-56126 Pisa, Italy http:

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 recove

Can't recover a bad corrupeted table...

2001-03-29 Thread Antonio gulli
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=16 keywords - check key delete