Re: Creating / Lookup Users For Database

2009-04-23 Thread Uma Bhat
Carlos, 1) To list the users having access to a database, mysql SELECT user,host from mysql.db where db = *database_name*; In your case that would be mysql SELECT user,host from mysql.db where db = *cal*; 2) To grant access to a *NEW *user, you can use GRANT statement along with IDENTIFIED BY

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

Re: Oracle , what else ?

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

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: Two COUNTs 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

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 be

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 j...@commandprompt.com 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

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 real

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

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 sebastien.more...@unil.ch 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