MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 611 to 620 of 628 total results

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

To enable debug output without having to set that variable in individual sessions, add the option to the table: mysql> INSERT INTO sys.sys_config (variable, value) VALUES('debug', 'ON'); To change the debug setting in the table, do two things. This ...

26.4.4.26 The table_exists() Procedure

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

This is an OUT parameter, so it must be a variable into which the table type can be stored. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...

8.4.3.1 How MySQL Opens and Closes Tables

https://dev.mysql.com/doc/refman/5.7/en/table-cache.html

Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...

5.5.3.3 Thread Pool Operation

https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html

Queue assignment can be affected by enabling the thread_pool_high_priority_connection system variable, which causes all queued statements for a session to go into the high-priority queue. The thread pool consists of a number of thread groups, each ...

11.2.3 The TIME Type

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

In particular, any fractional part in a value inserted into a TIME column is stored rather than discarded. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...

12.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

2.10.10 Upgrading MySQL with Directly-Downloaded RPM Packages

https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html

It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms. For an upgrade installation using RPM packages, the MySQL server is automatically restarted at the end of the installation if it was ...

7.4 Using mysqldump for Backups

https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html

This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. This section describes how to use mysqldump to produce dump files, and how to ...

5.8.1.5 Using a Stack Trace

https://dev.mysql.com/doc/refman/5.7/en/using-stack-trace.html

On glibc-based systems (Linux), the trace for an unexpected exit within a plugin looks something like: plugin/auth/auth_test_plugin.so(+0x9a6)[0x7ff4d11c29a6] To translate the relative address (+0x9a6) into a file name and line number, use this ...

23.9 Restrictions on Views

https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html

Dump files created with mysqldump cannot be loaded into servers that enforce the column-length restriction. The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible ...

Displaying 611 to 620 of 628 total results