So, mighty lazyweb, what is the best way to change the id column on this 96 GB table from INT to BIGINT? Using Percona 5.6.36-82pic.twitter.com/56NiVcy6OC
You can add location information to your Tweets, such as your city or precise location, from the web and via third-party applications. You always have the option to delete your Tweet location history. Learn more
Yeah, if you're out of primary key space, it's not like you need to worry about table changes while you alter things, so you can work on a copy and not worry about ruining the original... foreign keys might(?) trip you up if you're using those.
+1 for PT tools. They're reliable. Not too smart about load, so if you're close to the wire / can't accept latency increases you might want to hack it apart and improve that bit, but as long as there's decent headroom they're fine.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.