As I read the documentation, ALTER TABLE my_table DISABLE KEYS only
works on MyIsam tables. When I run the command against an InnoDB
database, however, I get no indication of a problem. I get the usual
Query OK message. So, can I temporarily disable keys on an InnoDB
database (say while doing a
Of the data? Or of the queries?
Not the data. Just your query, the output from explain and a create
table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE %harrod% AND
user_haves.card_name = cards_crypt.name AND
Hello.
On Tue 2002-07-16 at 07:47:33 -0500, [EMAIL PROTECTED] wrote:
Of the data? Or of the queries?
Not the data. Just your query, the output from explain and a create
table statement.
Query:
SELECT DISTINCT cards_crypt.*
FROM user_haves, cards_crypt WHERE
cards_crypt.name LIKE
When dealing with a considerable number of records
(10s of thousands) in a particular table, which is better
to use? Currently we are using MyISAM and the
queries on those tables are kind of slow. I've set the
most frequently used (in a query) columns as keys and
that isn't speeding it up any.
, 2002 1:53 PM
To: [EMAIL PROTECTED]
Subject: MyISAM v. InnoDB
When dealing with a considerable number of records
(10s of thousands) in a particular table, which is better
to use? Currently we are using MyISAM and the
queries on those tables are kind of slow. I've set the
most frequently used
On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote:
When dealing with a considerable number of records (10s of
thousands) in a particular table, which is better to use? Currently
we are using MyISAM and the queries on those tables are kind of
slow.
Really? That's not a lot of
When dealing with a considerable number of records (10s of
thousands) in a particular table, which is better to use? Currently
we are using MyISAM and the queries on those tables are kind of
slow.
Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the queries?
When dealing with a considerable number of records (10s of
thousands) in a particular table, which is better to use? Currently
we are using MyISAM and the queries on those tables are kind of
slow.
Really? That's not a lot of data. Can you provide examples?
Of the data? Or of the queries?
Can you post your query along with the output of explain?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:45 PM
To: Cal Evans; [EMAIL PROTECTED]
Subject: Re: MyISAM v. InnoDB
any conclusions.
IMHO,
Steve Orr
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:39 PM
To: Chris Boget; [EMAIL PROTECTED]
Subject: RE: MyISAM v. InnoDB
switching to InnoDB won't help. Take a look at optimizing your queries. Are
you using LIKE
On Monday, 15. July 2002 22:46, Chris Boget wrote:
Of the data? Or of the queries?
Not the data. Just your query, the output from explain and a create table
statement.
Regards
Georg
-
Before posting, please check:
11 matches
Mail list logo