MySQL Admin Cookbook 1st Edition by Schneller Daniel, Schwedt Udo ISBN 1847197965 978-1847197962

MySQL Admin Cookbook 1st Edition by Schneller Daniel, Schwedt Udo – Ebook PDF Instant Download/Delivery: 1847197965, 978-1847197962

Full download MySQL Admin Cookbook 1st Edition after payment

 

Product details:

ISBN 10: 1847197965 

ISBN 13: 978-1847197962

Author: Schneller Daniel, Schwedt Udo

 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 widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.

Table of contents: 

1. Monitoring and Analyzing a MySQL Installation

1. Introduction

2. Checking free InnoDB tablespace

3. Establishing alerting mechanisms for low remaining tablespace by using triggers

4. Enabling the MySQL scheduler

5. Improving configuration

6. Estimating tablespace requirements

7. Identifying and changing MySQL variables

8. Displaying more than one named variable at a time

9. Displaying global settings

10. Assessing the overall table count

11. Finding the biggest tables

12. Finding all columns with a certain name and/or type

13. Finding all tables referencing each other

2. Configuring MySQL

1. Introduction

2. Setting up a fixed InnoDB tablespace

3. Setting up an auto-extending InnoDB tablespace

4. Making an existing tablespace auto-extensible

5. Controlling the steps of tablespace extension

6. Limiting the size of an auto-extending tablespace

7. Adding a new auto-extending data file

8. Storing InnoDB data in one file per table

9. Decreasing InnoDB tablespace

10. Enabling and configuring binary logging

11. Configuring the InnoDB redo log

12. Understanding and configuring important MySQL and InnoDB timeout options

13. Setting values for innodb_rollback_on_timeout / innodb_lock_wait_timeout

14. Setting values for interactive_timeout / wait_timeout

15. Setting values for net_read_timeout / net_write_timeout

16. Adjusting table and database name letter case handling for better platform independence

17. Installing MySQL as a Windows service with custom options

18. Running multiple MySQL server instances in parallel on a Linux server

19. Turning off AppArmor / SELinux for Linux distributions

20. Considering the alternative MySQL Sandbox project

21. Preventing invalid date values from being stored in DATE or DATETIME columns

22. Configuring SQL mode for the current session only

3. MySQL User Management

1. Introduction

2. Configuring MySQL Administrator to display global privileges and hosts

3. Defining an alternative user for administrative tasks

4. Disabling the default accounts

5. Creating a basic user

6. Creating an installation user

7. Creating the account without using MySQL Administrator

8. Permitting management of user rights

9. Creating a read-only account

10. Allowing stored procedure calls

11. Defining a specific user for backup

12. Defining a specific user for replication

13. Allowing access from specific hosts only

14. Creating the account without using MySQL Administrator

15. Allowing access from a group of hosts

16. Regaining access to your database in case of lost account information

17. Avoiding plain text passwords in administrative scripts

People also search for:

 mysql admin console
mysql cookbook chef
mysql admin client
mysql admin account
mysql admin gui

Tags: Schneller Daniel, Schwedt Udo, MySQL Admin Cookbook