The longer the thread the longer it takes to post replies to it

[tortyNet]

Thanks for the info, thats basically the index we added to solve the posting timings. However index pages still render quite slow. Lets see if 5.5 brings any help here

[tortyNet]

Hmm I think we found something:

This query takes really long for what it is doing ->

SELECT `lastcontent`,`lastcontentid`,`lastcontentauthor`,`lastauthorid` FROM node

...

[tortyNet]

Hi,

we have some strange behavior on long running threads (6k+ answers 400+ pages) While the single thread pages render fine, it takes a very long time to post new answers to this kind of...

[tortyNet]

Seems to be a channel listing query. They tend to take some time if not already in cache. :-)

[tortyNet]

15 PrivateMessage
29 Channel

Result to your query:

35    105    29    1479934935    NULL    1    NULL    admin    <i><small>Moderatoren: dieMeike,

...

[tortyNet]

All INNODB Variables? Ok .. here you go

 [TABLE="align: center, border: 0, cellpadding: 4, cellspacing: 0"]
[TR]
[TD="align: left"]innodb_adaptive_flushing[/TD]
 			[TD]ON[/TD]
 		[/TR]
[TR]
[TD="align:[/]

...

[tortyNet]

Yes we do ... and we do have some with queries like this:

SELECT DISTINCT node.starter AS nodeid
            FROM node as node
            LEFT JOIN node AS starter ON starter.nodeid

...

[tortyNet]

No recent start .. it was always slow. We came from vb4 and moved to 5 like 1.5 years ago. It got better with moving the whole site to memcache as caching instead of database caching.

I'm...

[tortyNet]

No real speedup. Seems like the more traffic we have the slower it gets (while posting to Forum is still fast, even edit and re-save is fast)
I will try to find some time to dig into the queries...

[tortyNet]

We are using memcache as primary cache so cache and cacheevent are empty. I cleared the searchlog .. lets see if this helps...

[tortyNet]

We thought about that already. Just tested again .. we are using a smtp relay. Works nearly instant so no server delay here .. also no errors obviously. But thanks for the help :-)...

[tortyNet]

Regarding the pure size of 30 Gig Database and the GDPR issues we would run into, that's not really an option for us :-)...

[tortyNet]

Ok .. i activated debug .. and found out what i was asking .. I don't get any information about the ajax POST request to /private-message/ (that is actually taking so much time) before i get forwareded...

[tortyNet]

I will get debug output/info on the ajax query to "/create-content/private-message/"
The reload after that is quite fast again.

I'm not keen on setting a live site in debug...

[tortyNet]

Latest stable vBulletin 5.4.1
PHP 7.1.17
MySQL 5.6
All Tables INNODB

I thought about the sentto table .. currently there are ~ 1.9 mio entries in there ... according to...