How do you do to benchmark a query ?
I wish we had thought to have had him benchmark a query before and after he
added an index. It would be interesting to see the difference in actual time
that an index can make on a table with 450,000 records.
On Wed, 2004-10-06 at 15:31, Jason Williard
Hello,
I recently began experiencing issues that I would like some assistance with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table with 450,000+ records in it. When I try to run a single
query, such as selecting 1 row or deleting 1 row using the WHERE clause,
the query can
You need Appropriate Indexes on the tables.
-Original Message-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:11 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Long Running Queries
Hello,
I recently began experiencing issues that I would like
Is the table indexed in any way?
At 03:40 PM 10/6/2004, you wrote:
Hello,
I recently began experiencing issues that I would like some assistance with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table with 450,000+ records in it. When I try to run a single
query, such as
[mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:11 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Long Running Queries
Hello,
I recently began experiencing issues that I would like some assistance
with.
Server Details:
- Windows 2003
- MySQL Max 4.0.20a
I have a table
, October 07, 2004 1:24 AM
To: Wadhwa, Amit; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: Long Running Queries
What do you mean by appropriate indexes?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:43 PM
Not without more information. At the very least, we need to see the query.
Better yet, show us what EXPLAIN has to say about your query
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html.
Michael
Jason Williard wrote:
Hello,
I recently began experiencing issues that I would like some assistance
What do you mean by appropriate indexes?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:43 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Long Running Queries
You need Appropriate Indexes
? If so, why
is that?
Thanks!
Dan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Long Running Queries
appropriate indexes would mean
.
-Original Message-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:23 AM
To: Wadhwa, Amit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Long Running Queries
I'm sorry to sound like a novice, but could you explain that? Are you
recommending that I set
: Long Running Queries
Thank you for your assistance with this. Here's what you were asking
for.
Structure Output:
#
# Table structure for table 'asticketsdata'
#
CREATE TABLE asticketsdata (
ticketdataid int(11) NOT NULL auto_increment,
ticketidchar varchar(255) NOT NULL default
-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:42 AM
To: Wadhwa, Amit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Long Running Queries
Thank you for your assistance with this. Here's what you were asking
for.
Structure Output:
#
# Table structure
INDEX ( `ticketidchar` )
Regards,
Amit
-Original Message-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:42 AM
To: Wadhwa, Amit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Long Running Queries
Thank you for your assistance with this. Here's what
-
From: Jason Williard [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 07, 2004 1:42 AM
To: Wadhwa, Amit
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Long Running Queries
Thank you for your assistance with this. Here's what you were asking
for.
Structure Output
PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Date: Wed, Oct-6-2004 1:02 PM
Subject: RE: Long Running Queries
What do you mean by appropriate indexes?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 3:43 PM
Occasionally I have to add an index on a table with almost 2M rows and it
takes a long time. This is expected but when adding the index it seems to
block all other queries from other users from executing.
Is there a way to prevent this?
Thanks
Michael Blood
16 matches
Mail list logo