MySQL Resources

MySQL is a free, open-source relational database that has been used in thousands of websites, large and small. This is a contributed collection of resource links on MySQL. Feel free to add your favorites.

• Mike Franks – SSC
  • Collection of Mysql links and articles http://www.sscnet.ucla.edu/mysql/
  • Notes while learning Mysql http://www.sscnet.ucla.edu/mysql/notes.htm
  • Article on GRANTing access http://www.devshed.com/Server_Side/MySQL/Access/print_html
  • Article I don’t understand on storing hierarchical data in a relational database. //would this work with Mysql?\\ http://www.oreillynet.com/pub/a/network/2002/11/27/bioconf.html
  • Quick Tips to Optimize MySQL
  • 8 Reasons Not to Use MySQL
  • 5 Reasons To Use MySQL
• Ian Roessle November 9, 2002 at 13:23:
  • phpMyAdmin is a very useful tool for managing Mysql databases from the web. And this article tells how to Turn on phpMyAdmin’s hidden features
• Client-side database tools
  • Aqua Data Studio is a database query and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures. My favorite features: auto-completing SQL editor, and Excel-like editing of SELECT resultsets – the software generates automatically the appropriate UPDATE commands. Written in Java and supported on Windows, OS X, Solaris and Linux. Comes with JDBC drivers for MySQL, MS SQL Server 7/2000, Oracle 8/9/10, PostgreSQL and Sybase, and you can add drivers for other DBs. Runs fast. Free for educational use.
  • DBDesigner4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. I use it to visually layout and plan my database schemas. Free. Only on Windows and Linux
  • Point-and-Click MySQL Adminstration – Linux Magazine – Feb. 1, 2007
  • The MySQL Query Browser – Linux Magazine April 19, 2007
• Server-side Admin
  • Performance Tuning Best Practices for MySQL – Google Tech Talks – 43 min – Apr 28, 2006 Recommended by Harry Mangalam, UCI on UC-CSC Mailing List “This is a bit dated, but since so many web services use MySQL, this may still be useful.. It’s 43 min long, but the guy has a lot of useful hints and if you let it run in the background, you’ll pick up some things that will help, especially if you’re confused about the diffs between myisam and innodb tables and how to tune each.”
  • Quick and Dirty MySQL Performance Troubleshooting – Jeremy Zawodny, Monday, August 17th, 2009 Linux Magazine
• General documentation and training
  • MySQL University provides free download of talks on various topics.
  • Be productive with the MySQL Command Line
  • Fun with the MySQL pager command

This article was originally posted on the UCLA Programmers Wiki.