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/mysql-cluster-limitations-syntax.html
Attempting to create an index on an NDB table column whose width is greater than 3072 bytes is rejected with ER_TOO_LONG_KEY: Specified key was too long; max key length is 3072 bytes. Attempting to create an index on an NDB table column whose width ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
Proxy User System Variables Two system variables help trace the proxy login process: proxy_user: This value is NULL if proxying is not used. If the plugin does not set this variable, its value is NULL. The plugin that authenticates a given ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
row *************************** Engine: BLACKHOLE Support: YES Comment: /dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO *************************** 5. Blackhole: The Blackhole storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/thread-information.html
row *************************** Id: 1 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. To ascertain what your MySQL server is doing, it can be ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
This is also done for any NOT NULL expression when used with only one table. A table that is used with a WHERE clause on a PRIMARY KEY or a UNIQUE index, where all index parts are compared to constant expressions and are defined as NOT NULL. This ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
Attempting to use REORGANIZE PARTITION without the partition_names INTO (partition_definitions) option on explicitly partitioned tables results in the error REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
It makes SQL operations faster, by enabling better use of indexes and eliminating overhead for testing whether each value is NULL. If you really need NULL values in your tables, use them. Just avoid the default setting that allows NULL values in ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
row *************************** Id: 1 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: show processlist *************************** 2. row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL ... Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this ...