1. MySQL architecture: 1. Client connector: mainly includes JDBC, PHP, python, etc. to connect to MySQL. 2. MySQL Server: MySQL Server, MySQL server is generally composed of connection layer, service layer, engine layer and storage layer 1. Connection layer: Mainly responsible for accepting client connections and completing some authorization and authentication management. For example, when […]
Tag: dex
mysql user rights management index transaction storage engine
DDL:CTETATE DROP ALTER dml: manage data update insert into delete truncate dql: query statement select dcl: permission control statement grant revoke User rights management: create user ‘username’@’20.0.0.51’ idetified by ‘123456’; grant all select,insert,drop set password =password(‘123456’) set password for ‘username’@’localhost’ = password(‘adc123’); show grants for ‘root’@’20.0.0.51’; flush privileges; Permissions Permission Description Permission Level td> create […]
Elasticsearch (3) —Index
Syntax curl usage for indexed documents CURL: Simply think of it as a tool that can access URLs from the command line. curl is an open source file transfer tool that uses URL syntax to work in command line mode. Common get/post requests can be easily implemented using curl. curl -X specifies the http request […]
[MySQL Index and Optimization] Index optimization and query optimization
Index optimization and query optimization Article directory Index optimization and query optimization 1 Overview 2. Index failure case 3. Related query optimization 3.1 Principle of Join statement 3.2 Simple Nested-Loop Join (simple nested loop connection) 3.3 Index Nested-Loop Join (Index Nested Loop Join) 3.4 Block Nested-Loop Join (block nested loop connection) 3.5 Hash Join 3.6 […]
Building a multi-agent RAG using Llama index
Retrieval-augmented generation (RAG) has become a powerful technique to enhance the capabilities of large language models (LLM). By retrieving relevant information from knowledge sources and incorporating it into prompts, RAG provides LLM with useful context to produce fact-based output. However, existing single-agent RAG systems face the challenges of low retrieval efficiency, high latency, and suboptimal […]
Look at index structure selection from the comparison of Hash index, binary tree, B-Tree and B+Tree
Look at index structure selection from the comparison of Hash index, binary tree, B-Tree and B + Tree 1. Hash structure 1.1. About Hash data structure 1.2. Why not choose Hash structure for InnoDB index? 1.3. About InnoDB providing adaptive Hash index (Adaptive Hash Index) 2. Binary search tree 3. Balanced binary tree (AVL tree) […]
SQL optimization (slow query optimization method) correctly uses database indexes
Article directory (1) Correct posture for creating indexes 1) Indexes should not contain fields with low selectivity 2) Put highly selective fields in front or create separate indexes 3) Try to use covering indexes (2) Correct posture for using index 1) Leftmost matching truncation 2) Implicit conversion 3) in + order by causes sorting to […]
[MySQL Indexing and Optimization] Use of database optimization and performance analysis tools
Using database optimization and performance analysis tools Article directory Use of database optimization and performance analysis tools 1. Steps for database server optimization 2. Query system performance parameters 3. Locate the SQL that is fully executed: slow query log 4. View SQL execution costs: show profile 5. Analysis query tool: explain 5.1id 5.2 type 6. […]
RSA: Attack methods and thinking skills based on small encryption index
Directory Table of Contents Table of contents Zero, Preface 1. Small encryption index explosion [FSCTF]RSA Sign-in Idea: 2. Finite field roots based on small encryption exponent [NCTF 2019]easyRSA Idea: 3. CRT based on small encryption index [0CTF 2016]rsa Idea: Zero, Preface Recently, I found that my ideas for answering questions were quite confusing. In general, […]
OceanBase global index and local index exploration
OceanBase global index and local index exploration results in local area search and cross-region search. The author: Internet name Big Data Model, knows more about manufacturing, banking, and communications industries, and is concerned about the application practice of domestic database technology evangelism and data asset construction. Produced by the Aikeson open source community. Original content […]