For best performance, you would want to have all your indexes stored
in RAM, certainly. Generally true of databases.
However, you do not have to have enough RAM to keep the indexes loaded.
You can configure MySQL to use as much RAM as is appropriate for your
machine. The online manual has som
Nobody to explain me that?
From: "mel list_php" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: mysql index cardinality
Date: Fri, 25 Feb 2005 16:47:12 +
Hi,
A strange thing with index, I thought the cardinality was automatically
updated (like for a primary key for exemple).
When I use
On Mon, Sep 29, 2003 at 09:14:06PM -0700, Kevin wrote:
>
> I suspect it uses some algorithm to 'guess' the number of rows, and this
> usually gives a lower number to bigger indicies?
Did ANALYZE table help at all?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMA
On Wed, Jul 16, 2003 at 03:49:51PM -0700, Cory Lamle wrote:
> Contents are Direct Alliance Corporation CONFIDENTIAL
> -
> I have a table with 10 cols. 8 of which all need to be searched on
> independently of each other.
>
> Does creating 8 separate indexes for that table affect the speed of how
>
In the last episode (Apr 04), Dan Rossi said:
> Create a compound index on either (time, source_ip) or (source_ip,
> time). Mysql cannot use two indexes on one table.
>
> woah what are you saying here , that it cant have multiple indexes
> within a table ?
You can; MySQL will only use one per ta
[EMAIL PROTECTED]
Subject: Re: MySQL index fun
In the last episode (Apr 03), Steve Phillips said:
> I have a table for ip data that i need to index to suit the following
> query
>
> SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time >
> 1049108400 AND time <
In the last episode (Apr 03), Steve Phillips said:
> I have a table for ip data that i need to index to suit the following
> query
>
> SELECT time,source_ip,bytes FROM data.tb_ipdata_0403 WHERE (time >
> 1049108400 AND time < 1051786799) AND (source_ip > 3389268097 AND
> source_ip < 3389268099)
>
Taylor,
Thursday, May 16, 2002, 4:22:37 PM, you wrote:
TL> Regarding mysql...
TL> 1) Are primary keys and foreign keys by default indexes for a table?
Yeah. Primary key is index by default. Foreign key constraints you can create only
on indexed column.
TL> 2) Do I have to use a special data oth
>From my understanding primary keys and foreign keys are indexed. Someone
correct me if I'mwrong here. And you shouldn't have to do anything else to field
besides
make it a float to usenegative numbers.
-Nick
>
Regarding mysql...
> 1) Are primary keys and foreign
keys by default indexes for a t
Specifying it as a primary key (or a key of any kind) is analogous to
creating an index. So you are already indexing them explicitly.
Cal
http://www.calevans.com
-Original Message-
From: Gorantla, Aruna [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 21, 2001 9:47 AM
To: '[EMAIL P
It's indexed..
if you create a table like so:
create table planner(
id integer not null auto_increment,
tstamp timestamp,
uid integer not null,
db_id integer not null,
vendor bool not null default 0,
list bool not null default 0,
companylist
"Gorantla, Aruna" wrote:
>
> Hi,
> I would like to know whether the primary keys are automatically indexed in
> MySQL or do you have to index them explicitly?
>
> Thanks in advance,
> Aruna.
>
>
A primary key is a unique index.
--
12 matches
Mail list logo
