Kazakevich [mailto:ilya.kazakev...@jetbrains.com]
Sent: Wednesday, April 17, 2013 8:05 AM
To: Rick James
Cc: 'MySQL'
Subject: RE: Mesaure query speed and InnoDB pool
Hello Rick,
Run your query twice; take the second time. For most queries the
first
run brings everything into cache
will increase it now.
But I will need to disable swapping also to prevent my OS from swapping out
InnoDB pages.
Ilya.
-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
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 reads
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
...@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
On Tue, Apr 16, 2013 at 2:23 PM, Ilya
@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
dedicate 1.4Gig to innodb pool, my 64-bit linux machine will start
swapping heavily
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