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