optimizing my.cnf

[Joe Gronlund]

can someone help my optimize my MySQL my.cnf file??

http://www.asendtechnologies.com/vb/admin/mysqlinfo.php

Server Specs
1 Ghz Intel Pentium III
40 GB- SCSI
1 GB - RAM
Redhat Linux 7.3
PHP 4.2.3

[eva2000]

Originally posted by Asendin
can someone help my optimize my MySQL my.cnf file??

http://www.asendtechnologies.com/vb/admin/mysqlinfo.php

Server Specs
1 Ghz Intel Pentium III
40 GB- SCSI
1 GB - RAM
Redhat Linux 7.3
PHP 4.2.3 what's in your current my.cnf ?

average and max concurrent users?

[Joe Gronlund]

all thats in my my.cnf file right now is.

[mysqld]
set-variable = max_connections=500


thanks for your help :)

[eva2000]

Originally posted by Asendin
all thats in my my.cnf file right now is.

[mysqld]
set-variable = max_connections=500


thanks for your help :) average and max concurrent users? ;)

[Joe Gronlund]

Originally posted by eva2000
average and max concurrent users? ;)

im not sure what you mean,

thats the contents of my entire my.cnf

http://www.asendtechnologies.com/misc/mycnf.jpg

[eva2000]

Originally posted by Asendin
im not sure what you mean,

thats the contents of my entire my.cnf

http://www.asendtechnologies.com/misc/mycnf.jpg i mean how many vB users online per day do you get :)

[Joe Gronlund]

Originally posted by eva2000
i mean how many vB users online per day do you get :)

oh sorry, about 500-1000, max users at one time is around 130.


thanks

[Joe Gronlund]

still there george? :)

is this ok?


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=650
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[eva2000]

Originally posted by Asendin
still there george? :)

is this ok?


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=650
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=256
set-variable = wait_timeout=9600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
[safe_mysqld]
open_files_limit=8192
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[myisamchk]
set-variable = key_buffer=64M
set-variable = sort_buffer=64M
set-variable = read_buffer=16M
set-variable = write_buffer=16M yup that should work ... :)

[Joe Gronlund]

great thanks :cool: