Search Results
https://dev.mysql.com/doc/internals/en/myisampack-tricks.html
As already mentioned, myisampack uses some tricks to decrease the amount of data to be encoded. These cope with leading and trailing spaces or zeros or with all blank or NULL fields. They do not materialize in the compressed data files other than ...
https://dev.mysql.com/doc/internals/en/prepared-statements.html
The prepared statement protocol was introduced in MySQL 4.1 and adds a few new commands: COM_STMT_PREPARE COM_STMT_EXECUTE COM_STMT_CLOSE COM_STMT_RESET COM_STMT_SEND_LONG_DATA It also defines a more compact resultset format that is used instead of ...Keep in mind that not all statements can be prepared: ...
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/rnd-pos.html
Synopsis virtual int rnd_pos ( buf, pos); byte * buf ; byte * pos ; Description This is the rnd_pos method. This is like rnd_next, but you are given a position to use to determine the row. The position will be of the type that you stored in ref. You ...
https://dev.mysql.com/doc/internals/en/row-order-within-result-sets.html
Please keep in mind that the row order within a significant number of result sets depends on storage engine properties and in worst cases the current load (NDB!, partitioning?, parallel query?) on the testing box. Either use --sorted_result SELECT ...
https://dev.mysql.com/doc/internals/en/running-mysql-test-run-out-of-source.html
When building out of source (see Section 4.4.1, “Create the Build Directory”), use mysql-test-run.pl in the mysql-test directory under the build directory. It is a wrapper script that calls mysql-test-run.pl in the source directory and tells it ...
https://dev.mysql.com/doc/internals/en/stored-programs.html
The content formerly located in this chapter is now maintained in the Stored Programs section of the MySQL Server Doxygen documentation, available at https://dev.mysql.com/doc/index-other.html.
https://dev.mysql.com/doc/internals/en/update-row.html
Currently, new_data will not have an updated auto_increament record, or and updated timestamp field. You can do these for example by doing these: if (table->timestamp_field_type & TIMESTAMP_AUTO_SET_ON_UPDATE) table->timestamp_field->set_time(); if ...Synopsis virtual int update_row ( old_data, new_data); const byte * old_data ; byte * new_data ; Description This is the update_row ...
https://dev.mysql.com/doc/ndbapi/en/mgm-examples-event-logging-basic.html
This example shows the basics of handling event logging using the MGM API. The source code for this program may be found in the NDB Cluster source tree, in the file storage/ndb/ndbapi-examples/mgmapi_logevent/main.cpp.
https://dev.mysql.com/doc/ndbapi/en/ndb-nodejs-api-converter.html
If the user supplies a JavaScript converter, it used to read and write to the database. fromDB(val): Convert a value val read from the database into application object format. Converter invocations are chained in the following ways: When writing to ...