I agree that it's not simple to deal with long run...

# server

[andrewoma]

I agree that it's not simple to deal with long running queries. In some systems I've worked on we've pushed reporting style queries onto slaves, keeping them off of master completely.