Notifications
Clear all

wpForo 1.x.x [Closed] slow queries

26 Posts
4 Users
2 Reactions
2,266 Views
Posts: 53
Topic starter
(@mondesensuel)
Trusted Member
Joined: 8 years ago

Hello,

I have many slow queries on my forum. How I can to fix it ?

Thank you

 

25 Replies
Posts: 992
Moderator
(@martin)
Support Team
Joined: 8 years ago

Hi @mondesensuel,

1. Please let me know what Table Engine (InnoDB or MyISAM) is used for tables with _wpforo_ secondary prefixes in the database? You can use phpMyAdmin plugin to check it.

 

2. Make sure these options are enabled in Dashboard > Forums > Settings > Features Tab:

  • Enable Member Cache
  • Enable Object Cache
  • Enable Options Cache
  • Enable Memory Cache

 

3. Check the issues in the Dashboard > Forums > Tools > Debug Tab > Tables Sub-tab. If you see any issue, please click the [Solve Database Problems] button. 

Posts: 53
Topic starter
(@mondesensuel)
Trusted Member
Joined: 8 years ago

Hi,

thank you for your fast answer.

1.It's InnoDB.

2. all is enable (member cache was not)

3. no probems found in database

Less slower queries, but more time 🙁

 

 
5 Replies
Moderator
(@martin)
Joined: 8 years ago

Support Team
Posts: 992

@mondesensuel,

Could you please leave a similar screenshot of your _wpforo_ tables?

Moderator
(@martin)
Joined: 8 years ago

Support Team
Posts: 992

Also, try to change the wp_wpforo_visits table engine to MyISAM using the corresponding option in the "Operations" Tab of the phpMyAdmin tool.

(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53
(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53
(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53
dimalifragis
Posts: 2611
(@dimalifragis)
Famed Member
Joined: 5 years ago

Could you try to disable Wordpfence for a few minutes and check again if something changes.

5 Replies
(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53

@dimalifragis yes it's better but my website isn't protected 🙁

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611
Posted by: @mondesensuel

@dimalifragis yes it's better but my website isn't protected 🙁

Nothing will happen to your site for 5 minutes.

 

(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53
(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53
dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@mondesensuel What kind of hosting plan are you using? PHP ? DB ? memory ?

Is a big site? Big wpForo ?

Posts: 992
Moderator
(@martin)
Support Team
Joined: 8 years ago

I don't see big issues related to wpForo anymore. You can change the table Engine for these two tables as well:

  • wp_wpforo_profiles
  • wp_wpforo_likes
2 Replies
(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53

@martin I change it in MyISAM for profiles and likes ?

@dimalifragis not a bit site : https://mondesensuel.fr/forum

I have a VPS server : 

  • Bi Intel® Xeon®
    E5-2650
    (20 coeurs 3.0 GHz)
  • 3 (3x3.0 GHz)
  • 8 Go ram
  • 6 Go Vswap ssd
  • PHP 7.4

What is DB ?

 

(@mondesensuel)
Joined: 8 years ago

Trusted Member
Posts: 53

@martin today, it's 2,5 seconds lost with slow querries 🙁

 

Page 1 / 2