Mimi Church wrote:
>
> I'm using mySQL on a hosting service, by attaching to a remote server. I
> would like to find out the size of my tables. While isamchk is on my local
> server, which is maintained by the same hosting service, I do not
> understand if it is possible to run this to find the file size on a remote
> server. Both local and remote are freeBSD and 3.22.19b-log
>
> Apologies if this is in the manual or list archives, but I have not been
> able to find it.
>
> Thanks,
> Mimi Church
Can you just telnet to the remote server and run du?
Alternatively, estimate how much space a row takes, then select count(*)
from the_table and times it the number of bytes per row.
--
Sasha Pachev
http://www.sashanet.com
