Just a quick MySQL optimization note. Many times we're required to clear a database table and reset the auto increment counter. This is common with…