Page created in ....

[master2oo8]

Hi,

i have my own dedicated server, the forum (SMF 1.1.5) runs without problems but i have a question.

here in simplemachines.org the forum needs to create the site about 0.03 seconds, but at me stands always:
Page created in 0.102 seconds with 13 queries.

We have about 5000 members, 15.000 topics and 160.000 posts.

Processor: AMD Athlon(tm) 64 X2 Dual Core Processor 5000+
RAM: 2GB
OS: FreeBSD

SSH, top:

Code Select Expand

last pid:   129;  load averages:  0.32,  0.29,  0.21    up 8+11:11:54  23:54:39
3 processes:   1 running, 2 sleeping
CPU states:  8.3% user,  0.0% nice,  1.7% system,  0.0% interrupt, 90.0% idle
Mem: 97M Active, 1064M Inact, 216M Wired, 60K Cache, 112M Buf, 593M Free
Swap: 2048M Total, 2048M Free

  PID USERNAME       THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
99956 xxx             1  96    0  2148K  1412K CPU0   0   0:00  0.00% top
99878 xxx             1  96    0  6056K  3148K select 0   0:00  0.00% sshd
99883 xxx             1   8    0  1648K  1336K wait   0   0:00  0.00% sh



status.php

Code Select Expand


Connections per second:  0.9446
Kilobytes received per second: 4.525
Kilobytes sent per second: 1.0829
Queries per second: 17.5666
Percentage of slow queries: 0
Opened vs. Open tables:
(table_cache) 232.3125 (should be <= 80)
Table cache usage:
(table_cache) 1 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size) 0.001 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size) 0.2086 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 1 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size) 0.3399 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer) 0 (should be <= 0.001)
Query cache enabled:
(query_cache_type) 1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit) 0.5394 (should be <= 0.5)
Query cache prune rate:
(query_cache_size) 0.0143 (should be <= 0.05)


This things arent at the optimum range:

Code Select Expand



Query cache miss rate:
(query_cache_limit) 0.5394 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size) 1 (should be >= 30 )
Thread cache usage:
(thread_cache_size) 0 (should be >= 0.7 and <= 0.9)
Opened vs. Open tables:
(table_cache) 232.3125 (should be <= 80)
Table cache usage:
(table_cache) 1 (should be >= 0.5 and <= 0.9)

I use MySQL, Type: MyISAM, Kollation: utf8_general_ci
I heard that i can convert the tables, but i am scared that the special letter (sorry, i dont know a other word for it, i mean ä,ü,ö) looks after convert like "?", you know what i mean...?

how can i fix it and speed up the forum?

thanks for ur help

[rsw686]

I installed APC on my dedicated box and cut my page creation times in half. APC caches the op-code to save execution time.

You could also optimize mysql. See

http://www.interworx.com/forums/showthread.php?p=2346

[rsw686]

Oh I forgot to ask. Are you running php as a module, with cgi, or fast-chi. Running php with cgi will drastically increase your page creation times as it has to start up php each time. Fast-cgi is the way to go if you want the site running under suexec privs. Otherwise the best performance comes from using php as a module. Although all PHP files are executed under the apache user. Since this is a dedicated box this isn't a big deal.

[master2oo8]

thanks for your help!

And this is not a security risk or something?
i will test it tomorrow

php runs as a module.

[rsw686]

APC is not a security risk. Instead of reading files from the disk each time, it caches the code in memory.

[Rumbaar]

Also I wouldn't use the creation times for SMF as any comparison to your single server forum.  'We' here use a cluster of web servers to handle the load.