MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 51 to 58 of 58 total results

« Previous
4
5
6
Next »

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-functions.html

MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema and require no ...

26.6.3 Partitioning Limitations Relating to Functions

https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html

This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...

6.5.4 mysqldump — A Database Backup Program

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

You can use --mysqld-long-query-time to specify a session value from 0 (meaning that every query from mysqldump is logged to the slow query log) to 31536000, which is 365 days in seconds. The mysqldump client utility performs logical backups, ...

6.5.1.2 mysql Client Commands

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

mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: ...

9.3.1 Establishing a Backup Policy

https://dev.mysql.com/doc/refman/9.7/en/backup-policy.html

On Monday at 1 p.m., we can create an incremental backup by flushing the logs to begin a new binary log file. (For example, back it up on tape or DVD, or copy it to another machine.) On Tuesday at 1 p.m., execute another mysqladmin flush-logs ...A ...

25.4.3.6 Defining NDB Cluster Data Nodes

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbd-definition.html

If StartPartitionedTimeout is set to 0, the cluster waits indefinitely (232−1 ms, or approximately 49.71 days). The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data nodes. [ndbd] and [ndbd default] are ...

11.3 Keywords and Reserved Words

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

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

7.4.6 Server Log Maintenance

https://dev.mysql.com/doc/refman/9.7/en/log-file-maintenance.html

As described in Section 7.4, “MySQL Server Logs”, MySQL Server can create several different log files to help you see what activity is taking place. However, you must clean up these files regularly to ensure that the logs do not take up too ...