Comment

Also by using BIGINT all your secondary indexes are larger than they need to be. InnoDB stores the PK for each row in each of your secondary indexes, so by changing it to INT you could decrease your index size.