I have a MySQL table with 4 columns. The 1st column record_id is of type int, primary key, and auto-incremented. Now that I have added more than 2 billion records to this table I am finding that I have exceeded the range of my auto-incremented field. I need to modify record_id to a “bigint” to accommodate more records. What would be the fastest way to do this?
Is there a way to do this in-situ without dumping the tables?