• Home
  • WordPress
  • web Hosting
    • Free hosting
    • Cheap Hosting
    • comparison cloud , vps, shared, wordpress
    • managed wordpress hosting
    • managed cloud hosting
  • page Speed
  • Deals
  • Services
  • About

RAaz Kumar .com

wordpress tutorials seo hosting etc


WordPress database optimization (don’t neglect) plugins & phpmyadmin manually

 

automatic or manual optimization

we are humans more chances are there to foregetting, neglecting, overloading our mind other thoughts

I simple neglecting cause ms latency tend to loose million dollars ft amazon, google etc.

 

WordPress database optimization plugins

Wp rocket vs wp-optimize

wp optimize introduced page cache, minify css&js judt like other caching plugins.
why?  maybe wp  rocket introduced db optimization along with page caching.

Wp rocket database optimization settings

clean expired transcients
clean post auto revisions (you can limit post revisions in wp config php)
optimize tables
delete auto draft a
Empty trash comments
wp optimize has better feature viewing tables just like in phpmyadmin.
deleting tables that are left by uninstalled plugins.
both plugins have weekly automatic cleanup & optimize settings.

wordpress database optimization with phpmyadmin

some plugins like all in one wp security, redirection manager, etc
Leaves logs in database tables.
ex: ip login licked table has 10000 rows, but posts table has only 100 rows.

Why reducing database boosts performance

Reason: innodb buffer pool caching database in memory.
so we allocate less memory that means lower costs & higher performance.
object caching redis / memcached also requires memory.
Myisam locks entire table while a query performing new queries has to wait.
Innodb locks at row level ,
logging to database also cause iops issues tend lower performance.
why need phpmyadmin to empty the data of table.

deleting wordpress post meta with phpmyadmin

(don’t play with database)leave it if not necessary.
or take backup must otherwise you regret in case something goes wrong.
why post meta rows higher than posts.
yoast seo meta, review schema, job schema, author schema,
each plugin adds meta data about your posts.
this is the reason post meta has higher rows.
delete the post meta for unused plugins.
1st check the plugin.
SELECT * FROM wp_postmeta WHERE `meta_key` LIKE ‘%smpro%’
DELETE FROM `wp_postmeta` WHERE `meta_key` LIKE ‘%review%’;
or
SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
SELECT * FROM your_prefix_postmeta pm LEFT JOIN your_prefix_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL; DELETE pm FROM wp_postmeta pm LEFT JOIN your_prefix__posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;
or
SELECT * FROM your_prefixcommentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM your_prefix_comments ); DELETE FROM your_prefix_commentmeta WHERE comment_id NOT IN ( SELECT comment_id FROM your_prefix_comments ); SELECT * FROM your_prefix_commentmeta WHERE meta_key LIKE ‘%akismet%’; DELETE FROM your_prefix_commentmeta WHERE meta_key LIKE ‘%akismet%’;

bulk delete wordpress comments pending & spam phpmyadmin

DELETE FROM wp_comments WHERE comment_approved = ‘spam’;
DELETE FROM wp_comments WHERE comment_approved = ‘pending’;
transients
are used to communicate, expired transcients not automatically deleted themselves, we need to delete them manually.
delete unused tables
Phpmyadmin select table.
and drop.

post revisions

define( ‘WP_POST_REVISIONS’, 3)
clean all post revisions after certain time.
it’s better install a db optimize plugin.
old databases gets worse without optimizing it.
  • Carries out automatic weekly (or otherwise) clean-ups

Expired Transients

Wp-optimize
optimizing through phpmyadmin

deleting tables of uninstalled plugins

wordpress only have 11 core tables.
Innodb table locks row while mousam locks table while mysql queries.
whole database has to cache inorder to read lower size database Higher speed.

optimize database tables

optim
delete spam comments
we need to define spam triggers , so comments go straight to spam folder.
DELETE FROM wp_comments WHERE comment_approved = ‘spam’;
If you are DBA or db admin you may run SQL commands in terminal
like optimize, repair, other tools & scripts helpful
optimizing queries etc.
read MySQL optimization & MySQL performance tuning
tools do better & error free cleaning rather manualy doing it.(higher chances forgetting)

Related topics:

  1. Innodb vs myisam (table engines row lock vs table lock)
  2. phpmyadmin install / configure on nginx ubuntu 20.04 apache2 debian 10
  3. TOP 5 Best wordpress comment plugins 2020 (disable pingback, replytocom, customize form)
  4. WordPress Adsense Plugins & Manually
  5. mysqldump import /export mysql database command line, phpmyadmin, Cpanel, mysql workbench, xamp

