I happened across this article on BSDHound.com about setting up MySQL. While the author does a reasonable job handling the security aspects of MySQL, he makes two mistakes that I think need to be corrected.
He:
- Suggests that people use MySQL 3.23. While that's a stable and mature version, I suspect that most folks are best served by using 4.0.xx instead. There are many improvements in the 4.0.xx series and many bugs fixed as well.
- He doesn't tell readers about building it with LinuxThreads support and the advantages of doing so.
I'm really surprised at home many FreeBSD/MySQL folks still don't use LinuxThreads. Someday we should be getting official MySQL binaries with LT support from MySQL.com too. I need to bug Lenz about that again...
Posted by jzawodn at November 30, 2003 10:44 PM
Well, "bad" and "mysql (advice)" are synonymous with one another.
I see he's already changed the article in response to this!
But surely building MySQL with LinuxThreads support will only give an advantage for a multi-CPU machine?
Is it possible that the http://bsdhound.com/newsread.php?newsid=90 article was an old one?