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/tuning-trace-purging.html
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 possible. Negative values for offset can thus prove useful ...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 is ...
https://dev.mysql.com/doc/refman/5.7/en/locale-support.html
Any client can examine the value of lc_time_names or set its SESSION value to affect the locale for its own connection. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names value does not ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() or HEX(). A leading 0b is case-sensitive and ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
NDB Cluster imposes a maximum length of 63 characters for names of databases and tables. Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each ...The sizes of the identifier string columns in the grant tables are measured in ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
Any user can connect and perform any operation, which is insecure. The in-memory tables become effective for access control at that point. Thus, if you change the grant tables directly but forget to reload them, the changes have no effect until you ... If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup ...
https://dev.mysql.com/doc/refman/5.7/en/connection-interfaces.html
A value of 0 disables caching, which causes a thread to be set up for each new connection and disposed of when the connection terminates. To set a stack size of N bytes for each thread, start the server with thread_stack set to N. By granting the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-quick.html
First, you need to create a configuration directory such as /var/lib/mysql-cluster, by executing the following command as the system root user: $> mkdir /var/lib/mysql-cluster In this directory, create a file named config.ini that contains the ...# ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
The reason for this is that this table must work like a data file that would never be written to by anything other than the database system. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Because the InnoDB storage engine performs many of its ...See ...
https://dev.mysql.com/doc/refman/5.7/en/dbug-package.html
The effect of this default is: d: Enable output for all debug macros t: Trace function calls and exits i: Add PID to output lines o,/tmp/mysqld.trace, O,\mysqld.trace: Set the debug output file. Here are some example debug control strings as they ...