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
5.4 Streaming Copy
5.5 Asynchronous replication
5.6 Backup server
6 Query design
6.1 Design method configuration
6.2 Design cost constant
6.3 Genetic query optimization
6.4 Other design options
7 Error reporting and logging
7.1 Where to record
7.2 When to record
7.3 What to record
7.4 Use CSV format…
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 Oracle E-Business Suite Release 12.2 architecture.
You should periodically check this Document 1934915.1 on My Oracle Support for the addition of new knowledge documents, which will be listed when they become available.
There is a change log at the end of this document.
Note: This roadmap is specifically intended for…
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 back
Propagate the main library restore point
DG multi-instance REDO application supports IM
DML redirection in ADG
PDB supports recovery catalog
Regularly clear the flashback log to improve the predictability of the FRA size
The introduction of new parameters in DG is used to adjust the automatic resolution of the interruption plan
More fine-grained supplementary logs
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 a lot of videos and studying a lot of lessons, such as a trek.
1. What is a blockchain?
The blockchain is a distributed ledger that is public. …
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 port mapping so that external machines can access the database in the virtual machine
10. Other linking methods
Docker is a cloud open source project. Powerful, scalable and lightweight container solutions are provided by Docker. …
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 and can be written
Two, primary and secondary stream replication
1. Build primary and secondary stream replication
(1) The main end initializes the database
(2) Modify the parameters of the master
(4) The main end starts the database service
(5) Delete data on the standby end
(6) Basic backup of the standby end
(7) The standby end starts…
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
User Id (uid)=bizhi; — User name
Password=x; — Password
CharSet=utf8; — Encoding
port=x — Port
2, connection object
6. Query all libraries
sql: select * from [master].. [SysDatabases];
7. Display all tables
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 and log files into one file? So, when you recover, do you need to restore and re-execute the transactions that happened at the time of the backup after the backup was executed? The questions above are all positive. What the total backup does is first flush all the caches to…