List:Falcon Storage Engine« Previous MessageNext Message »
From:Christopher Powers Date:January 29 2009 10:54pm
Subject:TABLE OPTIMIZE
View as plain text  
Hi again. New issue.

TABLE OPTIMIZE refreshes the record and index cardinality for a table. 
Record cardinality is determined by fetching every record in the table. 
Each fetch loads a record into the record cache, where it remains 
unscavengeable (useCount > 1) until the transaction completes.

Any reason not to release each record after it has been fetched and counted?

Chris
Thread
TABLE OPTIMIZEChristopher Powers29 Jan
  • RE: TABLE OPTIMIZEVladislav Vaintroub30 Jan
    • Re: TABLE OPTIMIZEChristopher Powers30 Jan
      • RE: TABLE OPTIMIZEVladislav Vaintroub30 Jan