Can anyone tell me why this makes sense? I have a SELECT which uses an indexed
datetime field called Start with a BETWEEN range. If I select on this with no
LIMIT, it does a full scan of the 9391282 records in the DB (key=NULL).
However, if I do a limit of any value LESS than the number of r
right? Any light shed on indexing columns would be much
appreciated.
Thanks,
John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Assisitor,
Trouble with indexing. The team that is using MySQL for a
project consisting of capturing information from the
internet. I believe that they are indexing every word in
the english language, which in turn is slowing down the
search to turtle speed. What could one do to avoid
When is there going to be the ability to index in descending order?
Adam C Buggia
DirectAthletics Inc.
W: 978 927 7188
C: 781 608 5952
-
Before posting, please check:
http://www.mysql.com/manual.php
> -Original Message-
> From: Steve Bradwell
> Sent: Friday, May 03, 2002 10:31 AM
> To: '[EMAIL PROTECTED]'
> Subject: indexing?
>
> I've been doing some reading on indexes but I thought I should get an
> experienced persons input. My ques
Hi,
I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with
640MB of Ram. I only 1 table in a database with 5.6 million records and
I'm currently trying to index a varchar(100) field. I started the query
"alter table mytable add index myfield (myfield)" at 10am EST this morning
I'm new to MySQL and loving it. So pardon my lack of the simple things. I need to
index a table where the field is indexed, so when I look at the in the PHP script it
is in order.
Also when I run a query how can I save the results as a new table?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Sys
i'm makin a search engine the table looks like this -
---
| number | name | keywords | description | url | rank |
---
query's are made to against keywords, and description which are a blob's.
Hi,
Another question, to help me better understand MySQL indexing:
In MyISAM, does DISABLE INDEX followed by insertions and then
ENABLE INDEX freeze the original index and batch-updates it, or does
it drop it completely and recreate it from scratch?
--thanks, Roi
--
MySQL General Mailing List
Hey all, I have a question about indexing part of a date field. I
have a query that I run on a regular basis to retrieve monthly sales
numbers:
SELECT SUM(OrderSubTotal) FROM tblOrders
WHERE DATE_FORMAT(ShipDate, '%Y-%m') = '2004-09';
ShipDate is a date field. My question
Hi.
I'm relatively new to the database systems. I've read
from tutorials how to create indexes in tables. How
can I refresh the created index of a table as I insert
entries into it (in order to reflect the added entry
in the index)?
Any help would be very much appreciated.
Thanks!
Clinton Lope
Hello.
See:
http://dev.mysql.com/doc/mysql/en/LIMIT_optimization.html
>
>"Jeremiah Gowdy" <[EMAIL PROTECTED]> wrote:
>Can anyone tell me why this makes sense? I have a SELECT which uses an
>indexed datetime
>field called Start with a BETWEEN range. If I select on this with no LIMIT,
Jeremiah Gowdy wrote:
Can anyone tell me why this makes sense? I have a SELECT which uses an indexed
datetime field called Start with a BETWEEN range. If I select on this with no
LIMIT, it does a full scan of the 9391282 records in the DB (key=NULL).
However, if I do a limit of any value LESS
Hi
I have been testing mysql's GIS support for quite some time now. I have one
question. Suppose I execute this simple query:
select * from node where MRBWithin(node.shape_geo, LINESTRING(0 0, 200 200));
This will select all node records that are bounded in in the ractangle (0,0),
(0,200), (20
Hi,
I have a table that has a few short text fields [text(4000), text(1000)]
I would like to index. Do you think it is a good idea to index them
"simply", or is it better if I create auxilary fields which hold the MD5
for the text fields and index those? Would that be faster?
Thank you,
- Csong
Is there a way to only include certain matching conditions
in indexes?
Example if I have a row I want to index that is mysql dates
(2007-06-07) and I only want to include CURRENT and FUTURE
dates in the index and ignore any past dates. Is that
possible at all?
The issue I have is that the ratio
Hi,
I have created a rather large table containing about 16M records. Most
of the indexed fields are smallint, but there is one field that is a
text field that I am using fulltext indexing on. The total size of the
smallint indexes is only about 30 MB, but the fulltext index brings
the total index
Hello,
I had a question about indexing a while back and everyone screamed
"normalize"!!
Well...I've normalized much as I'm going to, and at most I have 3 indexes on
any one table. My database has 120 million records in it and the index
creation is taking a ridiculous a
Hi John,
- Original Message -
From: "John Mistler"
Sent: Sunday, May 02, 2004 12:50 AM
Subject: Indexing
> I know this is an elementary question, but I am getting two sets of
> instructions from different MySQL manuals about setting an index on a
prefix
> of a colu
> and the other says to use
>
> INDEX indexName (colName(length))
>
> Are both all right? Any light shed on indexing columns would be much
> appreciated.
>
KEY is synonym for INDEX. You can use either of them.
--
For technical support contracts, goto https://order.mys
Suppose I wanted to be able to perform queries against three columns of my
table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be
range-selecting records from the table ordering by 'created'. But I may also
want to select where 'user_id' = something and 'product_id' in (list, o
]]
Sent: Thursday, February 22, 2001 12:42 PM
To: [EMAIL PROTECTED]
Subject: indexing
When is there going to be the ability to index in descending order?
Adam C Buggia
DirectAthletics Inc.
W: 978 927 7188
C: 781 608 5952
what do you mean?
if you're talking about ordering your query result in descending order you
can do this:
select * from table_name order by field1 desc
Atle
On Thu, 22 Feb 2001, Adam C Buggia wrote:
>
>
> When is there going to be the ability to index in descending order?
>
>
>
> -
EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 12:42 PM
> To: [EMAIL PROTECTED]
> Subject: indexing
>
>
>
>
> When is there going to be the ability to index in descending order?
>
>
>
>
> Ad
-Original Message-
From: Adam C Buggia [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 1:42 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: RE: indexing
> Why do you need to build your index in descending order?
I am the dba for a track and field results web site, w
> I am the dba for a track and field results web site, when people look for
> results they are most likely going to want results from a more recent meet
> (rather than older meets).
>
> there is a table result and a table meet where a column in result is
> "meet_hnd." (there maybe hundreds of resu
Aer you not storing a date associated with each record??
If you're not, I'd highly recommend doing that, rather than just hoping
that mysql will return the order of results the way you want it. Ordering
by date should be pretty inefficient also.
mysql returns the records in the order they were
I do use ORDER BY by meet_hnd DESC.
In trying to optimize queries on this db, can I assume the following:
In searching for a result on meet_hnd (which is indexed) using the ORDER
BY clause not only affects the was the data is returned but also the
method by which the results are searched on:
]
Subject: Re: indexing
I do use ORDER BY by meet_hnd DESC.
In trying to optimize queries on this db, can I assume the following:
In searching for a result on meet_hnd (which is indexed) using the ORDER
BY clause not only affects the was the data is returned but also the
method by which the
2001 10:42
To: Adam C Buggia; Jason Landry
Cc: [EMAIL PROTECTED]
Subject: RE: indexing
Nope. ORDER BY determines how the result set is output. It has nothing to
do with how MySQL finds the records.
Cal
http://www.calevans.com
-Original Message-
From: Adam C Buggia [mailto:[EMAIL
001 4:18 PM
To: 'Cal Evans'; Adam C Buggia; Jason Landry
Cc: [EMAIL PROTECTED]
Subject: RE: indexing
Question: If you select and order by an indexed field, so that only the
index file is used, does the server still do a sort, or does the data come
out of the file pre-sorted?
Just won
On Fri, Feb 23, 2001 at 11:18:03AM +1300, Quentin Bennett wrote:
>
> Question: If you select and order by an indexed field, so that only
> the index file is used, does the server still do a sort, or does the
> data come out of the file pre-sorted?
The index entries are sorted, so MySQL can simply
Hi All,
Let's say I'm creating an affiliate program to track surfer clicks to sales.
I have a question on indexing that's always bothered me. I'm hoping an index
guru can help me out. Here's an example click-recording table:
CREATE TABLE clicks (
clickID int unsigne
Hi all,
I would like to create an index to speed up the following query:
SELECT Account, Status, count(*) From MessageStatus WHERE sentDate >
'(variable)' AND sentDate < '(variable)' GROUP BY Account,Status ORDER BY
Account
sentDate is a timestamp(14), Account and Status are both varchars.
The
Hello,
I have some doubts about the index behaviour in InnoDB.
I have a table named 'Albaranes'. The definition is as follow:
CREATE TABLE `albaranes` (
`Cli` varchar(6) NOT NULL default '',
`Alb` varchar(8) NOT NULL default '',
.
.
.
PRIMARY KEY (`Alb`),
UNIQUE KEY `Cliente` (`
Can anyone give me some tips on how indexes work?
I noticed that UNIQUE() seems to create a lock on all given fields per
call like UNIQUE (md5, mime) so that no row can have the same combination
of md5 and mime type which is good but assuming I wanted to have each
unique on it's own I'd need UNIQ
Hi all,
Can someone tell me how to speed up the index creation???
I am trying to build an index for a 13,875,354 records(13 million) table
with 176,322 distinct vendor_id(VARCHAR(40)) in the table.
the existing size of the transaction table:
transaction.MYD = 2,128,954,624 bytes
transaction.MYI
I have a course project at hand which deals with
indexing in MySQL. Has anyone worked with Indexing in
MySQLie worked on code.i seem 2 be a bit lost
i the source code..Can anyone help me out.
Deepanshu
=
Deepanshu
[ KReSIT ]
IIT-B
[EMAIL PROTECTED
(by determining how many mailings
were sent, and subtract the number of rows left in the table for that
mailing id)
My question is about indexing. I know a lot about indexing, and using
left-most indexes, etc...since this table will have millions of rows, I'm
wondering what kind of index I sho
Roger Ramirez wrote:
>
> Hi,
>
> I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with
> 640MB of Ram. I only 1 table in a database with 5.6 million records and
> I'm currently trying to index a varchar(100) field. I started the query
> "alter table mytable add index myfield (
EMAIL PROTECTED]
Subject: Re: indexing
Roger Ramirez wrote:
>
> Hi,
>
> I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with
> 640MB of Ram. I only 1 table in a database with 5.6 million records
and
> I'm currently trying to index a varchar(100) fie
On Tue, Jul 10, 2001 at 07:36:25PM -0400, Wyly Wade wrote:
>
> Never Index on text, blob, and if you can help it don't use var char
> in indexes.
There's nothing wrong with indexing a text or blob field. In fact,
it's often very useful to index just a small prefix (
Actually you are not indexing on a text or blob field solely if you are
indexing a fixed length 20 char or said field. Building key fields to
index on is a good approach I often when I would like to index on a text
or blob, I instead index on a unique hashing routine instead.
As far as the later
You asked:
I'm new to MySQL and loving it. So pardon my lack of the simple things. I
need to index a table where the field is indexed, so when I look at the in
the PHP script it is in order.
Also when I run a query how can I save the results as a new table?
I reply.
1. You need an ORDER BY cla
At 6:12 PM +0800 1/20/03, Jon Miller wrote:
I'm new to MySQL and loving it. So pardon my lack of the simple
things. I need to index a table where the field is indexed, so when
I look at the in the PHP script it is in order.
Use 'order by' in your select statement:
http://www.mysql.com/doc/e
Hi
I have many articles whose paths and categories are stored in a mysql table
!
I'd like to index these files so as to be used in my search engine!
I used to work with NT index server who automatically indexes files and put
them in an sql dbs!
but now i use php/mysql
Thanks
___
Hi,
I'm running MySQLd-NT on an Athlon 1.33GHz w/512MB RAM, under Win2000.
I'm doing a fulltext index on a varchar(255) column in one of my tables.
Admittedly, the table has ~77million rows, but the indexing has been
going for almost a *week* now.
What can I do to optimize MySQL fo
We have an application that needs to index every word (token) in a name,
separately.
Ex: "New York" must be indexed under "New" and "York".
One solution is to create an auxiliary table, extract the tokens one word
at a time, and cross-reference to the key of the original table.
Ex: CREATE TAB
Hi all,
I have developed a system that lets people send messages to each other, with
a MySQL database and PHP.
Among the tables that exist, one is called "Users" and contains information
such as Username, password (md5'd of course), email address etc. This table
has a primary key "UserID" that i
wrong and how can I improve it?
Also, are there any progress indicators, so I can know how much time
is left until indexing finishes?
--Thanks, Roi.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Another question, to help me better understand MySQL indexing:
>
> In MyISAM, does DISABLE INDEX followed by insertions and then
> ENABLE INDEX freeze the original index and batch-updates it, or does
> it drop it completely and recreate it from scratch?=20
>
> --t
I was trying to analyze a query that was taking almost 4 seconds to
execute. While trying to create additional indexes - found that the
query is not using any index from table qb_test_result . The type
returned is ALL for qb_test_result .
I have given the tables and query below. It would have bee
want.
Michael
Andrew Kreps wrote:
Hey all, I have a question about indexing part of a date field. I
have a query that I run on a regular basis to retrieve monthly sales
numbers:
SELECT SUM(OrderSubTotal) FROM tblOrders
WHERE DATE_FORMAT(ShipDate, '%Y-%m') = '2004-09';
ShipDate is
Daly
- Original Message -
From: "Andrew Kreps" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 22, 2004 4:48 PM
Subject: Date Indexing
Hey all, I have a question about indexing part of a date field. I
have a query that I run on a regular basis to ret
On 23-Sep-2004 Eamon Daly wrote:
> I'm interested in this, too. We have a logging table that
> sees hundreds of rows per second, and we do a ton of monthly
> reports. We just bit the bullet and added an indexed DATE
> column. Is there a better strategy?
>
I do something similar but with MEDIUMIN
clinton lopez <[EMAIL PROTECTED]> wrote on 29/09/2004 09:54:04:
> Hi.
>
> I'm relatively new to the database systems. I've read
> from tutorials how to create indexes in tables. How
> can I refresh the created index of a table as I insert
> entries into it (in order to reflect the added entry
> i
Please be gentle, I have nearly no experience with SQL databases. I am
not subscribed to the list so please cc me on replies.
Because my email client probably did horrable things to this post you
can find the text here also:
http://nolab.org/scratch/mysql-index-oddness.html
I use syslog-ng t
I have a database I'm using for a MMORPG (well, it isn't very
MM because I'm something of a noob), and I have a few questions about
indexing. I am storing world data in a database. In order to keep
everything as swift as possible, I have indexed everything. An
On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote:
FC> Hi,
FC> I have a table that has a few short text fields [text(4000), text(1000)]
FC> I would like to index. Do you think it is a good idea to index them
FC> "simply", or is it better if I create auxilary fields which hold the MD5
FC> for th
On Friday 11 June 2004 07:00 am, Fagyal, Csongor wrote:
> Hi,
>
> I have a table that has a few short text fields
> [text(4000), text(1000)] I would like to index. Do
> you think it is a good idea to index them "simply",
> or is it better if I create auxilary fields which
> hold the MD5 for the tex
> I have a table that has a few short text fields [text(4000), text(1000)]
> I would like to index. Do you think it is a good idea to index them
> "simply", or is it better if I create auxilary fields which hold the MD5
> for the text fields and index those? Would that be faster?
Try 'Fulltext
Hi Cory,
Cory Robin wrote:
Is there a way to only include certain matching conditions
in indexes?
Example if I have a row I want to index that is mysql dates
(2007-06-07) and I only want to include CURRENT and FUTURE
dates in the index and ignore any past dates. Is that
possible at all?
The
On 6/7/07, Cory Robin <[EMAIL PROTECTED]> wrote:
The issue I have is that the ratio of queries on old vs.
new data is like 1:10. And searches would be MUCH
faster if I could force my queries that are looking at
current or future data to use an index that ONLY had that
information in them..
What is the size of the text field you're fulltext indexing? How often is
that index used? You might be best off to create a table containing only
that column and a PK that is equal to the PK in the original table. You
might also keep a portion of the text field (say 50 characters) in the
ori
PK and text field seems to be the only sensible
decision. Thanks in advance,
Christian
On Tue, Mar 25, 2008 at 10:11 AM, Arthur Fuller <[EMAIL PROTECTED]> wrote:
> What is the size of the text field you're fulltext indexing? How often is
> that index used? You might be best off
Hi,
I just finished restoring a 22gig SQL dump but the server is not
performing anywhere near where it should be. I'm assuming this is
because it's still rebuilding indexes on the imported tables.
Is there any way to see the indexing status so I can gauge how far
it'
?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/11/04, 11:29:44 AM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding Indexing Woes:
> Hello,
> I had a questi
On Wed, 2004-02-11 at 09:29, Chris Fossenier wrote:
> Hello,
>
> I had a question about indexing a while back and everyone screamed
> "normalize"!!
>
> Well...I've normalized much as I'm going to, and at most I have 3 indexes on
> any one table. My d
lto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 12:10 PM
To: Chris Fossenier
Cc: 'MySQL List'
Subject: Re: Indexing Woes
Yes a duplicate copy of the table is created and the Indexes are created
on that new table, the original table is dropped and the new table is
renamed.
I have checked these...but I don't know what to set them too. Can I get more
input? Should I only run 1 index at a time? I have 2 machines (both quad
Xeon)..one is running a singel indexing job, the other is running 6 jobs. It
looks like they will end up completing in the same amount of total
Performing your indexing in one batch will create a temp table only once
as opposed to n-times.
What is the current value of your myisam_max_sort_file_size?
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<&
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 4:50 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
Performing your indexing in one batch will create a temp table only once
as opposed t
;>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/11/04, 4:54:21 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Indexing Woes:
> Can you provide a better explanation of these variables? I have yet to
find
>
None of my individual tables are larger than 12GB, however, I have no idea
if MySQL creates a separate TMP file for each indexing job or if it creates
a new one for each instance.
Also, where would it create this file? In the tmp dir?
Chris.
-Original Message-
From: [EMAIL PROTECTED
;<<<<<<<<<<
On 2/11/04, 5:42:31 PM, Chris Fossenier <[EMAIL PROTECTED]> wrote
regarding RE: Indexing Woes:
> None of my individual tables are larger than 12GB, however, I have no
idea
> if MySQL creates a separate TMP file for each indexing
nothing over 20mill for records.
Chris.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 5:47 PM
To: Chris Fossenier
Cc: 'Peter Zaitsev'; 'MySQL List'
Subject: RE: Indexing Woes
These files will be created in the /tm
Hi,
I'm trying to implement the proper indexing for my DB, and am having some
challenges. I was hoping someone could lend me a hand.
If I have 5 fields in the DB that I am indexing (field1, field2, field3,
field4, and field5), I know I can create an index:
Key Index1( field1, field2, f
Given these two tables:
create table t1 (
id int unsigned auto_increment,
a int,
... [other fields]
primary key (id),
index aid (a,id)
) type=innodb;
create table t2 (
id int unsigned,
b int,
... [other fields]
index id (i
hi,
if I have column order_id(int(4)) null do I have to index it too. I'm
going to use it ONLY for sorting records.
thanks.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I am looking for, is there any specific reason for not indexing all columns
of a table. whats the impact on the performance. Although indexing is meant
for getting great performance. So, why indexing all columns is not
feasible. (Read in docs that all columns should not be indexed
Hey, all. I'm trying to "get" indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been RTFM'ing, but
haven't found anything that really laid it out in bl
er 01, 2010 11:48 AM
To: mysql@lists.mysql.com
Subject: Indexing question
Suppose I wanted to be able to perform queries against three columns of my
table: 'user_id', 'product_id' and 'created'. Most of the time I'll just be
range-selecting records from the table ordering by &#x
-
> From: Jonas Galvez [mailto:jonasgal...@gmail.com]
> Sent: Friday, October 01, 2010 11:48 AM
> To: mysql@lists.mysql.com
> Subject: Indexing question
>
> Suppose I wanted to be able to perform queries against three columns of my
> table: 'user_id', 'product_id
Hi Neil, all!
Tompkins Neil wrote:
> So if you have individual indexes for example field_1, field_2 and field_3
> etc and then perform a search like
>
> WHERE field_1 = 10
> AND field_3 = 'abc'
>
> This wouldn't improve the search ? You have to create a index for all
> possible combined field
Thanks for your reply. So should we create individual indexes on each
field or a multiple column index ??
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, field_2 and
field_3
etc and then perform a s
Following on from my previous email I have columns containing numbers
which are then used in SUM and MIN/ MAX functions should these be
indexed too ?
On 3 Oct 2010, at 16:44, Joerg Bruehe wrote:
Hi Neil, all!
Tompkins Neil wrote:
So if you have individual indexes for example field_1, fie
Hi!
Neil Tompkins wrote:
> Thanks for your reply. So should we create individual indexes on each
> field or a multiple column index ??
This question cannot be answered without checking and measuring your
installation. The decision whether to create an index is always an act
of balancing:
- If t
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries for you
to advise if any changes need to be made ?
Regards
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe wrote:
> Hi!
>
>
> Neil Tompkins wrote:
> > Thanks for your reply. So should we create individual indexes on each
: Re: Indexing question
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries for you
to advise if any changes need to be made ?
Regards
Neil
On Mon, Oct 4, 2010 at 3:38 PM, Joerg Bruehe wrote:
> Hi!
>
>
> Neil Tompkins wrote:
> > Thanks for your reply. S
ssage-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Monday, October 04, 2010 8:54 AM
To: Joerg Bruehe
Cc: [MySQL]
Subject: Re: Indexing question
Jörg
Thanks for the useful reply. Maybe I can EXPLAIN my select queries
for you
to advise if any changes need to be made ?
Regards
> -Original Message-
>> From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
>> Sent: Monday, October 04, 2010 8:54 AM
>> To: Joerg Bruehe
>> Cc: [MySQL]
>> Subject: Re: Indexing question
>>
>> Jörg
>>
>> Thanks for the usef
Thanks Gavin and Joerg, that was very helpful!
-- Jonas
On Sun, Oct 3, 2010 at 12:44 PM, Joerg Bruehe wrote:
> Hi Neil, all!
>
>
> Tompkins Neil wrote:
> > So if you have individual indexes for example field_1, field_2 and
> field_3
> > etc and then perform a search like
> >
> > WHERE field_1 =
I'm using the following table to store information about a merchant user.
He uses his email address as his username to login. Since I'm going to
be doing WHERE clauses on that field, I'd like it to be indexed for speed.
If I have a UNIQUE property on the email field when I create the table, do I
n
Do the tables on the slave machine have to be *exactly* the same as the
tables on the master? Is it possible to have different indexes on the slave?
I want to use my master as my transaction server and my slave as my
reporting server. In that respect, I'd like to use very few indexes on my
master
filter-fodder:
Hi,
I am trying to speed things up a bit by indexing, but am having a bit of
trouble.
Take two tables:
TABLE dances (
danceid smallint(5) unsigned NOT NULL auto_increment,
ddref smallint(5) unsigned NOT NULL default '0',
has_desc enum('T',
Is the index for a hash table stored on disk or in memory? I have a hash
table that I am constantly adding data to, which means the index is
constantly being updated. If I keep the size of the key buffer sufficiently
large, will the new index values be there upon creation, or not until they
are
gt; From: Ben Holness [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 27, 2002 1:20 AM
> To: Mysql z_mailing
> Subject: Indexing question
>
>
> Hi all,
>
> I would like to create an index to speed up the following query:
>
> SELECT Account, Status, count(*) Fro
Hello,
I have some doubts about the index behaviour in InnoDB.
I have a table named 'Albaranes'. The definition is as follow:
CREATE TABLE `albaranes` (
`Cli` varchar(6) NOT NULL default '',
`Alb` varchar(8) NOT NULL default '',
.
.
.
PRIMARY KEY (`Alb`),
UNIQUE KEY `Cliente` (`
Where can I find info about HOW-TO write my own indexing subsystem for MySQL??
Or perhaps an example, or even the full thing. I need a "sphere" indexer,
which finds spheres overlapping a "search sphere".
N
See:
http://www.mysql.com/doc/C/R/CREATE_INDEX.html
http://www.mysql.com/doc/M/y/MySQL_indexes.html
Steve Meyers
> -Original Message-
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 19, 2001 2:07 PM
> To: [EMAIL PROTECTED]
> Subject: indexing quest
1 - 100 of 413 matches
Mail list logo
