Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-data-sets.html
Operations that fetch data items return a cursor that can be used to consume those data items from the result set. All subsequent calls increment the internal data item iterator cursor by one position and return the item found making the second ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-data-sets.html
Operations that fetch data items return a cursor that can be used to consume those data items from the result set. All subsequent calls increment the internal data item iterator cursor by one position and return the item found making the second ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-data-sets.html
Operations that fetch data items return a cursor that can be used to consume those data items from the result set. All subsequent calls increment the internal data item iterator cursor by one position and return the item found making the second ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value true Since Version 3.1.9 useCursorFetch Should the driver use cursor-based fetching to retrieve rows? If set to "true" and 'defaultFetchSize' is set to a value higher than zero or 'setFetchSize()' with a value higher than zero is ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
This is relevant within the context of cursors and is used to control what happens when a cursor reaches the end of a data set. DECLARE CONTINUE HANDLER FOR NOT FOUND BEGIN -- body of handler END; For another example, see Section 15.6.6, ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
However, a cursor cannot be used for a dynamic statement that is prepared and executed with PREPARE and EXECUTE. The statement for a cursor is checked at cursor creation time, so the statement cannot be dynamic. Using prepared statements with ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-status-variables.html
Mysqlx_cursor_close The number of cursor-close messages received Mysqlx_cursor_fetch The number of cursor-fetch messages received Mysqlx_cursor_open The number of cursor-open messages received Mysqlx_errors_sent The number of errors sent to clients.
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
Default Value false Since Version 5.0.5 scrollTolerantForwardOnly Should the driver contradict the JDBC API and tolerate and support backward and absolute cursor movement on result sets of type 'ResultSet.TYPE_FORWARD_ONLY'? Regardless of this ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
Another alternative is to use cursor-based streaming to retrieve a set number of rows each time. MySQL does not support SQL cursors, and the JDBC driver does not emulate them, so setCursorName() has no effect. MySQL Connector/J, as a rigorous ...