Hello. How to use PHP and Java tools to determine the physical size (on disk, in bytes or kilobytes, without a difference) the size of the database and the size of a single table? Interested in MySql for PHP and Microsoft SQL Server 2000 (and later versions) for Java .
PS:
Two questions concerning implementation in two different PLs.

    1 answer 1

    Mysql

     SELECT DATA_FREE FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = 'bd_name' AND TABLE_NAME = 'table_name'; //для всей базы SELECT SUM(DATA_FREE) FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA = 'bd_name'

    MS SQL in theory, but did not check

     DBCC UPDATEUSAGE (0); CREATE TABLE #t([имя таблицы] varchar(255), [строк] varchar(255), [зарезервировано] varchar(255), [всего данных] varchar(255), [размер индексов] varchar(255), [свободно] varchar(255)); INSERT INTO #t exec sp_msforeachtable N'exec sp_spaceused ''?'''; SELECT * FROM #t ORDER BY CONVERT(bigint, REPLACE([всего данных], ' KB', '')) DESC; DROP TABLE #t;