New Server - which configs?

[h4p3]

Hi,

i've got a new server, yeeeha :cool:

Specs:
Dual P3 1000
1 GB ECC RAM
2 LVD 18 GB HD IBM (Raid 1)
Tyan Thunder HEsl-T

Which configs should i use for php and mysql? Could anyone attach or post some configs?

Any help appreciated!

Regards,
h4p3

[eva2000]

nice server :)

how many vB's will be on it ?

average and max concurrent users ?

any other php/mysql scripts ?

[h4p3]

mhh,

only my vb (overclockers.at) ~ concurrent users, i think 200 for the future.

php scripts for my cms, that's it ;)

[h4p3]

c'mon eva, gimme some configs! :cool:

;)

[eva2000]

Originally posted by h4p3
c'mon eva, gimme some configs! :cool:

;) doh

okay try this on for size


[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=300
set-variable = key_buffer=16M
set-variable = join_buffer=5M
set-variable = record_buffer=5M
set-variable = sort_buffer=10M
set-variable = table_cache=1024
set-variable = thread_cache_size=256

[safe_mysqld]
open-files-limit=8192

[myisamchk]
set-variable = key_buffer=384M
set-variable = sort_buffer=384M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
restart mysql

[h4p3]

cool thx ;)

And any php.ini tips?

[eva2000]

Originally posted by h4p3
cool thx ;)

And any php.ini tips? yeah increase memory_limit from 8M to 16M

restart apache :)

[h4p3]

Okilidokili ;)

thx eva!

[eva2000]

Originally posted by h4p3
Okilidokili ;)

thx eva! no probs .. let us know how it goes in a few days or weeks :)