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

2013-05-09 Thread Vikas Shukla
Hi everybody, I think we need to focus on three things:- A) temp tables created on disk B) table cache size C) buffer sizes If you find the number of temp tables created on disk is very large, please increase the temp_table_size. Enable the slow query log And check if sort buffer size and join

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

2013-05-09 Thread Rick James
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 trouble than it

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, May

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:25, Robinson, Eric wrote: > >

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