MySQL Forums
Forum List  »  Memory Storage Engine

Re: Memory Engine Performance
Posted by: Gionni Tiozzo
Date: May 21, 2009 04:19AM

I just tried out heap as well and I confirm the performance (500k rows) is super good... for 1 person. But what if cuncurrency matters?

1. On tech pages they say "memory tables use table-level locking which gives low write concurrency". Fortunately it happens to me that I do only select but seems like lock still remains. Can you confirm that?

2. There is any chance to recompile source eliminating pthread_mutex_lock? Or is there any configuration in my.cnf? Did someone achieve?

Thanks so much for any experience sharing,
Johnny

Options: ReplyQuote


Subject
Views
Written By
Posted
18590
January 28, 2009 07:51AM
8617
May 15, 2009 01:41AM
Re: Memory Engine Performance
8663
May 21, 2009 04:19AM
7516
May 22, 2009 05:39AM


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.