Piwigo.org

evheniys · 2012-02-28 23:36:00

Hello,

I have Piwigo 2.3.0 installed on Ubuntu 11.10 (Nginx+PHP-fpm+MySQL).
The hardware of My PC is:
CPU - P4 with HT (3.0 GHz)
RAM - 2,5Gb

Today I have more then 470000 photos in the gallery, and I have the trouble with CPU utilization when I open pages, different from "home page" or "category page".
When I try to open "Recent pictures" or make some search in the gallery - the usage of CPU become to 100%

How I can fix this trouble?

plg · 2012-02-29 00:45:24

Hi evheniys,

Can you activate plugin LocalFiles Editor and then in [Administration > Plugins > LocalFiles Editor] add:

Code:

<?php
$conf['show_gt'] = true;
?>

Then go back to the gallery and tell us what Piwigo says in the footer : page generated in ... seconds...

evheniys · 2012-02-29 07:10:41

Hello, plg

On the "Home page" - generated in 32,562 s (35 SQL queries in 32,197 s)
On the "Recent pictures" - generated in 40,976 s (22 SQL queries in 32,929 s)
On the "Most visited" - generated in 39,439 s (22 SQL queries in 32,169 s)
On the "Images with tag" - generated in 33,183 s (23 SQL queries in 33,108 s)

It's too slow :(

Piwigo.org

Announcement

#1 2012-02-28 23:36:00

MySQL overload

#2 2012-02-29 00:45:24

Re: MySQL overload

Code:

#3 2012-02-29 07:10:41

Re: MySQL overload

Board footer