Hi! I want to get amount of disk space used by certain rows on disk, not a whole table, but only some rows. Is this possible?
For example I got a table like: CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `parent_category_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `name_parent` (`name`,`parent_category_id`) ) TYPE=MyISAM; and I want to know the amount of disk space that is used by the rows returned by certain query like: SELECT * FROM categories WHERE name LIKE 'a%'; I know I can get the size from a whole table with "SHOW TABLE STATUS", and I could create a HEAP table base on the query, and get it's size, but that probably wouldn't be very wise, since large results would consume the whole memory, and I got tables with files stored in BLOBs... So, is there any other way of getting this sizes?? I've Googled and found about getting table sizes with "SHOW TABLE STATUS", but nothing on what I want... Thanks in advance, Juan -- Open WebMail Project (http://openwebmail.org) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
