Mysql Optimization Overview

The information below I get from http://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html

Optimization at the database level

Database performance depends on several factors at the database level, such as tables, queries, and configuration settings .

1. Is the tables structured properly?

2. In particular, the columns has the right data types, and does each table has the appropriate columns for the type of work?

3. Is the right indexes on place to make queries efficient?

4. Is you using the appropriate storage engine for each table?

5. Does the application use an appropriate locking strategy?

6. Is all memory areas used for caching sized correctly?

optimizing at the Hardware level

System bottlenecks typically arise from these sources

1. Disk seeks. It takes time for the disk to find a piece of data

2. Disk Reading and writing

3. CPU Cycle

4. Memory Bandwidth

Mysql Optimization Overview