PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). in_outfile VARCHAR(255): The name to use for the .dot output file. in_max_runtime DECIMAL(20,2): The maximum ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-reference.html
The following table summarizes all available Performance Schema tables. For greater detail, see the individual table descriptions. Table 29.1 Performance Schema Tables Table Name Description Introduced accounts Connection statistics per client ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html
When the variable names a list of multiple values, each value must specify a single non-wildcard IP address (either IPv4 or IPv6) or a host name. If given, it must be specified as a /ns suffix immediately following the address. The host system must ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
SET can also be used to persist certain system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To make a global system variable setting permanent so that it applies across server ...| ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
With Web servers, store images and other binary assets as files, with the path name stored in the database rather than the file itself. This section lists a number of miscellaneous tips for improving query processing speed: If your application ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be specified. On 32-bit platforms, the supported range of values for this function is ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ...Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
Note If you use ALTER DATABASE to change the database default character set or collation, existing stored routines in the database that use those defaults must be dropped and recreated so that they use the new defaults. For example, to specify the ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...If applications require ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Event collection provides access to information about synchronization calls (such as for mutexes) file and table I/O, table locks, and so forth for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Because the format of the information is SQL statements, the file can easily be distributed and applied to running servers in the event that you need access to the data in an emergency. Using mysqldump to create a copy of a database enables you to ...Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump ...