Overview of MySQL Optimization

Optimization at the database level

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

1. Are the tables structured properly?

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

3. Are the right indexes in place to make queries efficient?

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

5. Does the application use an appropriate locking strategy?

6. Are 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

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

Thanks for reading this.

Thanks

Pankaj K.

--

--

--

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

1CAT CTF Write-ups (Մաս #3) — — SanityCheck, ReverseFlash, ShortCircuit, Lunchtimedoubly, ezDecode…

CI/CD integration of Java app with Docker, TomEE and TeamCity

Cleaning up commit history with Git rebase

Performance Testing

Exception Handling | A Beginners Guide:

Becoming a Self-Taught Developer Is Worth It

Why My Variable Always Undefined ? — Learning Python

How fast are your Android CI builds? And why it matters.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Pankaj kushwaha

Pankaj kushwaha

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

More from Medium

XGBoost4J Prediction Latency Reduction

How to Optimize Parameters for Multiple QR Code Decoding in a Single Image with YOLO

Dijkstra’s Algorithm for Adjacency Matrix in Python

Communication between two separate GUIs via Multi-Threading