Thanks for the respond. Please take a look at the attachment to show you the 'overhead' that I have. This number is growing fast, I just optimize/repair 12 hours ago. In 2 days it should be about 200,000 Bytes and it stops the mysqld.
Number of users that are on at any given time is about 300 I have attached the screenshot of my tables including the sizes, rows, and overhead numbers.
For information, I am using Single Xeon 2.4Ghz with 1024MB (512MB x 2), SCSI DRIVE. OS Fedora Core 1, Apache 2.0, Php 4.2.2, mySQL 3.23.58
Here is my my.cnf config: [] [client] port = 3306 socket = /var/lib/mysql/mysql.sock
[mysqld] port = 3306 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.