The Future of Performance: Scaling

[Bradley Baetz]

On Wed, Dec 31, 2008 at 5:20 PM, Max Kanat-Alexander
<mkanat at bugzilla.org> wrote:
> On Tue, 30 Dec 2008 22:16:20 -0600 "Bradley Baetz" <bbaetz at acm.org>
>        Yeah, on most installations I don't think it's an issue, but at
> places like bmo it could always be handy to see what else we can push
> off. Apparently the ratio of master reads to slave reads increased a
> lot in 3.2 for some reason, and we should probably look into it.

What we are missing is good db profiling for issues like this. I'm not
sure what the best way to do that is - does mysql have the ability to
log all queries to a db table? Or, even better, DBI (so that we can
consider all placeholders to be the same)?

Bradley