Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: How to evaluate server speed?


_ck_
Participant

@_ck_

I should point out that even your static.html serves up fairly slowly, though a little faster than the dynamic pages. Getting mysql caching may not be as big a boost as it hopefully should be. I can’t even see what your guaranteed VPS ram is.

If you are on a VPS there is usually a seperate VPS control panel that will also let you restart services, including mysql.

my setup lets me do a “service mysql restart” but that’s probably not universal. This is what I have in my.cnf

[mysqld]

# myisam-recover = BACKUP
# delay-key-write = ALL

max_connections = 400
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
skip-innodb
old-passwords = 1
basedir = /var/lib/mysql
datadir = /var/lib/mysql
long_query_time = 1
log-slow-queries = /var/log/mysql/mysql-slow.log
log-error = /var/log/mysql/mysqld.err

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M

Skip to toolbar