Search Results
https://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html
# Turn tracing on (it's off by default): SET optimizer_trace="enabled=on"; SELECT ...; # your query here SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE; # possibly more queries... # When done with tracing, disable it: SET ...
https://dev.mysql.com/doc/internals/en/optimizer.html
This chapter describes the operation of the MySQL Query optimizer, which is used to determine the most efficient means for executing queries.
https://dev.mysql.com/doc/internals/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
Linux programmers use it where Windows programmers would use a *.bat (batch filename extension). Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table ...
https://dev.mysql.com/doc/internals/en/selectexplain.html
For an EXPLAIN statement, for every SELECT, mysql_select will be called with option SELECT_DESCRIBE. For every SELECT in a given union, mysql_explain_union will call mysql_explain_select. mysql_select creates a JOIN for select if it does not ...
https://dev.mysql.com/doc/mysql-installer/en/mysql-installer-workflow-server.html
MySQL Installer performs the initial configuration of the MySQL server. For example: It creates the configuration file (my.ini) that is used to configure the MySQL server. The values written to this file are influenced by choices you make during ...
https://dev.mysql.com/doc/mysql-installer/en/server-type-network.html
Server Configuration Type Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources (memory) to assign to your MySQL server instance. Development: A computer that hosts many other ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-results.html
4.3.1.21.1 Synopsis public interface Results<E> extends, Iterable<E> {// Public Methods public abstract Iterator<E> iterator();} 4.3.1.21.2 iterator() public abstract Iterator<E> iterator(); Specified by: Method iterator in interface Iterable Get an ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
This section provides information about the Column class, which models a column in an NDBCLUSTER table. The NDB API provides no support for constructing such formats; however, they are checked by the NDB kernel. Type Description ArrayType Specifies ...
https://dev.mysql.com/doc/ndbapi/en/overview-operations.html
An NdbTransaction consists of a list of operations, each of which is represented by an instance of NdbOperation, NdbScanOperation, NdbIndexOperation, or NdbIndexScanOperation (that is, of NdbOperation or one of its child classes). See Section ...