If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query like this. A casual scan of the mysql tables don't show any sizes and I don't know of a way to get table/database size via SQL.
mysql> select table_schema, sum(DATA_LENGTH) from information_schema.tables group by 1; +--------------------+------------------+ | table_schema | sum(DATA_LENGTH) | +--------------------+------------------+ | information_schema | 0 | | mailprint | 2523448288 | | mysql | 275126 | | test | 16510 | +--------------------+------------------+ 4 rows in set, 79 warnings (6.22 sec) -----Original Message----- From: Salama hussein [mailto:[EMAIL PROTECTED] Sent: Friday, June 10, 2005 1:31 PM To: mysql@lists.mysql.com Subject: How to control database size in MySQL Windows? I think the answer to this is "You can't". So I guess what I can do is run a query once every while and get the sizes of all the databases and if any exceeds a predetermined size, revoke insert and update privilages. What's is the SQL query like to get a database size and the SQL to get the names of all the databases? Salama -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
