- Original Message -
From: nixofortune nixofort...@gmail.com
Few more things. You can't have a deadlock on Mylsam table. You can
You *can* have deadlocks in MyISAM; the concept is not related to any specific
engine - or even databases.
What you can't have, is deadlock on a single
Yes indeed,
but I think we are talking about MySQL level deadlocks,
that can happen only with row level locking and transactions.
If the deadlock is generated at application level then you can have it on
anything, also blackhole :-)
Claudio
2012/5/9 Johan De Meersman vegiv...@tuxera.be
-
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
Yes indeed,
but I think we are talking about MySQL level deadlocks,
that can happen only with row level locking and transactions.
If the deadlock is generated at application level then you can have
it on anything,
On 5/9/2012 6:17 AM, Johan De Meersman wrote:
- Original Message -
From: Claudio Nanniclaudio.na...@gmail.com
Yes indeed,
but I think we are talking about MySQL level deadlocks,
that can happen only with row level locking and transactions.
If the deadlock is generated at application
Chech your query log for queries hitting that tables. Myisam tables dont have
row level locking. There is probably a slow query somewhere.
Sent from my iPhone
On May 8, 2012, at 10:04 AM, abhishek jain abhishek.netj...@gmail.com wrote:
Hi
I am facing a strange problem, from the last few
Hi
Thanks,
Where can i find query log for previous one,or i have to do some config in
my.ini file, please let me know,
Thanks
Abhi
-Original Message-
From: Darryle [mailto:dstepli...@gmail.com]
Sent: 08 May 2012 19:42
To: abhishek jain
Cc: mysql@lists.mysql.com
Subject: Re: One table
to do some config in
my.ini file, please let me know,
Thanks
Abhi
-Original Message-
From: Darryle [mailto:dstepli...@gmail.com]
Sent: 08 May 2012 19:42
To: abhishek jain
Cc: mysql@lists.mysql.com
Subject: Re: One table gets locked by itself
Chech your query log for queries hitting
Subject: Re: One table gets locked by itself
In your my.conf or configuration file look for an attribute that says
LOG_SLOW_QUERIES , that should point to the path of your slow query
log.
On Tue, May 8, 2012 at 10:19 AM, abhishek jain
abhishek.netj...@gmail.com wrote:
Hi
Thanks,
Where
the non-Locked entry is the villain.
-Original Message-
From: Darryle Steplight [mailto:dstepli...@gmail.com]
Sent: Tuesday, May 08, 2012 7:32 AM
To: abhishek jain
Cc: mysql@lists.mysql.com
Subject: Re: One table gets locked by itself
In your my.conf or configuration file look
You might run out of file desciptors. Check your open file limits, open
table limits vars and corresponding syatus values
On 8 May 2012 15:05, abhishek jain abhishek.netj...@gmail.com wrote:
Hi
I am facing a strange problem, from the last few days in one of my projects
in production, i find
My plan B was basically what Rick and Claudio said. Check your my.conf
file for this variable LONG_QUERY_TIME . That determines how long a
query will run before it's considered slow. You may need to adjust
that setting, but that will just get rid of the symptom and not the
problem at hand.
Few more things. You can't have a deadlock on Mylsam table. You can check
status of your tables in use with: SHOW OPEN TABLES WHERE IN_USE !=0 you
might check mysqld error log ad well
On 8 May 2012 18:42, nixofortune nixofort...@gmail.com wrote:
You might run out of file desciptors. Check your
Right,
Technically not a deadlock,
Practically yes if hundreds of threads are waiting on the same mutex,
Like key cache one or query cache or any other mutex.
Claudio
On May 8, 2012 7:51 PM, nixofortune nixofort...@gmail.com wrote:
Few more things. You can't have a deadlock on Mylsam table. You
13 matches
Mail list logo