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/encryption-functions.html
For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text', UNHEX(SHA2('My secret passphrase',512)))); If you exceed the maximum key length of 128 bits, a warning is returned. The size penalty for storing the hex string in a CHAR column is at least two ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-limits.html
The maximum number of operations that can be performed per transaction is set using the configuration parameters MaxNoOfConcurrentOperations and MaxNoOfLocalOperations. For example, the maximum number of ordered indexes in the cluster is determined ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can check partitions for errors in much the same way that you can use CHECK TABLE with nonpartitioned tables. A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-host-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the host. total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-by-user-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event for the user. total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-waits-global-by-latency.html
max_latency The maximum single wait time of timed occurrences of the event. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event. The waits_global_by_latency and ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
For example, an application might encounter performance issues if it commits thousands of times per second, and different performance issues if it commits only every 2-3 hours. When each change is followed by a commit (as with the default autocommit ... To optimize InnoDB transaction processing, find the ideal balance between the performance overhead of transactional features and the workload of your ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. such statements produce a warning in the error ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...