SpirirHost Support Centre: MySQL Reference Manual p.265

<< 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 265 The manual section that describes tuning MySQL contains some information of how to tune the above variables. See Section 5.5.2 [Server parameters], page 363. 4.5.6.5 SHOW LOGS SHOW LOGS shows you status information about existing log les. It currently only displays information about Berkeley DB log les. File shows the full path to the log le Type shows the type of the log le (BDB for Berkeley DB log les) Status shows the status of the log le (FREE if the le can be removed, or IN USE if the le is needed by the transaction subsystem) 4.5.6.6 SHOW PROCESSLIST SHOW [FULL] PROCESSLIST shows you which threads are running. You can also get this information using the mysqladmin processlist command. If you have the SUPER privilege, you can see all threads. Otherwise, you can see only your own threads. See Section 4.5.5 [KILL], page 250. If you don't use the FULL option, then only the rst 100 characters of each query will be shown. This command is very useful if you get the 'too many connections' error message and want to nd out what's going on. MySQL reserves one extra connection for a client with the SUPER privilege to ensure that you should always be able to login and check the system (assuming you are not giving this privilege to all your users). Some states commonly seen in mysqladmin processlist Checking table The thread is performing [automatic] checking of the table. Closing tables Means that the thread is ushing the changed table data to disk and closing the used tables. This should be a fast operation. If not, then you should check that you don't have a full disk or that the disk is not in very heavy use. Connect Out Slave connecting to master. Copying to tmp table on disk The temporary result set was larger than tmp_table_ size and the thread is now changing the in memory-based temporary table to a disk based one to save memory. Creating tmp table The thread is creating a temporary table to hold a part of the result for the query. deleting from main table When executing the rst part of a multi-table delete and we are only deleting from the rst table. deleting from reference tables When executing the second part of a multi-table delete and we are deleting the matched rows from the other tables. Flushing tables The thread is executing FLUSH TABLES and is waiting for all threads to close their tables. Killed Someone has sent a kill to the thread and it should abort next time it checks the kill ag. The ag is checked in each major loop in MySQL, but in some cases it

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