Hello.
State: Sending data
MySQL server shouldn't spend several days in state of sending one row (your
query should return only one row :) to the client. Server doesn't work
properly and steps like upgrade or switching to the official binaries
might be helpful.
The query has
Hi all!
Gleb Paharenko wrote:
Hello.
I have a query that is taking days to complete (not good). If I change
Really, not good. What does SHOW PROCESSLIST report about the thread of
this query?
The query has been running for ~5 days now:
Id: 27977
User: root
Host:
David Sparks [EMAIL PROTECTED] wrote on 08/08/2005 12:20:41 PM:
Hi all!
Gleb Paharenko wrote:
Hello.
I have a query that is taking days to complete (not good). If I
change
Really, not good. What does SHOW PROCESSLIST report about the thread
of
this query?
The
Hello.
I have a query that is taking days to complete (not good). If I change
Really, not good. What does SHOW PROCESSLIST report about the thread of
this query?
David Sparks [EMAIL PROTECTED] wrote:
I have a query that is taking days to complete (not good). If I change
Hi David, all!
David Sparks wrote:
I have a query that is taking days to complete (not good). If I change
the query so that it selects less rows it runs fast.
I fear I have no decisive hint for this (sorry), but still ...
[[...]]
mysql select count(*) from msgs where message_id
Joerg Bruehe [EMAIL PROTECTED] wrote on 08/05/2005 02:08:35 PM:
Hi David, all!
David Sparks wrote:
I have a query that is taking days to complete (not good). If I
change
the query so that it selects less rows it runs fast.
I fear I have no decisive hint for this (sorry), but still
Hi Shawn, all!
[EMAIL PROTECTED] wrote:
Joerg Bruehe [EMAIL PROTECTED] wrote on 08/05/2005 02:08:35 PM:
[[...]]
Have you considered using BETWEEN?
[[...]]
Actually, no, he cannot substitute BETWEEN as BETWEEN is _inclusive_ of
the boundary conditions (a closed interval). In this case he
On Fri, 5 Aug 2005, Joerg Bruehe wrote:
Hi Shawn, all!
Still, I would consider to replace
X A AND X B
by
X BETWEEN (A+1) AND (B-1)
for the reasons I gave in my original post (provided we talk about integral
values).
the field is a DOUBLE, so you can't could this also explain why
I have a query that is taking days to complete (not good). If I change
the query so that it selects less rows it runs fast.
I ran an explain on both queries and it didn't give any hints as to why
the one query is taking days to run. In fact explain knows how many
rows each query will examine.
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
If I identify a user that is causing a problem is there a way
mysqladmin proc
mysqladmin kill ${Id} // The id that is causing the problem
---Original Message-
--From: Bill Todd [mailto:[EMAIL PROTECTED]
--Sent: Wednesday, September 10, 2003 11:51 AM
--To: MySQL List (E-mail)
--Subject: How identify long running query etc?
--
--Using MySQL
On Wed, Sep 10, 2003 at 11:50:43AM -0700, Bill Todd wrote:
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
I did a dump of a table from another database table and wanted to run
the .sql file in another database. I used PHPadmin to do this and used
phpadmin to run the .sql file against the other database
I have this is the error from mysql:
SQL-query :
CREATE TABLE tblmembers (
ID int(11)
By is not a legal data type
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: Running Query
I did a dump of a table from another database table and wanted to run
the .sql file in another database
'; '[EMAIL PROTECTED]'
Subject: RE: Running Query
By is not a legal data type.
Did you mean By text, without the word Modified?
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: Running Query
I did
By is not a legal data type.
Did you mean By text, without the word Modified?
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: Running Query
I did a dump of a table from another database table
16 matches
Mail list logo