Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | Facebook | Linkedin | Youtube | 打赏(Donations) | About

Netkiller Database 手札
		下一页

Netkiller Database 手札

PostgreSQL, MariaDB, MySQL, Oracle, Redis, MongoDB, Elasticsearch ...

Mr. Neo Chan, 陈景峯(BG7NYT)

中国广东省深圳市望海路半岛城邦三期
518067
+86 13113668890

<netkiller@msn.com>

文档初创于April 6, 2008

电子书最近一次更新于 2025-11-16 08:00:34

版权 © 2009-2019 Netkiller(Neo Chan). All rights reserved.

版权声明

转载请与作者联系，转载时请务必标明文章原始出处和作者信息及本声明。

http://www.netkiller.cn

http://netkiller.github.io

http://netkiller.sourceforge.net

微信公众号: netkiller

微信：13113668890 请注明“读者”

QQ：13721218 请注明“读者”

QQ群：128659835 请注明“读者”

知乎专栏

$Date: 2013-05-21 19:01:33 +0800 (Tue, 21 May 2013) $

Netkiller 数据库系列手札

数据库系列手札

Netkiller Database 手札

|

Netkiller PostgreSQL 手札

|

Netkiller MySQL 手札

|

Netkiller NoSQL 手札

|

Netkiller LDAP 手札

致读者

Netkiller 系列手札已经被 Github 收录，并备份保存在北极地下250米深的代码库中，备份会保留1000年。

Preserving open source software for future generations

The world is powered by open source software. It is a hidden cornerstone of modern civilization, and the shared heritage of all humanity.

The GitHub Arctic Code Vault is a data repository preserved in the Arctic World Archive (AWA), a very-long-term archival facility 250 meters deep in the permafrost of an Arctic mountain.

We are collaborating with the Bodleian Library in Oxford, the Bibliotheca Alexandrina in Egypt, and Stanford Libraries in California to store copies of 17,000 of GitHub’s most popular and most-depended-upon projects—open source’s “greatest hits”—in their archives, in museum-quality cases, to preserve them for future generations.

https://archiveprogram.github.com/arctic-vault/

目录

1.1. 写给读者
1.2. 作者简介
1.3. 如何获得文档
1.4. 打赏（Donations）
1.5. 联系方式

I. Database Relational

1. DB-Engines - DB-Engines Ranking

2. SysBench

3. SuperSmack

4. ETL (Extract-Transform-Load)

4.1. Kettle

4.1.1. 安装

5. 数据迁移

5.1. Apache Sqoop

6. GreenSQL

7. Database design & E-R diagram

7.1. opensource database design tools
7.2. OpenSystemArchitect
7.3. SQL Power Architect

II. Search Engine

8. Meilisearch

8.1. 安装

9. Elasticsearch

9.1. 安装 Elasticsearch

9.1.1. Docker 8.8.1
9.1.2. IK 分词
9.1.3. Helm Chart 安装 Elasticsearch
9.1.4. Elastic Cloud on Kubernetes
9.1.5. docker-compose 安装
9.1.6. Kubernetes
9.1.7. netkiller-devops 编排 elasticsearch
9.1.8. 安装指定版本的 Elasticsearch
9.1.9. Plugin
9.1.10. netkiller-devops 编排 Kubernetes

9.2. 文档API

9.2.1. 快速上手
9.2.2. 写入 PUT/POST
9.2.3. 获取 GET
9.2.4. 检查记录是否存在
9.2.5. 删除 Delete
9.2.6. 参数

9.3. 搜索

9.3.1. URL 搜索
9.3.2. 分页

9.4. Query DSL

9.4.1. match 匹配
9.4.2. multi_match 多字段匹配
9.4.3. Query bool 布尔条件
9.4.4. filter 过滤
9.4.5. sort 排序
9.4.6. _source
9.4.7. highlight 高亮处理

9.5. 集群管理

9.5.1. 节点健康状态
9.5.2. 节点http状态
9.5.3. 查看master节点
9.5.4. 查看索引的节点分布
9.5.5. 索引的开启与关闭

9.6. 中文分词插件管理

9.6.1. 通过 elasticsearch-plugin 命令安装分词插件
9.6.2. 手工安装插件
9.6.3. 创建索引
9.6.4. 删除索引
9.6.5. 配置索引分词插件

9.7. 索引管理

9.7.1. 查看索引
9.7.2. 删除索引

9.8. 映射

9.8.1. 查看 _mapping
9.8.2. 删除 _mapping
9.8.3. 创建 _mapping
9.8.4. 更新 mapping
9.8.5. 修改 _mapping
9.8.6. 数据类型

9.9. Alias management 别名管理

9.9.1. 查看索引别名
9.9.2. 创建索引别名
9.9.3. 修改别名
9.9.4. 删除别名

9.10. Example

9.10.1. 新闻资讯应用案例
9.10.2. 文章搜索案例

9.11. Migrating MySQL Data into Elasticsearch using logstash

9.11.1. 安装 logstash
9.11.2. 配置 logstash
9.11.3. 启动 Logstash
9.11.4. 验证
9.11.5. 配置模板
9.11.6. 解决数据不对称问题
9.11.7. 修改 Mapping

9.12. ElasticHD

9.13. 安装 Elasticsearch 早起版本

9.13.1. 6.x 安装
9.13.2. 单机模式 (适用于开发环境) 5.x
9.13.3. Elasticsearch Cluster 5.x
9.13.4. RPM 安装
9.13.5. YUM 安装
9.13.6. 测试安装是否正常
9.13.7. Plugin 插件管理

