Hi,
I have a question about Metadata Locking.
The short story is that I have a magento installation.
It ran on a mysql 5.1.41 (ubuntu). It was crashing every now and then.
(when trying to insert or delete from certain tables that ware running
sone DDL statements like truncate and alter
Hi!
Nowadays we've conducted something what I can call extended testing of
MySQL on Solaris10/x86.
The most annoying issue is a problem with locking queries to MyISAM-type
tables.
Mechanism seems to be simple to explain - long running query locks table
for READ, next there is some DML query
Hello.
Use SHOW PROCESSLIST and slow-query log to catch the query which locks
tables for a long time. Upgrade to 4.1.13. If you use MyISAM, think
about moving towards InnoDB.
Aaron [EMAIL PROTECTED] wrote:
Hi all ,
I have been experiencing intermittent locking issues with MYSQL.
The first thing I would do is to upgrade the Kernel, as per you r mail
u said u were running 2.4.20-8, get the latest one for RH9 that is
2.4.20-31.9 SMP, and you might see a huge difference, if it doesn't
work, then make sure you have properly indexed the colums, mytop is a
great tool for
Hi all ,
I have been experiencing intermittent locking issues with MYSQL. It
appears that sometimes a query will lock reliease its lock, and is
causing other queries to wait and wait until the connection limit is
reached and i am locked out of the database. Has anyone ever had
anything like
Heikki,
- Original Message -
Terry,
- Original Message -
From: Terry Riley [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 8:15 PM
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion
requests to the server are inevitably slow,
and these seem never to be cleared unless I kill the threads - and I'm not
100% sure how much damage I'm doing in that action.
Is this a possible locking issue? If so, how do I get around it. The
settings for the server are at default, except where noted
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL 4.1.3b-beta
- Original Message -
Thanks for those hints, Dathan (see below):
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Locking Issue?
Can someone help, please?
We set up a server
Terry,
- Original Message -
From: Terry Riley [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 8:15 PM
Subject: Locking Issue?
Can someone help, please?
We set up a server to handle a coldfusion web application (CFMX 6.1)
running against MySQL 4.1.3b
On Tue, 27 Apr 2004, Scott Switzer wrote:
Hi,
I am having a difficult time with a query. My environment is MySQL
v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
Basically, I am running a query of the form:
INSERT INTO temp_tbl
SELECT c1,c2...
FROM t1,t2,t3,t4
WHERE ...
Thanks for the message. I should rephrase - the data set is millions of
rows, but the tables are indexed, and an EXPLAIN looks like it is using
indexes effectively. The query produces the exact same results both
times (with and without LOCKing). Is there a reason that by calling the
query
Hi,
I am having a difficult time with a query. My environment is MySQL
v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
Basically, I am running a query of the form:
INSERT INTO temp_tbl
SELECT c1,c2...
FROM t1,t2,t3,t4
WHERE ...
It is a very complex query, which looks at
through the ids, performing various actions and
updating b with the result.
There's obviously something wrong here, because now that our
volume has ramped up, I'm seeing what looks to be a locking
issue. After the UNLOCK, I do a sanity check, comparing the
number of ids from the SELECT
If you've read my last email, you know what the problem is, but I have now
pinpointed it a bit further using the processlist feature.
[EMAIL PROTECTED] MBPlatforms]# mysqladmin -v processlist -p
Enter password:
Hi. As far as I know, MySQL doesn't suport row-locking, only table locking
is available.
But I figured table locking for sessions table of CGI::Session::MySQL
would be
quite inefficient, for there might be millions of rows and hundreds of
them
could be active at any time. So what do you guys
use InnoDB which does support row-locking (MySQL-Max)
-Original Message-
From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 9:23 AM
To: [EMAIL PROTECTED]; MySQL Maling list
Subject: Row Locking issue in 3.23.x
Hi. As far as I know, MySQL doesn't suport
17 matches
Mail list logo