January 2019
Intermediate to advanced
286 pages
7h 41m
English
Content preview from Advanced MySQL 8
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Tip 3 – understand your material resources
To work, a database server needs a good balanced dose of four core resources:
- CPU or processors
- RAM or live memory
- Disks
- Networks
If one of them is weak or overloaded, the database server will be impacted in performance.
One of the optimization tasks is to understand the material resources, which can be divided into two categories—the best choice of hardware and the identification of problems.
When choosing hardware for MySQL, we must ensure that we have powerful components, even if we have virtualization. It is important that we have a balance between these components. I have noticed over time that companies choose servers with processors and hard disks that are fast, but that require a lot of ...