2012/9/5 Adarsh Sharma eddy.ada...@gmail.com
Actually that query is not my concern :
i have a query that is taking so much time :
Slow Log Output :
# Overall: 195 total, 16 unique, 0.00 QPS, 0.31x concurrency _
# Time range: 2012-09-01 14:30:01 to 2012-09-04 14:13:46
#
I already attached the list.
Attaching one more time thanks for the interest.
Cheers
On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui man...@tuenti.com wrote:
2012/9/5 Adarsh Sharma eddy.ada...@gmail.com
Actually that query is not my concern :
i have a query that is taking so much
true Michael, pasting the output :
CREATE TABLE `WF_1` (
`id` varchar(255) NOT NULL,
`app_name` varchar(255) DEFAULT NULL,
`app_path` varchar(255) DEFAULT NULL,
`conf` text,
`group_name` varchar(255) DEFAULT NULL,
`parent_id` varchar(255) DEFAULT NULL,
`run` int(11) DEFAULT NULL,
...@gmail.com]
Sent: Wednesday, September 05, 2012 11:27 AM
To: Michael Dykman
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
true Michael, pasting the output :
CREATE TABLE `WF_1` (
`id` varchar(255) NOT NULL,
`app_name` varchar(255) DEFAULT NULL,
`app_path
Ok, this raises a question for me - what's a better way to do pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed
...@ihouseweb.com]
Sent: Wednesday, September 05, 2012 2:05 PM
To: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Ok, this raises a question for me - what's a better way to do
pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET
: Understanding Slow Query Log
Ok, this raises a question for me - what's a better way to do
pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes
I suggested will (probably) be much faster.
-Original Message-
From: Suresh Kuna [mailto:sureshkumar...@gmail.com]
Sent: Saturday, September 01, 2012 1:03 AM
To: Adarsh Sharma
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Disable log-queries-not-using-indexes
Message-
From: Suresh Kuna [mailto:sureshkumar...@gmail.com]
Sent: Saturday, September 01, 2012 1:03 AM
To: Adarsh Sharma
Cc: mysql@lists.mysql.com
Subject: Re: Understanding Slow Query Log
Disable log-queries-not-using-indexes to log only queries 100 sec.
Just do /var/lib
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
by setting below parameters in my.cnf :
log-slow-queries=/usr/local/mysql/slow-query.log
long_query_time=100
log-queries-not-using-indexes
I am assuming from the inf. from the internet that long_query_time
...@gmail.com:
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
by setting below parameters in my.cnf :
log-slow-queries=/usr/local/mysql/slow-query.log
long_query_time=100
log-queries-not-using-indexes
I am assuming from the inf. from the internet
Disable log-queries-not-using-indexes to log only queries 100 sec.
Just do /var/lib/mysql/slow-queries.log it will clear the log.
On Sat, Sep 1, 2012 at 12:34 PM, Adarsh Sharma eddy.ada...@gmail.comwrote:
Hi all,
I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled slow query log
Hi Machiel,
The below link will help you.
mk-query-digesthttp://www.xaprb.com/blog/category/maatkit/
Regards,
Krishna
On Tue, Feb 16, 2010 at 12:51 PM, Machiel Richards machi...@rdc.co.zawrote:
Hi All
I hope that someone can assist me with this.
We have
with the Slow Query Log
enabled but to use a very large value of --long-query-time to
essentially ignore every query. Then, when you want to capture slow
queries, you reset --long-query-time to a reasonable value.
Unfortunately, this requires a restart to initialize. After that you can
adjust
Hi All
I hope that someone can assist me with this.
We have a client with a production MySQL database running
MySQL 5.0.
Their slow query counts have skyrocketed over the last week
and I found that their slow query logs are
Use an etl tool like Talend to load the slow query log into a table. We do
something similar with the general query log very successfully with mysql 5
Even with 5.1 i would use this approach over the built in log tables as the
built in log tables impact performance quite significantly
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
SHOW CREATE TABLE mysql.slow_log;
http://dev.mysql.com/doc/refman/5.1/en/log-tables.html
--
Jaime Crespo
Crespo Rincón [mailto:jcre...@warp.es]
Sent: Thursday, October 08, 2009 10:17 AM
To: Brown, Charles
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: MYSQL slow query log in table.
2009/10/7 Brown, Charles cbr...@bmi.com:
Hello All. I would like to implement MYSQL slow query log in table
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
Thanks so much in advance
This message is intended only for the use of the Addressee and
may contain
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log?
Thanks
This message
Meyer; Mark Phillips
Subject: Questions on un-index searches and slow-query-log
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles cbr...@bmi.com wrote:
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any
Is there anyway to keep updates and deletes from showing up in the slow
query logs?
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
# 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 ba...@xaprb.com wrote:
It executes in 0 sec when
|
++
1 row in set (0.00 sec)
On 12/31/08, Baron Schwartz ba...@xaprb.com wrote:
Hi,
On Wed, Dec 31, 2008 at 8:44 AM, Ananda Kumar anan...@gmail.com wrote:
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time
Hi All,
I have enabled slow query log.
Generally this file will have sql's which take more than long-query time to
execute and also sql's not using indexes.
But i see sql's which does not come under the above condition.
I have set the long-query time to 1 Sec .
The query takes less than 1 sec
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
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
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 mysql
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
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 those were
hi,
I've just ran into some problems analyzing the slow-query-log.
1. I have many entries like:
# Time: 080312 13:07:33
# [EMAIL PROTECTED]: cms[cms] @ localhost []
# Query_time: 17 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
COMMIT;
# [EMAIL PROTECTED]: cms[cms] @ localhost
I want to know how to configurate slow-query-log to let it not record the
update sql.
I just want to know how the slow select statement ,not the update or insert.
Anybody's reply is appreciated,thanks.
--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
I would like to empty the slow query log without restarting MySQL.
If I simply delete lines, the server will no longer write to the file. I have
tried leaving the header, but still no writes unless I restart MySQL.
I am on RHEL4.
The group and owner of the file are correct:
4 -rw-rw
On 8/7/07, Boyd Hemphill [EMAIL PROTECTED] wrote:
I would like to empty the slow query log without restarting MySQL.
If I simply delete lines, the server will no longer write to the file. I
have tried leaving the header, but still no writes unless I restart MySQL.
I am on RHEL4.
The group
Before I do this, I just wanted to check with you all to see if this
is the correct command:
/etc/rc.d/init.d/mysqld restart --log-slow-queries
If so, where exactly will I find the slow query log?
Will the slow query log be turned off by default next time I restart it?
--
MySQL General
Brian Dunning wrote:
Before I do this, I just wanted to check with you all to see if this is
the correct command:
/etc/rc.d/init.d/mysqld restart --log-slow-queries
If so, where exactly will I find the slow query log?
Will the slow query log be turned off by default next time I restart
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;
# [EMAIL
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;
#
Hello,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
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]
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 log
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
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:
I have entries in my slow query log for identical queries but, as you can see
from the log entries below (including one irrelevant query), the number rows
examined and returned varies. The tables are _not_ being updated.
The query cache is 'on demand', so I'm also not sure why the subsequent
Hi,
Could anyone explain what might be the possible reasons that in the slow
query log(running read-only queries) the most very slow queries(taking
200-300sec) were the queries:
1. create table ... type = MyISAM
2. show slave status
Thanks,
Jenny
command: Prepare Execute;
# Time: 050207 16:32:32
# [EMAIL PROTECTED]: mmareuser[mmareuser] @ localhost.localdomain [127.0.0.1]
# Query_time: 28 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
# administrator command: Prepare Execute;
I thought that the slow query log would dump
PROTECTED]: mmareuser[mmareuser] @ localhost.localdomain [127.0.0.1]
# Query_time: 28 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
# administrator command: Prepare Execute;
I thought that the slow query log would dump the SQL of the queries
causing slow-downs.
Did I made some mistake in configuring
I noticed something interesting with our slow-query log and am looking for
an answer.
Our slow-query log is set for to record anything over 7 seconds.
In monitoring the server I ran the show full processlist I occasionally
see entries like
| ID | USER | HOST | DATABASE | Query
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 slow
Hello, mysql,
I have set the slow query parameter in the my.cnf as the following.
[safe_mysqld]
err-log=/var/log/mysqld.log
log-slow-queries=/var/log/mysqlslow.log
pid-file=/var/run/mysqld/mysqld.pid
After I check the status of mysql today,we found 6 slow query occur.
Is there a way to not have mysql put fulltext searches in the slow query
log?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
At 10:53 -0700 8/9/02, Steven Roussey wrote:
Is there a way to not have mysql put fulltext searches in the slow query
log?
Not FULLTEXT queries specifically. You can bump up long_query_time, but
that applies to all queries.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it says it
couldn't recognize the option. Here's what I have for my.ini file, any
other way I have to type it? Please advise.
slow query log#=c
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote:
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it
says it couldn't recognize the option. Here's what I have for my.ini
file, any
PROTECTED]
|
| cc: [EMAIL PROTECTED]
|
| Subject: Re: How to turn on Slow Query Log
Great. Thanks.
Tim.
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Tim Bunce [EMAIL PROTECTED]
Cc: Nathanial Hendler [EMAIL PROTECTED]; Mysql
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 20, 2001 12:05 AM
Subject: Re: Perl Script: MySQL Slow Query Log
On Wed, Jun 27, 2001 at 01:45:27PM +0100, Tim Bunce wrote:
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
I've submitted a patch against the manual to
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
Tim.
On Mon, Jun 25, 2001 at 11:59:59PM -0700, Nathanial Hendler wrote:
I wrote a perl script that will parse
any idea where any sort of documentation/tutorial can be found?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 1:45 PM
To: Nathanial Hendler
Cc: Mysql; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Perl Script: MySQL Slow Query Log Parser
You'll find mysqldumpslow (in the mysql distribution) does all that and
much much more
Sorry, not on my server (MySQL 3.22.32).
It's a pity that it's not mentioned in the online documentation
since it's a _very_ useful tool.
http://www.mysql.com/udmsearch/search.php?q=mysqldumpslow
shows
I wrote a perl script that will parse slow_queries logs, and output some
useful information. It's kind of hard to explain, but I'll try. I wanted to
see what queries were taking a lot of time, and how often they were
happening. I wrote a perl script that parses the log files, ignores
63 matches
Mail list logo
