I'm trying to improve an integrated ad server on my site, problem is I have some 10 tables which need their ad impression counters updated. Those tables are constantly being read by the website users (ads, bids, units, sites...), and the remote ad processor is constantly writing to those tables resulting in wait times for the users using the interface.
Innodb. I'm pretty much having a hard time separating the "hammer" (remote site hits) from the interface. If on one side writing the statistics in real time seems not wise, not doing it also raises other problems like having to write them all at once when batch events occur.