# mysql-data-base

**Repository Path**: cicadasmile/mysql-data-base

## Basic Information

- **Project Name**: mysql-data-base
- **Description**: MySQL基础，进阶，性能优化，管理工具，配置等核心模块。
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 9
- **Forks**: 19
- **Created**: 2019-12-22
- **Last Updated**: 2025-04-15

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# data-base

## 1、仓库说明

MySQL数据库基础、进阶总结。

## 2、分类文档

- **MySQL基础**

    - [经典查询案例，总结整理](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/B01、基础查询案例.md)
    - [多个维度思考表结构设计](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/B02、表结构设计.md)
    - [函数总结，触发器使用详解](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/B03、函数与触发器.md)
    - [存储过程和视图用法总结](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/B04、存储过程与视图.md)
    - [用户权限管理，日志体系简介](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/B05、用户权限与日志.md)

- **MySQL进阶**

    - [逻辑架构与存储引擎详解](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/S01、架构与存储引擎.md)
    - [事务管理，锁机制案例详解](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/S02、事务与锁机制.md)
    - [基于多个维度，分析服务器性能](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/S03、服务器性能分析.md)
    - [索引体系划分，B-Tree结构说明](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/S04、索引与树结构.md)
    - [合理的使用索引结构和查询](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/mysql/S05、高性能索引查询.md)

- **PostgreSQL**

    - [PostgreSQL环境搭建与入门](https://gitee.com/cicadasmile/butte-java-note/blob/master/doc/database/postgresql/P01、PostgreSQL环境搭建.md)

## 3、仓库整合

| 仓库 | 描述 |
|:---|:---|
| [butte-java](https://gitee.com/cicadasmile/butte-java-note) |Java编程文档整理，基础、架构，大数据 |
| [butte-frame](https://gitee.com/cicadasmile/butte-frame-parent) |微服务组件，中间件，常用功能二次封装 |
| [butte-flyer](https://gitee.com/cicadasmile/butte-flyer-parent) |butte-frame二次浅封装，实践案例 |
| [butte-auto](https://gitee.com/cicadasmile/butte-auto-parent) |Jenkins+Docker+K8S实现自动化持续集成 |
| [java-base](https://gitee.com/cicadasmile/java-base-parent) | Jvm、Java基础、Web编程，JDK源码分析 |
| [model-struct](https://gitee.com/cicadasmile/model-arithmetic-parent) | 设计模式、数据结构、算法 |
| [data-manage](https://gitee.com/cicadasmile/data-manage-parent) | 架构设计，实践，数据管理、工具 |
| [spring-mvc](https://gitee.com/cicadasmile/spring-mvc-parent) | Spring+Mvc框架基础总结 |
| [spring-boot](https://gitee.com/cicadasmile/spring-boot-base) | SpringBoot2基础，应用、配置等 |
| [middle-ware](https://gitee.com/cicadasmile/middle-ware-parent) | SpringBoot2进阶，整合常用中间件 |
| [spring-cloud](https://gitee.com/cicadasmile/spring-cloud-base) | Spring+Ali微服务基础组件用法|
| [cloud-shard](https://gitee.com/cicadasmile/cloud-shard-jdbc) | SpringCloud实现分库分表实时扩容 |
| [husky-cloud](https://gitee.com/cicadasmile/husky-spring-cloud) | SpringCloud综合入门案例 |
| [big-data](https://gitee.com/cicadasmile/big-data-parent) | Hadoop框架，大数据组件，数据服务 |
| [mysql-base](https://gitee.com/cicadasmile/mysql-data-base) | MySQL数据库基础、进阶总结 |
| [linux-system](https://gitee.com/cicadasmile/linux-system-base) | Linux系统基础，环境搭建、配置 |