MySQL : an Overview

MySQL : an Overview
Written by Nilima PaulDecember 21, 2021
9 min read
MySQL
0 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWS SHARE
Nilima Paul

Data Team

What's up guys, about this article we know what is MySQL its features, and its advantages and disadvantages.

What is MySQL?

MySQL is an open-source relational database management system. As with other relational databases, MySQL stores data in tables made up of rows and columns. Users can define, manipulate, control, and query data using Structured Query Language, more commonly known as SQL. MySQL’s name is a combination of “My,” the name of MySQL creator Michael Widenius’s daughter, and “SQL”.

A flexible and powerful program, MySQL is the most popular open-source database system in the world. As part of the widely-used LAMP technology stack (which consists of a Linux-based operating system, the Apache web server, a MySQL database, and PHP for processing), it’s used to store and retrieve data in a wide variety of popular applications, websites, and services.

blogpost

Features

MySQL has been offered under two different editions: the open-source MySQL Community Server[77] and the proprietary Enterprise Server.[78] MySQL Enterprise Server is differentiated by a series of proprietary extensions which install as server plugins, but otherwise, share the version numbering system and are built from the same code base.

Major features as available in MySQL 5.6:

  • A broad subset of ANSI SQL 99, as well as extensions
  • Cross-platform support
  • Stored procedures, using a procedural language that closely adheres to SQL/PSM[79]
  • Triggers
  • Cursors
  • Updatable views
  • Online Data Definition Language (DDL) when using the InnoDB Storage Engine.
  • Information schema
  • Performance Schema that collects and aggregates statistics about server execution and query performance for monitoring purposes.[80]
  • A set of SQL Mode options to control runtime behavior, including a strict mode to better adhere to SQL standards.
  • X/Open XA distributed transaction processing (DTP) support; two-phase commit as part of this, using the default InnoDB storage engine
  • Transactions with savepoints when using the default InnoDB Storage Engine. The NDB Cluster Storage Engine also supports transactions.
  • ACID compliance when using InnoDB and NDB Cluster Storage Engines[81]
  • SSL support
  • Query caching
  • Sub-SELECTs (i.e. nested SELECTs)
  • Built-in replication support
  • Asynchronous replication: master-slave from one master to many slaves[82][83] or many masters to one slave[84]
  • Semi synchronous replication: Master to slave replication where the master waits on replication[85][86]
  • Synchronous replication: Multi-master replication is provided in MySQL Cluster.[87]
  • Virtual Synchronous: Self-managed groups of MySQL servers with multi-master support can be done using: Galera Cluster[88] or the built-in Group Replication plugin[89]
  • Full-text indexing and searching[b]
  • Embedded database library
  • Unicode support[a]
  • Partitioned tables with the pruning of partitions in the optimizer
  • Shared-nothing clustering through MySQL Cluster
  • Multiple storage engines, allowing one to choose the one that is most effective for each table in the application.[c]
  • Native storage engines InnoDB, MyISAM, Merge, Memory (heap), Federated, Archive, CSV, Blackhole, NDB Cluster.
  • Commit grouping, gathering multiple transactions from multiple connections together to increase the number of commits per second.

MySQL is easy to use

However MySQL's social nature and the following unbending stockpiling constructions may appear to be prohibitive, the plain worldview is maybe the most instinctive, and at last, takes into account more noteworthy convenience.

Indeed, MySQL makes numerous concessions to supporting the most extensive conceivable assortment of information structures, from the standard however rich coherent, numeric, alphanumeric, date, and time types, to further developed JSON or geospatial information. Past simple information types and far-reaching work in highlight set, the MySQL environment likewise incorporates an assortment of devices, facilitating everything from the server the executives to announcing and information investigation.

Notwithstanding the RDBMS's overall engineering, clients can constantly observe a MySQL highlight permitting them to display and classify information how they wish. MySQL stays quite possibly the most direct data set technology to learn and utilize.

MySQL Advantages And Disadvantages

Features of MySQL:

  • MySQL is a Relational Database Management System or RDBMS which means that it stores and presents data in tabular form, organized in rows and columns.
  • MySQL is more secure as it consists of a solid data security layer to protect sensitive data from intruders and passwords in MySQL are encrypted.
  • MySQL is available for free to download and use from the official site of MySQL.
  • MySQL is compatible with most of the operating systems, including Windows, Linux, NetWare, Novell, Solaris, and other variations of UNIX.
  • MySQL provides the facility to run the clients and the server on the same computer or different computers, via the internet or local network.
  • MySQL has a unique storage engine architecture which makes it faster, cheaper, and more reliable.
  • MySQL gives developers higher productivity by using views, Triggers, and Stored procedures
  • MySQL is simple and easy to use. You can build and interact with MySQL with only the basic knowledge of MySQL and a few simple SQL statements.
  • MySQL has a client-server architecture. There can be any number of clients or application programs that communicate with the database server (MySQL) to query data, save changes, etc.
  • MySQL is scalable and capable of handling more than 50 million rows. This is enough to handle almost any amount of data. Although the default file size limit is 4GB it can be increased to 8TB.
  • MySQL allows transactions to be rolled back.
  • MySQL is very flexible as it supports a large number of embedded applications.

Disadvantages of MySQL:

  • MySQL is not very efficient in handling very large databases.
  • MySQL doesn’t have as good a developing and debugging tool as compared to paid databases.
  • MySQL versions less than 5.0 do not support COMMIT, stored procedure and, ROLE.
  • MySQL is prone to data corruption as it is inefficient in handling transactions.
  • MySQL does not support SQL check constraints.
MySQL
MySQLoverview
sql
0 VIEWS 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWS SHARE
Was this blog helpful?
You must be Logged in to comment
Code Block
Nilima Paul
Data Team
117 Blog Posts
0 Discussion Threads
Trending Categories
15
Software39
DevOps45
Frontend Development24
Backend Development20
Server Administration17
Linux Administration24
Data Center24
Sentry24
Terraform21
Ansible29
Docker28
Penetration Testing14
Kubernetes16
NGINX19
JenkinsX17
Techiio

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

facebooklinkdeintwitter

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Copyright techiio.com @2020 Kolkata, India
made with by Abhishek & Priyanka Jalan
Copyright techiio.com @2020
made with by Abhishek & Priyanka Jalan