PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
The Com_stmt_xxx status variables are as follows: Com_stmt_prepare Com_stmt_execute Com_stmt_fetch Com_stmt_send_long_data Com_stmt_reset Com_stmt_close Those variables stand for prepared statement commands. Flush_commands The number of times the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
Affected programs are listed here, along with the NDB versions in which the dependency was removed: ndb_restore, in NDB 7.5.15 ndb_show_tables, in NDB 7.5.18 ndb_waiter, in NDB 7.5.18 The principal effect of this change for users is that these ...A ...The config_params table has been made read-only, and has been enhanced with additional columns providing information about each configuration parameter, including the parameter's type, default value, maximum and minimum values (where applicable), a brief description of the parameter, and whether the parameter is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
If the variable does not exist or is NULL, the routine reads the option value from the table and sets the user-defined variable to that value. For more information about the relationship between configuration options and their corresponding ...By ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
For an example specific to full-text indexing, see Section 12.9.7, “Adding a User-Defined Collation for Full-Text Indexing”. Rebuilding InnoDB Full-Text Indexes For the changes to take effect, FULLTEXT indexes must be rebuilt after modifying any ...Modifying Boolean Full-Text Search Operators To change the operators used for boolean full-text searches on MyISAM tables, set the ft_boolean_syntax system ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Typical users aim to get the best database performance out of their existing software and hardware configurations. Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. Advanced ...As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and measuring performance using wall-clock ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Creating a Compressed Table in File-Per-Table Tablespace To create a compressed table in a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
Traditionally, you would get this type of information using the techniques from Section 14.18, “InnoDB Monitors”, setting up InnoDB monitors and parsing the output from the SHOW ENGINE INNODB STATUS statement. The first index is GEN_CLUST_INDEX, ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Renaming an index ALTER TABLE tbl_name RENAME INDEX old_index_name TO new_index_name, ALGORITHM=INPLACE, LOCK=NONE; Adding a FULLTEXT index CREATE FULLTEXT INDEX name ON table(column); Adding the first FULLTEXT index rebuilds the table if there is ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...The CREATE INDEX statement only finishes after all transactions ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. A SPATIAL index contains minimum bounding rectangle (MBR) values, so InnoDB enforces ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...