Oracle - Summary of the use of Mybatis and sql optimization
preface
Before writing, this blog will be updated constantly to sort out and summarize the sql optimization problems in the development work (actual combat process); Because the author works in the big data Department, the amount of data is basically very large, so he pays more attention to the performance under big data (but for some oper ...
Posted by AustinP on Wed, 11 May 2022 13:43:15 +0300
Containerization | building RadonDB MySQL Cluster Monitoring Platform
In the previous article, we demonstrated how to restore RadonDB MySQL Cluster Data in S3 backup. This article will demonstrate how to use Prometheus[2] + Grafana[3] in KubeSphere[1] to build a MySQL monitoring platform and enable the required monitoring indicators.
background
Prometheus text-based exposure format has become the de facto standar ...
Posted by Develop_Sake on Wed, 11 May 2022 09:46:01 +0300
Development oriented memory debugging artifact, how to use ASAN to detect memory leakage, stack overflow and other problems
The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...
Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300
The characteristics of zookeeper and the use of common commands
The characteristics of zookeeper and the use of common commands
zookeeper is a distributed, open source distributed application coordination service. It is a software that provides consistency services for distributed applications.
The application scenarios of zookeeper are as follows:
Data publishing subscription
load balancing
Naming ser ...
Posted by neoboffins on Wed, 11 May 2022 07:06:37 +0300
Installation of Oracle Database 11g Enterprise on CentOS (the most detailed and simple tutorial in the whole network)
Installation of Oracle Database 11g Enterprise on CentOS
environment
VMware Workstation 15 Pro
CentOS 7 64 bit (CentOS-7-x86_64-DVD-1810.iso)
If the environment is not ready, you can refer to: Installing CentOS for VMware virtual machines
tool
SecureCRT 8.7
SecureFX 8.7
Navicat Premium 12
PL/SQL
Installation package
Oracle Databa ...
Posted by sy-co on Tue, 10 May 2022 21:06:46 +0300
MyBatis learning notes (including SSM integration and reverse engineering)
1. Introduction to mybatis
1.1 what is MyBatis?
MyBatis official website
MyBatis is an excellent persistence layer framework that supports common SQL queries, stored procedures and advanced mapping. MyBatis eliminates almost all the manual setting of JDBC code and parameters and the retrieval of result sets. MyBatis uses simple XML or ann ...
Posted by kyme on Tue, 10 May 2022 16:23:56 +0300
SQL optimization case: implicit conversion
MySQL is one of the most popular relational databases at present. With the rapid development of the Internet, MySQL database is widely used in the production systems of e-commerce, finance and many other industries.
In the actual development, operation and maintenance process, we must often encounter the problem of slow SQL. A SQL with poor per ...
Posted by volant on Tue, 10 May 2022 09:16:01 +0300
Hyperledger Fabric chain code development practice log
1. Overview of chain code structure
Here, the development of chain code uses Go language. Therefore, we need to simply learn Go language first. It is a lightweight language. Interestingly, it has its own channel and can be concurrent, which is very suitable for the development of large-scale distributed systems. To Start the chain code, you mu ...
Posted by pmcconaghy on Mon, 09 May 2022 12:16:02 +0300
Troubleshoot high CPU usage in MongoDB
Analyze the requests being executed by the MongoDB database
1. Connect to the instance through Mongo Shell.
For details, see Mongo Shell connecting to a single node instance, Mongo Shell connecting to a replica set instance, and Mongo Shell connecting to a sharded cluster instance.
2. Execute the db.currentOp() command to view the operations cu ...
Posted by scarhand on Mon, 09 May 2022 07:46:34 +0300
Method of Sql Server Deadlock analysis
environment
The Sql Server database is deadlocked. (non emergency or emergency)
method
1. RML Utilities tool+Trace File capture deadlock
2. DBCC Capture deadlock
3. Profiler Capture deadlock
4. Trace File capture deadlock(It's time-consuming to execute offline)
5. Automatic deployment Profiler Capture deadlock
6. Service Broker Event n ...
Posted by ClevaTreva on Mon, 09 May 2022 07:07:31 +0300