Measuring database performance in MySQL

May 14, 2020 12:26 (Tiffany Taylor)
Hi internals!

I am currently working on an RFC draft to disable prepared statement
emulation for MySQL by default. I understand this has been discussed
previously[1][2], and one major concern is performance with reused
statements if prepared statement emulation is disabled because of the extra
round-trip. With MySQL 8.0, prepared statement reuse can be faster. My
question: does anyone know of any code for testing database performance in
PHP, that could be used to measure changes between older version of MySQL
and newer versions?

Thanks in advance,
Tiffany Taylor