Index

A

• --add-drop-database option / --add-drop-database
• --add-drop-table option / --add-drop-table
• --add-locks option / --add-locks
• ACID
  • URL / Introduction
• Advanced Package Tool (APT) / How it works...
• ALTER TABLE command
  • URL / See also
  / There's more...
• ALTER TABLE method / There's more...
• ANALYZE TABLE command / How it works...
• Aria benchmark results
  • URL / See also
• Aria pagecache
  • configuring / Configuring the Aria pagecache, How it works...
• Aria storage engine documentation
  • URL / See also
• Aria two-step deadlock detection
  • configuring / Configuring the Aria two-step deadlock detection, How to do it..., There's more...
• aria_pagecache_age_threshold variable / How it works...
• aria_pagecache_buffer_size variable / How it works..., There's more...
• aria_pagecache_division_limit variable / How it works...
• async option / XtraBackup and NFS
• Audit Plugin
  • installing / Installing the Audit Plugin, How to do it..., How it works...
  • using / Using the Audit Plugin, How to do it..., How it works..., There's more...
• authentication
  • PAM authentication plugin, used for / Authenticating using the PAM authentication plugin, How it works..., There's more...

B

• backup
  • restoring from / Restoring from a backup
• Backups
  • making, with XtraBackup / Making backups with XtraBackup
  • making, with mysqldump / Getting ready, How it works...
• backup user
  • creating / Creating a backup user, How it works...
• binary logs
  • versus relay logs / Binary logs versus relay logs
• BINARY[(N)] type / How it works...
• bind_address variable / Common causes of replication failures
• binlog event
  • enhancing, with row event annotation / Enhancing the binlog with row event annotations, How to do it..., There's more...
  • replication, skipping of / Selectively skipping the replication of binlog events, How to do it..., How it works...
• binlog event checksums
  • configuring / Configuring binlog event checksums, There's more...
  • URL / See also
• binlog event checksums interoperability
  • URL / See also
• brew
  • URL / Getting ready
• bug
  • URL / How it works...

C

• Cassandra
  • URL / See also
  • and MariaDB, mapping data between / Mapping data between MariaDB and Cassandra, Getting ready, How to do it..., How it works..., There's more...
• Cassandra storage engine
  • URL / See also
  • INSERT, used with / Using INSERT, UPDATE, and DELETE with the Cassandra storage engine, How to do it..., How it works...
  • SELECT, used with / Using SELECT with the Cassandra storage engine, How it works..., There's more...
• Cassandra Storage Engine
  • URL / See also
  • installing / Installing the Cassandra storage engine, How to do it..., How it works...
• cassandra_default_thrift_host variable / There's more...
• CHANGE MASTER TO command / How it works...
  • URL / See also
• CHAR[(N)] type / How it works...
• chown command / How it works...
• close method / How it works...
• Codership group
  • URL / See also
• COLUMN_ADD function / How it works...
• COLUMN_CHECK function / How it works...
• COLUMN_CREATE function / How it works...
• COLUMN_DELETE function / How it works...
• COLUMN_EXISTS function / How it works...
• COLUMN_GET function / How it works...
• COLUMN_JSON function / Reading nested dynamic columns
• COLUMN_LIST function / How it works..., There's more...
• compression
  • modifying, of TokuDB table / Modifying the compression of a TokuDB table, How to do it..., There's more...
• CONNECTION parameter / How it works...
• connections
  • encrypting, with SSL / Encrypting connections with SSL, Getting ready, How to do it..., How it works..., There's more...
• CONNECT storage engine
  • URL / Introduction
  • installing / Installing the CONNECT storage engine, How it works...
  • used, for reading CSV data / Reading and writing CSV data using CONNECT, How to do it..., How it works..., Changing the number and order of columns read using flags
  • used, for writing CSV data / Reading and writing CSV data using CONNECT, How to do it..., How it works..., Changing the number and order of columns read using flags
  • used, for writing XML data / Reading and writing XML data using CONNECT, How to do it..., How it works..., Tree versus HTML-like data structures, Tags and tag attributes
  • used, for reading XML data / Reading and writing XML data using CONNECT, How to do it..., How it works..., Tree versus HTML-like data structures, Tags and tag attributes
  • used, for accessing MariaDB table / Accessing MariaDB tables using CONNECT, How it works..., See also
• CONNECT tables
  • indexing, URL / Introduction
  • creating / Creating and dropping CONNECT tables, How to do it..., How it works...
  • dropping / Creating and dropping CONNECT tables, How to do it..., How it works..., Dropping CONNECT tables
  • creating, URL / See also
  • dropping, URL / See also
• cqlsh command / How to do it...
• CREATE INDEX command
  • URL / See also, See also
• CREATE TABLE command / How it works..., How to do it...
• cron
  • tables, optimizing with / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • tables, checking with / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
• CSV (comma separated values)
  • about / Reading and writing CSV data using CONNECT
• CSV data
  • reading, CONNECT storage engine used / Reading and writing CSV data using CONNECT, How to do it..., How it works..., Changing the number and order of columns read using flags
  • writing, CONNECT storage engine used / Reading and writing CSV data using CONNECT, How to do it..., How it works..., Changing the number and order of columns read using flags
• CSV data files
  • connecting to, URL / See also
• CSV header lines
  • about / CSV header lines
• CURRENT_TIMESTAMP() function
  • URL / See also
• CURRENT_TIMESTAMP function / There's more...

D

• data
  • importing, from mysqldump / Importing the data exported by mysqldump, How to do it...
  • deleting, in dynamic column / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • updating, in dynamic column / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • inserting, in dynamic column / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • reading, from dynamic column / Reading data from a dynamic column, How to do it..., How it works..., Reading nested dynamic columns
  • reading, HandlerSocket used / Reading data using HandlerSocket and PERL, How to do it..., How it works..., There's more..., Reading data using HandlerSocket and Ruby, How it works...
  • reading, PERL used / Reading data using HandlerSocket and PERL, How to do it..., How it works..., There's more...
  • inserting, HandlerSocket used / Inserting data using HandlerSocket and PERL, How it works..., Inserting data using HandlerSocket and Python, How it works..., Inserting data using HandlerSocket and Ruby, How it works...
  • inserting, PERL used / Inserting data using HandlerSocket and PERL, How it works...
  • deleting, PERL used / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works...
  • deleting, HandlerSocket used / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works..., Updating and deleting data using HandlerSocket and Python, How it works..., Updating and deleting data using HandlerSocket and Ruby, How it works...
  • updating, HandlerSocket used / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works..., How to do it..., How it works..., Updating and deleting data using HandlerSocket and Ruby, How it works...
  • updating, PERL used / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works...
  • reading from database, pyhs used / Reading data using HandlerSocket and Python, How it works...
  • inserting, Python used / Inserting data using HandlerSocket and Python, How it works...
  • deleting, Python used / How to do it..., How it works...
  • updating, Python used / How to do it..., How it works...
  • reading, Ruby used / Reading data using HandlerSocket and Ruby, How it works...
  • inserting, Ruby used / Inserting data using HandlerSocket and Ruby, How it works...
  • updating, Ruby used / Updating and deleting data using HandlerSocket and Ruby, How it works...
  • deleting, Ruby used / Updating and deleting data using HandlerSocket and Ruby, How it works...
  • mapping, between MariaDB and Cassandra / Mapping data between MariaDB and Cassandra, Getting ready, How to do it..., How it works..., There's more...
• datadir variable / How it works...
• data types
  • in CONNECT storage engine, URL / See also
• DATETIME column
  • microseconds, using in / Using microseconds in the DATETIME columns, How to do it..., How it works...
  • updating / Updating DATETIME and TIMESTAMP columns automatically, How to do it..., How it works..., There's more...
  • URL / See also
• DATETIME[(D)] type / How it works...
• DATE type / How it works...
• DECIMAL[(M[,D])] type / How it works...
• DELETE
  • used, with Cassandra storage engine / Using INSERT, UPDATE, and DELETE with the Cassandra storage engine, How to do it..., How it works...
• doctor command / Getting ready
• DROP INDEX command / How it works...
  • URL / See also
• dynamic column
  • tables, creating with / Creating tables with dynamic columns, There's more...
  • URL / See also
  • data, inserting / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • data, updating / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • data, deleting / Inserting, updating, and deleting dynamic column data, How to do it..., How it works..., There's more...
  • nesting / Nesting dynamic columns
  • data, reading from / Reading data from a dynamic column, How to do it..., How it works..., Reading nested dynamic columns
