Announcement

#1 2018-08-10 09:07:34

kiwiyak
Member
2015-10-02
23

2,481,999 Photos , mysql always 800% CPU , need help ...

Hello/Hi/Greetings,

Piwigo Administration

2,481,999 Photos  7756 Albums

is that meaning piwigo cant hold that much photos ?

the mysql always 800% CPU , need help ...

need idea.

thanks all

Offline

 

#2 2018-08-10 11:28:53

teekay
Member
2013-06-12
385

Re: 2,481,999 Photos , mysql always 800% CPU , need help ...

Obviously it’s your MySQL server that can’t handle it. Needs way more horsepower...

Offline

 

#3 2018-08-10 11:43:21

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13159

Re: 2,481,999 Photos , mysql always 800% CPU , need help ...

Hi,

Activate Mysql Slow log and monitor the slow log in /var/log/mysql : we will see which MySQL queries are slow and we will tell you how to improve speed (by deactivating a plugin, or adding an index, for example)


Latest blog post (May 3rd 2018) New subscription form

Offline

 

#4 2018-08-11 02:17:18

kiwiyak
Member
2015-10-02
23

Re: 2,481,999 Photos , mysql always 800% CPU , need help ...

# User@Host: cgkiwigo[cgkiwigo] @ localhost []  Id:   493
# Query_time: 68.482646  Lock_time: 0.000047 Rows_sent: 0  Rows_examined: 2830964
SET timestamp=1533946952;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# User@Host: cgkiwigo[cgkiwigo] @ localhost []  Id:   488
# Query_time: 6.529592  Lock_time: 0.000083 Rows_sent: 1  Rows_examined: 1415482
SET timestamp=1533946952;
SELECT COUNT(DISTINCT(image_id)) as total
  FROM piwigo_image_category
  WHERE category_id NOT IN (0)
    AND image_id NOT IN (0);
# User@Host: cgkiwigo[cgkiwigo] @ localhost []  Id:   492
# Query_time: 68.824714  Lock_time: 0.000048 Rows_sent: 0  Rows_examined: 2830964
SET timestamp=1533946952;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;
# Time: 180810 17:22:33
# User@Host: cgkiwigo[cgkiwigo] @ localhost []  Id:   494
# Query_time: 68.708064  Lock_time: 0.000047 Rows_sent: 0  Rows_examined: 2830964
SET timestamp=1533946953;
SELECT DISTINCT(id)
  FROM piwigo_images INNER JOIN piwigo_image_category ON id=image_id
  WHERE category_id NOT IN (0)
    AND level>0;

Offline

 

#5 2018-08-11 08:25:32

kiwiyak
Member
2015-10-02
23

Re: 2,481,999 Photos , mysql always 800% CPU , need help ...

I'm sure it right now.

Every time, I going to /admin.php , and when I login , the mysql CPU going to up around 800%, then waiting 5 or 8 mins later, it's back to normally.

If I try to use admin.php again, it's will be happen again.

Unless, I setup the server offline , and ONLY me, 1 visitor to use admin.php, that's will be alright , no problem.

Even, that's 2 visitors, the mysql will use CPU 800%, cant do anything until dead then back normally.

I'm wondering, is any problem with admin.php

ALSO, sometimes was happend when I in the admin try to syrcn the directories ...

thanks master...

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2018 · Contact