Home | 简体中文 | 繁体中文 | 杂文 | Search | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 作品与服务 | 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. 文档下载
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.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. 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
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
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. PROCEDURE
37.8. FUNCTION
37.9. 视图、存储过程、函数
37.10. 查看存储过程源代码
37.11. 日期时间格式
37.11.1. Date
37.11.2. 修改系统日期格式
37.11.3. TIMESTAMP
37.11.4.
37.12. 切换字符集
37.12.1. 切换到 GBK
37.12.2. 切到 UTF-8
37.12.3. 切到 AL32UTF8
37.12.4. 切换过程实例
37.13. Oracle 表空间
37.13.1. 查询空闲表空间
37.13.2. 创建表空间
37.13.3. 更改表空间属性
37.13.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 - Data Definition Language
40.1. 数据库管理(Database)
40.1.1. create
40.1.2. drop
40.1.3. Alter
40.1.4. Rename
40.1.5. CHARACTER
40.1.6. show create database
40.2. 表管理(Table)
40.2.1. 数据类型
40.2.2. create table ... select
40.2.3. modifiy table
40.2.4. TEMPORARY Table
40.2.5. Collate
40.2.6. CHARACTER
40.2.7. DEFAULT
40.2.8. KEY
40.2.9. COMMENT
40.2.10. Engine
40.3. Partitioning
40.3.1. RANGE
40.3.2. LIST
40.3.3. HASH
40.3.4. KEY分区
40.3.5. Subpartitioning
40.3.6. 分区管理
40.3.7. EXPLAIN PARTITIONS
40.3.8. SHOW CREATE TABLE
40.3.9. INFORMATION_SCHEMA.partitions 表
40.3.10. 分区数据操作
40.4. Index
40.4.1. SHOW INDEX
40.4.2. CREATE INDEX
40.4.3. DROP INDEX
40.4.4. rebuild
40.5. 外键(Foreign Key)
40.5.1. FOREIGN KEY (RESTRICT)
40.6. 视图(View)
40.7. 存储过程(PROCEDURE)
40.7.1. 存储程序
40.7.2. 函数
40.8. 触发器(Trigger)
40.8.1. create trigger
40.8.2. drop trigger
40.8.3. show triggers
40.8.4. EXAMPLE
40.9. 事件调度器(EVENT)
40.9.1. 启用 EVENT
40.9.2. 创建 EVENT
40.9.3. 禁用/启用
40.9.4. show events
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
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. MONITOR
46.3.2. save/bgsave/lastsave
46.3.3. Pub/Sub 订阅与发布
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. Quickstart
47.1.1. 二进制tar包安装
47.1.2. Ubuntu MongoDB
47.1.3. CentOS MongoDB
47.1.4. MongoDB + Hadoop
47.2. Security and Authentication
47.2.1. 超级管理员
47.2.2. 数据库用户
47.2.3. 删除用户
47.3. Replication
47.3.1. Master
47.3.2. Slave
47.3.3. 测试
47.4. Drivers
47.4.1. Using MongoDB in PHP
47.5. mongo shell
47.5.1. help
47.5.2. show 查看命令
47.5.3. 切换数据库
47.5.4. 记录管理
47.6. 命令
47.6.1. mongo
47.6.2. mongodump - Backup
47.6.3. mongorestore
47.6.4. mongostat
47.6.5. mongotop
47.6.6. mongofiles - Browse and modify a GridFS filesystem.
47.7. Mongo Admin UI
47.7.1. RockMongo
47.7.2. MongoVUE
47.8. Unique Indexes
47.8.1. 索引管理
47.9. Map-Reduce
47.9.1. 使用 Map-Reduce 统计Web 服务器 access.log 日志文件
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. 编译安装
51.1.2. debian/ubuntu
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
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. BEFORE/AFTER
40.2. uuid()
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
comments powered by Disqus