MySQL Forums
Forum List  »  Memory Storage Engine

Heap Table: How to define
Posted by: Bodo Fritsche
Date: March 29, 2006 03:42AM


I am still learning a lot about mySQL, so any advice is appreciated.

I use mySQL for a forum (about 50.000 entries) and about 30-100 users at the same time.

The application shows some user statistics (users online etc.) that are maintained in a small table.

As this table is accessed often but need not to be stored on disk (as it were temporary), my idea is to define it as a heap table in mySQL 4.0.18.

Today's definition:

CREATE TABLE `forum_useronline` (
`ip` char(15) NOT NULL default '',
`time` int(14) NOT NULL default '0',
`user_id` int(11) default '0'

-- Daten für Tabelle `forum_useronline`

INSERT INTO `forum_useronline` VALUES ('', 1143624409, 0);
INSERT INTO `forum_useronline` VALUES ('', 1143624637, 0);
INSERT INTO `forum_useronline` VALUES ('', 1143624790, 0);

How can I define this table to be only maintained in memory?

Can I modify the table to be heap when the server is running?

What other parameters have to be set?

As I do not have access rights to the root server, I need kind of detailled statements to be directed to my hosting provider.

Thanks for any ideas and help.


Options: ReplyQuote

Written By
Heap Table: How to define
March 29, 2006 03:42AM
March 29, 2006 07:46AM
March 30, 2006 01:00AM

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.