So, O’Reilly’s ONLamp.com has published the “Top 10 MySQL Best
Practices” at http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html.
Sadly, I find most “best practice” list do not thoroughly explain
the “why” enough so that people can make their own
For instance, #3 is “Protect the MySQL installation directory from access by other users.” I was intrigued at what they would consider the “installation” directory. By reading the tip, they actually mean the data directory. They say nothing of the log directory, nor that innodb …