[TYPO3] Stability & performance problem
Piotr Burda
pburda at narty.pl
Mon Feb 20 15:59:50 CET 2006
Hi
We are running www.narty.pl site on typo3 3.8.1, we have from 12 000 to
20 000 UV per day.
Our hadware is HP DL - 380 dedicated only for this site.
On this machine we are running typo and mysql server only for typo.
We are using: tt_news, tt_products, chc_forum, and some other minor
extensions.
We have very strange performance problems, the server is wery often
overload (20 to 30 times per day.
What should we do to stabilize server work?
Here are some of statistics : (restart was forced by server unstability)
1. 6 seconds after server restart
Apache Server Status for narciarz.narty.pl
Server Version: Apache/2.0.54 (Fedora)
Server Built: Jan 17 2006 06:36:08
--------------------------------------------------------------------------------
Current Time: Monday, 20-Feb-2006 15:42:01 CET
Restart Time: Monday, 20-Feb-2006 15:41:55 CET
Parent Server Generation: 333
Server uptime: 6 seconds
Total accesses: 23 - Total Traffic: 439 kB
CPU Usage: u12.25 s.58 cu0 cs0 - 214% CPU load
3.83 requests/sec - 73.2 kB/second - 19.1 kB/request
23 requests currently being processed, 0 idle workers
WCWWWWWWWWWCWWWWWCWWWWW.........................................
................................................................
Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
0-333 6770 0/3/3 W 1.65 0 0 0.0 0.08 0.08 195.205.244.61
narciarz.narty.pl GET /server-status HTTP/1.1
1-333 6771 1/1/1 C 1.76 1 4440 27.4 0.03 0.03 194.187.181.10
www.narty.pl GET /index.php?id=788&tx_pbnartymodelenart_pi1[showUid]=303&cHa
2-333 6772 0/2/2 W 2.72 0 0 0.0 0.10 0.10 213.180.128.151 www.narty.pl
GET /gallery2/main.php?g2_view=core.ShowItem&g2_itemId=5605&g2_
3-333 6773 0/3/3 W 0.88 1 0 0.0 0.03 0.03 83.11.167.253 www.narty.pl
GET /index.php?id=987 HTTP/1.1
4-333 6774 0/3/3 W 2.89 0 0 0.0 0.07 0.07 212.160.172.70 www.narty.pl
GET / HTTP/1.0
5-333 6775 0/1/1 W 1.85 2 0 0.0 0.03 0.03 145.237.253.14 www.narty.pl
GET /index.php?id=301&tx_ttnews[pointer]=1&tx_ttnews[tt_news]=1
6-333 6776 0/0/0 W 0.00 5 0 0.0 0.00 0.00 83.27.177.207 www.narty.pl
GET /index.php?id=763&tx_pbnartymodelenart_pi1[showUid]=160&cHa
7-333 6777 0/2/2 W 0.87 2 0 0.0 0.03 0.03 84.40.224.44 www.narty.pl
GET /index.php?id=750 HTTP/1.1
8-333 6778 0/0/0 W 0.00 4 0 0.0 0.00 0.00 145.237.253.14 www.narty.pl
GET /index.php?id=301&tx_ttnews[pointer]=1&tx_ttnews[tt_news]=1
9-333 6779 0/2/2 W 0.02 2 0 0.0 0.01 0.01 83.28.18.237 www.narty.pl
GET / HTTP/1.1
10-333 6780 0/0/0 W 0.00 3 0 0.0 0.00 0.00 218.75.98.66 www.narty.pl
GET /index.php?id=543 HTTP/1.0
11-333 6783 1/2/2 C 0.03 0 1607 14.9 0.02 0.02 212.2.99.218
www.narty.pl GET /stozek_cam/stozek.jpg HTTP/1.1
12-333 6784 0/1/1 W 0.13 1 0 0.0 0.00 0.00 83.27.117.209 www.narty.pl
GET /index.php?id=301&tx_ttnews[tt_news]=85&tx_ttnews[backPid]=
13-333 6785 0/1/1 W 0.00 2 0 0.0 0.03 0.03 62.233.170.111 www.narty.pl
GET / HTTP/1.1
14-333 6787 0/0/0 W 0.00 2 0 0.0 0.00 0.00 83.27.117.209 www.narty.pl
GET /index.php?id=301&tx_ttnews[tt_news]=85&tx_ttnews[backPid]=
15-333 6791 0/0/0 W 0.00 1 0 0.0 0.00 0.00 83.16.212.142 www.narty.pl
GET / HTTP/1.1
16-333 6792 0/0/0 W 0.00 1 0 0.0 0.00 0.00 83.22.108.76 www.narty.pl
GET /gallery2/main.php?g2_view=slideshow.Slideshow&g2_itemId=47
17-333 6793 1/1/1 C 0.03 0 1273 1.0 0.00 0.00 62.87.219.183
www.narty.pl GET /baner_management/adjs.php?n=195623482&what=zone:3&target=_
18-333 6794 0/0/0 W 0.00 1 0 0.0 0.00 0.00 83.22.108.76 www.narty.pl
GET / HTTP/1.1
19-333 6796 0/0/0 W 0.00 1 0 0.0 0.00 0.00 83.30.104.143 www.narty.pl
GET /index.php?id=995 HTTP/1.1
20-333 6797 0/0/0 W 0.00 1 0 0.0 0.00 0.00 83.22.108.76 www.narty.pl
GET / HTTP/1.1
21-333 6798 0/0/0 W 0.00 0 0 0.0 0.00 0.00 145.237.253.14 www.narty.pl
GET /index.php?id=301&tx_ttnews[pointer]=1&tx_ttnews[tt_news]=1
22-333 6799 0/1/1 W 0.00 0 0 0.0 0.01 0.01 218.75.98.66 www.narty.pl
GET /index.php?id=301&tx_ttnews[tt_news]=61&tx_ttnews[backPid]=
--------------------------------------------------------------------------------
Srv Child Server number - generation
PID OS process ID
Acc Number of accesses this connection / this child / this slot
M Mode of operation
CPU CPU usage, number of seconds
SS Seconds since beginning of most recent request
Req Milliseconds required to process most recent request
Conn Kilobytes transferred this connection
Child Megabytes transferred this child
Slot Total megabytes transferred this slot
--------------------------------------------------------------------------------
SSL/TLS Session Cache Status:
cache type: SHMCB, shared memory: 512000 bytes, current sessions: 0
sub-caches: 32, indexes per sub-cache: 133
index usage: 0%, cache usage: 0%
total sessions stored since starting: 0
total sessions expired since starting: 0
total (pre-expiry) sessions scrolled out of the cache: 0
total retrieves since starting: 0 hit, 0 miss
total removes since starting: 0 hit, 0 miss
2. 8 minutes after restart
Apache Server Status for narciarz.narty.pl
Server Version: Apache/2.0.54 (Fedora)
Server Built: Jan 17 2006 06:36:08
--------------------------------------------------------------------------------
Current Time: Monday, 20-Feb-2006 15:50:49 CET
Restart Time: Monday, 20-Feb-2006 15:41:55 CET
Parent Server Generation: 333
Server uptime: 8 minutes 53 seconds
Total accesses: 5112 - Total Traffic: 37.9 MB
CPU Usage: u338.43 s34.34 cu.14 cs0 - 70% CPU load
9.59 requests/sec - 72.7 kB/second - 7.6 kB/request
9 requests currently being processed, 55 idle workers
_C_W__________._____R___._____C_____W_____._.______C_W___.W___C_
.___.__.........................................................
Scoreboard Key:
"_" Waiting for Connection, "S" Starting up, "R" Reading Request,
"W" Sending Reply, "K" Keepalive (read), "D" DNS Lookup,
"C" Closing connection, "L" Logging, "G" Gracefully finishing,
"I" Idle cleanup of worker, "." Open slot with no current process
Srv PID Acc M CPU SS Req Conn Child Slot Client VHost Request
0-333 6770 0/89/89 _ 6.01 3 0 0.0 0.61 0.61 218.75.98.66 www.narty.pl
GET /typo3temp/javascript_579886c833.js HTTP/1.0
1-333 6771 1/79/79 C 12.39 0 0 0.0 0.69 0.69 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
2-333 6772 0/77/77 _ 7.36 1 0 0.0 0.75 0.75 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
3-333 6773 0/78/78 W 11.28 0 0 0.0 0.75 0.75 195.205.244.61
narciarz.narty.pl GET /server-status HTTP/1.1
4-333 6774 0/84/84 _ 8.15 2 22 0.0 0.79 0.79 195.205.244.61
narciarz.narty.pl GET /server-status HTTP/1.1
5-333 6775 0/69/69 _ 11.25 1 0 0.0 0.53 0.53 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
6-333 6776 0/80/80 _ 10.94 1 369 0.0 0.61 0.61 83.5.253.207
www.narty.pl GET /typo3temp/pics/0647cc13db.jpg HTTP/1.1
7-333 6777 0/82/82 _ 6.17 1 0 0.0 0.53 0.53 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
8-333 6778 0/79/79 _ 4.08 0 0 0.0 0.41 0.41 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
9-333 6779 0/76/76 _ 6.45 0 0 0.0 1.03 1.03 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
10-333 6780 0/84/84 _ 5.24 0 0 0.0 0.50 0.50 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/r.gif HTTP/1.0
11-333 6783 0/86/86 _ 2.42 0 0 0.0 0.42 0.42 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
12-333 6784 0/78/78 _ 6.23 2 0 0.0 0.64 0.64 83.238.240.3 www.narty.pl
GET /typo3conf/ext/ltg_rating//img/s100.gif HTTP/1.0
13-333 6785 0/77/77 _ 9.70 2 0 0.0 0.80 0.80 83.238.240.3 www.narty.pl
GET /typo3conf/ext/ltg_rating/img/s075.gif HTTP/1.0
14-333 - 0/0/6 . 1.51 492 0 0.0 0.00 0.05 62.179.64.252 www.narty.pl
GET /typo3temp/pics/0443afb674.jpg HTTP/1.1
15-333 6791 0/79/79 _ 7.62 2 0 0.0 0.81 0.81 83.5.253.207 www.narty.pl
GET /typo3temp/pics/4e108c3840.jpg HTTP/1.1
16-333 6792 0/76/76 _ 6.67 3 358 0.0 0.47 0.47 83.5.253.207
www.narty.pl GET /uploads/pics/otium.gif HTTP/1.1
17-333 6793 0/82/82 _ 2.94 0 0 0.0 0.48 0.48 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
18-333 6794 0/77/77 _ 5.01 1 0 0.0 0.53 0.53 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
19-333 6796 0/77/77 _ 6.04 1 0 0.0 0.58 0.58 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
20-333 6797 0/68/68 R 6.02 0 8 0.0 0.47 0.47 ? ? ..reading..
21-333 6798 0/80/80 _ 4.32 1 0 0.0 0.54 0.54 83.10.237.123
www.narty.pl GET /fileadmin/templates/narty/js/zakladki.js HTTP/1.1
22-333 6799 0/77/77 _ 6.68 0 2780 0.0 0.69 0.69 80.55.147.6
www.narty.pl GET / HTTP/1.1
23-333 6803 0/75/75 _ 6.85 0 0 0.0 0.57 0.57 149.156.124.17
www.narty.pl GET /typo3temp/stylesheet_99d1efed74.css HTTP/1.1
24-333 - 0/0/16 . 0.05 449 9 0.0 0.00 0.04 83.28.18.237 www.narty.pl
GET /gallery2/modules/imageframe/frames/polaroids/TR.gif HTTP/1
25-333 6807 0/76/76 _ 3.19 1 0 0.0 0.76 0.76 83.10.237.123
www.narty.pl GET /fileadmin/templates/narty/js/Alladyn.js HTTP/1.1
26-333 6808 0/76/76 _ 8.19 2 0 0.0 0.71 0.71 83.238.240.3 www.narty.pl
GET /typo3temp/pics/da56b98aab.jpg HTTP/1.0
27-333 6809 0/70/70 _ 1.80 0 0 0.0 0.84 0.84 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
28-333 6810 0/79/79 _ 4.39 2 0 0.0 0.47 0.47 83.5.253.207 www.narty.pl
GET /typo3temp/pics/1ad2812cb8.jpg HTTP/1.1
29-333 6811 0/80/80 _ 4.53 0 13 0.0 0.49 0.49 218.75.98.66
www.narty.pl GET /baner_management/adlog.php?bannerid=24&clientid=2&zoneid=3
30-333 6812 1/81/81 C 4.60 0 0 0.0 0.47 0.47 149.156.124.17
www.narty.pl GET /fileadmin/templates/narty/css/main_page2.css HTTP/1.1
31-333 6813 0/80/80 _ 4.39 2 162 0.0 0.49 0.49 83.238.240.3
www.narty.pl GET /baner_management/adimage.php?filename=przecena_19_100.swf&
32-333 6814 0/78/78 _ 7.46 2 1025 0.0 0.62 0.62 83.10.237.123
www.narty.pl GET /fileadmin/templates/narty/css/main_page2.css HTTP/1.1
33-333 6815 0/80/80 _ 9.53 0 0 0.0 0.71 0.71 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
34-333 6816 0/82/82 _ 7.00 0 4299 0.0 0.48 0.48 80.53.102.198
www.narty.pl GET /index.php?id=301&cHash=efe2da1c4b&tx_ttnews[tt_news]=136&t
35-333 6817 0/79/79 _ 6.88 1 13 0.0 0.64 0.64 218.75.98.66
www.narty.pl GET /baner_management/adjs.php?n=706643110&what=zone:3&target=_
36-333 6819 0/80/80 W 7.52 0 0 0.0 0.62 0.62 83.8.121.189 www.narty.pl
GET /gallery2/main.php?g2_view=core.ShowItem&g2_itemId=7&g2_pag
37-333 6820 0/81/81 _ 4.75 0 0 0.0 0.41 0.41 83.10.237.123
www.narty.pl GET /typo3temp/javascript_579886c833.js HTTP/1.1
38-333 6821 0/76/76 _ 6.54 0 0 0.0 0.60 0.60 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/b.gif HTTP/1.0
39-333 6832 0/75/75 _ 9.89 1 0 0.0 0.68 0.68 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/wagonik.gif HTTP/1.0
40-333 6833 0/83/83 _ 4.18 1 22 0.0 0.48 0.48 195.205.244.61
narciarz.narty.pl GET /server-status HTTP/1.1
41-333 6835 0/82/82 _ 3.81 3 328 0.0 0.46 0.46 83.5.253.207
www.narty.pl GET /uploads/pics/turyn_370_115_01.jpg HTTP/1.1
42-333 - 0/0/14 . 1.75 454 0 0.0 0.00 0.08 149.156.124.1 www.narty.pl
GET /favicon.ico HTTP/1.1
43-333 6839 0/76/76 _ 10.58 1 0 0.0 0.60 0.60 195.39.81.74
www.narty.pl GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
44-333 - 0/0/4 . 0.00 509 0 0.0 0.00 0.01 149.156.124.1 www.narty.pl
GET /fileadmin/templates/narty/images/snieg.jpg HTTP/1.1
45-333 6841 0/80/80 _ 2.45 0 0 0.0 0.39 0.39 83.10.237.123
www.narty.pl GET /fileadmin/templates/narty/images/shadow_right.jpg HTTP/1.1
46-333 6842 0/78/78 _ 3.53 1 0 0.0 0.47 0.47 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
47-333 6843 0/78/78 _ 3.68 1 0 0.0 0.77 0.77 83.5.253.207 www.narty.pl
GET /fileadmin/templates/narty/images/head_410.gif HTTP/1.1
48-333 6844 0/82/82 _ 4.37 1 0 0.0 0.57 0.57 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/orczyk.gif HTTP/1.0
49-333 6845 0/77/77 _ 4.68 2 0 0.0 0.37 0.37 83.10.237.123
www.narty.pl GET /fileadmin/templates/narty/css/contentwrapper.css HTTP/1.1
50-333 6846 0/77/77 _ 5.88 0 0 0.0 0.60 0.60 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/wagony.gif HTTP/1.0
51-333 6847 1/80/80 C 6.38 0 0 4.6 0.52 0.52 83.10.237.123
www.narty.pl GET /uploads/pics/gora_135_63_main.gif HTTP/1.1
52-333 6848 0/72/72 _ 5.50 4 0 0.0 1.00 1.00 195.39.81.74 www.narty.pl
GET /typo3temp/pics/cabf392a90.gif HTTP/1.1
53-333 6849 0/80/80 W 4.88 1 0 0.0 0.44 0.44 149.156.124.17
www.narty.pl GET / HTTP/1.1
54-333 6850 0/83/83 _ 5.42 3 19 0.0 0.40 0.40 83.238.240.3
www.narty.pl GET /baner_management/adjs.php?n=394959322&what=zone:1&target=_
55-333 6851 0/81/81 _ 2.74 2 10 0.0 0.78 0.78 83.238.240.3
www.narty.pl GET /baner_management/adlog.php?bannerid=27&clientid=2&zoneid=1
56-333 6852 0/84/84 _ 1.51 0 0 0.0 0.40 0.40 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
57-333 - 0/0/14 . 0.44 459 0 0.0 0.00 0.08 83.22.108.76 www.narty.pl
GET /fileadmin/templates/narty/images/narty_dol.jpg HTTP/1.1
58-333 6854 0/81/81 W 5.94 1 0 0.0 0.41 0.41 83.28.250.12 www.narty.pl
GET /index.php?id=967&no_cache=1&view=single_conf&cat_uid=11&co
59-333 6855 0/76/76 _ 7.67 2 693 0.0 0.70 0.70 83.10.237.123
www.narty.pl GET /typo3temp/stylesheet_99d1efed74.css HTTP/1.1
60-333 6856 0/80/80 _ 5.78 2 0 0.0 0.65 0.65 218.75.98.66 www.narty.pl
GET /baner_management/adx.js HTTP/1.0
61-333 6857 0/82/82 _ 1.67 3 46 0.0 0.34 0.34 195.205.244.61
narciarz.narty.pl GET /server-status HTTP/1.1
62-333 6858 1/82/82 C 2.92 0 0 0.0 0.41 0.41 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
63-333 6859 0/70/70 _ 7.41 1 0 0.0 0.85 0.85 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/krzeselka.gif HTTP/1.0
64-333 - 0/0/10 . 0.03 482 12 0.0 0.00 0.06 62.87.219.183 www.narty.pl
GET /baner_management/adjs.php?n=771812306&what=zone:1&target=_
65-333 6861 0/81/81 _ 3.00 0 0 0.0 0.46 0.46 83.238.240.3 www.narty.pl
GET /fileadmin/templates/narty/ikony/c.gif HTTP/1.0
66-333 6862 0/81/81 _ 5.03 1 0 0.0 0.56 0.56 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
67-333 6863 0/74/74 _ 2.73 3 0 0.0 0.84 0.84 218.75.98.66 www.narty.pl
GET /fileadmin/templates/narty/images/shadow_right.jpg HTTP/1.0
68-333 - 0/0/15 . 0.04 450 6 0.0 0.00 0.02 83.28.18.237 www.narty.pl
GET /gallery2/modules/imageframe/frames/polaroids/TL.gif HTTP/1
69-333 6865 0/69/69 _ 5.76 0 0 0.0 0.48 0.48 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
70-333 6866 0/82/82 _ 2.67 1 0 0.0 0.37 0.37 195.39.81.74 www.narty.pl
GET /typo3conf/ext/dropdown_sitemap/pi1/minus1.gif HTTP/1.1
--------------------------------------------------------------------------------
Srv Child Server number - generation
PID OS process ID
Acc Number of accesses this connection / this child / this slot
M Mode of operation
CPU CPU usage, number of seconds
SS Seconds since beginning of most recent request
Req Milliseconds required to process most recent request
Conn Kilobytes transferred this connection
Child Megabytes transferred this child
Slot Total megabytes transferred this slot
--------------------------------------------------------------------------------
SSL/TLS Session Cache Status:
cache type: SHMCB, shared memory: 512000 bytes, current sessions: 0
sub-caches: 32, indexes per sub-cache: 133
index usage: 0%, cache usage: 0%
total sessions stored since starting: 0
total sessions expired since starting: 0
total (pre-expiry) sessions scrolled out of the cache: 0
total retrieves since starting: 0 hit, 0 miss
total removes since starting: 0 hit, 0 miss
More information about the TYPO3-english
mailing list