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)
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
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
---BeginMessage---
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
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
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
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
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html.
Michael
Nathan Mealey wrote:
Is it
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
Is it possible to tell mysql to create the directory for a database in a
specified directory rather than in mysql's data directory?
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
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,
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
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
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
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 queries
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 indication
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
(two
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
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 there
19 matches
Mail list logo