MySQL


MySQL is the most popular and used open-source relational database management system. MySQL is an important part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python), a widely used open source web application software package.

Advantages

  • Open Source
  • Cross-platform
  • Very good performance
  • Manages memory very well and ocupies low disk space
  • Many tutorials on the internet
  • Multiple GUI tools to choose from
  • Can be installed from source code, allowing extra customization

Disadvantages

  • MySQL doesn't provide good debugging tools
  • Doesn't ship with a GUI tool

Features 

  • Multilayered design with independent modules
  • Fully multi-threaded using Kernel Threads
  • Provides Transactional and Non-transactional storage engines

GUI Tools

  • MySQL Workbench
  • phpMyAdmin
  • HeidiSQL
  • Navicat

Versions

  • MySQL 3.23
  • MySQL 4.0
  • MySQL 4.1
  • MySQL 5.0
  • MySQL 5.1
  • MySQL 5.5
  • MySQL 5.6
  • MySQL 5.7