9.14.1. Plugin [analysis-ik] is incompatible with Elasticsearch [2.3.5]. Was designed for version [2.3.4]
9.14.2. plugin [analysis-ik] is incompatible with version [5.6.1]; was designed for version [5.5.2]
9.14.3. mapper_parsing_exception: failed to parse [ctime]
9.14.4. 配置 JAVA_HOME
9.14.5. memory locking requested for elasticsearch process but memory is not locked

10. Manticore Search

10.1. 安装

10.1.1. Ubuntu
10.1.2. Ubuntu
10.1.3. Docker

10.2. Sphinx

11.1. 安装

11.2. Core Admin

11.2.1. Schema

11.3. 索引

11.3.1. Indexing a directory of "rich" files
11.3.2. Indexing Solr XML
11.3.3. Indexing JSON
11.3.4. Deleting Data

11.4. 接口

11.4.1. 查询

11.5.1. NOTE: Please install lsof as this script needs it to determine if Solr is listening on port 8983.

11.6. Solr 1.3.0

11.6.1. Embedded Jetty
11.6.2. Jetty
11.6.3. Tomcat
11.6.4. solr-php-client
11.6.5. multicore
11.6.6. 中文分词

17. Apache Hbase

17.1. 安装 Apache Hbase

17.1.1. 单机模式安装
17.1.2. 伪分布式模式
17.1.3. 分布式模式部署
17.1.4. 运维技巧

17.2. 配置 Apache Hbase

17.2.1. hbase-env.sh
17.2.2. hbase-site.xml

17.3. Hbase Shell

17.3.1. 表操作

17.4. Web UI

17.5. Phoenix

17.5.1. 安装 Phoenix
17.5.2. sqlline.py 命令行界面
17.5.3. SQuirreL SQL Client

17.6.1. HBaseConfTool : Unsupported major.minor version 51.0
17.6.2. ignoring option PermSize=128m; support was removed in 8.0

18. Apache Hive

18.1. 安装 Apache Hive

18.1.1. MySQL
18.1.2. Hadoop
18.1.3. Hive
18.1.4. 启动 Hive
18.1.5. 访问 Hive
18.1.6. 配置 hiveserver2

18.2. beeline

18.3. 管理 Hive

18.3.1. 表管理
18.3.2. 分区表
18.3.3. 视图管理
18.3.4. 数据管理
18.3.5. HDFS与本地文件系统管理

18.4. HiveQL - Hive查询语言

18.4.1. JOIN 连接查询
18.4.2. 子查询

18.5.1. adoop.security.authorize.AuthorizationException): User: hadoop is not allowed to impersonate anonymous

19. Apache Sqoop

19.1. 安装 Sqoop

19.2. sqoop2-tool

19.2.1. verify
19.2.2. upgrade

19.3. sqoop2-shell

19.3.1. show version
19.3.2. set
19.3.3. show connector
19.3.4. link
19.3.5. job
19.3.6. update

19.4.1. Unable to load native-hadoop library for your platform

20. MySQL Server

20.1. MySQL 安装

20.1.1. Rocky Linux
20.1.2. CentOS
20.1.3. Docker
20.1.4. Ubuntu/Debian
20.1.5. 源码安装
20.1.6. 二进制版本
20.1.7. Installing MySQL on Linux Using the MySQL Yum Repository
20.1.8. Firewall
20.1.9. Mac OS
20.1.10. 重置数据库
20.1.11. MariaDB
20.1.12. Percona

20.2. MySQL Plugin

20.2.1. validate_password
20.2.2. MySQL Images manager
20.2.3. MySQL fifo
20.2.4. 内容输出到文本插件

20.3. Replication

20.3.1. Master Slave
20.3.2. Master Master(主主)
20.3.3. Semisynchronous Replication
20.3.4. multi-master replication
20.3.5. multi-source replication
20.3.6. 与复制有关的问题
20.3.7. GTID

20.4. MySQL Custer

20.4.1. Management node (MGM node)
20.4.2. Data node
20.4.3. SQL node
20.4.4. Starting
20.4.5. Shutdown
20.4.6. Testing

20.5. MySQL Proxy

20.5.1. Ubuntu
20.5.2. CentOS

20.6. MySQL Router

20.6.1. 安装 MySQL Router
20.6.2. 配置 MySQL Router
20.6.3. MySQL Router ， Haproxy，LVS 的选择

20.7. my.cnf

20.7.1. bind-address
20.7.2. 禁用TCP/IP链接
20.7.3. 配置字符集
20.7.4. 最大链接数 max_connections
20.7.5. 默认引擎 storage-engine
20.7.6. max_allowed_packet
20.7.7. skip-name-resolve
20.7.8. timeout
20.7.9. 与复制有关的参数
20.7.10. 与 InnoDB 有关的配置项
20.7.11. EVENT 设置
20.7.12. 日志
20.7.13. MySQL 5.7 my.cnf 实例
20.7.14. Example for my.cnf

20.8. variables

20.8.1. 查询多个变量
20.8.2. time_zone
20.8.3. sql_mode
20.8.4. wait_timeout
20.8.5. table_lock_wait_timeout
20.8.6. low_priority_updates
20.8.7. collation_server
20.8.8. character_set
20.8.9. datadir
20.8.10. plugin_dir
20.8.11. storage_engine
20.8.12. timeout
20.8.13. max_connections
20.8.14. 自动提交 autocommit

20.9. Monitoring

20.9.1. Analysis and Optimization
20.9.2. Cacti
20.9.3. Monitoring MySQL with SNMP

21. Client and Utility Programs

21.1. mysql - the MySQL command-line tool

21.1.1. ~/.my.cnf
21.1.2. 屏幕输出到文件
21.1.3. 终端编码
21.1.4. Unix Socket
21.1.5. 重定向巧用
21.1.6. --sigint-ignore 忽略 Ctrl + C
21.1.7. mysql log

21.2. mysqldump - a database backup program

21.2.1. 备份数据库结构和数据
21.2.2. 备份数据库结构和数据并压缩文件
21.2.3. 备份到文件
21.2.4. 备份数据库结构/表
21.2.5. 备份数据库，无结构，只有数据
21.2.6. 备份所有数据库
21.2.7. 使用完整的insert插入数据
21.2.8. --extended-insert / --skip-extended-insert
21.2.9. --skip-lock-tables
21.2.10. --skip-add-locks
21.2.11. --where
21.2.12. 注释信息--comments /--skip-comments
21.2.13. 不导出注释信息
21.2.14. 字符集设置

21.3. mysqladmin - client for administering a MySQL server

21.3.1. reload
21.3.2. 更改密码
21.3.3. status
21.3.4. process list

21.4. myisamchk — MyISAM Table-Maintenance Utility

21.5. mysqlcheck — A Table Maintenance and Repair Program

21.6. mysqlslap - load emulation client

21.7. mysqldumpslow - Parse and summarize the MySQL slow query log.

21.8. mysql-shell

21.9. mycli

21.10. MySQL慢查询日志（Slow Query Log）

21.10.1. MySQL 8.x
21.10.2. MySQL 5.x

21.11. mysql-admin

21.12. MySQL Workbench 数据库恢复

22. 数据库管理（Database Administration)

22.1. 用户管理（User Account Management）

22.1.1. 创建用户
22.1.2. 删除用户
22.1.3. 修改用户名
22.1.4. 修改密码

22.2. Access Privilege System

22.2.1. SHOW GRANTS
22.2.2. show privileges
22.2.3. Grant privileges
22.2.4. Revoke privileges
22.2.5. Show Privileges
22.2.6. MAX_QUERIES_PER_HOUR/MAX_UPDATES_PER_HOUR
22.2.7. Table Privileges
22.2.8. Column Privileges

22.3. 字符集转换

22.3.1. 转换 latin1 到 UTF-8

22.4. 重新整理AUTO_INCREMENT字段

22.5. 数据库内容替换

22.6. Kill 脚本

22.7. MySQL 时区管理

22.8. SHOW COMMAND

22.8.1. 查看版本
22.8.2. status
22.8.3. show processlist
22.8.4. 线程的使用情况
22.8.5. DATABASES
22.8.6. 排序统计信息
22.8.7. Key 状态
22.8.8. FUNCTION
22.8.9. PROCEDURE
22.8.10. TRIGGERS
22.8.11. EVENTS
22.8.12. 引擎(ENGINES)
22.8.13. 字符集(Collation)
22.8.14. SHOW GRANTS
22.8.15. validate_password

22.9. Maintenance 数据库维护

22.9.1. CHECK 检查表
22.9.2. ANALYZE 分析表
22.9.3. CHECKSUM
22.9.4. OPTIMIZE 优化表
22.9.5. REPAIR 修复

22.10. INFORMATION_SCHEMA

22.10.1. 查询表字段
22.10.2. 列出所有触发器
22.10.3. 查看表数据尺寸

22.11. Backup and Recovery

22.11.1. Import / Export
22.11.2. Snapshot Backup

23. DDL - Data Definition Language

23.1. 数据库管理(Database)

23.1.1. 创建数据库
23.1.2. 删除数据库
23.1.3. 修改数据库
23.1.4. 重命名数据库
23.1.5. 修改字符集
23.1.6. 查看数据库创建语句

23.2. 表管理(Table)

23.2.1. 数据类型
23.2.2. 基于现有表结构创建新空表
23.2.3. 基于已存在表创建新表
23.2.4. 修改表
23.2.5. 临时表
23.2.6. CHARACTER
23.2.7. DEFAULT
23.2.8. KEY
23.2.9. AUTO_INCREMENT 定义初始值
23.2.10. COMMENT
23.2.11. 修改表名
23.2.12. Engine 存储引擎

23.3. Partitioning

23.3.1. RANGE
23.3.2. LIST
23.3.3. HASH
23.3.4. KEY分区
23.3.5. Subpartitioning
23.3.6. 分区管理
23.3.7. EXPLAIN PARTITIONS
23.3.8. SHOW CREATE TABLE
23.3.9. INFORMATION_SCHEMA.partitions 表
23.3.10. 分区数据操作

23.4. Index

23.4.1. SHOW INDEX
23.4.2. CREATE INDEX
23.4.3. DROP INDEX
23.4.4. rebuild

23.5. 外键(Foreign Key)

23.5.1. FOREIGN KEY (RESTRICT)

23.6. 视图(View)

23.7. 存储过程(PROCEDURE)

23.7.1. 存储程序
23.7.2. EXECUTE 执行 SQL
23.7.3. PREPARE 传递参数
23.7.4. 存储过程返回数据
23.7.5. 结果集转JSON
23.7.6. 例子·过程返回结果

23.8. 函数

23.8.1. TIMESTAMP TO ISO8601

23.9. 触发器(Trigger)

23.9.1. create trigger
23.9.2. drop trigger
23.9.3. show triggers
23.9.4. EXAMPLE

23.10. 事件调度器(EVENT)

23.10.1. 启用 EVENT
23.10.2. 创建 EVENT
23.10.3. 禁用/启用
23.10.4. 查看 events
23.10.5. 删除 EVENT
23.10.6. EVENT 应用案例

24. DML (Data Manipulation Language)

24.1. INSERT 插入

24.1.1. INSERT INTO ... SELECT
24.1.2. INSERT IGNORE
24.1.3. INSERT...ON DUPLICATE KEY UPDATE

24.2. REPLACE 替换

24.3. DELETE 删除

24.3.1. 删除重复数据
24.3.2. 删除重复数据保留第一条

25. SQL Statement Syntax

25.1. DISTINCT

25.2.1. LEFT JOIN / LEFT OUTER JOIN
25.2.2. JOIN / INNER JOIN

25.3. order by 排序

25.3.1. 处理 null

25.4. group by

25.4.1. 忽略 NULL

25.5. HAVING

25.6. REGEXP

25.7. IN / NOT IN

25.8. ALL / Any

25.9. exists, not exists

25.10. UNION

25.10.1. UNION ALL
25.10.2. 两张表字段不对等解决方法

25.11. OUTFILE/LOAD DATA INFILE

25.11.1. Export data to CSV from MySQL
25.11.2. Import data from CSV file.

25.12. CASE Syntax

25.13. 查询结果放入变量

25.14. MySQL 专有命令

25.14.1. SQL_NO_CACHE
25.14.2. SIGNAL Syntax

25.15. SQL 92

26. Functions and Operators

26.1. COUNT

26.2. UUID()

26.3. 字符串

26.3.1. LEFT/RIGHT
26.3.2. RPAD/LPAD
26.3.3. CONCAT
26.3.4. CONCAT_WS
26.3.5. 链接所有字段
26.3.6. GROUP_CONCAT
26.3.7. replace 字符串替换
26.3.8. SUBSTRING
26.3.9. SUBSTRING_INDEX
26.3.10. AES_ENCRYPT / AES_DECRYPT

26.4. Date and Time

26.4.1. year/month/day hour:minite:second
26.4.2. Unix time
26.4.3. DATE_FORMAT
26.4.4. DATE_SUB/DATE_ADD
26.4.5. datediff / timediff

26.5. 数值函数

26.5.1. cast 类型转换
26.5.2. truncate 保留小数位数
26.5.3. MOD 求余

26.6. Control Flow Functions

27. DCL (Data Control Language)

27.1.1. 共享锁
27.1.2. 排他锁
27.1.3. 锁
27.1.4. 锁等待与超时

27.2. 事务处理和锁定语句

27.2.1. 事务隔离级别
27.2.2. 事务所用到的表
27.2.3. 解决更新冲突
27.2.4. 共享锁
27.2.5. SAVEPOINT

28. Optimization

28.1. Limit 状态

28.2. 使用 Btrfs 文件系统存储mysql数据

28.3. 打开表的数量

28.4. Buffering and Caching

28.4.1. Query Cache SELECT Options

28.5. where 优化

28.6. SHOW PROFILE Syntax SQL性能分析器

28.7. PROCEDURE ANALYSE()

29. MySQL Connectors

29.1. JDBC
29.2. ODBC
29.3. MySQL native driver for PHP - mysqlnd
29.4. python-mysqldb

30. MySQL GUI/Web Manager

30.1. HeidiSQL
30.2. Toad for MySQL Freeware
30.3. phpMyAdmin - MySQL web administration tool
30.4. Maatkit Essential command-line utilities for MySQL

31. Miscellaneous

31.1. Multi-Master Replication Manager for MySQL
31.2. MHA
31.3. HandlerSocket
31.4. Maatkit
31.5. Mroonga
31.6. Amoeba

32.1. Reset root password 重置MySQL root密码

32.1.1. MySQL 5.7.x
32.1.2. MySQL 8.0

32.2. 查看错误代码

32.2.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
32.2.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

32.3. 临时表是否需要建索引

32.4. [Warning] Changed limits: max_open_files: 5000 (requested 20480)

32.5. Table 'performance_schema.session_variables' doesn't exist

32.6. SQL Error (1038): Out of sort memory, consider increasing server sort buffer size

32.7. this is incompatible with sql_mode=only_full_group_by

32.8. ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes

32.9. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists

32.10. ERROR 1114 (HY000): The table 'your_table' is full

32.11. Error Code: 1146. Table 'test.CACHE_UPDATE' doesn't exist

32.12. Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

32.13. ERROR 1273 (HY000) at line 3364: Unknown collation: 'utf8mb4_0900_ai_ci'

32.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

32.15. ERROR 1364: 1364: Field 'id' doesn't have a default value

32.16. Error Code: 1292. Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 95692

32.17. ERROR 1415: Not allowed to return a result set from a trigger

32.18. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

32.19. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

32.20. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

32.21. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

32.22. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

32.23. ERROR 2013 (HY000): Lost connection to MySQL server during query

32.24. ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

32.25. ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

32.26. Error Code: 3780. Referencing column 'id' and referenced column 'id' in foreign key constraint 'FKfeti3hcwwku7l7xqru4emwkc6' are incompatible.

32.27. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory

32.28. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

32.29. mysqldump: Couldn't execute 'SELECT COLUMN_NAME,

32.30. this is incompatible with sql_mode=only_full_group_by

32.31. mysqldump: [Warning] Using a password on the command line interface can be insecure.

32.32. mysql: [Warning] Using a password on the command line interface can be insecure.

32.33. 时间自动被加一秒

33. Redis 安装

33.1. Rocky Linux

33.2. CentOS 8 Stream

33.3. CentOS 7

33.4. CentOS 6

33.4.1. 主从同步
33.4.2. Sentinel

33.5. Ubuntu

33.6. Mac 安装 Redis

33.7. 源码编译安装

33.8. Test Redis

34. /etc/redis.conf

34.1. 备份配置文件
34.2. 绑定配置
34.3. 密码认证
34.4. maxmemory-policy TTL 过期策略配置
34.5. aclfile

35. redis-cli - Command-line client to redis-server

35.1. 命令参数

35.1.1. password
35.1.2. raw

35.2. --latency Enter a special mode continuously sampling latency.

35.3. 清空指定数据库

35.4. 用户认证

35.4.1. 传统 requirepass 认证

35.5. ACL 用户/密码认证

35.5.1. 查看用户列表
35.5.2. 用户删除
35.5.3. 设置默认密码
35.5.4. 创建用户
35.5.5. 查看 ACL 列表
35.5.6. 检验用户名和密码

35.6. MONITOR

35.8. save/bgsave/lastsave

35.9. config

35.10. keys

35.11. 字符串操作

35.11.1. set/get/del
35.11.2. setnx

35.12. expire/ttl

35.13. 获取 key 类型

35.14. LIST 数据类型

35.15. set 无序字符集合

35.15.1. 查看元素是否存在

35.16. zset (有序集合)

35.17. HASH

35.18. Pub/Sub 订阅与发布

35.19. flushdb 清空 Redis 数据

36. redis-benchmark 测试工具

37. Redis Cluster

38. Redis 通信协议

38.1. 切换DB
38.2. 监控

39. Redis 开发

39.1. 消息订阅与发布
39.2. 选择数据库

40.1. 导出 / 导入
40.2. phpRedisAdmin
40.3. A fast, light-weight proxy for memcached and redis

41.1. 清空数据库
41.2. (error) MISCONF Redis is configured to save RDB snapshots
41.3. You can't write against a read only replica.
41.4. MISCONF Redis is configured to save RDB snapshots, but it's currently unable to persist to disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error.
41.5.

43. Install 安装MongoDB

43.1. CentOS 8 Stream

43.2. MacOS 安装 MongoDB

43.3. 二进制tar包安装

43.4. Ubuntu MongoDB

43.5. CentOS 7 MongoDB

43.6. 从官网安装最新版本的 MongoDB 3.4

43.6.1. Server
43.6.2. Client
43.6.3. 工具

43.7. MongoDB + Hadoop

43.8. OSCM 一键安装 MongoDB 4.0.2

43.9. Replication

43.9.1. Master
43.9.2. Slave
43.9.3. 测试

43.10. Drivers

43.10.1. Using MongoDB in PHP

44. MongoDB 管理

44.1. Security and Authentication

44.1.1. 超级管理员
44.1.2. 数据库访问用户
44.1.3. 数据库监控用户
44.1.4. 删除用户
44.1.5. 更新角色

44.2. 4.0早期旧版本

45. 命令工具

45.1. mongo - MongoDB Shell

45.1.1. eval
45.1.2. help
45.1.3. 登陆认证
45.1.4. 管道操作

45.2. mongodump - Backup

45.2.1. 本地备份
45.2.2. 远程备份

45.3. mongorestore

45.3.1. 本地恢复
45.3.2. 远程恢复
45.3.3. filter

45.4. mongostat

45.5. mongotop

45.6. mongofiles - Browse and modify a GridFS filesystem.

45.6.1. list 浏览文件
45.6.2. put 上传文件
45.6.3. get 下载
45.6.4. delete 删除

46. MongoDB Shell

46.1. shutdownServer

46.2. show 查看命令

46.2.1. show dbs
46.2.2. show collections
46.2.3. show users
46.2.4. show profile

46.3. 切换数据库

46.4. Collection 管理

46.4.1. 创建 Collection
46.4.2. 删除 collection
46.4.3. 删除字段

46.6. insert

46.7. update

46.7.1. multi 更新所有数据
46.7.2. upsert 更新，如果不存在则插入数据
46.7.3. updateMany 更新集合中的所有数据

46.8. remove

46.8.1. 删除条件使用 _id

46.9. count()

46.10. 查询

46.10.1. find() MongoDB 2.x
46.10.2. find() MongoDB 3.x
46.10.3. group()

46.11. aggregate

46.11.1. project
46.11.2. groupby + sum

46.12. Indexes 索引

46.12.1. 查看索引
46.12.2. 创建索引
46.12.3. 删除索引
46.12.4. 唯一索引
46.12.5. 复合索引
46.12.6. 稀疏索引

46.13. Map-Reduce

46.13.1. 使用 Map-Reduce 统计Web 服务器 access.log 日志文件

46.14. 内嵌对象

46.14.1. Array / List 列表类型

46.15. Javascript 脚本

47. Mongo Admin UI

47.1. RockMongo
47.2. MongoVUE

48. Cassandra

48.1. Getting Started

48.1.1. Downloading and Installation
48.1.2. Running Cassandra
48.1.3. cli tool
48.1.4. Testing Cassandra

48.2. Configure Cassandra

48.2.1. Envionment variables
48.2.2. log4j.properties
48.2.3. storage-conf.xml

48.3. Keyspace

48.3.1. Schema
48.3.2. Keyspace example

48.4. Cluster

48.4.1. Running a cluster
48.4.2. Running a single node
48.4.3. nodetool

49. Hypertable

49.1. Hypertable 安装

49.1.1. Hypertable standalone 单机安装
49.1.2. Hypertable on HDFS(hadoop) 安装
49.1.3. MapR
49.1.4. Ceph
49.1.5. 检验安装

49.2. Code examples

49.2.1. PHP

49.3.1. namespace 命名空间管理
49.3.2. Table 表

49.4.1. 切换 DFS Broker

50. CouchBase

50.1. 安装 CouchBase

50.1.1. Getting Started with Couchbase on PHP

50.2. couchbase 命令

50.2.1. couchbase-cli

51. Memcached

51.1. 安装 Memcached

51.1.1. CentOS 下编译
51.1.2. Ubuntu 下编译安装
51.1.3. debian/ubuntu
51.1.4. yum install

51.2. Memcached 代理

51.2.1. moxi
51.2.2. memagent

52. RethinkDB

53. TokyoCabinet/Tyrant

55. Voldemort

56. LevelDB

57. HyperDex

VI. PostgreSQL

59. PostgreSQL 安装

59.1. Ubuntu 12.04.1 LTS 安装

59.2. YUM 默认源安装

59.3. PostgreSQL 官方 YUM 源安装

59.3.1. 9.2
59.3.2. 9.3
59.3.3. 9.4
59.3.4. 9.6
59.3.5. PostgreSQL 10

59.4. PostgreSQL 配置

59.4.1. postgresql.conf
59.4.2. pg_hba.conf

59.5. 创建dba用户

60. 数据库管理（Database Administration)

60.1. 用户管理（User Account Management）

60.1.1. 创建用户
60.1.2. 删除用户
60.1.3. 修改用户名
60.1.4. 修改密码

60.2. Access Privilege System

60.2.1. SHOW GRANTS
60.2.2. show privileges
60.2.3. Grant privileges
60.2.4. Revoke privileges
60.2.5. Show Privileges
60.2.6. MAX_QUERIES_PER_HOUR/MAX_UPDATES_PER_HOUR
60.2.7. Table Privileges
60.2.8. Column Privileges

60.3. 字符集转换

60.3.1. 转换 latin1 到 UTF-8

60.4. 重新整理AUTO_INCREMENT字段

60.5. 数据库内容替换

60.6. Kill 脚本

60.7. MySQL 时区管理

60.8. SHOW COMMAND

60.8.1. 查看版本
60.8.2. status
60.8.3. show processlist
60.8.4. 线程的使用情况
60.8.5. DATABASES
60.8.6. 排序统计信息
60.8.7. Key 状态
60.8.8. FUNCTION
60.8.9. PROCEDURE
60.8.10. TRIGGERS
60.8.11. EVENTS
60.8.12. 引擎(ENGINES)
60.8.13. 字符集(Collation)
60.8.14. SHOW GRANTS
60.8.15. validate_password

60.9. Maintenance 数据库维护

60.9.1. CHECK 检查表
60.9.2. ANALYZE 分析表
60.9.3. CHECKSUM
60.9.4. OPTIMIZE 优化表
60.9.5. REPAIR 修复

60.10. INFORMATION_SCHEMA

60.10.1. 查询表字段
60.10.2. 列出所有触发器
60.10.3. 查看表数据尺寸

60.11. Backup and Recovery

60.11.1. Import / Export
60.11.2. Snapshot Backup

61. PostgreSQL 命令

61.1. psql - PostgreSQL interactive terminal

61.1.1. 执行文件

61.2. Backup / Restore

61.2.1. Backup
61.2.2. Restore
61.2.3. import
61.2.4. 导出指定 schema
61.2.5. PostgreSQL for windows
61.2.6. 大型数据库备份
61.2.7. schema之间迁移数据

62. DDL - Data Definition Language

62.1. 数据库管理(Database)

62.1.1. 创建数据库
62.1.2. 删除数据库
62.1.3. 修改数据库
62.1.4. 重命名数据库
62.1.5. 修改字符集
62.1.6. 查看数据库创建语句

62.2. 表管理(Table)

62.2.1. 数据类型
62.2.2. 基于现有表结构创建新空表
62.2.3. 基于已存在表创建新表
62.2.4. 修改表
62.2.5. 临时表
62.2.6. CHARACTER
62.2.7. DEFAULT
62.2.8. KEY
62.2.9. AUTO_INCREMENT 定义初始值
62.2.10. COMMENT
62.2.11. 修改表名
62.2.12. Engine 存储引擎

62.3. Partitioning

62.3.1. RANGE
62.3.2. LIST
62.3.3. HASH
62.3.4. KEY分区
62.3.5. Subpartitioning
62.3.6. 分区管理
62.3.7. EXPLAIN PARTITIONS
62.3.8. SHOW CREATE TABLE
62.3.9. INFORMATION_SCHEMA.partitions 表
62.3.10. 分区数据操作

62.4. Index

62.4.1. SHOW INDEX
62.4.2. CREATE INDEX
62.4.3. DROP INDEX
62.4.4. rebuild

62.5. 外键(Foreign Key)

62.5.1. FOREIGN KEY (RESTRICT)

62.6. 视图(View)

62.7. 存储过程(PROCEDURE)

62.7.1. 存储程序
62.7.2. EXECUTE 执行 SQL
62.7.3. PREPARE 传递参数
62.7.4. 存储过程返回数据
62.7.5. 结果集转JSON
62.7.6. 例子·过程返回结果

62.8. 函数

62.8.1. TIMESTAMP TO ISO8601

62.9. 触发器(Trigger)

62.9.1. create trigger
62.9.2. drop trigger
62.9.3. show triggers
62.9.4. EXAMPLE

62.10. 事件调度器(EVENT)

62.10.1. 启用 EVENT
62.10.2. 创建 EVENT
62.10.3. 禁用/启用
62.10.4. 查看 events
62.10.5. 删除 EVENT
62.10.6. EVENT 应用案例

63. DML (Data Manipulation Language)

63.1. INSERT 插入

63.1.1. INSERT INTO ... SELECT
63.1.2. INSERT IGNORE
63.1.3. INSERT...ON DUPLICATE KEY UPDATE

63.2. REPLACE 替换

63.3. DELETE 删除

63.3.1. 删除重复数据
63.3.2. 删除重复数据保留第一条

64. SQL Statement Syntax

64.1. DISTINCT

64.2.1. LEFT JOIN / LEFT OUTER JOIN
64.2.2. JOIN / INNER JOIN

64.3. order by 排序

64.3.1. 处理 null

64.4. group by

64.4.1. 忽略 NULL

64.5. HAVING

64.6. REGEXP

64.7. IN / NOT IN

64.8. ALL / Any

64.9. exists, not exists

64.10. UNION

64.10.1. UNION ALL
64.10.2. 两张表字段不对等解决方法

64.11. OUTFILE/LOAD DATA INFILE

64.11.1. Export data to CSV from MySQL
64.11.2. Import data from CSV file.

64.12. CASE Syntax

64.13. 查询结果放入变量

64.14. MySQL 专有命令

64.14.1. SQL_NO_CACHE
64.14.2. SIGNAL Syntax

64.15. SQL 92

65. Functions and Operators

65.1. COUNT

65.2. UUID()

65.3. 字符串

65.3.1. LEFT/RIGHT
65.3.2. RPAD/LPAD
65.3.3. CONCAT
65.3.4. CONCAT_WS
65.3.5. 链接所有字段
65.3.6. GROUP_CONCAT
65.3.7. replace 字符串替换
65.3.8. SUBSTRING
65.3.9. SUBSTRING_INDEX
65.3.10. AES_ENCRYPT / AES_DECRYPT

65.4. Date and Time

65.4.1. year/month/day hour:minite:second
65.4.2. Unix time
65.4.3. DATE_FORMAT
65.4.4. DATE_SUB/DATE_ADD
65.4.5. datediff / timediff

65.5. 数值函数

65.5.1. cast 类型转换
65.5.2. truncate 保留小数位数
65.5.3. MOD 求余

65.6. Control Flow Functions

66. PostgreSQL GUI

66.1. pgAdmin III

66.2. phpPgAdmin

66.3. Monitoring

66.3.1. PgBadger

66.4. pgModeler - PostgreSQL Database Modeler

67. Barman Backup & recovery for PostgreSQL

68. pgbouncer - lightweight connection pooler for PostgreSQL

68.1. 安装 pgbouncer

68.1.1. Ubuntu
68.1.2. CentOS

68.2. 配置 pgbouncer

69. Foreign data wrappers

70. Barman for PostgreSQL

71. Connector

71.1. Pomm

72. Replication

72.1. Bucardo

73.1. Reset root password 重置MySQL root密码

73.1.1. MySQL 5.7.x
73.1.2. MySQL 8.0

73.2. 查看错误代码

73.2.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
73.2.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

73.3. 临时表是否需要建索引

73.4. [Warning] Changed limits: max_open_files: 5000 (requested 20480)

73.5. Table 'performance_schema.session_variables' doesn't exist

73.6. SQL Error (1038): Out of sort memory, consider increasing server sort buffer size

73.7. this is incompatible with sql_mode=only_full_group_by

73.8. ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes

73.9. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists

73.10. ERROR 1114 (HY000): The table 'your_table' is full

73.11. Error Code: 1146. Table 'test.CACHE_UPDATE' doesn't exist

73.12. Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

73.13. ERROR 1273 (HY000) at line 3364: Unknown collation: 'utf8mb4_0900_ai_ci'

73.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

73.15. ERROR 1364: 1364: Field 'id' doesn't have a default value

73.16. Error Code: 1292. Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 95692

73.17. ERROR 1415: Not allowed to return a result set from a trigger

73.18. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

73.19. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

73.20. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

73.21. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

73.22. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

73.23. ERROR 2013 (HY000): Lost connection to MySQL server during query

73.24. ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

73.25. ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

73.26. Error Code: 3780. Referencing column 'id' and referenced column 'id' in foreign key constraint 'FKfeti3hcwwku7l7xqru4emwkc6' are incompatible.

73.27. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory

73.28. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

73.29. mysqldump: Couldn't execute 'SELECT COLUMN_NAME,

73.30. this is incompatible with sql_mode=only_full_group_by

73.31. mysqldump: [Warning] Using a password on the command line interface can be insecure.

73.32. mysql: [Warning] Using a password on the command line interface can be insecure.

73.33. 时间自动被加一秒

VII. Oracle

74. Oracle 12c 安装可

74.1. Server 安装

74.2. Desktop 安装

74.3. Oracle Net Services Configuration

74.3.1. Listener configuration
74.3.2. Local Net Service Name configuration

74.4. Oracle 12c Client for Windows 10

74.5. 卸载 Oracle

74.6. Linux 安装 sqlplus

75. Privilege

75.1. Account

75.1.1. show user
75.1.2. DEFAULT_TABLESPACE
75.1.3. unlock/lock

75.2.1. Create user
75.2.2. Drop user
75.2.3. Alter user
75.2.4. 修改密码
75.2.5. Reset Password 忘记密码重置密码

75.3. grant

75.3.1. 列出权限
75.3.2. 查看用户权限
75.3.3. 吊销权限
75.3.4. System Privileges 系统权限
75.3.5. Object Privileges 对象权限

75.4. Opening the Encrypted Wallet

76. 数据库管理

76.1. lsnrctl

76.2. listener.ora

76.3. TNS 配置

76.3.1. HOST
76.3.2. SID

76.4. parameter

76.4.1. db
76.4.2. instance_name
76.4.3. service_name
76.4.4. global_name
76.4.5. db_name
76.4.6. db_domain
76.4.7. sga
76.4.8. size
76.4.9. spfile
76.4.10. cache
76.4.11. Character Set

76.5. 进程

76.6. 查看用户

76.7. 显示表

76.8. 显示试图

76.9. PROCEDURE

76.10. FUNCTION

76.11. 视图、存储过程、函数

76.12. 查看存储过程源代码

76.13. 日期时间格式

76.13.1. Date
76.13.2. 修改系统日期格式
76.13.3. TIMESTAMP
76.13.4.

