Effective MySQL: optimizing SQL statements

Type Book

Rate 0.0 /5

The Essential Guide to SQL Statement Optimization Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements. Identify the essential analysis commands for gathering and diag…

Details

Files

Reviews

Download

Title Statements

Full title :Effective MySQL : optimizing SQL statements / Ronald Bradford.

Summary

Edition Statements

Publication Date:©2011.

Publication Statements

Publisher(s):Oracle Press/McGraw-Hill
Place of Publication:New York
Language:eng
Publication Date:©2011.

Notes

Includes index.

The Physical Object

Description:1 online resource (1 volume) : : illustrations

Edition Identifiers

ISBN:9780071782807, 007178280X
oclc:ocn819322421
LC Classification:QA76.9.D3
Dewey Decimal:005.75/65

Cover Page -- Title Page -- Copyright -- Contents -- Acknoledgements -- Introduction -- 1 The Five Minute DBA -- Identifying Performance Problems -- Finding a Slow SQL Statement -- Confirming the Slow Query -- Optimizing Your Query -- What You Should Not Do -- Confirm Your Optimization -- The Correct Approach -- An Alternative Solution -- Conclusion -- 2 The Essential Analysis Commands -- EXPLAIN -- EXPLAIN PARTITIONS -- EXPLAIN EXTENDED -- SHOW CREATE TABLE -- SHOW INDEXES -- SHOW TABLE STATUS -- SHOW STATUS -- SHOW VARIABLES -- INFORMATION_SCHEMA -- Conclusion

3 Understanding MySQL Indexes -- Example Tables -- MySQL Index Usages -- Data Integrity -- Optimizing Data Access -- Table Joins -- Sorting Results -- Aggregation -- About Storage Engines -- Index Terminology -- MySQL Index Types -- Index Data Structure Theory -- MySQL Implementation -- MySQL Partitioning -- Conclusion -- 4 Creating MySQL Indexes -- Example Tables -- Existing Indexes -- Single Column Indexes -- Syntax -- Restricting Rows with an Index -- Joining Tables with an Index -- Understanding Index Cardinality -- Using Indexes for Pattern Matching -- Selecting a Unique Row

Ordering Results -- Multi Column Indexes …