RSS xf_thread_read auto_increment out of range

[mattrogowski]

If you set up a MySQL cluster for replication, the auto_increment values generated by MySQL will go up by more than 1 at a time (see auto_increment_increment) - the default (we've been told) is to increment them by 10. This means you use up IDs 10x quicker (so you'd run out of IDs at 420 million rows, not 4.2 billion).

If you have a particularly a) large, b) active, and c) long running forum, combined with the auto_increment values going up by 10 instead of 1, you will...

Read more

Continue reading...

 

X

RSS  [ICODE=rich] does not round-trip after editing a post as expected.

S

RSS  Do you want to replace existing images?