PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-handles-table.html
It is autosized by default; to configure the table size, set the performance_schema_max_table_handles system variable at server startup. The Performance Schema exposes table lock information through the table_handles table to show the table locks ...Table lock instrumentation uses the wait/lock/table/sql/handler instrument, which is enabled by ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version <= 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. If the original table resides in a ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
Tables in the performance_schema database cannot be locked with LOCK TABLES, except the setup_xxx tables. Results for queries that refer to tables in the performance_schema database are not saved in the query cache. The Performance Schema avoids ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html
It is used on systems that have a zoneinfo database (the set of files describing time zones). The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. One likely location for these files is the /usr/share/zoneinfo directory ...tz_file is the name of your time zone file: mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ...This statement ... SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-mysql-firewall-users-table.html
The MYSQL_FIREWALL_USERS table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_users system table that provides persistent storage of firewall data; see MySQL Enterprise ...It lists names and operational modes of registered firewall account ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=dir_name Type Directory name The directory where character sets are installed. When the table is used later, the server reads into memory the information needed to decompress ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multiple-buffer-pools.html
For systems with buffer pools in the multi-gigabyte range, dividing the buffer pool into separate instances can improve concurrency, by reducing contention as different threads read and write to cached pages. This feature is typically intended for ...Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the innodb_buffer_pool_size ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-long-table.html
To set the table size explicitly, set the performance_schema_events_stages_history_long_size system variable at server startup. The Performance Schema autosizes the value of N during server startup. For more information about the relationship ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-long-table.html
To set the table size explicitly, set the performance_schema_events_statements_history_long_size system variable at server startup. For more information about the relationship between the three events_statements_xxx event tables, see Section 25.9, ... The events_statements_history_long table contains the N most recent statement events that have ended globally, across all ...