InnoDB and MySQL with Gallery2?

gossamer

Joined: 2011-01-07
Posts: 47
Posted: Fri, 2011-01-14 01:49

Hi,

I have very little experience with MySQL, but the database seems kind of slow, with a few hundred pictures in my gallery. I've just installed MySQL on Fedora 14 for use with this gallery installation.

I recall reading something about configuring MySQL for InnoDB instead of whatever the default is. Can someone guide me to information on if I should be making any performance improvements for G2 with MySQL?

Thanks,
Alex
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2011-01-14 02:03

You can convert to InnoDB via Gallery Admin -> Maintenance it is faster.
Also remove any modules you don't need, not just uninstall, remove the directories.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
gossamer

Joined: 2011-01-07
Posts: 47
Posted: Fri, 2011-01-14 15:30
suprsidr wrote:
You can convert to InnoDB via Gallery Admin -> Maintenance it is faster.
Also remove any modules you don't need, not just uninstall, remove the directories.

Thanks for the info. Is that just the "Optimize" option?

Thanks,
Alex
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2011-01-14 15:41

Sorry, there is a task to convert to UTF8, the InnoDB option must be during install. My mistake.

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Fri, 2011-01-14 17:56

And honestly, if you're seeing performance issues with just a few 100 items uploaded, you need to take a look at your mysql and probably apache configs.

I have a low memory VPS and have 1000s of images and albums spread across 2 G2 installs and 2 G3 installs on several domains all pointing to the same db server (localhost) so I have apache, mysql and php all running on the same limited hardware and the system flies super fast.
____________________________________________
Like Gallery? Like the support? Donate now!
 
gossamer

Joined: 2011-01-07
Posts: 47
Posted: Wed, 2011-01-19 22:24
nivekiam wrote:
And honestly, if you're seeing performance issues with just a few 100 items uploaded, you need to take a look at your mysql and probably apache configs.

Could it be due to not having chosen the InnoDB option at the time of creation of the database, perhaps?

I also can't say it's exceedingly slow, but it seems like the initial time before the first image is shown it's a little slow. I've posted my virtualhost config in another post. Perhaps it's related to that? I don't have DNS queries enabled, and the system is otherwise idle.

Thanks again,
Alex