MySQL Forums
Forum List  »  Performance

Re: Time performance in query Inner Join
Posted by: angel rivero
Date: July 09, 2011 01:09PM

Rick James Wrote:
-------------------------------------------------------
> > > Change to 1600M
> Edit my.cnf (my.ini), then restart mysqld
>
> EXPLAIN SELECT ...
> (Run that with your actual SELECT statement;
> provide us with the output.)

Ok Rick, thks:
innodb_buffer_pool_size 112197632 in browser
Time: 95,381ms

innodb_buffer_pool_size 112197632 in mysql
Time: 90.709ms

innodb_buffer_pool_size 1600M in browser
Time: 63,731ms

innodb_buffer_pool_size 1600M in mysql
Time: 66.201ms

You can decrease over time?



Edited 1 time(s). Last edit at 07/09/2011 01:28PM by angel rivero.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Time performance in query Inner Join
970
July 09, 2011 01:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.