Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-j2ee-concepts-connection-pooling.html
Many of these resources will be used whether or not the connection is actually doing any useful work! Connection pools can be tuned to maximize performance, while keeping resource utilization below the point where your application will start to fail ... Connection pooling is a technique of creating and managing a pool of connections that are ready for use by any thread that needs ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-parameters.html
This part of the tutorial shows you how to use parameters in your MySQL Connector/NET application. Although it is possible to build SQL query strings directly from user input, this is not advisable as it does not prevent erroneous or malicious ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-performance.html
If you experience problems with the performance of Connector/ODBC, or notice a large amount of disk activity for simple queries, there are a number of aspects to check: Ensure that ODBC Tracing is not enabled. The Connector/ODBC driver has been ...
https://dev.mysql.com/doc/connectors/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-parameters.html
This part of the tutorial shows you how to use parameters in your MySQL Connector/NET application. Although it is possible to build SQL query strings directly from user input, this is not advisable as it does not prevent erroneous or malicious ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-performance.html
If you experience problems with the performance of Connector/ODBC, or notice a large amount of disk activity for simple queries, there are a number of aspects to check: Ensure that ODBC Tracing is not enabled. The Connector/ODBC driver has been ...
https://dev.mysql.com/doc/connector-python/en/connector-python-tutorial-cursorbuffered.html
The following example script gives a long-overdue 15% raise effective tomorrow to all employees who joined in the year 2000 and are still with the company. (A buffered cursor fetches and buffers the rows of a result set after executing a query; see ...
https://dev.mysql.com/doc/internals/en/calling-sequence.html
For simple non-grouping queries only Section 18.1.3, “send_row()” is called once for each result row. For grouping queries add() is called once for each source row. The init callback is always called first at the beginning of a query, followed ...
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The file bears the same name as the table, with an .frm extension.
https://dev.mysql.com/doc/internals/en/optimizer-code.html
This diagram shows the structure of the function handle_select() in /sql/sql_select.cc (the server code that handles a query): handle_select() mysql_select() JOIN::prepare() setup_fields() JOIN::optimize() /* optimizer is from here ... */ ...