Search Results
https://dev.mysql.com/doc/refman/8.4/en/compiling-for-debugging.html
If you have some very specific problem, you can always try to debug MySQL. To do this you must configure MySQL with the -DWITH_DEBUG=1 option. You can check whether MySQL was compiled with debugging by doing: mysqld --help. If mysqld stops crashing ...If the --debug flag is listed with the options then you have debugging ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
If you inspect the MySQL error log (hostname.err), you can see that the event is executing, but the action it is attempting to perform fails: 2013-09-24T12:41:31.261992Z 25 [ERROR] Event Scheduler: [jon@ghidora][cookbook.e_store_ts] INSERT command ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? A.7.5. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.4 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use ...
https://dev.mysql.com/doc/refman/8.4/en/firewall.html
Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or ...For a given account, the firewall can operate in recording, protecting, or detecting mode, for training in the accepted statement patterns, active protection against unacceptable statements, or passive detection of unacceptable ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-dedicated-server.html
When the server is started with --innodb-dedicated-server, InnoDB automatically calculates values for and sets the following system variables: innodb_buffer_pool_size innodb_redo_log_capacity Note innodb_redo_log_capacity supersedes both ...The ...
https://dev.mysql.com/doc/refman/8.4/en/locale-support.html
The set of locales supported by MySQL may differ from those supported by your operating system. The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-source.html
The procedure for doing this is almost identical to the procedure used to compile the standard MySQL Server binaries for Windows, and uses the same tools. However, there are two major differences: MySQL NDB Cluster 8.4 is built from the MySQL Server ... Oracle provides precompiled NDB Cluster binaries for Windows which should be adequate for most ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview.html
NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase”). In our documentation, the term NDB refers to the part of the setup that is specific to the storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-documents-modify.html
mysql-js> db.countryinfo.modify("Code = 'SEA'").set( "demographics", {"LifeExpectancy": 78, "Population": 28}) After you modify a document, use the find() method to verify the change. mysql-js> db.countryinfo.modify("Name = 'Sealand'").unset("GNP") ... You can use the modify() method to update one or more documents in a ...