RSS Forums RSS
Please support our DaniWeb Community Feedback advertiser: Programming Forums

Daniweb link history - apparent error

Join Date: Feb 2002
Location: Lawn Guylen, NY
Posts: 11,073
Reputation: cscgal is just really nice cscgal is just really nice cscgal is just really nice cscgal is just really nice cscgal is just really nice 
Rep Power: 33
Solved Threads: 118
Admin
Staff Writer
cscgal's Avatar
cscgal cscgal is online now Online
The Queen of DaniWeb

Re: Daniweb link history - apparent error

  #4  
Aug 16th, 2007
The table in the database which stores which of the latest threads have been read has recently been changed to a HEAP memory structure, which means that it's now completely stored in RAM. This was done because, as you can imagine, the table gets written to every time a member views a thread, so there is a speed improvement there, as the old MyISAM table format succumbs to table locking (meaning the entire table locks up when it's being changed, so multiple writes must wait in line).

However, I believe that the database server was restarted once or twice over the past couple of days, and when that happens, all of its HEAP tables get wiped out.

Let's gie it a couple more days as I'm not sure if the problem is the HEAP structure to begin with, or if it's restarting the db that caused the problems.
Dani the Computer Science Gal
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 11:28 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC