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 Archiving

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

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 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
Fragmentation
Propagate parameter…


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. …


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 port mapping so that external machines can access the database in the virtual machine
10. Other linking methods

1.Docker:

Docker is a cloud open source project. Powerful, scalable and lightweight container solutions are provided by Docker. …


Contents:


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
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 Id (uid)=bizhi; — User name
Password=x; — Password
pooling=false; -
CharSet=utf8; — Encoding
port=x — Port

2, connection object
sql:SqlConnection
mysql:MySqlConnection

3. Command:
sql:SqlCommand
mysql:MySqlCommand

4. Parameter
sql:SqlParameter
mysql:MySqlParameter

5. Fill:
sql:SqlDataAdapter
mysql:MySqlDataAdapter

6. Query all libraries
sql: select * from [master].. [SysDatabases];
mysql:SHOW DATABASES;

7. Display all tables
sql of…


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 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…

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