I keep some temporary data in a memory table. I only need the 20 most recent entries and would prefer the data is always be on the heap. How should i accomplish this? i am sure theres nothing i can do about the memory table but how should i handle entries tables? should i add a autoincrease key and delete the oldest whenever i want to pu...
Hi, I have multiple tables created in MySQL Memory Engine. Except for 3 tables, all other tables will be updated daily (all the records). We recently noticed that data in one/more of these tables is being deleted after around 14 days (with No data modification statements executed). The data is not completely truncated in a table. Som...
I have a couple of questions regarding MySQL indexing: 1) Is there any speed increase when indexing a table stored in memory? 2) When searching my table I match on column field, would indexing every column defeat the purpose of an index? Many thanks. ...