Re: Oracle , what else ?

2009-04-23 Thread Martijn Tonies
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 n

Re: How to show highly frequent words in fulltext index ?

2009-04-23 Thread Sebastien Moretti
It looks perfect. Thanks Google for "myisam_ftdump", HTH Cor - Original Message - From: "Sebastien Moretti" To: 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

Full Text Search Problem

2009-04-23 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

Full Text Search Problem

2009-04-23 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

Re: How to show highly frequent words in fulltext index ?

2009-04-23 Thread Corrado Pandiani
Yes, you can use myisam_ftdump Bye On Thu, 23 Apr 2009 17:24:09 +0200, Sebastien Moretti wrote: > 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:

replication problems

2009-04-23 Thread Duncan Hutty
I have a simple master-slave replication setup. Nothing very interesting as far as I know, both running identically configured 5.1.31 using 'mixed' replication. I have a couple of issues which I assume are related, although I suppose they might not be: 1) When the monitoring showed that slav

RE: Oracle , what else ?

2009-04-23 Thread Gabriel - IP Guys
> -Original Message- > >After MySQL bought by the java maker, > > and now Sun bought by Oracle, > > How did I miss this!? > > It seems like the little fish are getting eaten by the bigger fish. > > I understand Microsoft is now going to buy Oracle. :-) > (Sorry, just kidding) > The

Re: Oracle , what else ?

2009-04-23 Thread Joshua D. Drake
On Thu, 2009-04-23 at 08:25 +, Glyn Astill wrote: > --- On Wed, 22/4/09, Joshua D. Drake wrote: > > > >what are we gonna run as RDBMS ? > > > > How about PostgreSQL? > > > > I second that. You should all have a play with the 8.4 beta > I actually think a lot of primarily MySQL people are

Re: Oracle , what else ?

2009-04-23 Thread Yves Goergen
On 21.04.2009 18:40 CE(S)T, mos wrote: > At 08:06 AM 4/21/2009, Gilles MISSONNIER wrote: >> what are we gonna run as RDBMS ? > > It seems like the little fish are getting eaten by the bigger fish. > > I understand Microsoft is now going to buy Oracle. :-) > (Sorry, just kidding) No, that would

Re: Two "COUNT"s in one query

2009-04-23 Thread Nigel Peck
Thanks to everyone who helped me out with this, just what I needed and this is now working for me. One further question... I'm using a subquery as suggested: SELECT `Organisations`.`organisation_id`, `Organisations`.`name`, (SELECT COUNT(*) FROM `Notes__Organisations` WHERE `Notes__Organ

How to show highly frequent words in fulltext index ?

2009-04-23 Thread Sebastien Moretti
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 ?

2009-04-23 Thread Glyn Astill
--- On Wed, 22/4/09, Joshua D. Drake wrote: > From: Joshua D. Drake > Subject: Re: Oracle , what else ? > To: "Martijn Tonies" > Cc: mysql@lists.mysql.com > Date: Wednesday, 22 April, 2009, 10:45 PM > On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote: > > Hey Gilles, > > > > > > >After

Re: Mysql on Ultrasparc T2 and floating point performance

2009-04-23 Thread Andy Smith
Hi Dan, Yes, actually, I already know that parallel performance will be much improved, however, I was expecting more improvement on single threads as well, since the specs say that it takes 40 clock cycles just to access the FPU on the T1, but something like 6 clock cycles on the T2. So just fr