SEO

permalink · #1 (**permalink**) 02-28-2008, 09:10 AM

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

permalink · #2 (**permalink**) 02-28-2008, 09:11 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Getting filesize of users data in MySQL DB?