Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 12188
Latest: thereisaway
New This Month: 10
New This Week: 0
New Today: 0
Stats
Total Posts: 39137
Total Topics: 6892
Most Online Today: 47
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 50
Total: 51

Author Topic: Gallery Pro extremely slow to load  (Read 1038 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: 14594
    • 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: 14594
    • 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: 38
    • 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
4164 Views
Last post March 31, 2007, 01:37:52 pm
by SMFHacks
5 Replies
6154 Views
Last post June 24, 2007, 02:09:53 pm
by wkheathjr
2 Replies
7692 Views
Last post April 06, 2013, 01:07:17 pm
by SMFHacks
2 Replies
2767 Views
Last post August 06, 2016, 01:33:58 am
by shuban
10 Replies
314 Views
Last post August 02, 2018, 10:07:47 pm
by shuban

+- Recent Topics

Error in log with Export Data by Rivilis
Today at 10:23:55 am

More regular expression match for search by Michel68
September 23, 2018, 02:42:08 pm

SMFBlog problem by SMFHacks
September 21, 2018, 08:10:59 pm

GDPR Pro 2.0 Released for SMF by SMFHacks
September 21, 2018, 02:17:11 pm

[Mod]Dynamic Memberlist by SMFHacks
September 17, 2018, 05:00:59 pm

Pretty URL caches Url Permanently by SMFHacks
September 17, 2018, 11:57:44 am

[Mod]Guest Post No Email Field by SMFHacks
September 13, 2018, 10:41:07 pm

Can I redirect Pretty URL topics to another? by SMFHacks
September 13, 2018, 04:39:54 pm

Aeva Conversion - How to? by SMFHacks
September 12, 2018, 12:12:02 pm

Hide categories by language. 2. Multi lingual title by SMFHacks
September 12, 2018, 12:15:13 am

Powered by EzPortal