Re: Query Cache

In the last episode (Aug 07), Paul DuBois said: > At 23:16 +0100 8/7/04, Terry Riley wrote: > > However, there appears to be no indication in the manual as to the > > time that a cached query remains in memory. In the absence of this > > information, is it safe to assume that a cached query remains

Re: Query Cache

At 23:16 +0100 8/7/04, Terry Riley wrote: We have the query cache turned on, and it appears to be working well. However, there appears to be no indication in the manual as to the time that a cached query remains in memory. In the absence of this information, is it safe to assume that a cached query

Re: SSH connection from a client machine - localhost works but not 127.0.0.1

On Monday 02 August 2004 22:34, James Weisensee wrote: > What does your '/etc/hosts' file contain? Sounds like > it may have the following entry: > > 127.0.0.1 localhost.localdomain > > change it to: > > 127.0.01localhost Actually, it has 127.0.0.1 localhost.localdomain localhost

Re: Query Cache

Yes, a query cache is only removed when one of it's tables is updated or the server is restarted. -Eric On Sat, 7 Aug 2004 23:16 +0100 (BST), Terry Riley <[EMAIL PROTECTED]> wrote: > We have the query cache turned on, and it appears to be working well. > > However, there appears to be no indicat

Re: Why do exists & In fail?

What version of MySQL are you using? Rhino - Original Message - From: "john sayre" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 07, 2004 6:35 PM Subject: Why do exists & In fail? > I'm trying to do some simple in or exists queries, but am getting syntax error on q

Re: Why do exists & In fail?

At 15:35 -0700 8/7/04, john sayre wrote: I'm trying to do some simple in or exists queries, but am getting syntax error on queries that appear to be correct. If I run the outside & sub queries alone, not problem. In the In subquery, if I hardcode a value, ok but this fails: SELECT * FROM eres

Why do exists & In fail?

I'm trying to do some simple in or exists queries, but am getting syntax error on queries that appear to be correct. If I run the outside & sub queries alone, not problem. In the In subquery, if I hardcode a value, ok but this fails: SELECT * FROM erestbase WHERE erestbase.id in(SELECT distin

Query Cache

We have the query cache turned on, and it appears to be working well. However, there appears to be no indication in the manual as to the time that a cached query remains in memory. In the absence of this information, is it safe to assume that a cached query remains there indefinitely, unless ei

Re: Uninstalling MySQL

On Friday 06 August 2004 19:49, [EMAIL PROTECTED] wrote: > Greetings... How do I uninstall MySQL under linux (i have Fedora Core 2)... > i will be installing a new version of it... > > I have 3.23 currently and will replace it with 4. Please Help Thanks I just did this a couple of weeks ago myself

Re: Alternate directory for database

At 13:17 -0400 8/7/04, Steven Buroff wrote: Is it possible to tell mysql to create the directory for a database in a specified directory rather than in mysql's "data" directory? No. You can create the database, then (with the server down) move it where you want it and create a symlink in the origin

Alternate directory for database

Is it possible to tell mysql to create the directory for a database in a specified directory rather than in mysql's "data" directory?

Re: how to add time to NOW() function

Or simply NOW() + INTERVAL 60 SECOND Michael [EMAIL PROTECTED] wrote: Use DATE_ADD(NOW(),INTERVAL 1 HOUR) Or DATE_ADD(NOW(),INTERVAL 60 MINUTE) Or DATE_ADD(NOW(),INTERVAL 3600 SECOND) -Original Message- From: Deepak Dhake [mailto:[EMAIL PROTECTED] Sent: Saturday, August 07, 2004 1:

Re: Install 2 parallel versions?

Yes, but there is a little more to it than separate install directories. In particular, the port, socket, and pid-file must be set differently for each server. You can find the details in the manual . Michael Nathan Mealey wrote: Is it

Install 2 parallel versions?

Is it possible to install 2 versions of MySQL, 4.0.x and 4.1.x, on the same system? Do you just have to ensure that they are installed in separate, distinct, directories? Thanks for any help/advice! Nathan -- Nathan Mealey Director of Operations Cycle-Smart, Inc. P.O. Box 1482 Northampton, MA 0

Re: Table and indexes

"A PRIMARY KEY is a unique KEY where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL will declare them so implicitly (and silently). A table can have only one PRIMARY KEY. If you don't have a PRIMARY KEY and an application asks for the PRIMARY KEY

Re: Uninstalling MySQL

--- Begin Message --- The current version was installed when I installed FEDORA 2 on my PC... I do not know what the RPMs are - Original Message - From: Michael Weiner <[EMAIL PROTECTED]> Date: Friday, August 6, 2004 8:53 pm Subject: Re: Uninstalling MySQL > On Fri, 2004-08-06 at 20:49

Re: Mixing Innodb & MyISAM tables

In article <[EMAIL PROTECTED]>, sean c peters <[EMAIL PROTECTED]> writes: > Im considering a design that mixes InnoDB and MyISAM tables. I want Innodb for > speed, etc, but i have one table where i want a column to have a FULLTEXT > index on. Thus the need for MyISAM. > Im not worried about the

Table and indexes

Is this normal to have a index like below.. As I know there is no need to have "KEY" and "UNIQUE" for a PRIMARY KEY PRIMARY KEY (`urun_id`), UNIQUE KEY `UC_urun_id` (`urun_id`), KEY `IDX_urun_urun_id` (`urun_id`), KEY `ktgr` (`ktgr`) ) TYPE=MyISAM Best Regards, Cemal Dalar a.k.a Jimmy

Re: very large HEAP-tables in 4.1.3

harrison, thanks for you mail, I think mysql uses way too much memory (overhead) to store my data. How much overhead do you think it is using? Each row is 61 bytes in geldbrief, which is *exactly* the amount needed for the datatypes you have. [...] Now if you take 61 * 2449755 (number of rows)