openoffice-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From janI <j...@apache.org>
Subject Re: Forums down (SQL error: Too many connections [1040])
Date Tue, 02 Apr 2013 07:22:34 GMT
HI.

I have now been on the forum vm, testing my new access.

While I was in there I made a couple of observations:

1) number of apache work thread > mysql max_connections, which is generally
a bad idea. The number of work tasks is higher than the actual load calls
for, so the work parameter should be adjusted.
2) mysql tables are not performing too well (indexes), it seems they were
last tuned ages ago. Some of the table could benefit from being converted
to innoDb.
3) memory/disk and other resources are fine and not a problem

4) due to the heavy php usage, the site would benefit from fast-cgi
(requires httpd upgrade)
5) It seems that a lot of identical pages are been requested, using
trafficserver would lower the mysql load a lot (on wiki2 the difference is
more or less double). This might also call for some more memory.

Some work for the new maintenance team.
rgds
jan I.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message