Author Topic: CathInfo online again March 25 (Read 1925 times)

Matthew · « **on:** March 25, 2013, 02:40:46 PM »

I cleared out several databases as usual.

This time, I had to do a bit more.

I now treat Guests and Members differently. From now on, Guests only get 3 posts per page, and 10 topics per page. Members get 5 posts per page and 20 topics per page.

More privileges, more advantages to being a member.

Also, Guests will no longer be able to see the current thumbs up/thumbs down for each post. (They already couldn't upvote/downvote)

So sign up for an account already!

There are SO MANY guests, that any changes I make to their privileges has a great effect on the performance of the site.

Also, I decided to delete many old members that had 0 posts, who hadn't logged on since August 2012.

So if you can't log in anymore, just sign up for a new account. Your old account is either gone, or it will be deleted in a few months when it is sufficiently old and unused.

ServusSpiritusSancti · « **Reply #1 on:** March 25, 2013, 02:51:31 PM »

Glad CI is back up.

Capt McQuigg · « **Reply #2 on:** March 25, 2013, 02:58:07 PM »

Me too!!!!

:ready-to-eat:

RomanCatholic1953 · « **Reply #3 on:** March 25, 2013, 06:20:35 PM »

Smart Move.

Many sign up, and that is the last we hear from them.

Once again, sad that the likes/dislikes have again disappeared.

Neil Obstat · « **Reply #4 on:** March 25, 2013, 08:15:47 PM »

Quote

Members get 5 posts per page and 20 topics per page.

Hooray! This will be great! Wait. We got 5 posts and 20 topics before...

Too bad I kept all my notes in PMs. C'est la vie.

Matthew · « **Reply #5 on:** March 25, 2013, 10:14:21 PM »

I programmed some more performance improvements this evening.

It could be my imagination, but the site seems to be a bit snappier than usual!

I did some special things to the Database to speed things up. I do this professionally, so that helps.

Hopefully the site will be in great shape for many months (at least).

Iuvenalis · « **Reply #6 on:** March 25, 2013, 11:14:36 PM »

You're on a VM no?

Just curious, when this happens, it's CPU not disk I/O? Usually the disk is more a bottleneck for structured data (db)

Is it really block storage? Or is it a db *file* on a filesystem?

Matthew · « **Reply #7 on:** March 25, 2013, 11:36:29 PM »

Quote from: Iuvenalis

You're on a VM no?

Just curious, when this happens, it's CPU not disk I/O? Usually the disk is more a bottleneck for structured data (db)

Is it really block storage? Or is it a db *file* on a filesystem?

It's a MySQL database with a PHP frontend.

My bottleneck is the number of MySQL queries being done. I need to minimize these, or I end up using more than 25% of the server's CPU resources. When that happens, they suspend my account and give me a nice e-mail/phone call.

I'm on a shared hosting account, believe it or not. I'd like to keep it that way.

Graham · « **Reply #8 on:** March 25, 2013, 11:38:07 PM »

I notice that the time limit on consecutive searches has increased to 30 seconds.

Iuvenalis · « **Reply #9 on:** March 25, 2013, 11:46:05 PM »

Quote from: Matthew

My bottleneck is the number of MySQL queries being done. I need to minimize these, or I end up using more than 25% of the server's CPU resources. When that happens, they suspend my account and give me a nice e-mail/phone call.

I'm on a shared hosting account, believe it or not. I'd like to keep it that way.

And stored procedures instead of the actual SQL been tried? (Or too much a pain?)

Matthew · « **Reply #10 on:** March 25, 2013, 11:46:10 PM »

Quote from: Graham

I notice that the time limit on consecutive searches has increased to 30 seconds.

I figure that would only inconvenience most people by 5 or 10 seconds -- that assumes they did a search that really didn't pan out. It usually takes 10 seconds to skim the results.

Furthermore, Guests can no longer perform searches at all.

:sign-surrender:

http://www.cathinfo.com/catholic.php?a=register

ServusSpiritusSancti · « **Reply #11 on:** March 25, 2013, 11:48:00 PM »

Quote from: Matthew

I programmed some more performance improvements this evening.

It could be my imagination, but the site seems to be a bit snappier than usual!

I did some special things to the Database to speed things up. I do this professionally, so that helps.

Hopefully the site will be in great shape for many months (at least).

Yeah, CatholicInfo seems to be running good right now, at least for me.

Thanks, Matthew.

CathMomof7 · « **Reply #12 on:** March 26, 2013, 06:52:41 AM »

I was sooo out of sorts yesterday! I couldn't even get a Cathinfo homepage! I just assumed, Matthew, that you had decided to observe a fast for Holy Week.

AlligatorDicax · « **Reply #13 on:** March 26, 2013, 10:22:44 AM »

Quote from: Matthew (Mar. 26, 2013, 12:36 am)

I need to minimize [....] MySQL queries [....], or I end up using more than 25% of the server's CPU resources. When that happens, they suspend my account and give me a nice e-mail/phone call.

Ouch! Are you slammed by the hosting hammer for mere spikes, or can you rely on some patience being applied? Odd, isn't it, that ads promoting shared-hosting don't ever seem to describe the provider's penalties for exceeding its configured limits on your sharing? I know I hadn't thought about that before.

Quote from: (continued)

I'm on a shared hosting account, believe it or not.

That's actually easier to believe, because that suggests to me that you're being bitten by a weakness of the Apache model for shared hosting, where every site hosted runs as the same 'user', which likely deprives the operating system or server-subsystem of information needed to gracefully throttle the performance of sites, by lowering the execution-priorities of those users or tasks exceeding CPU-usage limits. Or perhaps it's something completely different; I know far less about its & *nix internals than I'd like.

Or perhaps the hosting service-providers actually plan not to provide graceful throttling of performance, because providing it would eliminate a substantial selling point for upgrading to a dedicated hosting account.

Quote from: (concluded)

I'd like to keep it [....] on a shared hosting account.

I assume that you're thinking mostly of the beeeg increase in monthly costs to indulge in dedicated hosting. And elsewhere you have mentioned children, who presumably need feeding at least occasionally.

Hatchc · « **Reply #14 on:** March 26, 2013, 11:13:31 PM »

I've noticed that certain threads don't appear when I'm logged off. I have to log in to see them.