PHP/MySQL database connection priority?

Posted by Josh on Stack Overflow See other posts from Stack Overflow or by Josh
Published on 2010-03-25T20:05:33Z Indexed on 2010/03/25 20:13 UTC
Read the original article Hit count: 499

Filed under:
|
|

Hello,

I have a production database where usage statistics for a service we're working on. I use php to periodically roll up different resolutions (day, week, month, year) of interesting statistics in buckets dictated by the resolution.

The php application I've written "completes" its data when its run, such that it will calculate all the rolled-up statistics for the resolutions and periods since it was last run. This is useful if we want to turn this off to debug database performance issues, because I can turn it back on and have it complete its data set.

The problem I have, is the calculations are fairly intensive and drive the QPS of the production database server up. Is there a way to set a "priority" on a particular database connection so that it will only use "off-cycles" to do these calculations?

Maybe a proper response would be to replicate the tables I'm working on into a different stats database, but, unfortunately I don't have the resources in place to attempt such a thing (yet).

Thanks in advance for any help, Josh

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql