MySQL Forums
Forum List  »  Memory Storage Engine

Re: my.cnf variables for memory tables
Posted by: Ingo Strüwing
Date: February 14, 2006 04:29AM

I believe that there is no other setting for memory tables.

I tend to answer yes to zero all cache sizes. But one thing comes to mind. If you select data from your tables, temporary tables might be created for the result. For joins these could become much bigger that your data size. If they exceed tmp_table_size they will be converted into MyISAM tables. If this happens, you should not have zeroed all cache sizes.

While typing I got aware of the query cache. It is table type independend. Depending on your statements it might be good to keep it.

There may be other thing too. I did not hear of an application like yours before. So surprises are expected. :-) I would be glad to hear how it works for you.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
8797
February 13, 2006 06:22AM
Re: my.cnf variables for memory tables
5310
February 14, 2006 04:29AM
4440
February 14, 2006 03:14PM


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.