Re: Long Running Queries

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 w

RE: Long Running Queries

MAIL PROTECTED]> > To: [EMAIL 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 P

Re: Long Running Queries

D 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] &

Re: Long Running Queries

ADD 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. Her

Re: Long Running Queries

- 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 structur

RE: Long Running Queries

: 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) N

Re: Long Running Queries

and the query, I can help you with your index. -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

RE: Long Running Queries

rrect? 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&q

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 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Long Running Queries You need Appropriate Inde

Re: Long Running Queries

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 . Michael Jason Williard wrote: Hello, I recently began experiencing issues that I would like some assistance

RE: Long Running Queries

Sent: Thursday, 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,

Re: Long Running Queries

liard [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

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 selecti

RE: Long Running Queries

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

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 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 t

long running queries

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 -