SpirirHost Support Centre: MySQL Reference Manual p.312

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

312 MySQL Technical Reference for Version 4.0.3 4.9.6 Log File Maintenance MySQL has a lot of log les which make it easy to see what is going. See Section 4.9 [Log Files], page 308. One must however from time to time clean up after MysQL to ensure that the logs don't take up too much disk space. When using MySQL with log les, you will, from time to time, want to remove/backup old log les and tell MySQL to start logging on new les. See Section 4.4.1 [Backup], page 227. On a Linux (Redhat) installation, you can use the mysql-log-rotate script for this. If you installed MySQL from an RPM distribution, the script should have been installed automat- ically. Note that you should be careful with this if you are using the log for replication! On other systems you must install a short script yourself that you start from cron to handle log les. You can force MySQL to start using new log les by using mysqladmin flush-logs or by using the SQL command FLUSH LOGS. If you are using MySQL Version 3.21 you must use mysqladmin refresh. The above command does the following: If standard logging (--log) or slow query logging (--log-slow-queries) is used, closes and reopens the log le (`mysql.log' and ``hostname`-slow.log' as default). If update logging (--log-update) is used, closes the update log and opens a new log le with a higher sequence number. If you are using only an update log, you only have to ush the logs and then move away the old update log les to a backup. If you are using the normal logging, you can do something like: shell> cd mysql-data-directory shell> mv mysql.log mysql.old shell> mysqladmin flush-logs and then take a backup and remove `mysql.old'. 4.10 Replication in MySQL This section describes the various replication features in MySQL. It serves as a reference to the options available with replication. You will be introduced to replication and learn how to implement it. Toward the end, there are some frequently asked questions and descriptions of problems and how to solve them. We suggest that you visit our website at http://www.mysql.com/ often and read updates to this section. Replication is constantly being improved, and we update the manual frequently with the most current information. 4.10.1 Introduction One way replication can be used is to increase both robustness and speed. For robustness you can have two systems and can switch to the backup if you have problems with the

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide