Re: Understanding Slow Query Log

2012-09-05 Thread Manuel Arostegui
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 #

Re: Understanding Slow Query Log

2012-09-05 Thread Adarsh Sharma
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

Re: Understanding Slow Query Log

2012-09-05 Thread Adarsh Sharma
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,

RE: Understanding Slow Query Log

2012-09-05 Thread Rick James
...@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

Re: Understanding Slow Query Log

2012-09-05 Thread Andy Wallace
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

RE: Understanding Slow Query Log

2012-09-05 Thread Rick James
...@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

Re: Understanding Slow Query Log

2012-09-05 Thread Andy Wallace
: 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

RE: Understanding Slow Query Log

2012-09-04 Thread Rick James
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

Re: Understanding Slow Query Log

2012-09-04 Thread Adarsh Sharma
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

Re: Understanding Slow Query Log

2012-09-01 Thread yoku ts
Hi Because of that, those queries don't use index. log-queries-not-using-indexes works even if query time less than long-query-time. http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_log-queries-not-using-indexes regards, yoku 2012/9/1 Adarsh Sharma

Re: Understanding Slow Query Log

2012-09-01 Thread Suresh Kuna
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