PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
If you install MySQL using MySQL Installer, the root user is created automatically with the password you supplied. Windows distributions prior to MySQL 5.7.7 include a data directory with a set of preinitialized accounts in the mysql database. (See ... GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
To override these system-wide settings and configure optimizer statistics parameters for individual tables, you can define STATS_PERSISTENT, STATS_AUTO_RECALC, and STATS_SAMPLE_PAGES clauses in CREATE TABLE or ALTER TABLE statements. The value ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review the MySQL Enterprise Backup 4.1 User's Guide, especially Backing Up a Database Server. Connect to the restored server with a mysql client and reset the source and replica information with the following commands: mysql> RESET MASTER;mysql> RESET SLAVE ALL; For the restored server to be able to recover automatically using Group Replication's built-in mechanism for distributed recovery, configure the server's gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 3 State: Waiting for next activation Info: NULL 2 rows in set (0.00 sec) Event scheduling can be stopped by setting the value of ...When ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
This instance of GET DIAGNOSTICS assigns the number of available conditions and the rows-affected count to the user variables @p1 and @p2: GET DIAGNOSTICS @p1 = NUMBER, @p2 = ROW_COUNT; To obtain condition information, specify the condition number ...This instance of GET DIAGNOSTICS assigns the SQLSTATE value and error message to the user variables @p3 and @p4: GET DIAGNOSTICS CONDITION 1 @p3 = RETURNED_SQLSTATE, @p4 = MESSAGE_TEXT; The retrieval list specifies one or more target = item_name assignments, separated by ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server.html
Start the MySQL server like this if your installation includes mysqld_safe: $> bin/mysqld_safe --user=mysql & Note For Linux systems on which MySQL is installed using RPM packages, server startup and shutdown is managed using systemd rather than ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Cast Function and Operator Descriptions Character Set Conversions Character Set Conversions for String Comparisons Other Uses for Cast Operations Cast Function and Operator Descriptions BINARY expr The BINARY operator converts the expression to a ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. The reason for this is that the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
(It is necessary to use the mount option rather than setting innodb_flush_method if you want direct I/O for the log files.) Users of the Veritas file system VxFS should use the convosync=direct mount option. If database write performance is an ...If ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). In the token list for a given server, token names represent database ...