MySQL Forums
Forum List  »  Memory Storage Engine

Insert response time in Memory Tables
Posted by: Chooi Ting Goon
Date: July 04, 2008 03:41AM

I am having inconsistent insert response time in my application. It take 1-2 ms to complete the insert query during beginning of the program when there is less data in the table. When it run for a long time, it takes about 300ms to complete an insert statement. We have other module who will access the table(select), update and delete the records. Question is how can I fine tune MysQL server parameters in order to shortern the insert response time ? If I were to fine tune MySQL parameter on memory table, the parameter involve will be max_heap_table_size and tmp_table_size ??

Options: ReplyQuote

Written By
Insert response time in Memory Tables
July 04, 2008 03:41AM

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.