Re: [Tiki-devel] Poor performance on doc (maybe dev too) hopefully fixed
Jonny Bradley via TikiWiki-devel <[email protected]>
| Newsgroups | gmane.comp.cms.tiki.devel |
|---|---|
| Message-ID | <[email protected]> |
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 > >