Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12239
Latest: allershm
New This Month: 8
New This Week: 4
New Today: 0
Stats
Total Posts: 39378
Total Topics: 6932
Most Online Today: 134
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 53
Total: 54

Author Topic: Gallery Pro extremely slow to load  (Read 1288 times)

0 Members and 1 Guest are viewing this topic.

Offline lovetohax

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #30 on: March 05, 2018, 06:11:54 pm »
Just converted the table to InnoDB, and the performance difference is within the margin of error.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14712
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #31 on: March 05, 2018, 08:57:18 pm »
I am busy tomorrow but hopefully should have some time later this week.
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 lovetohax

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #32 on: March 06, 2018, 12:15:15 am »
Thanks for all the help!

Offline lovetohax

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #33 on: March 06, 2018, 03:34:48 pm »
Hey, I just did some testing, and it seems the super long searches are only when EXIF search is activated.

Offline lovetohax

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #34 on: March 11, 2018, 08:40:15 pm »
I just did some diagnostics, and there is a huge issue with temporary tables.

I've increased memory limits way higher, and it's still not enough to combat the huge amount of swap that is happening in order to accommodate the huge temporary tables being created. It's resulting in disk I/O being hammered, which leads to the DB timing out.

It seems that certain searches are using join statements that are not indexed, which is resulting in these massive temporary tables.

I have not done much SQL, so I was wondering if the query or the indexes would have to be modified?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 14712
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #35 on: March 11, 2018, 09:42:19 pm »
It's something with the joins not sure if it is mariadb issue it doesn't seem like it is seeing the indexes.
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 TeraS

  • Newbie
  • *
  • Posts: 39
    • View Profile
Re: Gallery Pro extremely slow to load
« Reply #36 on: March 11, 2018, 11:03:55 pm »
It's not likely a MariaDB issue as we were having this problem with mySQL as well.

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
4207 Views
Last post March 31, 2007, 01:37:52 pm
by SMFHacks
5 Replies
6200 Views
Last post June 24, 2007, 02:09:53 pm
by wkheathjr
2 Replies
7734 Views
Last post April 06, 2013, 01:07:17 pm
by SMFHacks
2 Replies
2940 Views
Last post August 06, 2016, 01:33:58 am
by shuban
10 Replies
443 Views
Last post August 02, 2018, 10:07:47 pm
by shuban

+- Recent Topics

GDPR Helper free doubts by Rock Lee
December 08, 2018, 06:20:57 pm

condition de livraison by alain54100
December 06, 2018, 12:33:38 pm

Downloads Pro 5.0 Released by SMFHacks
December 05, 2018, 03:11:32 pm

SMF Hacks Black Friday Sale! by SMFHacks
November 30, 2018, 09:03:04 am

Rewrite rule for IPN by diegolyanky
November 26, 2018, 10:58:55 am

EDITOR PRO by SMFHacks
November 25, 2018, 03:12:19 pm

SMF Gallery Pro 8.0 / PHP 7.0 onwards by SMFHacks
November 25, 2018, 12:33:10 pm

5.0 beta log errors by tfs
November 24, 2018, 10:37:06 pm

Download button doesn't initiate a download the first time by SMFHacks
November 24, 2018, 09:08:55 pm

Turn off Latest Posts? by tfs
November 23, 2018, 09:08:49 pm

Powered by EzPortal