Messages

1

FA Obsession Collection / Re: [THE CREATURE STIRS] or "A rare FA code update"

« on: December 10, 2013, 05:23:01 pm »

It sounds like they have some script that breaks apart the notification load into parts. If I had to guess, whatever they are using is skipping over some data causing their database cache to keep growing.

That the ibdata file is growing indicates database updates are being written to the InnoDB transaction log but the disks don't have enough IOPS to commit the transactions to the database. The new notification queueing shouldn't have increased the load more than the previous notification method. Since the database response time has been getting progressively higher after the upgrade, I suspect it's now reached a point where the disks can no longer keep up.

Curious that the new database server has rotating disks instead of SSDs...