Author: KnickerBlogger

So the site went down today, and my uptime tool didn’t catch it. I also had a hard time getting everything back up.

The root cause is … lack of hard drive space. Now I know the issue I’ll work on sorting it out, although the timing couldn’t be any worse.

Also WordPress wants to update as well. The site might go down for short bursts, but I should be able to get it stable.

It was an odd game, as a Knicks starting forward was benched due to ineffectiveness, just not the one you thought it would be. R.J. scored 26 points on 18 shots, while Randle struggled with just 7 on 10 and sat for much of the 4th quarter. The Knicks blew a 9 point half time lead early in the second half, but came through strong at the end. Even though Brunson led the team with 29 points on 22 shots, it felt as if it were a team effort. Mitch had 7 offensive rebounds and chipped in 12 points. Hart had 19 points on 16 shots, pulled down 7 rebounds, and added 2 steals.

Randle only played 27 minutes, and Toppin saw the floor for the fourth quarter and ended up with 20 minutes played, and hauled in 8 boards, 5 on the offensive end.

The NBA broadcasted a stat that said teams up 3-1 win the series 95% of the time, so fingers crossed that we’re not that 1 in 20 outlier.

[Edited because somehow in my haste I looked at the wrong box score.]

I said it!

No Embid, no Harden, and after 12 minutes, no Mitch. And the Knicks-Sixers went down to the wire, 106-104 New York. Going into the 4th quarter, Toppin had just 4 points. And then Obi broke out with 13 points in the final frame, powered by 3 treys and a pair of dunks.

Toppin’s play wasn’t the only surprise. The Knicks started Grimes, and Reddish saw significant minutes. I’m not a Cam fan, but if New York is going to go down, they might as well give me something fun to watch. And seeing the kids run around is just [kisses fingers].

Probably a good time to test out the polling function…

So the site seemed to be working very smoothly. I started with a fresh database, so everything was lost. The restore I attempted only restored posts/comments up to 2010. So I started running SQL queries to restore the lost posts. At some point I got a majority of them back.

But then I noticed the site loading very slowly. I watched the sql process eat up the server resources.

Unfortunately I’ve come to the conclusion that the data in the database is just too large storing all the data. There’s 15 years of posts an comments in there, and it’s choking the site.

Hence, I’m going to remove older from the database. I’ll keep only the X most recent years, which at this time will be 10 years. If that stabilizes the site, I can keep them. Otherwise I’ll keep reducing it by a year, until I find a sweet spot.

My thinking right now is this: Keeping the site running smoothly so that people can read/post is more important than the old stuff. I still have the old database, so theoretically I can do something with it. Perhaps make some static pages. But that’ll be a future project.

Fingers still twisted…

OK I’ve opened up site registration, and the ability to comment. Feel free to give both a try.

Note: You’ll have to verify your account by email. Check your email spam, because that’s where mine went. If you ever published an article, you might already have an account & may have to reset the password.

I’ll try to check in regularly during the day & there’s still a ton to do on the back-end. Fingers still in a know.

Hey everyone. I know you’re all excited to talk about the Cavs new guard, but I need a little more time to get the site up. I tried my best to get it all up today, but it’s not happening.

In all likelihood everyone might have to create new accounts, and hopefully it should be up some time tomorrow.

Fingers still crossed.

Wow, so this is weird, huh?

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!