# DbDemo

**Repository Path**: jauking/db-demo

## Basic Information

- **Project Name**: DbDemo
- **Description**: 数据库demo，包括mysql，solr，mongodb
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-10-23
- **Last Updated**: 2025-01-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 安装
## solr安装
https://blog.csdn.net/o544033135/article/details/143118101

## Mysql安装
docker run -d --name=mysql -p 3306:3306  -e MYSQL_ROOT_PASSWORD=root mysql:5.7

## Mongodb安装
docker run -d --name mongo  -p 27017:27017 mongo

## es

docker run --name es -d -e ES_JAVA_OPTS="-Xms512m -Xmx512m" -e "discovery.type=single-node" -p 9200:9200 -p 9300:9300 elasticsearch:7.6.1
docker run -d --name kibana -p 5601:5601 -e "ELASTICSEARCH_HOSTS=http://192.168.56.1:9200" kibana:7.6.1

https://release.infinilabs.com/analysis-ik/stable/

cd /usr/share/elasticsearch/plugins

elasticsearch-plugin install https://release.infinilabs.com/analysis-ik/stable/elasticsearch-analysis-ik-7.6.1.zip


# 统计
250W中文数据

| 耗时统计 | MySQL | MongoDB | Solr | Elasticsearch |
|------|-------|---------|------|---------------|
| 入库   | 1.5M  | 1M      | 5M   | 3M            |
| 搜索   | 2s    | 5s      | 9ms  | 37ms          |