New answers tagged limits
No, at least not in this case. The evidence pointing towards a DELETE ... LIMIT 1 was real, but not entirely accurate. The real issue here was a PHP script that called hundreds of unnecessary queries in order to execute the suspected DELETE ... LIMIT 1 query. Using MySQL's log all queried on a test environment lead to the solution to this problem.
Initially, I looked into database benchmarks for this (I'm interested in realistic benchmarks), but found that neither the HammerDB nor Sysbench tools appear to handle multiple databases (i.e. schemas). I couldn't find any Google link despite searching for many combinations of "MySQL benchmark multiple schemas/databases". With respect to multi-tenancy, ...
Top 50 recent answers are included