# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 150
SELECT SUM(COUNTER_VALUE) FROM STO_LIS sl, SCAT_LIS sfl WHERE l.STO_LIS_ID
=sfl.LIS_ID AND sfl.CAT_ID = '-1';
This is what is there in the slow-query log
On 1/2/09, Baron Schwartz wrote:
>
> It executes in 0 sec when you run it.
It executes in 0 sec when you run it. It might be in the query cache.
Try it with SQL_NO_CACHE. But even then it might run faster than it
did when it got logged in the slow log, because the table's data might
be in memory and therefore faster to access.
The point is that the slow query log show
mysql> explain SELECT SUM(COUNTER_VALUE) FROM STO_LIS sl,
-> SCAT_LIS sfl WHERE sl.STO_LIS_ID =
-> sfl.LIS_ID AND sfl.CAT_ID = '-1';
++-+---+--+---+---+-+-+--+-+
| id | select_type | ta
I'm just guessing, but if the slow query log time resolution is seconds,
perhaps 0.5 and higher rounds up?
Or, perhaps it has an index, but it can't be used in that query.
What does EXPLAIN [paste query here] tell you?
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Wow! 70k files in /tmp. Hell of a mistake :) I hope it doesn't happen often.
Arthur
On 3/17/08, Soenke Ruempler - NorthClick <[EMAIL PROTECTED]> wrote:
>
> Hi Baron,
>
>
> There were about 70k files in /tmp (caused by a mistake). the web
> application on this server had many lookups to tmp and tho
Hi Baron,
Baron Schwartz wrote:
I'd be interested to know what filesystem you're using and how big the
directories are. When you say big, do you mean number of entries in
the directory, or space used?
There were about 70k files in /tmp (caused by a mistake). the web
application on this serv
Hi,
On Mon, Mar 17, 2008 at 12:59 PM, Soenke Ruempler - NorthClick
<[EMAIL PROTECTED]> wrote:
> hi again,
>
> for those that are interested: the problem was indeed the filesystem
> with slow lookups of BIG directories (this had nothing to do with mysql
> but caused much iowait and therefore the
hi again,
for those that are interested: the problem was indeed the filesystem
with slow lookups of BIG directories (this had nothing to do with mysql
but caused much iowait and therefore the mysql process had been heavily
impacted).
Soenke Ruempler - NorthClick wrote:
I assume that those s
TK wrote:
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
# [
2006/4/5, Mechain Marc <[EMAIL PROTECTED]>:
> Hi,
>
> Thank you for your answer.
> But is there a chance to be able to do it one day?
> I think it could be a nice feature.
>
You still have the option to sponsor that feature ;-D
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Mechain Marc wrote:
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
That should be asked to one of the devs.
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
-Message d'origine-
De : Petr Chardin [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 avril 2006 13:06
À : Mechain Marc
Cc : MySQL
Objet : Re: Slow query lo
On Wed, 2006-04-05 at 11:38 +0200, Mechain Marc wrote:
> Is there a way to enable the Slow Query Log on the fly without having to
> restart mysqld
No.
Petr
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
You have an application which executes prepared statements.
See:
http://dev.mysql.com/doc/mysql/en/c-api-prepared-statements.html
MySQL doesn't log to the slow log a prepared statement. You
can enable general query log which logs prepared statements.
Andrea Gangini <[EMAIL
Hi,
I think log-slow-queries belongs in the [mysqld] section of my.cnf, not
[mysqld_safe].
Hope that helps.
Matt
- Original Message -
From: "MaFai"
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 05, 2003 9:00 PM
Subject: Slow query log setting
> Hello, mysql,
>
> I have set the
15 matches
Mail list logo