<div dir="ltr">Yeah, your admins are right, too many tables in the database over time slow down a system, no two ways about it. You have to incrementally grow your server environment anyway, but cleaning out some sites you know no one used is an easy win.<div><br></div><div>Jim</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jun 24, 2015 at 8:27 PM, Grogan, David <span dir="ltr"><<a href="mailto:David.Grogan@tufts.edu" target="_blank">David.Grogan@tufts.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:#1f497d">No worries.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:#1f497d">Jim, did you find a need to do this to improve system performance or other systems tasks like backups?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:"Calibri","sans-serif";color:#1f497d"><br>
Chilli David<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> wp-edu [mailto:<a href="mailto:wp-edu-bounces@lists.automattic.com" target="_blank">wp-edu-bounces@lists.automattic.com</a>]
<b>On Behalf Of </b>Jim Groom<br>
<b>Sent:</b> Wednesday, June 24, 2015 8:25 PM</span></p><div><div class="h5"><br>
<b>To:</b> Low-traffic list discussing WordPress in education.<br>
<b>Subject:</b> Re: [wp-edu] Process for pruning/retiring inactive sites?<u></u><u></u></div></div><p></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Sorry, I meant David, but was thinking of the great Yankee pinch-hitter Chilli Davis.<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Jim<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, Jun 24, 2015 at 8:23 PM, Jim Groom <<a href="mailto:jimgroom@gmail.com" target="_blank">jimgroom@gmail.com</a>> wrote:<u></u><u></u></p>
<div>
<p class="MsoNormal">Davis,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I would even see if you can't find all sites that only have one post, like "Hello World," and delete those sites, so you can still clean out your system, but keep the stuff that folks may want later on. I know there are some scripts for
this we used a year ago or so.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#888888">Jim<u></u><u></u></span></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Wed, Jun 24, 2015 at 8:20 PM, Grogan, David <<a href="mailto:David.Grogan@tufts.edu" target="_blank">David.Grogan@tufts.edu</a>> wrote:<u></u><u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="color:#1f497d">This is good info Joe. According to our sys admin the huge number of tables (as you know WP schema isn’t exactly normalized) starts to cause real issues
with MySQL backups. I’ll ask him to delve a bit deeper into what those issues are.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d">David</span><u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> wp-edu [mailto:<a href="mailto:wp-edu-bounces@lists.automattic.com" target="_blank">wp-edu-bounces@lists.automattic.com</a>]
<b>On Behalf Of </b>Joseph Ugoretz<br>
<b>Sent:</b> Wednesday, June 24, 2015 8:10 PM<br>
<b>To:</b> Low-traffic list discussing WordPress in education.<br>
<b>Subject:</b> Re: [wp-edu] Process for pruning/retiring inactive sites?</span><u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">We've found that students will sometimes return to a site and pick it up again even after several years of inactivity. We want to make sure never to preclude that possibility, so
we don't prune old or inactive sites at all. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">I don't think I could trust any automated system, and I certainly don't want that manual drudgery. And I don't want a student to ever find that her work, no matter how preliminary
and initial, has disappeared--or even give her the impression that she needs to tidy it up or make it disappear. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Is it really that big a drag on the system to have some inactive sites? (We are up to over 4,000 sites now, and probably only 50-60% are "active"--depending on your definition).
Enough to justify the time consuming drudgery? Why not just let them remain?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Joe<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"> <u></u><u></u></p>
<div>
<p class="MsoNormal">-- <br>
Joseph Ugoretz, PhD<u></u><u></u></p>
</div>
<p class="MsoNormal">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
35 West 67th St.<br>
New York, New York 10023<br>
<a href="tel://212-729-2920" target="_blank">212-729-2920</a><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
On Jun 24, 2015, at 7:29 PM, Grogan, David <<a href="mailto:David.Grogan@tufts.edu" target="_blank">David.Grogan@tufts.edu</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Hello all,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">What process do you have in place to clean up your WP instance of old and inactive sites? Every summer we look at this and go through a process of manual identification (e.g. sites
not updated in past 6 months) and go about trying to contact site admins for permission to delete. It’s time consuming and drudgery.
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">David<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">--------------------------------------------------------------<u></u><u></u></p>
<p class="MsoNormal">David Grogan<u></u><u></u></p>
<p class="MsoNormal">Senior Solutions Specialist<u></u><u></u></p>
<p class="MsoNormal">Educational Technology Services (ETS) Tufts Technology Services (TTS) Tufts University<u></u><u></u></p>
<p class="MsoNormal">108 Bromfield Rd<u></u><u></u></p>
<p class="MsoNormal">Somerville, MA 02144<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Phone:
<a href="tel:617.627.2859" target="_blank">617.627.2859</a><u></u><u></u></p>
<p class="MsoNormal">Fax:
<a href="tel:617.627.3082" target="_blank">617.627.3082</a><u></u><u></u></p>
<p class="MsoNormal"><a href="http://it.tufts.edu/ests" target="_blank">http://it.tufts.edu/ests</a><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><u></u><u></u></p>
</div>
</blockquote>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
<br></blockquote></div><br></div>