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/linux-installation-debian.html
Users who want to set a password later can leave the password field blank in the dialogue box and just press OK; in that case, root access to the server is authenticated using the MySQL Socket Peer-Credential Authentication Plugin for connections ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
For example, on Pentiums, the instruction is RDTSC (an assembly-language rather than a C instruction) and it is theoretically possible for the operating system to prevent user-mode programs from using it. Each timer row in setup_timers must refer to ...Instruments time events, which is how the Performance Schema provides an idea of how long events ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. Enable profiling by setting profiling to 1 or ON: mysql> SET profiling = 1; SHOW PROFILES displays a list of the most recent statements sent to ...Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. Given these considerations, for many applications, some tables compress more effectively than others, and you might find that your workload performs ...However, because the efficiency of compression depends on the nature of your data, you can make decisions that affect the performance of compressed tables: Which tables to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
Whether the freed space becomes available for other users depends on whether the pattern of deletes frees individual pages or extents to the tablespace. Dropping a table or deleting all rows from it is guaranteed to release the space to other users, ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/index-page-merge-threshold.html
When the “page-full” percentage for an index page falls below 50%, which is the default MERGE_THRESHOLD setting, InnoDB attempts to merge the index page with a neighboring page. Setting MERGE_THRESHOLD for a Table You can set the MERGE_THRESHOLD ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf ...The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
Of course, it is not possible for one mysqld instance to access user variables set on another server instance directly. We have employed a user variable @latest here to represent the value obtained in Step 1. This means that the ndb_apply_status ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
If the application has high requirements for the response time, it should most likely throttle users at a higher level itself. This section provides guidelines on setting thread pool system variables for best performance, measured using a metric ...