MySQL database size

[DanS]

Is there any way of telling how large my MySQL database is from the mysql command line or CNC?  Also, CNC doesn't list disk space under the www root.  Does that mean it's free?

[DanS]

Also, does the MySQL server have pack_ism installed and how does that count toward my quota?  Almost all of my tables are read-only.

[Terra]

Also, CNC doesn't list disk space under the www root.  Does that mean it's free?

The next major revision of Disk_Space will in fact calculate the total xdom environment, *including* the MySQL database usage as well...

Also, there are system level programs, separate from the Disk_Space modules that keep tabs on the disk usage which will become the basis for the upcoming updates...

The pack_ism is only available with the full commercial version of MySQL, which we do not have right now...

Overall, Disk_Usage will be changing drastically soon...  We have seen domains with literally 1000's of tiny 4 or 5 byte control file sizes, yet on the disk they are consuming a full cluster/block of disk space...

The minimum calculation will be on block consumption, and not file size as that is the true storage space required...  This is an effort for people to start using more efficient storage methods like MySQL or DBM hashes, instead of thousands of small control files...

Doing the math:
:perception:
1000 files x 5 bytes = 5000 bytes
:reality: (based that 1 block = 1024 bytes)
1000 files x 1024 bytes = 1,024,000 bytes (actually consumed)

The above changes will fall right in line as I start to place system level enforced quotas on each domain...  The Linux 2.2.x kernel is ready to roll this out full force, as it still has a few kinks with quotas that must be fixed first...

--
Terra
--perception and reality don't always blend well--
FutureQuest

[DanS]

Thanks Terra.  So currently there's no way for me to tell how large and bloated my MySQL database is?

[DanS]

Ah, indeed.  I have been busy.  But once I start learning PHP, look out!

The number you gave me is heartening.  The flattext size was 27,145,140 and the indexed (1/table) database size is 29,300,402.  4 tables.  Not bad.  Much better than I expected.

[Terra]

Not that I know of, unless you have access to the MySQL data storage area (off limits)...

2 ways I know of off hand)
1) simple: ls -l or du -k and gleam the file sizes
2) isamchk and snag the data set size...

I will be basing the database size from #1 above, which takes into account the form/data/index size...

If I have some free time in the next 2 weeks, I may cook something up that can calc database sizes and tie it into the Disk_Space module...

I just checked your DB's: 29,300,402 (you've been busy)

--
Terra
--I would borrow time, if the payback interest wasn't so friggin high--
FutureQuest
[This message has been edited by ccTech (edited 05-16-99)]