MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 351 to 360 of 361 total results

https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html

The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. It is ...

8.6.3 Optimizing REPAIR TABLE Statements

https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html

You may be able to its improve performance by setting these variables, as described in Section 4.6.3.6, “myisamchk Memory Usage”. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same ...

16.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html

However, it is not strictly necessary to include every column in both images, and we can often save disk, memory, and network usage by logging only those columns which are actually required. Startup Options Used with Binary Logging System Variables ...

5.5.4.1 Installing or Uninstalling the Rewriter Query Rewrite Plugin

https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-installation.html

6.4.1.5 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html

MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...

13.7.5.31 SHOW PROFILES Statement

https://dev.mysql.com/doc/refman/5.7/en/show-profiles.html

SHOW PROFILES The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. Note The SHOW PROFILE and SHOW PROFILES statements ...

6.4.1.11 Socket Peer-Credential Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html

The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket file. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program.

8.4.3.1 How MySQL Opens and Closes Tables

https://dev.mysql.com/doc/refman/5.7/en/table-cache.html

See MyISAM and partition file descriptor usage.) To increase the number of file descriptors available to MySQL, set the open_files_limit system variable. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 ...

6.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/test-pluggable-authentication.html

MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. This is a loadable plugin (not built in) and must be installed prior to use. The test plugin source code is separate from the server ...

8.15.4 Tuning Trace Purging

https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html

Using optimizer_trace_offset and optimizer_trace_limit, which are restrictions at the trace producer level, provide better (greater) speed and (less) memory usage than setting offsets or limits at the trace consumer (SQL) level with SELECT * FROM ...

Displaying 351 to 360 of 361 total results