Re: MySql hanging

Thanks. I was already looking at ways to rewrite this query - the link will be helpful. I would have expected the query to be slow, but it looked to me like the database stopped processing the query at all after a while. Now that I understand just how slow it might be even under the best of circu

Re: MySql hanging

Bill Duffy <[EMAIL PROTECTED]> wrote on 08/31/2005 11:32:02 AM: > When I run a query like this > > DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM > test_x_RM_4508_48875 ) > > it never completes. > > test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains 22,957,70

MySql hanging

When I run a query like this DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM test_x_RM_4508_48875 ) it never completes. test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains 22,957,702 rows. There does not appear to be any iowait problem and CPU is about 50 % in us

Re: FBSD/Mysql hanging every 6-8hr

... Subject: FBSD/Mysql hanging every 6-8hrs From: Crescent Kao Date: Sun, 02 Feb 2003 10:03:58 + Hello everyone! This is my first time posting on this mailing list, a Mysql

FBSD/Mysql hanging every 6-8hrs

Hello everyone! This is my first time posting on this mailing list, a Mysql developer referred me here in hopes that I can find some solutions to our fairly unique situation. I’m pretty new to FBSD and Mysql so please bare with me. I am the part owner of a pretty large website – www.mid

mysql hanging

I've been having some problems with MySQL-4.0.1-2 on RedHat 7.2 rpms MySQL-Max-4.0.1-2 MySQL-4.0.1-2 MySQL-shared-4.0.1-2 MySQL-devel-4.0.1-2 Occasionally the server enters into a strange state where it will refuse to do much of anything. Commands hang in the mysql client. Com

RE: mysql hanging on mysqldump output

Problem: No space left on device Solution: Pay more attention to partition sizes I would have expected mysql to start failing queries on such an event. -Original Message- From: Lance Lovette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 8:08 PM To: MySQL Subject: mysql

mysql hanging on mysqldump output

I am trying to copy data from one database to another using output from mysqldump version 8.11 distributed with 3.23.28-gamma. The problem is that part way through importing the data into the target database, mysql just hangs. When I show the process list, there is only one query, and it's stuck i