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 - 14 Nov 2020 Looks like something was wrong with the forum, thanks @Sierra13 From the logs: Code: 2020-11-14T19:33:16.774425Z 952540 [ERROR] [MY-013132] [Server] The table 'mybb_sessions' is full! How can it be full???? EDIT: Ooops: 100,580 MEMORY utf8mb4_unicode_ci 128.5 MiB RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 Someone from DE was/is ripping the site at the speed of 3 req/sec - not a load for the server at all, but I wonder why the session table was not being cleared - it was full with sessions from that IP address (blocked now). RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 Checked - it is being cleaned-up, but not at the speed of new requests. I wonder why new session is created for every new request. The table overflow can be prevented by changing the table type from memory to InnoDB at the cost of some speed and disk access, but I think that the logic is wrong somewhere. EDIT: no, it's not cleaned up... And I don't see a corresponding task. Mmmm.... Checking further .... RE: Site performance, Server errors, outages and tunings - Zooy - 14 Nov 2020 (14 Nov 2020, 21:05 )Like Ra Wrote: Checked - it is being cleaned-up, but not at the speed of new requests. I wonder why new session is created for every new request. The table overflow can be prevented by changing the table type from memory to InnoDB at the cost of some speed and disk access, but I think that the logic is wrong somewhere. It must have been a bit strange. I got an error message on my Mac laptop, but not on my iPads (I have a very old one and a newer one). This was rather consistent. Anyway: thanks for all the work you put in. RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 (14 Nov 2020, 21:05 )Like Ra Wrote: EDIT: no, it's not cleaned up... And I don't see a corresponding task. Mmmm.... Checking further ....Cleaned up now. I found this in dailycleanup.php: Code: // Clear out sessions older than 24h But the sessions in question were removed after ~1h. Magic... RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 (14 Nov 2020, 21:21 )Zooy Wrote: I got an error message on my Mac laptop, but not on my iPads (I have a very old one and a newer one).Possibly your iPad had a valid not-expired session. But new sessions (even anonymous) could not be established. And I was only away for ~5 hours ... 😁 RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 It began 09:39am (GMT) - I did not notice it either, because my session was still active. So, @Sierra13 - huge thanks again for letting me know by mail!!! (@ other guys - hint-hint ... ping me if you notice anything weird) RE: Site performance, Server errors, outages and tunings - Like Ra - 14 Nov 2020 (10 Nov 2020, 02:42 )Like Ra Wrote: Now webp is properly added - you can upload webp images and they will be properly thumbnailed. Unfortunately, animated WEBP images are not supported 😟 If you upload such file you will get a white page, you can go back and upload again, then you will get an error that the image is aeady uploaded, but there will no thumbnail. Not sure where the problem is - does PHP imagemagic library support animated WEBP? More work! 😁 RE: Test uploading images - madjack - 17 Nov 2020 (17 Nov 2020, 16:11 )Like Ra Wrote:(17 Nov 2020, 16:05 )madjack Wrote: testing animated webp uploadsHOW DID YOU DO THIS???? Err... I just posted it, like any normal .jpeg/gif file. 😁 (like many old-skool IT guys I simply keep trying the same thing until it works!!!!) It failed first time (no error, just a blank screen below the address bar), but think that was due to the second file I was trying to load at same time, which was one of those 'not really a .gif file' file types (that file type is very odd - I can't get any animation in my 'Photo' software, but can if opening in a browser) MJ RE: Test uploading images - Like Ra - 17 Nov 2020 (17 Nov 2020, 19:44 )madjack Wrote: It failed first time (no error, just a blank screen below the address bar),Yes, exactly what I meant! PHP is complaining about animated WEBP. Investigating... |