万本电子书0元读

万本电子书0元读

顶部广告

Instant InnoDB电子书

售       价:¥

45人正在读 | 0人评论 9.8

作       者:Matt Reid

出  版  社:Packt Publishing

出版时间:2013-02-01

字       数:73.3万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
This book is a complete reference guide, designed to provide you with answers and solutions to all the common problems you encounter within InnoDB, helping you achieve higher performance and greater stability in your InnoDB databases. The "InnoDB Quick Reference Guide" features content for all skill levels of MySQL administrators, developers, and engineers.
目录展开

Instant InnoDB

Table of Contents

Instant InnoDB

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

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. Getting Started with InnoDB

Basic features of InnoDB

Referential integrity

Multiversion concurrency control

Transaction isolation

ACID compliance

Locking characteristics

System requirements and supported platforms

Downloading MySQL with InnoDB

Installing MySQL with InnoDB support

Verifying InnoDB support and transaction settings

Atomicity

Consistency

Isolation

Durability

Setting the transaction isolation level for InnoDB

Creating your first InnoDB table

Summary

2. Basic Configuration Parameters

MySQL memory allocation equations

InnoDB memory and data file configuration

Static variables

innodb_data_home_dir

innodb_data_file_path

innodb_log_group_home_dir

innodb_log_file_size

innodb_log_buffer_size

innodb_log_files_in_group

innodb_buffer_pool_size

innodb_status_file

transaction-isolation

skip-innodb

Summary

3. Advanced Configuration Parameters

InnoDB and input/output resources

SysBench

Fio

Bonnie++

Disk speed: standard IOPS

InnoDB variables

Dynamic InnoDB variables

innodb_table_locks

innodb_flush_log_at_trx_commit

innodb_io_capacity

innodb_thread_concurrency

innodb_commit_concurrency

innodb_support_xa

innodb_fast_shutdown

Static InnoDB variables

innodb_file_per_table

innodb_additional_mem_pool_size

innodb_buffer_pool_instances

innodb_write_io_threads

innodb_read_io_threads

skip-innodb-doublewrite

Summary

4. Load Testing InnoDB for Performance

Open source system monitoring tools

Open source MySQL load testing applications

Log replay

SysBench

Quadrant framework

OLTPbenchmark

MySQL Benchmark Suite

MySQLslap

Filesystem benchmarking

hdparm

Bonnie++

Fio

InnoDB Flush methods

InnoDB Flush method comparison chart

Thread concurrency testing

Advisory on transaction-isolation level

Summary

5. Maintenance and Monitoring

Maintenance procedures

Adding and resizing InnoDB log files

Adding tablespaces to InnoDB

Utilizing RAW tablespaces

Monitoring InnoDB

Monitoring via show table status

Querying INFORMATION_SCHEMA

Global status and global variables

Third-party resources for trending and visualization

Equations for analyzing InnoDB statistics

Summary

6. Troubleshooting InnoDB

Troubleshooting system issues

InnoDB system crashes

Using InnoDB crash recovery modes

Enabling InnoDB recovery modes

Utilizing InnoDB status statistics

Troubleshooting InnoDB performance

I/O resources

Table-space and logging

Memory resources

Concurrency settings

Global status variables – trending statistics

InnoDB performance status variables

InnoDB pending operation status variables

Get to grips with InnoDB error codes

1005 (ER_CANT_CREATE_TABLE)

1016 (ER_CANT_OPEN_FILE)

1114 (ER_RECORD_FILE_FULL)

1205 (ER_LOCK_WAIT_TIMEOUT)

1206 (ER_LOCK_TABLE_FULL)

1213 (ER_LOCK_DEADLOCK)

1216 (ER_NO_REFERENCED_ROW)

1217 (ER_ROW_IS_REFERENCED)

InnoDB troubleshooting and backup applications

Summary

7. References and Links

General documentation

Reference books

Terminology

InnoDB tuning references

Index

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部