Index

A

• access modes, transactions
  • about / Transactions access modes
• allowed values, log_slow_filter variable
  • full_scan / The slow query log
  • full_join / The slow query log
  • filesort / The slow query log
  • filesort_on_disk / The slow query log
  • tmp_table / The slow query log
  • tmp_table_on_disk / The slow query log
  • query_cache_miss / The slow query log
• allowed values, log_slow_verbosity
  • microtime / The slow query log
  • query_plan / The slow query log
  • innodb / The slow query log
  • profiling / The slow query log
  • profiling_use_getrusage / The slow query log
  • explain / The slow query log
• ALTER TABLE command
  • about / The general_log table
• Antelope / A brief on InnoDB file formats
• AppArmor
  • about / Installation
  • disabling / Installation
• ARCHIVE
  • about / Other compression solutions
• ARCHIVE storage engine
  • about / Other engines
• Aria
  • about / MyISAM and Aria
• Aria log
  • about / Logs
• Aria page cache
  • about / Aria page cache
• Aria recovery
  • about / MyISAM and Aria autorecovery
  • values / MyISAM and Aria autorecovery
• Aria status variable
  • about / Aria page cache
• asynchronous replication / An overview of replication
• atomic writes
  • about / Explaining the doublewrite buffer
• authentication, MariaDB
  • about / Authentication and security
  • permissions / Authentication and security
• authentication plugins
  • about / Authentication plugins
  • mysql_native_password / Authentication plugins
  • mysql_old_password / Authentication plugins
  • unix_socket / Authentication plugins
  • pam / Authentication plugins
  • pool of threads, enabling / Activating the pool of threads
  • pool of threads, monitoring / Monitoring the pool of threads
  • threadpool implementation, configuring / Configuring the threadpool implementation
  • pool of threads, configuring on Unix / Configuring the pool of threads on Unix
  • pool of threads, configuring on Windows / Configuring the pool of threads on Windows
  • configuration variables, tuning / Tuning the configuration variables
  • blocked pool of threads, unblocking / Unblocking a blocked pool of threads
• automatic node provisioning / An overview of Galera Cluster

B

• @@binlog_format variable / Choosing a binary log format, Configuring a new replication master
• backups
  • types / Types of backups
  • logical backup / Logical and physical backups
  • physical backup / Logical and physical backups
  • cold backup / Hot and cold backups
  • hot backup / Hot and cold backups
  • replication, working with / Backups and replication
  • steps / Steps to be followed before performing backups
  • securing / Securing backups
• backups, securing
  • about / Securing backups
  • permissions, setting / Securing backups
  • backups, transferring in secure way / Securing backups
  • encrypt backups / Securing backups
  • store backups, in safe place / Securing backups
• Barracuda / A brief on InnoDB file formats
• binary injection
  • about / The MIXED binary logging format
• binary log
  • using, for incremental backups / Using the binary log for incremental backups
  • rotating / Rotating the binary log
  • about / Rotating the binary log
• binary log format
  • about / The general query log
  • statement-based binary logging / Statement-based binary logging
  • row-based binary logging / Row-based binary logging
  • MIXED binary logging format / The MIXED binary logging format
• binary log format, replication
  • STATEMENT format / An overview of replication
  • ROW format / An overview of replication
  • MIXED format / An overview of replication
  • selecting / Choosing a binary log format
• binary logging, of stored programs
  • about / The binary logging of stored programs
• Binlog dump thread / Replication threads
• binlog_format variable / Starting the nodes
• BLACKHOLE storage engine
  • about / Other engines
• BTREE index type
  • about / Introducing indexes
• buffer pool instances
  • about / Buffer pool instances
• buffer pool performance
  • diagnosing / Diagnosing the buffer pool performance
• bulk_insert_buffer_size variable / Per-session buffers

C

• --compress option / Incremental physical backups with the rsync command
• --console option
  • using / The error log
• --control <port> option
  • about / Galera Load Balancer
• caches
  • about / MariaDB caches
  • InnoDB caches / InnoDB caches
  • MyISAM key cache / MyISAM key cache
  • Aria page cache / Aria page cache
  • query cache / The query cache explained
  • table open cache / The table open cache
  • per-session buffers / Per-session buffers
• cache stampede / The query cache explained
• Cacti / Diagnosing the buffer pool performance
• CassandraSE storage engine
  • about / Other engines
• change buffer
  • about / The InnoDB change buffer
  • configuring / The InnoDB change buffer
• CHANGE MASTER TO statement / Starting a slave
• CHARACTER SET clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• checksums, of binary log events
  • verifying / Checksums of the binary log events
• checksums, replication
  • calculating / Checking the replication for errors
  • CHECKSUM TABLE statement / The CHECKSUM TABLE statement
  • pt-table-checksum tool / The pt-table-checksum tool
  • files checksums, calculating / Files checksum
  • query checksum / Query checksum
• CHECKSUM TABLE statement
  • about / The CHECKSUM TABLE statement
• CHECK TABLE command
  • about / The general_log table
• CHECK TABLE statement
  • about / The CHECK TABLE statement
  • FOR UPGRADE function / The CHECK TABLE statement
  • CHANGED function / The CHECK TABLE statement
  • FAST function / The CHECK TABLE statement
  • QUICK function / The CHECK TABLE statement
  • MEDIUM function / The CHECK TABLE statement
  • EXTENDED function / The CHECK TABLE statement
• CIPHER 'str' option / Connecting MariaDB through Secure Socket Layer
• circular replication
  • about / An overview of replication
• clean pages
  • about / Dirty pages
• cold backup
  • about / Hot and cold backups
• COLUMNS keyword
  • about / The COLUMNS keyword
• COLUMNS keyword type
  • about / The COLUMNS keyword
• COLUMNS partitioning type
  • about / The COLUMNS keyword
• command-line client
  • about / The command-line client
• compression failure
  • about / Explaining the implementation of the InnoDB compression
• compression solutions
  • about / Other compression solutions
• CONCURRENT clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• configuration, MariaDB Galera Cluster
  • performing / Configuring the cluster
  • Galera system variables / Explaining the important Galera system variables
  • Generic cluster settings / Generic cluster settings
  • performance and stability settings / Performance and reliability
  • State Snapshot Transfer (SST) / Settings affecting the behavior of State Snapshot Transfer
  • settings, used for dealing limitations / Dealing with Galera limitations
  • wsrep parameters, setting / Setting the wsrep parameters
• CONNECT engine
  • used, for performing backup / Performing a backup using a CONNECT or CSV engine
  • about / Performing a backup using a CONNECT or CSV engine
• connections
  • monitoring / Monitoring connections
  • states, of process / States of the process
  • aborting / Aborting connections
• connection string / Creating a FEDERATEDX table
• CONNECT storage engine
  • about / Other engines, The FEDERATEDX and CONNECT storage engines
  • features / The FEDERATEDX and CONNECT storage engines
  • MYSQL CONNECT table, creating / Creating a MYSQL CONNECT table
  • SQL statements, sending to remote server / Sending SQL statements to a remote server
  • multiple CONNECT MYSQL tables, merging / Merging multiple CONNECT MYSQL tables
• consistent reads
  • about / Consistent reads
• CSV engine
  • about / Performing a backup using a CONNECT or CSV engine
  • used, for performing backup / Performing a backup using a CONNECT or CSV engine
• CSV format options
  • TABLE_TYPE / Performing a backup using a CONNECT or CSV engine
  • FILE_NAME / Performing a backup using a CONNECT or CSV engine
  • HUGE / Performing a backup using a CONNECT or CSV engine
  • COMPRESS / Performing a backup using a CONNECT or CSV engine
  • READONLY / Performing a backup using a CONNECT or CSV engine
  • DATA_CHARSET / Performing a backup using a CONNECT or CSV engine
  • SEP_CHAR / Performing a backup using a CONNECT or CSV engine
  • ENDING / Performing a backup using a CONNECT or CSV engine
  • QUOTED / Performing a backup using a CONNECT or CSV engine
  • QCHAR / Performing a backup using a CONNECT or CSV engine
  • HEADER / Performing a backup using a CONNECT or CSV engine
• CSV storage engine
  • about / Other engines
• CSV tables
  • repairing / Repairing CSV tables
• CURRENT_ROLE() function / Setting permissions using roles
• CURRENT_USER() function / User accounts
• custom errors
  • about / The custom errors
• Cygwin
  • URL / A troubleshooting example with the error log

D

• --daemon option
  • about / Galera Load Balancer
• --discovery option
  • about / Galera Load Balancer
• daemon facility
  • about / System logs
• database administrator (DBA)
  • about / Other engines, The custom errors
• data sharding
  • files, distributing between multiple disks / Distributing files between multiple disks
  • table files path, determining / Determining the path of table files
  • InnoDB logfiles / InnoDB logfiles
  • undo log, configuring / Configuring the undo log
  • redo log, configuring / Configuring the redo log
• DBMS compatibility / Compatibility with MySQL and other DBMS
• deadlocks
  • about / Deadlocks
  • solutions / Deadlocks
  • diagnosing / Deadlocks
  • example / Deadlocks
• debugging examples, with general query log
  • about / Debugging examples with the general query log
• DELETE statement
  • about / Locks used by various SQL statements
• Denial-Of-Service attack / Per-session buffers
• diagnostics area
  • about / The SHOW WARNINGS and SHOW ERRORS statements, The diagnostics area
  • statement information / The diagnostics area
  • condition information / The diagnostics area
  • example / The diagnostics area
• dirty pages
  • about / Dirty pages
  / InnoDB logfiles
• do table / Explaining the file-per-table mode
• doublewrite buffer
  • about / Explaining the doublewrite buffer
• dump file
  • about / Logical and physical backups
  • creating, with mysqldump / Creating a dump file with mysqldump
  • drawback / Creating a dump file with mysqldump
  • restoring / Creating a dump file with mysqldump

E

• @@expire_logs_days server variable
  • about / Rotating the binary log
• edit command / The command-line client
• Emacs editor / The command-line client
• error conditions
  • about / Understanding error conditions in MariaDB
  • error message / Understanding error conditions in MariaDB, The error message
  • SQLSTATE value / Understanding error conditions in MariaDB, The SQLSTATE value
  • error number / Understanding error conditions in MariaDB, The error number
  • custom errors / The custom errors
  • SHOW WARNINGS statement / The SHOW WARNINGS and SHOW ERRORS statements
  • SHOW ERRORS statement / The SHOW WARNINGS and SHOW ERRORS statements
• error log
  • about / The error log
  • file format / The error log format
  • troubleshooting example / A troubleshooting example with the error log
• error message
  • about / The error message
• error number
  • about / The error number
• exclusive lock mode, InnoDB
  • about / The lock modes
• EXPLAIN statement
  • about / Working with the EXPLAIN statement
  • working with / Working with the EXPLAIN statement
  • output, analyzing / Understanding the output of EXPLAIN
• extra_max_connections variable / Unblocking a blocked pool of threads
• extra_port variable / Unblocking a blocked pool of threads

F

• .frm files
  • about / Storage engines
• FEDERATED storage engine
  • about / Other engines
• FEDERATEDX storage engine
  • about / Other engines, The FEDERATEDX and CONNECT storage engines
  • features / The FEDERATEDX and CONNECT storage engines
  • FEDERATEDX table, creating / Creating a FEDERATEDX table
  • remote server link, defining / Defining a link to a remote server
• file-based logs
  • rotating / Rotating the file-based logs
• file per table mode
  • about / Explaining the file-per-table mode
  • enabling / Explaining the file-per-table mode
• files checksums
  • calculating / Files checksum
• fill factor
  • about / InnoDB pages
• FirstMatch strategy / Optimization of subqueries
• FIXED row format / MyISAM and Aria autorecovery
• FLUSH TABLES ... FOR EXPORT / Hot physical backups
• FLUSH TABLES ... WITH READ / Hot physical backups

G

• --general_log startup option
  • about / The general query log
• Galera arbitrator
  • about / The Galera arbitrator
• Galera Arbitrator Demon (garbd) binary
  • about / The Galera arbitrator
• Galera Cache (GCache) / Incremental State Transfer
• Galera Cluster Nagios plugin
  • about / Monitoring and troubleshooting
  • download link / Monitoring and troubleshooting
• galera package / Installation
• Galera URL
  • determining / Determining a node URL
  • gcomm schema / Determining a node URL
  • dummy schema / Determining a node URL
• general error
  • about / The SQLSTATE value
• general query log
  • about / The general query log
  • file format / The file format of the general query log
  • general_log table / The general_log table
  • debugging examples / Debugging examples with the general query log
• general_log table
  • about / The general_log table
  • event_time column / The general_log table
  • user_host column / The general_log table
  • thread_id column / The general_log table
  • server_id column / The general_log table
  • command_type column / The general_log table
  • argument column / The general_log table
• Generic cluster settings
  • wsrep_provider / Generic cluster settings
  • wsrep_cluster_address / Generic cluster settings
  • wsrep_cluster_name / Generic cluster settings
  • wsrep_node_address / Generic cluster settings
  • wsrep_node_name / Generic cluster settings
  • wsrep_on / Generic cluster settings
• GET DIAGNOSTICS statement
  • about / The GET DIAGNOSTICS statement
• GLB
  • about / Load balancing, Galera Load Balancer
  • download link / Galera Load Balancer
• GRANT statement
  • example / Setting permissions using roles
  / Authentication plugins

H

• --help option
  • about / Galera Load Balancer
• haon table / Explaining the file-per-table mode
• HASH and KEY partitions
  • modifying / Modifying HASH and KEY partitions
• HASH index type
  • about / Introducing indexes
• HASH partitioning type
  • about / The HASH and KEY types
• head
  • about / Old and new pages
• host_address variable
  • about / Galera Load Balancer
• hot backup
  • about / Hot and cold backups

I

• @@innodb_force_recovery command
  • about / Forcing data recovery
• idx_birth index
  • about / Simple SELECT statements
• IGNORE clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• incremental backups
  • about / Complete and incremental backups
• indexes
  • about / Introducing indexes
  • table statistics / Table statistics
  • storage engines / Storage engines and indexes
• index types
  • RTREE / Introducing indexes
  • HASH / Introducing indexes
  • BTREE / Introducing indexes
