Table Locking Memory Engine

[Daniel Oneil]

Hello I have switched to memory engine. I do not see a performance issue with mysql after switching. I get about 250 queries a second on one table. All data that is entered is very small the database used to be 6mb with innodb but is around 30mb with memory engine. It has on avg 10.000 rows insert,update,delete are most the queries. I ran mysql tuner and notice in phpmyadmin these are two things that shows up red

Mysql Tuner
[!!] Table locks acquired immediately: 82%

Phpmyadmin
Table_locks_waited 34K

Thats after I just reset the server and the phpmyadmin table lock keeps going up is there something I should be concerned about?

My serverload with linux went from 2.0 to .06 using memory I like using memory. the data inst important if I reset the server it will come back.

I have a quad core with 16GB ram.

Thanks



Edited 4 time(s). Last edit at 08/07/2011 12:47AM by Daniel Oneil.