MySQL Tips and Tricks

by jeremyjones on March 16, 2011

  • Share
  • CevherShare
  • Share

The most popular open-source database engine in the world, MySQL is a powerful database engine that is known for its high performance, reliability and ease of use. Many large internet companies use MySQL to power their databases and applications based on the LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python).

MySQL is platform independent and runs on more than 20 operating system platforms including:

  • Windows
  • Linux
  • Mac OS
  • Solaris
  • HP-UX
  • IBM AIX

The comprehensive range of tools, support, training and consultancy offered for MySQL makes it a good choice for any enterprise environment.

Hopefully these MySQL tips will help you improve your skills and improve the performance and functionality of your databases.

  1. Time and Date Functions in MySQL
  2. MySQL Performance Optimization
  3. Automate MySQL Database Backups
  4. Use Benchmarking to Improve Performance
  5. Isolate Slow MySQL Processes
  6. Partition Tables
  7. Tighten up the schema
  8. Secure your Server
  9. Control remote access
  10. Remove Obsolete Privileges

Leave a Comment

Previous post:

Next post: