MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 321 to 330 of 332 total results

https://dev.mysql.com/doc/refman/8.0/en/sys-schema-reference.html

The sys schema includes tables and triggers, views, and stored procedures and functions.

10.4.3.1 How MySQL Opens and Closes Tables

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

When the table cache fills up, the server uses the following procedure to locate a cache entry to use: Tables not currently in use are released, beginning with the table least recently used. When you execute a mysqladmin status command, you should ...

7.1.15 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

The MySQL installation procedure creates the time zone tables, but does not load them. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time ...

10.15.4 Tuning Trace Purging

https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html

Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...

3.3 Upgrade Best Practices

https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html

MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...

3.6 Preparing Your Installation for Upgrade

https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or ...

8.2.1 Account User Names and Passwords

https://dev.mysql.com/doc/refman/8.0/en/user-names.html

You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. MySQL stores accounts in the user table of the mysql system database. An ...

7.9.1.5 Using a Stack Trace

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

On some operating systems, the error log contains a stack trace if mysqld dies unexpectedly. You can use this to find out where (and maybe why) mysqld died. To get a stack trace, you must not compile mysqld with the -fomit-frame-pointer option to ...

2.5.9 Managing MySQL Server with systemd

https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html

If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake option. The following discussion covers these topics: Overview of ...

15.6.5.8 WHILE Statement

https://dev.mysql.com/doc/refman/8.0/en/while.html

Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...

Displaying 321 to 330 of 332 total results