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?
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.
1 Setting parameters
2 File location
3 Links and authorization
3.1 Link settings
3.2 Security and authorization
4 Resource consumption
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.2 Check points
Oracle E-Business Suite Release 12.2 Technology Stack Documentation Roadmap (Doc ID 1934915.1) To Bottom
This document acts as a central list of books and My Oracle Support knowledge documents that describe the recommended use and deployment of various optional and required components of the technology stack that underpins the overall…
List of new features of Oracle 19c
Labels (space separated): Oracle 19c
List of new features of Oracle 19c
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…
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…
1. PITR steps(1) Initialize the database
(2) Create an archive directory
(3) Modify the archive parameters
(4) Start the database service
(5) Basic backup
(6) Manufacturing data
(7) Close the database service
(8) Replace data
(9) Create a logo file
(10) Modify recovery parameters
(11) Start the database service and complete the recovery
(12) The verification table has been restored…
Comparison of sql and mysql
1. Connection string
sql: Initial Catalog(database)=x; — database name
— server Persist Security Info=True; — integrated sql server authentication
Integrated Security =True — integrated windows authentication
— user name Password(pwb)=x; — password
mysql:Database=x; — database name
Data Source=x; — server
There are three main types of SQL Server backup:
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…