Hi, > >> isnt the engine supposed to know the size of tables?
with release 7.6 it does. For tables created in release 7.6 they are always available. However, if you have migrated from a lower release (e.g. 7.5) these counters have to be initialized first. With release 7.6.00.16 it's easiest to do this by doing 'Check Data With Update' in admin mode on your database. In a future release these counters will be initialized automatically while the database is idle. You can check the current values for the sizes in the system table FILES. Files whose counters haven't been initialized yet will show NULL values for the sizes. To get the name of the tables you can join the column FILEID with TABLEID from TABLES (or FILEID from INDEXES for indexes). HTH, Martin. SAP Labs, Berlin. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
