MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 91 to 100 of 194 total results

25.5.5 ndb_mgm — The NDB Cluster Management Client

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-mgm.html

--connect-retries=# Command-Line Format --connect-retries=# Type Numeric Default Value 3 Minimum Value 0 Maximum Value 4294967295 This option specifies the number of times following the first attempt to retry a connection before giving up (the ...

25.5.25 ndb_select_all — Print Rows from an NDB Table

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-select-all.html

--ndb-mgm-tls Command-Line Format --ndb-mgm-tls=level Type Enumeration Default Value relaxed Valid Values relaxedstrict Sets the level of TLS support required to connect to the management server; one of relaxed or strict. --useHexFormat -x Causes ...

25.5.2 ndbinfo_select_all — Select From ndbinfo Tables

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndbinfo-select-all.html

--delay=seconds Command-Line Format --delay=# Type Numeric Default Value 5 Minimum Value 0 Maximum Value MAX_INT This option sets the number of seconds to wait between executing loops. --loops=number, -l number Command-Line Format --loops=# Type ...

10.3.1 How MySQL Uses Indexes

https://dev.mysql.com/doc/refman/9.7/en/mysql-indexes.html

Comparison of dissimilar columns (comparing a string column to a temporal or numeric column, for example) may prevent use of indexes if values cannot be compared directly without conversion. For a given value such as 1 in the numeric column, it ...

22.3.3.6 Create and Drop Indexes

https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-indexes-create.html

The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-js> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...

22.4.3.6 Create and Drop Indexes

https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-index.html

The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-py> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...

6.5.1.6 mysql Client Tips

https://dev.mysql.com/doc/refman/9.7/en/mysql-tips.html

Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 14.3, “Type Conversion in ...

6.6.10 mysqldumpslow — Summarize Slow Query Log Files

https://dev.mysql.com/doc/refman/9.7/en/mysqldumpslow.html

-n N Type Numeric Abstract numbers with at least N digits within names. -t N Type Numeric Display only the first N queries in the output. The MySQL slow query log contains information about queries that take a long time to execute (see Section ...

10.4.2.2 Optimizing for Character and String Types

https://dev.mysql.com/doc/refman/9.7/en/optimize-character.html

See Section 10.4.2.1, “Optimizing for Numeric Data” for reasons why a numeric column is usually preferable to an equivalent string column. For character and string columns, follow these guidelines: Use binary collation order for fast comparison ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

Displaying 91 to 100 of 194 total results