In my previous articles we learned how to perform CRUD operation using MySQLi Procedural and Object Oriented style. On performing CRUD operations, the data of MySQL table are affected. This article ...

A simple tool for anyone who might need to count MySQL database rows accurately and with a high degree of parallelism. Useful for counting rows in large databases and comparing the output.

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 ...