Live briefing

Everything about MySQL

SQL database engine software

MySQL is a free and open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius' daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups. Wikipedia →

🧭 Start here: a 6-step reading path

Read the overview: MySQLA 5-minute orientation
Skim a recent paper: A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data ManagementInfluential work since 2022
Pick up a classic book: SQL in a NutshellThe most-reprinted book on the subject
Read the landmark paper: GEOMAGIA50: An archeointensity database with PHP and MySQLCited 103 times
Go sideways: MariaDBA closely related topic
Go sideways: Comparison of relational database management systemsA closely related topic

📖 Definitions

No dictionary entry for this exact phrase.

🗂️ The subject at a glance

🏆 Landmark papers (most cited)

GEOMAGIA50: An archeointensity database with PHP and MySQL

K. Korhonen, F. Donadini, P. Riisager · 2008 · Geochemistry, Geophysics, Geosystems · 103 citations
Performance Evaluation of IoT Data Management Using MongoDB Versus MySQL Databases in Different Cloud Environments

Mahmoud Moustafa Eyada, Walaa Saber, Mohammed M. El Genidy · 2020 · IEEE Access · 70 citations
The Comparison Firebase Realtime Database and MySQL Database Performance using Wilcoxon Signed-Rank Test

Margaretha Ohyver, Jurike V. Moniaga, Iwa Sungkawa · 2019 · Procedia Computer Science · 69 citations
PALEOMAGIA: A PHP/MYSQL database of the Precambrian paleomagnetic data

Toni Veikkolainen, Lauri J. Pesonen, David A. D. Evans · 2014 · Studia Geophysica et Geodaetica · 45 citations
Performance analysis of NoSQL and relational databases with MongoDB and MySQL

Benymol Jose, Sajimon Abraham · 2020 · Materials Today: Proceedings · 44 citations
A Performance Benchmark for the PostgreSQL and MySQL Databases

Sanket Vilas Salunke, Abdelkader Ouda · 2024 · Future Internet · 41 citations
Performance Analysis of NoSQL and Relational Databases with CouchDB and MySQL for Application’s Data Storage

Cornelia A. Győrödi, Diana V. Dumşe-Burescu, Doina R. Zmaranda · 2020 · Applied Sciences · 37 citations
Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases

Cornelia A. Győrödi, Diana V. Dumşe-Burescu, Robert Ş. Győrödi · 2021 · Applied Sciences · 30 citations

🆕 Influential since 2022

A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management

Cornelia A. Győrödi, Diana V. Dumşe-Burescu, Doina R. Zmaranda · 2022 · Big Data and Cognitive Computing · 28 citations
Optimization of MySQL database

Ivan Šušter, Tamara Ranisavljević · 2023 · Journal of Process Management and New Technologies · 17 citations
Query Optimization In MySQL Database Using Index

Siti Maesaroh, Heru Gunawan, Agung Lestari · 2022 · International Journal of Cyber and IT Service Management · 15 citations
Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Marcin Choina, Maria Skublewska-Paszkowska · 2022 · Journal of Computer Sciences Institute · 14 citations
Design and implementation of a new intelligent warehouse management system based on MySQL database technology

Ying Zhang, Feng Pan · 2022 · Informatica · 14 citations

📚 Books worth reading

SQL in a NutshellKevin E. Kline, Kevin Kline · 2000
High Performance MySQLJeremy D. Zawodny, Derek J. Balling · 2004
Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
Learning PHP and MySQLMichele E. Davis, Jon A. Phillips · 2006
Murach's PHP and MySQLJoel Murach, Joel Murach · 2010
📕PHP and MySQL Web developmentLuke Welling · 2001
PHP and MySQL 24-Hour TrainerAndrea Tarr · 2011
Murach's MySQLJoel Murach · 2012

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

MariaDB MariaDB is a open-source relational database management system (RDBMS) sharing a common heritage with MySQL, from which it was forked in 2009 by original…
Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
Outline of MySQL The following outline is provided as an overview of and topical guide to MySQL: MySQL ("My Structured Query Language") – world's second most widely used…
Aria (storage engine) Aria is a storage engine for the MariaDB and MySQL relational database management systems. Its goal is to make a crash-safe alternative to MyISAM. It is…
MyRocks MyRocks is open-source software developed at Facebook in order to use MySQL features with RocksDB implementations. It is based on Oracle MySQL 5.6. Starting…
Percona Server for MySQL Percona Server for MySQL is a distribution of the MySQL relational database management system created by Percona. It is similar to MySQL Enterprise from…
Michael Widenius Ulf Michael Widenius (born 3 March 1962), also known as Monty, is a Finnish software programmer. He is the main author of the original version of the open…
InnoDB InnoDB is a storage engine for the database management system MySQL and MariaDB. Since the release of MySQL 5.5.5 in 2010, it replaced MyISAM as MySQL's…