Re: How to track page splits

[Peter Brawley]

Then nothing to do with "page splits".

If you're counting on auto_increment to provide monotonically incrementing values, forget it. Auto_increment doesn't, can't do that. If you need monotonic sequentiality, code it.

To prevent clients from arbitrarily setting auto_increment values, don't gove them raw acces to Insert and Update commands, eg write Before Insert Triggers that override user values on such columns by setting them Null.