Comments | jamesd: Want to work for M y S Q L as a support engineer?

jamesd

Want to work for M y S Q L as a support engineer?

Sep 16, 2005 01:41

If you've worked with production systems and know M y S Q L well, the support group is hiring new support engineers. Customers include just about any company with a major net presence. Locations are US and Asia-Pacific, working from home anywhere within those time zones. Really capable people who have lived with major production setups are ( Read more... )

Comments 2

matthew September 16 2005, 04:13:33 UTC

does it have to do with the innologs cycling?

jamesd November 1 2005, 01:44:20 UTC

This looked as though it was the Innologs cycling and the times appeared to match. To confirm, I modified InnoDB to write one page per second to the disks, even under load, and also changed the log size. Both of those should have made a difference to the pattern but neither did.

It turned out to be an artifact of the test queries being used. Two sets of queries, one a relatively short duration batch run periodically which was replacing the pages in the InnoDB buffers which the other set needed. Insert buffer merging after the batch and the comparatively cold (wrong) cache for the main set of queries explained it.