I like to use M-x sql-mysql to interact with mysql in emacs, but I constantly (and seemingly somewhat sporadically) run into situations where for some reason emacs stops using the full height of a buffer (meaning I'll have some long output, and then the mysql> prompt will be halfway up the buffer, which is frustrating.
Also, I end up having to M-> on almost every query I want to enter once the above has happened, as the cursor will stop being aligned to the end of the mysql> prompt, and be sitting on the m, or below the prompt, or in the middle of the results for the query.
It seems to happen most often when I switch the buffer ... pane (argh, I forgot the terminology) that sqli-mode is in, or when I resize said pane. Like it's grabbing dimensions on start, and not updating them.
Has anyone run into this before and found a solution? I haven't seen anything on emacswiki...