{"product_id":"pro-mysql-9781590595053","title":"Pro MySQL","description":"\u003cp\u003e\u003ci\u003ePro MySQL\u003c\/i\u003e is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.\u003c\/p\u003e\u003cp\u003eThe first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examplesfrom dealing with hierarchical data to performing geographic information system (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.\u003c\/p\u003e\u003cp\u003eThe latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Apress\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/27\/2005\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9781590595053\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 768\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 2.86lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.32h x 7.29w x 1.78d\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003eReview Citations: \u003c\/strong\u003e\u003ci\u003eScitech Book News\u003c\/i\u003e 12\/01\/2006 pg. 21\u003cbr\u003e","brand":"Jay Pipes, Michael Kruckenberg","offers":[{"title":"Default Title","offer_id":41574019858613,"sku":"9781590595053","price":50.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/products\/img_6ab50aa8-8ab6-42e8-84ba-824ebc7e39ff.jpg?v=1643688347","url":"https:\/\/pastforward.org\/products\/pro-mysql-9781590595053","provider":"Past Forward","version":"1.0","type":"link"}