MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 221 to 230 of 236 total results

8.12.3.1 Using Symbolic Links for Databases on Unix

https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html

On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create a soft link to it from the MySQL data directory. $> mkdir /dr1/databases/test $> ln -s /dr1/databases/test ...

8.12.3 Using Symbolic Links

https://dev.mysql.com/doc/refman/5.7/en/symbolic-links.html

You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...

26.4.5.5 The format_statement() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html

Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...

26.4.3.21 The metrics View

https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html

This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...

26.4.4.23 The ps_trace_thread() Procedure

https://dev.mysql.com/doc/refman/5.7/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). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...

26.4.1 sys Schema Object Index

https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html

The following tables list sys schema objects and provide a short description of each one.

26.4.4.25 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html

Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...

2.6 Installing MySQL Using Unbreakable Linux Network (ULN)

https://dev.mysql.com/doc/refman/5.7/en/uln-installation.html

Linux supports a number of different solutions for installing MySQL, covered in Section 2.5, “Installing MySQL on Linux”. One of the methods, covered in this section, is installing from Oracle's Unbreakable Linux Network (ULN). You can find ...

13.2.11 UPDATE Statement

https://dev.mysql.com/doc/refman/5.7/en/update.html

UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...

2.10.4 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or ...

Displaying 221 to 230 of 236 total results