PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are utf8mb4 and ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
On Monday at 1 p.m., we can create an incremental backup by flushing the logs to begin a new binary log file. (For example, back it up on tape or DVD, or copy it to another machine.) On Tuesday at 1 p.m., execute another mysqladmin flush-logs ...A ...
https://dev.mysql.com/doc/refman/8.0/en/sys-format-time.html
Depending on the size of the value, the units part is ps (picoseconds), ns (nanoseconds), us (microseconds), ms (milliseconds), s (seconds), m (minutes), h (hours), d (days), or w (weeks). Note As of MySQL 8.0.16, format_time() is deprecated and ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/thread-pool-tuning.html
In the worst case, this could take hours or even days. This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the number ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
This option is required for Group Replication, and also ensures correct behavior in various replication chain setups, which have become the norm today. The default value of the expire_logs_days system variable changed from 0 to 30. The new default ... Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
Why use a script? Here are a few reasons: If you run a query repeatedly (say, every day or every week), making it a script enables you to avoid retyping it each time you execute it. In the previous sections, you used mysql interactively to enter ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html
Examples of valid expr PRECEDING and expr FOLLOWING indicators: 10 PRECEDING INTERVAL 5 DAY PRECEDING 5 FOLLOWING INTERVAL '2:30' MINUTE_SECOND FOLLOWING expr FOLLOWING: For ROWS, the bound is expr rows after the current row. The definition of a ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-tuning.html
For example, imagine a system that monitors traffic crossing a busy bridge, recording data for approximately 100,000 vehicles each day. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or ...