PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
--port=port_num, -P port_num Command-Line Format --port=port_num Type Numeric Default Value 3306 For TCP/IP connections, the port number to use. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 ...
https://dev.mysql.com/doc/refman/8.0/en/null-values.html
Be aware that the NULL value is different from values such as 0 for numeric types or the empty string for string types. The NULL value means “no data.” NULL can be written in any lettercase. For text file import or export operations performed ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
For tables that are big, or contain lots of repetitive text or numeric data, consider using COMPRESSED row format. Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
Each error summary table has three columns that identify the error: ERROR_NUMBER is the numeric error value. The Performance Schema maintains summary tables for aggregating statistical information about server errors (and warnings). For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
MySQL does not perform matching of Host column values in the mysql.user system table against host names for which one or more of the initial components of the name are entirely numeric, such as 1.2.example.com. The MySQL server maintains an ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
For variables that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Many MySQL programs have internal variables that can be set at runtime using the SET statement. See ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Between any of the decimal types DECIMAL, FLOAT, DOUBLE, and NUMERIC. Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In addition, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
This example shows the GTID set stored in the gtid_executed system variable (@@GLOBAL.gtid_executed) of a replica that has applied transactions from more than one source: 2174B383-5441-11E8-B90A-C80AA9429562:1-3, ... A global transaction identifier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...