-
Anonymous users2024-02-11Installation Steps.
Run install to proceed to the next step.
developer default is the default installation type.
server only as a server.
client only acts as a client.
full fully installed type.
custom user-defined installation type.
Choose the installation according to your own situation, we take the custom installation as an example:
There are 3 options, Machine, a desktop workstation for personal use, which takes up the least amount of system resources.
Machine, MySQL servers can be run with other applications such as FTP, email, and web servers. The MySQL server is configured to use an appropriate proportion of system resources.
MySQL Server Machine: This option represents a server that only runs the MySQL service. It is assumed that no other applications are running.
The MySQL server is configured to use all available system resources.
You can choose according to your own situation, and the general web server can choose the second one, and the server machine can be! Choose the first one for PC installation, and the developer machine is better.
Proceed to the next step of installation. Just complete the installation.
-
Anonymous users2024-02-10First of all, there is an installation package. ,It's all fool installation under windows.,The next step is good.。
It's good to install the rpm of the server and client under Linux, and if you want to develop, you also need to install the development package.
-
Anonymous users2024-02-091. Double-click to enter the installation.
2. On the License Agreement page, check "I Accept the License Terms" and click "Next".
3. On the Find Latest Products page, check "skip the check for updates(no recommended)" to skip the check, and then click "Next".
4. In the Choosing a Setup Type interface, select the installation type according to the installation requirements (the default version is recommended), set the MySQL installation path and data storage path, and finally click "Next".
5. On the Check Requirements page, click "Next".
6. On the Installation Progress page, click "execute" to execute.
7. Wait for the installation progress to be completed, and click "Next".
8. Go to the Configuration Overview page and click "Next".
9. In the MySQL Server Configuration interface, do not modify it by default and click "Next".
10. Set the password of the root account.
11. Add a (non-root) user account. Its purpose is to facilitate database rights management and provide secure accounts for remote visitors.
12. The default Windows service configuration is not modified, click "Next".
13. Return to the configuration overview interface, and click "Next" after installation.
14. Pretend to dismantle the MySQL installation complete (Installation Complete), click "Finish".
Redis caching is actually to put frequently accessed data into Redis, users query first to Redis when querying, execute SQL statement query if they do not find it, and synchronize the data to Redis at the same time. Redis only performs read operations and has a fast query speed in memory. >>>More
Here are the steps to modify:
1. Of course, if the economic capacity allows, adding hardware equipment and increasing the hardware performance is the most direct and effective. >>>More
Issue. We have a sql that finds tables that don't have a primary key unique key, but it's running very slow on mysql, what should I do? >>>More
Check out proc meminfo
Tips: "Large memory page" is also known as traditional large page, large page memory, etc. helps Linux to manage virtual memory, the standard memory page is 4kb, here the use of "large memory page" can define a maximum page size of 1GB, during the system boot can use "large memory page" to reserve a part of the memory for the application, this part of the memory is occupied and will never be swapped out of the memory, it will remain there until the configuration is changed. (For details, please see the link below for the official explanation). >>>More
1. MySQL database has several configuration options that can help us capture inefficient SQL statements in a timely manner1, Slow Query Log >>>More