Cargando…
Effective MySQL : optimizing SQL statements /
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....
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
Oracle Press/McGraw-Hill,
©2011.
|
| Colección: | Oracle Press Ser.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn819322421 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 121126s2011 nyua o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d COO |d DEBSZ |d TEFOD |d OCLCQ |d OCLCF |d TEFOD |d STF |d YDXCP |d OCLCQ |d TEFOD |d OCLCQ |d EBLCP |d TOH |d OCLCQ |d CEF |d G3B |d OCLCO |d OCLCQ |d OCLCO | ||
| 019 | |a 814369027 |a 1103553434 |a 1164491704 | ||
| 020 | |a 9780071782807 |q (electronic bk.) | ||
| 020 | |a 007178280X |q (electronic bk.) | ||
| 020 | |z 0071782796 | ||
| 020 | |z 9780071782791 | ||
| 024 | 8 | |a 007178280X | |
| 024 | 8 | |a 9780071782791 | |
| 029 | 1 | |a AU@ |b 000050347651 | |
| 029 | 1 | |a AU@ |b 000053283095 | |
| 029 | 1 | |a DEBBG |b BV040903246 | |
| 029 | 1 | |a DEBSZ |b 378275267 | |
| 029 | 1 | |a DEBSZ |b 381393070 | |
| 029 | 1 | |a AU@ |b 000066231123 | |
| 035 | |a (OCoLC)819322421 |z (OCoLC)814369027 |z (OCoLC)1103553434 |z (OCoLC)1164491704 | ||
| 037 | |a CL0500000176 |b Safari Books Online | ||
| 037 | |a F2E1EE34-5B81-4681-A3B2-8DEAE38D8C41 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.D3 | |
| 082 | 0 | 4 | |a 005.75/65 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Bradford, Ronald. | |
| 245 | 1 | 0 | |a Effective MySQL : |b optimizing SQL statements / |c Ronald Bradford. |
| 246 | 3 | 0 | |a Optimizing SQL statements |
| 260 | |a New York : |b Oracle Press/McGraw-Hill, |c ©2011. | ||
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Oracle Press Ser. | |
| 588 | 0 | |a Print version record. | |
| 500 | |a Includes index. | ||
| 520 | |a 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 diagnosing issuesLearn how different index theories are applied and represented in MySQLPlan and execute. | ||
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a Ordering Results -- Multi Column Indexes -- Determining Which Index to Use -- Multi Column Index Syntax -- Providing a Better Index -- Many Column Indexes -- Combining WHERE and ORDER BY -- MySQL Optimizer Features -- Query Hints -- Complicated Queries -- The Impact of Adding Indexes -- DML Impact -- DDL Impact -- Disk Space Impact -- MySQL Limitations -- Cost Based Optimizer -- QEP Pinning -- Index Statistics -- Function Based Indexes -- Multiple Indexes per Table -- Conclusion -- 5 Creating Better MySQL Indexes -- Better Indexes -- Covering Index -- Storage Engine Implications -- Partial Index | |
| 505 | 8 | |a Conclusion -- 6 MySQL Configuration Options -- Memory Related Variables -- key_buffer_size -- Named Key Buffers -- innodb_buffer_pool_size -- innodb_additional_mem_pool_size -- query_cache_size -- max_heap_table_size -- tmp_table_size -- join_buffer_size -- sort_buffer_size -- read_buffer_size -- read_rnd_buffer_size -- Instrumentation Related Variables -- slow_query_log -- slow_query_log_file -- general_log -- general_log_file -- long_query_time -- log_output -- Profiling -- Other Optimization Variables -- optimizer_switch -- default_storage_engine -- max_allowed_packet -- sql_mode | |
| 505 | 8 | |a Innodb_strict_mode -- Other Variables -- Conclusion -- 7 The SQL Lifecycle -- Capture Statements -- General Query Log -- Slow Query Log -- Binary Log -- Processlist -- Engine Status -- MySQL Connectors -- Application Code -- INFORMATION_SCHEMA -- PERFORMANCE_SCHEMA -- SQL Statement Statistics Plugin -- MySQL Proxy -- TCP/IP -- Identify Problematic Statements -- Slow Query Log Analysis -- TCP/IP Analysis -- Confirm Statement Operation -- Environment -- Timing -- Analyze Statements -- Optimize Statements -- Verify the Results -- Conclusion -- 8 Hidden Performance Tips | |
| 542 | |f Copyright © McGraw-Hill 2012 |g 2012 | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 blmlsh |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Bradford, Ronald. |t Effective MySQL. |d New York : Oracle Press/McGraw-Hill, ©2012 |z 9780071782791 |w (DLC) 2011037338 |w (OCoLC)748332995 |
| 830 | 0 | |a Oracle Press Ser. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780071782791/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL4958482 | ||
| 938 | |a YBP Library Services |b YANK |n 12087444 | ||
| 994 | |a 92 |b IZTAP | ||