Put this somewhere in your ~/bin: watch ‘echo “show processlist” | mysql -u whateveruser –password=mypassword | grep -v “show processlist” ‘ Now run it and…
Every once in a while you will get a query that no matter what you try, it doesn’t use the indices. This is typically because…
In order to make queries run faster, you should try to have oracle explain to you how the query should be performed. The whole explanation…
This tip contains a couple of MySQL scripts that allow me to create and drop a database and a user that will “own” said database.