I usually compose queries in vi or some other text editor, and then execute them using a command line. This is mostly a personal preference, but on some production environments, GUIs can be dangerous so we explicitly don't allow GUI tools to connect to these databases.
The problem in these environments is it's too easy for these tools to issue relatively expensive metadata operations (such as MySQL SHOW TABLE STATUS) without the user knowing they're doing these operations.
One time, we got alerts that production was running slowly, and we looked at active queries, and saw that an opera...(more)Loading…