Re: Time performance in query Inner Join
Please post a few INSERT statements, approx 10-20 rows per table.
How much RAM does the machine have?
What is the innodb_buffer_pool_size setting? In fact show the results of
show variables like 'inno%';
show status like 'inno%';
Edited 1 time(s). Last edit at 07/07/2011 01:18PM by Peter Brawley.
Subject
Views
Written By
Posted
3242
July 07, 2011 02:14AM
899
July 07, 2011 06:39AM
1092
July 07, 2011 09:47AM
Re: Time performance in query Inner Join
1005
July 07, 2011 01:10PM
889
July 07, 2011 10:29PM
1144
July 08, 2011 06:52AM
1842
July 08, 2011 07:03AM
941
July 08, 2011 09:07PM
993
July 09, 2011 07:16AM
1024
July 09, 2011 10:49AM
971
July 09, 2011 01:09PM
1236
July 09, 2011 04:54PM
888
July 10, 2011 01:59AM
851
July 10, 2011 12:19PM
1714
July 10, 2011 01:55PM
944
July 10, 2011 04:28PM
942
July 11, 2011 03:01AM
999
July 11, 2011 11:28AM
838
July 12, 2011 10:22AM
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.