<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • 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
    250 MySQL Technical Reference for Version 4.0.3 4.5.4  RESET Syntax RESET reset_option [,reset_option] ... The RESET command is used to clear things.  It also acts as an stronger version of the FLUSH command.  See Section 4.5.3 [FLUSH], page 248. To execute RESET, you must have the RELOAD privilege. Option Description MASTER Deletes all binary logs listed in the index le,  resetting the bin- log index le to be empty.  In pre-3.23.26 versions, FLUSH MASTER (Master) SLAVE Makes the slave forget its replication position in the master logs. In pre 3.23.26 versions the command was called FLUSH SLAVE(Slave) QUERY CACHE Removes all query results from the query cache. 4.5.5  KILL Syntax KILL thread_id Each  connection  to  mysqld  runs  in  a  separate  thread.   You  can  see  which  threads  are running with the SHOW PROCESSLIST command and kill a thread with the KILL thread_id command. If you have the PROCESS privilege, you can see all threads.  If you have the SUPER privilege, you can kill all threads.  Otherwise, you can only see and kill your own threads. You can also use the mysqladmin processlist and mysqladmin kill commands to exam- ine and kill threads. When you do a KILL, a thread speci c kill flag is set for the thread. In most cases it may take some time for the thread to die as the kill ag is only checked at speci c intervals.    In  SELECT,  ORDER BY  and  GROUP BY  loops, the ag is checked after reading a block of rows.  If the kill ag is set the statement is aborted    When  doing  an  ALTER TABLE  the  kill   ag  is  checked  before  each  block  of  rows  are read from the original table.  If the kill ag was set the command is aborted and the temporary table is deleted.    When  doing  an  UPDATE TABLE  and  DELETE TABLE,  the  kill   ag  is  checked  after  each block read and after each updated or delete row.  If the kill ag is set the statement is aborted.  Note that if you are not using transactions, the changes will not be rolled back!    GET_LOCK() will abort with NULL.    An INSERT DELAYED thread will quickly ush all rows it has in memory and die.    If the thread is in the table lock handler (state:  Locked), the table lock will be quickly aborted.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN REGISTRATION
    MANAGE YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    SITE MAP
    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