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/sys-extract-schema-from-file-name.html
This function assumes that the file name lies within the schema directory. For this reason, it does not work with partitions or tables defined using their own DATA_DIRECTORY table option. This function is useful when extracting file I/O information ... Given a file path name, returns the path component that represents the schema ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html
If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. This attempt might fail because the ...
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
This usually happens under the following conditions: The table is so small that it is faster to perform a table scan than to bother with a key lookup. This is common for tables with fewer than 10 rows and a short row length. In this case, MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
This directory should be in a disk-based file system (not a memory-based file system) so that the temporary files used to replicate LOAD DATA can survive machine restarts. On platforms that support it (such as Unix), this is done by unlinking the ...
https://dev.mysql.com/doc/refman/5.7/en/using-mysqldump.html
This section describes how to use mysqldump to produce dump files, and how to reload dump files. This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. Because MySQL does similar optimizations automatically, you can often avoid this work, and leave the query in a more understandable and maintainable form. This is ...The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. At this point, you should have an ODBC connection to MySQL, encrypted using ...Either do a remote forward (Set local_port: 3306, remote_host: yourmysqlservername_or_ip, remote_port: 3306 ) or a local forward (Set port: 3306, host: localhost, remote port: ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-encrypted-connections.html
This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
To use this statement, you need the CREATE privilege for the database. If you manually create a directory under the data directory (for example, with mkdir), the server considers it a database directory and it shows up in the output of SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...