MySQL Forums
Forum List  »  Memory Storage Engine

Speed of reading decreases in time
Posted by: Andrey Shchurkov
Date: May 23, 2011 04:58AM

I have a procedure that simulates some objects and for each simulated object it does a lot of reading from two memory tables with 40-50 mln records in each.

Number of reads from that tables for each simulated object is about 50.

The issue is that when I start simulating some number of objects, simulation speed of first object is about 0.25 sec/object. But the speed decreases in time - after simulated 2,000 objects the speed is about 10 sec/object, after 5,000 objects - 70 sec/object.

And the slowest queries are reads from these two memory tables.

Memory limits should be okay:
max_heap_table_size = 20G
tmp_table_size = 2G

P.S. I do only reads - no inserts or updates.

Options: ReplyQuote

Written By
Speed of reading decreases in time
May 23, 2011 04:58AM

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.