Chapter 10: Basic Administration - Mastering MySQL 4 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا

➟

جستجو در لغت نامه

بیشتر

کتابخانه شخصی پرسش از کتابدار ارسال منبع

Mastering MySQL 4 [Electronic resources] - نسخه متنی

Ian Gilfillan

| ،

افزودن به کتابخانه شخصی

میخواهم بخوانم

درحال خواندن

خوانده شده

ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال

جستجو در متن کتاب

بیشتر

تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب

➟

جستجو در لغت نامه

بیشتر

لیست موضوعات

Sitemap

Mastering MySQL 4

What Not to Expect from This Book

What Do You Need?

How to Use This Book

How to Contact the Author

Part I: Using MySQL

Chapter 1: Quickstart to MySQL

Understanding MySQL Basics

Connecting to the MySQL Server

Creating and Using Your First Database

Chapter 2: Data Types and Table Types

Exploring the Various Column Types

Exploring the Various Table Types

Chapter 3: Advanced SQL

Adding Records to a Table from Other Tables with INSERT SELECT

More about Adding Records

More about Removing Records (DELETE and TRUNCATE)

Running SQL Statements Stored in files

Transactions and Locking

Chapter 4: Indexes and Query Optimization

Understanding Indexes

Creating an Index

Using an Auto Increment Field

Dropping or Changing an Index

Understanding Table Types and Indexes

Using Indexes Effectively

Analyzing How MySQL Uses Indexes with EXPLAIN

Optimizing Selects

Optimizing Updates, Deletes, and Inserts

Chapter 5: Programming with MySQL

Using Good Database Programming Techniques

The Stages of Application Development

Chapter 6: Extending MySQL

User-Defined Functions

Troubleshooting the UDF

Part II: Designing a Database

Chapter 7: Understanding Relational Databases

Exploring Early Database Models

Understanding the Relational Database Model

Chapter 8: Database Normalization

Understanding Normalization

Understanding Denormalization

Chapter 9: Database Design

The Database Lifecycle

Real-World Example: Creating a Publishing Tracking System

Concurrency Control with Transactions

Part III: MySQL Administration

Chapter 10: Basic Administration

Meeting MySQL as an Administrator

Starting and Shutting Down MySQL

Configuring MySQL

Optimizing, Analyzing, Checking, and Repairing Tables

Chapter 11: Database Backups

Backing Up MyISAM Tables with BACKUP

Restoring MyISAM Tables with RESTORE

Backing Up MyISAM Tables by Directly Copying the files

Backing Up with mysqldump

Backing Up with SELECT INTO

Using mysqlhotcopy to Back Up

Using the Binary Update Log to Restore a Database to the Most Recent Position

Backing Up and Restoring InnoDB Tables

Replication as a Means of Backup

Chapter 12: Database Replication

Understanding Replication

Setting Up Replication

Replicating One Database

Replicating with an Active Binary Log on the Master

Removing Old Binary Logs from the Master and Then Starting

Avoiding Too Many Updates

Avoiding Key Errors

Chapter 13: Configuring and Optimizing MySQL

Optimizing the mysqld Variables

Changing Variable Values with the Server Running

Improving Hardware to Speed Up the Server

Using Benchmarks

Running MySQL in ANSI Mode

Using Different Languages in MySQL

Chapter 14: Database Security

Security When Connecting

Managing Users and Permissions

SSL Connections

Application Security

System Security

Security Issues with LOAD DATA LOCAL

Chapter 15: Installing MySQL

Deciding Whether to Install a Source or Binary Distribution

Installing MySQL on Windows

Installing MySQL on Unix

Installing Multiple MySQL Servers on the Same Machine

Avoiding Common Installation Problems

Upgrading from MySQL 3.x to MySQL 4

Chapter 16: Multiple Drives

Understanding RAID

Using Symbolic Links

Part A: Appendixes

Appendix A: MySQL Syntax Reference

LOAD DATA INFILE

SET TRANSACTION

Appendix B: MySQL Function and Operator Reference

Arithmetic Operators

Comparison Operators

Date and Time Functions

String Functions

Numeric Functions

Aggregate Functions

Other Functions

Appendix C: PHP API

PHP MySQL Functions

Appendix D: Perl DBI

DBI Class Methods

DBI Methods Common to All Handles

DBI Utility Functions

Database Handle Methods

Statement Handle Methods

DBI Attributes Common to All Handles

Database Handle Attributes

Statement Handle Attributes

Dynamic Attributes

A Short Perl DBI Example

Appendix E: Python Database API

A Short Python Example

Appendix F: Java API

General Methods

Connection Methods

Statement and Prepared Statement Methods

ResultSet Methods

ResultSetMetaData Methods

SQLException Methods

Warning Methods

A Short Java Example

Appendix G: C API

C API Functions

A Short C API Example

Appendix H: ODBC and .NET

Understanding Data Sources

Exporting Data from Microsoft Access to MySQL

MyODBC Functions

List of Figures

List of Listings

List of Sidebars

توضیحات

افزودن یادداشت جدید

Chapter 10: Basic Administration

Overview

Although MySQL is easy to maintain and administer, it does not look after itself. This chapter covers the basic administrative tasks, some of which are covered in more detail in the following chapters. Specifically, you'll learn how to start and stop the server, both manually and automatically. You'll also get to know some of the indispensable tools for a MySQL administrator, learn how to use logs, and how to configure MySQL.

Featured in this chapter:

The MySQL utilities

Starting and shutting down MySQL

Starting mysqld automatically upon booting up

Configuring MySQL

Logging

Rotating logs

Optimizing, checking, analyzing, and repairing tables