Hi!
Thank you very much, that works now.
Okay, I found the issue, but I could only add a bypass solution. When the index table page is loaded, the plugin runs a “count” query to get only the size of the index and the posts table. However, for some reason that query either fails, or loops or simpyl takes a very long time. I tried different variations, even forced to use indexes, but it did not help whatsoever.
For now, I simply added a bypass to those functions to simply return “100000000” as the table size, and not to run the query. Aside from that report it should work just fine.
You can try running a table analyze and table optimize queries to make sure that the table is not fragmented, that would explain the problem perfectly: https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
Apparently counting the table rows can be problematic for some MySQL tables, but unfortunately due to access limitations there is no other way to do that at the moment via WordPress.