#1 WordPress forum plugin created by gVectors Team

wpForo – WordPress Forum Plugin
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation

Forum

Home | Forum

wpDiscuz - WordPress Comment Plugin
  • Forums
  • Members
  • Recent Posts
Forums
Main Support Forums
How-to and Troubles...
slow queries
 
Share:
Notifications
Clear all

slow queries  

Page 1 / 2 Next
    Last Post
RSS

Mondesensuel
Posts: 50
 Mondesensuel
Topic starter
January 13, 2021 4:56 pm
(@mondesensuel)
Trusted Member
Joined: 4 years ago

Hello,

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

Thank you

 

 slow-queries.png
19 Replies
Martin
Posts: 688
Martin - Facebook Martin - Twitter
 Martin
Moderator
January 13, 2021 6:55 pm
(@martin)
Support Team
Joined: 5 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. 

Powered by gVectors Team. our popular plugins:
wpForo, wpDiscuz

Reply
Mondesensuel
Posts: 50
 Mondesensuel
Topic starter
January 13, 2021 7:27 pm
(@mondesensuel)
Trusted Member
Joined: 4 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 🙁

 

 
 slow-queries2.png
Reply
5 Replies
Martin
 Martin
Moderator
(@martin)
Joined: 5 years ago

Support Team
Posts: 688
Martin - Facebook Martin - Twitter
January 13, 2021 7:29 pm
Reply toMondesensuelMondesensuel

@mondesensuel,

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

Powered by gVectors Team. our popular plugins:
wpForo, wpDiscuz

Reply
Martin
 Martin
Moderator
(@martin)
Joined: 5 years ago

Support Team
Posts: 688
Martin - Facebook Martin - Twitter
January 13, 2021 7:31 pm
Reply toMartinMartin
Mondesensuel

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

Powered by gVectors Team. our popular plugins:
wpForo, wpDiscuz

Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 7:36 pm
Reply toMartinMartin
Mondesensuel

@martin

 wpforo-tables.png
Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 7:42 pm
Reply toMondesensuelMondesensuel
Martin
Mondesensuel

done, but now :

 

 slow-queries3.png
Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 7:42 pm
Reply toMondesensuelMondesensuel
Martin
Mondesensuel

and it

 slow-queries4.png
Reply
dimalifragis
Posts: 125
 dimalifragis
January 13, 2021 7:57 pm
(@dimalifragis)
Estimable Member
Joined: 9 months ago

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

Reply
5 Replies
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 8:32 pm
Reply todimalifragisdimalifragis

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

 slow-queries5.png
Reply
dimalifragis
 dimalifragis
(@dimalifragis)
Joined: 9 months ago

Estimable Member
Posts: 125
January 13, 2021 9:09 pm
Reply toMondesensuelMondesensuel
dimalifragis
Posted by: @mondesensuel

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

 slow-queries5.png

Nothing will happen to your site for 5 minutes.

 

Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 8:41 pm
Reply todimalifragisdimalifragis

@dimalifragis or not.

 

 slow-queries8.png
Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 13, 2021 8:41 pm
Reply todimalifragisdimalifragis

@dimalifragis

 slow-queries6.png
Reply
dimalifragis
 dimalifragis
(@dimalifragis)
Joined: 9 months ago

Estimable Member
Posts: 125
January 13, 2021 9:12 pm
Reply toMondesensuelMondesensuel
dimalifragis

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

Is a big site? Big wpForo ?

Reply
Martin
Posts: 688
Martin - Facebook Martin - Twitter
 Martin
Moderator
January 15, 2021 6:39 am
(@martin)
Support Team
Joined: 5 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

Powered by gVectors Team. our popular plugins:
wpForo, wpDiscuz

Reply
2 Replies
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 15, 2021 9:28 am
Reply toMartinMartin

@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 ?

 

Reply
Mondesensuel
 Mondesensuel
(@mondesensuel)
Joined: 4 years ago

Trusted Member
Posts: 50
January 15, 2021 9:46 am
Reply toMartinMartin

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

 

 slow-queries9.png
Reply
Page 1 / 2 Next
  All forum topics
  Previous Topic
Next Topic  

Recently viewed by users: Alber_97 7 mins ago.

Forum Search

Join Us!

Download wpForo plugin
on WordPress.org

wpForo Addons

wpforo-private-messages  wpforo-advanced-attachments-128x128  wpforo-embeds-128x128 wpForo User Custom Fields addon  wpForo – Blog Cross Posting addon  wpForo Ads Manager
View all Addons »

Recent Topics

  • A HUGE problem with an user

    By Alber_97, 9 mins ago

  • Help please

    By Creationweb, 4 hours ago

  • Settings for attachements cannot be saved

    By Jheronimus, 4 hours ago

  • Reply button problem

    By xfok, 5 hours ago

  • Advanced search including date fields as the default home page

    By Arik, 9 hours ago

  • Adding members, recent posts and my profile to the forum menu

    By Xaleah, 20 hours ago

Topic Tags

  • new features43
  • seo39
  • translation36
  • plugin conflict35
  • forum32
  • buddypress31
  • login31
  • threaded layout30
  • registration29
  • ultimate member28
  • moderation27
  • editor25
  • avatar24
  • shortcode23
  • css23
  • tags21
  • migration20
  • url20
  • menu20
  • colors19
View all tags (1465)

Recent Posts

  • A HUGE problem with an user

    I have a problem with a user who is uploading ILLEGAL p...

    By Alber_97, 9 mins ago

  • RE: PHP error, need help

    You should check to make sure all folders have 755 perm...

    By Percysgrowroom, 1 hour ago

  • RE: slow queries

    This is the official post about caching: I'm not f...

    By dimalifragis, 2 hours ago

  • RE: Why wpForo using two Font Awesome files?

    @adisaputro, I'm sorry but it's not possible, they a...

    By Robert, 2 hours ago

  • RE: Help please

    @Martin Thank you for your prompt response, I attach ne...

    By Creationweb, 3 hours ago

  • RE: Settings for attachements cannot be saved

    Thank you so much, that worked! Sorry, newbie here!

    By Jheronimus, 4 hours ago

  • RE: Reply button problem

    Hi @xfok, Could you please show me on a screenshot wh...

    By Martin, 4 hours ago

Share:
  Forum Statistics
20 Forums
7,753 Topics
38.9 K Posts
4 Online
14.8 K Members

Latest Post: A HUGE problem with an user Our newest member: zakisoft Recent Posts Unread Posts Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo | Copyright © 2016-2021 gVectors Team
Copyright Registration Service - Click here for more information or to register work
wpForo is Registered with the IP Rights Office
Copyright Registration Service

Ref: 4477265538
  • Home
  • Forum
  • Migrate to wpForo
  • Addons
  • Documentation