should pick up the index.
>
> Index hints are rarely ever needed. It's best to stay away from them unless
> you know exactly what's going on under the hood :-)
>
>
> - Original Message -
>> From: "xucheng"
>> To: mysql@lists.mysql.com
>>
[Note to self, reply to mailinglist, not to author ;) ]
> i found a strange problem . when i using index for 'select' , i
> got a slower result than without index .
> i have a tabe :
> create table geo_query (
> `id` int(10) unsigned not null auto_increment ,
>
hints are rarely ever needed. It's best to stay away from them unless you
know exactly what's going on under the hood :-)
- Original Message -
> From: "xucheng"
> To: mysql@lists.mysql.com
> Sent: Thursday, 28 July, 2011 2:50:46 PM
> Subject: index problem
Hi
i found a strange problem . when i using index for 'select' , i
got a slower result than without index .
i have a tabe :
create table geo_query (
`id` int(10) unsigned not null auto_increment ,
`start` bigint(20) unsigned not null ,
`end` bigint
Michael Gale wrote:
When I run the following:
`Select DISTINCT machine from syslog WHERE date1 > (NOW() - INTERVAL 1
hour);' it takes 9min to complete.
If I use "Explain" it says the query is using index "hostname", should
it not be using the index "hostdate" which contains fields "machine" and
"
Hello,
Currently I am using sysklogd-sql to store syslog messages in a MySQL
4.0.24. The current number of rows is around 3,799,700.
The table layout is as follows:
ID
machine
facility
priority
date1
message
Now ID is the primary key and it had one index called hostname
containing (mach
"Oropeza Querejeta, Alejandro" <[EMAIL PROTECTED]> wrote:
> Hi, i'm trying to create an index on a table with 199 million records.
> The problem is that is taking too long (8 hours and is not yet
> finnished).
> does anyone have any idea?
Wait until it finishes.:)
We have tables where index cre
some_index on table(folio2(5));
to only index part of the data?
David
Oropeza Querejeta, Alejandro wrote
Below are the answers
Best Regards
-Mensaje original-
De: David Griffiths [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Junio de 2004 01:29 p.m.
Para: [EMAIL PROTECTED]
As
Below are the answers
Best Regards
-Mensaje original-
De: David Griffiths [mailto:[EMAIL PROTECTED]
Enviado el: Miércoles, 30 de Junio de 2004 01:29 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: Index problem
What's the definition of the table? IE are you indexing an INT, VARCHAR,
e
What's the definition of the table? IE are you indexing an INT, VARCHAR,
etc?
What's the definition of the index? Is it unique, composite, etc?
What's the storage engine in use? InnoDB? MyISAM?
Can you show the relevant parts of your my.cnf file?
What operating system are you using?
David
Oropeza
Hi, i'm trying to create an index on a table with 199 million records.
The problem is that is taking too long (8 hours and is not yet
finnished).
does anyone have any idea?
the server is 2Xeon 2.8 gigs with 6 Gb of ram.
Best regards
Alejandro
Hi,
We upgrade one of our servers, but physical and mysql from
3.23.55-max-log to 3.23.58-max-log and run into some problems with a few
queries.
This is the old server:
mysql> explain select count(id) from table where entered >
date_sub(now(), INTERVAL 15 DAY) and DAYOFYEAR(entered) =
DAYOFYEAR(
i am new to mysql.
i have got a table tab1 in my database.
i am using 4.0.3 version of mysql and the table type is MyISAM.
the tab1 has got 14 fields and about 600,000 records and is indexed on
col1 which is of varchar type
i have used the query
select * from tab1 order by col1;
which does not us
At 2:31 AM -0700 1/16/03, Prasanth Krishna wrote:
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
In this query, I can't see any reason to use an index...MySQL is
simply re
PROTECTED]]
Sent: 16 January 2003 09:31
To: [EMAIL PROTECTED]
Subject: index problem
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
but if i say
select col1 from tbl1;
it use
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
but if i say
select col1 from tbl1;
it uses the index.
how to make mysql use the index on col1 for the first query?
thanks i
Hi.
On Thu 2002-07-25 at 10:49:47 -0500, [EMAIL PROTECTED] wrote:
> Hi, I have a problem where the index for a SET column does not get used
> once I link in another table.
>
> The output to explain:
>
> mysql> explain select count(*) from NS_articles where
> find_in_set('approved', artFlags)
Hi, I have a problem where the index for a SET column does not get used
once I link in another table.
The output to explain:
mysql> explain select count(*) from NS_articles where
find_in_set('approved', artFlags) > 0;
+-+---+---+--+-+--+--+
Hello everybody.
I am working with mysql about one week by now, and a friend of mine did an
ALTER TABLE, and during this he did a cold reboot. After that, I realize
that my tables where somewhat inconsistent. Then I run myisamchk -r, and it
told me that my index definition is not valid, and that
I am using mysql verison 3.23.41-nt
I am working with the following two tables.
mysql> show create table table1;
| Table | Create Table
-
| table1 | CREATE TABLE `table1` (
`Column1` varchar(63) NOT NULL default '',
`Column2` varchar(31) default NULL
P
Sommai,
Tuesday, January 22, 2002, 7:17:36 AM, you wrote:
SF> I have problem with these query:
SF> select * from holder, management where holder.id=management.id or
SF> (holder.name=management.name and holder.surname=management.surname) order
SF> by holder.no
SF> It t
I was try with explain or describe command. The result in column 'type'
show 'ALL' , column ' possible keys' show index name I was created. I
wonder that why did not use index it take a long time (look like computer
hang).
SF
At 14:23 22/1/2002 +0700, Kittiphum Worachat wrote:
>Hi
>
>Try t
Hi
Try to check your query by this command
explain select * from holder, management where holder.id=management.id or
(holder.name=management.name and holder.surname=management.surname) order
by holder.no
and let take a look the result if they say the result come from ALL record
it mean you can'
Hi,
I have problem with these query:
select * from holder, management where holder.id=management.id or
(holder.name=management.name and holder.surname=management.surname) order
by holder.no
It take a long time (more than 1 minute) with thousand record. I have
index wi
Responding to my own email... sheesh. It's just that kinda day. :>
I found reference in the archives to what seems to be the same problem.
Monty replied to a thread entitled "I got it hanged !" on 2001-07-17, and agreed that
it shouldn't be happening. Unfortunately, I can't find a solution in
Hi all,
mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large ALTER
TABLE -- adding or dropping an Index, repair etc. The server and client are still
'alive' and I can do simple things like show processlist, or selecting a count(0) from
another table, but other selec
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: FW: pls help for index problem
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TAB
u [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 9:42 AM
> To: 'Bill Adams'
> Subject: RE: pls help for index problem
>
> Thanks yr promptly reply !!
>
> It seems no any change(improvement) by running explain again after erase
> quotes. I also ran
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I al
kmlau wrote:
> I encountered a problem about indexing. I want to add index on timerecord
> field in table gw (shown as below) to speed up query relating with time.
> However, I use explain command (explain select * from gw where timerecord =
> '010902') to analyze the performace. As a resul
hi,
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result, it seems the q
Thanks for the advice last time folks, I think that one's working.
Here's a tougher query, any ideas on how to speed this one up:
SELECT DISTINCT badge.last_name AS last_name, badge.first_name AS
first_name, badge.bid AS bid, badge.employee AS employee,
badge_type.description AS type, badgests.co
Hi,
We were running 3.23.21, which had the problem where the index file could
only go to 64MB.
So I shutdown the db, move the mysql directory(/usr/local/mysql) and
installed 3.23.36, and moved the database directories into the new version's
directory. I then repaired the radacct table.
My proble
running myisamchk against basic table gives this error :
stopword doesn't have a correct index definition. you need to recreate it
before you can do a repair.
table details:
create table stopword(word char(32) DEFAULT '' NOT NULL, lang char(2) DEFAULT
'' NOT NULL, PRIMARY KEY (word, lang));
Th
34 matches
Mail list logo
