https://dev.mysql.com/where-optimization.html
At one time, a scan was used based on whether the best index spanned more than 30% of the table, but a fixed percentage no longer determines the choice between using an index or a scan. This section discusses optimizations that can be made for ...
https://dev.mysql.com/window-functions-named-windows.html
Windows can be defined and given names by which to refer to them in OVER clauses. If present in a query, the WINDOW clause falls between the positions of the HAVING and ORDER BY clauses, and has this syntax: WINDOW window_name AS (window_spec) [, ...
https://dev.mysql.com/window-functions-usage.html
For example, if a table contains a TIMESTAMP column named ts, standard SQL permits PARTITION BY ts but not PARTITION BY HOUR(ts), whereas MySQL permits both. However, whereas an aggregate operation groups query rows into a single result row, a ...
https://dev.mysql.com/windows-and-ssh.html
Save everything, otherwise you will have to redo it the next time. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. Either ...
https://dev.mysql.com/windows-installation.html
If you configured MySQL as a service, then Windows will automatically start MySQL server every time you restart your system. Important MySQL 8.0 Server requires the Microsoft Visual C++ 2015 Redistributable Package to run on Windows platforms.
https://dev.mysql.com/windows-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN authentication_windows SONAME 'authentication_windows.dll'; INSTALL PLUGIN loads ... Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/windows-postinstallation.html
Make sure that the server is running (see Section 2.3.4.5, “Starting the Server for the First Time”). GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL ...
https://dev.mysql.com/windows-restrictions.html
Some versions of Windows have a boot time setting to enable larger applications by reducing the kernel application. The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not ...
https://dev.mysql.com/windows-upgrading.html
Deselect all but the MySQL server product, unless you intend to upgrade other products at this time, and click Next. There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The ...
https://dev.mysql.com/writing-full-text-plugins.html
The first parameter for this callback function should be the param value itself: param->mysql_parse(param, ...); A front end plugin can extract text and pass it all at once to the built-in parser, or it can extract and pass text to the built-in ...
