Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-side-help-support.html
Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
The new password becomes the primary password, but clients can use the account to connect to the server using either the primary or secondary password. When the read_only system variable is enabled, SET PASSWORD requires the CONNECTION_ADMIN ... SET ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. Example mysql> SELECT sys.ps_is_thread_instrumented(43); ...This is a value of ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. For example, for 200 concurrent running connections, specify ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meters.html
For example, to update the frequency of the mysql.inno metrics: mysql>update performance_schema.setup_meters set FREQUENCY='30' where name = 'mysql.inno'; The maximum number of meter instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-trace-format.html
logs_enabled: Boolean details: Session Span Issued when a client session ends, recording data relevant to that session from initial connection to close of session. This span type has the following attributes: Name: Session mysql.processlist_id ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the results. To see a list of options provided by mysql, invoke it with ... This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
The MySQL server must be connected to NDB for this phase to complete. If any NDB or NDBINFO tables exist, and the server cannot connect to the cluster, it exits with an error message: Failed to Populate DD tables. This section describes how to ...
https://dev.mysql.com/doc/refman/8.4/en/using-gdb-on-mysqld.html
Some symptoms are: mysqld hangs during startup (before it writes ready for connections). It is very hard to debug MySQL under gdb if you do a lot of new connections the whole time as gdb does not free the memory for old threads. You can avoid this ... On most systems you can also start mysqld from gdb to get more information if mysqld ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
This command invokes the MySQL administrative utility mysqladmin to connect to the server and tell it to shut down. The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. The MySQL server ...