y Wallace [mailto:awall...@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 &
re than 10,000 pages.
10,000 * 10,000 = 100 million !
> -Original Message-
> From: Andy Wallace [mailto:awall...@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 q
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
---Original Message-
> From: Adarsh Sharma [mailto:eddy.ada...@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` (
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,
`
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 wrote:
>
>
> 2012/9/5 Adarsh Sharma
>
>> Actually that query is not my concern :
>>
>> i have a query that is taking so much time :
>> Slow Log Output :
>>
2012/9/5 Adarsh Sharma
> 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
> # Attribute tota
f so, the query
> will get slower. Meanwhile, the index 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:
ll
get slower. Meanwhile, the index 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: Understa
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 wrote:
> Hi all,
>
> I am using Mysql Ver 14.14 Distrib 5.1.58 in which i enabled sl
>
> 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
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 is in
to setup the machine 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 tha
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 wrote:
> Hi All
>
>
>
>I hope that someone can assist me with this.
>
>
>
>We have a client
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
Jaime 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 :
> Hello All. I would like to implement MYSQL slow query log in table. Can
&
2009/10/7 Brown, Charles :
> 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
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
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles 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 uti
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
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 is
Is there anyway to keep updates and deletes from showing up in the slow
query logs?
# 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
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 quer
--+
| NULL |
++
1 row in set (0.00 sec)
On 12/31/08, Baron Schwartz wrote:
>
> Hi,
>
> On Wed, Dec 31, 2008 at 8:44 AM, Ananda Kumar wrote:
> > Hi All,
> > I have enabled slow query log.
> > Generally this file will have s
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 arch
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 les
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
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] @ loca
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
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 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
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 it
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
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;
# [
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 PROTEC
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,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
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
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
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 my server?
>
--
For technical support
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 the SQL of the queries
causing slow-downs.
Did I made some mistake in config
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 | HOS
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,
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.
Bu
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://N
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
|
| To: [EMAIL PROTECTED]
|
| cc: [EMAIL PROTECTED]
|
| Subject: Re: How to turn on
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
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.
sl
;
Sent: Friday, July 20, 2001 12:05 AM
Subject: Re: Perl Script: MySQL Slow Query Log Parser
> 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
> >
&
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
> 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
sho
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
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
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 queries
63 matches
Mail list logo