• dynamic columns API
  • URL / See also
• DYNAMIC_COLUMN_STORAGE=yes attribute / There's more...

E

• engine-independent table statistics
  • using / Using engine-independent table statistics, How it works...
  • URL / See also
• Estimate option / Performance
• execute_single method / How it works..., There's more..., How it works..., How it works..., How it works..., How it works...
• exists_to_in subquery optimization strategy
  • URL / See also
• extended keys
  • used, with InnoDB / Using extended keys with InnoDB and XtraDB, There's more...
  • used, with XtraDB / Using extended keys with InnoDB and XtraDB, There's more...
• extended statistics
  • using / Using extended statistics, How it works..., There's more...
• extra_port variable / The thread_pool_stall_limit, thread_pool_max_threads, and extra_port variables

F

• Feedback plugin
  • about / The Feedback plugin
  • enabling / Enabling the Feedback plugin, How it works...
  • URL / See also
• FIELD_FORMAT option / Tags and tag attributes
• filenames
  • versus plugin names / Plugin names versus filenames
• FILE_NAME option / Files and CONNECT
• find method / How it works...
• find_modify method / How it works...
• flag= option / How it works...
• FLAG option / Changing the number and order of columns read using flags
• FLUSH PRIVILEGES command / How to do it…
• Fractal Tree Indexes / Introduction
• full-text index
  • creating / Creating a full-text index, How to do it..., How it works...
  • URL / See also

G

• Galera wiki
  • URL / See also
• get_index_id method / How it works...
• global transaction IDs
  • using / Using global transaction IDs, There's more...
  • URL / See also
• GRANT command / There's more...
• group commit optimization
  • URL / See also

H

• HandlerSocket
  • configuring / Installing and configuring HandlerSocket, How it works..., There's more...
  • installing / Installing and configuring HandlerSocket, How it works..., There's more...
  • used, for reading data / Getting ready, How it works..., There's more..., Reading data using HandlerSocket and Ruby, How it works...
  • used, for inserting data / Inserting data using HandlerSocket and PERL, How it works..., Inserting data using HandlerSocket and Python, How it works..., Inserting data using HandlerSocket and Ruby, How it works...
  • used, for deleting data / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works..., Updating and deleting data using HandlerSocket and Python, How to do it..., How it works..., Updating and deleting data using HandlerSocket and Ruby, How it works...
  • used, for updating data / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works..., Updating and deleting data using HandlerSocket and Python, How to do it..., How it works..., Updating and deleting data using HandlerSocket and Ruby, How it works...
  • used, with telnet / Using HandlerSocket directly with Telnet, How it works...
• HandlerSocket configuration options
  • URL / See also
• HandlerSocket PERL client library
  • installing / Getting ready, How it works...
• HandlerSocket plugin
  • URL / See also
• HandlerSocket protocol
  • URL / See also, See also
• HandlerSocket Ruby client library
  • installing / Installing the HandlerSocket Ruby client libraries, Getting ready, See also
• handlersocket_port_wr variable / How it works...
• have_ssl variable / How it works...
• HeidiSQL
  • about / HeidiSQL
• HTML output
  • producing / Producing HTML output, How it works..., See also
• HTML table structure
  • versus tree / Tree versus HTML-like data structures

I

• index
  • creating / Creating an index, How it works..., There's more...
  • URL / See also
  • removing / Removing an index, See also
  • adding, to TokuDB table / Adding indexes to TokuDB tables, How it works...
• indexer command / How to do it..., How it works...
• innobackupex script / How it works..., Restoring from a backup
• InnoDB
  • and XtraDB, switching between / Switching between InnoDB and XtraDB, How to do it...
  • table, migrating from MyISAM / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • table, migrating from Aria / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • extended keys, using with / Using extended keys with InnoDB and XtraDB, There's more...
• InnoDB documentation
  • URL / See also
• insecure password users
  • checking for / Checking for users with insecure passwords, How it works...
• INSERT
  • used, with Cassandra storage engine / Using INSERT, UPDATE, and DELETE with the Cassandra storage engine, How to do it..., How it works...
• insert method / How it works...
• INSTALL command / How it works...
• INSTALL PLUGIN command
  • versus INSTALL SONAME command / INSTALL SONAME versus INSTALL PLUGIN
  / How it works..., How it works...
• INSTALL SONAME command
  • using / Using INSTALL SONAME
  • versus INSTALL PLUGIN command / INSTALL SONAME versus INSTALL PLUGIN
  • URL / See also
  / How it works..., How it works..., How it works..., How it works..., How it works...
• INTEGER type / How it works...
• Internet Speculative Fiction Database (ISFDB) / Importing the data exported by mysqldump

J

• Java JRE
  • installing, URL / Getting ready
• JOINs
  • using / Using JOINs, There's more...

K

• key cache variables
  • about / Other key cache variables
• KILL QUERY ID command
  • URL / See also

L

• launchctl command / How to do it…
• libhsclient library
  • installing / Installing the libhsclient library, How it works...
• LIMIT
  • used, with LIMIT ROWS EXAMINED clause / Using LIMIT with LIMIT ROWS EXAMINED
• LIMIT ROWS EXAMINED clause
  • using / Using LIMIT ROWS EXAMINED, How it works...
  • LIMIT, using with / Using LIMIT with LIMIT ROWS EXAMINED
• Linux
  • MariaDB, installing on / Installing MariaDB on Linux, How to do it..., How it works...
  • Sphinx daemon, installing / Installing the Sphinx daemon on Linux, How to do it...
  • MariaDB files, securing on / Securing MariaDB files on Linux, How to do it..., How it works..., There's more...
• LOAD DATA INFILE command / Reading and writing CSV data using CONNECT
• log_bin variable
  • URL / How to do it...

M

• MAC address table type
  • using / Using the MAC address table type, How it works..., There's more...
• Mac OS X
  • MariaDB, installing on / Installing MariaDB on Mac OS X, How to do it…
• MAC table type
  • URL / See also
• MariaDB
  • installing, on Windows / Installing MariaDB on Windows, How to do it..., How it works...
  • installing, on Linux / Installing MariaDB on Linux, How to do it..., How it works...
  • installing, on Mac OS X / Installing MariaDB on Mac OS X, How to do it…
  • TokuDB, URL / See also
  • SphinxSE, installing / Installing SphinxSE in MariaDB, How to do it..., How it works..., Getting SphinxSE's status
  • and Cassandra, mapping data between / Mapping data between MariaDB and Cassandra, Getting ready, How to do it..., How it works..., There's more...
  • securing, with mysql_secure_installation / Securing MariaDB with mysql_secure_installation, There's more...
• MariaDB Audit Plugin
  • URL / See also
• MariaDB files
  • securing, on Linux / Securing MariaDB files on Linux, How to do it..., How it works..., There's more...
  • securing, on Windows / Securing MariaDB files on Windows, How to do it..., How it works..., There's more...
• MariaDB Galera cluster
  • installing / Installing MariaDB Galera Cluster, How to do it..., How it works...
  • configuring / Configuring MariaDB Galera Cluster
  • URL / See also
  • node, dropping from / Dropping a node from MariaDB Galera Cluster, How it works...
  • monitoring, URL / See also
  • shutting down / Shutting down MariaDB Galera Cluster, How it works..., See also
• MariaDB installation
  • URL, on Linux / See also
• MariaDB Knowledge Base, replication
  • URL / See also
• MariaDB MSI installer
  • URL, for Windows / See also
• MariaDB optimizer strategies
  • controlling / Controlling MariaDB optimizer strategies, How it works..., There's more...
• MariaDB table
  • accessing, CONNECT storage engine used / Accessing MariaDB tables using CONNECT, How it works..., See also
• MASTER_LOG_FILE variable / How it works...
• MASTER_LOG_POS variable / How it works...
• MASTER_USE_GTID variable / How it works...
• microseconds
  • used, in DATETIME column / Using microseconds in the DATETIME columns, How to do it..., How it works...
• multisource replication
  • using / Using multisource replication, Getting ready, How to do it..., How it works..., Additional files
  • URL / See also
• MVCC
  • URL / Introduction
• MyISAM segmented key cache
  • configuring / Configuring the MyISAM segmented key cache, How it works..., Other key cache variables
• mysqlbinlog command / There's more...
  • URL / See also
• mysqlcheck
  • tables, optimizing with / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • tables, checking with / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
• mysql client
  • progress reporting, used in / Using progress reporting in the mysql client, How it works...
• mysql command / How it works...
• mysql command-line client
  • URL / See also
• mysqldump
  • backups, making with / Getting ready, How it works...
  • data, importing from / Importing the data exported by mysqldump, How to do it...
• mysqldump command
  • URL / See also
• MYSQL Table Type
  • URL / See also
• mysql_secure_installation
  • MariaDB, securing with / Securing MariaDB with mysql_secure_installation, There's more...
  • URL / See also

N

• nested dynamic column
  • reading / Reading nested dynamic columns
• NFS
  • about / XtraBackup and NFS
• node
  • dropping, from MariaDB Galera cluster / Dropping a node from MariaDB Galera Cluster, How it works...
• NoSQL databases
  • about / Introduction
• NOW() function / There's more...
  • URL / See also
• number of segments
  • setting, to 1 / Setting the number of segments to 1

O

• occurcol variable / How it works...
• OCCUR table type
  • using / Using the OCCUR table type, How to do it..., How it works..., See also
• old_passwords variable / How to do it...
• open_index method / How it works...
• optimal number of segments
  • determining / Determining the optimal number of segments
• OPTIMIZE command / How to do it...
• OPTION_LIST option
  • about / OPTION_LIST options

P

• $pk variable / How it works...
• PAM authentication plugin
  • used, for authentication / Authenticating using the PAM authentication plugin, How it works..., There's more...
  • URL / See also
• PASSWORD() function
  • URL / See also
• Per account SSL options
  • URL / See also
• performance schema
  • enabling / Enabling the performance schema, How it works...
  • URL / See also
  • using / Using the performance schema, How to do it..., How it works...
• PERL
  • used, for reading data / Getting ready, How it works..., There's more...
  • used, for inserting data / Inserting data using HandlerSocket and PERL, How it works...
  • used, for updating data / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works...
  • used, for deleting data / Updating and deleting data using HandlerSocket and PERL, How to do it..., How it works...
• PERL client library
  • URL / See also
• PIVOT data type
  • URL / See also
• PIVOT table type
  • using / Using the PIVOT table type, How to do it..., How it works..., There's more...
• Pluggable Authentication Modules (PAM) / Authenticating using the PAM authentication plugin
• plugin names
  • versus filenames / Plugin names versus filenames
• pool-of-threads
  • URL / See also
• progress reporting
  • used, in mysql client / Using progress reporting in the mysql client, How it works...
  • disabling / Disabling progress reporting
  • in mytop / Progress reporting in mytop
• progress_report_time variable / There's more…
• Proxy table type
  • URL / See also
• pyhs
  • used, for reading data from database / Reading data using HandlerSocket and Python, How it works...
• pyhs library
  • URL / See also
• Python
  • used, for inserting data / Inserting data using HandlerSocket and Python, How it works...
  • used, for updating data / Updating and deleting data using HandlerSocket and Python, How it works...
  • used, for deleting data / Updating and deleting data using HandlerSocket and Python, How it works...
• Python pyhs client library
  • installing / Installing the HandlerSocket Python client libraries, How it works...

Q

• queries
  • optimizing, with subquery cache / Optimizing queries with the subquery cache, How to do it..., There's more...
• QUOTED option / How it works...

R

• rankcol variable / How it works...
• read_only variable / How it works...
• relay logs
  • versus binary logs / Binary logs versus relay logs
• REPLICATE_EVENTS_MARKED_FOR_SKIP variable / How it works...
• replicate_ignore_db option / How it works...
• replicate_ignore_table variable / Other ignore options
• replication
  • setting up / Setting up replication, How to do it..., How it works..., Binary logs versus relay logs
• replication failure
  • causes / Common causes of replication failures
• repository configuration tool
  • URL / There's more...
• require handlersocket command / How it works...
• roles
  • used, for controlling user permissions / Using roles to control user permissions, How to do it..., How it works...
• roles, feature
  • URL / See also
• row event annotation
  • binlog event, enhancing with / Enhancing the binlog with row event annotations, How to do it..., There's more...
  • URL / See also
• rt indexes
  • URL / See also
• Ruby
  • used, for reading data / Reading data using HandlerSocket and Ruby, How it works...
  • used, for inserting data / Inserting data using HandlerSocket and Ruby, How it works...
  • used, for deleting data / Updating and deleting data using HandlerSocket and Ruby, How it works...
  • used, for updating data / Updating and deleting data using HandlerSocket and Ruby, How it works...
• Ruby handlersocket library
  • URL / See also
• running queries
  • SHOW EXPLAIN, using with / Using SHOW EXPLAIN with running queries, How to do it..., How it works..., There's more..., See also

S

• @@skip_replication session variable / How it works...
• search command / How to do it...
• Security
  • about / Security
• SELECT
  • used, with Cassandra storage engine / Using SELECT with the Cassandra storage engine, How it works..., There's more...
• SELECT command / How to do it...
• SELECT current_role() command / How it works...
• semijoin subqueries
  • optimizing / Optimizing semijoin subqueries, How it works...
• semijoin subquery optimization
  • in MariaDB, URL / See also
• server_audit_incl_users variable / How it works...
• server_id variable / Common causes of replication failures
• service command / How to do it...
• SET PASSWORD command
  • URL / See also
• SET ROLE command / How it works...
• SHOW ALL SLAVES STATUS; command / How it works...
• SHOW command / How to do it..., How it works...
• SHOW CREATE TABLE command / How it works...
• SHOW ENGINES; command / How to do it..., How to do it..., How it works...
• SHOW ENGINES command / How it works...
• SHOW ENGINE TokuDB STATUS; command / How it works...
• SHOW EXPLAIN
  • used, with running queries / Using SHOW EXPLAIN with running queries, How to do it..., How it works..., There's more..., See also
• SHOW EXPLAIN command
  • URL / See also
• SHOW GRANTS command / How it works...
• SHOW INDEX command
  • URL / See also, See also
• SHOW PLUGINS; command / How to do it..., How to do it...
• SHOW PROCESSLIST; command / How it works...
• SHOW STATUS command
  • using / Using SHOW STATUS to check if a feature is being used, How it works..., There's more...
  / How to do it...
• SHOW VARIABLES command / How it works...
• SIGNED [INTEGER] type / How it works...
• skip_networking variable / Common causes of replication failures
• SkySQL
  • URL / How to do it...
• Special Virtual Tables
  • URL / See also
• Sphinx
  • versus SphinxSE / SphinxSE versus Sphinx
  • URL / How to do it...
• Sphinx daemon
  • installing, on Linux / Installing the Sphinx daemon on Linux, How to do it...
  • installing, on Windows / Installing the Sphinx daemon on Windows, How to do it..., There's more...
  • configuring / Configuring the Sphinx daemon, How to do it..., How it works..., The Sphinx daemon and MariaDB on different hosts, See also
  • searching with / Searching with the Sphinx daemon and SphinxSE, How to do it..., How it works..., See also
• SphinxQL
  • URL / See also
• SphinxSE
  • installing, in MariaDB / Installing SphinxSE in MariaDB, How to do it..., How it works..., Getting SphinxSE's status
  • versus Sphinx / SphinxSE versus Sphinx
  • status, obtaining / Getting SphinxSE's status
  • URL / See also
  • searching with / Searching with the Sphinx daemon and SphinxSE, How to do it..., How it works..., See also
• sql_query variable / Sphinx queries
• SSL
  • connections, encrypting with / Encrypting connections with SSL, Getting ready, How to do it..., How it works..., There's more...
• SSL status variables
  • URL / See also
• SSL system variables
  • URL / See also
• statistics
  • URL / See also
• STATUS; command / How it works...
• STATUS variables
  • URL / See also
• stopwords
  • URL / See also
• subquery cache
  • queries, optimizing with / Optimizing queries with the subquery cache, How to do it..., There's more...
  • URL / See also
  • benefits, URL / See also
• sync option / XtraBackup and NFS

T

• table
  • migrating, from MyISAM to Aria / Migrating a table from MyISAM to Aria, How it works...
  • migrating, from MyISAM to InnoDB / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • migrating, from MyISAM to XtraDB / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • migrating, from Aria to InnoDB / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • migrating, from Aria to XtraDB / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
• tables
  • checking, with mysqlcheck / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • checking, with cron / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • optimizing, with cron / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • optimizing, with mysqlcheck / Checking and optimizing tables automatically with mysqlcheck and cron, How to do it…, There's more…
  • creating, with dynamic column / Creating tables with dynamic columns, There's more...
• TABNAME option / How it works...
• Tag attributes
  • about / Tags and tag attributes
• Tags
  • about / Tags and tag attributes
• telnet
  • HandlerSocket, used with / Using HandlerSocket directly with Telnet, How it works...
• threadpool
  • configuring / Configuring threadpool, How it works..., Pool-of-threads differences on Windows and Linux
  • versus thread-per-connection performance, URL / See also
• threadpool benchmarks
  • URL / See also
• thread_pool_idle_timeout variable / The thread_pool_idle_timeout variable
• thread_pool_max_threads variable / The thread_pool_stall_limit, thread_pool_max_threads, and extra_port variables
• thread_pool_stall_limit variable / The thread_pool_stall_limit, thread_pool_max_threads, and extra_port variables
• THRIFT_HOST parameter / How it works...
• TIMESTAMP column
  • updating / Updating DATETIME and TIMESTAMP columns automatically, How to do it..., How it works..., There's more...
  • URL / See also
• TIME[(D)] type / How it works...
• TokuDB
  • about / Introduction
  • installing / Installing TokuDB, How it works...
  • URL / See also
  • configuring / Configuring TokuDB, How it works...
  • migrating to / Migrating to TokuDB, How it works..., See also
  • clustering indexes, URL / See also
• tokudb-cache-size option / How it works...
• TokuDB-specific configuration file
  • creating / Creating a TokuDB-specific configuration file
• TokuDB table
  • creating / Creating TokuDB tables, How to do it...
  • index, adding to / Adding indexes to TokuDB tables, How it works...
  • compression, modifying of / Modifying the compression of a TokuDB table, How to do it..., There's more...
• Tokutek
  • URL / See also
• tree
  • versus HTML table structure / Tree versus HTML-like data structures

U

• UNINSTALL SONAME command / How it works...
• UNSIGNED [INTEGER] type / How it works...
• UPDATE
  • used, with Cassandra storage engine / Using INSERT, UPDATE, and DELETE with the Cassandra storage engine, How to do it..., How it works...
• user permissions
  • controlling, roles used / Using roles to control user permissions, How to do it..., How it works...
• user statistics feature
  • URL / See also
• use_stat_tables variable / There's more...

V

• virtual columns
  • using / Using virtual columns, How to do it..., How it works...
• virtual columns documentation
  • in MariaDB, URL / See also

W

• Windows
  • MariaDB, installing on / Installing MariaDB on Windows, How to do it..., How it works...
  • Sphinx daemon, installing / Installing the Sphinx daemon on Windows, How to do it..., There's more...
  • MariaDB files, securing on / Securing MariaDB files on Windows, How to do it..., How it works..., There's more...
• Windows Management Instrumentation (WMI) / Using the WMI table type
• WMI data type
  • URL / See also
• WMI table type
  • using / Using the WMI table type, Performance
• wsrep_incoming_addresses variable / How to do it...
• wsrep_local_state_comment variable / There's more...

X

• XCOL data type
  • URL / See also
• XCOL table type
  • using / Using the XCOL table type, There's more...
• XML data
  • reading, CONNECT storage engine used / Reading and writing XML data using CONNECT, How to do it..., How it works..., Tree versus HTML-like data structures, Tags and tag attributes
  • writing, CONNECT storage engine used / Reading and writing XML data using CONNECT, How to do it..., How it works..., Tree versus HTML-like data structures, Tags and tag attributes
  • inserting / Inserting XML data
• XML output
  • producing / Getting ready, See also
• XtraBackup
  • Backups, making with / Getting ready
  • about / XtraBackup and NFS
• XtraDB
  • and InnoDB, switching between / Switching between InnoDB and XtraDB, How to do it...
  • table, migrating from Aria / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • table, migrating from MyISAM / Migrating a table from MyISAM or Aria to InnoDB or XtraDB, How it works...
  • extended keys, using with / Using extended keys with InnoDB and XtraDB, There's more...
• XtraDB documentation
  • URL / See also

Y

• Yellowdog Updater Modified (YUM) / How it works...