Index

A

• access control, MySQL 8
  • about / Access control in MySQL 8
  • privileges / Privileges provided by MySQL 8
  • grant tables / Grant tables
• Access Control Lists (ACLs) / General guidelines
• access control stages verification
  • about / Verification of access control stages
  • connection verification / Stage 1 - Connection verification
  • request verification / Stage 2 - Request verification
• administrative programs, MySQL 8
  • innochecksum / Administrative and utilities programs, innochecksum - offline InnoDB file checksum utility
  • myisam_ftdump / Administrative and utilities programs, myisam_ftdump - displaying full-text index utility
  • myisamchk / Administrative and utilities programs, myisamchk - MyISAM table-maintenance utility
  • myisamlog / Administrative and utilities programs, myisamlog - displaying MyISAM log file content
  • myisampack / Administrative and utilities programs, myisampack - generating compressed, read-only MyISAM tables
  • mysql_config_editor / Administrative and utilities programs, mysql_config_editor - MySQL configuration utility
  • mysqlbinlog / Administrative and utilities programs, mysqlbinlog - utility for processing binary log files
  • mysqldumpslow / Administrative and utilities programs, mysqldumpslow - summarizing slow query log files.
  • ibdsdi / MySQL 8 administrative programs, ibdsdi - InnoDB tablespace SDI extraction utility
• advanced custom storage engine
  • reference / Reference for advanced custom storage engine
• advantages, MySQL replication
  • scale out solutions / Advantages of MySQL replication
  • data security / Advantages of MySQL replication
  • analytics / Advantages of MySQL replication
  • long distance data distribution / Advantages of MySQL replication
• American National Standard Institute (ANSI) /
• Application Programming Interface (APIs) / Platform compatibility
• ARCHIVE storage engine / The ARCHIVE storage engine
• archive storage engine / Overview of archive
• authentication plugins
  • about / Authentication plugins
  • SHA-2 pluggable authentication / SHA-2 pluggable authentication
  • client-side cleartext pluggable authentication / Client-side cleartext pluggable authentication
  • no-login pluggable authentication / No-login pluggable authentication
  • socket peer-credential pluggable authentication / Socket peer-credential pluggable authentication
  • test pluggable authentication / Test pluggable authentication

B

• B-Tree index / B-Tree index
• Basic Multilingual Plane (BMP) / Character set support
• benefits, MySQL 8
  • about / Benefits of using MySQL 8
  • security / Security
  • scalability / Scalability
  • open source relational database management system / An open source relational database management system
  • high performance / High performance
  • high availability / High availability
  • cross-platform capabilities / Cross-platform capabilities
• best practices, data partitioning
  • about / Best practices for data partitioning
  • horizontal partitioning / Horizontal partitioning
  • vertical partitioning / Vertical partitioning
  • pruning of partitions / Pruning partitions in MySQL
• best practices, for queries and indexing
  • about / Best practices for queries and indexing
  • data types / Data types, Data types and joins
  • not null / Not null
  • indexing / Indexing, Indexing everything
  • search fields index / Search fields index
  • joins / Data types and joins
  • compound index / Compound index
  • primary keys, shortening up / Shortening up primary keys
  • data, fetching / Fetching all data
  • job, performing / Letting the application do the job
  • data existence / Existence of data
  • limiting / Limiting yourself
  • slow queries, analyzing / Analyzing slow queries
  • query cost / Query cost
• best practices, memcached
  • about / Best practices for memcached
  • resource allocation / Resource allocation
  • operating system architecture / Operating system architecture
  • default configurations / Default configurations
  • max object size / Max object size
  • backlog queue limit / Backlog queue limit
  • large pages support / Large pages support
  • sensitive data / Sensitive data
  • exposure, restricting / Restricting exposure
  • failover / Failover
  • namespaces / Namespaces
  • caching mechanism / Caching mechanism
  • memcached general statistics / Memcached general statistics
• best practices, MySQL benchmarking and tools
  • about / MySQL benchmarking and tools
  • resource utilization / Resource utilization
  • benchmarking timelines, stretching / Stretching your benchmarking timelines
  • production settings, replicating / Replicating production settings
  • latency, consistency / Consistency of throughput and latency
  • throughput, consistency / Consistency of throughput and latency
  • sysbench / Sysbench can do more
  • virtualization / Virtualization world
  • hidden workloads / Hidden workloads
  • query / Nerves of your query
  • benchmarks / Benchmarks
• best practices, replication
  • throughput, in group replication / Throughput in group replication
  • infrastructure sizing / Infrastructure sizing
  • constant throughput / Constant throughput
  • contradictory workloads / Contradictory workloads
  • write scalability / Write scalability
• BINARY data type / BINARY and VARBINARY data types
• Binary Large Object (BLOB) / BLOB and TEXT data types
• binary log / The binary log
• binary log file based replication / Binary log file based replication
• binlog dump thread / Replication implementation details
• bit value type
  • about / Bit value type
  • literals / Bit value literals
  • implementations / Practical uses of BIT
• BLACKHOLE storage engine / Overview of BLACKHOLE as a storage engine, The BLACKHOLE storage engine
• BLOB data types
  • about / BLOB and TEXT data types
  • optimization guidelines / Optimizing MySQL data types
• bucket / Hash index

C

• caching techniques / Caching techniques
• Certificate Authority (CA) / Server-side configuration for encrypted connections
• challenges, in scaling MySQL 8
  • about / Challenges in scaling MySQL 8
  • business type / Business type and flexibility
  • flexibility / Business type and flexibility
  • server workload / Understand server workload
  • read-write operation limit / Read-write operation limit
  • maintenance / Maintenance
  • master server failure / Master server failure
  • synchronization / Synchronization
  • database security / Database security
  • cross node transaction / Cross node transaction
  • growing team, for development / Growing team for development
  • change request management / Manage change request
  • scale-up / Scale-up and scale-out
  • scale-out / Scale-up and scale-out
