Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43261
Total Topics: 7519
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 265
Total: 266

Author Topic: Slow on forum with tens of thousands of images  (Read 7141 times)

0 Members and 1 Guest are viewing this topic.

Offline tank_fv101

  • Community Suite Customer
  • Jr. Member
  • ******
  • Posts: 77
    • View Profile
    • N Gauge Forum
Slow on forum with tens of thousands of images
« on: July 23, 2023, 02:16:42 pm »
On a very large site with SMF Gallery we keep getting this:

"Waiting for table level lock"

 as one of the reason for intense MySQL slow queries that causes pages to take up to 20 seconds to load!

It is associated with as an example:

Code: [Select]
SELECT COUNT(*) as total FROM smf_gallery_pic as p LEFT JOIN smf_members AS m ON (p.ID_M
Is there a way to make the tables work with Innodb to help?

We tried changing them but found it would stop posting the code in topics where it was connected to the gallery.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Slow on forum with tens of thousands of images
« Reply #1 on: July 23, 2023, 08:51:40 pm »
You should be able to change the tables to INNODB for all the gallery tables without issues.

For query can you do a MYSQL explain in front of it.

Also I want to see the table indexes from smf_gallery_pic.
Command below.
SHOW INDEX FROM smf_gallery_pic;
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline tank_fv101

  • Community Suite Customer
  • Jr. Member
  • ******
  • Posts: 77
    • View Profile
    • N Gauge Forum
Re: Slow on forum with tens of thousands of images
« Reply #2 on: August 08, 2023, 10:22:55 am »
Please see attached.

Also, as said above when we change the table engine this happens:

Quote
We tried changing them but found it would stop posting the code in topics where it was connected to the gallery.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Slow on forum with tens of thousands of images
« Reply #3 on: August 08, 2023, 10:26:45 am »
Any more of the slow query I just see part of it.
The indexes seem find.

When changing table engines I would change all tables part of the gallery. That behavior above seems unusual. The table engine shouldn't change how code works in that case.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline tank_fv101

  • Community Suite Customer
  • Jr. Member
  • ******
  • Posts: 77
    • View Profile
    • N Gauge Forum
Re: Slow on forum with tens of thousands of images
« Reply #4 on: August 08, 2023, 05:31:29 pm »
I changed all the tables to INNODB and I believe that was a big help. However, as previously posted on Quick Reply when using the popup instead of inserting the code it loads the page you are posting on within the popup.

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
6817 Views
Last post March 31, 2007, 01:37:52 pm
by SMFHacks
4 Replies
6840 Views
Last post January 10, 2008, 09:39:04 pm
by 5thmsstech
3 Replies
6143 Views
Last post October 10, 2008, 07:43:27 am
by jsanglier
36 Replies
7914 Views
Last post March 11, 2018, 11:03:55 pm
by TeraS
10 Replies
3953 Views
Last post August 02, 2018, 10:07:47 pm
by shuban

+- Recent Topics

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
Today at 08:27:36 am

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Powered by EzPortal