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 - 10 Apr 2015 MySQL writes too much. I noticed that long tine ago, found some wrongly written plugins, but still MySQL writes way too much. One performance metric got on my nerves for years - high percentage of temporary tables created on disk. Increasing the buffer did not help, so I ignored this. However, 3 days ago I stumbled upon this issue again and decided to finally look into it. It turned out that tables with TEXT columns cannot be created in memory. All these three days I've been analysing table structures, calculating the longest entries, removing garbage, replacing text columns with varchar ones when possible and ... suddenly I noticed that almost no temporary tables are being created on disk anymore! And the CPU/memory load is dropped! I would call it a success 😉 I always knew that WordPress (and WP plugins) was not created with performance in mind, but how could I know that it would take me years and years of tweaking and performance tuning... And it's still very resource hungry. MyBB developers have done a better job. And I still have to rewrite the WordPress theme to conform the latest internal design ideas. RE: Site performance, Server errors, outages and tunings - Like Ra - 10 Apr 2015 Another interesting thing. The CPU load and network traffic dropped significantly 2 days ago when a huge computer botnet was discovered and stopped. RE: Site performance, Server errors, outages and tunings - Like Ra - 10 Apr 2015 Just to give you some real data. This is the blocked SPAM statistics (only blog and only Akismet, Stop Forum Spam software stopped in order of magnitude more SPAM attempts): A bit too much, I should say... RE: Site performance, Server errors, outages and tunings - Like Ra - 12 Apr 2015 Making forum backups and preparing for a big upgrade. In this case it's a long multistep procedure. Everything has to be reverted back (e.g. templates and styles), all plugins should be disabled, reuploaded and retested, all theme files should be rechecked and all changes should be redone. Yeah, I know... RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Apr 2015 As a preparation for the upgrade I have deactivated some not important plugins. RE: Site performance, Server errors, outages and tunings - Atsta - 14 Apr 2015 I like the new look RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Apr 2015 I'm not done yet 😉 It can be both good and bad 😁 But the basic functionality is there. RE: Site performance, Server errors, outages and tunings - madjack - 14 Apr 2015 Wahhhhhhh! It's all changed Going to take some getting used to, but seems to be ok so far. Have spotted the Icons/emoticons above this post are missing their 'images' MJ RE: Site performance, Server errors, outages and tunings - Like Ra - 15 Apr 2015 To be honest, I would leave the previous design, if I could. At least I'd like to change the colours. But the reason behind the upgrade is the internals, that are significantly different from the previous version. Also, no old plugins are supported and they are not reverse compatible. So I would have to upgrade sooner or later. It took me almost 8 month to take a deep breath and jump 😉 RE: Site performance, Server errors, outages and tunings - madjack - 15 Apr 2015 Judging by the 'Vertical spread eagle' posting I suspect that the 'view counter' isn't working 😋 MJ |