Home | 简体中文 | 繁体中文 | 杂文 | Search | ITEYE 博客 | OSChina 博客 | Facebook | Linkedin | 作品与服务 | Email
Netkiller Database 手札
   下一页

Netkiller Database 手札

PostgreSQL, MySQL, Oracle ...

Mr. Neo Chan, 陈景峯(BG7NYT)


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


文档初创于April 6, 2008

版权 © 2009, 2010, 2011, 2012, 2013, 2014 Netkiller(Neo Chan). All rights reserved.

版权声明

转载请与作者联系，转载时请务必标明文章原始出处和作者信息及本声明。
文档出处:
http://netkiller.github.io
http://netkiller.sourceforge.net

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

QQ群：128659835 请注明“读者”

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

我的系列文档

编程语言

Netkiller Architect 手札 Netkiller Developer 手札 Netkiller PHP 手札 Netkiller Python 手札 Netkiller Testing 手札 Netkiller Cryptography 手札
Netkiller Perl 手札 Netkiller Docbook 手札 Netkiller Project 手札 Netkiller Java 手札 Netkiller DevOps 手札  

操作系统

Netkiller Linux 手札 Netkiller Debian 手札 Netkiller CentOS 手札 Netkiller FreeBSD 手札 Netkiller Shell 手札 Netkiller Security 手札
Netkiller Web 手札 Netkiller Monitoring 手札 Netkiller Storage 手札 Netkiller Mail 手札 Netkiller Multimedia 手札  

数据库

Netkiller Database 手札 Netkiller PostgreSQL 手札 Netkiller MySQL 手札 Netkiller NoSQL 手札 Netkiller LDAP 手札  

网络设备及其他

Netkiller Network 手札 Netkiller Cisco IOS 手札 Netkiller H3C 手札 Netkiller Amateur Radio 手札   

您可以使用iBook阅读当前文档

