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 slow query log
> by setting bel
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 :
> Hi all,
>
> I am
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
12 matches
Mail list logo