Site performance, Server errors, outages and tunings - Printable Version +- Like Ra's Naughty Forum (https://www.likera.com/forum/mybb) +-- Forum: Technical section (https://www.likera.com/forum/mybb/Forum-Technical-section) +--- Forum: Site (https://www.likera.com/forum/mybb/Forum-Site) +--- Thread: Site performance, Server errors, outages and tunings (/Thread-Site-performance-Server-errors-outages-and-tunings) Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
RE: Site performance, Server errors, outages and tunings - Like Ra - 31 Dec 2012 If anybody experienced slowdowns this morning - they were caused by a monitoring script which went mad for some reason. Something like race conditions. This is the first time it happened in several years. Restarted. Look OK. Nice graph: RE: Site performance, Server errors, outages and tunings - Like Ra - 13 Jan 2013 Site rippers were at it again. Huge traffic, memory overflow, swapping, slow downs, etc. The average page access time became as twice as much. Actually longer for one-two page visitors. Had to block by IP again. Then decreased the amount of PHP processes by one. It helped. Yes, 1GB RAM is definitely not enough. Especially if fappers downloading all the gigabytes for days. RE: Site performance, Server errors, outages and tunings - Like Ra - 11 Apr 2013 Another upgrade!! See http://www.likera.com/blog/wp/archives/15031 !!! I'm still playing with various parameters, but this is the current changes: Simultaneous connections (Apache threads) - 105 (was 50) PHP5-FPM processes - 22 (was 17) Keep-alive TTL - 5sec (was 3) APC cache size - 128MB (was 64) Mod_pagespeed cache size - 160MB (was 90) New MySQL caches (no significant changes, e.g. query_cache_size from 36MB to 48) Does not look like tremendous changes, but one additional GB is gone 😁 Let's see how stable this environment will be. RE: Site performance, Server errors, outages and tunings - Like Ra - 12 Apr 2013 Strange, the network fell off this morning. Had to reboot the box. Pity, I lost the performance statistics for the last 12 hours. RE: Site performance, Server errors, outages and tunings - Like Ra - 15 Apr 2013 And it happened again. I did not have these problems before the migration. A trouble ticket logged. RE: Site performance, Server errors, outages and tunings - Like Ra - 15 Apr 2013 The guys responded very quickly and proposed to migrate to another server. What I did. Probably it was a known issue? The CPU is now different: Intel® Xeon® CPU E5-2630L 0 @ 2.00GHz 15MB cache Meanwhile I increased the APC cache to 164MB and reduced the amount of PHP servers to 20. Watching the performance. RE: Site performance, Server errors, outages and tunings - Like Ra - 16 Apr 2013 Next step will be MyISAM to InnoDB migration. Should be interesting to compare 😉 RE: Site performance, Server errors, outages and tunings - Like Ra - 19 Apr 2013 I migrated almost all tables to InnoDB except those with FULLTEXT index. MySQL 5.6 supports FULLTEXT index in InnoDB, but there is no supported version for Ubuntu yet. Only one WP (blog) plugin is currently incompatible - YARPP (related posts), and I'm not quite ready to disable it. MyBB (forum) is a more complex case, because searching depends on the full text index. Apparently for a full scale comparison I have to wait for MySQL 5.6 availability for Ubuntu, but I hope that even the first phase will bring some performance improvements. RE: Site performance, Server errors, outages and tunings - Like Ra - 21 Apr 2013 Ooops... The maximum memory a PHP process could you was set to 128MB, but APC cache to 164MB. Hence the "cache full" issues while there were lots of unused cache. Let's see if "matching the levels" helps. RE: Site performance, Server errors, outages and tunings - Like Ra - 22 Apr 2013 More fun. I removed the FULLTEXT index from the MyBB posts table (since the FULLTEXT search is buggy anyway) and converted it to InnoDB. But the same trick with the threads table did not work, so I had to revert to MyISAM. Removed some unused tables what reduced the database by ~20MB - the idea is to cache the entire database and all PHP files (via APC cache) into the memory. |