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/security-options.html
For descriptions of each of these, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”. The following table shows mysqld options and system variables that affect security.
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-account-enabled.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given account is enabled. Parameters in_host VARCHAR(60): The host name of the account to check. Example mysql> SELECT sys.ps_is_account_enabled('localhost', 'root'); ...
https://dev.mysql.com/doc/refman/5.7/en/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 26.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) ...A ...Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Table 15.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-descriptions.html
Tables in the performance_schema database can be grouped as follows: Setup tables. For example, to set the sizes of the wait event history tables, set performance_schema_events_waits_history_size and ...The events_waits_current table contains the ...These tables have the same structure as the current events tables, but contain more ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
For example, to invoke a stored procedure p or function f that is associated with the test database, you can say CALL test.p() or test.f(). A stored procedure or function is associated with a particular database. This has several implications: When ... A stored routine is either a procedure or a ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
External locking is the use of file system locking to manage contention for MyISAM database tables by multiple processes. Do not start the server with the delay_key_write system variable set to ALL or use the DELAY_KEY_WRITE=1 table option for any ...Here are some examples: If you run multiple servers that use the same database directory (not recommended), each server must have external locking ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. TABLE_SCHEMA The name of the schema (database) to which the table containing the index belongs. INDEX_SCHEMA The name of the ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur. Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content ...Physical (Raw) Versus Logical Backups Physical backups consist of raw copies of the directories and files that store database ...