舉報(bào) 
會(huì)員
MariaDB Cookbook
最新章節(jié)：
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 更新時(shí)間：2021-07-16 12:19:53
推薦閱讀
- 神經(jīng)網(wǎng)絡(luò)編程實(shí)戰(zhàn)：Java語言實(shí)現(xiàn)（原書第2版）
- Python 3網(wǎng)絡(luò)爬蟲實(shí)戰(zhàn)
- Building Cross-Platform Desktop Applications with Electron
- Java加密與解密的藝術(shù)
- Easy Web Development with WaveMaker
- SAS數(shù)據(jù)統(tǒng)計(jì)分析與編程實(shí)踐
- Visual C++應(yīng)用開發(fā)
- 程序員修煉之道：通向務(wù)實(shí)的最高境界（第2版）
- iOS開發(fā)實(shí)戰(zhàn)：從入門到上架App Store（第2版） （移動(dòng)開發(fā)叢書）
- JavaScript+jQuery網(wǎng)頁(yè)特效設(shè)計(jì)任務(wù)驅(qū)動(dòng)教程
- iOS開發(fā)項(xiàng)目化入門教程
- Isomorphic Go
- Android 5從入門到精通
- 微信公眾平臺(tái)開發(fā)最佳實(shí)踐
- Learning Dynamics NAV Patterns
- Visual Basic 開發(fā)從入門到精通
- PHP從入門到精通（微視頻精編版）
- 微信公眾平臺(tái)服務(wù)號(hào)開發(fā)：揭秘九大高級(jí)接口
- Getting Started with SpriteKit
- 深度學(xué)習(xí)企業(yè)實(shí)戰(zhàn)：基于R語言
- Mockito for Spring
- Learning IPython for Interactive Computing and Data Visualization（Second Edition）
- 軟件測(cè)試實(shí)驗(yàn)教程
- HTML5+CSS3+JavaScript Web前端開發(fā)案例教程（慕課版）
- 思維訓(xùn)練啟蒙新觀念：青少年P(guān)ascal語言編程搶先起跑一路通
- 程序員面試筆試真題庫(kù)
- 精通LevelDB
- Java編程方法論：響應(yīng)式Spring Reactor 3設(shè)計(jì)與實(shí)現(xiàn)
- 劍指JavaWeb：技術(shù)詳解與應(yīng)用實(shí)踐
- Web開發(fā)技術(shù)：HTML、CSS、JavaScript
