Chapter 13. Administering Starting Up and Shutting Getting Information Abou Setting Variables
Killing Threads Clearing Caches 1Z0-517 Understanding the Log Fi
Chapter 14. Backup and Di Backing Up and Restoring Testing Your Backup Checking and Repairing T
Chapter 15. Securing Your How the Privilege System Securing Accounts
Securing Your Installation
Filtering User Data
Chapter 16. Replicating Yo
Setting Up and Configurin
Advanced Topologies Replication Future Summary Quiz
Part VI: Optimizing MySQL Chapter 17. Optimizing Yo Compiling and Linking for
Tuning Server Parameters
Tuning Other Factors
Chapter 18. Optimizing Yo What¡¯s Slow in MySQL Da Making the Right Design
Indexing for Optimization ANALYZE TABLE
Using OPTIMIZE TABLE
Chapter 19. Optimizing Yo Finding Slow Queries Benchmarking Your Queri
Using the Slow Query Log Using EXPLAIN to See Ho Understanding MySQL¡¯s B
Quiz Exercises Answers Index
Copyright . 2004 by Sams Publishing
All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.
Library of Congress Catalog Card Number: 2003092540
Printed in the United States of America
First Printing: December 2003
06 05 04 03 4 3 2 1
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.
MySQL and the MySQL logo are trademarks or registered trademarks of MySQL AB and are used here by permission.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an ¡°as is¡± basis. The authors and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.
Pearson offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact
Senior Project Editor
J. Scott Johnson Chris Newman
Cover & Interior Designer
This book is dedicated to our families: both 1z0-517 exam questions the human and four-legged members.