title: What to do if the auto-increment value reaches its limit?
body: <p>I am doing a little research for a problem that might occur someday. 
  Lets say you have an InnoDB MySQL table with an id and a name field. the id field has BIGINT(20) and is AUTO_INCREMENT plus its the primary key. </p>
  
  <p>What do you do in a case that this table is full which means we have reached the limit on the id and  no auto increment number can be generated anymore. </p>