Author: Wang LinlinSource: UAVStack intelligent operation and maintenanceSource:Yixin Institute of TechnologyTechnology Salon 001 |AI Middle Station: An Agile Intelligent Business Support Scheme | Yixin Technology Salon Live Online at 8pm on March 28, Click to Sign Up UAVStack is a full-scale monitoring and application operation and maintenance platform. UAV.Monitor has monitoring functions, including basic monitoring, ..
Tag : Database
I introduction Themis is a database auditing product developed by DBA team of Yixin Company, which can help DBA and developers to quickly discover database quality problems and improve work efficiency. Its name comes from the goddess of justice and law in Greek mythology. The name of the project implies that the platform judges the ..
Introduction: Themis is a database auditing product developed by DBA team of Yixin Company, which can help DBA and developers to quickly discover database quality problems and improve work efficiency. This platform can audit Oracle and MySQL databases in multiple dimensions (object structure, SQL text, execution plan and execution characteristics) to evaluate the design quality ..
AWR in Oracle is all called Automatic Workload Repository, an automatic load repository. It collects operation statistics and other statistics about a specific database. Oracle takes a snapshot of all its important statistics and load information at fixed intervals (the default is 1 hour) and stores the snapshot in AWR. This information is retained in ..
Scene: Redis Interview (Image from Internet) Interviewer: I saw on your resume that you are skilled at using Redis, so why do you say Redis is used? Xiao Ming: (secretly pleased in my heart, isn’t Redis just a cache? Redis is mainly used as a cache to efficiently store non-persistent data through memory. Interviewer: Can ..
I. Hint Overview 1. Why is Hint introduced? Hint is a unique function in Oracle database, and is often used in many DBA optimizations. Then why would Oracle consider introducing an optimizer? Cost-based optimizer is very smart. In most cases, it will choose the right optimizer to reduce the burden of DBA. However, sometimes it ..
Author: feng han Source: DBAplus community share Themis open source address:https://github.com/CreditEaseDBA Expand reading:Rules Analysis and Deployment Strategy of Yixin Open Source | Database Auditing Software Themis [Technology Salon 002] Data Center: Construction Practice of Yixin Agile Data Center | Yixin Technology Salon will be broadcast live online at 8: 00 pm on May 23. Click ..
Preface Last articleRedis Gossip (1): Building Knowledge MapThis paper introduces the basic concept, advantages and disadvantages of redis and its memory elimination mechanism. I believe everyone has a preliminary understanding of redis. Redis is found in many application scenarios of the Internet, and what it can do is far beyond our imagination. What is the ..
Introduction Optimizing SQL is one of the common tasks of DBA. How to optimize a statement efficiently and quickly is a problem that every DBA often faces. In the daily optimization work, I found many operations are essential steps in the optimization process. However, repeated execution of these steps will cost DBA a a lot ..
Guide to exotic techniques The existing open source time series database influxdb only supports single-machine operation. When faced with a large amount of data writing, there will be slow query, high machine load and the limitation of single-machine capacity. In order to solve this problem, the 360 infrastructure team developed a cluster version-qtsdb on the ..
Mongodb service crashed during scheduled task operation. When the query log found the crash, records in the following two formats were fixed: command admin.$cmd command: isMaster { ismaster: 1 } numYields:0 reslen:189 locks:{} protocol:op_query 1600ms serverStatus was very slow: { after basic: 600, after asserts: 1001, after backgroundFlushing: 1302, after connections: 1701, after dur: 2194, ..
Problem description The following data are available: { “_id” : 1, “name” : “dave123”, “favorites” : [ “chocolate”, “cake”, “butter”, “apples” ] } { “_id” : 2, “name” : “li”, “favorites” : [ “apples”, “pudding”, “pie”, “cake” ] } { “_id” : 3, “name” : “ahn”, “favorites” : [ “pears”, “pecans”, “chocolate”, “cherries” ] } ..