SpirirHost Support Centre: MySQL Reference Manual p.297

<< 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

Chapter 4: Database Administration 297 Memory in use Memory allocated directly by the mysqld code (only available when MySQL is compiled with {with- debug=full). Max memory used Maximum memory allocated directly by the mysqld code (only available when MySQL is compiled with {with- debug=full). If you do mysqladmin shutdown on a socket (in other words, on a the computer where mysqld is running), mysqladmin will wait until the MySQL pid-file is removed to ensure that the mysqld server has stopped properly. 4.8.4 Using mysqlcheck for Table Maintenance and Crash Recovery Since MySQL version 3.23.38 you will be able to use a new checking and repairing tool for MyISAM tables. The dierence to myisamchk is that mysqlcheck should be used when the mysqld server is running, where as myisamchk should be used when it is not. The benet is that you no longer have to take the server down for checking or repairing your tables. mysqlcheck uses MySQL server commands CHECK, REPAIR, ANALYZE and OPTIMIZE in a convenient way for the user. There are three alternative ways to invoke mysqlcheck: shell> mysqlcheck [OPTIONS] database [tables] shell> mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...] shell> mysqlcheck [OPTIONS] --all-databases So it can be used in a similar way as mysqldump when it comes to what databases and tables you want to choose. mysqlcheck does have a special feature compared to the other clients; the default behaviour, checking tables (-c), can be changed by renaming the binary. So if you want to have a tool that repairs tables by default, you should just copy mysqlcheck to your harddrive with a new name, mysqlrepair, or alternatively make a symbolic link to mysqlrepair and name the symbolic link as mysqlrepair. If you invoke mysqlrepair now, it will repair tables by default. The names that you can use to change mysqlcheck default behaviour are here: mysqlrepair: The default option will be -r mysqlanalyze: The default option will be -a mysqloptimize: The default option will be -o The options available for mysqlcheck are listed here, please check what your version sup- ports with mysqlcheck --help. -A, --all-databases Check all the databases. This will be same as {databases with all databases selected -1, --all-in-1 Instead of making one query for each table, execute all queries in 1 query separately for each database. Table names will be in a comma separated list.

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