-
Hello @gkuhnert !
Could you please share your Studio->Dashboard->Server Audit area? And please specify what caches did you enable?
-
The screenshot I shared was from your website... so 100% not just my site... But for sake of argument, see below. As per the screenshot, my bet is on the sheer number of sql aueries. It feels like it is inherrently doing a whole lot of stuff thats causing the poor performance.
For the record, GZ compression is on, and local cache options are 100% correct.
Host Tools Requirements PHP: version = 8.3.23 - OK allow_url_fopen = On - OK allow_url_include = Off - OK magic_quotes_gpc = Off - OK memory_limit = 128 MB - OK post_max_size = 64 MB - OK upload_max_filesize = 64 MB - OK register_globals = Off - OK safe_mode = Off - OK disable_functions = exec,system,passthru,proc_open,proc_nice,ini_restore - OK php module: curl = curl - OK php module: gd = gd - OK php module: mbstring = mbstring - OK php module: json = json - OK php module: fileinfo = fileinfo - OK php module: zip = zip - OK php module: openssl = openssl - OK php module: exif = exif - OK MySQL: version = 10.5.27 - OK Web-server: Apache rewrite_module - OK (mod_rewrite is active: request reached PHP (even if 404 status)) OS: Linux 5.14.0-503.16.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Dec 13 01:47:05 EST 2024 x86_64 Hardware: Hardware requirements can not be determined automatically - manual server audit may be required. Site setup UNA version = 14.0.0 - OK Files and folders permissions - please click here to find out if permissions are correct. ffmpeg - ffmpeg version 4.4-static ffmpeg-url Copyright (c) 2000-2021 the FFmpeg developers built with gcc 8 (Debian 8.3.0-6) configuration: --enable-gpl --enable-version3 --enable-static --disable-debug --disable-ffplay --disable-indev=sndio --disable-outdev=sndio --cc=gcc --enable-fontconfig --enable-frei0r --enable-gnutls --enable-gmp --enable-libgme --enable-gray --enable-libaom --enable-libfribidi --enable-libass --enable-libvmaf --enable-libfreetype --enable-libmp3lame --enable-libopencore-amrnb --enable-libopencore-amrwb --enable-libopenjpeg --enable-librubberband --enable-libsoxr --enable-libspeex --enable-libsrt --enable-libvorbis --enable-libopus --enable-libtheora --enable-libvidstab --enable-libvo-amrwbenc --enable-libvpx --enable-libwebp --enable-libx264 --enable-libx265 --enable-libxml2 --enable-libdav1d --enable-libxvid --enable-libzvbi --enable-libzimg libavutil 56. 70.100 / 56. 70.100 libavcodec 58.134.100 / 58.134.100 libavformat 58. 76.100 / 58. 76.100 libavdevice 58. 13.100 / 58. 13.100 libavfilter 7.110.100 / 7.110.100 libswscale 5. 9.100 / 5. 9.100 libswresample 3. 9.100 / 3. 9.100 libpostproc 55. 9.100 / 55. 9.100 Hyper fast Audio and Video encoder usage: ffmpeg [options] [[infile options] -i infile]... {[outfile options] outfile}... Use -h to get full help or, even better, run 'man ffmpeg' if you dont know if output is correct then manual server audit may be required. Mail sending - click here to send test email Cron jobs - no crontab for una if you are unsure if output is correct then manual server audit may be required Last cron jobs execution - 3 Aug 2025 9:56:01 pm Site optimization PHP: PHP accelerator = ZendOPcache - OK PHP setup = fpm-fcgi - OK MySQL: key_buffer_size = 128 MB - OK max_heap_table_size = 16 MB - OK tmp_table_size = 16 MB - OK thread_cache_size = 151 - OK Web-server: User-side caching for static content - click here to check it in Google Page Speed If it is not enabled then please consider implement this optimization, since it improve perceived site speed and save the bandwidth. To apply this optimization you need to have expires_module - OK (Detected Expires or Cache-Control header via HTTP on static asset) Server-side content compression - can be checked manually or in "Page Speed" tool build-in into browser. If it is not enabled then please consider implement this optimization, since it improve perceived site speed and save the bandwidth. To apply this optimization you need to have deflate_module - OK (Detected compression (gzip/deflate) via HTTP headers on static asset) UNA: DB cache = On (Memcached based cache engine) - OK Pages cache = On (Memcached based cache engine) - OK Page blocks cache = On (Memcached based cache engine) - OK Templates Cache = On (Memcached based cache engine) - OK CSS files cache = On - OK JS files cache = On - OK Compression for CSS/JS cache = On - OK Manual Server Audit Some things can not be determined automatically, manual server audit is required to check it. If you dont know how to do it by yourself you can submit Server Audit Request.
-
Thnx for the details. Well, from the provided server audit I may see that the memory_limit param's value is too low. It would be good to have the 512Mb at least.
-
Changed it, and it made exactly 0% improvement. I monitor server logs, and there were no pages getting tripped by the memory_limit value. As said before, the root cause appears to be the sheer volume of SQL queries (and associated data processing). Why do we need literally thousands of queries to render a page? Something inherrently wrong in that part of Una.
-