How to set up mysql temporary tables at startup

[steve]

I like to create some temprary tables (in-memory tables) when mysql
starts up. How do I do that.

Thanks.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-set-te...ict224284.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=773056

[steve]

"steve" wrote:

I like to create some temprary tables (in-memory tables) when
mysql starts up. How do I do that.

Thanks.

On further reading, I need heap tables, which are shared by all
connections. But the idea should be the same.

[steve]

"steve" wrote:

On further reading, I need heap tables, which are shared by
all connections. But the idea should be the same.

anyone??

[Bill Karwin]

steve wrote:

"steve" wrote:

> On further reading, I need heap tables, which are shared by
> all connections. But the idea should be the same.

anyone??

The definition of heap tables stay around, according to the docs, but
the data within the table evaporates. So you don't have to create the
table at MySQL startup time, you just need to load it with data.

If you're on UNIX/Linux, you can edit the mysqld_safe script that starts
the MySQL daemon. Once the mysqld daemon has been started successfully
within that script, add a line to run the 'mysql' tool to execute a SQL
script which performs any commands you want, such as loading some data
into those heap tables.

If you run the MySQL Server on Windows, I don't have a solution to
suggest for you. There doesn't seem to be an equivalent to the
mysqld_safe script.

Regards,
Bill K.

[steve]

"Bill Karwin1" wrote:

steve wrote:

"steve" wrote:

 > > On further reading, I need heap tables, which are
shared by
 > > all connections. But the idea should be the same.

anyone??

The definition of heap tables stay around, according to the
docs, but
the data within the table evaporates. So you don't have to
create the
table at MySQL startup time, you just need to load it with
data.

If you're on UNIX/Linux, you can edit the mysqld_safe script
that starts
the MySQL daemon. Once the mysqld daemon has been started
successfully
within that script, add a line to run the 'mysql' tool to
execute a SQL
script which performs any commands you want, such as loading
some data
into those heap tables.

If you run the MySQL Server on Windows, I don't have a
solution to
suggest for you. There doesn't seem to be an equivalent to
the
mysqld_safe script.

Regards,
Bill K.

Thanks, Bill. That is what I was missing. Did not realize that the
definitiion stays around, and was thinking of having to redefine the
table every time the server comes back on.

I currently use CacheLite to implement caching (I long for ASP’s
Application variable). I am thinking of using temp tables instead,
but looks like they don’t support text fields, so pretty limited.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/mySQL-set-te...ict224284.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=778978