• character sets
  • about / Character sets
  • support / Character set support
  • adding / Adding the character set
  • configuring / Configuring the character sets
• CHAR data type / CHAR and VARCHAR data types
• client-side cleartext pluggable authentication / Client-side cleartext pluggable authentication
• client-side configuration
  • for encrypted connections / Client-side configuration for encrypted connections
• client programs, MySQL 8
  • mysql / Client programs, mysql - the command-line tool
  • mysqladmin / Client programs, mysqladmin - client for administering a MySQL server
  • mysqlcheck / Client programs, mysqlcheck - a table maintenance program
  • mysqldump / Client programs, mysqldump - a database backup program
  • mysqlimport / Client programs, mysqlimport - a data import program
  • mysqlpump / Client programs, mysqlpump - a database backup program
  • mysqlshow / Client programs, mysqlshow - showing database, table, and column information
  • mysqlslap / Client programs, mysqlslap - load emulation client
  • mysql logging / mysql logging
  • mysql server-side help / mysql server-side help
  • mysqlsh / mysqlsh - the MySQL Shell
• cluster
  • used, for scaling MySQL 8 / Scaling using cluster
• cluster architecture
  • about / Scaling using cluster
  • client node / Client node
  • application node / Application node
  • management node / Management node
  • data node / Data node
• clustered index / An overview on indexing
• collation
  • reference / Configuring the character sets
• column-level indexing / Column-level indexing
• column indexes
  • about / Column indexes
  • index prefixes / Index prefixes
  • FULLTEXT indexes / FULLTEXT indexes
  • spatial indexes / Spatial Indexes
• COLUMNS partitioning
  • about / COLUMNS partitioning
  • RANGE COLUMN partitioning / RANGE COLUMN partitioning
  • LIST COLUMN partitioning / LIST COLUMN partitioning
• command line
  • MySQL 8 programs, executing from / Executing programs from the command line
• command options
  • for encrypted connections / Command options for encrypted connections
• commands, related to role configuration
  • SET ROLE / SET ROLE
  • CREATE ROLE / CREATE ROLE
  • DROP ROLE / DROP ROLE 
  • GRANT / GRANT
  • REVOKE / REVOKE
  • SET DEFAULT ROLE / SET DEFAULT ROLE
  • SHOW GRANTS / SHOW GRANTS
• comma separated values (CSV) engine / Overview of CSV
• components
  • managing / Components and plugin management
• component services / Component and plugin services
• composite index / Multiple-column indexes
• comp_err / Installation/upgradation programs, comp_err – compiling the MySQL error msg file
• connection-control plugins / The connection-control plugins
• CONNECTION_CONTROL plugin
  • about / CONNECTION_CONTROL
  • installing / Plugin installation
  • variables / Variables related to CONNECTION-CONTROL
• core features, MySQL
  • structured database / Structured database
  • database storage engines / Database storage engines and types
  • database storage types / Database storage engines and types
• CREATE ROLE command / CREATE ROLE
• CSV storage engine / The CSV storage engine
• custom storage engine
  • creating / Creating a custom storage engine
  • storage engine source files, creating / Creating storage engine source files
  • engine-specific variables, adding / Adding engine-specific variables and parameters
  • engine-specific parameters, adding / Adding engine-specific variables and parameters
  • handlerton, creating / Creating the handlerton
  • handler installation, handling / Handling handler installation
  • filename extensions, defining / Defining filename extensions
  • tables, creating / Creating tables
  • table, opening / Opening a table
  • basic table scanning implementation / Implementing basic table scanning
  • table, closing / Closing a table

D

• database storage engines
  • InnoDB / Overview of InnoDB
  • MyISAM /
  • memory / Overview of memory
  • archive / Overview of archive
  • BLACKHOLE / Overview of BLACKHOLE as a storage engine
  • CSV / Overview of CSV
  • merge / Overview of merge
  • federated / Overview of federated
  • NDB cluster / Overview of the NDB cluster
• database structure
  • optimizing / Optimizing database structure
• data directory / Data directory
• data nodes
  • benefits / Data storage and management of disk-based and in-memory data, Automatic fail over
• data partitioning
  • best practices / Best practices for data partitioning
• data size optimization
  • about / Optimizing data size
  • table columns / Table columns
  • row format / Row format
  • indexes / Indexes
  • joins / Joins
  • normalization / Normalization
• data type
  • selecting, for column / Choosing the right data type for column
• data types, storage requisites / Storage requirements for data types
• date and time data types
  • about / Date and time data types
  • DATE type / DATE, DATETIME, and TIMESTAMP types
  • DATETIME type / DATE, DATETIME, and TIMESTAMP types
  • TIMESTAMP type / DATE, DATETIME, and TIMESTAMP types
  • MySQL DATETIME functions / MySQL DATETIME functions
  • TIME type / TIME type
  • time functions / Time functions
  • YEAR type / YEAR type
  • YEAR(2), migrating to YEAR(4) / Migrating YEAR(2) to YEAR(4)
• DBUG package / The DBUG package
• DDL log / The DDL log
• Debian package
  • used, for installing MySQL 8 / Installation using the Debian package
• debugging / Debugging and porting
• descending index / Descending index
• Development Milestone Release (DMR) / Improved features in MySQL 8
• disk I/O
  • optimizing / Optimizing disk I/O
