7 messages in com.mysql.lists.mysqlRe: Figuring out the space.
FromSent OnAttachments
Ariel Manzur10 Aug 2000 23:00 
Ariel Manzur11 Aug 2000 04:46 
Ariel Manzur11 Aug 2000 06:48 
Dana Powers11 Aug 2000 10:26 
Robert Goff11 Aug 2000 11:19 
Dana Powers11 Aug 2000 14:11 
Dana Powers11 Aug 2000 15:17 
Subject:Re: Figuring out the space.
From:Ariel Manzur (pun@anime.com.ar)
Date:08/11/2000 04:46:48 AM
List:com.mysql.lists.mysql

Hi.. thanks.. thats really useful.. I have some questions:

Does it only work with text files? I have some varchar fields too.. and, can I put more than 1 field name into SUM() or LENGTH()?

I can't find a description of those functions on the mysql manual on mysql.com..

Thanks!

Ariel.

At 10:26 11/08/2000 -0700, Dana Powers wrote:

If they are text fields, you might try SELECT SUM(LENGTH(email_text)) FROM email_table WHERE user_id=?;

This wont be totally exact, but it should be pretty close.

Dana Powers

On Thu, 10 Aug 2000, Ariel Manzur wrote:

Hi.. I wrote this "free webmail" system in perl, using Mysql, I have all e-mails stored on a table ("emails"), each e-mail with the ID of the owner of the e-mail.

Is there any way to get how much space is a user using on the table? (without having to take all the data out and count each byte.. :)

Thanks.. bye.

Ariel.