Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
How about age? That might be of interest, but it is not a good thing to store in a database. Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool.html
As the database operates, pages in the buffer pool that are not accessed “age” by moving toward the tail of the list. The larger the buffer pool, the more InnoDB acts like an in-memory database, reading data from disk once and then accessing the ... The buffer pool is an area in main memory where InnoDB caches table and index data as it is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-fulltext_index-tables.html
Before querying any of them, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that contains the FULLTEXT index (for example, test/articles). YourSQL','In the following database ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The INDEX_ID is an identifier for the index that is unique across all databases in an instance. Example 17.4 Joining InnoDB INFORMATION_SCHEMA Schema Object Tables This example demonstrates joining three InnoDB INFORMATION_SCHEMA schema object ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-rpm.html
mysql-commercial-server Database server and related tools mysql-commercial-test Test suite for the MySQL server Additional *debuginfo* RPMs There are several debuginfo packages: mysql-commercial-client-debuginfo, mysql-commercial-libs-debuginfo ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-blob-tool.html
If you need to specify a database, use the --database (-d) option. --database=db_name, -d Command-Line Format --database=name Type String Default Value [none] Specify the database to find the table in. This tool can be used to check for and remove ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. --database, -d Specifies the name of the database in which the desired table is found. If this option is given, the name of a table must follow the database name. If this ...By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as ...
https://dev.mysql.com/doc/refman/8.4/en/password-logging.html
To guard log files against unwarranted exposure, locate them in a directory that restricts access to the server and the database administrator. If the server logs to tables in the mysql database, grant access to those tables only to the database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-implementation.html
Replication is based on the source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. The binary log serves as a written record of all events that modify database structure or content (data) from ...Each replica that connects to the source requests a copy of the binary ...