My php-fpm is set to log slow request for 5 seconds or more, I am repeatedly seeing this in my php fpm slow log, could you help me to understand it and how to fix it ?

[xvids]

[25-Aug-2023 20:03:39]  [pool mykvs.web.com] pid 3285984
script_filename = /home/path/to/my/web/public_html/view_album.php
[0x00007fc19da14ea0] query() /home/path/to/my/web/public_html/admin/include/functions_base.php:385
[0x00007fc19da14db0] sql() /home/path/to/my/web/public_html/blocks/list_albums/list_albums.php:2663
[0x00007fc19da14250] list_albumsShow() /home/path/to/my/web/public_html/admin/include/process_page.php:1904
[0x00007fc19da13e00] insert_getBlock() /home/path/to/my/web/public_html/admin/smarty/internals/core.run_insert_handler.php:51
[0x00007fc19da13ce0] smarty_core_run_insert_handler() /home/path/to/my/web/public_html/admin/smarty/template-c-site/%%F7^F79^F791CE7A%%view_album.tpl.php:34

[25-Aug-2023 20:03:41]  [pool mykvs.web.com] pid 3284790
script_filename = /home/path/to/my/web/public_html/view_album.php
[0x00007fc19da14ea0] query() /home/path/to/my/web/public_html/admin/include/functions_base.php:385
[0x00007fc19da14db0] sql() /home/path/to/my/web/public_html/blocks/list_albums/list_albums.php:2663
[0x00007fc19da14250] list_albumsShow() /home/path/to/my/web/public_html/admin/include/process_page.php:1904
[0x00007fc19da13e00] insert_getBlock() /home/path/to/my/web/public_html/admin/smarty/internals/core.run_insert_handler.php:51
[0x00007fc19da13ce0] smarty_core_run_insert_handler() /home/path/to/my/web/public_html/admin/smarty/template-c-site/%%F7^F79^F791CE7A%%view_album.tpl.php:34

[25-Aug-2023 20:03:43]  [pool mykvs.web.com] pid 3282075
script_filename = /home/path/to/my/web/public_html/view_album.php
[0x00007fc19da14ea0] query() /home/path/to/my/web/public_html/admin/include/functions_base.php:385
[0x00007fc19da14db0] sql() /home/path/to/my/web/public_html/blocks/list_albums/list_albums.php:2663
[0x00007fc19da14250] list_albumsShow() /home/path/to/my/web/public_html/admin/include/process_page.php:1904
[0x00007fc19da13e00] insert_getBlock() /home/path/to/my/web/public_html/admin/smarty/internals/core.run_insert_handler.php:51
[0x00007fc19da13ce0] smarty_core_run_insert_handler() /home/path/to/my/web/public_html/admin/smarty/template-c-site/%%F7^F79^F791CE7A%%view_album.tpl.php:34

 

I am repeatedly seeing this in my php fpm slow log, could you help me to understand it and how to fix it ?

[Tech Support]

This is because some SQL that selects albums list works longer than 5 seconds. This depends on which SQL is running there, you can check that in MySQL slow query logs.