Timeline for What happens when I reach the last id with MySQL InnoDB?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 10, 2016 at 22:00 | history | edited | Michael Green | CC BY-SA 3.0 |
Tidied wording.
|
| Jul 10, 2016 at 19:24 | answer | added | Rick James | timeline score: 2 | |
| Jul 4, 2016 at 20:49 | comment | added | fiprojects | @jkavalik I love your idea for its simplicity and will give it a try. Thanks! | |
| Jul 4, 2016 at 19:28 | comment | added | Bill Croft | Once you exhaust your ID space your inserts will stop. This can be a hassle to track down if you don't consider it early in your troubleshooting. We have thousands of databases across a lot of servers so we run a script periodically that identifies auto inc columns via the information schema and then checks the max IDs | |
| Jul 4, 2016 at 18:57 | answer | added | iamwhargoul | timeline score: 1 | |
| Jul 4, 2016 at 17:58 | comment | added | jkavalik | Create a table with tinyint autoincrement column and start inserting rows. Tinyint is small enough to fill by hand so you can get the hard answer yourself. Then for your table just use unsigned bigint, filling that would take thousands of years | |
| Jul 4, 2016 at 17:50 | history | asked | fiprojects | CC BY-SA 3.0 |