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
Subject: RE: [Suspected Spam][Characteristics] RE: Slow Response --
What Does This Sound Like to You?
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
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 periodically
freezes for 30-90 seconds. We check the slow query logs and find that
one user issued a complex query that did indeed take 30-90
-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
periodically
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
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
http://docs.oracle.com/cd/E17952_01/refman-5.5-en/table-locking.html
:
A SELECT statement that takes a long time to run prevents other
sessions
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 a situation where
-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
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
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
: 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, May 09, 2013 1:58 PM
To: mysql@lists.mysql.com
Subject: Slow Response -- What Does
.
Regards
Vikas shukla
-Original Message-
From: Rick James rja...@yahoo-inc.com
Sent: 10-05-2013 07:24
To: Bruce Ferrell bferr...@baywinds.org; mysql@lists.mysql.com
mysql@lists.mysql.com
Subject: RE: Slow Response -- What Does This Sound Like to You?
1. MyISAM locks _tables_. That can
12 matches
Mail list logo