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 h
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
> >
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
Ho
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
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
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), bu
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 > 112
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
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.
P
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
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 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
"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
To: 'Todd Williamsen'; '[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,
"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
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) defau
16 matches
Mail list logo
