You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by janI <ja...@apache.org> on 2013/04/02 09:22:34 UTC
Re: Forums down (SQL error: Too many connections [1040])
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.
Re: Forums down (SQL error: Too many connections [1040])
Posted by janI <ja...@apache.org>.
On 8 August 2013 17:13, FR web forum <oo...@free.fr> wrote:
> >We already have a admin, and I hope that the admin soon will be active.
>
> >I have access to the server and have offered to help the admin, but got no
> >response. I know the general setup (mysql, httpd and ubuntu) quite well,
>
> From beginning, I asked to check the MySQL max_connections parameter.
> Increase this value can fix the error
>
It will help quite a lot (and I did and agreed with you in the beginning),
but not totally solve the problem. We also need to control the number of
httpd workers. If these changes are not done carefully we get swap/virtual
mem problems instead. The goal is (as with any server) to strike a balance
not overheating any of the available resources.
rgds
jan I.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by FR web forum <oo...@free.fr>.
>We already have a admin, and I hope that the admin soon will be active.
>I have access to the server and have offered to help the admin, but got no
>response. I know the general setup (mysql, httpd and ubuntu) quite well,
>From beginning, I asked to check the MySQL max_connections parameter.
Increase this value can fix the error
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by Rory O'Farrell <of...@iol.ie>.
On Thu, 8 Aug 2013 16:39:04 +0200
janI <ja...@apache.org> wrote:
> On 8 August 2013 16:25, Rory O'Farrell <of...@iol.ie> wrote:
>
> > On Thu, 8 Aug 2013 15:59:36 +0200 (CEST)
> > FR web forum <oo...@free.fr> wrote:
> >
> > > >Seems fixed but very slow response.
> > > No, error still occurs this afternoon.
> > > Very annoying for end-users.
> > > And we are on august (low traffic with vacations).
> > > I'm afraid about september, forums will be completly unavailable.
> > >
> > I have asked on the en-Forum if there might be someone with phpBB/SQL
> > admin experience who would like to give a hand, but no responses.
> >
>
> We already have a admin, and I hope that the admin soon will be active.
>
> I have access to the server and have offered to help the admin, but got no
> response. I know the general setup (mysql, httpd and ubuntu) quite well,
> since I maintain a couple of other servers. But I do not know the phpBB
> software (which is not needed for the current problems).
>
> rgds
> jan I.
>
>
>
>
> >
> > --
> > Rory O'Farrell <of...@iol.ie>
> >
I realise you did offer, but you do so much this is another burden. I don't fault Imacat, who is involved with examinations which are more important.
Having another Administrator would avoid the problem that has arisen with the long term unavailability of a single admin.
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by janI <ja...@apache.org>.
On 8 August 2013 16:25, Rory O'Farrell <of...@iol.ie> wrote:
> On Thu, 8 Aug 2013 15:59:36 +0200 (CEST)
> FR web forum <oo...@free.fr> wrote:
>
> > >Seems fixed but very slow response.
> > No, error still occurs this afternoon.
> > Very annoying for end-users.
> > And we are on august (low traffic with vacations).
> > I'm afraid about september, forums will be completly unavailable.
> >
> I have asked on the en-Forum if there might be someone with phpBB/SQL
> admin experience who would like to give a hand, but no responses.
>
We already have a admin, and I hope that the admin soon will be active.
I have access to the server and have offered to help the admin, but got no
response. I know the general setup (mysql, httpd and ubuntu) quite well,
since I maintain a couple of other servers. But I do not know the phpBB
software (which is not needed for the current problems).
rgds
jan I.
>
> --
> Rory O'Farrell <of...@iol.ie>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by Rory O'Farrell <of...@iol.ie>.
On Thu, 8 Aug 2013 15:59:36 +0200 (CEST)
FR web forum <oo...@free.fr> wrote:
> >Seems fixed but very slow response.
> No, error still occurs this afternoon.
> Very annoying for end-users.
> And we are on august (low traffic with vacations).
> I'm afraid about september, forums will be completly unavailable.
>
I have asked on the en-Forum if there might be someone with phpBB/SQL admin experience who would like to give a hand, but no responses.
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by FR web forum <oo...@free.fr>.
>Seems fixed but very slow response.
No, error still occurs this afternoon.
Very annoying for end-users.
And we are on august (low traffic with vacations).
I'm afraid about september, forums will be completly unavailable.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by Kazunari Hirano <kh...@gmail.com>.
Hi,
Seems fixed but very slow response.
Thanks,
khirano
On Thu, Aug 8, 2013 at 8:22 PM, Kazunari Hirano <kh...@gmail.com> wrote:
> Hi,
> http://forum.openoffice.org/ja/forum/ is still getting the error.
> Not fixed yet?
>
> Thanks,
> khirano
>
>
> On Thu, Aug 8, 2013 at 4:35 AM, janI <ja...@apache.org> wrote:
>
>> On 7 August 2013 21:14, Raphael Bircher <r....@gmx.ch> wrote:
>>
>> > Am 07.08.13 21:04, schrieb Rory O'Farrell:
>> >
>> > On Wed, 7 Aug 2013 20:35:30 +0200
>> >> janI <ja...@apache.org> wrote:
>> >>
>> >> On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
>> >>>
>> >>> 2013/8/7 FR web forum <oo...@free.fr>
>> >>>>
>> >>>> I pull up this issue.
>> >>>>> The error occurs again since two weeks.
>> >>>>>
>> >>>>>
>> >>>>> Today, forums alternate between error 1040 and being slower than a
>> >>>> snail.
>> >>>> It is not possible to access them right now.
>> >>>>
>> >>>> I think you have some fast snails in your area :-)
>> >>>
>> >>> At least the vm itself seems relative ok now.
>> >>>
>> >>> However, I can see that there has been mysql problems earlier, seems
>> to
>> >>> be
>> >>> the old problem, that httpd tries to grap more connections than
>> >>> available.
>> >>>
>> >>> This time I could also see that the mysql buffer spaces had been
>> pretty
>> >>> full, without knowing the forum software, I would say that some of the
>> >>> tables should be converted to innodb. We did that on mwiki, and that
>> >>> change
>> >>> alone allowed mysql to handle a lot more parallel select statements
>> >>> (60-70%
>> >>> of the total).
>> >>>
>> >>> In general the configs are ok for normal daily traffic but cannot
>> handle
>> >>> peak situations.
>> >>>
>> >>> Rgds
>> >>> jan I.
>> >>>
>> >>>
>> >>> Regards
>> >>>> Ricardo
>> >>>>
>> >>>>
>> >>>>
>> >>>> For interested look at:
>> >>>>>> INFRA-6097 which request mysql optimization and
>> >>>>>> INFRA-6098 which request httpd/ats/php optimization
>> >>>>>> They are assigned to me, but when I do it, I need somebody to help
>> >>>>>> test...any volunteers ?
>> >>>>>>
>> >>>>> Just before one outage of the forum today there were 150 users
>> online,
>> >> which is a long way short of the maximum logged of 294. An interesting
>> >> thing I have noted is that it is often slow, leading to an error 10040
>> at
>> >> about 0930 UTC+1; this happens quite regularly.
>> >>
>> >> Maybe this is the backup. Bugzilla has the same behavure at the same
>> > time. Or ASF Server simply don't like morning ;-)
>> >
>>
>> good tip to the forum adminidtrator, backup script start at 6:46 UTC, with
>> a sqldump, then generating/encrypting backup files and finally rsync to
>> the
>> backup server. This costs some cpu cycles and takes memory. This can cause
>> a simualted peak situation, when some users (30-40) at the same time are
>> quite active then the vm will have a problem.
>>
>>
>> rgds
>> jan I.
>>
>>
>> >
>> > Greetings Raphael
>> >
>> >
>> >
>> ------------------------------**------------------------------**---------
>> > To unsubscribe, e-mail: dev-unsubscribe@openoffice.**apache.org<
>> dev-unsubscribe@openoffice.apache.org>
>> > For additional commands, e-mail: dev-help@openoffice.apache.org
>> >
>> >
>>
>
>
>
> --
> khirano@apache.org
> Apache OpenOffice
> http://openoffice.apache.org
>
--
khirano@apache.org
Apache OpenOffice
http://openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by Kazunari Hirano <kh...@gmail.com>.
Hi,
http://forum.openoffice.org/ja/forum/ is still getting the error.
Not fixed yet?
Thanks,
khirano
On Thu, Aug 8, 2013 at 4:35 AM, janI <ja...@apache.org> wrote:
> On 7 August 2013 21:14, Raphael Bircher <r....@gmx.ch> wrote:
>
> > Am 07.08.13 21:04, schrieb Rory O'Farrell:
> >
> > On Wed, 7 Aug 2013 20:35:30 +0200
> >> janI <ja...@apache.org> wrote:
> >>
> >> On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
> >>>
> >>> 2013/8/7 FR web forum <oo...@free.fr>
> >>>>
> >>>> I pull up this issue.
> >>>>> The error occurs again since two weeks.
> >>>>>
> >>>>>
> >>>>> Today, forums alternate between error 1040 and being slower than a
> >>>> snail.
> >>>> It is not possible to access them right now.
> >>>>
> >>>> I think you have some fast snails in your area :-)
> >>>
> >>> At least the vm itself seems relative ok now.
> >>>
> >>> However, I can see that there has been mysql problems earlier, seems to
> >>> be
> >>> the old problem, that httpd tries to grap more connections than
> >>> available.
> >>>
> >>> This time I could also see that the mysql buffer spaces had been pretty
> >>> full, without knowing the forum software, I would say that some of the
> >>> tables should be converted to innodb. We did that on mwiki, and that
> >>> change
> >>> alone allowed mysql to handle a lot more parallel select statements
> >>> (60-70%
> >>> of the total).
> >>>
> >>> In general the configs are ok for normal daily traffic but cannot
> handle
> >>> peak situations.
> >>>
> >>> Rgds
> >>> jan I.
> >>>
> >>>
> >>> Regards
> >>>> Ricardo
> >>>>
> >>>>
> >>>>
> >>>> For interested look at:
> >>>>>> INFRA-6097 which request mysql optimization and
> >>>>>> INFRA-6098 which request httpd/ats/php optimization
> >>>>>> They are assigned to me, but when I do it, I need somebody to help
> >>>>>> test...any volunteers ?
> >>>>>>
> >>>>> Just before one outage of the forum today there were 150 users
> online,
> >> which is a long way short of the maximum logged of 294. An interesting
> >> thing I have noted is that it is often slow, leading to an error 10040
> at
> >> about 0930 UTC+1; this happens quite regularly.
> >>
> >> Maybe this is the backup. Bugzilla has the same behavure at the same
> > time. Or ASF Server simply don't like morning ;-)
> >
>
> good tip to the forum adminidtrator, backup script start at 6:46 UTC, with
> a sqldump, then generating/encrypting backup files and finally rsync to the
> backup server. This costs some cpu cycles and takes memory. This can cause
> a simualted peak situation, when some users (30-40) at the same time are
> quite active then the vm will have a problem.
>
>
> rgds
> jan I.
>
>
> >
> > Greetings Raphael
> >
> >
> > ------------------------------**------------------------------**---------
> > To unsubscribe, e-mail: dev-unsubscribe@openoffice.**apache.org<
> dev-unsubscribe@openoffice.apache.org>
> > For additional commands, e-mail: dev-help@openoffice.apache.org
> >
> >
>
--
khirano@apache.org
Apache OpenOffice
http://openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by janI <ja...@apache.org>.
On 7 August 2013 21:14, Raphael Bircher <r....@gmx.ch> wrote:
> Am 07.08.13 21:04, schrieb Rory O'Farrell:
>
> On Wed, 7 Aug 2013 20:35:30 +0200
>> janI <ja...@apache.org> wrote:
>>
>> On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
>>>
>>> 2013/8/7 FR web forum <oo...@free.fr>
>>>>
>>>> I pull up this issue.
>>>>> The error occurs again since two weeks.
>>>>>
>>>>>
>>>>> Today, forums alternate between error 1040 and being slower than a
>>>> snail.
>>>> It is not possible to access them right now.
>>>>
>>>> I think you have some fast snails in your area :-)
>>>
>>> At least the vm itself seems relative ok now.
>>>
>>> However, I can see that there has been mysql problems earlier, seems to
>>> be
>>> the old problem, that httpd tries to grap more connections than
>>> available.
>>>
>>> This time I could also see that the mysql buffer spaces had been pretty
>>> full, without knowing the forum software, I would say that some of the
>>> tables should be converted to innodb. We did that on mwiki, and that
>>> change
>>> alone allowed mysql to handle a lot more parallel select statements
>>> (60-70%
>>> of the total).
>>>
>>> In general the configs are ok for normal daily traffic but cannot handle
>>> peak situations.
>>>
>>> Rgds
>>> jan I.
>>>
>>>
>>> Regards
>>>> Ricardo
>>>>
>>>>
>>>>
>>>> For interested look at:
>>>>>> INFRA-6097 which request mysql optimization and
>>>>>> INFRA-6098 which request httpd/ats/php optimization
>>>>>> They are assigned to me, but when I do it, I need somebody to help
>>>>>> test...any volunteers ?
>>>>>>
>>>>> Just before one outage of the forum today there were 150 users online,
>> which is a long way short of the maximum logged of 294. An interesting
>> thing I have noted is that it is often slow, leading to an error 10040 at
>> about 0930 UTC+1; this happens quite regularly.
>>
>> Maybe this is the backup. Bugzilla has the same behavure at the same
> time. Or ASF Server simply don't like morning ;-)
>
good tip to the forum adminidtrator, backup script start at 6:46 UTC, with
a sqldump, then generating/encrypting backup files and finally rsync to the
backup server. This costs some cpu cycles and takes memory. This can cause
a simualted peak situation, when some users (30-40) at the same time are
quite active then the vm will have a problem.
rgds
jan I.
>
> Greetings Raphael
>
>
> ------------------------------**------------------------------**---------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.**apache.org<de...@openoffice.apache.org>
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by Raphael Bircher <r....@gmx.ch>.
Am 07.08.13 21:04, schrieb Rory O'Farrell:
> On Wed, 7 Aug 2013 20:35:30 +0200
> janI <ja...@apache.org> wrote:
>
>> On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
>>
>>> 2013/8/7 FR web forum <oo...@free.fr>
>>>
>>>> I pull up this issue.
>>>> The error occurs again since two weeks.
>>>>
>>>>
>>> Today, forums alternate between error 1040 and being slower than a snail.
>>> It is not possible to access them right now.
>>>
>> I think you have some fast snails in your area :-)
>>
>> At least the vm itself seems relative ok now.
>>
>> However, I can see that there has been mysql problems earlier, seems to be
>> the old problem, that httpd tries to grap more connections than available.
>>
>> This time I could also see that the mysql buffer spaces had been pretty
>> full, without knowing the forum software, I would say that some of the
>> tables should be converted to innodb. We did that on mwiki, and that change
>> alone allowed mysql to handle a lot more parallel select statements (60-70%
>> of the total).
>>
>> In general the configs are ok for normal daily traffic but cannot handle
>> peak situations.
>>
>> Rgds
>> jan I.
>>
>>
>>> Regards
>>> Ricardo
>>>
>>>
>>>
>>>>> For interested look at:
>>>>> INFRA-6097 which request mysql optimization and
>>>>> INFRA-6098 which request httpd/ats/php optimization
>>>>> They are assigned to me, but when I do it, I need somebody to help
>>>>> test...any volunteers ?
> Just before one outage of the forum today there were 150 users online, which is a long way short of the maximum logged of 294. An interesting thing I have noted is that it is often slow, leading to an error 10040 at about 0930 UTC+1; this happens quite regularly.
>
Maybe this is the backup. Bugzilla has the same behavure at the same
time. Or ASF Server simply don't like morning ;-)
Greetings Raphael
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by Rory O'Farrell <of...@iol.ie>.
On Wed, 7 Aug 2013 20:35:30 +0200
janI <ja...@apache.org> wrote:
> On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
>
> > 2013/8/7 FR web forum <oo...@free.fr>
> >
> > > I pull up this issue.
> > > The error occurs again since two weeks.
> > >
> > >
> > Today, forums alternate between error 1040 and being slower than a snail.
> > It is not possible to access them right now.
> >
> I think you have some fast snails in your area :-)
>
> At least the vm itself seems relative ok now.
>
> However, I can see that there has been mysql problems earlier, seems to be
> the old problem, that httpd tries to grap more connections than available.
>
> This time I could also see that the mysql buffer spaces had been pretty
> full, without knowing the forum software, I would say that some of the
> tables should be converted to innodb. We did that on mwiki, and that change
> alone allowed mysql to handle a lot more parallel select statements (60-70%
> of the total).
>
> In general the configs are ok for normal daily traffic but cannot handle
> peak situations.
>
> Rgds
> jan I.
>
>
> >
> > Regards
> > Ricardo
> >
> >
> >
> > > >For interested look at:
> > >
> > > >INFRA-6097 which request mysql optimization and
> > > >INFRA-6098 which request httpd/ats/php optimization
> > >
> > > >They are assigned to me, but when I do it, I need somebody to help
> > > >test...any volunteers ?
> > >
Just before one outage of the forum today there were 150 users online, which is a long way short of the maximum logged of 294. An interesting thing I have noted is that it is often slow, leading to an error 10040 at about 0930 UTC+1; this happens quite regularly.
--
Rory O'Farrell <of...@iol.ie>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by janI <ja...@apache.org>.
On 7 August 2013 17:28, Ricardo Berlasso <rg...@gmail.com> wrote:
> 2013/8/7 FR web forum <oo...@free.fr>
>
> > I pull up this issue.
> > The error occurs again since two weeks.
> >
> >
> Today, forums alternate between error 1040 and being slower than a snail.
> It is not possible to access them right now.
>
I think you have some fast snails in your area :-)
At least the vm itself seems relative ok now.
However, I can see that there has been mysql problems earlier, seems to be
the old problem, that httpd tries to grap more connections than available.
This time I could also see that the mysql buffer spaces had been pretty
full, without knowing the forum software, I would say that some of the
tables should be converted to innodb. We did that on mwiki, and that change
alone allowed mysql to handle a lot more parallel select statements (60-70%
of the total).
In general the configs are ok for normal daily traffic but cannot handle
peak situations.
Rgds
jan I.
>
> Regards
> Ricardo
>
>
>
> > >For interested look at:
> >
> > >INFRA-6097 which request mysql optimization and
> > >INFRA-6098 which request httpd/ats/php optimization
> >
> > >They are assigned to me, but when I do it, I need somebody to help
> > >test...any volunteers ?
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> > For additional commands, e-mail: dev-help@openoffice.apache.org
> >
> >
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by Ricardo Berlasso <rg...@gmail.com>.
2013/8/7 FR web forum <oo...@free.fr>
> I pull up this issue.
> The error occurs again since two weeks.
>
>
Today, forums alternate between error 1040 and being slower than a snail.
It is not possible to access them right now.
Regards
Ricardo
> >For interested look at:
>
> >INFRA-6097 which request mysql optimization and
> >INFRA-6098 which request httpd/ats/php optimization
>
> >They are assigned to me, but when I do it, I need somebody to help
> >test...any volunteers ?
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: dev-help@openoffice.apache.org
>
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by FR web forum <oo...@free.fr>.
I pull up this issue.
The error occurs again since two weeks.
>For interested look at:
>INFRA-6097 which request mysql optimization and
>INFRA-6098 which request httpd/ats/php optimization
>They are assigned to me, but when I do it, I need somebody to help
>test...any volunteers ?
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@openoffice.apache.org
For additional commands, e-mail: dev-help@openoffice.apache.org
Re: Forums down (SQL error: Too many connections [1040])
Posted by janI <ja...@apache.org>.
For interested look at:
INFRA-6097 which request mysql optimization and
INFRA-6098 which request httpd/ats/php optimization
They are assigned to me, but when I do it, I need somebody to help
test...any volunteers ?
rgds
jan I.
On 2 April 2013 13:03, imacat <im...@mail.imacat.idv.tw> wrote:
> Waoh... You are awesome!
>
> On 2013/04/02 15:22, janI said:
> > 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.
> >
>
>
> --
> Best regards,
> imacat ^_*' <im...@mail.imacat.idv.tw>
> PGP Key http://www.imacat.idv.tw/me/pgpkey.asc
>
> <<Woman's Voice>> News: http://www.wov.idv.tw/
> Tavern IMACAT's http://www.imacat.idv.tw/
> Woman in FOSS in Taiwan http://wofoss.blogspot.com/
> OpenOffice http://www.openoffice.org/
> EducOO/OOo4Kids Taiwan http://www.educoo.tw/
> Greenfoot Taiwan http://greenfoot.westart.tw/
>
>
Re: Forums down (SQL error: Too many connections [1040])
Posted by imacat <im...@mail.imacat.idv.tw>.
Waoh... You are awesome!
On 2013/04/02 15:22, janI said:
> 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.
>
--
Best regards,
imacat ^_*' <im...@mail.imacat.idv.tw>
PGP Key http://www.imacat.idv.tw/me/pgpkey.asc
<<Woman's Voice>> News: http://www.wov.idv.tw/
Tavern IMACAT's http://www.imacat.idv.tw/
Woman in FOSS in Taiwan http://wofoss.blogspot.com/
OpenOffice http://www.openoffice.org/
EducOO/OOo4Kids Taiwan http://www.educoo.tw/
Greenfoot Taiwan http://greenfoot.westart.tw/