PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
Or you might want to give different users access to different mysqld servers that they manage themselves. Or you might run multiple instances of the current production version, each managing a different set of databases. For methods of configuring ...You might want to test a new MySQL release while leaving an existing production setup ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). The following restrictions apply to use of MySQL on ...Alternatively, to use more than 2GB, use a 64-bit version of ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...The ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...If you are unfamiliar with the LDML rules used to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. CURRENT_SCHEMA The default database for the statement, NULL if there is none. The table stores one row per thread showing the current status of ...Of the tables that contain statement event rows, events_statements_current is the most ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...As more rows fit into a single disk page, ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
Functions and operators To make it easier for users who migrate from other SQL environments, MySQL Server supports aliases for many functions. Some SQL servers provide the same functionality but call this User space. (In MySQL Server, these ...For ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ...The command connects as the MySQL root user, which is the default administrative account in the MySQL grant ...Alternatively, you can try to start the server with the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
For example, you can set up a source/replica relationship over a dial-up link where the link is up only sporadically and for short periods of time. How can I use replication to improve performance of my system? Set up one server as the source and ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. Notes To see information about a routine, you must be the user named in the routine DEFINER clause or have SELECT access to ...CHARACTER_SET_NAME For stored function character string return values, the character set ... The ...