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: 43259
Total Topics: 7518
Most Online Today: 201
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 231
Total: 231

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

0 Members and 1 Guest are viewing this topic.

Offline lovetohax

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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

  • Member
  • *
  • 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

  • Member
  • *
  • 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: 16436
    • 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

  • Member
  • *
  • 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
6815 Views
Last post March 31, 2007, 01:37:52 pm
by SMFHacks
5 Replies
7711 Views
Last post June 24, 2007, 02:09:53 pm
by wkheathjr
9 Replies
7818 Views
Last post November 18, 2009, 08:45:31 am
by RollingRock
10 Replies
3946 Views
Last post August 02, 2018, 10:07:47 pm
by shuban
4 Replies
7132 Views
Last post August 08, 2023, 05:31:29 pm
by tank_fv101

+- Recent Topics

No thumbnails on new uploads by SMFHacks
March 27, 2024, 02:10:41 pm

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

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal