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/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. With simple tests, you usually test how ...Benchmarks are typically long-running and elaborate performance tests, where the results could dictate high-level choices such as hardware and storage configuration, or how soon to upgrade to a new MySQL ...
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-innodb-cmp-table.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information on operations related to compressed InnoDB tables. The INNODB_CMP and INNODB_CMP_RESET tables have these columns: PAGE_SIZE The compressed page size in bytes. Pages are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. PAGES_FREE The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-and-plugins.html
The associated event information, including aggregate information, remains readable in performance_schema database tables. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. For additional ...Time spent executing the code while the plugin was loaded was still spent even if the plugin is unloaded ...
https://dev.mysql.com/doc/refman/5.7/en/error-handling.html
This appendix describes the types of error information MySQL provides and how to obtain information about them. It describes common problems and errors that may occur and potential resolutions.
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-use_sys_malloc.html
When InnoDB was developed, the memory allocators supplied with operating systems and run-time libraries were often lacking in performance and scalability. At that time, there were no memory allocator libraries tuned for multi-core CPUs. Therefore, ...This allocator is guarded by a single mutex, which may become a ...
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/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 ...