skip to content
MySQL Admin Cookbook LITE Replication and Indexing. Preview this item
ClosePreview this item
Checking...

MySQL Admin Cookbook LITE Replication and Indexing.

Author: Daniel Schneller; Udo Schwedt
Publisher: Birmingham : Packt Pub., 2011.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
This cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Schneller, Daniel.
MySQL Admin Cookbook LITE Replication and Indexing.
Birmingham : Packt Publishing, ©2011
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Daniel Schneller; Udo Schwedt
ISBN: 9781849516136 1849516138
OCLC Number: 796384721
Description: 1 online resource (206 pages)
Contents: MySQL Admin Cookbook: LITE; MySQL Admin Cookbook: LITE; Credits; About the Authors; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Monitoring and Analyzing a MySQL Installation; Introduction; Checking free InnoDB tablespace; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Establishing alerting mechanisms for low remaining tablespace by using triggers; Getting ready; How to do it ... ; How it works ... ; There's more ... Enabling the MySQL schedulerImproving configuration; See also; Estimating tablespace requirements; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Identifying and changing MySQL variables; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Displaying more than one named variable at a time; Displaying global settings; See also; Assessing the overall table count; Getting ready; How to do it ... ; How it works ... ; See also; Finding the biggest tables; Getting ready; How to do it ... ; How it works ... ; See also. Finding all columns with a certain name and/or typeGetting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Finding all tables referencing each other; Getting ready; How to do it ... ; How it works ... ; See also; 2. Configuring MySQL; Introduction; Setting up a fixed InnoDB tablespace; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Setting up an auto-extending InnoDB tablespace; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Making an existing tablespace auto-extensible; Controlling the steps of tablespace extension. Limiting the size of an auto-extending tablespaceAdding a new auto-extending data file; Storing InnoDB data in one file per table; Getting ready; How to do it ... ; How it works ... ; Decreasing InnoDB tablespace; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Enabling and configuring binary logging; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Configuring the InnoDB redo log; Getting ready; How to do it ... ; What just happened ... ; There's more ... ; Understanding and configuring important MySQL and InnoDB timeout options; Getting ready; How to do it ... How it works ... Setting values for innodb_rollback_on_timeout / innodb_lock_wait_timeout; Setting values for interactive_timeout / wait_timeout; Setting values for net_read_timeout / net_write_timeout; Adjusting table and database name letter case handling for better platform independence; Getting ready; How to do it ... ; How it works ... ; See also ... ; Installing MySQL as a Windows service with custom options; Getting started; How to do it ... ; How it works ... ; There's more ... ; Running multiple MySQL server instances in parallel on a Linux server; Getting ready; How to do it ... ; How it works ...

Abstract:

This cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to wid.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/796384721> # MySQL Admin Cookbook LITE Replication and Indexing.
    a schema:Book, schema:MediaObject, schema:CreativeWork ;
    library:oclcnum "796384721" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/2044810194#Place/birmingham> ; # Birmingham
    schema:about <http://experiment.worldcat.org/entity/work/data/2044810194#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:about <http://experiment.worldcat.org/entity/work/data/2044810194#Topic/database_management> ; # Database management
    schema:about <http://dewey.info/class/005.74/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2044810194#Topic/mysql_electronic_resource> ; # MySQL (Electronic resource)
    schema:bookFormat schema:EBook ;
    schema:contributor <http://experiment.worldcat.org/entity/work/data/2044810194#Person/schwedt_udo> ; # Udo Schwedt
    schema:creator <http://experiment.worldcat.org/entity/work/data/2044810194#Person/schneller_daniel> ; # Daniel Schneller
    schema:datePublished "2011" ;
    schema:description "This cookbook presents solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will benefit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to wid."@en ;
    schema:description "MySQL Admin Cookbook: LITE; MySQL Admin Cookbook: LITE; Credits; About the Authors; About the Reviewers; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Monitoring and Analyzing a MySQL Installation; Introduction; Checking free InnoDB tablespace; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Establishing alerting mechanisms for low remaining tablespace by using triggers; Getting ready; How to do it ... ; How it works ... ; There's more ..."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/2044810194> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/2044810194#CreativeWork/mysql_admin_cookbook_lite_replication_and_indexing> ;
    schema:name "MySQL Admin Cookbook LITE Replication and Indexing."@en ;
    schema:productID "796384721" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/796384721#PublicationEvent/birmingham_packt_pub_2011> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/2044810194#Agent/packt_pub> ; # Packt Pub.
    schema:url <http://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=943475> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=943475> ;
    schema:workExample <http://worldcat.org/isbn/9781849516136> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/796384721> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/2044810194#Person/schneller_daniel> # Daniel Schneller
    a schema:Person ;
    schema:familyName "Schneller" ;
    schema:givenName "Daniel" ;
    schema:name "Daniel Schneller" ;
    .

<http://experiment.worldcat.org/entity/work/data/2044810194#Person/schwedt_udo> # Udo Schwedt
    a schema:Person ;
    schema:familyName "Schwedt" ;
    schema:givenName "Udo" ;
    schema:name "Udo Schwedt" ;
    .

<http://experiment.worldcat.org/entity/work/data/2044810194#Topic/database_management> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2044810194#Topic/mysql_electronic_resource> # MySQL (Electronic resource)
    a schema:Intangible ;
    schema:name "MySQL (Electronic resource)"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2044810194#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/entity/work/data/2044810194#CreativeWork/mysql_admin_cookbook_lite_replication_and_indexing>
    a schema:CreativeWork ;
    rdfs:label "MySQL Admin Cookbook LITE Replication and Indexing." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/796384721> ; # MySQL Admin Cookbook LITE Replication and Indexing.
    .

<http://worldcat.org/isbn/9781849516136>
    a schema:ProductModel ;
    schema:isbn "1849516138" ;
    schema:isbn "9781849516136" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.