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
This is the first time I try to use MySQL for very large tables.
Experienced users warned me against possible problems with *index*
definition for large tables:
they claim MySQL indices are stored completely in memory, which is
problematic to me : I have a huge table and limited memory size (RAM)
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 e
Hi,
A strange thing with index, I thought the cardinality was automatically
updated (like for a primary key for exemple).
When I use a primary key in a table, insert a row, the cardinality is
increased of 1 as well.
I just tried to do that with an INDEX, and the cardinality is none unless I
up
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
Anyone know how the index chooser works, and why it is often so bad?
For example, with the following query:
SELECT lid,brief,title FROM poems left join poets on poems.mid =
poets.mid WHERE poems.mid =9365 ORDER BY created DESC LIMIT 0,10
With an explain of:
*** 1. row **
Hi,
Can someone point to a location where the implementation of indexes on MyISAM tables
is explained? I'm trying to understand exactly (not roughly) how the indexes are
created and used.
Harald
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
>
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
mysql searches each index?
In other words would keeping my indexes to on
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)
>
Hey People :-)
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)
if i created an index on the time column and a
I have a table with millions of records, lots of fields, and lots of
indexes. It appears I break every rule for table efficiency...but there is a
reason! I needed to do summarized data on *lots* of the fields at once, and
the savings in time & simplicity far outweigh any performance hits I may
hav
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
Regarding mysql...
1) Are primary keys and foreign keys by default indexes for a table?
2) Do I have to use a special data other than float to allow for negative numbers,
i.e. I want to be able to enter -1.76 and be able to later do math against that
number...
Thanks,
Taylor
Taylor Lewick
U
EMAIL PROTECTED]'
Cc: Gorantla, Aruna
Subject: MySQL Index
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.
-
Befo
#x27;
Cc: Gorantla, Aruna
Subject: MySQL Index
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.
-
Before posting, ple
"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.
--
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.
-
Before posting, please check:
http://www.mysql.com/manual.php (t
21 matches
Mail list logo
