Process ID max limit and what happens after

All we need is an easy explanation of the problem, so here it is.

Process ID is bigint in information schema.
What happens when limit is reached?
Do I need to restart MySQL to 0 it out again?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

The manual says:

When the column reaches the upper limit of the data type, the next attempt to generate a sequence number fails.

Found this: What to do if the auto-increment value reaches its limit?

So either update the table column for a larger type, or handle the error and the consequences of having the reset of the key values.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply