Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Search | Email

Netkiller Database 手札

PostgreSQL, MySQL, Oracle ...

Mr. Neo Chan, 陈景峯(BG7NYT)


中国广东省深圳市龙华新区民治街道溪山美地
518131
+86 13113668890


文档初创于April 6, 2008

版权声明

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

文档出处:
http://netkiller.github.io
http://netkiller.sourceforge.net

微信扫描二维码进入 Netkiller 微信订阅号

QQ群:128659835 请注明“读者”

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


目录

1. 自述
1.1. 系列文档
1.2. 作者简介
1.3. 写给读者
1.4. 文档下载
1.5. 打赏(Donations)
1.5.1. 微信(Wechat)
1.5.2. 支付宝(Alipay)
1.5.3. PayPal Donations
1.5.4. 银行(Bank)
I. Database Relational
1. DB-Engines - DB-Engines Ranking
2. SysBench
3. SuperSmack
4. ETL (Extract-Transform-Load)
4.1. Kettle
4.2. suro
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. MySQL
8. MySQL Server
8.1. MySQL Installation
8.1.1. Installation by apt-get under debian/ubuntu
8.1.2. Installation by source code
8.1.3. MySQL binary distribution
8.1.4. mysql-5.5.21-debian6.0-i686.deb
8.1.5. CentOS 6.2 + MySQL 5.5.25 (RPM)
8.1.6. mysql-admin
8.1.7. Installing MySQL on Linux Using the MySQL Yum Repository
8.1.8. Firewall
8.1.9. Limit 状态
8.1.10. 使用 Btrfs 文件系统存储mysql数据
8.2. MariaDB
8.2.1. CentOS YUM 安装 MariaDB
8.2.2. MariaDB Audit Plugin
8.3. Percona
8.3.1. Percona yum Repository
8.3.2. Percona XtraBackup
8.3.3. Percona Toolkit - MySQL Management Software
8.4. my.cnf
8.4.1. bind-address
8.4.2. 禁用TCP/IP链接
8.4.3. 配置字符集
8.4.4. 最大链接数 max_connections
8.4.5. 默认引擎 storage-engine
8.4.6. max_allowed_packet
8.4.7. skip-name-resolve
8.4.8. timeout
8.4.9. 与复制有关的参数
8.4.10. 与 InnoDB 有关的配置项
8.4.11. EVENT 设置
8.4.12. 日志
8.4.13. MySQL 5.7 my.cnf 实例
8.4.14. Example for my.cnf
8.5. SHOW COMMAND
8.5.1. 查看版本
8.5.2. status
8.5.3. show processlist
8.5.4. variables
8.5.5. binary 日志
8.5.6. DATABASES
8.5.7. TABLE
8.5.8. FUNCTION
8.5.9. PROCEDURE
8.5.10. TRIGGERS
8.5.11. EVENTS
8.5.12. 引擎(ENGINES)
8.5.13. 字符集(Collation)
8.5.14. SHOW GRANTS
8.6. MySQL Plugin
8.6.1. validate_password
8.6.2. MySQL Images manager
8.6.3. MySQL fifo
8.7. Replication
8.7.1. Master Slave
8.7.2. Master Master(主主)
8.7.3. Semisynchronous Replication
8.7.4. multi-master replication
8.7.5. multi-source replication
8.7.6. 与复制有关的问题
8.7.7. GTID
8.8. MySQL Custer
8.8.1. Management node (MGM node)
8.8.2. Data node
8.8.3. SQL node
8.8.4. Starting
8.8.5. Shutdown
8.8.6. Testing
8.9. MySQL Proxy
8.9.1. Ubuntu
8.9.2. CentOS
8.10. MySQL Router
8.10.1. 安装 MySQL Router
8.10.2. 配置 MySQL Router
8.10.3. MySQL Router , Haproxy,LVS 的选择
8.11. Monitoring
8.11.1. Analysis and Optimization
8.11.2. Munin
8.11.3. Cacti
8.11.4. Monitoring MySQL with SNMP
9. Client and Utility Programs
9.1. mysql - the MySQL command-line tool
9.1.1. ~/.my.cnf
9.1.2. 屏幕输出到文件
9.1.3. 终端编码
9.1.4. Unix Socket
9.1.5. 重定向巧用
9.1.6. --sigint-ignore 忽略 Ctrl + C
9.2. mysqldump - a database backup program
9.2.1. 备份数据库,无结构,只有数据
9.2.2. 备份数据库结构(不备份数据)
9.2.3. 使用完整的insert插入数据
9.2.4. --extended-insert / --skip-extended-insert
9.2.5. --skip-lock-tables
9.2.6. --skip-add-locks
9.2.7. --where
9.2.8. 注释信息--comments /--skip-comments
9.3. mysqladmin - client for administering a MySQL server
9.3.1. reload
9.3.2. 更改密码
9.3.3. status
9.3.4. process list
9.4. myisamchk — MyISAM Table-Maintenance Utility
9.5. mysqlcheck — A Table Maintenance and Repair Program
9.6. mysqlslap - load emulation client
9.7. mysqldumpslow - Parse and summarize the MySQL slow query log.
9.8. mysql log
10. Database Administration
10.1. User Account Management
10.1.1. Create User
10.1.2. Drop User
10.1.3. Rename User
10.1.4. SET PASSWORD
10.2. Access Privilege System
10.2.1. SHOW GRANTS
10.2.2. show privileges
10.2.3. Grant privileges
10.2.4. Revoke privileges
10.2.5. Show Privileges
10.2.6. MAX_QUERIES_PER_HOUR/MAX_UPDATES_PER_HOUR
10.2.7. Table Privileges
10.2.8. Column Privileges
10.3. Maintenance 数据库维护
10.3.1. CHECK 检查表
10.3.2. ANALYZE 分析表
10.3.3. CHECKSUM
10.3.4. OPTIMIZE 优化表
10.3.5. REPAIR 修复
10.4. Backup and Recovery
10.4.1. Import / Export
10.4.2. Snapshot Backup
11. DDL - Data Definition Language
11.1. 数据库管理(Database)
11.1.1. create
11.1.2. drop
11.1.3. Alter
11.1.4. Rename
11.1.5. CHARACTER
11.1.6. show create database
11.2. 表管理(Table)
11.2.1. 数据类型
11.2.2. create table ... select
11.2.3. modifiy table
11.2.4. TEMPORARY Table
11.2.5. Collate
11.2.6. CHARACTER
11.2.7. DEFAULT
11.2.8. KEY
11.2.9. COMMENT
11.2.10. Engine
11.3. Partitioning
11.3.1. RANGE
11.3.2. LIST
11.3.3. HASH
11.3.4. KEY分区
11.3.5. Subpartitioning
11.3.6. 分区管理
11.3.7. EXPLAIN PARTITIONS
11.3.8. SHOW CREATE TABLE
11.3.9. INFORMATION_SCHEMA.partitions 表
11.3.10. 分区数据操作
11.4. Index
11.4.1. SHOW INDEX
11.4.2. CREATE INDEX
11.4.3. DROP INDEX
11.4.4. rebuild
11.5. 外键(Foreign Key)
11.5.1. FOREIGN KEY (RESTRICT)
11.6. 视图(View)
11.7. 存储过程(PROCEDURE)
11.7.1. 存储程序
11.7.2. 函数
11.8. 触发器(Trigger)
11.8.1. create trigger
11.8.2. drop trigger
11.8.3. show triggers
11.8.4. EXAMPLE
11.9. 事件调度器(EVENT)
11.9.1. 启用 EVENT
11.9.2. 创建 EVENT
11.9.3. 禁用/启用
11.9.4. show events
12. DML (Data Manipulation Language)
12.1. INSERT
12.1.1. INSERT INTO ... SELECT
12.1.2. INSERT IGNORE
12.1.3. INSERT...ON DUPLICATE KEY UPDATE
12.2. REPLACE
12.3. DELETE
12.3.1. 删除重复数据
13. SQL Statement Syntax
13.1. DISTINCT
13.2. group by
13.3. HAVING
13.4. REGEXP
13.5. IN / NOT IN
13.6. ALL / Any
13.7. exists, not exists
13.8. UNION
13.8.1. UNION ALL
13.9. OUTFILE/LOAD DATA INFILE
13.9.1. Export data to CSV from MySQL
13.9.2. Import data from CSV file.
13.10. MySQL 专有命令
13.10.1. SQL_NO_CACHE
13.10.2. SIGNAL Syntax
13.11. SQL 92
14. Functions and Operators
14.1. COUNT
14.2. UUID()
14.3. String
14.3.1. LEFT/RIGHT
14.3.2. RPAD/LPAD
14.3.3. CONCAT
14.3.4. GROUP_CONCAT
14.3.5. replace
14.3.6. SUBSTRING
14.3.7. SUBSTRING_INDEX
14.3.8. AES_ENCRYPT / AES_DECRYPT
14.4. Date and Time
14.4.1. year/month/day hour:minite:second
14.4.2. Unix time
14.4.3. DATE_FORMAT
14.4.4. DATE_SUB/DATE_ADD
14.4.5. datediff / timediff
14.5. 数值函数
14.5.1. cast 类型转换
14.5.2. truncate 保留小数位数
14.5.3. MOD 求余
14.6. Control Flow Functions
15. DCL (Data Control Language)
15.1. 锁
15.1.1. 共享锁
15.1.2. 排他锁
15.1.3. 锁
15.1.4. 锁等待与超时
15.2. 事务处理和锁定语句
15.2.1. 事务隔离级别
15.2.2. 事务所用到的表
15.2.3. 解决更新冲突
15.2.4. SAVEPOINT
16. Optimization
16.1. Buffering and Caching
16.1.1. Query Cache SELECT Options
16.2. where 优化
16.3. SHOW PROFILE Syntax SQL性能分析器
16.4. PROCEDURE ANALYSE()
17. MySQL Connectors
17.1. JDBC
17.2. ODBC
17.3. MySQL native driver for PHP - mysqlnd
17.4. python-mysqldb
18. MySQL GUI/Web Manager
18.1. HeidiSQL
18.2. Toad for MySQL Freeware
18.3. phpMyAdmin - MySQL web administration tool
18.4. Maatkit Essential command-line utilities for MySQL
19. Miscellaneous
19.1. Multi-Master Replication Manager for MySQL
19.2. MHA
19.3. HandlerSocket
19.4. Maatkit
19.5. Mroonga
19.6. Amoeba
20. FAQ
20.1. Reset root password 重置MySQL root密码
20.2. 数据库内容替换
20.3. 查看错误代码
20.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
20.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
20.4. 临时表是否需要建索引
20.5. Kill 脚本
20.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
20.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
20.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
20.9. 重新整理AUTO_INCREMENT字段
20.10. 转换 latin1 到 UTF-8
20.11. this is incompatible with sql_mode=only_full_group_by
20.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
III. PostgreSQL
21. PostgreSQL 安装
21.1. Ubuntu 12.04.1 LTS 安装
21.2. YUM 默认源安装
21.3. PostgreSQL 官方 YUM 源安装
21.3.1. 9.2
21.3.2. 9.3
21.3.3. 9.4
21.3.4. 9.6
21.3.5. 10
21.4. PostgreSQL 配置
21.4.1. postgresql.conf
21.4.2. pg_hba.conf
21.5. 创建dba用户
22. PostgreSQL 命令
22.1. psql - PostgreSQL interactive terminal
23. Database Administration
23.1. User Account Management
23.1.1. Create User
23.1.2. Drop User
23.1.3. Rename User
23.1.4. SET PASSWORD
23.2. Access Privilege System
23.2.1. SHOW GRANTS
23.2.2. show privileges
23.2.3. Grant privileges
23.2.4. Revoke privileges
23.2.5. Show Privileges
23.2.6. MAX_QUERIES_PER_HOUR/MAX_UPDATES_PER_HOUR
23.2.7. Table Privileges
23.2.8. Column Privileges
23.3. Maintenance 数据库维护
23.3.1. CHECK 检查表
23.3.2. ANALYZE 分析表
23.3.3. CHECKSUM
23.3.4. OPTIMIZE 优化表
23.3.5. REPAIR 修复
23.4. Backup and Recovery
23.4.1. Import / Export
23.4.2. Snapshot Backup
24. DDL - Data Definition Language
24.1. 数据库管理(Database)
24.1.1. create
24.1.2. drop
24.1.3. Alter
24.1.4. Rename
24.1.5. CHARACTER
24.1.6. show create database
24.2. 表管理(Table)
24.2.1. 数据类型
24.2.2. create table ... select
24.2.3. modifiy table
24.2.4. TEMPORARY Table
24.2.5. Collate
24.2.6. CHARACTER
24.2.7. DEFAULT
24.2.8. KEY
24.2.9. COMMENT
24.2.10. Engine
24.3. Partitioning
24.3.1. RANGE
24.3.2. LIST
24.3.3. HASH
24.3.4. KEY分区
24.3.5. Subpartitioning
24.3.6. 分区管理
24.3.7. EXPLAIN PARTITIONS
24.3.8. SHOW CREATE TABLE
24.3.9. INFORMATION_SCHEMA.partitions 表
24.3.10. 分区数据操作
24.4. Index
24.4.1. SHOW INDEX
24.4.2. CREATE INDEX
24.4.3. DROP INDEX
24.4.4. rebuild
24.5. 外键(Foreign Key)
24.5.1. FOREIGN KEY (RESTRICT)
24.6. 视图(View)
24.7. 存储过程(PROCEDURE)
24.7.1. 存储程序
24.7.2. 函数
24.8. 触发器(Trigger)
24.8.1. create trigger
24.8.2. drop trigger
24.8.3. show triggers
24.8.4. EXAMPLE
24.9. 事件调度器(EVENT)
24.9.1. 启用 EVENT
24.9.2. 创建 EVENT
24.9.3. 禁用/启用
24.9.4. show events
25. DML (Data Manipulation Language)
25.1. INSERT
25.1.1. INSERT INTO ... SELECT
25.1.2. INSERT IGNORE
25.1.3. INSERT...ON DUPLICATE KEY UPDATE
25.2. REPLACE
25.3. DELETE
25.3.1. 删除重复数据
26. SQL Statement Syntax
26.1. DISTINCT
26.2. group by
26.3. HAVING
26.4. REGEXP
26.5. IN / NOT IN
26.6. ALL / Any
26.7. exists, not exists
26.8. UNION
26.8.1. UNION ALL
26.9. OUTFILE/LOAD DATA INFILE
26.9.1. Export data to CSV from MySQL
26.9.2. Import data from CSV file.
26.10. MySQL 专有命令
26.10.1. SQL_NO_CACHE
26.10.2. SIGNAL Syntax
26.11. SQL 92
27. Functions and Operators
27.1. COUNT
27.2. UUID()
27.3. String
27.3.1. LEFT/RIGHT
27.3.2. RPAD/LPAD
27.3.3. CONCAT
27.3.4. GROUP_CONCAT
27.3.5. replace
27.3.6. SUBSTRING
27.3.7. SUBSTRING_INDEX
27.3.8. AES_ENCRYPT / AES_DECRYPT
27.4. Date and Time
27.4.1. year/month/day hour:minite:second
27.4.2. Unix time
27.4.3. DATE_FORMAT
27.4.4. DATE_SUB/DATE_ADD
27.4.5. datediff / timediff
27.5. 数值函数
27.5.1. cast 类型转换
27.5.2. truncate 保留小数位数
27.5.3. MOD 求余
27.6. Control Flow Functions
28. PostgreSQL GUI
28.1. pgAdmin III
28.2. phpPgAdmin
28.3. Monitoring
28.3.1. PgBadger
28.4. pgModeler - PostgreSQL Database Modeler
29. Barman Backup & recovery for PostgreSQL
30. pgbouncer - lightweight connection pooler for PostgreSQL
30.1. 安装 pgbouncer
30.1.1. Ubuntu
30.1.2. CentOS
30.2. 配置 pgbouncer
31. Foreign data wrappers
32. Barman for PostgreSQL
33. Connector
33.1. Pomm
34. Replication
34.1. Bucardo
35. FAQ
35.1. Reset root password 重置MySQL root密码
35.2. 数据库内容替换
35.3. 查看错误代码
35.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
35.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
35.4. 临时表是否需要建索引
35.5. Kill 脚本
35.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
35.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
35.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
35.9. 重新整理AUTO_INCREMENT字段
35.10. 转换 latin1 到 UTF-8
35.11. this is incompatible with sql_mode=only_full_group_by
35.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
IV. Oracle
36. Oracle 12c 安装可
36.1. Server 安装
36.2. Desktop 安装
36.3. Oracle Net Services Configuration
36.3.1. Listener configuration
36.3.2. Local Net Service Name configuration
36.4. Oracle 12c Client for Windows 10
36.5. 卸载 Oracle
36.6. Linux 安装 sqlplus
37. Privilege
37.1. Account
37.1.1. show user
37.1.2. DEFAULT_TABLESPACE
37.1.3. unlock/lock
37.2. User
37.2.1. Create user
37.2.2. Drop user
37.2.3. Alter user
37.2.4. 修改密码
37.2.5. Reset Password 忘记密码重置密码
37.3. grant
37.3.1. 列出权限
37.3.2. 查看用户权限
37.3.3. 吊销权限
37.3.4. System Privileges 系统权限
37.3.5. Object Privileges 对象权限
37.4. Opening the Encrypted Wallet
38. 数据库管理
38.1. lsnrctl
38.2. listener.ora
38.3. TNS 配置
38.3.1. HOST
38.3.2. SID
38.4. parameter
38.4.1. db
38.4.2. instance_name
38.4.3. service_name
38.4.4. global_name
38.4.5. db_name
38.4.6. db_domain
38.4.7. sga
38.4.8. size
38.4.9. spfile
38.4.10. cache
38.4.11. Character Set
38.5. 进程
38.6. 查看用户
38.7. 显示表
38.8. 显示试图
38.9. PROCEDURE
38.10. FUNCTION
38.11. 视图、存储过程、函数
38.12. 查看存储过程源代码
38.13. 日期时间格式
38.13.1. Date
38.13.2. 修改系统日期格式
38.13.3. TIMESTAMP
38.13.4.
38.14. 切换字符集
38.14.1. 切换到 GBK
38.14.2. 切到 UTF-8
38.14.3. 切到 AL32UTF8
38.14.4. 切换过程实例
38.15. Oracle 表空间
38.15.1. 查询空闲表空间
38.15.2. 创建表空间
38.15.3. 更改表空间属性
38.15.4. 删除表空间
39. Oracle Gui
39.1. Create instance
39.2. Oracle Net Configuration Assistant
39.3. Oracle Enterprise Manager
39.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
39.4. Other GUI - phpOraAdmin
40. CLI
40.1. SQL*Plus
40.1.1. conn
40.1.2. startup/shutdown
40.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
40.1.4. @运行SQL
40.1.5. 链接数据库
40.2. exp/imp
40.2.1. exp
40.2.2. imp
40.3. expdp/impdp
40.3.1. expdp
40.3.2. impdp
40.3.3. 数据泵演示
40.3.4. 查看dmp文件的表空间
40.4. RMAN
40.4.1. 数据库模式
40.4.2. 完全备份
40.4.3. 增量备份
40.4.4. 恢复数据库
40.4.5. 是用tar打包rman文件
40.4.6. 打包 rman 备份文件
41. DDL
41.1. 字段类型
41.1.1. Date
41.1.2. TIMESTAMP
41.2. 索引
41.3. 表
41.3.1.
41.3.2. 约束检查
41.4. SEQUENCE 序列
41.4.1.
42. 程序包
42.1. 执行包中的过程
43. 数据库链接
44. Oracle 监控
44.1. Oracle日志的路径
44.2. SQL 日志监控
44.2.1. 查询性能分析
44.2.2. IO性能分析
44.3. session
44.4. SQL Monitoring Report
45. Installing Oracle Database
45.1. Installing Oracle Database 10g Release 2 on Linux x86
45.2. 11gR2
45.3. Installing Oracle Client 11g
45.4. Silence Install - Database
45.4.1. Response File
45.4.2. OS 配置脚本
45.4.3. 运行 runInstaller
45.5. Silence Install - Client
45.6. oracle 817 script
45.7. Script for automatic startup on boot
45.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
46. FAQ
46.1. Reset root password 重置MySQL root密码
46.2. 数据库内容替换
46.3. 查看错误代码
46.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
46.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
46.4. 临时表是否需要建索引
46.5. Kill 脚本
46.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
46.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
46.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
46.9. 重新整理AUTO_INCREMENT字段
46.10. 转换 latin1 到 UTF-8
46.11. this is incompatible with sql_mode=only_full_group_by
46.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
V. NoSQL
47. Redis
47.1. Redis 安装
47.1.1. CentOS
47.1.2. Ubuntu
47.1.3. Test Redis
47.2. /etc/redis.conf
47.2.1. 密码认证
47.3. redis-cli - Command-line client to redis-server
47.3.1. 命令参数
47.3.2. auth
47.3.3. MONITOR
47.3.4. save/bgsave/lastsave
47.3.5. Pub/Sub 订阅与发布
47.3.6. --latency Enter a special mode continuously sampling latency.
47.4. Redis Cluster
47.5. Redis 通信协议
47.5.1. 切换DB
47.5.2. info
47.5.3. 监控
47.5.4. keys
47.5.5. set/get/del
47.5.6. expire/ttl
47.6. phpRedisAdmin
47.7. Redis 开发
47.7.1. 消息订阅与发布
47.8. FAQ
47.8.1. 清空数据库
47.9. A fast, light-weight proxy for memcached and redis
48. MongoDB
48.1. Install 安装MongoDB
48.1.1. Quickstart
48.1.2. Replication
48.1.3. Drivers
48.2. MongoDB 管理
48.2.1. Security and Authentication
48.2.2. Query
48.2.3. Unique Indexes
48.3. 命令工具
48.3.1. mongo shell
48.3.2. mongodump - Backup
48.3.3. mongorestore
48.3.4. mongostat
48.3.5. mongotop
48.3.6. mongofiles - Browse and modify a GridFS filesystem.
48.4. Mongo Admin UI
48.4.1. RockMongo
48.4.2. MongoVUE
48.5. Map-Reduce
48.5.1. 使用 Map-Reduce 统计Web 服务器 access.log 日志文件
48.6. MongoDB 2.x 早期版本
48.6.1. 用户管理
49. Cassandra
49.1. Getting Started
49.1.1. Downloading and Installation
49.1.2. Running Cassandra
49.1.3. cli tool
49.1.4. Testing Cassandra
49.2. Configure Cassandra
49.2.1. Envionment variables
49.2.2. log4j.properties
49.2.3. storage-conf.xml
49.3. Keyspace
49.3.1. Schema
49.3.2. Keyspace example
49.4. Cluster
49.4.1. Running a cluster
49.4.2. Running a single node
49.4.3. nodetool
50. Hypertable
50.1. Hypertable 安装
50.1.1. Hypertable standalone 单机安装
50.1.2. Hypertable on HDFS(hadoop) 安装
50.1.3. MapR
50.1.4. Ceph
50.1.5. 检验安装
50.2. Code examples
50.2.1. PHP
50.3. HQL
50.3.1. namespace 命名空间管理
50.3.2. Table 表
50.4. FAQ
50.4.1. 切换 DFS Broker
51. CouchBase
51.1. 安装 CouchBase
51.1.1. Getting Started with Couchbase on PHP
51.2. couchbase 命令
51.2.1. couchbase-cli
52. Memcached
52.1. 安装 Memcached
52.1.1. CentOS 下编译
52.1.2. Ubuntu 下编译安装
52.1.3. debian/ubuntu
52.1.4. yum install
52.2. Memcached 代理
52.2.1. moxi
52.2.2. memagent
53. RethinkDB
54. TokyoCabinet/Tyrant
55. Flare
56. Voldemort
57. LevelDB
58. HyperDex
59. LeoFS
VI. Search Engine
60. Solr
60.1. 安装
60.2. Core Admin
60.2.1. Schema
60.3. 索引
60.3.1. Indexing a directory of "rich" files
60.3.2. Indexing Solr XML
60.3.3. Indexing JSON
60.3.4. Deleting Data
60.4. 接口
60.4.1. 查询
60.5. FAQ
60.5.1. NOTE: Please install lsof as this script needs it to determine if Solr is listening on port 8983.
60.6. Solr 1.3.0
60.6.1. Embedded Jetty
60.6.2. Jetty
60.6.3. Tomcat
60.6.4. solr-php-client
60.6.5. multicore
60.6.6. 中文分词
61. Elasticsearch
61.1. 安装 Elasticsearch
61.2. 文档API
61.2.1. 快速上手
61.2.2. 写入 PUT/POST
61.2.3. 获取 GET
61.2.4. 检查记录是否存在
61.2.5. 删除 Delete
61.2.6. 参数
61.3. 搜索
61.3.1. 分页
61.3.2. 字符串搜索
61.3.3. Query DSL
61.4. 中文分词插件管理
61.4.1. 安装插件
61.4.2. 创建索引
61.4.3. 删除索引
61.4.4. 配置索引分词插件
61.5. 映射
61.5.1. 查看 _mapping
61.5.2. 删除 _mapping
61.5.3. 创建 _mapping
61.5.4. 修改 _mapping
61.5.5. 数据类型
61.6. Alias management 别名管理
61.6.1. 查看索引别名
61.6.2. 创建索引别名
61.6.3. 修改别名
61.6.4. 删除别名
61.7. Example
61.7.1. 新闻资讯应用案例
61.8. 安装 Elasticsearch 2.3
61.8.1. RPM 安装
61.8.2. YUM 安装
61.8.3. 测试安装是否正常
61.8.4. Plugin 插件管理
61.9. FAQ
61.9.1. Plugin [analysis-ik] is incompatible with Elasticsearch [2.3.5]. Was designed for version [2.3.4]
61.9.2. mapper_parsing_exception: failed to parse [ctime]
62. Nutch
63. Sphinx
64. Lucene
65. MG4J
66. PhpDig
67. Mahout

表格清单

15.1. 更新丢失演示
15.2. 防止更新丢失加锁演示

范例清单

8.1. my.cnf
8.2. my.cnf
8.3. my.cnf
11.1. BEFORE/AFTER
11.2. uuid()
13.1. SQL ANY example
16.1. SQL_CACHE 测试
16.2. SHOW PROFILE Syntax
24.1. BEFORE/AFTER
24.2. uuid()
26.1. SQL ANY example
30.1. /etc/pgbouncer/pgbouncer.ini
38.1. Oracle 字符集切换实例
38.2. 创建表空间实例
40.1. expdp
40.2. impdp
40.3. full backup
41.1.
43.1. DB LINK
48.1. MongoDB Test
48.2. Using MongoDB in PHP
49.1. Twitter
49.2. Twissandra
52.1. /etc/init.d/memcached
60.1. Solr - schema.xml
60.2. /etc/profile.d/java.sh