Understanding MySQL internals:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2007
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XVII, 234 S. graph. Darst. |
| ISBN: | 9780596009571 0596009577 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV022948171 | ||
| 003 | DE-604 | ||
| 005 | 20071116 | ||
| 007 | t | ||
| 008 | 071107s2007 d||| |||| 00||| eng d | ||
| 015 | |a 07,N10,0036 |2 dnb | ||
| 020 | |a 9780596009571 |c : EUR 48.00 (freier Pr.) |9 978-0-596-00957-1 | ||
| 020 | |a 0596009577 |c : EUR 48.00 (freier Pr.) |9 0-596-00957-7 | ||
| 024 | 3 | |a 9780596009571 | |
| 035 | |a (OCoLC)438844770 | ||
| 035 | |a (DE-599)BVBBV022948171 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-706 | ||
| 080 | |a 004.43 | ||
| 082 | 0 | |a 005.7585 |2 22 | |
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Pachev, Alexander Sasha |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Understanding MySQL internals |c Sasha Pachev |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2007 | |
| 300 | |a XVII, 234 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a MySQL (Electronic resource) |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 0 | 7 | |a MySQL 5.0 |0 (DE-588)4792791-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a MySQL 5.0 |0 (DE-588)4792791-4 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch Darmstadt |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016152699&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-016152699 | ||
Datensatz im Suchindex
| _version_ | 1804137190014320640 |
|---|---|
| adam_text | UNDERSTANDING MYSQL INTERNALS SASHA PACHEV O REILLY 1 BEIJING *
CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI * TOKYO TABLE
OF CONTENTS PREFACE XI 1. MYSQL HISTORY AND ARCHITECTURE 1 MYSQL HISTORY
1 MYSQL ARCHITECTURE 4 2. NUTS AND BOLTS OF WORKING WITH THE MYSQL
SOURCE CODE 19 UNIX SHELL 19 BITKEEPER 19 PREPARING THE SYSTEM TO BUILD
MYSQL FROM BITKEEPER TREE 22 BUILDING MYSQL FROM BITKEEPER TREE 24
BUILDING FROM SOURCE DISTRIBUTION 25 INSTALLING MYSQL INTO A SYSTEM
DIRECTORY 26 SOURCE CODE DIRECTORY LAYOUT ... 27 PREPARING THE SYSTEM TO
RUN MYSQL IN A DEBUGGER 28 DEBUGGER-GUIDED SOURCE TOUR 29 BASICS OF
WORKING WITH GDB 30 FINDING THINGS IN THE SOURCE 33 INTERESTING
BREAKPOINTS AND VARIABLES 34 MAKING A SOURCE MODIFICATION 36 CODING
GUIDELINES &* 37 KEEPING YOUR BITKEEPER REPOSITORY UP TO DATE 39
SUBMITTING A PATCH 40 VII 3. CORE CLASSES, STRUCTURES, VARIABLES, AND
APIS 41 THD 41 NET 46 TABLE 48 FIELD 51 UTILITY API CALLS 54
PREPROCESSOR MACROS 57 GLOBAL VARIABLES 59 4. CLIENT/SERVER
COMMUNICATION 62 PROTOCOL OVERVIEW 62 PACKET FORMAT 62 RELATIONSHIP
BETWEEN MYSQL PROTOCOL AND OS LAYER 63 AUTHENTICATING HANDSHAKE 64
COMMAND PACKET 69 SERVER RESPONSES 74 5. CONFIGURATION VARIABLES 80
CONFIGURATION VARIABLES TUTORIAL 80 INTERESTING ASPECTS OF SPECIFIC
CONFIGURATION VARIABLES 88 6. THREAD-BASED REQUEST HANDLING 107 THREADS
VERSUS PROCESSES . 107 IMPLEMENTATION OF REQUEST HANDLING 109 THREAD
PROGRAMMING ISSUES 113 7. THE STORAGE ENGINE INTERFACE 119 THE HANDLER
CLASS 120 ADDING A CUSTOM STORAGE ENGINE TO MYSQL 136 8. CONCURRENT
ACCESS AND LOCKING 161 TABLE LOCK MANAGER 162 9. PARSER AND OPTIMIZER
167 PARSER 167 OPTIMIZER 170 VIII | TABLE OF CONTENTS 10. STORAGE
ENGINES 194 SHARED ASPECTS OF ARCHITECTURE 195 INNODB 202 MEMORY (HEAP)
204 MYLSAM MERGE 205 NDB 205 ARCHIVE 206 FEDERATED 207 11. TRANSACTIONS
208 OVERVIEW OF TRANSACTIONAL STORAGE ENGINE IMPLEMENTATION 208
IMPLEMENTING THE HANDLER SUBCLASS 209 DEFINING THE HANDLERTON 212
WORKING WITH THE QUERY CACHE 213 WORKING WITH THE REPLICATION BINARY LOG
214 AVOIDING DEADLOCKS 214 12. REPLICATION 216 OVERVIEW 216
STATEMENT-BASED VERSUS ROW-BASED REPLICATION 217 TWO-THREADED SLAVE 218
MULTI-MASTER 219 SQL COMMANDS TOJHELP UNDERSTAND REPLICATION 220 BINARY
LOG FORMAT 223 CREATING A CUSTOM REPLICATION UTILITY 227 INDEX 229 TABLE
OF CONTENTS | IX
|
| adam_txt |
UNDERSTANDING MYSQL INTERNALS SASHA PACHEV O'REILLY 1 BEIJING *
CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI * TOKYO TABLE
OF CONTENTS PREFACE XI 1. MYSQL HISTORY AND ARCHITECTURE 1 MYSQL HISTORY
1 MYSQL ARCHITECTURE 4 2. NUTS AND BOLTS OF WORKING WITH THE MYSQL
SOURCE CODE 19 UNIX SHELL 19 BITKEEPER 19 PREPARING THE SYSTEM TO BUILD
MYSQL FROM BITKEEPER TREE 22 BUILDING MYSQL FROM BITKEEPER TREE 24
BUILDING FROM SOURCE DISTRIBUTION 25 INSTALLING MYSQL INTO A SYSTEM
DIRECTORY 26 SOURCE CODE DIRECTORY LAYOUT . 27 PREPARING THE SYSTEM TO
RUN MYSQL IN A DEBUGGER 28 DEBUGGER-GUIDED SOURCE TOUR 29 BASICS OF
WORKING WITH GDB 30 FINDING THINGS IN THE SOURCE 33 INTERESTING
BREAKPOINTS AND VARIABLES 34 MAKING A SOURCE MODIFICATION 36 CODING
GUIDELINES &* 37 KEEPING YOUR BITKEEPER REPOSITORY UP TO DATE 39
SUBMITTING A PATCH 40 VII 3. CORE CLASSES, STRUCTURES, VARIABLES, AND
APIS 41 THD 41 NET 46 TABLE 48 FIELD 51 UTILITY API CALLS 54
PREPROCESSOR MACROS 57 GLOBAL VARIABLES 59 4. CLIENT/SERVER
COMMUNICATION 62 PROTOCOL OVERVIEW 62 PACKET FORMAT 62 RELATIONSHIP
BETWEEN MYSQL PROTOCOL AND OS LAYER 63 AUTHENTICATING HANDSHAKE 64
COMMAND PACKET 69 SERVER RESPONSES 74 5. CONFIGURATION VARIABLES 80
CONFIGURATION VARIABLES TUTORIAL 80 INTERESTING ASPECTS OF SPECIFIC
CONFIGURATION VARIABLES 88 6. THREAD-BASED REQUEST HANDLING 107 THREADS
VERSUS PROCESSES . 107 IMPLEMENTATION OF REQUEST HANDLING 109 THREAD
PROGRAMMING ISSUES 113 7. THE STORAGE ENGINE INTERFACE 119 THE HANDLER
CLASS 120 ADDING A CUSTOM STORAGE ENGINE TO MYSQL 136 8. CONCURRENT
ACCESS AND LOCKING 161 TABLE LOCK MANAGER 162 9. PARSER AND OPTIMIZER
167 PARSER 167 OPTIMIZER 170 VIII | TABLE OF CONTENTS 10. STORAGE
ENGINES 194 SHARED ASPECTS OF ARCHITECTURE 195 INNODB 202 MEMORY (HEAP)
204 MYLSAM MERGE 205 NDB 205 ARCHIVE 206 FEDERATED 207 11. TRANSACTIONS
208 OVERVIEW OF TRANSACTIONAL STORAGE ENGINE IMPLEMENTATION 208
IMPLEMENTING THE HANDLER SUBCLASS 209 DEFINING THE HANDLERTON 212
WORKING WITH THE QUERY CACHE 213 WORKING WITH THE REPLICATION BINARY LOG
214 AVOIDING DEADLOCKS 214 12. REPLICATION 216 OVERVIEW 216
STATEMENT-BASED VERSUS ROW-BASED REPLICATION 217 TWO-THREADED SLAVE 218
MULTI-MASTER 219 SQL COMMANDS TOJHELP UNDERSTAND REPLICATION 220 BINARY
LOG FORMAT 223 CREATING A CUSTOM REPLICATION UTILITY 227 INDEX 229 TABLE
OF CONTENTS | IX |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Pachev, Alexander Sasha |
| author_facet | Pachev, Alexander Sasha |
| author_role | aut |
| author_sort | Pachev, Alexander Sasha |
| author_variant | a s p as asp |
| building | Verbundindex |
| bvnumber | BV022948171 |
| ctrlnum | (OCoLC)438844770 (DE-599)BVBBV022948171 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01501nam a2200421 c 4500</leader><controlfield tag="001">BV022948171</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20071116 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">071107s2007 d||| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">07,N10,0036</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596009571</subfield><subfield code="c">: EUR 48.00 (freier Pr.)</subfield><subfield code="9">978-0-596-00957-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596009577</subfield><subfield code="c">: EUR 48.00 (freier Pr.)</subfield><subfield code="9">0-596-00957-7</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780596009571</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)438844770</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022948171</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-706</subfield></datafield><datafield tag="080" ind1=" " ind2=" "><subfield code="a">004.43</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7585</subfield><subfield code="2">22</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Pachev, Alexander Sasha</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Understanding MySQL internals</subfield><subfield code="c">Sasha Pachev</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 234 S.</subfield><subfield code="b">graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">MySQL (Electronic resource)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL 5.0</subfield><subfield code="0">(DE-588)4792791-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MySQL 5.0</subfield><subfield code="0">(DE-588)4792791-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch Darmstadt</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016152699&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-016152699</subfield></datafield></record></collection> |
| id | DE-604.BV022948171 |
| illustrated | Illustrated |
| index_date | 2024-07-02T19:00:54Z |
| indexdate | 2024-07-09T21:08:21Z |
| institution | BVB |
| isbn | 9780596009571 0596009577 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-016152699 |
| oclc_num | 438844770 |
| open_access_boolean | |
| owner | DE-706 |
| owner_facet | DE-706 |
| physical | XVII, 234 S. graph. Darst. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Pachev, Alexander Sasha Verfasser aut Understanding MySQL internals Sasha Pachev 1. ed. Beijing [u.a.] O'Reilly 2007 XVII, 234 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier MySQL (Electronic resource) SQL (Langage de programmation) SQL (Computer program language) MySQL 5.0 (DE-588)4792791-4 gnd rswk-swf MySQL 5.0 (DE-588)4792791-4 s DE-604 HEBIS Datenaustausch Darmstadt application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016152699&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Pachev, Alexander Sasha Understanding MySQL internals MySQL (Electronic resource) SQL (Langage de programmation) SQL (Computer program language) MySQL 5.0 (DE-588)4792791-4 gnd |
| subject_GND | (DE-588)4792791-4 |
| title | Understanding MySQL internals |
| title_auth | Understanding MySQL internals |
| title_exact_search | Understanding MySQL internals |
| title_exact_search_txtP | Understanding MySQL internals |
| title_full | Understanding MySQL internals Sasha Pachev |
| title_fullStr | Understanding MySQL internals Sasha Pachev |
| title_full_unstemmed | Understanding MySQL internals Sasha Pachev |
| title_short | Understanding MySQL internals |
| title_sort | understanding mysql internals |
| topic | MySQL (Electronic resource) SQL (Langage de programmation) SQL (Computer program language) MySQL 5.0 (DE-588)4792791-4 gnd |
| topic_facet | MySQL (Electronic resource) SQL (Langage de programmation) SQL (Computer program language) MySQL 5.0 |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=016152699&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT pachevalexandersasha understandingmysqlinternals |