• Drop index command / Drop index command
• DROP ROLE command / DROP ROLE 

E

• encryption
  • in MySQL 8 / Encryption in MySQL 8
• ENUM data type / ENUM data type
• environment variables, MySQL 8
  • MYSQL_UNIX_PORT / Environment variables
  • MYSQL_TCP_PORT / Environment variables
  • MYSQL_PWD / Environment variables
  • MYSQL_DEBUG / Environment variables
  • TMPDIR / Environment variables
  • about / MySQL 8 environment variables
• error log
  • about / The error log
  • component configuration / Component configuration
  • default error log destination configuration / Default error log destination configuration 
  • default error log destination, on Windows / Default error log destination on Windows
  • default error log destination, on Unix / Default error log destination on Unix and  Unix-Like systems
  • default error log destination, on Unix-Like systems / Default error log destination on Unix and  Unix-Like systems
• EXAMPLE storage engine / The EXAMPLE storage engine
• EXPLAIN statement / Query execution plan

F

• FEDERATED storage engine / The FEDERATED storage engine
• federated storage engine / Overview of federated
• fixed point types / Fixed point types
• floating point types
  • about / Floating point types
  • problems / Problems with floating point values
• FULLTEXT indexes / FULLTEXT indexes
• functions
  • adding, to MySQL 8 / Adding new functions to MySQL 8
  • adding / Adding new functions

G

• General Availability (GA) / General installation guide
• General Public License (GNU) /
• general query log / The general query log
• globalization
  • about / Globalization
  • character sets / Character sets
  • language selection / Language selection
  • time zone settings, for MySQL 8 / Time zone settings for MySQL8
  • locale support / Locale support
• global transaction identifier (GTID) / What is MySQL replication?
• Global transaction identifiers (GTID)
  • about / GTID replication
  • benefits / GTID replication
• global transaction identifiers based replication / Global transaction identifiers based replication
• GRANT command / GRANT
• grant tables / Grant tables
• Group Communication System (GCS) / Group replication
• group replication
  • about / Group replication
  • versus primary-secondary replication / Primary-secondary replication versus group replication
  • configuring / Group replication configuration
  • use cases / Group replication use cases
• group replication, MySQL 8
  • limitations / Limitations of group replication in MySQL8
• GUI tools, MySQL
  • MySQL Workbench / MySQL GUI tools
  • MySQL Notifier / MySQL Notifier

H

• hash function / Hash index
• hash index / Hash index
• HASH partitioning
  • about / HASH partitioning
  • LINEAR HASH partitioning / LINEAR HASH partitioning
• HASH partition management / HASH and KEY partition management
• high availability
  • overview / Overview of scalability and high availability in MySQL 8
  • achieving / Achieving high availability
  • advantages / Advantages of high availability
• high availability, purpose
  • about / Purpose of high availability
  • data availability / Data availability
  • data security / Security of data
  • data synchronization / Synchronization of data
  • data backup / Backup of the data
  • competitive market / Competitive market
  • performance / Performance
  • system updates / Updates in the system
  • solution selection / Choosing the solution

I

• ibdsdi / ibdsdi - InnoDB tablespace SDI extraction utility
• IGNORE keyword
  • about / The IGNORE keyword
  • reference / The IGNORE keyword
• improved features, MySQL 8
  • transactional data dictionary / Transactional data dictionary
  • roles / Roles
  • InnoDB auto increment / InnoDB auto increment
  • invisible indexes / Invisible indexes
  • descending indexes / Improving descending indexes
  • SET PERSIST variant / The SET PERSIST variant
  • expanded GIS support / Expanded GIS support
  • default character set / Default character set
  • extended bit-wise operations / Extended bit-wise operations
  • InnoDB Memcached / InnoDB Memcached
  • NOWAIT / NOWAIT and SKIP LOCKED
  • SKIP LOCKED / NOWAIT and SKIP LOCKED
  • JSON / JSON
  • cloud / Cloud
  • resource management / Resource management
• INDEX command
  • creating / Creating an INDEX command
• indexes
  • clustered index / An overview on indexing
  • non-clustered index / An overview on indexing
  • benefits / Uses of indexes in MySQL 8
  • optimizer, using for / Using an optimizer for indexes
  • optimizing / Optimizing indexes
• index extension / Index extension
• indexing
  • overview / An overview on indexing
• innochecksum / Administrative and utilities programs, innochecksum - offline InnoDB file checksum utility
• InnoDB architecture
  • components / Architecture
• InnoDB buffer pool optimization / InnoDB buffer pool optimization
• InnoDB index statistics collection / InnoDB and MyISAM index statistics collection
• InnoDB storage engine
  • about / Overview of InnoDB, The InnoDB storage engine
  • limitations / Limitations of InnoDB storage engine
  • restrictions / Restrictions
  • overview / Overview of the InnoDB storage engine
  • ACID model / ACID model
  • multiversioning / Multiversioning
  • locking model / Locking and transaction model
  • transactional model / Locking and transaction model
  • configuration / Configuration
  • tablespaces / Tablespaces
  • tables / Tables and indexes
  • indexes / Tables and indexes
  • INFORMATION_SCHEMA tables / INFORMATION_SCHEMA tables 
  • memcached plugin / Memcached plugin
• InnoDB tables
  • optimizing / Optimization for InnoDB tables