76.14. 切换字符集

76.14.1. 切换到 GBK
76.14.2. 切到 UTF-8
76.14.3. 切到 AL32UTF8
76.14.4. 切换过程实例

76.15. Oracle 表空间

76.15.1. 查询空闲表空间
76.15.2. 创建表空间
76.15.3. 更改表空间属性
76.15.4. 删除表空间

77. Oracle Gui

77.1. Create instance

77.2. Oracle Net Configuration Assistant

77.3. Oracle Enterprise Manager

77.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.

77.4. Other GUI - phpOraAdmin

78.1. SQL*Plus

78.1.1. conn
78.1.2. startup/shutdown
78.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
78.1.4. @运行SQL
78.1.5. 链接数据库

78.2. exp/imp

78.2.1. exp
78.2.2. imp

78.3. expdp/impdp

78.3.1. expdp
78.3.2. impdp
78.3.3. 数据泵演示
78.3.4. 查看dmp文件的表空间

78.4.1. 数据库模式
78.4.2. 完全备份
78.4.3. 增量备份
78.4.4. 恢复数据库
78.4.5. 是用tar打包rman文件
78.4.6. 打包 rman 备份文件

79.1. 字段类型

79.1.1. Date
79.1.2. TIMESTAMP

79.2. 索引

79.3.1.
79.3.2. 约束检查

79.4. SEQUENCE 序列

79.4.1.

80. 程序包

80.1. 执行包中的过程

81. 数据库链接

82. Oracle 监控

82.1. Oracle日志的路径

82.2. SQL 日志监控

82.2.1. 查询性能分析
82.2.2. IO性能分析

82.3. session

82.4. SQL Monitoring Report

83. Installing Oracle Database

83.1. Installing Oracle Database 10g Release 2 on Linux x86

83.2. 11gR2

83.3. Installing Oracle Client 11g

83.4. Silence Install - Database

83.4.1. Response File
83.4.2. OS 配置脚本
83.4.3. 运行 runInstaller

83.5. Silence Install - Client

83.6. oracle 817 script

83.7. Script for automatic startup on boot

83.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)

84.1. Reset root password 重置MySQL root密码

84.1.1. MySQL 5.7.x
84.1.2. MySQL 8.0

84.2. 查看错误代码

84.2.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
84.2.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

84.3. 临时表是否需要建索引

84.4. [Warning] Changed limits: max_open_files: 5000 (requested 20480)

84.5. Table 'performance_schema.session_variables' doesn't exist

84.6. SQL Error (1038): Out of sort memory, consider increasing server sort buffer size

84.7. this is incompatible with sql_mode=only_full_group_by

84.8. ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes

84.9. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists

84.10. ERROR 1114 (HY000): The table 'your_table' is full

84.11. Error Code: 1146. Table 'test.CACHE_UPDATE' doesn't exist

84.12. Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

84.13. ERROR 1273 (HY000) at line 3364: Unknown collation: 'utf8mb4_0900_ai_ci'

84.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

84.15. ERROR 1364: 1364: Field 'id' doesn't have a default value

84.16. Error Code: 1292. Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 95692

84.17. ERROR 1415: Not allowed to return a result set from a trigger

84.18. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

84.19. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

84.20. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

84.21. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

84.22. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

84.23. ERROR 2013 (HY000): Lost connection to MySQL server during query

84.24. ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

84.25. ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

84.26. Error Code: 3780. Referencing column 'id' and referenced column 'id' in foreign key constraint 'FKfeti3hcwwku7l7xqru4emwkc6' are incompatible.

84.27. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory

84.28. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

84.29. mysqldump: Couldn't execute 'SELECT COLUMN_NAME,

84.30. this is incompatible with sql_mode=only_full_group_by

84.31. mysqldump: [Warning] Using a password on the command line interface can be insecure.

84.32. mysql: [Warning] Using a password on the command line interface can be insecure.

84.33. 时间自动被加一秒

85. ClickHouse

85.1. 安装 Clickhouse

85.1.1. RPM 安装

85.2. 客户端

86. Milvus 向量数据库

86.1. 安装 Milvus

86.2. 安装 Milvus insight 管理界面

86.3. 问答模型

86.4. milvus-cli

86.4.1. 安装 milvus-cli
86.4.2. 查看帮助信息
86.4.3. 链接数据库
86.4.4.
86.4.5. 查看数据库
86.4.6. 数据库管理
86.4.7.
86.4.8. 查询
86.4.9. 删除操作
86.4.10.

86.5. Python SDK

86.5.1. 数据库管理
86.5.2. 创建分区
86.5.3. Example
86.5.4. FAQ

表格清单

27.1. 更新丢失演示
27.2. 防止更新丢失加锁演示

范例清单

9.1. Elasticsearch master / slave
11.1. Solr - schema.xml
11.2. /etc/profile.d/java.sh
20.1. MySQL 8 创建root账号
20.2. my.cnf
20.3. my.cnf
20.4. my.cnf
23.1. BEFORE/AFTER
23.2. uuid()
25.1. SQL ANY example
28.1. SQL_CACHE 测试
28.2. SHOW PROFILE Syntax
43.1. MongoDB Test
43.2. Using MongoDB in PHP
48.1. Twitter
48.2. Twissandra
51.1. /etc/init.d/memcached
59.1. Example for /var/lib/pgsql/10/data/pg_hba.conf
62.1. BEFORE/AFTER
62.2. uuid()
64.1. SQL ANY example
68.1. /etc/pgbouncer/pgbouncer.ini
76.1. Oracle 字符集切换实例
76.2. 创建表空间实例
78.1. expdp
78.2. impdp
78.3. full backup
79.1.
81.1. DB LINK

		下一页
		自述