No Of Bytes consumed of the resultants rows from a query
Posted: Mon Jan 31, 2005 9:53 am
Is there anyway to find the space usage (in bytes or whatever) for a query say :
SELECT * FROM `Private_Messages` WHERE UserID='10'
I would like to show the user how much disk space he has used up. But this won't be possible using file methods since I dont have access to MySQL files and moreover there are many rows in one table where all the msgs are stored and I need to get only the ones of a particular user.
Its there in phpMyAdmin, but I couldnt trace out the function/query to get this result.
Thanks
SELECT * FROM `Private_Messages` WHERE UserID='10'
I would like to show the user how much disk space he has used up. But this won't be possible using file methods since I dont have access to MySQL files and moreover there are many rows in one table where all the msgs are stored and I need to get only the ones of a particular user.
Its there in phpMyAdmin, but I couldnt trace out the function/query to get this result.
Code: Select all
// In the main frame, at startup...
$cfgї'ShowStats'] = TRUE; // allow to display statistics and space usage in
// the pages about database details and table
// properties