Hello all! I have a MySQL query that is giving me the results that I want, but I'm having difficulty displaying the results in PHP. Here is my SQL statement: SELECT `tkid`,COUNT(*) FROM ...

After upgrading mysql from 5.7 to 8.0.20 a count(*) or count(id) of an indexed table with 100.000 rows (without where) takes > 5 seconds. (~0.00 seconds with 5.7) count(*) is at least used for list ...