Error : Incorrect key file for table 'X'

2009-04-24 Thread Mark
Odd. I just painstakingly upgraded to MySQL 5.1.34, coming from 5.0.77. So, I run: "/usr/local/bin/mysql_upgrade", and get these all over the place (see below; just a few lines: the error list is too long to post in whole). So, accomodating MySQL, I run: /usr/local/bin/myisamchk --force --ex

Index time columns?

2009-04-24 Thread Cantwell, Bryan
I have a debate with someone about indexes on time columns. So I ask the community, should you put an index on a timestamp column of a table? Thanks...

Re: Oracle , what else ?

2009-04-24 Thread Glyn Astill
--- On Fri, 24/4/09, David Sparks wrote: > Mysql is getting better at a pace that is making the other > open source DB > servers irrelevant. > lol. Is that a typo? Surely you wanted to say "Mysql's bug fix list is gathering pace..." -- MySQL General Mailing List For list archives: http:/

Re: Full Text Search Problem

2009-04-24 Thread mysupport
Sorry, I don't understand your answer. Could you kindly explain in more details? Thanks, Jack --- On Fri, 4/24/09, zhu dingze wrote: From: zhu dingze Subject: Re: Full Text Search Problem To: mysupp...@asuma.com Cc: mysql@lists.mysql.com Date: Friday, April 24, 2009, 5:57

Re: Oracle , what else ?

2009-04-24 Thread David Sparks
Glyn Astill wrote: >> Begone Postgres troll! > > Oh the hostility of a scorned mysql user. Joshua has posted no more FUD > than you mysql chaps have done yourselvs over the past few days. You were > worried about the future and he's posted a few ideas of how you can > prepare. No he didn't. He p

Re: Oracle , what else ?

2009-04-24 Thread Glyn Astill
--- On Fri, 24/4/09, David Sparks wrote: > From: David Sparks > Subject: Re: Oracle , what else ? > To: "j...@commandprompt.com" > Cc: "mysql@lists.mysql.com" > Date: Friday, 24 April, 2009, 6:42 PM > Joshua D. Drake wrote: > > I would expect that MySQL in two years likely > won't exist excep

Re: Full Text Search Problem

2009-04-24 Thread zhu dingze
'Words' shows in more than 50% rows will be regards as a stop words. 2009/4/24 > Hi, > > I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency). > > 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC > ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPA

Re: Oracle , what else ?

2009-04-24 Thread David Sparks
Joshua D. Drake wrote: > I would expect that MySQL in two years likely won't exist except on the > most tertiary level. Most new projects will be developed in either > PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle). > > Sincerely, > > Joshua D. Drake > > -- > PostgreSQL - XMPP: jdr

RE: Oracle , what else ?

2009-04-24 Thread Joshua D. Drake
On Fri, 2009-04-24 at 10:56 -0400, Martin Gainty wrote: > IF MySQL returns to opensource..(presumably under Monty's benevolent > leadership) > then packages that utilise MySQL could be "for paying clients only" > > from your perspective what is the future of MySQL? Interesting question. I think M

Re: Oracle , what else ?

2009-04-24 Thread mos
At 01:44 AM 4/24/2009, Martijn Tonies wrote: Well, MySQL is open source, right? And the source is available? I'm sure a team of devs will come to the rescue. Really? What would make a group of developers wanting to develop a -database engine- for free? Some party needs to step up and pay those

Re: Oracle , what else ?

2009-04-24 Thread Joshua D. Drake
On Fri, 2009-04-24 at 08:44 +0200, Martijn Tonies wrote: > >Well, MySQL is open source, right? And the source is available? I'm sure > >a team of devs will come to the rescue. > > Really? What would make a group of developers wanting to develop > a -database engine- for free? Some party needs to

Extending stopwords list

2009-04-24 Thread Thomas Spahni
Hi I have configured MySQL to ignore stopwords from file /etc/my.stopwords. While playing around with myisam_ftdump I found that my fulltext index contains about a dozen words which are so common that they have a negative weight. Would it be a good idea to include these words in the stopwords

Full Text Search Problem

2009-04-24 Thread mysupport
Hi, I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency). 'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'. When I did a search like the following; SELECT COUNT(*) FROM article