RE: Slow Response -- What Does This Sound Like to You?

2013-05-10 Thread Rick James
-05-07'. What does the {} syntax do?? Contradictory: where `Query1`.`Appointment_Provider_ID` in (9118, 9119, 60922, 9116, 47495) and `Query1`.`Appointment_Provider_ID` = 60922; The IN filter does nothing useful. I think those changes will make the query run _much

RE: [>Suspected Spam<][Characteristics] RE: Slow Response -- What Does This Sound Like to You?

2013-05-10 Thread Robinson, Eric
> > 1. MyISAM locks _tables_. That can cause other connections > to be blocked. Solution: switch to InnoDB. Caution: There > are a few caveats when switching; see > https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/ > > 2. As mentioned by Shawn, the Query Cache can be more

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Vikas Shukla
. Regards Vikas shukla -Original Message- From: "Rick James" Sent: ‎10-‎05-‎2013 07:24 To: "Bruce Ferrell" ; "mysql@lists.mysql.com" Subject: RE: Slow Response -- What Does This Sound Like to You? 1. MyISAM locks _tables_. That can cause other connect

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Rick James
ts.mysql.com > Subject: Re: Slow Response -- What Does This Sound Like to You? > > On 05/09/2013 03:25 PM, Robinson, Eric wrote: > >> > >>> -Original Message- > >>> From: Robinson, Eric [mailto:eric.robin...@psmnv.com] > >>> Sent: Thursday,

Re: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Bruce Ferrell
On 05/09/2013 03:25 PM, Robinson, Eric wrote: -Original Message- From: Robinson, Eric [mailto:eric.robin...@psmnv.com] Sent: Thursday, May 09, 2013 1:58 PM To: mysql@lists.mysql.com Subject: Slow Response -- What Does This Sound Like to You? We have a situation where users complain tha

Re: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread shawn green
Hello Eric, On 5/9/2013 7:13 PM, Robinson, Eric wrote: -Original Message- From: Wm Mussatto [mailto:mussa...@csz.com] Sent: Thursday, May 09, 2013 3:50 PM To: Robinson, Eric Cc: Rick James; mysql@lists.mysql.com Subject: RE: Slow Response -- What Does This Sound Like to You? On Thu

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Robinson, Eric
> -Original Message- > From: Wm Mussatto [mailto:mussa...@csz.com] > Sent: Thursday, May 09, 2013 3:50 PM > To: Robinson, Eric > Cc: Rick James; mysql@lists.mysql.com > Subject: RE: Slow Response -- What Does This Sound Like to You? > > On Thu, May 9, 2013 15:

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Wm Mussatto
On Thu, May 9, 2013 15:25, Robinson, Eric wrote: >> >> > -Original Message- >> > From: Robinson, Eric [mailto:eric.robin...@psmnv.com] >> > Sent: Thursday, May 09, 2013 1:58 PM >> > To: mysql@lists.mysql.com >> > Subject: Slow Response -- What Does This Sound Like to You? >> > >> > We have

Re: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Denis Jedig
Am 09.05.2013 22:58, schrieb Robinson, Eric: Q: What conditions could cause single query to lock up a database for a while for all users From : A SELECT statement that takes a long time to run prevents other session

Re: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Johnny Withers
I delt with a similar situation where users complained the system would freeze up for 30-60 seconds at random intervals. After days of looking at queries, logs, error logs, etc.. We were no closer to finding a solution. We do have a service that runs every 15 minutes to cache some data in our syste

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Robinson, Eric
> > > -Original Message- > > From: Robinson, Eric [mailto:eric.robin...@psmnv.com] > > Sent: Thursday, May 09, 2013 1:58 PM > > To: mysql@lists.mysql.com > > Subject: Slow Response -- What Does This Sound Like to You? > > > > We have a situation where users complain that the system > per

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Rick James
MyISAM? Or InnoDB? Lock_time perhaps applies only to table locks on MyISAM. SHOW ENGINE InnoDB STATUS; You may find some deadlocks. Is Replication involved? Anyone doing an ALTER? > -Original Message- > From: Robinson, Eric [mailto:eric.robin...@psmnv.com] > Sent: Thursday, May 09, 201