SpirirHost Support Centre: MySQL Reference Manual p.256

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

256 MySQL Technical Reference for Version 4.0.3 Select_range Number of joins where we used ranges on the rst table. (It's normally not critical even if this is big.) Select_scan Number of joins where we did a full scann of the rst table. Select_range_check Number of joins without keys where we check for key usage after each row (If this is 0, you should carefully check the index of your tables). Questions Number of queries sent to the server. Slave_open_temp_tables Number of temporary tables currently open by the slave thread Slave_running Is ON if this is a slave that is connected to a master. Slow_launch_threads Number of threads that have taken more than slow_launch_ time to create. Slow_queries Number of queries that have taken more than long_query_ time. See Section 4.9.5 [Slow query log], page 311. Sort_merge_passes Number of merges passes the sort algoritm have had to do. If this value is large you should consider increasing sort_ buffer. Sort_range Number of sorts that where done with ranges. Sort_rows Number of sorted rows. Sort_scan Number of sorts that where done by scanning the table. ssl_xxx Variables used by SSL; Not yet implemented. Table_locks_immediate Number of times a table lock was acquired immediately. Available after 3.23.33. Table_locks_waited Number of times a table lock could not be acquired imme- diately and a wait was needed. If this is high, and you have performance problems, you should rst optimise your queries, and then either split your table(s) or use replication. Avail- able after 3.23.33. Threads_cached Number of threads in the thread cache. Threads_connected Number of currently open connections. Threads_created Number of threads created to handle connections. Threads_running Number of threads that are not sleeping. Uptime How many seconds the server has been up. Some comments about the above: If Opened_tables is big, then your table_cache variable is probably too small. If Key_reads is big, then your key_buffer_size variable is probably too small. The cache hit rate can be calculated with Key_reads/Key_read_requests. If Handler_read_rnd is big, then you probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. If Threads_created is big, you may want to increase the thread_cache_size variable. The cache hit rate can be calculated with Threads_created/Connections. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size variable to get the temporary tables memory-based instead of disk based. 4.5.6.4 SHOW VARIABLES

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