Search Results
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-using-a-recommendation-model-similar-users.html
Before You Begin Review and complete the following tasks: Prepare Data for a Recommendation Model Train a Recommendation Model Generate Predictions for a Recommendation Model Generating Similar Users When you run ML_PREDICT_TABLE to generate similar ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-train-test-split.html
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 between training and testing datasets depends on the machine learning task. Order the table by the ... The TRAIN_TEST_SPLIT routine automatically splits your data into training and testing ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Thus, if a table is touched for the first time, it implicitly starts a ...In ...
https://dev.mysql.com/doc/refman/9.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/9.7/en/create-server.html
The CREATE SERVER statement creates a new row in the servers table in the mysql database. The CREATE SERVER statement creates an entry in the mysql.servers table that can later be used with the CREATE TABLE statement when creating a FEDERATED table.
https://dev.mysql.com/doc/refman/9.7/en/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? A.6.4. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-system-tablespace.html
The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. By default, a single system tablespace data ...To do so, specify the autoextend attribute for the last data file in the innodb_data_file_path setting, and restart the ...
https://dev.mysql.com/doc/refman/9.7/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before ...At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join ...
https://dev.mysql.com/doc/refman/9.7/en/serialized-dictionary-information.html
Other storage engines store SDI data in .sdi files that are created for a given table in the table's database directory. Serialized dictionary information (SDI) is present in all InnoDB tablespace files except for temporary tablespace and undo ...
https://dev.mysql.com/doc/refman/9.7/en/windows-restrictions.html
File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location. DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...