PostgreSQL, MariaDB, MySQL, Oracle ...
文檔初創于April 6, 2008
版權 © 2009-2019 Netkiller(Neo Chan). All rights reserved.
版權聲明
轉載請與作者聯繫，轉載時請務必標明文章原始出處和作者信息及本聲明。
|
|
|
|
$Date: 2013-05-21 19:01:33 +0800 (Tue, 21 May 2013) $
Netkiller 資料庫系列手札
資料庫系列手札
| Netkiller Database 手札 | | | Netkiller PostgreSQL 手札 | | | Netkiller MySQL 手札 | | | Netkiller NoSQL 手札 | | | Netkiller LDAP 手札 |
目錄
- 1. 自述
- I. Database Relational
- II. Search Engine
- 8. Elasticsearch
- 8.1. 安裝 Elasticsearch
- 8.2. 文檔API
- 8.3. 搜索
- 8.4. Query DSL
- 8.5. 集群管理
- 8.6. 中文分詞插件管理
- 8.7. 索引管理
- 8.8. 映射
- 8.9. Alias management 別名管理
- 8.10. Example
- 8.11. Migrating MySQL Data into Elasticsearch using logstash
- 8.12. 安裝 Elasticsearch 2.3
- 8.13. FAQ
- 9. Solr
- 10. Nutch
- 11. Sphinx
- 12. Lucene
- 13. MG4J
- 14. PhpDig
- 15. Mahout
- 16. Apache Hbase
- 17. Apache Hive
- 18. Apache Sqoop
- III. MySQL
- 19. MySQL Server
- 19.1. MySQL Installation
- 19.1.1. Installation by apt under debian/ubuntu
- 19.1.2. Installation by source code
- 19.1.3. MySQL binary distribution
- 19.1.4. CentOS
- 19.1.5. Docker
- 19.1.6. mysql-admin
- 19.1.7. Installing MySQL on Linux Using the MySQL Yum Repository
- 19.1.8. Firewall
- 19.1.9. Limit 狀態
- 19.1.10. 使用 Btrfs 檔案系統存儲mysql數據
- 19.1.11. Mac OS
- 19.2. MariaDB
- 19.3. Percona
- 19.4. my.cnf
- 19.5. MySQL Plugin
- 19.6. Replication
- 19.7. MySQL Custer
- 19.8. MySQL Proxy
- 19.9. MySQL Router
- 19.10. variables
- 19.11. SHOW COMMAND
- 19.11.1. 查看版本
- 19.11.2. status
- 19.11.3. show processlist
- 19.11.4. binary 日誌
- 19.11.5. 綫程的使用情況
- 19.11.6. DATABASES
- 19.11.7. TABLE
- 19.11.8. 臨時表
- 19.11.9. 排序統計信息
- 19.11.10. Key 狀態
- 19.11.11. FUNCTION
- 19.11.12. PROCEDURE
- 19.11.13. TRIGGERS
- 19.11.14. EVENTS
- 19.11.15. 引擎(ENGINES)
- 19.11.16. 字符集(Collation)
- 19.11.17. SHOW GRANTS
- 19.11.18. validate_password
- 19.12. Monitoring
- 20. Client and Utility Programs
- 20.1. mysql - the MySQL command-line tool
- 20.2. mysqldump - a database backup program
- 20.3. mysqladmin - client for administering a MySQL server
- 20.4. myisamchk — MyISAM Table-Maintenance Utility
- 20.5. mysqlcheck — A Table Maintenance and Repair Program
- 20.6. mysqlslap - load emulation client
- 20.7. mysqldumpslow - Parse and summarize the MySQL slow query log.
- 20.8. mysql log
- 21. Database Administration
- 21.1. User Account Management
- 21.2. Access Privilege System
- 21.3. Maintenance 資料庫維護
- 21.4. INFORMATION_SCHEMA
- 21.5. Backup and Recovery
- 22. DDL - Data Definition Language
- 22.1. 資料庫管理(Database)
- 22.2. 表管理(Table)
- 22.3. Partitioning
- 22.4. Index
- 22.5. 外鍵(Foreign Key)
- 22.6. 視圖(View)
- 22.7. 存儲過程(PROCEDURE)
- 22.8. 函數
- 22.9. 觸發器(Trigger)
- 22.10. 事件調度器(EVENT)
- 23. DML (Data Manipulation Language)
- 24. SQL Statement Syntax
- 25. Functions and Operators
- 26. DCL (Data Control Language)
- 27. Optimization
- 28. MySQL Connectors
- 29. MySQL GUI/Web Manager
- 30. Miscellaneous
- 31. FAQ
- 31.1. Reset root password 重置MySQL root密碼
- 31.2. 資料庫內容替換
- 31.3. 查看錯誤代碼
- 31.4. 臨時表是否需要建索引
- 31.5. Kill 腳本
- 31.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
- 31.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- 31.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 31.9. 重新整理AUTO_INCREMENT欄位
- 31.10. 轉換 latin1 到 UTF-8
- 31.11. this is incompatible with sql_mode=only_full_group_by
- 31.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
- 31.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
- 31.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
- 31.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
- 31.16. ERROR 1415: Not allowed to return a result set from a trigger
- 31.17. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory
- 31.18. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
- IV. Redis
- 32. Redis 安裝
- 33. /etc/redis.conf
- 34. redis-cli - Command-line client to redis-server
- 35. redis-benchmark 測試工具
- 36. Redis Cluster
- 37. Redis 通信協議
- 38. phpRedisAdmin
- 39. Redis 開發
- 40. A fast, light-weight proxy for memcached and redis
- 41. FAQ
- V. MongoDB
- 42. Install 安裝MongoDB
- 43. 資料庫管理
- 44. 命令工具
- 45. MongoDB Shell
- 46. Mongo Admin UI
- 47. FAQ
- 47.1. Reset root password 重置MySQL root密碼
- 47.2. 資料庫內容替換
- 47.3. 查看錯誤代碼
- 47.4. 臨時表是否需要建索引
- 47.5. Kill 腳本
- 47.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
- 47.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- 47.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 47.9. 重新整理AUTO_INCREMENT欄位
- 47.10. 轉換 latin1 到 UTF-8
- 47.11. this is incompatible with sql_mode=only_full_group_by
- 47.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
- 47.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
- 47.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
- 47.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
- 47.16. ERROR 1415: Not allowed to return a result set from a trigger
- 47.17. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory
- 47.18. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
- 48. Cassandra
- 49. Hypertable
- 50. CouchBase
- 51. Memcached
- 52. RethinkDB
- 53. TokyoCabinet/Tyrant
- 54. Flare
- 55. Voldemort
- 56. LevelDB
- 57. HyperDex
- 58. LeoFS
- VI. PostgreSQL
- 59. PostgreSQL 安裝
- 60. Database Administration
- 60.1. User Account Management
- 60.2. Access Privilege System
- 60.3. Maintenance 資料庫維護
- 60.4. INFORMATION_SCHEMA
- 60.5. Backup and Recovery
- 61. PostgreSQL 命令
- 62. DDL - Data Definition Language
- 62.1. 資料庫管理(Database)
- 62.2. 表管理(Table)
- 62.3. Partitioning
- 62.4. Index
- 62.5. 外鍵(Foreign Key)
- 62.6. 視圖(View)
- 62.7. 存儲過程(PROCEDURE)
- 62.8. 函數
- 62.9. 觸發器(Trigger)
- 62.10. 事件調度器(EVENT)
- 63. DML (Data Manipulation Language)
- 64. SQL Statement Syntax
- 65. Functions and Operators
- 66. PostgreSQL GUI
- 67. Barman Backup & recovery for PostgreSQL
- 68. pgbouncer - lightweight connection pooler for PostgreSQL
- 69. Foreign data wrappers
- 70. Barman for PostgreSQL
- 71. Connector
- 72. Replication
- 73. FAQ
- 73.1. Reset root password 重置MySQL root密碼
- 73.2. 資料庫內容替換
- 73.3. 查看錯誤代碼
- 73.4. 臨時表是否需要建索引
- 73.5. Kill 腳本
- 73.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
- 73.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- 73.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 73.9. 重新整理AUTO_INCREMENT欄位
- 73.10. 轉換 latin1 到 UTF-8
- 73.11. this is incompatible with sql_mode=only_full_group_by
- 73.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
- 73.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
- 73.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
- 73.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
- 73.16. ERROR 1415: Not allowed to return a result set from a trigger
- 73.17. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory
- 73.18. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
- VII. Oracle
- 74. Oracle 12c 安裝可
- 75. Privilege
- 76. 資料庫管理
- 77. Oracle Gui
- 78. CLI
- 79. DDL
- 80. 程序包
- 81. 資料庫連結
- 82. Oracle 監控
- 83. Installing Oracle Database
- 83.1. Installing Oracle Database 10g Release 2 on Linux x86
- 83.2. 11gR2
- 83.3. Installing Oracle Client 11g
- 83.4. Silence Install - Database
- 83.5. Silence Install - Client
- 83.6. oracle 817 script
- 83.7. Script for automatic startup on boot
- 83.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
- 84. FAQ
- 84.1. Reset root password 重置MySQL root密碼
- 84.2. 資料庫內容替換
- 84.3. 查看錯誤代碼
- 84.4. 臨時表是否需要建索引
- 84.5. Kill 腳本
- 84.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
- 84.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
- 84.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 84.9. 重新整理AUTO_INCREMENT欄位
- 84.10. 轉換 latin1 到 UTF-8
- 84.11. this is incompatible with sql_mode=only_full_group_by
- 84.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
- 84.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
- 84.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
- 84.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
- 84.16. ERROR 1415: Not allowed to return a result set from a trigger
- 84.17. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory
- 84.18. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
- 85. 資料庫遷移
表格清單
- 26.1. 更新丟失演示
- 26.2. 防止更新丟失加鎖演示
範例清單
- 8.1. Elasticsearch master / slave
- 9.1. Solr - schema.xml
- 9.2. /etc/profile.d/java.sh
- 19.1. my.cnf
- 19.2. my.cnf
- 19.3. my.cnf
- 22.1. BEFORE/AFTER
- 22.2. uuid()
- 24.1. SQL ANY example
- 27.1. SQL_CACHE 測試
- 27.2. SHOW PROFILE Syntax
- 42.1. MongoDB Test
- 42.2. Using MongoDB in PHP
- 43.1. Oracle 字符集切換實例
- 43.2. 創建表空間實例
- 48.1. Twitter
- 48.2. Twissandra
- 51.1. /etc/init.d/memcached
- 59.1. Example for /var/lib/pgsql/10/data/pg_hba.conf
- 62.1. BEFORE/AFTER
- 62.2. uuid()
- 64.1. SQL ANY example
- 68.1. /etc/pgbouncer/pgbouncer.ini
- 76.1. Oracle 字符集切換實例
- 76.2. 創建表空間實例
- 78.1. expdp
- 78.2. impdp
- 78.3. full backup
- 79.1.
- 81.1. DB LINK