Kako videti sta gusi Apache server? - Strana 2

Milos Vukotic · 20. 01. 2012.

Prisjeti se da li možda radiš pretragu nad nekim neindeksiranim poljem. Ja sam se jednom namučio oko nekog usporenog cms-a dok nisam provalio da kao referencu za prikaz tekstova ne koristi ID kategorije već njen url-slug, koji se nalazio u neindeksiranom varchar polju.

A za "show processlist", u konzoli (putty) prvo kucaj:
mysql -u tvojDBuser -p;
(potom ukucaš password)
show processlist;

MorenoArdohain · 20. 01. 2012.

Koliko vidim, LiteSpeed je zamena za Apache. Ako ti se smanjio load na jednu trecinu, to znaci da ti mysql onda nije ni pravio problem??

ljtruba · 20. 01. 2012.

evo resenja

Hello,

The only thing that I can think of at the moment is that you had a bunch of minicalendar entries in the cache store table.. Over 1500.. that.. We know that the fact that there ARE that many is an issue, however, we're looking into seeing if that causes load issues when there gets to be so many.

I've cleared those out, so, if that is part of the problem, it should stop now.. But, can you let me know the next time the load shoots up so we can try to see it as it's happening?

Hello,

No.. It's not spam, it's just.. Everytime a minicalendar is displayed, it is cached.. But, never removed from the cache.. So, if a spider starts following the 'next month' links on a calendar, it can cache all the way to the year 2038 or so.. Every month.. Which builds all those records up in the cache_store.

20. 01. 2012.	#11
Milos Vukotic Knowledge base Wrote a book Datum učlanjenja: 07.06.2005 Lokacija: Neđe ođe... Poruke: 1.198 Hvala: 339 688 "Hvala" u 178 poruka	Prisjeti se da li možda radiš pretragu nad nekim neindeksiranim poljem. Ja sam se jednom namučio oko nekog usporenog cms-a dok nisam provalio da kao referencu za prikaz tekstova ne koristi ID kategorije već njen url-slug, koji se nalazio u neindeksiranom varchar polju. A za "show processlist", u konzoli (putty) prvo kucaj: mysql -u tvojDBuser -p; (potom ukucaš password) show processlist; __________________ Чак Норис може да си ги врзе врвките на чевлите со стапалата.

20. 01. 2012.	#12
MorenoArdohain Knowledge base Wrote a book Datum učlanjenja: 16.06.2005 Lokacija: Novi Sad Poruke: 1.437 Hvala: 37 131 "Hvala" u 82 poruka	Koliko vidim, LiteSpeed je zamena za Apache. Ako ti se smanjio load na jednu trecinu, to znaci da ti mysql onda nije ni pravio problem?? __________________ Não quero mais seguir um só caminho Poslednja izmena od MorenoArdohain : 20. 01. 2012. u 00:15.

20. 01. 2012.	#13
ljtruba old school Expert Datum učlanjenja: 14.10.2006 Poruke: 460 Hvala: 39 17 "Hvala" u 14 poruka	evo resenja Hello, The only thing that I can think of at the moment is that you had a bunch of minicalendar entries in the cache store table.. Over 1500.. that.. We know that the fact that there ARE that many is an issue, however, we're looking into seeing if that causes load issues when there gets to be so many. I've cleared those out, so, if that is part of the problem, it should stop now.. But, can you let me know the next time the load shoots up so we can try to see it as it's happening? Hello, No.. It's not spam, it's just.. Everytime a minicalendar is displayed, it is cached.. But, never removed from the cache.. So, if a spider starts following the 'next month' links on a calendar, it can cache all the way to the year 2038 or so.. Every month.. Which builds all those records up in the cache_store.