Mysql is an open source relational database management system (RDBMS). MySQL is a central component of the LAMP open-source web application software stack (and other “AMP” stacks). LAMP is an acronym for “LinuxApache, MySQL, Perl/PHP/Python“. Applications that use the MySQL database include: TYPO3MODxJoomlaWordPressphpBBMyBB, and Drupal. MySQL is also used in many high-profile, large-scale websites, including Google[10][11] (though not for searches), Facebook,[12][13][14] Twitter,[15] Flickr,[16] and YouTube.

Here is an interesting Mysql tip to list the size of each database on the Mysql server.

How to list the total size of each database on the mysql server.

mysql> SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; +——————–+—————+ | DB Name

mysql> SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema;
+--------------------+---------------+
| DB Name            | DB Size in MB |
+--------------------+---------------+
| confluence         |          70.6 |
| drupal             |           7.2 |
| information_schema |           0.0 |
| jiradb             |           7.1 |
| mysql              |           0.6 |
| owncloud           |           0.1 |
+--------------------+---------------+
6 rows in set (0.17 sec)