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 > 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 ideas: > * Count 'Innodb_rows_read' or 'Innodb_pages_read' instead of actual time > * Set pool as small as possible to reduce its effect on query speed > * Set pool larger than my db and run query to load all data into pool and > measure speed then > > How do you measure your queries' speed? > > Ilya Kazakevich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
