首頁 > 計算機網絡 >
專用軟件
> MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users最新章節目錄
舉報 
會員
MySQL Admin Cookbook LITE: Configuration, Server Monitoring, Managing Users
最新章節：
Index
Learn?SetupMySQLreplicationtomanageloadbalancing,onlinebackup,andfail-overscenarios?Create,modify,anddeleteindexes;alsoidentifyduplicateindexestooptimizeyourMySQLservers'performance?Setupautomaticallyupdatedslaves?EstimateandlimityournetworkandslaveI/Oload?Checkthatyourserversareinsynctoimprovecommunication?Learnaboutprimarykeys?Speedupyoursearchesforsub-domainsAboutMySQListhemostpopularopen-sourcedatabaseandisalsoknownforitseasysetupfeature.However,properconfigurationbeyondthedefaultsettingsremainsachallenge,alongwithday-to-daymaintenancetaskssuchasindexingandreplication.Thesetaskshavenotbeencoveredthoroughlyinthedefaultdocumentation.ThisMySQLAdminCookbookLITEcoverstwokeyaspectsofMySQLadministrationindetail;replication,whichwillallowyoutoorganizeyourdatabasemoreefficiently,andindexing,whichenablesyoutoaccessinformationeveninthedeepest,darkestdepthsofyourlargestdatabases.Alloftherecipesarebasedonreal-worldexperiencewhichwerederivedfromprovensolutionsusedinanenterpriseenvironment.Tofindoutmoreaboutupgradingtothefulledition,visitwww.packtpub.com/lite-editionsandlogintoyouraccountforoffersandhelp.Ifyoudon’thaveanaccountonPacktPub.com,visittodayandsetoneup!Features?SetupMySQLtoperformadministrativetaskssuchasreplicationandindexing?Balanceserverloadsacrossmultiplemachines,easebackupsandmuchmorewithreplication?Allowforrapidandefficientaccessacrossyourdatabasewithindexing?PartofPackt'sCookbookseries:Eachrecipeisacarefullyorganizedsequenceofinstructionstocompletethetaskasefficientlyaspossible
目錄(38章)
倒序
- 封面
- 版權信息
- Credits
- About the Authors
- About the Reviewers
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Replication
- Introduction
- Setting up automatically updated slaves of a server based on a SQL dump
- Setting up automatically updated slaves of a selection of tables based on a SQL dump
- Setting up automatically updated slaves using data file copy
- Sharing read load across multiple machines
- Using replication to provide full-text indexing for InnoDB tables
- Estimating network and slave I/O load
- Limiting network and slave I/O load in heavy write scenarios using the blackhole storage engine
- Setting up slaves via network streaming
- Skipping problematic queries
- Checking if servers are in sync
- Avoiding duplicate server IDs
- Setting up slaves to report custom information about themselves to the master
- Chapter 2. Indexing
- Introduction
- Adding indexes to tables
- Adding a fulltext index
- Creating a normalized text search column
- Removing indexes from tables
- Estimating InnoDB index space requirements
- Using prefix primary keys
- Choosing InnoDB primary key columns
- Speeding up searches for (sub)domains
- Finding duplicate indexes
- Index 更新時間：2021-04-02 19:43:57
推薦閱讀
- 商用級AIGC繪畫創作與技巧（Midjourney+Stable Diffusion）
- Photoshop CC超級學習手冊
- Yii 1.1 Application Development Cookbook
- CakePHP 1.3 Application Development Cookbook
- ABAQUS基礎入門與案例精通
- Cinema 4D電商美工與視覺設計案例教程（培訓教材版）
- After Effects影視特效立體化教程：After Effects 2021（微課版）
- AutoCAD 2017從新手到高手
- PowerPoint 2016實戰從入門到精通（超值版）
- 網店美工設計：Photoshop CC案例教程（視頻指導版）
- 中文版Photoshop CS6從新手到高手·全彩版
- 中文版Photoshop CC基礎培訓教程
- 蝶變：移動用戶體驗設計之道
- AI繪畫基礎與商業實戰
- Quality Assurance for Dynamics AX-Based ERP Solutions
- UML 2.0 in Action: A project/based tutorial
- Photoshop+Firefly從入門到精通
- 中文版Photoshop 2020基礎培訓教程
- MATLAB完全自學教程
- Excel高手捷徑：一招鮮，吃遍天
- Microsoft Visual Studio LightSwitch Business Application Development
- Adobe Dreamweaver CS4 網頁設計與制作標準實訓教程
- Rhino 8.0中文版完全自學一本通
- CAXA電子圖板2011機械設計與制作標準實訓教程
- SolidWorks高級應用教程（2020中文版）
- 中文版Photoshop 2022從入門到實戰視頻教程（全彩版）
- Excel 2016數據處理與分析（微課版）
- Tableau數據可視化分析從新手到高手
- Building Websites with Joomla! v1.0
- Drupal 6 Theming Cookbook
