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. Replication
8.6.1. Master Slave
8.6.2. Master Master(主主)
8.6.3. Semisynchronous Replication
8.6.4. multi-master replication
8.6.5. multi-source replication
8.6.6. 與複製有關的問題
8.6.7. GTID
8.7. MySQL Custer
8.7.1. Management node (MGM node)
8.7.2. Data node
8.7.3. SQL node
8.7.4. Starting
8.7.5. Shutdown
8.7.6. Testing
8.8. MySQL Proxy
8.8.1. Ubuntu
8.8.2. CentOS
8.9. MySQL Router
8.9.1. 安裝 MySQL Router
8.9.2. 配置 MySQL Router
8.9.3. MySQL Router , Haproxy,LVS 的選擇
8.10. Monitoring
8.10.1. Analysis and Optimization
8.10.2. Munin
8.10.3. Cacti
8.10.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.4. PostgreSQL 配置
21.4.1. postgresql.conf
21.4.2. pg_hba.conf
21.5. 創建dba用戶
22. Database Administration
22.1. User Account Management
22.1.1. Create User
22.1.2. Drop User
22.1.3. Rename User
22.1.4. SET PASSWORD
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. Maintenance 資料庫維護
22.3.1. CHECK 檢查表
22.3.2. ANALYZE 分析表
22.3.3. CHECKSUM
22.3.4. OPTIMIZE 優化表
22.3.5. REPAIR 修復
22.4. Backup and Recovery
22.4.1. Import / Export
22.4.2. Snapshot Backup
23. DDL - Data Definition Language
23.1. 資料庫管理(Database)
23.1.1. create
23.1.2. drop
23.1.3. Alter
23.1.4. Rename
23.1.5. CHARACTER
23.1.6. show create database
23.2. 表管理(Table)
23.2.1. 數據類型
23.2.2. create table ... select
23.2.3. modifiy table
23.2.4. TEMPORARY Table
23.2.5. Collate
23.2.6. CHARACTER
23.2.7. DEFAULT
23.2.8. KEY
23.2.9. COMMENT
23.2.10. 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. 函數
23.8. 觸發器(Trigger)
23.8.1. create trigger
23.8.2. drop trigger
23.8.3. show triggers
23.8.4. EXAMPLE
23.9. 事件調度器(EVENT)
23.9.1. 啟用 EVENT
23.9.2. 創建 EVENT
23.9.3. 禁用/啟用
23.9.4. show events
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. 刪除重複數據
25. SQL Statement Syntax
25.1. DISTINCT
25.2. group by
25.3. HAVING
25.4. REGEXP
25.5. IN / NOT IN
25.6. ALL / Any
25.7. exists, not exists
25.8. UNION
25.8.1. UNION ALL
25.9. OUTFILE/LOAD DATA INFILE
25.9.1. Export data to CSV from MySQL
25.9.2. Import data from CSV file.
25.10. MySQL 專有命令
25.10.1. SQL_NO_CACHE
25.10.2. SIGNAL Syntax
25.11. SQL 92
26. Functions and Operators
26.1. COUNT
26.2. UUID()
26.3. String
26.3.1. LEFT/RIGHT
26.3.2. RPAD/LPAD
26.3.3. CONCAT
26.3.4. GROUP_CONCAT
26.3.5. replace
26.3.6. SUBSTRING
26.3.7. SUBSTRING_INDEX
26.3.8. 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. PostgreSQL GUI
27.1. pgAdmin III
27.2. phpPgAdmin
27.3. Monitoring
27.3.1. PgBadger
27.4. pgModeler - PostgreSQL Database Modeler
28. Barman Backup & recovery for PostgreSQL
29. pgbouncer - lightweight connection pooler for PostgreSQL
29.1. 安裝 pgbouncer
29.1.1. Ubuntu
29.1.2. CentOS
29.2. 配置 pgbouncer
30. Foreign data wrappers
31. Barman for PostgreSQL
32. Connector
32.1. Pomm
33. Replication
33.1. Bucardo
34. FAQ
34.1. Reset root password 重置MySQL root密碼
34.2. 資料庫內容替換
34.3. 查看錯誤代碼
34.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
34.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
34.4. 臨時表是否需要建索引
34.5. Kill 腳本
34.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
34.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
34.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
34.9. 重新整理AUTO_INCREMENT欄位
34.10. 轉換 latin1 到 UTF-8
34.11. this is incompatible with sql_mode=only_full_group_by
34.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
IV. Oracle
35. Oracle 12c 安裝可
35.1. Server 安裝
35.2. Desktop 安裝
35.3. Oracle Net Services Configuration
35.3.1. Listener configuration
35.3.2. Local Net Service Name configuration
35.4. Oracle 12c Client for Windows 10
35.5. 卸載 Oracle
35.6. Linux 安裝 sqlplus
36. Privilege
36.1. Account
36.1.1. show user
36.1.2. DEFAULT_TABLESPACE
36.1.3. unlock/lock
36.2. User
36.2.1. Create user
36.2.2. Drop user
36.2.3. Alter user
36.2.4. 修改密碼
36.2.5. Reset Password 忘記密碼重置密碼
36.3. grant
36.3.1. 列出權限
36.3.2. 查看用戶權限
36.3.3. 吊銷權限
36.3.4. System Privileges 系統權限
36.3.5. Object Privileges 對象權限
36.4. Opening the Encrypted Wallet
37. 資料庫管理
37.1. lsnrctl
37.2. listener.ora
37.3. TNS 配置
37.3.1. HOST
37.3.2. SID
37.4. parameter
37.4.1. db
37.4.2. instance_name
37.4.3. service_name
37.4.4. global_name
37.4.5. db_name
37.4.6. db_domain
37.4.7. sga
37.4.8. size
37.4.9. spfile
37.4.10. cache
37.4.11. Character Set
37.5. 進程
37.6. 查看用戶
37.7. 顯示表
37.8. 顯示試圖
37.9. PROCEDURE
37.10. FUNCTION
37.11. 視圖、存儲過程、函數
37.12. 查看存儲過程原始碼
37.13. 日期時間格式
37.13.1. Date
37.13.2. 修改系統日期格式
37.13.3. TIMESTAMP
37.13.4.
37.14. 切換字符集
37.14.1. 切換到 GBK
37.14.2. 切到 UTF-8
37.14.3. 切到 AL32UTF8
37.14.4. 切換過程實例
37.15. Oracle 表空間
37.15.1. 查詢空閒表空間
37.15.2. 創建表空間
37.15.3. 更改表空間屬性
37.15.4. 刪除表空間
38. Oracle Gui
38.1. Create instance
38.2. Oracle Net Configuration Assistant
38.3. Oracle Enterprise Manager
38.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
38.4. Other GUI - phpOraAdmin
39. CLI
39.1. SQL*Plus
39.1.1. conn
39.1.2. startup/shutdown
39.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
39.1.4. @運行SQL
39.1.5. 連結資料庫
39.2. exp/imp
39.2.1. exp
39.2.2. imp
39.3. expdp/impdp
39.3.1. expdp
39.3.2. impdp
39.3.3. 數據泵演示
39.3.4. 查看dmp檔案的表空間
39.4. RMAN
39.4.1. 資料庫模式
39.4.2. 完全備份
39.4.3. 增量備份
39.4.4. 恢復資料庫
39.4.5. 是用tar打包rman檔案
39.4.6. 打包 rman 備份檔案
40. DDL
40.1. 欄位類型
40.1.1. Date
40.1.2. TIMESTAMP
40.2. 索引
40.3. 表
40.3.1.
40.3.2. 約束檢查
40.4. SEQUENCE 序列
40.4.1.
41. 程序包
41.1. 執行包中的過程
42. 資料庫連結
43. Oracle 監控
43.1. Oracle日誌的路徑
43.2. SQL 日誌監控
43.2.1. 查詢性能分析
43.2.2. IO性能分析
43.3. session
43.4. SQL Monitoring Report
44. Installing Oracle Database
44.1. Installing Oracle Database 10g Release 2 on Linux x86
44.2. 11gR2
44.3. Installing Oracle Client 11g
44.4. Silence Install - Database
44.4.1. Response File
44.4.2. OS 配置腳本
44.4.3. 運行 runInstaller
44.5. Silence Install - Client
44.6. oracle 817 script
44.7. Script for automatic startup on boot
44.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
45. FAQ
45.1. Reset root password 重置MySQL root密碼
45.2. 資料庫內容替換
45.3. 查看錯誤代碼
45.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
45.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
45.4. 臨時表是否需要建索引
45.5. Kill 腳本
45.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
45.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
45.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
45.9. 重新整理AUTO_INCREMENT欄位
45.10. 轉換 latin1 到 UTF-8
45.11. this is incompatible with sql_mode=only_full_group_by
45.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
V. NoSQL
46. Redis
46.1. Redis 安裝
46.1.1. CentOS
46.1.2. Ubuntu
46.1.3. Test Redis
46.2. /etc/redis.conf
46.2.1. 密碼認證
46.3. redis-cli - Command-line client to redis-server
46.3.1. 命令參數
46.3.2. auth
46.3.3. MONITOR
46.3.4. save/bgsave/lastsave
46.3.5. Pub/Sub 訂閲與發佈
46.3.6. --latency Enter a special mode continuously sampling latency.
46.4. Redis Cluster
46.5. Redis 通信協議
46.5.1. 切換DB
46.5.2. info
46.5.3. 監控
46.5.4. keys
46.5.5. set/get/del
46.5.6. expire/ttl
46.6. phpRedisAdmin
46.7. Redis 開發
46.7.1. 消息訂閲與發佈
46.8. FAQ
46.8.1. 清空資料庫
46.9. A fast, light-weight proxy for memcached and redis
47. MongoDB
47.1. Install 安裝MongoDB
47.1.1. Quickstart
47.1.2. Replication
47.1.3. Drivers
47.2. MongoDB 管理
47.2.1. Security and Authentication
47.2.2. Query
47.2.3. Unique Indexes
47.3. 命令工具
47.3.1. mongo shell
47.3.2. mongodump - Backup
47.3.3. mongorestore
47.3.4. mongostat
47.3.5. mongotop
47.3.6. mongofiles - Browse and modify a GridFS filesystem.
47.4. Mongo Admin UI
47.4.1. RockMongo
47.4.2. MongoVUE
47.5. Map-Reduce
47.5.1. 使用 Map-Reduce 統計Web 伺服器 access.log 日誌檔案
47.6. MongoDB 2.x 早期版本
47.6.1. 用戶管理
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. HQL
49.3.1. namespace 命名空間管理
49.3.2. Table 表
49.4. FAQ
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
54. Flare
55. Voldemort
56. LevelDB
57. HyperDex
58. LeoFS
VI. Search Engine
59. Solr
59.1. 安裝
59.2. Core Admin
59.2.1. Schema
59.3. 索引
59.3.1. Indexing a directory of "rich" files
59.3.2. Indexing Solr XML
59.3.3. Indexing JSON
59.3.4. Deleting Data
59.4. 介面
59.4.1. 查詢
59.5. FAQ
59.5.1. NOTE: Please install lsof as this script needs it to determine if Solr is listening on port 8983.
59.6. Solr 1.3.0
59.6.1. Embedded Jetty
59.6.2. Jetty
59.6.3. Tomcat
59.6.4. solr-php-client
59.6.5. multicore
59.6.6. 中文分詞
60. Elasticsearch
60.1. 安裝 Elasticsearch
60.1.1. RPM 安裝
60.1.2. YUM 安裝
60.1.3. 測試安裝是否正常
60.2. 文檔API
60.2.1. 快速上手
60.2.2. 寫入 PUT/POST
60.2.3. 獲取 GET
60.2.4. 檢查記錄是否存在
60.2.5. 刪除 Delete
60.2.6. 參數
60.3. 搜索
60.3.1. 分頁
60.3.2. 字元串搜索
60.3.3. Query DSL
60.4. Plugin 插件管理
60.4.1. 手工安裝插件
60.4.2. plugin 命令
60.4.3. 插件測試
60.5. 映射
60.5.1. 查看 _mapping
60.5.2. 刪除 _mapping
60.5.3. 創建 _mapping
60.5.4. 修改 _mapping
60.5.5. 數據類型
60.6. Alias management 別名管理
60.6.1. 查看索引別名
60.6.2. 創建索引別名
60.6.3. 修改別名
60.6.4. 刪除別名
60.7. Example
60.7.1. 新聞資訊應用案例
60.8. FAQ
60.8.1. Plugin [analysis-ik] is incompatible with Elasticsearch [2.3.5]. Was designed for version [2.3.4]
60.8.2. mapper_parsing_exception: failed to parse [ctime]
61. Nutch
62. Sphinx
63. Lucene
64. MG4J
65. PhpDig
66. 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
23.1. BEFORE/AFTER
23.2. uuid()
25.1. SQL ANY example
29.1. /etc/pgbouncer/pgbouncer.ini
37.1. Oracle 字符集切換實例
37.2. 創建表空間實例
39.1. expdp
39.2. impdp
39.3. full backup
40.1.
42.1. DB LINK
47.1. MongoDB Test
47.2. Using MongoDB in PHP
48.1. Twitter
48.2. Twissandra
51.1. /etc/init.d/memcached
59.1. Solr - schema.xml
59.2. /etc/profile.d/java.sh