Re: Two MySql servers, but very different performances for a SELECT JOIN

| | | media | 1 | media_FI_2 |1 | content_id | A | 1 | NULL | NULL | YES | BTREE | | +---+++--+-+---+-+--++--+----+-+ => Very different cardinality, and the highest cardinality is on the fast server (?)

Grant to some database question

I have a database 'DB1' and user 'user1'. How to allow this user to full access (read/write/create etc.) only to database 'DB1' and deny to other databases, including view its names? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Server AutoStart on Mac OS X 10.3.2 Panther

server when I reboot? I read that Mac OSX has /Library/StartupItems /System/Library/StartupItems & also a nice packaged 'Installer' but I am worried that my --user=mysqladm will not be configured properly with this installer. Thank you all for any help! Cheers, Tristan -- Tristan J.

CPAN - DBI & MySQL problems with make test & make install

.1/darwin-thread-multi-2level/CORE/perl.h") Running make test Make had some problems, maybe interrupted? Won't test Running make install Make had some problems, maybe interrupted? Won't install -- Tristan J. Fiedler, Ph.D. Postdoctoral Research Fellow - Walsh Laboratory NIEH

Backup & Recover Database

- -- Server version 4.0.17-standard I assume I am having a permissions problem? Any help would be appreciated. Thank you, Tristan -- [EMAIL PROTECTED] (alias) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT statement w/ Min() & Group By

how do I then select the sp_id and score associated with this evalue? Many thanks! -- Tristan J. Fiedler, Ph.D. Postdoctoral Research Fellow - Walsh Laboratory NIEHS Marine & Freshwater Biomedical Sciences Center Rosenstiel School of Marine & Atmospheric Sciences University of Miami [EMAI

mysql search

Hello, I have a field named "rights" (varchar[9]) it contains some records like "wrxwrxwrx" or "wr-w--w-x" I'd like to find all the records that contains this : "wr??" That's why I did this query : "SELECT * FROM table WHERE rights LIKE 'wr??'" and it doesn't work ! It extension, a

mysql error (help)

command is not allowed with this MySQL version" Is that command not availbale in version 3.23.49 if yes what is the alternate command for it. Would appreciate any help you can give me. Tristan - Before posting, p

Re: Running crash-me against remote M$ SQL Server

MS SQL server, so that may be an option. > > This makes sense I'll try that and let everyone know how to do it if > I can get it to work. > > Tristan 'Minty' Colgate writes: > > > The one approach that will almost certainly work is to > > install

Re: Once again... quotas...

Cheers, Ive subscribed and resent the email. On Tue, Feb 20, 2001 at 10:49:36PM -0800, Jeremy D. Zawodny wrote: > On Tue, Feb 20, 2001 at 04:19:27PM +0000, Tristan 'Minty' Colgate wrote: > > > > I have recently been asked to implement per database quotas for > >

Once again... quotas...

this is still the case could they post them to me, if it can fit in our timeframe Id be more than happy to do it. It really would be a nice feature. -- Tristan 'Minty' Colgate <[EMAIL PROTECTED]> | ICQ #645908 --- "You can get all you daily vitamins from 43 pi

Linux Thread Limit

doesn't exist Thanks, Tristan Zajonc [EMAIL PROTECTED]