Full Text Search Problem
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 WHERE MATCH (agency) AGAINST ('DEPARTMENT OF COMMERCE'); It returned count(*) = 0 instead of count(*) = 6. Could you kindly advise me what did I do wrong? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Full Text Search Problem
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 WHERE MATCH (agency) AGAINST ('DEPARTMENT OF COMMERCE'); It returned count(*) = 0 instead of count(*) = 6. Could you kindly advise me what did I do wrong? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to show highly frequent words in fulltext index ?
It looks perfect. Thanks Google for myisam_ftdump, HTH Cor - Original Message - From: Sebastien Moretti sebastien.more...@unil.ch To: mysql@lists.mysql.com Sent: Thursday, April 23, 2009 5:24 PM Subject: How to show highly frequent words in fulltext index ? Hi, Is there a command to see which words are highly frequent in a fulltext index ? Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 people, else you're beloved product will go no-where. Open source, yes, but free, no way ... When it comes to free usuage, people can go to PostgreSQL or Firebird, hey, some parties might even be better off, cause those two don't need a license for commercial usuage! With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Full Text Search Problem
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 WHERE MATCH (agency) AGAINST ('DEPARTMENT OF COMMERCE'); It returned count(*) = 0 instead of count(*) = 6. Could you kindly advise me what did I do wrong? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Extending stopwords list
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 file? Will this improve results for users? Any insight is welcome. Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 step up and pay those people, else you're beloved product will go no-where. SQL Lite and PostgreSQL were both originally developed for free. Yes much of PostgreSQL is sponsored by people who now get paid to work on the product but that isn't 100% the case and it took a long way to get there. That being said, this is a good point. A team of developers are likely not to pick up MySQL unless they get paid. There are too many as good or better options that are also open source. Sincerely, Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 people, else you're beloved product will go no-where. Correct. There are multi-million dollar companies using MySQL who would lose their investment and skill set if they switched to another database. These are the ones likely willing to fund for continued development of MySQL, like the Firebird community who took up the development of the Interbase fork. There is a huge interest in MySQL and no matter what happens, it will be around for some time to come. If Oracle was smart, they should put a lot of effort into supporting it. Open source, yes, but free, no way ... When it comes to free usuage, people can go to PostgreSQL or Firebird, hey, some parties might even be better off, cause those two don't need a license for commercial usuage! I agree. They are better choices for commercial development because of the MySQL licensing policies. But no such licenses are needed for web development which is where MySQL dominates. I doubt MySQL AB makes a lot of money from licenses anyway. When was the last time you saw MySQL on a desk top? The real money is in support, just ask IBM. If Oracle dropped the licensing restrictions on MySQL altogether and charged only for support, it would put MySQL on many more desk tops and I feel they could profit from it immensely. Oracle would have a high end database and a low end database and they would end up dominating the database marketplace. It's like a manufacturer coming out with a generic no-name product to compete with its higher end product. It is done all the time in the food industry. They'd rather have the customer using their generic product than lose the customer to a competitor. Hopefully Oracle sees it that way. Just one guy's opinion. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Oracle , what else ?
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 MySQL will live on in various incarnations but I do think its glory days are over. It will be a supported but second class citizen from Oracle. I was at Innotech yesterday speaking on the open source panel (http://vimeo.com/4307197) and one of the participants stated that they were nervous about the fact that MySQL had been bought twice in the last two years. I did mention that I didn't think MySQL was going away and that Oracle is a smart company and there is a lot of mind share with MySQL. However, Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. It is estimated that MySQL AB was only doing 50M a year when they were bought by Sun. 50M a year is petty cash for Oracle. So Oracle has two choices, completely change MySQL to make it more profitable and thus alienate its main user base (small websites) or maintain it long enough to allow MySQL to kill itself. MySQL is already killing itself through the various forks that have permeated through the last 9 months. Another issue I see is the potential for mass migration from MySQL by non web applications. Yes there are a lot of them. Why? Because one way Oracle can make money from MySQL is to continue to charge for linked software against MySQL. If you are building a web app as long as your web language is open source, you are good with the GPL. However if you are building a monolithic app in say C++ you have a serious problem because the nature of the GPL guarantees that your C++ app will have to be open source. As much as a lot of us are pro Open Source the majority (by far) of the world still isn't. MySQL does have a strong following in the appliance state in this way. 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...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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...@jabber.postgresql.org Your FUD would be better posted on a Postres list with all the onging discussions on how Mysql doesn't support foreign keys, transactions, etc. Begone Postgres troll! ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Full Text Search Problem
'Words' shows in more than 50% rows will be regards as a stop words. 2009/4/24 mysupp...@asuma.com 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 WHERE MATCH (agency) AGAINST ('DEPARTMENT OF COMMERCE'); It returned count(*) = 0 instead of count(*) = 6. Could you kindly advise me what did I do wrong? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com
Re: Oracle , what else ?
--- On Fri, 24/4/09, David Sparks d...@ca.sophos.com wrote: From: David Sparks d...@ca.sophos.com Subject: Re: Oracle , what else ? To: j...@commandprompt.com j...@commandprompt.com Cc: mysql@lists.mysql.com 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 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...@jabber.postgresql.org Your FUD would be better posted on a Postres list with all the onging discussions on how Mysql doesn't support foreign keys, transactions, etc. 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. That said I do agree he's jumped in at the right time to do a bit of Postgres pushin' and pimpin' :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
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 posted doom and gloom: It will be a supported but second class citizen from Oracle. Oracle is not interested in the 1000/yr business. For the most part that is where MySQL revenue is. maintain it long enough to allow MySQL to kill itself. I would expect that MySQL in two years likely won't exist except on the most tertiary level. One more time: begone Postgres troll! Switching gears ... All said, I'm cautiously optimistic that Oracle taking over the reins to Mysql will benefit all. Mysql is the long running leader in the open source database space, and with the DB smarts of Oracle behind it I expect to see the gap between Mysql and the other open source DB servers widen, not close up. Mysql is getting better at a pace that is making the other open source DB servers irrelevant. ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Full Text Search Problem
Sorry, I don't understand your answer. Could you kindly explain in more details? Thanks, Jack --- On Fri, 4/24/09, zhu dingze mysql.li...@gmail.com wrote: From: zhu dingze mysql.li...@gmail.com Subject: Re: Full Text Search Problem To: mysupp...@asuma.com Cc: mysql@lists.mysql.com Date: Friday, April 24, 2009, 5:57 PM 'Words' shows in more than 50% rows will be regards as a stop words. 2009/4/24 mysupp...@asuma.com 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 WHERE MATCH (agency) AGAINST ('DEPARTMENT OF COMMERCE'); It returned count(*) = 0 instead of count(*) = 6. Could you kindly advise me what did I do wrong? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql.li...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
--- On Fri, 24/4/09, David Sparks d...@ca.sophos.com 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://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Index time columns?
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...
Error : Incorrect key file for table 'X'
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 --extend-check --update-state -O key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M /var/db/mysql/*/*.MYI Makes no difference, though. All the tables are unusable now (thank God for Vmware!). But obviously, I can't take it to the producton server like this (FreeBSD). Anyone any idea what's happening? Thanks, - Mark Repairing tables albatross.banned Error: Incorrect key file for table 'banned'; try to repair it error: Corrupt albatross.bridge Error: Incorrect key file for table 'bridge'; try to repair it error: Corrupt albatross.categories Error: Incorrect key file for table 'categories'; try to repair it error: Corrupt albatross.comments Error: Incorrect key file for table 'comments'; try to repair it error: Corrupt albatross.config Error: Incorrect key file for table 'config'; try to repair it error: Corrupt albatross.dict Error: Incorrect key file for table 'dict'; try to repair it error: Corrupt albatross.ecards Error: Incorrect key file for table 'ecards'; try to repair it error: Corrupt albatross.exif Error: Incorrect key file for table 'exif'; try to repair it error: Corrupt albatross.favpics Error: Incorrect key file for table 'favpics'; try to repair it error: Corrupt albatross.filetypes Error: Incorrect key file for table 'filetypes'; try to repair it error: Corrupt albatross.hit_stats Error: Incorrect key file for table 'hit_stats'; try to repair it error: Corrupt albatross.plugins Error: Incorrect key file for table 'plugins'; try to repair it error: Corrupt Etc, etc.