Hi
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
skip-locking
set-variable = max_connections=500
set-variable = myisam_sort_buffer_size=64M
#set-variable = key_buffer=16M
set-variable = key_buffer=64M
set-variable = join_buffer=4M
set-variable = record_buffer=4M
set-variable = sort_buffer=6M
#set-variable = read_buffer_size=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
[/]
My top produces
[]
10:42:46 up 7 days, 15:28, 2 users, load average: 14.33, 17.51, 16.14
191 processes: 179 sleeping, 12 running, 0 zombie, 0 stopped
CPU0 states: 93.3% user 6.2% system 0.0% nice 0.0% iowait 0.0% idle
CPU1 states: 93.3% user 6.2% system 0.0% nice 0.0% iowait 0.0% idle
Mem: 1030284k av, 978456k used, 51828k free, 0k shrd, 58532k buff
754756k actv, 64160k in_d, 37968k in_c
Swap: 1020116k av, 52048k used, 968068k free 463096k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
16502 mysql 15 0 63012 54M 1276 S 15.2 5.4 97:51 1 mysqld
28860 apache 16 0 8160 6608 3756 S 11.0 0.6 0:06 1 httpd
28899 apache 15 0 8008 6444 3736 S 7.3 0.6 0:01 0 httpd
...
[/]
Thank you for all the helps.
Best regards