Holdings: Understanding MySQL internals

Understanding MySQL internals:

Saved in:

Bibliographic Details
Main Author:	Pachev, Alexander Sasha (Author)
Format:	Book
Language:	English
Published:	Beijing [u.a.] O'Reilly 2007
Edition:	1. ed.
Subjects:	MySQL (Electronic resource) SQL (Langage de programmation) SQL (Computer program language) MySQL 5.0
Online Access:	Inhaltsverzeichnis
Physical Description:	XVII, 234 S. graph. Darst.
ISBN:	9780596009571 0596009577

Staff View

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

Record in the Search Index

_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

Holdings

There is no print copy available.

Interlibrary loan Place Request Caution: Not in THWS collection! Indexes

MARC

Record in the Search Index

There is no print copy available.

Similar Items