PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. unique_hosts The number of distinct hosts from which connections for the user have originated. The user_summary and x$user_summary views have these columns: user ...
https://dev.mysql.com/doc/refman/8.0/en/testing-server.html
The following commands provide simple tests to check whether the server is up and responding to connections: $> bin/mysqladmin version $> bin/mysqladmin variables If you cannot connect to the server, specify a -u root option to connect as root.
https://dev.mysql.com/doc/refman/8.0/en/thread-pool.html
The default thread-handling model in MySQL Server executes statements using one thread per client connection. As more clients connect to the server and execute statements, overall performance degrades. The plugin implements a thread pool that ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). Sending the signal enables the flush operations to be performed without having to connect ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html
(See Section 6.2.2, “Specifying Program Options”.) The server also maintains a set of session variables for each client that connects. The client's session variables are initialized at connect time using the current values of the corresponding ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
Based on the type of statements it issues (for example, reads versus writes), a client selects an appropriate server and connects to it. The client-side logic for detecting version token errors and selecting a new server can be implemented different ... Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version ...
https://dev.mysql.com/doc/refman/8.0/en/workbench.html
MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those newer server versions. MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
If a client attempts to connect to a locked account, the attempt fails. The server increments the Locked_connects status variable that indicates the number of attempts to connect to a locked account, returns an ER_ACCOUNT_HAS_BEEN_LOCKED error, and ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. The user name part of an account name is either a nonblank value that ...
https://dev.mysql.com/doc/refman/8.0/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...