目录

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. create table ... select
11.2.2. modifiy table
11.2.3. TEMPORARY Table
11.2.4. Collate
11.2.5. CHARACTER
11.2.6. DEFAULT
11.2.7. KEY
11.2.8. COMMENT
11.2.9. 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
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
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字段
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. create table ... select
23.2.2. modifiy table
23.2.3. TEMPORARY Table
23.2.4. Collate
23.2.5. CHARACTER
23.2.6. DEFAULT
23.2.7. KEY
23.2.8. COMMENT
23.2.9. 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
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
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字段
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
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. 切换到 GBK
37.11.2. 切到 UTF-8
37.11.3. 切到 AL32UTF8
37.11.4. 切换过程实例
37.12. Oracle 表空间
37.12.1. 查询空闲表空间
37.12.2. 创建表空间
37.12.3. 更改表空间属性
37.12.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. 程序包
40.1. 执行包中的过程
41. Oracle 监控
41.1. Oracle日志的路径
41.2. SQL 日志监控
41.2.1. 查询性能分析
41.2.2. IO性能分析
41.3. session
41.4. SQL Monitoring Report
42. FAQ
42.1. Reset root password
42.2. 数据库内容替换
42.3. 查看错误代码
42.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
42.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
42.4. 临时表是否需要建索引
42.5. Kill 脚本
42.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
42.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
42.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
42.9. 重新整理AUTO_INCREMENT字段
43. Installing Oracle Database
43.1. Installing Oracle Database 10g Release 2 on Linux x86
43.2. 11gR2
43.3. Installing Oracle Client 11g
43.4. Silence Install - Database
43.4.1. Response File
43.4.2. OS 配置脚本
43.4.3. 运行 runInstaller
43.5. Silence Install - Client
43.6. oracle 817 script
43.7. Script for automatic startup on boot
43.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
V. NoSQL
44. Redis
44.1. Redis 安装
44.1.1. CentOS
44.1.2. Ubuntu
44.1.3. Test Redis
44.2. /etc/redis.conf
44.2.1. 密码认证
44.3. redis-cli - Command-line client to redis-server
44.3.1. MONITOR
44.3.2. save/bgsave/lastsave
44.3.3. Pub/Sub 订阅与发布
44.4. Redis Cluster
44.5. Redis 通信协议
44.5.1. 切换DB
44.5.2. info
44.5.3. 监控
44.5.4. keys
44.5.5. set/get/del
44.5.6. expire/ttl
44.6. phpRedisAdmin
44.7. Redis 开发
44.7.1. 消息订阅与发布
44.8. FAQ
44.8.1. 清空数据库
44.9. A fast, light-weight proxy for memcached and redis
45. MongoDB
45.1. Quickstart
45.1.1. 二进制tar包安装
45.1.2. Ubuntu MongoDB
45.1.3. CentOS MongoDB
45.1.4. MongoDB + Hadoop
45.2. Security and Authentication
45.2.1. 超级管理员
45.2.2. 数据库用户
45.2.3. 删除用户
45.3. Replication
45.3.1. Master
45.3.2. Slave
45.3.3. 测试
45.4. Drivers
45.4.1. Using MongoDB in PHP
45.5. 命令
45.5.1. mongo
45.5.2. mongodump - Backup
45.5.3. mongorestore
45.5.4. mongostat
45.5.5. mongotop
45.5.6. mongofiles - Browse and modify a GridFS filesystem.
45.6. Mongo Admin UI
45.6.1. RockMongo
45.6.2. MongoVUE
45.7. Map-Reduce
45.7.1. 使用 Map-Reduce 统计Web 服务器 access.log 日志文件
46. Cassandra
46.1. Getting Started
46.1.1. Downloading and Installation
46.1.2. Running Cassandra
46.1.3. cli tool
46.1.4. Testing Cassandra
46.2. Configure Cassandra
46.2.1. Envionment variables
46.2.2. log4j.properties
46.2.3. storage-conf.xml
46.3. Keyspace
46.3.1. Schema
46.3.2. Keyspace example
46.4. Cluster
46.4.1. Running a cluster
46.4.2. Running a single node
46.4.3. nodetool
47. Hypertable
47.1. Hypertable 安装
47.1.1. Hypertable standalone 单机安装
47.1.2. Hypertable on HDFS(hadoop) 安装
47.1.3. MapR
47.1.4. Ceph
47.1.5. 检验安装
47.2. Code examples
47.2.1. PHP
47.3. HQL
47.3.1. namespace 命名空间管理
47.3.2. Table 表
47.4. FAQ
47.4.1. 切换 DFS Broker
48. CouchBase
48.1. 安装 CouchBase
48.1.1. Getting Started with Couchbase on PHP
48.2. couchbase 命令
48.2.1. couchbase-cli
49. Memcached
49.1. 安装 Memcached
49.1.1. 编译安装
49.1.2. debian/ubuntu
49.2. Memcached 代理
49.2.1. moxi
49.2.2. memagent
50. RethinkDB
51. TokyoCabinet/Tyrant
52. Flare
53. Voldemort
54. LevelDB
55. HyperDex
56. LeoFS
VI. Search Engine
57. Solr
57.1. 安装
57.2. Core Admin
57.2.1. Schema
57.3. 索引
57.3.1. Indexing a directory of "rich" files
57.3.2. Indexing Solr XML
57.3.3. Indexing JSON
57.3.4. Deleting Data
57.4. 接口
57.4.1. 查询
57.5. FAQ
57.5.1. NOTE: Please install lsof as this script needs it to determine if Solr is listening on port 8983.
57.6. Solr 1.3.0
57.6.1. Embedded Jetty
57.6.2. Jetty
57.6.3. Tomcat
57.6.4. solr-php-client
57.6.5. multicore
57.6.6. 中文分词
58. Nutch
59. Sphinx
60. Lucene
61. MG4J
62. PhpDig
63. Mahout
64. elasticsearch

表格清单

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.
39.3. full backup
45.1. MongoDB Test
45.2. Using MongoDB in PHP
46.1. Twitter
46.2. Twissandra
49.1. /etc/init.d/memcached
57.1. Solr - schema.xml
57.2. /etc/profile.d/java.sh
comments powered by Disqus
   下一页
   自述