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 <ima...@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 ^_*' <ima...@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/ > >
