Re: [Tiki-devel] Poor performance on doc (maybe dev too) hopefully fixed
Bsfez Tiki via TikiWiki-devel <[email protected]>
| Newsgroups | gmane.comp.cms.tiki.devel |
|---|---|
| Message-ID | <[email protected]> |
Thanks Jonny ! Little by little working on t.o website are much better. B > On 23 Jun 2021, at 17:44 , Jonny Bradley via TikiWiki-devel <[email protected]> wrote: > > Hi all again > > I was trying to add some new screenies on doc and the file galleries were being really slow again, so i had a look in the database and the tiki_auth_tokens table (which i cleared out about a month ago) now has 128,000 rows in it again - it seems auth tokens are being issued there every 10-15 seconds for some strange reason (web crawlers indexing PDF links maybe?) so the fix i made doesn't seem to be working... > > Ok, seems the PDF generators were adding a token and then not cleaning it up afterwards, and if no tokens are then used afterwards nothing was then removing the expired ones, so i added deleteToken in 0672f897 and backported that to 22.x > > Also i cleared out the tiki_auth_tokens again manually so we're able to use the file galleries again - hope it didn't bork anything else! > > Now where was i..? > > jonny > > > > >> On 24 May 2021, at 19:44, Jonny Bradley <[email protected]> wrote: >> >> I started trying to fix the missing images on http://doc.tiki.org/PluginImg but needed to check in the file galleries, which have been broken there for months, so i investigated... >> >> And eventually, found there were about 2 million expired auth tokens in the database (generated when pages are printed i think), due to some poor code in \AuthTokens::getGroups, which i (hopefully) have fixed in: >> >> https://gitlab.com/tikiwiki/tiki/-/commit/5292fbdf >> >> I've also backup up and removed all the expired tokens from the tiki_auth_tokens table on doc, and now we have filegals back again, woo! >> >> e.g. >> >> https://doc.tiki.org/file5 >> >> Seems that table on dev also has about 1.5 million row, so i'll do the same expiry delete query there too... >> >> And once the tikis there have updated (usually overnight i think) this shouldn't happen again - hopefully... >> >> jonny >> >> > > > > _______________________________________________ > TikiWiki-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel