MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 101 to 110 of 116 total results

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-setup-metrics-table.html

The setup_metrics table lists the available metrics: mysql> select * from performance_schema.setup_metrics\G *************************** 34. row *************************** NAME: undo_tablespaces_active METER: mysql.inno METRIC_TYPE: ASYNC GAUGE ...

29.12.14.4 Performance Schema variables_metadata Table

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html

The three queries using the variables_metadata table shown in the following example provide information about the binlog_row_image, innodb_doublewrite_batch_size, and secure_file_priv system variables: mysql> SELECT * FROM variables_metadata WHERE ... The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and ...

14.26.3 Expression Handling

https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html

If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. With precision math, exact-value numbers are used as given whenever possible. For example, numbers in ...

14.8.2 Regular Expressions

https://dev.mysql.com/doc/refman/9.7/en/regexp.html

If you want your expr or pat argument to contain a literal \, you must double it. This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and ...

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/9.7/en/replication-options-replica.html

If you use the option on the command line, you might need to double the backslashes or quote the option value, depending on your command interpreter. This section explains the server options and system variables that apply to replica servers and ...

B.3.3.2 How to Reset the Root Password

https://dev.mysql.com/doc/refman/9.7/en/resetting-permissions.html

Start the MySQL server with the init_file system variable set to name the file (notice that the backslash in the option value is doubled): C:\> cd "C:\Program Files\MySQL\MySQL Server 9.7\bin" C:\> mysqld --init-file=C:\\mysql-init.txt If you ... If ...

8.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/9.7/en/secure-client-programming.html

Try to enter single and double quotation marks (' and ") in all of your Web forms. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle ...

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html

If the CRL file is large, the server allocates a large chunk of memory (ten times the file size), which is doubled while the new instance is being loaded and the old one has not yet been released. Innodb_dblwr_pages_written The number of pages that ... The MySQL server maintains many status variables that provide information about its ...

14.16.13 Spatial Convenience Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-convenience-functions.html

If the distance exceeds the range of a double-precision number, an ER_STD_OVERFLOW_ERROR error occurs. The functions in this section provide convenience operations on geometry values. Unless otherwise specified, functions in this section handle ...

27.3.12 JavaScript Stored Program Examples

https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html

This section contains examples illustrating a number of different aspects of using JavaScript programs under various circumstances. The following example demonstrates the use of a JavaScript stored function with table column values. Next, we create ...

Displaying 101 to 110 of 116 total results