Skip Navigation Links
Home
Forum Home
Latest 50
Unanswered
All Time Leaders
Jump to CategoryExpand Jump to Category
Login 
    Welcome Guest!
 Search Forum For :  
X
 Login
Please login to submit a new post, reply and edit exiting posts, see user profiles, and access more features. If you are not a registered member, Register here.
User Id / Email:
Password:  
Forgot Password | Forgot UserName
   Home » MySQL » dirty page and dirty report
       
Author Reply
Mike Starc
posted 65 posts
since Dec 05, 2011 
from

 dirty page and dirty report
  Posted on: 15 Feb 2012       
Please give some information about dirty page and dirty report?
Thanks.
Sponsored by
Alviro Dan
posted  54 posts
since  Dec 05, 2011 
from 

 Re: dirty page and dirty report
  Posted on: 18 Feb 2012   Accepted Answer     0  
Here is the difference:
Dirty Pages: Data that has been modified and Stored in the buffer cache and has not yet been written in to the hard disk. (Transaction Logs)

Dirty reads: Reading the data that is actually read by Transaction2 which was modified by Transaction 1 and Transaction1 was not yet committed and above that, if Transaction 1 is rolled back then transaction2 has read data that never was modified or exists... This is dirty read.
Mike Starc
posted  65 posts
since  Dec 05, 2011 
from 

 Re: dirty page and dirty report
  Posted on: 19 Feb 2012        0  
Great explanation.
Thanks
       

 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Site Map  |  Advertise with us
Current Version: 5.2011.3.12
 © 1999 - 2012  Mindcracker LLC. All Rights Reserved