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 <
> 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