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

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.

Introduction to the Postgresql database 14-server setup

server configuration

1 Setting parameters

2 File location

3 Links and authorization

3.1 Link settings

3.2 Security and authorization

4 Resource consumption

4.1 Memory

4.2 Use of Kernel Resources

4.3 cost-based vacuum delay

4.4 Backend writer process

4.5 Asynchronous behavior

5 Write header file log

5.1 Settings

5.2 Check points

5.3…

List of new features of Oracle 19c
Labels (space separated): Oracle 19c

Article Directory
List of new features of Oracle 19c
Availability
general
Simplified the management of database parameters in DG Broker
Dynamically modify the Fast-Start Failover (FSFO) target library
Broker’s FSFO supports watch-only mode
When the main database flashes back, the standby database will also flash…

What is a blockchain?

You’re willing to read this article because you’re curious about the emergence of cryptocurrencies and want to know how blockchain functions with the underlying technologies behind them.

But understanding the blockchain is not easy, at least for me. I began to practice by myself after browsing…

Task introduction

1.Docker
1.1. Docker Installation
2. Find the mirror
3. Download the mirror
4. View the mirror
5. Create a container and run it through mirroring
6. Delete the container and create a data directory for host mapping postgres
7. Check the status of the postgres container
8, enter the postgres container
9. Connection test outside the container-Complete…

Comparison of sql and mysql

1. Connection string
sql: Initial Catalog(database)=x; — database name
Data Source(source)=x;
— server Persist Security Info=True; — integrated sql server authentication
Integrated Security =True — integrated windows authentication
User ID(uid)=x;
— user name Password(pwb)=x; — password

mysql:Database=x; — database name
Data Source=x; — server
User…

Backup and restore MS SQL Server

1.One is full backup . The data that this backup includes is debatable. We know that two types of files, data files and log files, are in the database. Is the backup complete? Pack and back up all the data files…

Pankaj kushwaha

Database/System Administrator | DevOPS | Cloud Specialist | DevOPS

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