l 16, 2013 2:06 AM
>> To: Ilya Kazakevich
>> Cc: MySQL
>> Subject: Re: Mesaure query speed and InnoDB pool
>>
>> Does your query use proper indexes.
>> Does your query scan less number blocks/rows can you share the explain
>> plan of the sql
>>
>>
ze is probably the biggest
memory consumer, so it is the easiest way to shrink mysqld's footprint.
> -Original Message-
> From: Ilya Kazakevich [mailto:ilya.kazakev...@jetbrains.com]
> Sent: Wednesday, April 17, 2013 8:05 AM
> To: Rick James
> Cc: 'MySQL'
> Su
to about 70% of available
RAM.
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
Sent: Tuesday, April 16, 2013 2:06 AM
To: Ilya Kazakevich
Cc: MySQL
Subject: Re: Mesaure query speed and InnoDB pool
Does your query use proper indexes.
Does your query scan less number
Sent: Tuesday, April 16, 2013 8:38 AM
> To: mysql@lists.mysql.com
> Subject: Re: Mesaure query speed and InnoDB pool
>
> Hi Rick,
> I thought you have to dedicate 70-80% of available RAM not a total RAM.
> Saying if I have 2 gig of RAM on my exclusively innodb box, and I
&
o:anan...@gmail.com]
> Sent: Tuesday, April 16, 2013 2:06 AM
> To: Ilya Kazakevich
> Cc: MySQL
> Subject: Re: Mesaure query speed and InnoDB pool
>
> Does your query use proper indexes.
> Does your query scan less number blocks/rows can you share the explain
> plan of the sql
>
Hello,
I have 12Gb DB and 1Gb InnoDB pool. My query takes 50 seconds when it reads
data from disk and about 2 seconds when data already exists in pool. And it
may take 10 seconds when _some_ pages are on disk and some are in pool.
So, what is the best way to test query performance? I have several
Does your query use proper indexes.
Does your query scan less number blocks/rows
can you share the explain plan of the sql
On Tue, Apr 16, 2013 at 2:23 PM, Ilya Kazakevich <
ilya.kazakev...@jetbrains.com> wrote:
> Hello,
>
> I have 12Gb DB and 1Gb InnoDB pool. My query takes 50 seconds when it r
