Same for me : 1-5 minutes to get the "All software Page" and newt 10 items.... (no io wait, no swapping...)
Another tip mysql were using all available CPU, because there were huge number of locks on software table, due to high number of select on software table => I decreased the load to null by adding an index covering(HARDWARE_ID,NAME_ID,VERSION_ID);
23k machines, 83k softwares
- php 7.2.24, Apache/2.4.29 (Ubuntu),Ubuntu 18.04 version 10.1.43-MariaDB-0ubuntu0.18.04.1
- OCSReports 2.8
- Linux x86_64 4.15.0-76-generic, 16384 MB, Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz
- Ubuntu 18.04.4 LTS
EDIT : no improvment for my part : still 145s to exquete the sql query with ramdisk (no surprise because most of the IO were in memory cache.