my.cnf and php.ini optimization

[ASTRAPI]

Hello

For a server:

# 2x Intel Xeon Quad 5405
# 8192 MB FB DDR2 RAM
# 500 GB 7.200 RPM

1.000 Mbit Unshared

Centos 64Bit

What settings i can use for my.cnf and php.ini?

my.cnf:




Thank you

[mysqld]

port            = 3306

socket          = /var/lib/mysql/mysql.sock

skip-locking

skip-innodb

skip-bdb

key_buffer = 10M

max_allowed_packet = 1M

table_cache = 1024

sort_buffer_size = 2M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

net_buffer_length = 2K

thread_stack = 64K

log-slow-queries       = /var/log/mysql/mysql-slow.log

server-id = 1

skip-networking


[mysqldump]

quick

max_allowed_packet = 1M


[mysql]

no-auto-rehash

safe-updates


[isamchk]

key_buffer = 10M

sort_buffer_size = 2M


[myisamchk]

key_buffer = 10M

sort_buffer_size = 2M

My php.ini settings:

max_execution_time = 30     ; Maximum execution time of each script, in seconds

max_input_time = 60	; Maximum amount of time each script may spend parsing request data

memory_limit = 32M      ; Maximum amount of memory a script may consume (32MB)



[mSQL]

; Allow or prevent persistent links.

msql.allow_persistent = On


; Maximum number of persistent links.  -1 means no limit.

msql.max_persistent = -1


; Maximum number of links (persistent+non persistent).  -1 means no limit.

msql.max_links = -1


[PostgresSQL]

; Allow or prevent persistent links.

pgsql.allow_persistent = On


; Detect broken persistent links always with pg_pconnect(). Need a little overhead.

pgsql.auto_reset_persistent = Off 


; Maximum number of persistent links.  -1 means no limit.

pgsql.max_persistent = -1


; Maximum number of links (persistent+non persistent).  -1 means no limit.

pgsql.max_links = -1


; Ignore PostgreSQL backends Notice message or not.

pgsql.ignore_notice = 0


; Log PostgreSQL backends Noitce message or not.

; Unless pgsql.ignore_notice=0, module cannot log notice message.

pgsql.log_notice = 0


[Sybase]

; Allow or prevent persistent links.

sybase.allow_persistent = On


; Maximum number of persistent links.  -1 means no limit.

sybase.max_persistent = -1


; Maximum number of links (persistent + non-persistent).  -1 means no limit.

sybase.max_links = -1


;sybase.interface_file = "/usr/sybase/interfaces"


; Minimum error severity to display.

sybase.min_error_severity = 10


; Minimum message severity to display.

sybase.min_message_severity = 10

[MindTooth]

Regarding MySQL, I can recommend MySQLTuner. With PHP, this is more a Apache mather, something I want to learn more about too.

Birger :)

[ASTRAPI]

I will use also the sqltuner but i want some recomendations about my.cnf and php.ini :)

[ASTRAPI]

any one ?

[rct2·com]

I recommend that you employ a professional to give you some advice. If you can afford to pay for that server on a monthly basis, you can afford to pay for a few hours for an expert to tune it.

php.ini is the least important factor in this. You should focus on my.cnf and httpd.conf. The best settings will depend on what the server is being used for, number of visitors concurrent, what they are doing when they visit, etc. You might also like to google for different recommended my.cnf settings based on typical server spaces and usage profiles.

[Sheffielder]

I too need a server tuning

does anyone know any recommended professionals ?

[Gary.]

Everything is looking fine but hense, You have 8GB and your allowing 32MB per script ? :whistle: I would up that to atleast 96MB and then let that monster processor do the work.

No matter what people post saying my.cnf, http,conf ect you can only configure it to the modules running and what apache, Mysql and enviroment you have / Host.

[*Salvo*]

Put on the forum's root the script below (from SMF), rename it for security proposal, and you'll have valid response and suggestions. Run it like: www.mysite.buh/forum/status.phpstatus.php