steve.mckeogh@googlemail.com wrote:
> Howdy,
>
> Not sure if this is possible, if not does anyone know how this could
> be done?
>
> I'm doing a site where users have several areas to create events,
> mail, forums etc etc, and I need to give them a limit of say, for
> example 100mb.
>
> Now I need to know how much data they have stored in the DB, so is it
> possible to do a select on all the users data in the DB (on a
> scheduled task every night for example) and see how much (in mb/bytes
> etc) this query pulls back?
>
> If not I suppose I could store all the data in a .txt and see the file
> size of that, but I'd prefer to do it in MySQL if poss?
>
> Anyway, anyone know if this can be done?
>
> btw, Im on MySQL 4+ and CFMX 7
>
> Thanks
>
> Steve M
>

does each user have a seperate schema and table or a tables? if so,

select data_length from information_schema.tables where table_name =
'userstable' and table_schema = 'usersschema';

http://www.xcdsql.org/Misc/MySQL_INF...ON_SCHEMA.html (w/clickable links to
MySQL docs - looks informative.

--
Michael Austin
Database Consultant
Domain Registration and Linux/Windows Web Hosting Reseller
http://www.spacelots.com