FAQ
Yeah...... I have to assert that for reporting needs this can be a common
use case. I personally try to avoid it in automated code but crontab code
can certainly need to create tables for reporting.

The main problem (which could solve both issues) is that TRUNCATE TABLE in
NDB is basically just a CREATE TABLE (from what I understand) and so one
wouldn't be able to create the tables ahead of time and just TRUNCATE them
because TRUNCATE isn't available during node restart either.
On 1/26/07, pekka@mysql.com wrote:

We have thousands of create and drop tables daily.
This seems strange.

Are these temp/work tables? Then maybe they can be created
as isam or memory tables.

If not, can you use one big table instead of thousands?
The big table would have an indexed key which says what data
set (previously in separate table) in accessed.

--
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.X.com
pekka@mysql.x.com +46 (0) 73 068 4978

--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:
http://lists.mysql.com/cluster?unsub=burtonator@gmail.com

--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 5 of 5 | next ›
Discussion Overview
groupcluster @
categoriesmysql
postedJan 26, '07 at 7:53p
activeJan 27, '07 at 12:12a
posts5
users3
websitemysql.com
irc#mysql

3 users in discussion

Brian: 2 posts Pekka: 2 posts Kevin Burton: 1 post

People

Translate

site design / logo © 2018 Grokbase