[Home]  [Headlines]  [Latest Articles]  [Latest Comments]  [Post]  [Sign-in]  [Mail]  [Setup]  [Help] 

Status: Not Logged In; Sign In

Opioids More Likely To Kill Than Car Crashes Or Suicide

The association between COVID-19 “vaccines” and cognitive decline

Democrats Sink to Near Zero in New Gallup Poll, Theyre Just Not Satisfied

She Couldn't Read Her Own Diploma: Why Public Schools Pass Students but Fail Society

Peter Schiff: Gold To $6,000 Next Year, Dollar Index To 70

Russia Just Admitted Exactly What Everyone – But Trump – Already Knew About Putin's Ukraine Plans

Sex Offenses in London by Nationality

Greater Israel Collapses: Iran the Next Target

Before Jeffrey Epstein: The FINDERS

Cyprus: The Israeli Flood Has Become A Deluge

Israel Actually Slaughtered Their Own People On Oct 7th Says Israeli Newspaper w/ Max Blumenthal

UK Council Offers Emotional Support To Staff "Discomforted" By Seeing The National Flag

Inside the Underground City Where 700 Trucks Come and Go Every Day

Fentanyl Involved In 70% Of US Drug Overdose Deaths

Iran's New Missiles. Short Version

Obama Can't Bear This. Kash Patel Exposes Dead Chef Revelation. Obama’s Legacy DESTROYED!

Triple-Digit Silver Imminent? Critical Mineral, Backwardation & Remonetization | Mike Maloney

Israel Sees Sykes-Picot Borders As 'Meaningless' & 'Will Go Where They Want': Trump Envoy

Bring Back Asylums: It's Time To Talk About Transgender Fatigue In America

German Political Parties (Ex-AfD) Sign 'Fairness Pact' That Prevents Criticizing Immigration

CARVING .45 CALIBER AUTOMATICS OUT OF STEEL WWII UNION SWITCH AND SIGNAL MOVIE

This surprising diabetes link could protect your brain

Putin and Xi to lay foundations for a new world order in Beijing

Cancer Natural Solutions Q&R

Is ANYONE buying this anymore? (Netanyahu)

Mt Etna in Sicily Eupting

These Soviet 4x4 Sedans Are Cooler Than You Think!

SSRIs and School Shootings, FDA Corruption, and Why Everyone on Anti-Depressants Is Totally Unhappy

St. Louis Man Who Gunned Down Police Officer Demond Taylor Is Released on $5,000 Bond

How Israeli spy veterans are shaping US big tech


Miscellaneous
See other Miscellaneous Articles

Title: Server upgrade
Source: [None]
URL Source: [None]
Published: Sep 5, 2010
Author: Neil
Post Date: 2010-09-05 15:30:44 by Pinguinite
Ping List: *4um Admin News*     Subscribe to *4um Admin News*
Keywords: None
Views: 452
Comments: 16

I'm conducting a server upgrade shortly. I don't expect any noticable outage, as these have gone smoothly in the past, but just in case.... Subscribe to *4um Admin News*

Post Comment   Private Reply   Ignore Thread  


TopPage UpFull ThreadPage DownBottom/Latest

Begin Trace Mode for Comment # 6.

#5. To: All, *4um Admin News* (#0)

Just upgraded the server OS again. This will be the last for quite a while. Next I'm going to revisit the DB cleaning program which didn't go right last time and gave 4um an outage hour or two. Maybe this time I'll place the dynamite more carefully.

Pinguinite  posted on  2010-09-12   3:20:56 ET  Reply   Untrace   Trace   Private Reply  


#6. To: Pinguinite (#5)

Next I'm going to revisit the DB cleaning program which didn't go right last time and gave 4um an outage hour or two. Maybe this time I'll place the dynamite more carefully.

Does the DB cleaning program erase discussions or archive them?

GreyLmist  posted on  2010-09-13   9:59:55 ET  Reply   Untrace   Trace   Private Reply  


Replies to Comment # 6.

#7. To: GreyLmist (#6)

Does the DB cleaning program erase discussions or archive them?

Neither. It gets rid of all the obscenities and foul, over the top insults that sometimes gets posted here.

Just kidding.

But it is neither, actually. The DB can slowly accumulate defects as time goes by. These are defects that in small numbers don't cause any problem as the whole mysql setup is rather robust and can work around them. But in a large DB, the defects can reach a point where the server starts to struggle to keep up. That's happened a few times and the result is essentially a server crash. So a regular DB scan and fix can repair those defects and avoid those outages.

It's interesting that mysql can work with these defects and still retain 100% data accuracy. Perhaps later versions of the server software will have this type of DB repair operations done constantly.

Pinguinite  posted on  2010-09-13 17:52:43 ET  Reply   Untrace   Trace   Private Reply  


End Trace Mode for Comment # 6.

TopPage UpFull ThreadPage DownBottom/Latest


[Home]  [Headlines]  [Latest Articles]  [Latest Comments]  [Post]  [Sign-in]  [Mail]  [Setup]  [Help]