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
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
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
11 matches
Mail list logo