舉報 
會員
MariaDB Cookbook
最新章節：
Index
Apracticalcookbook,filledwithadvancedrecipes,andplentyofcodeandcommandsusedforillustration,whichwillmakeyourlearningcurveeasyandquick.ThisbookisforanyonewhowantstolearnmoreaboutdatabasesingeneralorMariaDBinparticular.SomefamiliaritywithSQLdatabasesisassumed,buttherecipesareapproachabletoalmostanyonewithbasicdatabaseskills.
目錄(140章)
倒序
- coverpage
- MariaDB Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Getting Started with MariaDB
- Introduction
- Installing MariaDB on Windows
- Installing MariaDB on Linux
- Installing MariaDB on Mac OS X
- Enabling the Feedback plugin
- Switching between InnoDB and XtraDB
- Creating a backup user
- Making backups with XtraBackup
- Making backups with mysqldump
- Checking and optimizing tables automatically with mysqlcheck and cron
- Using progress reporting in the mysql client
- Chapter 2. Diving Deep into MariaDB
- Introduction
- Importing the data exported by mysqldump
- Using SHOW EXPLAIN with running queries
- Using LIMIT ROWS EXAMINED
- Using INSTALL SONAME
- Producing HTML output
- Producing XML output
- Migrating a table from MyISAM to Aria
- Migrating a table from MyISAM or Aria to InnoDB or XtraDB
- Chapter 3. Optimizing and Tuning MariaDB
- Introduction
- Using SHOW STATUS to check if a feature is being used
- Controlling MariaDB optimizer strategies
- Using extended keys with InnoDB and XtraDB
- Configuring the Aria two-step deadlock detection
- Configuring the MyISAM segmented key cache
- Configuring threadpool
- Configuring the Aria pagecache
- Optimizing queries with the subquery cache
- Optimizing semijoin subqueries
- Creating an index
- Creating a full-text index
- Removing an index
- Using JOINs
- Using microseconds in the DATETIME columns
- Updating DATETIME and TIMESTAMP columns automatically
- Chapter 4. The TokuDB Storage Engine
- Introduction
- Installing TokuDB
- Configuring TokuDB
- Creating TokuDB tables
- Migrating to TokuDB
- Adding indexes to TokuDB tables
- Modifying the compression of a TokuDB table
- Chapter 5. The CONNECT Storage Engine
- Introduction
- Installing the CONNECT storage engine
- Creating and dropping CONNECT tables
- Reading and writing CSV data using CONNECT
- Reading and writing XML data using CONNECT
- Accessing MariaDB tables using CONNECT
- Using the XCOL table type
- Using the PIVOT table type
- Using the OCCUR table type
- Using the WMI table type
- Using the MAC address table type
- Chapter 6. Replication in MariaDB
- Introduction
- Setting up replication
- Using global transaction IDs
- Using multisource replication
- Enhancing the binlog with row event annotations
- Configuring binlog event checksums
- Selectively skipping the replication of binlog events
- Chapter 7. Replication with MariaDB Galera Cluster
- Introduction
- Installing MariaDB Galera Cluster
- Dropping a node from MariaDB Galera Cluster
- Shutting down MariaDB Galera Cluster
- Chapter 8. Performance and Usage Statistics
- Introduction
- Installing the Audit Plugin
- Using the Audit Plugin
- Using engine-independent table statistics
- Using extended statistics
- Enabling the performance schema
- Using the performance schema
- Chapter 9. Searching Data Using Sphinx
- Introduction
- Installing SphinxSE in MariaDB
- Installing the Sphinx daemon on Linux
- Installing the Sphinx daemon on Windows
- Configuring the Sphinx daemon
- Searching with the Sphinx daemon and SphinxSE
- Chapter 10. Exploring Dynamic and Virtual Columns in MariaDB
- Introduction
- Creating tables with dynamic columns
- Inserting updating and deleting dynamic column data
- Reading data from a dynamic column
- Using virtual columns
- Chapter 11. NoSQL with HandlerSocket
- Introduction
- Installing and configuring HandlerSocket
- Installing the libhsclient library
- Installing the HandlerSocket PERL client libraries
- Reading data using HandlerSocket and PERL
- Inserting data using HandlerSocket and PERL
- Updating and deleting data using HandlerSocket and PERL
- Installing the HandlerSocket Python client libraries
- Reading data using HandlerSocket and Python
- Inserting data using HandlerSocket and Python
- Updating and deleting data using HandlerSocket and Python
- Installing the HandlerSocket Ruby client libraries
- Reading data using HandlerSocket and Ruby
- Inserting data using HandlerSocket and Ruby
- Updating and deleting data using HandlerSocket and Ruby
- Using HandlerSocket directly with Telnet
- Chapter 12. NoSQL with the Cassandra Storage Engine
- Introduction
- Installing the Cassandra storage engine
- Mapping data between MariaDB and Cassandra
- Using INSERT UPDATE and DELETE with the Cassandra storage engine
- Using SELECT with the Cassandra storage engine
- Chapter 13. MariaDB Security
- Introduction
- Securing MariaDB with mysql_secure_installation
- Securing MariaDB files on Linux
- Securing MariaDB files on Windows
- Checking for users with insecure passwords
- Encrypting connections with SSL
- Using roles to control user permissions
- Authenticating using the PAM authentication plugin
- Index 更新時間：2021-07-16 12:19:53
推薦閱讀
- C語言程序設計案例教程
- Java完全自學教程
- jQuery EasyUI網站開發實戰
- Oracle 12c中文版數據庫管理、應用與開發實踐教程 (清華電腦學堂)
- Designing Hyper-V Solutions
- 小程序，巧運營：微信小程序運營招式大全
- Oracle Database 12c Security Cookbook
- C語言開發基礎教程（Dev-C++）（第2版）
- 學習OpenCV 4：基于Python的算法實戰
- Apache Camel Developer's Cookbook
- Julia數據科學應用
- JavaEE架構與程序設計
- Web開發新體驗
- Cinder：Begin Creative Coding
- C語言程序設計教程
- Head First Go語言程序設計
- 自然語言處理NLP從入門到項目實戰：Python語言實現
- Java EE 7 First Look
- Service Worker Development Cookbook
- 零基礎學C# 3.0
- 微信小程序開發
- Moodle Course Design Best Practices（Second Edition）
- Django 3 Web應用開發實戰
- 大模型應用開發極簡入門：基于GPT-4和ChatGPT（第2版）
- Java程序員面試筆試寶典
- C#深入詳解
- Mastering Adobe Captivate 8
- Java多線程編程核心技術（第3版）
- Preparing for the Certified OpenStack Administrator Exam
- J2EE應用開發詳解
