Jump to content

Slow Queries


RevengeFNF

Recommended Posts

Hello,

I always got a problem with the "Mark topics a user have replied", so i turned it off since it was introduced.

Since the Preview of IPS4 that i noticed that option is On by default and we cannot turn it off, i turned it on on my board so i could test it if the problem was gone.

The result was the Query for that option taking sometime 1 full minute... So i opened a ticket in the support.

This problem is solved in IPS4 and they applied the fix to my 3.4 board. But even that way, sometimes the query takes 5 to 10 seconds, which is enough to have some of my members complaing about the speed.

Some examples:

# Query_time: 12.299088  Lock_time: 0.000284 Rows_sent: 9  Rows_examined: 14163
SET timestamp=1418257731;
SELECT DISTINCT (topic_id), author_id FROM x_utf_ibf_posts WHERE  queued=0  AND author_id=12390 AND topic_id IN(64878,65574,65639,65579,65573,65276,65717,65571,62946,64967,65572,64221,49216,65671,62426,64283,63370,65585,65509,64220,65453,65465,65576,56600,35237);
# Time: 141211  1:31:46

# Query_time: 5.879324  Lock_time: 0.000166 Rows_sent: 12  Rows_examined: 21458
SET timestamp=1418257906;
SELECT DISTINCT (topic_id), author_id FROM x_utf_ibf_posts WHERE  queued=0  AND author_id=346 AND topic_id IN(64878,65574,65639,65579,65573,65276,65717,49216,65671,62426,65585,64220,65453,65576,35237,60724,59951,62753,63421,64222,65437,45727,63776,65417,63764);
# Time: 141211  1:32:53

# Query_time: 6.245190  Lock_time: 0.000168 Rows_sent: 8  Rows_examined: 22275
SET timestamp=1418319220;
SELECT DISTINCT (topic_id), author_id FROM x_utf_ibf_posts WHERE  queued=0  AND author_id=25536 AND topic_id IN(63306,65719,64425,65276,65572,65682,49216,62426,65453,60724,65436,64220,65671,64222,64246,61334,64004,65703,65509,35237,59951,62753,65627,4854,59836);
# Time: 141211 18:36:41

So what solutions do we have if we find this problem in IPS4?

I believe the problem might be in the fact that i use a VPS with an HDD. That HDD is shared by all the VPS's. But with that option turn off my site is really fast, so i don't see the need of going to a dedicated Server. I also don't use Ads, so i don't generate any kind of revenue. All the money for the VPS, Licenses etc etc, comes from my pocket.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...