https://dev.mysql.com/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...
https://dev.mysql.com/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/information-schema-optimization.html
The default is 86400 seconds (24 hours), but the time period can be extended to as much as one year. Applications that monitor databases may make frequent use of INFORMATION_SCHEMA tables. To write queries for these tables most efficiently, use the ...
https://dev.mysql.com/time-zone-support.html
The example uses values that are appropriate for the 2007 DST 1-hour change that occurs in the United States on March 11 at 2 a.m. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named ...
https://dev.mysql.com/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) mysql_stmt_fetch() returns the next row in the result set. It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that produces a result ...
https://dev.mysql.com/innodb-best-practices.html
While you don't want to commit too often, you also don't want to issue huge batches of INSERT, UPDATE, or DELETE statements that run for hours without committing. Specifying a primary key for every table using the most frequently queried column or ...
https://dev.mysql.com/timestamp-lookups.html
(The example shown earlier illustrates how this can occur.) The query specifies a search value that is within the hour of entry into DST in the session time zone. Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted ...
https://dev.mysql.com/group-replication-frequently-asked-questions.html
You can set a waiting period of up to 1 hour. Attempting to add another server to a group with 9 members causes the request to join to be refused. This limit has been identified from testing and benchmarking as a safe boundary where the group ...
https://dev.mysql.com/c-api-prepared-statement-date-handling.html
mysql_stmt_bind_param(stmt, bind); /* supply the data to be sent in the ts structure */ ts.year= 2002; ts.month= 02; ts.day= 03; ts.hour= 10; ts.minute= 45; ts.second= 20; mysql_stmt_execute(stmt); .. The binary (prepared statement) protocol ...
https://dev.mysql.com/group-replication-limitations.html
You can allow up to an hour after the initial 5-second detection period before a suspect member is expelled from the group. Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters ...