• information_schema database
  • about / The information_schema database
  • metadata tables / The information_schema database
  • status and variables tables / The information_schema database
  • privilege tables / The information_schema database
  • PROFILING table / The information_schema database
  • PROCESSLIST table / The information_schema database
  • InnoDB locks tables / The information_schema database
  • InnoDB buffer pool tables / The information_schema database
  • INNODB_METRICS table / The information_schema database
  • InnoDB compression tables / The information_schema database
  • InnoDB full-text tables / The information_schema database
  • InnoDB data dictionary tables / The information_schema database
• InnoDB
  • about / XtraDB and InnoDB
  • undo log / Logs
  • redo log / Logs
  • versus, ARCHIVE / Other compression solutions
• InnoDB buffer pool
  • about / MariaDB caches, The InnoDB buffer pool
  • new list / MariaDB caches
  • old list / MariaDB caches
  • change buffer / MariaDB caches, The InnoDB change buffer
  • old pages / Old and new pages
  • new pages / Old and new pages
  • buffer pool instances / Buffer pool instances
  • dirty pages / Dirty pages
  • read ahead optimization / The read ahead optimization
  • buffer pool performance, diagnosing / Diagnosing the buffer pool performance
  • dumping / Dumping and loading the buffer pool
  • loading / Dumping and loading the buffer pool
  • doublewrite buffer / Explaining the doublewrite buffer
• InnoDB buffer pool tables
  • about / The information_schema database
• InnoDB caches
  • about / InnoDB caches
  • InnoDB pages / InnoDB pages
  • InnoDB buffer pool / The InnoDB buffer pool
• InnoDB compressed tables
  • creating / Creating InnoDB compressed tables
• InnoDB compression
  • overview / An overview of the InnoDB compression
  • requirements / InnoDB compression requirements
  • file per table mode / Explaining the file-per-table mode
  • InnoDB file formats / A brief on InnoDB file formats
  • implementing / Explaining the implementation of the InnoDB compression
  • performance, monitoring / Monitoring the InnoDB compression performance
• InnoDB compression tables
  • about / The information_schema database
• InnoDB data dictionary tables
  • about / The information_schema database
• InnoDB data structures
  • about / InnoDB data structures
• InnoDB file formats
  • about / A brief on InnoDB file formats
• InnoDB full-text tables
  • about / The information_schema database
• InnoDB locks
  • about / The InnoDB locks
  • modes / The lock modes
  • types / Lock types
  • diagnosing / Diagnosing locks
  • used, by SQL statements / Locks used by various SQL statements
• InnoDB locks tables
  • about / The information_schema database
• InnoDB logfiles
  • about / InnoDB logfiles
• InnoDB pages
  • about / InnoDB pages
• InnoDB tables recovering
  • about / Recovering InnoDB tables
  • tables, checking / Checking tables
  • transaction logs / Transaction logs
  • data recovery, forcing / Forcing data recovery
• innodb_autoinc_lock_mode system variable
  • allowed values / Storage engines and indexes
• innodb_autoinc_lock_mode variable / Starting the nodes
• innodb_buffer_pool_instances variable
  • about / Buffer pool instances
• innodb_buffer_pool_size variable
  • about / Buffer pool instances
• INNODB_BUFFER_POOL_STATS table
  • about / Diagnosing the buffer pool performance
  • columns / Diagnosing the buffer pool performance
• innodb_change_buffering variable / The InnoDB change buffer
• innodb_change_buffer_max_size variable / The InnoDB change buffer
• INNODB_CMPMEM table
  • about / Monitoring the InnoDB compression performance, The INNODB_CMPMEM table
  • PAGE_SIZE column / The INNODB_CMPMEM table
  • BUFFER_POOL_INSTANCE column / The INNODB_CMPMEM table
  • PAGES_USED column / The INNODB_CMPMEM table
  • PAGES_FREE column / The INNODB_CMPMEM table
  • RELOCATION_OPS column / The INNODB_CMPMEM table
  • RELOCATION_TIME column / The INNODB_CMPMEM table
• INNODB_CMP table
  • about / Monitoring the InnoDB compression performance, The INNODB_CMP table
• INNODB_CMP_PER_INDEX table
  • about / Monitoring the InnoDB compression performance, The INNODB_CMP_PER_INDEX table
  • DATABASE_NAME column / The INNODB_CMP_PER_INDEX table
  • TABLE_NAME column / The INNODB_CMP_PER_INDEX table
  • INDEX_NAME column / The INNODB_CMP_PER_INDEX table
  • COMPRESS_OPS column / The INNODB_CMP_PER_INDEX table
  • COMPRESS_OPS_OK column / The INNODB_CMP_PER_INDEX table
  • COMPRESS_TIME column / The INNODB_CMP_PER_INDEX table
  • UNCOMPRESS_OPS column / The INNODB_CMP_PER_INDEX table
  • UNCOMPRESS_TIME column / The INNODB_CMP_PER_INDEX table
• innodb_flush_neighbors variable
  • about / Old and new pages
• INNODB_LOCKS table
  • LOCK_ID columns / Diagnosing locks
  • LOCK_TRX_ID column / Diagnosing locks
  • LOCK_MODE column / Diagnosing locks
  • LOCK_TYPE column / Diagnosing locks
  • LOCK_TABLE column / Diagnosing locks
  • LOCK_INDEX column / Diagnosing locks
  • LOCK_SPACE column / Diagnosing locks
  • LOCK_PAGE column / Diagnosing locks
  • LOCK_REC column / Diagnosing locks
  • LOCK_DATA column / Diagnosing locks
• INNODB_LOCK_WAITS table
  • REQUESTING_TRX_ID column / Diagnosing locks
  • REQUESTED_LOCK_ID column / Diagnosing locks
  • BLOCKING_TRX_ID column / Diagnosing locks
  • BLOCKING_LOCK_ID column / Diagnosing locks
• innodb_max_dirty_pages_pct variable
  • about / Old and new pages
• INNODB_METRICS table
  • about / The information_schema database
• innodb_old_blocks_pct variable
  • about / Old and new pages
• innodb_old_blocks_time variable
  • about / Old and new pages
• INNODB_TRX table
  • about / Diagnosing locks
• INSERT ... SELECT statement
  • about / Locks used by various SQL statements
• INSERT statement
  • about / Locks used by various SQL statements
• INTO TABLE clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• isolation levels, transactions
  • about / Transactions isolation levels
  • READ UNCOMMITTED isolation level / The READ UNCOMMITTED isolation level
  • READ COMMITTED isolation level / The READ COMMITTED isolation level
  • REPEATABLE READ isolation level / The REPEATABLE READ isolation level
  • SERIALIZABLE isolation level / The SERIALIZABLE isolation level
• ISSUER 'str'option / Connecting MariaDB through Secure Socket Layer

J

• JIRA
  • about / MariaDB resources
  • URL / MariaDB resources
• join_buffer_size variable / Per-session buffers

K

• key buffer / MyISAM key cache
• key cache / MyISAM key cache
• KEY partitioning type
  • about / The HASH and KEY types
• key_buffer_size server variable / MyISAM key cache
• KEY_CACHE table
  • about / Key cache instances
  • columns / Key cache instances
