Announcement

  •  » Engine
  •  » Performance issue - excessive mysqld usage.

#16 2021-05-07 22:44:47

deemon
Member
2021-05-03
14

Re: Performance issue - excessive mysqld usage.

erAck wrote:

Sounds being related to the "related albums" feature problem [Forum, topic 31187] 11.x, related albums and performance issues.

Maybe, maybe not. As we don't use actually tags at all. When you remove the category, it seems to handle the entire database as one big album or something? (via creating those left and right arrows to move to next and previous images between every image in this huge site)

...or then again... related as all the other pictures in the site that have no tags? Maybe :D

edit: yeah it actually might be:
when I edited my my.cnf file to have under mysqld section:
# to limit max query time to 5 seconds in MariaDB
max_statement_time = 5

and tried to reload the same url, I got error

Code:

Warning:  [mysql error 1969] Query execution was interrupted (max_statement_time exceeded)

SELECT
    c.id,
    c.uppercats,
    count(*) AS counter
  FROM image_category
    INNER JOIN categories c ON category_id = id
  WHERE image_id IN (413509,400218,400219,400217,400220,400221,438118,413945,413510,415044,398727,438120,438121,473734,473735,473736,473737,473738,473739,473740,473741,473742,473743,473744,473745,473746,473713,473714,473721,473722,473723,473724,473725,473726,473727,473728,473729,473715,473730,473731,473732,473733,473716,473717,473718,473719,473720,413188,413946,413473,415045,398728,413189,413474,413947,415046,398729,413190,473192,413475,413948,415048,398730,413191,413476,413949,415049,398731,413192,472275,413477,413950,415050,398732,413193,413478,413951,415051,398733,413194,413952,413479,415052,398734,472277,413195,413480,413953,415053,398735,413196,472270,444134,444143,447741,451869,455573,462159,464697,469088,477462,261388,273000,286508,290488,400575,417692,426809,431728,438432,443374,450238,451041,45 in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php on line 864

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php:228
Stack trace:
#0 /var/www/html/galerii/include/functions_category.inc.php(711): pwg_db_fetch_assoc(false)
#1 /var/www/html/galerii/include/functions_category.inc.php(723): get_common_categories(Array, NULL, Array)
#2 /var/www/html/galerii/include/menubar.inc.php(123): get_related_categories_menu(Array, Array)
#3 /var/www/html/galerii/include/menubar.inc.php(15): initialize_menu()
#4 /var/www/html/galerii/picture.php(1025): include('/var/www/html/g...')
#5 {main}
  thrown in /var/www/html/galerii/include/dblayer/functions_mysqli.inc.php on line 228

While on the subject... of displaying errors to web visitors? Piwigo, really?

I mean like I have in global php.ini display_errors = Off and yet somehow in Piwigo they are visible?? Where and why does Piwigo turn this ON?

Last edited by deemon (2021-05-07 23:34:07)

Offline

 
  •  » Engine
  •  » Performance issue - excessive mysqld usage.

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2021 · Contact