Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup.compressed.html
To avoid wasting CPU cycles without saving additional disk space, --compress does not attempt to compress tables that were already-compressed on the server (see Creating Compressed Tables); nevertheless, such tablespace files are also saved with the ... To save disk space, you can compress InnoDB backup data files by using the --compress option of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-files-backed-up-generated.html
Inside the image backup file created by the backup-to-image command of mysqlbackup are some new files that are produced during the backup process. The files generated during the backup process include: meta/backup_create.xml: Lists the command line ...These files are used to control later tasks such as verifying and restoring the backup ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-deploying-sandbox.html
We'll use bootstrapping (using --bootstrap), and create a self-contained MySQL Router installation using --directory. Test a MySQL Router installation by setting up a Router sandbox with InnoDB Cluster. In this case, Router acts as an intermediate ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-installation-source-code.html
To compile the source code, create a folder to contain the compiled binaries and executables, run cmake to create the make file, and then compile the code. Begin by executing the cmake command to create the make file. MySQL Router is part of the ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/admin-api-deploy-router.html
The MySQL Router bootstrap process creates a mysqlrouter.conf file, with the settings based on the metadata retrieved from the address passed to the --bootstrap option, in the above example icadmin@ic-1:3306. The generated MySQL Router configuration ... The recommended deployment of MySQL Router is on the same host as the ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-threaded-clients.html
If a thread does not create the connection to the MySQL database but calls MySQL functions, take the following into account: When you call mysql_init(), MySQL creates a thread-specific variable for the thread that is used by the debug library (among ... This section provides guidance for writing client programs that use the thread-related functions in the MySQL C ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-execute.html
Example The following example demonstrates how to create and populate a table using mysql_stmt_init(), mysql_stmt_prepare(), mysql_stmt_param_count(), mysql_stmt_bind_named_param(), mysql_stmt_execute(), and mysql_stmt_affected_rows(). int ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/adding-native-function.html
If the function takes a variable number of arguments, create a subclass of Create_native_func. To provide a name by which the function can be referred to in SQL statements, register the name in item_create.cc by adding a line to this array: static ... To add a native MySQL function, use the procedure described here, which requires that you use a source ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-prepare-data-split.html
You can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine. Two new tables in the same database are created with the following names: [original_table_name]_train [original_table_name]_test The split of the data ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-supervised-learning.html
Supervised Learning Supervised learning creates a machine learning model by analyzing a labeled dataset to learn patterns. What's Next Learn more about the following: AutoML Ease of Use AutoML Workflow Oracle AutoML Learn how to Create a Machine ...