Re: Long Running Queries

2004-10-07 Thread m . muller
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

Long Running Queries

2004-10-06 Thread 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

RE: Long Running Queries

2004-10-06 Thread Amit_Wadhwa
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

Re: Long Running Queries

2004-10-06 Thread Ted Byrne
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

Re: Long Running Queries

2004-10-06 Thread 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 some assistance with. Server Details: - Windows 2003 - MySQL Max 4.0.20a I have a table

RE: Long Running Queries

2004-10-06 Thread Amit_Wadhwa
, 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

Re: Long Running Queries

2004-10-06 Thread Michael Stassen
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

RE: Long Running Queries

2004-10-06 Thread Danny Willis
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

RE: Long Running Queries

2004-10-06 Thread Danny Willis
? 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

Re: Long Running Queries

2004-10-06 Thread Jason Williard
. -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

RE: Long Running Queries

2004-10-06 Thread Amit_Wadhwa
: 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

Re: Long Running Queries

2004-10-06 Thread Jason Williard
- 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

Re: Long Running Queries

2004-10-06 Thread Jason Williard
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

Re: Long Running Queries

2004-10-06 Thread Spenser
- 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

RE: Long Running Queries

2004-10-06 Thread Randy Clamons
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

long running queries

2001-09-20 Thread Michael Blood
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