PDA

View Full Version : Server Optimization Request - Please...

WebmasterAJ
Wed 14th Jan '04, 2:20am
Hello,

Firs and foremost, thank you for taking your much valuable time to help me out and get my server situated. I'm really not having any problems as of yet, but I would like to work on this prior to a problem. Once again, thank you. Here is my information.

1. Dedicated
2. Server specs

cpu speed/type single or dual cpus): AMD AthlonXP 2500 1.83Ghz
how much memory installed: 1GIG DDR
hard drive type/configuration: 80GB IDE
linux distributor or windows version: redhat linux 9
apache/IIS version: apache 1.3.29
PHP version: php 4.3.3
MySQL version: mysql 4.0.15-standard


3. No

4. It was compiled by FastServers.net
5. your top stats: http://66.220.27.161/boardvb2/topstats.txt
6. your mysql configuration variables

[mysqld]
set-variable = max_connections=500
safe-show-database


7. your mysql extended-status output: http://66.220.27.161/boardvb2/mysqlinfo.php

8. There are other, smaller databases on the server

9. 100-200 average, 300-400 max

10. http://66.220.27.161/boardvb2/phpinfo.php

11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150

12. 2.2.8

Thank you once again, I look forward to hearing back.

Sincerley,
Andrew Tatum
eva2000
Wed 14th Jan '04, 3:42am
1. upgrade to vB 2.3.4
2. change my.cnf to below and restart mysql and see how that goes

[mysqld]
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
WebmasterAJ
Wed 14th Jan '04, 5:09pm
1. upgrade to vB 2.3.4
2. change my.cnf to below and restart mysql and see how that goes
Great, thank you very much for that change. The only reason why I haven't upgraded is because I want to wait for vB3 since the majority of hacks I have installed on the board come with vB3.

Thank you again!
RichM
Wed 14th Jan '04, 5:39pm
Well you may have problems if you upgrade from 2.2.8 to VB3 directly.
I am not 100% sure though.
RobAC
Wed 14th Jan '04, 6:15pm
Couple questions....can those settings be in a different file on the server? I can't locate a my.cnf file on my server.

Also, what is the best way to shut down and restart mysql on the server?
WebmasterAJ
Wed 14th Jan '04, 6:20pm
Well you may have problems if you upgrade from 2.2.8 to VB3 directly.
I am not 100% sure though.
When I want to upgrade to vb3, I'll first upgrade to the last vb2... if you know what I mean... :cool:
RichM
Wed 14th Jan '04, 7:58pm
Robac you can login to SSH and simply type:

service mysql stop
service mysql restart
service mysql start