-
Recent Posts
- Thinking About Switching From WordPress? What Should You Consider Before You Move?
- The Airtable Acquisition Raises a Bigger Question: Do You Really Own the Software Your Business Runs On?
- How to Use Google Search Console’s New Generative AI Data to Improve Your SEO
- How to Update the Same Website Content on Multiple Pages at Once
- Discovered vs. Crawled Not Indexed in Google Search Console: What’s the Difference and How to Fix Each
- The Small Business Guide to Auditing Google Ads and Website Costs
- Do Professional Writers Still Need SEO in the Age of AI?
- Search Engine First vs. People First Content: Why Generic FAQ Dumps Harm Your SEO
- Looking for a Website Builder Without AI? Which One Should You Choose?
- Keyword Cannibalization: How to Find and Fix the Pages Stealing Your Own Google Traffic
- Why Great Content Gets Stuck on Page 8 (And How to Fix It)
- Why MySQL FULLTEXT Search Returns 0 Results (And How to Fix It)
- The Reality of Domain Speculation on New TLD Launches: Is It Still Worth It?
- The Hidden Domain Name Lock-In: Which Registrars Restrict Nameservers?
- Paying $10,000 a Month for SEO? Here’s How to Tell If You’re Getting Your Money’s Worth
- Introducing New WordPress Magazine Layouts in UltimateWB 9 (With Early Access)
- How to Fix the WordPress “Critical Error” on the Widgets Page After a PHP Upgrade
- The Hidden Risk of SaaS Website Builders: Lessons from the Recent Wix Outage
Categories
Tag Archives: terminal
How to Whitelist Googlebot, Bingbot in CSF
One way to prevent server load spikes and maintain fast performance is to block problematic IP addresses and IP ranges. However, you have to make sure that legitimate crawlers, such as Googlebot and Bingbot, are not accidentally blocked from accessing your websites. Don't crash your SEO! We covered this important step in, “How to Stop High Server Load from Distributed Botnets, Scrapers, and Database Queue Locks”. If you don't know how to do this whitelisting, this tutorial is for
... Continue readingHow to Edit .htaccess on the Site Level or Add Rules Globally
In "How to Stop High Server Load from Distributed Botnets, Scrapers, and Database Queue Locks" we talked about how to fix your high server loads. That included adding rules to your site's .htaccess file, or updating the rules globally. If you don't know how to do that yet, this guide is for you.
Crucial First Step: Make a Backup
Before touching .htaccess, always make a copy. A single typo in this file will cause a "500 Internal Server Error" and take
... Continue reading
Posted in Coding, Server Admin & Security
Tagged .htaccess, 500 Internal Server Error, apache, apache configuration, cpanel, file manager, global apache configuration, global rules, include editor, nano text editor, post virtual host include, pre main include, pre virtualhost include, show hidden files, terminal, whm
Leave a comment
The Developer’s Guide to Identifying and Optimizing Slow MySQL Queries
This tutorial will guide you through identifying, extracting, and analyzing your most problematic database queries using the command line on a WHM/cPanel server.
If you’re using UltimateWB for your backend, chances are you won’t need any of this. We optimize UltimateWB to run fast whether your website is small or large. But in case you need it - for example, if you are adding complex custom code or building a project from scratch - this guide has you covered.
... Continue reading
Posted in Coding, Server Admin & Security, Web Hosting
Tagged cpanel, database optimization, fast website, guide, mysql, mysql database, mysqldumpslow, optimize database, Percona Toolkit, server performance, slow mysql queries, slow query log, software development, SQL optimization, technical seo, terminal, tutorial, web performance, whm
Leave a comment