• KILL statement / Aborting connections

L

• --log-error option
  • using / The error log
• --log-output option
  • about / The general query log
• -l option / Incremental physical backups with the rsync command
• @@log_bin variable / Configuring a new replication master
• Last Recently Used (LRU) algorithm / Old and new pages
• less pager / The command-line client
• life cycle, transactions
  • about / The transactions life cycle
• LINEAR HASH
  • about / The LINEAR keyword
• LINEAR KEY partitioning types
  • about / The LINEAR keyword
• LINEAR keyword
  • about / The LINEAR keyword
• LIST COLUMNS type
  • about / The COLUMNS keyword
• LIST partitioning type
  • about / The LIST type
• load balancing, Galera Cluster
  • about / Load balancing
• LOAD DATA INFILE statement
  • used, for loading dump file / Loading a dump file with the LOAD DATA INFILE statement
• LOCAL clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• lock
  • about / The InnoDB locks
• lock commits / The InnoDB locks
• locking reads
  • about / Locking reads
• lock modes, InnoDB
  • about / The lock modes
  • shared / The lock modes
  • exclusive / The lock modes
• LOCK TABLES option
  • about / The general_log table
• lock types, InnoDB
  • table-level locks / Lock types
  • record-level locks / Lock types
• Log's flushing
  • about / The file format of the general query log
• logical backup
  • about / Logical and physical backups
  • pros / Logical and physical backups
• logs
  • error log / Logs
  • SQL_ERROR_LOG / Logs
  • general query log / Logs
  • slow query logs / Logs
  • binary log (binlog) / Logs
  • relay log / Logs
  • about / Logs
• log_slow_filter variable
  • allowed values / The slow query log
• log_slow_verbosity
  • allowed values / The slow query log
• LooseScan / Optimization of subqueries
• LOW_PRIORITY clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• LUSH TABLES WITH READ LOCK option
  • about / The general_log table
• lv pager / The command-line client

M

• --max_con <number> option
  • about / Galera Load Balancer
• maintenance operations statements
  • about / Maintenance operations statements
• MariaDB
  • about / The MariaDB architecture
  • architecture / The MariaDB architecture
  • logs / Logs
  • caches / MariaDB caches
  • authentication / Authentication and security
  • security / Authentication and security
  • compatibility, with MySQL / Compatibility with MySQL and other DBMS
  • compatibility, with DBMS / Compatibility with MySQL and other DBMS
  • resources / MariaDB resources
  • error conditions / Understanding error conditions in MariaDB
  • user accounts / User accounts
  • connecting, through Secure Socket Layer / Connecting MariaDB through Secure Socket Layer
• mariadb-galera-server package / Installation
• MariaDB Error Codes
  • reference link / The custom errors
• MariaDB Foundation blog
  • URL / MariaDB resources
• MariaDB Galera Cluster
  • key concepts / MariaDB Galera Cluster key concepts
  • URL / MariaDB Galera Cluster key concepts
  • documentation, for MySQL / MariaDB Galera Cluster key concepts
  • overview / An overview of Galera Cluster
  • synchronous replication / Synchronous replication
  • setting up / Setting up a cluster
  • requisites / Requirements
  • installing / Installation
  • nodes, starting / Starting the nodes
  • configuring / Configuring the cluster
  • troubleshooting / Monitoring and troubleshooting
  • monitoring / Monitoring and troubleshooting
  • load balancing / Load balancing
  • limitations / Listing the limitations of Galera Cluster
  • GLB / Galera Load Balancer
• MariaDB Galera Cluster node
  • starting / Starting the nodes
  • options / Starting the nodes
  • node URL, determining / Determining a node URL
  • node provisioning / Node provisioning
  • split brain problem / The split brain problem
• MariaDB KB
  • URL / MariaDB resources
• master log
  • about / Slave logs
• max_binlog_size server variable
  • about / Rotating the binary log
• MAX_CONNECTIONS_PER_HOUR limit / Authentication plugins
• max_error_count system variable
  • about / The diagnostics area
• MAX_QUERIES_PER_HOUR limit / Authentication plugins
• max_relay_log_size server variable
  • about / Rotating the relay log
• MAX_UPDATES_PER_HOUR limit / Authentication plugins
• MAX_USER_CONNECTIONS limit / Authentication plugins
• memcache / Compatibility with MySQL and other DBMS
• metadata locks
  • about / Metadata locks
• metadata tables
  • about / The information_schema database
• METADATA_LOCK_INFO table
  • THREAD_ID column / Metadata locks
  • LOCK_MODE column / Metadata locks
  • LOCK_DURATION column / Metadata locks
  • LOCK_TYPE column / Metadata locks
  • TABLE_SCHEMA column / Metadata locks
  • TABLE_NAME column / Metadata locks
• midpoint
  • about / Old and new pages
• miss storm / The query cache explained
• MIXED binary logging format
  • about / The MIXED binary logging format
• modification log
  • about / Explaining the implementation of the InnoDB compression
• monitoring, MariaDB Galera Cluster
  • performing / Monitoring and troubleshooting
  • notification scripts / Notification scripts
  • status variables, checking / Checking the status variables
• more pager / The command-line client
• MRG_MyISAM storage engine
  • about / MyISAM and Aria
• mroonga storage engine
  • about / Other engines
• multiple CONNECT MYSQL tables
  • merging / Merging multiple CONNECT MYSQL tables
• multisource replication
  • about / An overview of replication, Multisource replication
• MyISAM
  • about / MyISAM and Aria, Other compression solutions
  • data file / MyISAM and Aria
  • index file / MyISAM and Aria
  • FIXED data format / MyISAM and Aria
  • DYNAMIC data format / MyISAM and Aria
  • COMPRESSED data format / MyISAM and Aria
• MyISAM autorecovery
  • about / MyISAM and Aria autorecovery
  • values / MyISAM and Aria autorecovery
• myisamchk and aria_chk tools
  • used, for repairing tables / Repairing tables with the myisamchk and aria_chk tools
  • --check option / Repairing tables with the myisamchk and aria_chk tools
  • --force option / Repairing tables with the myisamchk and aria_chk tools
  • --repair option / Repairing tables with the myisamchk and aria_chk tools
  • --analyze option / Repairing tables with the myisamchk and aria_chk tools
  • options / Repairing tables with the myisamchk and aria_chk tools
• MyISAM format
  • about / The general_log table
• MyISAM key cache
  • about / MyISAM key cache
  • LRU algorithm, using / LRU and the midpoint insertion strategy
  • midpoint insertion strategy / LRU and the midpoint insertion strategy
  • key cache instances / Key cache instances
  • segmented key cache / Segmented key cache
  • indexes, preloading / Preloading indexes into the cache
• mylvmbackup utility / Filesystem snapshots
• mysql.server script / The MariaDB architecture
• mysqlbinlog command
  • sbout / Using the binary log for incremental backups
• mysqlbinlog tool
  • about / The general query log
• mysql command-line client / The command-line client
• MySQL compatibility / Compatibility with MySQL and other DBMS
• MYSQL CONNECT table
  • creating / Creating a MYSQL CONNECT table
• mysqldump command
  • used, for creating dump file / Creating a dump file with mysqldump
  • about / Creating a dump file with mysqldump
• mysqld_safe script / The MariaDB architecture
• mysql_native_password plugin
  • about / Authentication plugins
• mysql_old_password plugin
  • about / Authentication plugins

N

• --nodelay option
  • about / Galera Load Balancer
• Nagios / Diagnosing the buffer pool performance
• node provisioning, Galera Cluster
  • about / Node provisioning
  • methods / Node provisioning
  • State Snapshot Transfer (SST) / Node provisioning, State Snapshot Transfer
  • Incremental State Transfer (IST) / Node provisioning, Incremental State Transfer
• node_list variable
  • about / Galera Load Balancer
• non-InnoDB tables
  • repairing / Repairing non-InnoDB tables
  • CHECK TABLE statement / The CHECK TABLE statement
  • REPAIR TABLE statement / The REPAIR TABLE statement
  • CSV tables, repairing / Repairing CSV tables
  • tables, repairing with myisamchk and aria_chk tools / Repairing tables with the myisamchk and aria_chk tools
  • MyISAM autorecovery / MyISAM and Aria autorecovery
  • Aria autorecovery / MyISAM and Aria autorecovery
• non-repeatable reads
  • about / The non-repeatable reads
• NONE option / Connecting MariaDB through Secure Socket Layer
• not found conditions
  • about / The SQLSTATE value
• notification script
  • command parameter / Notification scripts
  • new_status parameter / Notification scripts
  • state_UUID parameter / Notification scripts
  • --primary parameter / Notification scripts
  • members_list parameter / Notification scripts

O

• --outliers option / Explaining the pt-query-digest command from Percona Toolkit
• one thread per connection / Authentication plugins
• On Line Transaction Processing (OLTP) / Authentication plugins
• OpenQuery
  • about / Other engines
• OpenSSL / Connecting MariaDB through Secure Socket Layer
• OPTIMIZE TABLE command
  • about / The general_log table
• OQGRAPH storage engine
  • about / Other engines
• outliers / Explaining the pt-query-digest command from Percona Toolkit
• output, EXPLAIN command
  • analyzing / Understanding the output of EXPLAIN
  • id column / Understanding the output of EXPLAIN
  • select_type column / Understanding the output of EXPLAIN
  • table column / Understanding the output of EXPLAIN
  • partitions column / Understanding the output of EXPLAIN
  • type column / Understanding the output of EXPLAIN
  • possible_key column / Understanding the output of EXPLAIN
  • key column / Understanding the output of EXPLAIN
  • key_len column / Understanding the output of EXPLAIN
  • ref column / Understanding the output of EXPLAIN
  • rows column / Understanding the output of EXPLAIN
  • filtered column / Understanding the output of EXPLAIN
  • Extra column / Understanding the output of EXPLAIN
  • Simple SELECT statements / Simple SELECT statements
  • internal temporary files / Internal temporary tables or files
  • internal temporary tables / Internal temporary tables or files
  • UNION queries / The UNION queries
  • index access methods / Simple index access methods
  • JOIN clause index optimizations / Index optimizations of the JOIN clause
  • subqueries optimization / Optimization of subqueries
• overflow pages
  • about / An overview of the InnoDB compression
• overlow pages
  • about / InnoDB pages

P

• --progress option / Incremental physical backups with the rsync command
• page cache
  • about / Aria page cache
• page cleaner
  • about / Dirty pages
• pager program / The command-line client
• pam plugin
  • about / Authentication plugins
• parallel replication
  • about / Parallel replication
• partitioned columns list
  • about / The COLUMNS keyword
• partitioned tables
  • administering / Administering partitioned tables
  • information, obtaining / Obtaining information about partitions
  • partitions definition, changing / Changing partitions' definitions
  • RANGE and LIST partitions, modifying / Modifying RANGE and LIST partitions
  • HASH and KEY partitions, modifying / Modifying HASH and KEY partitions
  • data, copying between partition and table / Copying data between a partition and a table
  • maintenance operations statements / Maintenance operations statements
• partitioning expression
  • about / Partitioning expressions
  • TO_SECONDS() function / Partitioning expressions
  • YEAR() function / Partitioning expressions
  • MONTH() function / Partitioning expressions
  • TO_DAYS() function / Partitioning expressions
• partitioning types
  • about / Partitioning types and expressions, Partitioning types
  • RANGE / The RANGE type
  • LIST / The LIST type
  • COLUMNS keyword / The COLUMNS keyword
  • HASH / The HASH and KEY types
  • KEY / The HASH and KEY types
  • LINEAR keyword / The LINEAR keyword
• partition pruning
  • about / Query optimizations, Partition pruning
• partition selecting
  • about / Query optimizations
• partition selection
  • about / Partition selection
• partitions physical files
  • about / Partitions' physical files
• PARTITIONS table
  • columns / Obtaining information about partitions
• partition_list variable
  • about / Partition selection
• PASSWORD() function / User accounts
  • about / The HASH and KEY types
• per-session buffers
  • about / Per-session buffers
  • configuring / Per-session buffers
• Percona Toolkit project
  • pt-query-digest command / Explaining the pt-query-digest command from Percona Toolkit
• Percona XtraBackup
  • about / Percona XtraBackup
  • URL / Percona XtraBackup
  • backups, performing / Performing backups
  • complete backup, creating / Complete backups
  • partial backups / Partial backups
  • backups, preparing / Preparing backups
  • complete backups, preparing / Preparing complete backups
  • partial backups, preparing / Preparing partial backups
  • backups, restoring / Restoring backups
  • complete backups, restoring / Restoring complete backups
  • partial backups, restoring / Restoring partial backups
• performance and stability settings, Galera Cluster
  • wsrep_data_home_dir / Performance and reliability
  • wsrep_slave_threads / Performance and reliability
  • wsrep_causal_reads / Performance and reliability
  • wsrep_max_ws_size setd / Performance and reliability
  • wsrep_max_ws_rows / Performance and reliability
  • wsrep_retry_autocommit / Performance and reliability
  • wsrep_load_data_splitting / Performance and reliability
• performance_schema database
  • about / The performance_schema database
• performance_schema setup table
  • events_statements_ / The performance_schema database
  • events_stages_ / The performance_schema database
  • *_instances_ / The performance_schema database
  • events_waits_ / The performance_schema database
• performance_schema storage engine
  • about / Other engines
• performance_schema variable
  • about / The performance_schema database
  • actor / The performance_schema database
  • consumers / The performance_schema database
  • instruments / The performance_schema database
  • objects / The performance_schema database
• permissions
  • setting, roles used / Setting permissions using roles
• phantom rows
  • about / Phantom rows
• physical backup
  • pros / Logical and physical backups
  • about / Physical backups
  • performing / Which files should be copied?
  • table files / Table files
  • logfiles / Logfiles
  • configuration files / Configuration files
  • hot physical backups / Hot physical backups
  • filesystem snapshots / Filesystem snapshots
  • incremental physical backups, with rsync command / Incremental physical backups with the rsync command
  • data, copying between running servers / Copying files when the server is running
  • backup tablespace, creating / Copying files when the server is running
  • backup tablespace, restoring / Copying files when the server is running
• Planet MariaDB
  • URL / MariaDB resources
• pool of threads
  • about / Authentication plugins
  • activating / Activating the pool of threads
  • monitoring / Monitoring the pool of threads
  • threadpool_threads variable / Monitoring the pool of threads
  • threadpool_idle_threads variable / Monitoring the pool of threads
  • configuring, on Unix / Configuring the pool of threads on Unix
  • configuring, on Windows / Configuring the pool of threads on Windows
  • unblocking / Unblocking a blocked pool of threads
• privilege tables
  • about / The information_schema database
• PROCESSLIST table
  • about / The information_schema database
  • columns / Monitoring connections
  • COMMAND column, values / Monitoring connections
  • STATE column, values / States of the process
• PROFILING table
  • about / The information_schema database
• pt-query-digest command
  • about / Explaining the pt-query-digest command from Percona Toolkit
  • using / Explaining the pt-query-digest command from Percona Toolkit
  • example / Explaining the pt-query-digest command from Percona Toolkit
• pt-schema-change
  • about / Metadata locks
• pt-table-checksum tool
  • about / The pt-table-checksum tool
• PURGE BINARY LOGS statement
  • about / Rotating the binary log

Q

• query cache
  • about / The query cache explained
  • enabling / The query cache explained
  • enabling, on demand / The query cache explained
  • configuring / Configuring the query cache
  • status information / Information on the status of the query cache
  • subquery cache / Explaining the subquery cache
  • alternative query caching methods / Alternative query caching methods
• query cache configuration
  • query_cache_type / Configuring the query cache
  • query_cache_size / Configuring the query cache
  • query_cache_alloc_block_size / Configuring the query cache
  • query_cache_limit / Configuring the query cache
  • query_cache_strip_comments / Configuring the query cache
• query caching methods
  • about / Alternative query caching methods
• query checksum
  • calculating / Query checksum
• query optimizations
  • partition pruning / Query optimizations
  • partition selecting / Query optimizations
• query_cache_alloc_block_size variable / Configuring the query cache
• QUERY_CACHE_INFO table
  • about / Information on the status of the query cache
  • STATEMENT_SCHEMA column / Information on the status of the query cache
  • STATEMENT_TEXT column / Information on the status of the query cache
  • RESULT_BLOCKS_COUNT column / Information on the status of the query cache
  • RESULT_BLOCKS_SIZE column / Information on the status of the query cache
  • RESULT_BLOCKS_SIZE_USED column / Information on the status of the query cache
• query_cache_limit variable / Configuring the query cache
• query_cache_size variable / Configuring the query cache
• query_cache_strip_comments variable / Configuring the query cache
• query_cache_type variable / Configuring the query cache

R

• --random option
  • about / Galera Load Balancer
• --round option
  • about / Galera Load Balancer
• -r option / Incremental physical backups with the rsync command
• @@replicate_skip_db variable / Filtering the replication of events on the slaves
• @@replicate_skip_table variable / Filtering the replication of events on the slaves
• @@replicate_wild_skip_tables variable / Filtering the replication of events on the slaves
• random read ahead
  • about / The read ahead optimization
• range / Simple index access methods
• RANGE and LIST partitions
  • modifying / Modifying RANGE and LIST partitions
• RANGE COLUMNS type
  • about / The COLUMNS keyword
• RANGE partitioning type
  • about / The RANGE type
• read ahead
  • about / The read ahead optimization
  • linear read ahead / The read ahead optimization
  • random read ahead / The read ahead optimization
• READ COMMITTED isolation level
  • about / The READ COMMITTED isolation level
• reads
  • consistency / Reads consistency
  • non-repeatable reads / The non-repeatable reads
  • phantom rows / Phantom rows
  • consistent reads / Consistent reads
  • locking reads / Locking reads
• READ UNCOMMITTED isolation level
  • about / The READ UNCOMMITTED isolation level
• read_buffer_size variable / Per-session buffers
• read_rnd_buffer_size variable / Per-session buffers
• record-level locks
  • about / Lock types
  • record lock / Lock types
  • next-key lock / Lock types
  • gap lock / Lock types
• redo log
  • about / Logs
  • configuring / Configuring the redo log
  • @@innodb_log_group_log_dir variable / Configuring the redo log
  • @@innodb_log_files_in_group variable / Configuring the redo log
  • @@innodb_log_file_size variable / Configuring the redo log
• relay log
  • about / Slave logs, Rotating the relay log
  • rotating / Rotating the relay log
• remote
  • about / Creating a FEDERATEDX table
• Remote Secure Access (RSA) authentication / Connecting MariaDB through Secure Socket Layer
• REORGANIZE command / Modifying RANGE and LIST partitions
• REPAIR TABLE command
  • about / The general_log table
• REPAIR TABLE statement
  • about / The REPAIR TABLE statement
• REPEATABLE READ isolation level
  • about / The REPEATABLE READ isolation level
• REPLACE clause
  • about / Loading a dump file with the LOAD DATA INFILE statement
• replication
  • overview / An overview of replication
  • binary log / An overview of replication
  • working / How replication works
  • threads / Replication threads
  • parallel replication / Parallel replication
  • slave logs / Slave logs
  • binary log format, selecting / Choosing a binary log format
  • configuring / Configuring replication
  • multisource replication / Multisource replication
  • logs / Replication logs
  • checking, for errors / Checking the replication for errors
  • troubleshooting / Troubleshooting
• replication configuration
  • performing / Configuring replication
  • replication master, configuring / Configuring a new replication master
  • replication slave, configuring / Configuring a new replication slave
  • slave, starting / Starting a slave
  • running slave threads, checking / Checking whether a slave is running
  • existing slave, reconfiguring / Reconfiguring an existing slave
  • data, importing into master / Importing the data into a master
  • data, importing into slave from master / Importing the data into a slave from a master
  • data, dumping from master / Dumping data from a master
  • data, dumping from slave / Dumping data from a slave
  • binary log events, filtering / Filtering binary log events
  • replication of events, filtering on slaves / Filtering the replication of events on the slaves
  • checksums of binary log events, verifying / Checksums of the binary log events
  • parallel replication, configuring / Configuring parallel replication
  • slave, delaying / Delaying a slave
• replication logs
  • about / Replication logs
  • binary log, rotating / Rotating the binary log
  • relay log, rotating / Rotating the relay log
  • slave status logs / The slave status logs
• replication threads
  • about / Replication threads
  • Binlog dump thread / Replication threads
  • SQL I/O thread / Replication threads
  • Slave SQL thread / Replication threads
• repository, for wsrep project
  • URL / Synchronous replication
• resources, MariaDB
  • reference links / MariaDB resources
• REVOKE statement
  • example / Setting permissions using roles
• roles
  • used, for setting permissions / Setting permissions using roles
• rolls back / The InnoDB locks
• row-based binary logging
  • about / Row-based binary logging
  • advantages / Row-based binary logging
• row-based replication / An overview of replication
• rsync command
  • used, for incremental physical backups / Incremental physical backups with the rsync command
  • about / Incremental physical backups with the rsync command
• RTREE index type
  • about / Introducing indexes

S

• --single option
  • about / Galera Load Balancer
• --source option
  • about / Galera Load Balancer
• --stats option / Incremental physical backups with the rsync command
• @@server_id variable / Configuring a new replication master
• @@skip_replication variable
  • about / The @@skip_replication variable
  • REPLICATE value / The @@skip_replication variable
  • FILTER_ON_SLAVE value / The @@skip_replication variable
  • FILTER_ON_MASTER value / The @@skip_replication variable
• @@slave_domain_parallel_threads variable / Configuring parallel replication
• @@slave_parallel_max_queued variable / Configuring parallel replication
• @@slave_parallel_threads
  • about / Parallel replication
  / Parallel replication
• @@slave_parallel_threads server variable / Configuring parallel replication
• safe place
  • about / Securing backups
• Secure Hash Algorithm (SHA) hashing / Connecting MariaDB through Secure Socket Layer
• Secure Socket Layer
  • MariaDB, connecting through / Connecting MariaDB through Secure Socket Layer
• Secure Socket Layer (SSL) connection / Connecting MariaDB through Secure Socket Layer
• security, MariaDB
  • about / Authentication and security
• segmented key cache
  • about / Segmented key cache
• SELECT ... INTO DUMPFILE statement / Creating a text-delimited file with the SELECT … INTO OUTFILE command
• SELECT ... INTO OUTFILE command
  • used, for creating text-delimited file / Creating a text-delimited file with the SELECT … INTO OUTFILE command
• SELECT query / The command-line client
• SELinux
  • about / Installation
  • disabling / Installation
• SEQUENCE storage engine
  • about / Other engines
• SERIALIZABLE isolation level
  • about / The SERIALIZABLE isolation level
• server logs maintenance
  • about / Maintenance of the server logs
  • logs, flushing / Flushing logs
  • file-based logs, rotating / Rotating the file-based logs
  • table-based logs, rotating / Rotating the table-based logs
• SET SQL_LOG_BIN statement
  • about / The SET SQL_LOG_BIN statement
• settings, for dealing Galera limitations
  • wsrep_replicate_myisam / Dealing with Galera limitations
  • wsrep_convert_LOCK_to_trx / Dealing with Galera limitations
  • wsrep_certify_nonPK / Dealing with Galera limitations
• shared lock mode, InnoDB
  • about / The lock modes
• SHOW BINARY LOGS statement / Using the binary log for incremental backups
• SHOW COUNT(*) ERRORS statement
  • about / The SHOW WARNINGS and SHOW ERRORS statements
  • example / The SHOW WARNINGS and SHOW ERRORS statements
• SHOW COUNT(*) WARNINGS statement
  • example / The SHOW WARNINGS and SHOW ERRORS statements
• SHOW COUNT(*) WARNING statement
  • about / The SHOW WARNINGS and SHOW ERRORS statements
• SHOW CREATE TABLE command
  • used, for dumping table definition / Dumping a table definition with the SHOW CREATE TABLE command
• SHOW ENGINE INNODB STATUS statement / Diagnosing locks
• SHOW ERRORS statement
  • about / The SHOW WARNINGS and SHOW ERRORS statements
• SHOW MASTER STATUS statement / Using the binary log for incremental backups
• SHOW PROCESSLIST statement / Monitoring connections
• SHOW WARNINGS statement
  • about / The SHOW WARNINGS and SHOW ERRORS statements
• simple SELECT statement
  • about / Simple SELECT statements
• slave logs, replication
  • about / Slave logs
  • relay log / Slave logs
  • master log / Slave logs
• slave relay log / Replication threads
• Slave SQL thread / Replication threads
• slave status logs
  • about / The slave status logs
• slow query log
  • about / The slow query log
  • file format / The file format of the slow query log
  • Time / The file format of the slow query log
  • User@Host / The file format of the slow query log
  • Thread_id / The file format of the slow query log
  • QC_hit / The file format of the slow query log
  • slow_log table / The slow_log table
• slow_log table
  • about / The slow_log table
  • start_time column / The slow_log table
  • user_host column / The slow_log table
  • query_time column / The slow_log table
  • lock_time column / The slow_log table
  • rows_sent column / The slow_log table
  • rows_examined column / The slow_log table
  • db column / The slow_log table
  • last_insert_id column / The slow_log table
  • insert_id column / The slow_log table
  • server_id column / The slow_log table
  • sql_text column / The slow_log table
  • thread_id column / The slow_log table
• sort_buffer_size variable / Per-session buffers
• SphinxSE storage engine
  • about / Other engines
• SPIDER storage engine
  • about / Other engines, The SPIDER storage engine
  • URL / The SPIDER storage engine
  • working / Explaining the working of the SPIDER storage engine
  • installing / Installing the SPIDER storage engine
  • SPIDER table, creating / Creating a SPIDER table
  • queries, logging / Logging of queries and errors
  • errors, logging / Logging of queries and errors
  • arbitrary statements, executing on remote servers / Executing arbitrary statements on remote servers
• spider_bg_direct_sql() function
  • about / Explaining the spider_bg_direct_sql() function
  • syntax / Explaining the spider_bg_direct_sql() function
• spider_direct_sql() function
  • about / Explaining the spider_direct_sql() function
  • parameters / Explaining the spider_direct_sql() function
• split brain problem, Galera Cluster
  • about / The split brain problem
  • arbitrator / The Galera arbitrator
• SQL I/O thread / Replication threads
• SQLSTATE value
  • about / The SQLSTATE value
• SQL_ERROR_LOG plugin
  • about / The SQL_ERROR_LOG plugin
  • variables / The SQL_ERROR_LOG plugin
  • used, for debugging stored programs / Debugging stored programs using the SQL_ERROR_LOG plugin
• SSL option / Connecting MariaDB through Secure Socket Layer
• statement-based binary logging
  • about / Statement-based binary logging
  • non-deterministic functions / Statement-based binary logging
• statement-based replication / An overview of replication
• statement information, diagnostics area
  • about / The diagnostics area
  • NUMBER / The diagnostics area
  • ROW_COUNT / The diagnostics area
• State Snapshot Transfer (SST)
  • about / State Snapshot Transfer
  • mysqldump method / State Snapshot Transfer
  • rsync tool / State Snapshot Transfer
  • rsync_wan tool / State Snapshot Transfer
  • xtrabackup tool / State Snapshot Transfer
• State Snapshot Transfer (SST) settings
  • wsrep_sst_donor / Settings affecting the behavior of State Snapshot Transfer
  • wsrep_sst_donor_rejects_queries / Settings affecting the behavior of State Snapshot Transfer
  • wsrep_sst_method / Settings affecting the behavior of State Snapshot Transfer
  • wsrep_sst_auth / Settings affecting the behavior of State Snapshot Transfer
• status and variables tables
  • about / The information_schema database
• status variables, Galera Cluster
  • checking / Checking the status variables
  • cluster health, checking / Checking the status variables, The health of a cluster
  • individual node health, checking / Checking the status variables, Individual node health
  • replication health, checking / Checking the status variables, The health of a replication
  • network performance, checking / Checking the status variables, Network performance
• storage engines
  • about / Storage engines, Storage engines and indexes
  • XtraDB / XtraDB and InnoDB
  • InnoDB / XtraDB and InnoDB
  • TokuDB / TokuDB, Other compression solutions
  • MyISAM / MyISAM and Aria, Other compression solutions
  • Aria / MyISAM and Aria
  • OQGRAPH / Other engines
  • BLACKHOLE / Other engines
  • SPIDER / Other engines
  • CONNECT / Other engines
  • ARCHIVE / Other engines, Other compression solutions
  • CassandraSE / Other engines
  • SphinxSE / Other engines
  • mroonga / Other engines
  • SEQUENCE / Other engines
  • performance_schema / Other engines
• stored programs
  • debugging tips / Tips on debugging stored programs
  • debugging, SQL_ERROR_LOG plugin used / Debugging stored programs using the SQL_ERROR_LOG plugin
• SUBJECT 'str' option / Connecting MariaDB through Secure Socket Layer
• subquery cache
  • about / Explaining the subquery cache
• superuser
  • about / The general query log
• synchronous replication, Galera Cluster
  • about / Synchronous replication
• SYSDATE() function / Statement-based binary logging
• system log (syslog)
  • about / System logs

T

• --threads <number> option
  • about / Galera Load Balancer
• --top option
  • about / Galera Load Balancer
• -t option / Incremental physical backups with the rsync command
• <table_list> variable / Merging multiple CONNECT MYSQL tables
• table-based logs
  • rotating / Rotating the table-based logs
• table-level locks
  • about / Lock types
• table files path
  • determining / Determining the path of table files
• table open cache
  • about / The table open cache
• table partitioning
  • support / Support for partitioning
  • partitioning expression / Partitioning types and expressions
  • partitioning type / Partitioning types and expressions
  • indexes / Indexes and primary keys
  • primary keys / Indexes and primary keys
  • partition names / Partition names
  • partitioning types / Partitioning types
  • subpartitions, splitting into / Splitting into subpartitions
• table pullout / Optimization of subqueries
• tables, repairing
  • about / Repairing tables
  • InnoDB tables recovering / Recovering InnoDB tables
  • non-InnoDB tables, repairing / Repairing non-InnoDB tables
• tablespaces
  • about / Explaining the file-per-table mode
• table_open_cache server variable
  • about / The table open cache
• text-delimited backups
  • about / Delimited text backups
  • creating / Delimited text backups
  • --tab option, of mysqldump command / The --tab option of the mysqldump command
  • dump file, loading with mysqlimport command / Loading a dump file with the mysqlimport command
  • creating, with SELECT … INTO OUTFILE command / Creating a text-delimited file with the SELECT … INTO OUTFILE command
  • table definition, dumping with SHOW CREATE TABLE command / Dumping a table definition with the SHOW CREATE TABLE command
  • dump file, loading with LOAD DATA INFILE statement / Loading a dump file with the LOAD DATA INFILE statement
  • line separators options / Separator options and clauses
  • line clauses / Separator options and clauses
  • dump files, creating / An example to create and restore dump files
  • dump files, restoring / An example to create and restore dump files
  • performing, CSV engine used / Performing a backup using a CONNECT or CSV engine
  • performing, CONNECT engine used / Performing a backup using a CONNECT or CSV engine
• text limited backup
  • restoring / Delimited text backups
• threadpool_idle_threads variable / Monitoring the pool of threads
• threadpool_threads variable / Monitoring the pool of threads
• thread_pool_idle_timeout variable / Configuring the pool of threads on Unix
• thread_pool_max_threads variable / Configuring the pool of threads on Unix, Configuring the pool of threads on Windows
• thread_pool_min_threads variable / Configuring the pool of threads on Windows
• thread_pool_oversubscribe variable / Configuring the pool of threads on Unix
• thread_pool_size variable / Configuring the pool of threads on Unix
• thread_pool_stall_limit variable / Configuring the pool of threads on Unix
• TokuDB
  • about / TokuDB, Other compression solutions
• transactions
  • about / Transactions
  • life cycle / The transactions life cycle
  • isolation levels / Transactions isolation levels
  • access modes / Transactions access modes
• transportable tablespaces
  • about / Copying files when the server is running
  • limitations / Copying files when the server is running
• tri table / Explaining the file-per-table mode
• troubleshooting, replication errors
  • performing / Troubleshooting
  • slave does not start / A slave does not start
  • slave lags behind / A slave lags behind
• troubleshooting example, with error log
  • about / A troubleshooting example with the error log

U

• undo log
  • about / Logs
  • configuring / Configuring the undo log
  • @@innodb_undo_directory variable / Configuring the undo log
  • @@innodb_undo_tablespaces variable / Configuring the undo log
• UNION queries / The UNION queries
• Universally Unique Identifier (UUID) / Notification scripts
• Unix Pluggable Authentication Modules (PAM) / Authentication plugins
• unix_socket plugin
  • about / Authentication plugins
• UPDATE statement
  • about / Locks used by various SQL statements
• USAGE command / Authentication plugins
• USER() function / User accounts
• user accounts
  • about / User accounts
• User Defined Functions (UDFs) / Executing arbitrary statements on remote servers
• USE_FRM command
  • about / The REPAIR TABLE statement

V

• --version option
  • about / Galera Load Balancer
• variables, SQL_ERROR_LOG plugin
  • sql_error_log_filename / The SQL_ERROR_LOG plugin
  • sql_error_log_rate / The SQL_ERROR_LOG plugin
  • sql_error_log rotate / The SQL_ERROR_LOG plugin
  • sql_error_log_rotations / The SQL_ERROR_LOG plugin
  • sql_error_log_size_limit / The SQL_ERROR_LOG plugin
• vi editor / The command-line client
• virtually synchronous replication / Synchronous replication

W

• Wide Area Network (WAN) / State Snapshot Transfer
• Windows Event Log
  • about / System logs
• working set
  • about / The InnoDB buffer pool
• wsrep parameters
  • base_host / Setting the wsrep parameters
  • base_port / Setting the wsrep parameters
  • evs.inactive_timeout / Setting the wsrep parameters
  • evs.user_send_window / Setting the wsrep parameters
  • gcache.dir / Setting the wsrep parameters
  • gcache.mem_size / Setting the wsrep parameters
  • gcache.page_size / Setting the wsrep parameters
  • gcs.fc_master_slave / Setting the wsrep parameters
  • gcs.max_throttle / Setting the wsrep parameters
  • pc.ignore_quorum / Setting the wsrep parameters
• wsrep_cluster_size variable / Starting the nodes
• wsrep_cluster_status variable / Starting the nodes
• wsrep_connected status variable
  • about / Individual node health
• wsrep_connected variable / Starting the nodes
• wsrep_flow_control_paused status variable
  • about / The health of a replication
• wsrep_local_send_queue_avg status variable
  • about / Network performance
• wsrep_notify_cmd server variable / Notification scripts
• wsrep_provider option / Starting the nodes
• wsrep_ready variable / Starting the nodes
• wsrep_replicate_myisam server variable
  • about / Listing the limitations of Galera Cluster

X

• X509 option / Connecting MariaDB through Secure Socket Layer
• XtraDB
  • about / XtraDB and InnoDB

Y

• yaSSL / Connecting MariaDB through Secure Socket Layer
• YYMMDD format / The error log format