Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--log-raw Command-Line Format --log-raw[={OFF|ON}] System Variable log_raw Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value OFF Passwords in certain statements written to the general query log, slow query log, and binary ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/server-status-variables.html
Current_tls_ca The active ssl_ca value in the SSL context that the server uses for new connections. This context value may differ from the current ssl_ca system variable value if the system variable has been changed but ALTER INSTANCE RELOAD TLS has ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/8.4/en/sorted-index-builds.html
It does not apply to external pages used for TEXT or BLOB entries. Sorted Index Builds and Full-Text Index Support Sorted index builds are supported for fulltext indexes. Previously, SQL was used to insert entries into a fulltext index. InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is available only for tables having no BLOB or TEXT columns. Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
Support for FULLTEXT indexes is available in MySQL 5.6 and later.7. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-bytes.html
Note format_bytes() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_BYTES() function instead. See Section 14.21, “Performance Schema Functions” Given a byte ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-time.html
Note format_time() is deprecated, and subject to removal in a future MySQL version. Applications that use it should be migrated to use the built-in FORMAT_PICO_TIME() function instead. See Section 14.21, “Performance Schema Functions” Given a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/windows-create-option-file.html
Whichever option file you use, it must be a plain text file. An option file can be created and modified with any text editor, such as Notepad. If you need to specify startup options when you run the server, you can indicate them on the command line ...