wordpress tutorials for beginners advanced complete guide to run WordPress

  • Rules to get 100/100 in Google pagespeed web core vitalsscore
  • How to add adsense amp ads to wordpress
  • wordpress password reset in 3 ways mail, phpmyadmin, mysql command
  • how i recovered hacked website site 5 times ft wordpress?
  • enable browser caching in wordpress apache nginx caching headers explained
  • W3TC w3 total cache plugin setup guide review comparison with wp rocket and wp super cache
  • Wordpress database optimization (don't neglect) plugins & phpmyadmin manually
  • Optimize css delivery inline critical css, remove unused css, render blocking css
  • Converting WordPress into static website speed after 1 second dynamic 3 seconds
  • Wordpress errors and fix
  • website cache best caching plugins wordpress w3tc cloudflare
  • Install xamp & wordpress on localhost windows
  • favicon ico Change / Add / Disable favicon in wordpress Ft Genesis Theme or any theme
  • increase wordpress memory limit (how to ) 40MB , 64 MB 128 MB or 512 MB maybe 1024MB
  • wp cron job check working or not disable enable change schedule
  • google analytics plugins for wordpress #sitekit #monsterinsights gadwp back as gainwp
  • Lazy Load Adsense to improve core web vitals - Vs revenue
  • xmlrpc php wordpress uses, disable without 403 error log message
  • wordpress change post date programmatically (auto on update like blogger
  • wordpress plugins that slow down your site and its alternatives
  • best wordpress plugins social, seo, Backup, speed up your blog
  • TOP 10 Wordpress Themes Premium/ Free & providers
  • Wordpress Adsense Plugins & Manually
  • Social share buttons for website Wordpress Blogger
  • How to bulk delete in wordpress posts, pages, Media Images, tags and categories
  • TOP 5 Best wordpress comment plugins 2020 (disable pingback, replytocom, customize form)
  • all in one seo pack vs yoast seo pressor
  • Auto post to Facebook, twitter, Google Plus Wordpress Posts 2019
  • wordpress speed optimization Speed up wordpress Score on Google pagespeed
  • How to use wordpress tags and categories
  • Wordpress duplicate thin content Issues {FIXED}
  • how to increase wordpress memory & file upload size
  • combine rss feeds wordpress
  • Reduce the impact of third-party code ,optimize JS delivery, Minify, remove unused js, pre connect, inline, lazy load etc
  • change wordpress site url
  • install wordpress on ubuntu apache nginx debian command line
  • Wordpress Security Plugins 2021 (Brute force, Login lockdown, Malware scanner etc)

 

 

wordpress Pagespeed optimization

Digitalocean free $100 Credit

Cloudways Review pricing promo codes

Siteground cpu limits Pricing

Shared Hosting

Managed wordpress Hosting

Managed Hosting Cloud server

VPS Hosting

Cloud Hosting – Unmanaged

Google cloud Pricing

Aws Pricing

Azure pricing

nginx server tutorials

apache server tutorials

linux sysadmin tutorials

mysql Commands list pdf

LEMP Install Ubuntu

Mysql Performance Tuning

Nginx Performance tuning

Linux Performance tuning

Php -fpm performance tuning

Redis Performance tuning

linux server security

nginx security best practices

wordpress security plugins

 

 

wordpress

 

Top 5  WP Google Analytics Plugins

WP Backup Plugins

Wp Comment Plugins

Top wordpress Security Plugins

WP Seo Plugins

WP Caching Plugins

Best Adsense Plugins for WordPress

Wp social Sharing Plugins

autoshare social media plugins

WP speed Optimization Plugins

Speedup WordPress google Score

More Wp tuts

Server Admin Cloud

 

Installing Nginx LEMP On ubuntu

Installing apache Lamp ubuntu

nginx fastcgi cache enable

php – fpm install  & Configuration

Opcache install & Configure

php -fpm pool manager explained

Mysql Install & Configuration

Redis Object cache install & configure

 

Nginx as Reverse Proxy and Load balancer

Load Balance / auto scaling in google cloud

Linux Commands PDF

Mysql Commands Pdf

Letsencrypt tutorial

mysqldump export & import 

Pagespeed Module install & configure

nginx.conf best file

mysql.conf best file

upgrade ubuntu

© 2023 - All Rights Reserved Disclaimer & Privacy Policy