• installation/upgradation programs, MySQL 8
  • comp_err / Installation/upgradation programs, comp_err – compiling the MySQL error msg file
  • mysql_secure_installation / Installation/upgradation programs, mysql_secure_installation – improving MySQL installation security
  • mysql_ssl_rsa_setup / Installation/upgradation programs, mysql_ssl_rsa_setup – creating SSL/RSA files
  • mysql_tzinfo_to_sql / Installation/upgradation programs, mysql_tzinfo_to_sql – loading the timezone tables
  • mysql_upgrade / Installation/upgradation programs, mysql_upgrade - checking and upgrading MySQL tables
  • about / Installation programs
• instances
  • executing, on single machine / Running multiple instances on a single machine
  • multiple data directories, setting up / Setting up multiple data directories
  • MySQL instances, executing on Windows / Running multiple MySQL instances on Windows
• integer types / Integer types
• internal temporary table
  • usage, in MySQL / Use of an internal temporary table in MySQL
• Internet Assigned Numbers Authority (IANA) / Locale support
• invisible index / Invisible and descending indexes, Invisible index

J

• JavaScript Object Notation (JSON) / Query execution plan
• JSON data type
  • about / JSON data type
  • partial updates / Partial updates of JSON values

K

• KEY partitioning / KEY partitioning
• KEY partition management / HASH and KEY partition management
• keyring plugin
  • about / MySQL 8 keyring
  • installing / Install keyring plugin
  • variables / System variables related to keyring plugin
• keyring service / The keyring service

L

• Least Recently Used (LRU) / MyISAM key cache
• limitations, MySQL 8
  • number of tables / Number of tables or databases
  • number of databases / Number of tables or databases
  • table size / Table size
  • joins / Joins
  • Windows platform / Windows platform
  • table column count / Table column count
  • row size / Row size
  • InnoDB storage engine / InnoDB storage engine
  • data dictionary / Data dictionary
  • group replication / Limitations of group replication in MySQL8
  • partitioning / Limitations of partitioning
• LINEAR HASH partitioning / LINEAR HASH partitioning
• Linux
  • MySQL 8, installing on / Installing MySQL 8 on Linux
• Linux Apache MySQL PHP (LAMP) / Cross-platform capabilities
• LIST COLUMN partitioning / LIST COLUMN partitioning
• LIST partitioning / LIST partitioning
• LIST partition management / RANGE and LIST partition management
• locking operations
  • optimizing / Optimizing locking operations
• locking service / The locking service
• lock types, InnoDB storage engine
  • shared locks / Locking and transaction model
  • exclusive lock / Locking and transaction model
  • intention locks / Locking and transaction model
  • record locks / Locking and transaction model
  • gap locks / Locking and transaction model
  • next-key locks / Locking and transaction model
  • insertion intention locks / Locking and transaction model
  • AUTO-INC locks / Locking and transaction model
  • predicate locks / Locking and transaction model
• logging / Password and logging

M

• memcached
  • used, for scaling MySQL 8 / Scaling using memcached in MySQL 8
  • best practices / Best practices for memcached
• MEMORY storage engine
  • about / The MEMORY storage engine
  • indexes / Indexes in the MEMORY storage engine
• memory storage engine / Overview of memory
• MEMORY tables
  • optimizing / Optimization for MEMORY tables
• MERGE storage engine / The MERGE storage engine
• merge storage engine / Overview of merge
• metadata / Character set support
• Microsoft Windows
  • MySQL 8, installing on / Installing MySQL 8 on Microsoft Windows
• mixed-format replication / Replication formats
• multiple-column indexes / Multiple-column indexes
• multiple tables
  • optimizing / Optimizing for many tables
• MyISAM /
• myisamchk / Administrative and utilities programs, myisamchk - MyISAM table-maintenance utility
• MyISAM index statistics collection / InnoDB and MyISAM index statistics collection
• MyISAM key cache / MyISAM key cache
• myisamlog / Administrative and utilities programs, myisamlog - displaying MyISAM log file content
• myisampack / Administrative and utilities programs, myisampack - generating compressed, read-only MyISAM tables
• MyISAM storage engine / The MyISAM storage engine
• MyISAM tables
  • optimizing / Optimization for MyISAM tables
• myisam_ftdump / Administrative and utilities programs, myisam_ftdump - displaying full-text index utility
• mysql
  • about / Client programs, mysql - the command-line tool
  • options / mysql options
  • commands / mysql commands, connect [db_name host_name], \r [db_name host_name]
  • logging / mysql logging
• MySQL
  • overview / Overview of MySQL
  • as relational database management system /
  • reliability / Reliability and scalability
  • scalability / Reliability and scalability
  • platform compatibility / Platform compatibility
  • releases / Releases
  • core features / Core features in MySQL
  • use cases / Use cases of MySQL
  • Network File System (NFS), using with / Using NFS with MySQL
• mysql.8.1.2-rc / General installation guide
• mysql.server / Startup programs, mysql.server – MySQL Server startup script
• MySQL 5.7
  • upgrade prerequisites / Upgrading prerequisites for MySQL 5.7
• MySQL 8
  • license requisites /
  • improved features / Improved features in MySQL 8
  • benefits / Benefits of using MySQL 8
  • limitations / Limitations of MySQL 8
  • installation process / The MySQL 8 installation process
  • general installation guide / General installation guide
  • development release / General installation guide
  • general release / General installation guide
  • Development Milestone Release (dmr) / General installation guide
  • downloading / Downloading MySQL 8
  • package integrity, verifying / Verifying the package integrity
  • package integrity, verifying with MD5 checksums / Using MD5 checksums
  • package integrity, verifying with cryptographic signatures / Using cryptographic signatures
  • installing, on Microsoft Windows / Installing MySQL 8 on Microsoft Windows
  • installer distributions / Installing MySQL 8 on Microsoft Windows
  • source distribution / Installing MySQL 8 on Microsoft Windows
  • binary distribution / Installing MySQL 8 on Microsoft Windows
  • Windows-specific considerations / Windows-specific considerations
  • installation layout / MySQL 8 installation layout
  • right installation package, selecting / Choosing the right installation package
  • installing, ZIP file used / MySQL 8 installation using a ZIP file
  • installing, on Linux / Installing MySQL 8 on Linux
  • installing, Yum repository used / Installation using the Yum repository
  • installing, RPM package used / Installation using the RPM package
  • installing, Debian package used / Installation using the Debian package
  • post-installation setup / Post-installation setup for MySQL 8
  • upgrading / Upgrading MySQL 8
  • upgrading methods / Upgrading methods
  • in-place upgrade / In-place upgrade of MySQL
  • logical upgrade / Logical upgrade for MySQL 8
  • downgrading / MySQL 8 downgrading
  • downgrade methods / Downgrading methods
  • logical downgrade / Logical downgrade
  • manual changes, before downgrading / Manual changes required before downgrading
  • command-line programs / MySQL 8 command-line programs
  • client programs / MySQL 8 client programs
  • administrative programs / MySQL 8 administrative programs
  • data types, overview / Overview of MySQL 8 data types
  • scaling / Scaling MySQL 8
  • scaling, cluster used / Scaling using cluster
  • scaling, memcached used / Scaling using memcached in MySQL 8
  • challenges, in scaling / Challenges in scaling MySQL 8
  • securing, against attackers / Secure MYSQL 8 against attackers
  • security options / Security options and variables provided by MySQL 8
  • security guidelines, for client programming / Security guidelines for client programming
  • access control / Access control in MySQL 8
  • account management / Account management in MySQL 8
  • encryption / Encryption in MySQL 8
  • extending / An overview of extending MySQL 8
  • locking service / MySQL 8 services for components and plugins
  • keyring service / MySQL 8 services for components and plugins
  • functions, adding / Adding new functions to MySQL 8
  • porting / Debugging and porting MySQL 8
  • debugging / Debugging and porting MySQL 8
  • common issues / MySQL 8 common problems
• My SQL 8
  • Release Candidate (rc) / General installation guide
  • absence of suffix / General installation guide
• MySQL 8 client errors
  • about / MySQL 8 client errors
  • case sensitivity, in string searches / Case sensitivity in string searches
  • DATE columns issue / Problems with DATE columns
  • NULL values issue / Problems with NULL values
• MySQL 8 clients
  • optimizing / Optimizing MySQL 8 servers and clients
• MySQL 8 installer
  • about / The MySQL 8 installer
  • Community Edition / The MySQL 8 installer
  • Commercial Edition / The MySQL 8 installer
  • initial setup information / Initial setup information
  • installation workflow / Installation workflow
  • InnoDB cluster sandbox test setup / InnoDB cluster sandbox test setup
  • server configuration / Server configuration
  • product catalog / MySQL installer product catalog and dashboard
  • dashboard / MySQL installer product catalog and dashboard
  • console / MySQL installer console
• MySQL 8 internals
  • about / MySQL 8 internals
  • reference / MySQL 8 internals
• MySQL 8 optimization
  • database optimization / Optimizing the database
  • hardware optimization / Optimizing the hardware
• MySQL 8 plugin API / MySQL 8 plugin API 
• MySQL 8 privilege system
  • limitations / Access control in MySQL 8
• MySQL 8 programs
  • overview / Overview of MySQL 8 programs, MySQL programs in brief
  • startup programs / Startup programs, Server and server-startup programs
  • installation/upgradation programs / Installation/upgradation programs, Installation programs
  • client programs / Client programs
  • administrative programs / Administrative and utilities programs
  • environment variables / Environment variables, MySQL 8 environment variables
  • executing, from command line / Executing programs from the command line
  • executing / Executing MySQL programs
  • connecting, to MySQL server / Connecting to the MySQL server
  • options, specifying for / Specifying options for programs
  • options, on command line / Options on the command line
  • options, modifying / Modifying program options
  • options, modifying with files / Modifying options with files
  • group / group
  • opt_name / opt_name
  • opt_name=value / opt_name=value
  • include directives / Include directives
  • command-line options, affecting option file handling / Command-line options affecting option file handling
  • program variables, setting with options / Setting program variables with options
  • environment variables, setting / Setting environment variables
• MySQL 8 server errors
  • about / MySQL 8 server errors
  • file permissions issue / Issues with file permissions
  • root password reset / Resetting the root password
  • MySQL crashes prevention / MySQL crashes prevention
  • disk-full condition / Handling MySQL full disk
  • temporary files storage / MySQL temporary files storage
  • Unix socket file / MySQL Unix socket file
  • time zone issues / Time zone problems
• MySQL 8 servers
  • optimizing / Optimizing MySQL 8 servers and clients
• MySQL 8 test suite / MySQL 8 internals
• MySQL 8 threads / MySQL 8 internals
• MySQL 8 troubleshooting approach
  • about / MySQL 8 troubleshooting approach
  • queries, analyzing / Analyzing queries
• mysqladmin / Client programs, mysqladmin - client for administering a MySQL server
• MySQL benchmarking and tools
  • best practices / MySQL benchmarking and tools
• mysqlbinlog / Administrative and utilities programs, mysqlbinlog - utility for processing binary log files
• mysqlcheck / Client programs, mysqlcheck - a table maintenance program
• MySQL client
  • debugging / Debugging MySQL client
• mysqld
  • about / Startup programs, mysqld –
  • options / Options
• MySQL data types
  • optimizing / Optimizing MySQL data types
• mysqldump
  • about / Client programs, mysqldump - a database backup program
  • scalability / Performance and scalability
  • performance / Performance and scalability
• mysqldumpslow / Administrative and utilities programs, mysqldumpslow - summarizing slow query log files.
• mysqld_multi / Startup programs, mysqld_multi – managing multiple MySQL servers
• mysqld_safe / Startup programs, mysqld_safe – MySQL server startup script
• MySQL errors
  • about / Most common MySQL errors
  • access denied / Access denied
  • can't connect to MySQL server / Can't connect to [local] MySQL server
  • lost connection to MySQL server / Lost connection to MySQL server
  • password fails when entered incorrectly / Password fails when entered incorrectly
  • host host_name is blocked / Host host_name is blocked
  • too many connections / Too many connections
  • out of memory / Out of memory
  • packet too large / Packet too large
  • table-full error / The table is full
  • can't create/write to file / Can't create/write to file
  • commands out of sync / Commands out of sync
  • ignoring user / Ignoring user
  • table tbl_name doesn't exist / Table tbl_name doesn't exist
• mysqlimport / Client programs, mysqlimport - a data import program
• MySQL memory
  • optimizing / Optimizing the use of memory
• MySQL multi-source replication / MySQL multi-source replication
• MySQL Notifier
  • about / MySQL Notifier
  • usage / MySQL Notifier usage
• MySQL optimization / Overview of MySQL 8 optimization
• mysqlpump / Client programs, mysqlpump - a database backup program
• MySQL queries
  • best practices / Best practices for queries and indexing
• MySQL query optimization
  • real-world scenario / Real-world scenario
• MySQL replication
  • about / What is MySQL replication?
  • advantages / Advantages of MySQL replication
• MySQL server
  • debugging / Debugging MySQL server
• mysql server-side help / mysql server-side help
• mysqlsh / mysqlsh - the MySQL Shell
• mysqlshow / Client programs, mysqlshow - showing database, table, and column information
• mysqlslap / Client programs, mysqlslap - load emulation client
• MySQL storage engine
  • architecture / MySQL storage engine architecture
• MySQL Workbench
  • about / MySQL GUI tool, MySQL Workbench
  • SQL development / MySQL Workbench
  • data modeling / MySQL Workbench
  • server administration / MySQL Workbench
  • data migration / MySQL Workbench
  • MySQL Enterprise support / MySQL Workbench
• mysql_config_editor / Administrative and utilities programs, mysql_config_editor - MySQL configuration utility
• mysql_secure_installation / Installation/upgradation programs, mysql_secure_installation – improving MySQL installation security
• mysql_ssl_rsa_setup / Installation/upgradation programs, mysql_ssl_rsa_setup – creating SSL/RSA files
• mysql_tzinfo_to_sql / Installation/upgradation programs, mysql_tzinfo_to_sql – loading the timezone tables
• mysql_upgrade / Installation/upgradation programs, mysql_upgrade - checking and upgrading MySQL tables

N

• native function
  • adding / Adding a new native function
• NDB cluster
  • overview / Overview of the NDB cluster
• Network File System (NFS)
  • using, with MySQL / Using NFS with MySQL
• network usage
  • optimizing / Optimizing use of the network
• no-login pluggable authentication / No-login pluggable authentication
• non-clustered index / An overview on indexing
• non-spatial index
  • characteristics / Non-spatial index characteristics
• NoSQL APIs / NoSQL APIs
• NULL
  • handling, in partitioning / Handling NULL in partitioning
• numeric data types
  • about / Numeric data types
  • integer types / Integer types
  • fixed point types / Fixed point types
  • floating point types / Floating point types
  • bit value type / Bit value type
  • type attributes / Type attributes

O

• optimizer
  • using, for indexes / Using an optimizer for indexes

P

• partition information
  • obtaining / Obtain partition information
• partitioning
  • overview / Overview of partitioning
  • types / Types of partitioning, Types of partitioning
  • limitations / Restrictions and limitations in partitioning, Partitioning keys, primary keys, and unique keys, Partitioning limitations relating to storage engines, Partitioning limitations relating to functions
  • advantages / Restrictions and limitations in partitioning
  • RANGE partitioning / RANGE partitioning
  • LIST partitioning / LIST partitioning
  • COLUMNS partitioning / COLUMNS partitioning
  • HASH partitioning / HASH partitioning
  • KEY partitioning / KEY partitioning
  • NULL, handling / Handling NULL in partitioning
• partitioning, limitations
  • constructs prohibition / Constructs prohibition
  • operators / Operators
  • tables / Tables
• partition maintenance / Partition maintenance
• partition management
  • about / Partitioning management, Partition management
  • LIST partition management / RANGE and LIST partition management
  • RANGE partition management / RANGE and LIST partition management
  • KEY partition management / HASH and KEY partition management
  • HASH partition management / HASH and KEY partition management
• partition pruning / Partition selection and pruning, Partition pruning
• partition selection / Partition selection and pruning, Partition selection
• password management / Password management
• passwords / Password and logging
• password validation plugin
  • about / The password validation plugin
  • installing / Install password validation plugin
  • variables / Variables and options related to the password validation plugin
• performance benchmarking / Performance benchmarking
• pluggable storage engine architecture / Pluggable storage engine architecture
• plugin management
  • about / Components and plugin management
  • server plugins / MySQL 8 server plugins
  • plugins, installing / Installing the plugins
  • plugin, activating / Activate plugin
  • plugin, uninstalling / Uninstall plugin
  • installed plugins information, obtaining / Getting information about the installed plugins
• plugins
  • extending / Extending plugins and using services to call them
  • writing / Writing plugins
• plugin services / Component and plugin services
• plugins services / Component and plugin services
• porting / Debugging and porting
• post-installation setup, MySQL 8
  • about / Post-installation setup for MySQL 8
  • data directory initialization / Data directory initialization
  • initial MySQL account, securing / Securing the initial MySQL account
  • MySQL 8 services, starting / Starting and troubleshooting MySQL 8 services
  • MySQL 8 services, troubleshooting / Starting and troubleshooting MySQL 8 services
• primary-secondary replication
  • versus group replication / Primary-secondary replication versus group replication
• privileges
  • URL / Roles and permissions
• privileges, MySQL 8
  • database privilege / Privileges provided by MySQL 8
  • administrative privileges / Privileges provided by MySQL 8
  • database object's privileges / Privileges provided by MySQL 8
  • static privileges / Privileges provided by MySQL 8
  • dynamic privileges / Privileges provided by MySQL 8

Q

• queries
  • optimizing / Optimizing queries
• query execution plan
  • determining / Query execution plan

R

• RANGE COLUMN partitioning / RANGE COLUMN partitioning
• RANGE partitioning / RANGE partitioning
• RANGE partition management / RANGE and LIST partition management
• Redundant Array of Independent Drives (RAID) / Optimizing disk I/O
• relational database management system (RDBMS) / Overview of MySQL
• repertoire / Character set support
• replication
  • about / Overview of replication
  • MySQL replication / What is MySQL replication?
  • configuring / Configuring replication
  • binary log file based replication / Binary log file based replication
  • slaves, adding to / Adding slaves to replication
  • global transaction identifiers based replication / Global transaction identifiers based replication
  • MySQL multi-source replication / MySQL multi-source replication
  • administration tasks / Replication administration tasks
  • implementing / Implementing replication
  • formats / Replication formats
  • implementation details / Replication implementation details
  • relay log / Replication relay and status logs
  • master info log / Replication relay and status logs
  • relay log info log / Replication relay and status logs
  • group replication / Group replication
  • solutions / Replication solutions
  • best practices / Best practices for replication
• replication channels / Replication channels
• replication filtering rules
  • evaluating / Evaluating replication filtering rules
• replication master
  • configuring / Replication master configuration
  • configuration / Replication master configuration
• replication slave
  • configuring / REPLICATION SLAVE configuration
• REVOKE command / REVOKE
• roles / Roles and permissions
• row-based replication
  • versus statement-based replication / Statement-based versus row-based replication
• RPM package
  • used, for installing MySQL 8 / Installation using the RPM package

S

• scalability
  • overview / Overview of scalability and high availability in MySQL 8, Scaling MySQL 8
• scaling, with replication
  • about / Scaling using replication
  • single server dependency / Single server dependancy
  • performance / Performance
  • backup and recovery / Backup and recovery
  • load distribution / Load distribution
  • asynchronous data replication / Asynchronous data replication
  • geographical data distribution / Geographical data distribution
  • Global transaction identifiers (GTID) / GTID replication
  • ZFS replication / ZFS replication
• secure password
  • guidelines /  Guidelines for a secure password
  • guidelines, for end users / Guidelines for end users
  • guidelines, for administrators / Guidelines for administrators
• security
  • overview / Overview of security for MySQL 8
  • issues / Common security issues
  • general guidelines / General guidelines
  • with roles / Security using roles
• security plugins
  • about / Security plugins
  • authentication plugins / Authentication plugins
  • connection-control plugins / The connection-control plugins
  • password validation plugin / The password validation plugin
  • keyring plugin / MySQL 8 keyring
• server-side configuration
  • for encrypted connections / Server-side configuration for encrypted connections
• server administration
  • about / MySQL 8 server administration
  • server options / Server options and different types of variables
  • variable, types / Server options and different types of variables
  • Server SQL, modes / Server SQL modes
  • IPv6 support / IPv6 support        
  • server side help / Server side help
  • server shutdown process / The server shutdown process 
• server log
  • about / MySQL 8 server logs
  • reference / MySQL 8 server logs
  • error log / The error log
  • general query log / The general query log
  • binary log / The binary log
  • slow query log / The slow query log
  • DDL log / The DDL log
  • maintenance / Server log maintenance
• server option
  • reference / Server options and different types of variables
• server shutdown process / The server shutdown process 
• Server SQL, modes
  • SQL mode, setting / Setting the SQL mode
  • ANSI / The available SQL modes
  • STRICT_TRANS_TABLES / The available SQL modes
  • TRADITIONAL / The available SQL modes
  • ALLOW_INVALID_DATES / The available SQL modes
  • ANSI_QUOTES / The available SQL modes
  • ERROR_FOR_DIVISON_BY_ZERO / The available SQL modes
  • HIGH_NOT_PRECEDENCE / The available SQL modes
  • IGNORE_SPACE / The available SQL modes
  • NO_AUTO_CREATE_USER / The available SQL modes
  • NO_AUTO_VALUE_ON_ZERO / The available SQL modes
  • NO_BACKSLASH_ESCAPES / The available SQL modes
  • NO_DIR_IN_CREATE / The available SQL modes
  • NO_ENGINE_SUBSTITUTION / The available SQL modes
  • NO_FIELD_OPTIONS / The available SQL modes
  • NO_KEY_OPTIONS / The available SQL modes
  • NO_TABLE_OPTIONS / The available SQL modes
  • NO_UNSIGNED_SUBTRACTION / The available SQL modes
  • NO_ZERO_DATE / The available SQL modes
  • NO_ZERO_IN_DATE / The available SQL modes
  • ONLY_FULL_GROUP_BY / The available SQL modes
  • PAD_CHAR_TO_FULL_LENGTH / The available SQL modes
  • PIPES_AS_CONCAT / The available SQL modes
  • REAL_AS_FLOAT / The available SQL modes
  • STRICT_ALL_TABLES / The available SQL modes
  • TIME_TRUNCATE_FRACTIONAL / The available SQL modes
  • combination SQL modes / Combination SQL modes
  • strict SQL mode / Strict SQL mode
  • IGNORE keyword / The IGNORE keyword
• Server status variable
  • reference / Server options and different types of variables
• Server System variable
  • reference / Server options and different types of variables
• services
  • used, for calling plugins / Extending plugins and using services to call them
• SET data type / SET data type
• SET DEFAULT ROLE command / SET DEFAULT ROLE
• SET ROLE command / SET ROLE
• SHA-2 pluggable authentication / SHA-2 pluggable authentication
• SHOW GRANTS command / SHOW GRANTS
• slave I/O thread / Replication implementation details
• slaves
  • adding, to replication / Adding slaves to replication
• slave server SQL thread
  • states / Examining thread information
• slave SQL thread / Replication implementation details
• slow query log / The slow query log
• socket peer-credential pluggable authentication / Socket peer-credential pluggable authentication
• solutions, MySQL 8 for high availability
  • MySQL replication / Overview of scalability and high availability in MySQL 8
  • MySQL cluster / MySQL cluster
  • Oracle MySQL cloud service / Oracle MySQL cloud service
  • MySQL, with Solaris cluster / MySQL with the Solaris cluster
• spatial index
  • characteristics / Spatial index characteristics
  • creating / SPATIAL index creation and optimization
  • optimizing / SPATIAL index creation and optimization
• spatial reference identifier (SRID) / SPATIAL index creation and optimization
• Spatial Reference System (SRS) / Expanded GIS support, SPATIAL index creation and optimization
• sql
  • executing, from text files / Executing sql from text files
• SQL statements
  • optimizing / Optimizing SQL statements
• SSH
  • used, for connecting remotely with MySQL 8 / Connect with MySQL 8 remotely from Windows with SSH
• startup programs, MySQL 8
  • about / Startup programs
  • mysqld / Startup programs, mysqld –
  • mysqld_safe / Startup programs, mysqld_safe – MySQL server startup script
  • mysql.server / Startup programs, mysql.server – MySQL Server startup script
  • mysqld_multi / Startup programs, mysqld_multi – managing multiple MySQL servers
• statement-based replication
  • about / Replication formats
  • versus row-based replication / Statement-based versus row-based replication
• storage engines
  • overview / Overview of storage engines
  • MySQL storage engine / MySQL storage engine architecture
  • types / Several types of storage engine, Several types of storage engines
  • InnoDB storage engine / Overview of the InnoDB storage engine, The InnoDB storage engine
  • custom storage engine / Custom storage engine
  • pluggable storage engine architecture / Pluggable storage engine architecture
  • database server layer / The common database server layer
  • setting / Setting the storage engine
  • MyISAM storage engine / The MyISAM storage engine
  • MEMORY storage engine / The MEMORY storage engine
  • CSV storage engine / The CSV storage engine
  • ARCHIVE storage engine / The ARCHIVE storage engine
  • BLACKHOLE storage engine / The BLACKHOLE storage engine
  • MERGE storage engine / The MERGE storage engine
  • FEDERATED storage engine / The FEDERATED storage engine
  • EXAMPLE storage engine / The EXAMPLE storage engine
• strict mode / Strict SQL mode
• string data types
  • about / String data types
  • CHAR data type / CHAR and VARCHAR data types
  • VARCHAR data type / CHAR and VARCHAR data types
  • VARCHAR data types / CHAR and VARCHAR data types
  • BINARY data type / BINARY and VARBINARY data types
  • VARBINARY data types / BINARY and VARBINARY data types
  • BLOB data types / BLOB and TEXT data types
  • TEXT data types / BLOB and TEXT data types
  • ENUM data type / ENUM data type
  • SET data type / SET data type
• structured database / Structured database
• Structured Query Language (SQL) / Overview of MySQL
• subpartitioning / Subpartitioning
• system database
  • about / The system database
  • data dictionary tables / Data dictionary tables
  • object information system tables / Object information system tables
  • log system tables / Log system tables
  • server-side help system tables / The server-side help system tables
  • time zone system tables / Time zone system tables
  • replication system tables / Replication system tables
  • optimizer system tables / Optimizer system tables
  • miscellaneous system tables / Other miscellaneous system tables

T

• tables
  • optimizing / Optimizing tables
• test pluggable authentication / Test pluggable authentication
• thread information
  • examining / Examining thread information
  • executing / Examining thread information
• type attributes
  • about / Type attributes
  • overflow, handling / Overflow handling

U

• use cases, MySQL
  • social media / Social media
  • government / Government
  • media / Media and entertainment
  • entertainment / Media and entertainment
  • fraud detection / Fraud detection
  • business mapping / Business mapping
  • e-commerce / E-commerce
• user-defined function
  • adding / Adding a new user-defined function
• user-defined function interface
  • features / Features of a user-defined function interface
• user account
  • creating / Add and remove user accounts
  • removing / Add and remove user accounts

V

• VARBINARY data type / BINARY and VARBINARY data types
• VARCHAR data type / CHAR and VARCHAR data types

W

• Windows
  • MySQL instances, executing / Running multiple MySQL instances on Windows

Y

• Yum repository
  • used, for installing MySQL 8 / Installation using the Yum repository

Z

• ZIP file
  • used, for installing MySQL 8 / MySQL 8 installation using a ZIP file