Introduction to MySQL Flashcards
Is an open-source relational database management system.
MySQL
Where does “My” & “SQL” came from?
“My” from the name of co-founder Michael Widenius’s daughter.
“SQL” is the abbreviation of Structured Query Language.
MySQL is written in what programming language?
C and C++
MySQL was created by which Swedish company?
MySQL AB
What is the star feature of MySQL?
On-demand flexibility
Provide connectivity to the MySQL server for client programs.
MySQL Connectors
Provide low-level access to MySQL resources using either the classic MySQL protocol or X Protocol.
APIs
Is a cache of database connections maintained so that the connections can be reused when future requests to the database are required.
MySQL Connection pool
Are used to enhance the performance of executing commands on a database.
Connection pool
Allows you to create and execute queries, develop and debug stored routines, automate database object management, analyze table data via an intuitive interface, and much more.
SQL Interface
Translates the SQL command in textual format into a combination of internal binary structures that can be easily manipulated by the optimizer.
MySQL Parser
Is built-in database software that determines the most efficient method for an SQL statement to access requested data.
Query optimizer (called simply the optimizer)
Is an area in main memory where InnoDB caches table and index data as it is accessed.
Buffer pool
Permits frequently used data to be accessed directly from memory, which speeds up processing. On dedicated servers, up to 80% of physical memory is often assigned to this.
Buffer pool
Is a prominent MySQL feature that speeds up data retrieval from a database. It achieves this by storing MySQL SELECT statements together with the retrieved record set in memory, then if a client requests identical queries it can serve the data faster without executing commands again from the database.
Query cache
The default storage engine in MySQL 8.0 and is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data.
InnoDB
These tables have a small footprint so it is often used in read-only or read-mostly workloads in Web and data warehousing
configurations.
MyISAM
Stores all data in RAM, for fast access in environments that require quick lookups of non-critical data. This engine was formerly known as the HEAP engine.
Memory
Its tables are text files with comma-separated values.
CSV
These compact, unindexed tables are intended for storing and retrieving large amounts of
seldom-referenced historical, archived, or security audit information.
Archive
Accepts but does not store data, similar to the Unix /dev/null device. Queries always return an empty set. These tables can be used in replication configurations where DML statements are sent to replica servers, but the source server does not keep its own copy of the data.
Blackhole
This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability.
NBD (or NBDCluster)
