PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. As with any other MySQL Server, user and privilege information is stored in the mysql system ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
Windows distributions prior to MySQL 5.7.7 include a data directory with a set of preinitialized accounts in the mysql database. Use mysqlshow to see what databases exist: C:\> bin\mysqlshow +--------------------+ | Databases | ... GUI tools exist ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT X'616263', HEX('abc'), UNHEX(HEX('abc')); -> 'abc', 616263, 'abc' mysql> SELECT HEX(255), CONV(HEX(255),16,10); -> 'FF', 255 INSERT(str,pos,len,newstr) Returns the string str, with the substring beginning at position pos and len ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
db_name is the name of the database where the table into which to import the data is found; file_name is the name of the CSV file from which to read the data; this must include the path to this file if it is not in the current directory. ndb_import ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. ndb_index_stat provides per-fragment statistical information ...
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This can be a more convenient means of repairing tables because you can use the --databases or --all-databases option to repair all tables in specific databases or all databases, respectively: mysqlcheck --repair --databases db_name ... This ...
https://dev.mysql.com/doc/refman/5.7/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
The data file and index file can be moved elsewhere and replaced in the data directory by symlinks. (Bug #32167) myisamchk does not replace a symlink with the data file or index file. This is an extremely good reason not to run mysqld as the root ...