Notice a drag in the action lately? Have you been getting the database error a little too often? Time-outs? Memory overloads?<\/p>\n
Everything associated with Bloodhound Realty runs on a dual-core Xeon box. All by itself, no shared users. We have the whole server to ourselves. Two processors, two big disk drives, gigahertz ’til it hurts.<\/p>\n
And we’re maxing it out in peak hours.<\/p>\n
BloodhoundBlog has thousands of RSS subscribers, and we serve our own feeds. In the long run I might have to bite the bullet and sign up for a third party feed service like everyone else.<\/p>\n
But there is another big problem that I’m making an effort to cure today:<\/p>\n
BloodhoundBlog gets hit with spam comments around 5,000 times a day. Almost all of these are caught by Akismet, but each one is a strain on the MySQL database — the very chokepoint that’s getting maxed out.<\/p>\n
So effective now, I’ve cut off all comments for posts over two weeks old. I hate having to do this, because sometimes pure gold turns up in a comment on an older post — and our archives are ripe with gold in any case. But the spammers are looking for juice, and older posts are where the juice is to be found.<\/p>\n
I hate having to do this, but swatting at flies only gets you so far. Eventually you have to rob them of their food supply.<\/p>\n
My apologies. But: Let’s hope this speeds up the action on the live conversations.<\/p>\n","protected":false},"excerpt":{"rendered":"
Notice a drag in the action lately? Have you been getting the database error a little too often? Time-outs? Memory overloads? Everything associated with Bloodhound Realty runs on a dual-core Xeon box. All by itself, no shared users. We have the whole server to ourselves. Two processors, two big disk drives, gigahertz ’til it hurts. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[62,29],"tags":[],"class_list":{"0":"post-7454","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-dirty-laundry","7":"category-group-therapy","9":"no-featured-image"},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":7275,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/7275\/putting-the-charm-back-into-crm-introducing-top-of-mind-networks-mark-green\/","url_meta":{"origin":7454,"position":0},"title":"Putting the charm back into CRM: Introducing Top of Mind Networks’ Mark Green","author":"Greg Swann","date":"March 3, 2009","format":false,"excerpt":"Joining us today is Mark Green of Top of Mind Networks, a lender-focused CRM system with automated follow-ups. Mark is a database marketing expert, permission Marketing disciple and overall CRM junkie. He'll bring a dry wit, along with practical execution strategies that'll help you evolve beyond sending meatloaf recipe cards\u2026","rel":"","context":"In "Lending"","block_context":{"text":"Lending","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/lending\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1206,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/1206\/were-on-the-move-if-you-add-a-comment-tonight-it-will-probably-be-lost\/","url_meta":{"origin":7454,"position":1},"title":"We’re on the move: If you add a comment tonight, it will probably be lost","author":"Greg Swann","date":"March 24, 2007","format":false,"excerpt":"I have what I need to start moving BloodhoundBlog. Once I've posted this message, I will be backing up our MySQL database to get it ready to move. The weblog may continue to seem to work for the next few hours, but any changes made to the database -- any\u2026","rel":"","context":"In "Blogging"","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13327,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/13327\/the-server-swap-is-happening-now\/","url_meta":{"origin":7454,"position":2},"title":"The server swap is happening now…","author":"Greg Swann","date":"September 30, 2010","format":false,"excerpt":"DNS propagation takes a while, so it could be a while before you hit the new sever. Meanwhile, I'm backing up this database every 15 minutes, but there's no way of know when we might lose data. I'll say so when things seem to be finished.","rel":"","context":"In "Blogging"","block_context":{"text":"Blogging","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/blogging\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":18699,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/18699\/need-more-listings-check-your-inbox\/","url_meta":{"origin":7454,"position":3},"title":"Need More Listings? Check Your Inbox","author":"Brian Brady","date":"April 27, 2022","format":false,"excerpt":"If you know me, you know that I am a fan of the\u00a0Millionaire Real Estate Agent\u00a0book by Gary Keller. His high touch marketing, to people you know, is a proven way to generate seller leads. Why aren't more people deploying the\u00a036-touch strategy\u00a0then? . Three reasons why Realtors aren't doing this\u2026","rel":"","context":"In "Marketing"","block_context":{"text":"Marketing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/marketing\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10581,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/10581\/zillowcom-jumps-the-shark-make-a-big-splash-in-the-dead-pool\/","url_meta":{"origin":7454,"position":4},"title":"Zillow.com jumps the shark, makes a big splash in the dead pool","author":"Greg Swann","date":"December 17, 2009","format":false,"excerpt":"Cathleen just discovered the hard way that Zillow.com now expects us to pay them $9.95 per listing to populate their database. So long, Zillovians. It's been good to know you. (News at Inman. An obvious workaround at AG.)","rel":"","context":"In "Group Therapy"","block_context":{"text":"Group Therapy","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/group-therapy\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2521,"url":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/2521\/in-the-business-of-personal-relationships-database-marketing-is-more-effective-than-seo-marketing\/","url_meta":{"origin":7454,"position":5},"title":"In The Business Of Personal Relationships, Database Marketing Is More Effective Than SEO Marketing","author":"Dan Green","date":"January 30, 2008","format":false,"excerpt":"Two years ago, NAR told us that 74% of people begin their home search online.\u00a0 What they didn't tell us, however,\u00a0what percentage of those people\u00a0write paper with the agent on whose site they began said search. This omission is an important one.\u00a0 Just because a person starts online doesn't mean\u00a0he\u2026","rel":"","context":"In "Marketing"","block_context":{"text":"Marketing","link":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/category\/marketing\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/7454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/comments?post=7454"}],"version-history":[{"count":1,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/7454\/revisions"}],"predecessor-version":[{"id":7455,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/posts\/7454\/revisions\/7455"}],"wp:attachment":[{"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/media?parent=7454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/categories?post=7454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bloodhoundrealty.com\/BloodhoundBlog\/wp-json\/wp\/v2\/tags?post=7454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}