Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. (If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 7, ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. To create a test instance, make a copy of your MySQL instance that contains the mysql database and other databases without the ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. This means that anyone can attempt to connect to the server using any user name, so you cannot make a database secure in any way unless all MySQL accounts have passwords. Warning ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
DROP DATABASE You cannot drop a database that is in use by another session. Case-insensitive names File names are not case-sensitive on Windows, so MySQL database and table names are also not case-sensitive on Windows. The only restriction is that ... 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 ...
https://dev.mysql.com/doc/refman/8.4/en/xa.html
The application makes sure that transactions dealing with message sending, retrieval, and processing that also involve a transactional database all happen in a global transaction. A global transaction manager integrates the ATM and database ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-capacity-options.html
These options limit the resources used by the backup process, in order to minimize backup overhead for busy or huge databases, or specify behaviors of the process when encountering resource issues. This is to limit the CPU and I/O overhead on the ...--number-of-buffers=num_buffers Command-Line Format --number-of-buffers=NUMBER Type Numeric Default Value 14 Minimum Value 1 Specifies the number of buffers, each 16MB in size, to use during multithreaded ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-single-file-options.html
--sbt-database-name=NAME Command-Line Format --sbt-database-name=NAME Type String Default Value MySQL For tape backups, this option can be used as a hint to the Media Management Software (MMS) for the selection of media and policies. The parameter ...You use them in combination with the mysqlbackup commands backup-to-image, image-to-backup-dir, backup-dir-to-image, copy-back-and-apply-log, list-image, and extract (not all of the options are applicable to all these commands ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.corruption.html
Reboot the database server and the storage device to see if the problem persists. If the problem persists after the database server and the storage device have been restarted, you might really have a corruption on your disk. You might consider ...