PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
Example The following example uses the ins_sum trigger defined in Section 23.3, “Using Triggers”: mysql> SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE TRIGGER_SCHEMA='test' AND TRIGGER_NAME='ins_sum'\G *************************** 1. To see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 13.7.1.4, “GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns in a table The number of partitions. If a table has no partitions, the number ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
ENGINE=InnoDB AS SELECT * FROM other_engine_table; To assess performance with a full application under a realistic workload, install the latest MySQL server and run benchmarks. If InnoDB is not the default storage engine, you can determine if your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
To get exclusive write access to a set of rows, use the SELECT ... Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into the buffer pool and evict an equivalent amount of older data, even if the new data is never used again.
https://dev.mysql.com/doc/refman/5.7/en/innodb-check-availability.html
Issue the SHOW ENGINES statement to view the available MySQL storage engines.
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-internals.html
This section describes some internal implementation details about compression for InnoDB tables. The information presented here may be helpful in tuning for performance, but is not necessary to know for basic use of compression. Compression ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
mysql> SELECT @@innodb_file_per_table; +-------------------------+ | @@innodb_file_per_table | +-------------------------+ | 1 | +-------------------------+ For more information about file-per-table tablespaces, see Section 14.6.3.2, ... There are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...