Catholic Info
Traditional Catholic Faith => General Discussion => Topic started by: 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.
-
Glad CI is back up. :cowboy:
-
Me too!!!!
:ready-to-eat:
-
Smart Move.
Many sign up, and that is the last we hear from them.
Once again, sad that the likes/dislikes have again disappeared.
-
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.
-
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).
-
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?
-
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.
-
I notice that the time limit on consecutive searches has increased to 30 seconds.
-
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?)
-
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
-
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.
-
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.
-
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.
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.
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.
-
I've noticed that certain threads don't appear when I'm logged off. I have to log in to see them.
-
Another strange change is that threads don't end on the last page. I click "next" and there's another page.
-
I believe I fixed that.
Again, I encourage all our "guest" guests to sign up for an account.
You can pick a completely off-the-wall username, and you don't have to say a thing about yourself.
It's just as anonymous as being a guest -- but at least I know you're a human being. Just for that little bit of information, you get considerably more privileges and a much better CathInfo browsing experience.
-
Yes, the site does seem to be responding more snappily!
-
Whew doggies!
Am I relieved to hear that it was just maintenance and upgrades!
I thought CI had been hacked...
By either:
The mossad
(http://cdn.timesofisrael.com/uploads/2012/07/idf-hackers-195x110.jpg)
China's Cyber warfare division.
(http://2.bp.blogspot.com/_3cib3fK139M/TPOFKCfoS1I/AAAAAAAAGAg/gI85az2sNGo/s1600/chinese+cyber+warfare.jpg)
Or the Al Qeada computer club
(http://1.bp.blogspot.com/-PpxtOoFm0kA/UEvvAmxOhJI/AAAAAAAAScA/zUs1EHIHYaM/s640/reuterssultan-al-fahed.n.jpeg)
-
Whew doggies!
Am I relieved to hear that it was just maintenance and upgrades!
I thought CI had been hacked...
By either:
The mossad
Very good observation, Incredulous.
I fed your 1st photo to some very high-tech bagel-boy-unmasking image enhancer software. And what surprise: if we take a closer look at that mirror next to the soldiers, I think we can recognize Krah there. He must have been on that photo all the time. See?
(http://img11.imageshack.us/img11/7434/katercarlo.jpg)
:-)
-
Wow! Ethelred...
We knew Maxie visited a Mossad special forces camp, but now your image de-coder reveals he's treated by the military like a rock star ? But why?
With that crazy hair-style, could be Maxie be sending a secret signal that he's actually a modern-day Golem?
(http://merovee.files.wordpress.com/2010/06/golem-2.jpg)
The rabbis super hero, who will help destroy the SSPX and the last vestiges of Holy Roman Catholicism ?
Man... this week's revelations... are too much to comprehend.
-
Now I know where all our recycled Trinitron monitors went to...........
The Al Qeada computer club!
(http://1.bp.blogspot.com/-PpxtOoFm0kA/UEvvAmxOhJI/AAAAAAAAScA/zUs1EHIHYaM/s640/reuterssultan-al-fahed.n.jpeg)
:wink: