How to Optimize Images in WordPress Without Plugin & With Plugin

How to Optimize Images in WordPress Without Plugin & With Plugin

How to Optimize Images in WordPress Without Plugin & With Plugin

  1. How to Optimize Images in WordPress Without Plugin
  2. How to Optimize Images in WordPress With Plugin

1. How to Optimize Images in WordPress Without Plugin

The more the contents we are trying to display in homepage is affecting the Page size. So, we have to think like we will upload limited contents on a home page so that it will not affect the Page Load.

  1. During uploading a big images in Revolution Slider or Product Images keep the actual dimension but we can decrease the image size.
  2. Lossless Compression: This is process to Strip unused data & compress images without affecting image quality.
  3. All Product Image / Slider Images / Banner Images should be in JPG format. It is much lighter than the PNG format.
  4. Optimize & compress up to 50 images by using a plugin with one click.
  5. By saving images like this we can save much storage in the Server and the site will be Optimized. We should keep the Big images like Slider Images, Big Banner Images within 150kb to 200kb Max (Always less value should be Compromised). The Product image size can be 50kb to 100kb Maximum (Always less value should be Compromised).
  6. Incorrect Size Image Detection: Quickly locate images by using a plugin that are slowing down your site.
  7. Automatic optimization using Cron
  8. In homepage Carousels Sections should be limited. Each Section of Carousels should calling only 10-12 product images . e.g. If each tab loading 20 to 30 Product images. If we assume 30 images then 430 = 120 Images are loading in this Section.
  9. Make your website faster by reducing the weight of images
  10. Optimize images if they are not located in the media library.
  11. Grid Style is better instead of Carousels, we can set a View More Button at the Right or Bottom side of Each Section which can lead to the Category Page.
  12. Serves images from a global CDN for free
  13. imagecompressor.com bh

(1). Example of Image Size

Woocommerce.com mentioned, Original images you upload should be at least 800 x 800px or higher for most themes. It depends on theme. I have mentioned some example below –

  • Alibaba: 1000x1000px =240kb, 2448x2448px = 1.39Mb, 800x1066px = 474kb, 800x800px = 109kb
  • Amazon: 679x848px = 7kb, 679x847px = 21kb, 1500x1471px = 165kb, 1302x1500px = 156kb

2. How to Optimize Images in WordPress With Plugin

kraken.io Plugin (bh)

How to enable lazy image loading & How to add lazy load to images

2.1. Install and configure Jetpack Boost

2.2. Install and configure Jetpack

  • Enable Lazy Image Loading
  • Enable site accelerator
  • Speed up image load times
  • Enable Lazy Loading for images

2.3. Install and configure Shotpixel

  1. Sign up 
  2. Input API key
  3. Configure
  4. Convert all JPEG, PNG or GIF to WebP and AVIF
  5. Convert the next generation images (WebP and AVIF) into the front-end pages by using the <picture> tag instead of <img>, independent from generating them through the plugin
  6. Compatible with WP Retina 2x – all retina images are compressed automatically
  7. CMYK to RGB conversion
  8. Can run ShortPixel on multiple websites or on a multisite with a single API Key
  9. Bulk optimize all images in Media Library with one click
  10. Option to deactivate auto-optimizing on upload for images
  11. Integration with CloudFlare, by API Key or a Token
  12. Uploaded images can be automatically optimized in Media Library.

2..4. Install and Configure WebP Express

 Install and Configure WebP Express
  1. HTML, replacing image tags with picture tags
  2. HTML, replacing image URLs so all points to webp
  3. Cache Enabler, the same as above can be achieved, but with page caching
  4. Much faster load time for images in browsers that supports webp
  5. Better ranking in Google searches
  6. Less bandwidth consumption

Install and configure Imagify Plugin

FAQ

Question: How can I measure the impact of Imagify on speed score?

Answer: We can use GTMetrix/Google PageSpeed to test the following metrics before and after the image optimization:

Total Page Size (GTMetrix), Optimize images (GTMetrix), Serve images in next-gen formats (PageSpeed Insights) and Efficiently encode images (PageSpeed Insights)

Questions: I am operating as ecommerce website developed by WordPress. I have imported 857 products. All product has one image.  Sometimes I delete some products and sometimes I add some products. But I don’t delete image. So now I have 857 products. But in media library I found around 2463 images. Will unused image slow/affect my website?

Answer: Yes . These unused images will cause load on your website slow down the website functionality.
As you keep on uploading the images, the website keeps on building up the CPU usage, cache and other processes, until it reaches its peak and breaks down. (S5)

Answer: Unsued images should not be affecting your site in terms of performance as those are not being used. They are, however, using the allocated disk. (dp)

Question: Which image format is better for website? E.g.JPG/PNG/WebP

Answer: WebP format is best as it dies not consume much resource but resolution is not that great! (S5) I’d say WebP. (dp)

Question: You are talking about  wordpress.org/plugins/rocket-lazy-load. Will this plugin convert JPG/PNG to WebP format? I have jetpack so will  Jetpack does not work as Lazy load since it has option.    

Question: What is the best image conversion plugin?

My recommendation would be to follow the steps in an article like this one decwinser.com/article/webp-redirects-with-a-http-proxy-cache . We uses a HTTP Proxy Cache so I think you can do the conversion using the suggested plugin in that above article.

Answer: wordpress.org/plugins/rocket-lazy-load

TopicsLink
Shotpixel Officialyoutu.be/5EbX0Hsy6j4
Dreamhost Jetpackhelp.dreamhost.com/hc/en-us/articles/115006051887-Using-Jetpack-with-DreamPress
Configure WebP Expressdecwinser.com/article/webp-redirects-with-a-http-proxy-cache

How To Install SSL Certificate in cPanel /Hosting Server for Website.

How To Install SSL Certificate in cPanel for WordPress Website

What is SSL

SSL means Secure Sockets Layer. It is a protocol that protects communication on the internet. SSL is used for securing communication between a web browser & a web server. Website address will be from HTTP to HTTPS.

What is SSL Certificates

A website needs SSL certificate in order to keep user data secure, verifying ownership of the website, prevent the attackers from creating a fake version of the site and gain user trust.

Why SSL Certificates Use

Companies and organizations need to install SSL certificates to their websites to secure online transactions and keep their customer information private and secure. We recommend that you use SSL when you set up your email account in an email application as well as in online payment services to protect your data

Types of SSL Certificates

PositiveSSL: 1 domain, Domain Validation, It means before an SSL certificate can be issued, the certificate applicant needs to confirm their domain ownership rights. This is called domain control validation (DCV), Basic HTTPS, Comodo SSL, Low assurance, Great for Personal, Pricing: 3$

PositiveSSL Wildcard : Unlimited subdomains, Domain Validation, Basic HTTPS, Comodo SSL, Low assurance, High and Law means, the level of the assurance mostly depends on the certificate validation type, the amount of the information the certificate applicant provides to the Certificate Authority (Comodo, now Sectigo). The deeper is the certificate validation process performed by Comodo (now Sectigo), the higher is the assurance, Great for Personal, Pricing: 38$

Essential SSL : Domain (DV), Single Domain, Great for Personal, Encryption (up to 256-bit), Pricing: 13$

EV SSL: 1 domain, Extended Validation, Company name in browser, Comodo SSL, Very high assurance, Great for Business, Encryption (up to 256-bit), Pricing: 39$

PremiumSSL Wildcard : Unlimited subdomains, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Personal, Great for Personal, Encryption (up to 256-bit), Pricing: 112$

Instant SSL : 1 domain, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Business, Encryption (up to 256-bit), Pricing: $15

PositiveSSL Multi Domain : 3-100 domain seats, Domain Validation, Basic HTTPS, Comodo SSL, Low assurance, Great for Personal, Encryption (up to 256-bit), Pricing: $16

EV Multi Domain SSL : 3-100 domain seats, Extended Validation, Company name in browser, This means, that in the address bar, clickable padlock, you can see company details in certificate properties (for OV and EV certificates)., Comodo SSL, Very high assurance, Great for Business, Pricing: $69

Unified Communication : 3-100 domain seats, Organization Validation, Company name in SSL, Comodo SSL, High assurance, Great for Business, Encryption (up to 256-bit), Pricing: $44

Self-Signed : Self-signed certificate to secure  Local IP addresses. It is encrypted but there is no verification by a trusted party that it is handled by the correct source

TOP 20 SSL Certificates Providers/ Authority

Sectigo/ Comodo: Comodo is the former name of Sectigo and is one of the certificate authorities that issue SSL certificates

SLProviderTypeURL (Copy and Paste to your Browser)
1Sectigo/ComodoAuthoritysectigo.com
2SymantecAuthoritybroadcom.com
3GeoTrustAuthoritygeotrust.com
4DigiCertAuthoritydigicert.com
5ThawteAuthoritythawte.com
6GoDaddyAuthoritygodaddy.com/gdshop/ssl/ssl.asp
7Network SolutionsAuthoritynetworksolutions.com/SSL-certificates/index.jsp
8RapidSSLonlineAuthorityrapidsslonline.com
RapidsslAuthorityrapidssl.com
9SSL.comAuthorityssl.com/certificates
10Entrust DatacardAuthorityentrustdatacard.com
11GlobalSignAuthorityglobalsign.com
12EntrustAuthorityentrust.com
13AlphaSSLAuthorityalphassl.com
14SSL.comProviderSSL.com
15Let’s EncryptAuthorityletsencrypt.org
16IdenTrustProvideridentrust.com/digital-certificates/tlsssl-website-security
17SlstoreProviderthesslstore.com
18SecuretrustProvidercerts.securetrust.com

How to generate a key and CSR

To configure server to use SSL, you must have an SSL certificate. To obtain the SSL certificate, complete the steps:

Set the OpenSSL configuration environment variable
Generate a key file.
Create a Certificate Signing Request
Send the CSR to a certificate authority (CA) to obtain an SSL certificate.
Use the key and certificate to configure Tableau Server to use SSL.
Configure a certificate for multiple domain names

SSL Management

SSL installation process via hosting provider is given below –

  • At first contact / chat with SSL service provider
  • Then they will make an invoice
  • Then make payment
  • Then need to create an email address in the domain
  • Thank you
  • You have entered the correct Domain Control Validation code. Your certificate will now be issued and emailed to you shortly. Please close this window now.

FAQ

Q: Are you offering free SSL? So who is your SSL service provider? And which certificate are you providing in hosting package?

Question: How to Check SSL Active or Not?

Answer: Go to the link and input your website and check. www. sslshopper.com/ssl-checker.html

After inputting website below information will come to screen

These results were cached from July 13, 2020, 3:35 am PST to conserve server resources.
If you are diagnosing a certificate installation problem, you can get uncached results by clicking here.
autogarment.com resolves to 162.241.253.102

 Server Type: Apache

 The certificate should be trusted by all major web browsers (all the correct intermediate certificates are installed).

 The certificate was issued by Let's Encrypt.

Write review of Let’s Encrypt

 The certificate will expire in 58 days. Remind me



 The hostname (autogarment.com) is correctly listed in the certificate.

 Common name: autodiscover.autogarments.com

SANs: autodiscover.autogarment.com, autodiscover.autogarments.com, autogarment.com, autogarments.autogarment.com, autogarments.com, compliance.autogarment.com, cpanel.autogarment.com, cpanel.autogarments.com, cpcalendars.autogarment.com, cpcalendars.autogarments.com, cpcontacts.autogarment.com, cpcontacts.autogarments.com, mail.autogarment.com, mail.autogarments.com, webdisk.autogarment.com, webdisk.autogarments.com, webmail.autogarment.com, webmail.autogarments.com, www.autogarment.com, www.autogarments.autogarment.com, www.autogarments.com, www.compliance.autogarment.com
Valid from June 11, 2020 to September 9, 2020
Serial Number: 04711e80e12d4d977884iooce29d0888d7b58d86e97f56
Signature Algorithm: sha25ttg56Wit888hRSAE8888ncryption
Issuer: Let’s Encrypt Authority X3

 Common name: Let's Encrypt Authority X3

Organization: Let’s Encrypt
Location: US
Valid from March 17, 2016 to March 17, 2021
Serial Number: 0a01tyu4142000001ooppiiuuy5385736a0b8oop5eca708
Signature Algorithm: sha2uio56WithRSAE7uioncopiryption
Issuer: DST Root CSA X3

Question: How to check mix content of http and https in a website

Answer: User below URL to check URL: www.whynopadlock.com

Question: Where is the file of user.ini

Answer: I have renamed the .user.ini file that fixed the issue ! It is in cpanel – File manager – Doc Root: /home1/bab/designview.bab.com

Question: We have purchase host & SSL from xyz.com. If we transfer our hosting to you as VPS hosting, should we use existing SSL purchase from site5.com

ProviderLink
SSLSssls.com
Trial SSLssls.com/blog/ssl-trials

How to Secure a Domain Name for Medium Business

How to Secure a Domain Name for Medium Business

Free & Full Domain Privacy

  • Free Domain Privacy keeps your personal info and identity safe & prevents from spam.
  • Free Domain Privacy replaces your personal info with proxy info in public WHOIS directory.
  • Free Domain Privacy Prevents spam with private email account for domain inquiries.
  • Prevents hackers for stealing your own domain or making any other unauthorized changes
  • Requires your approval in mobile via 2-factor authentication for vital changes e.g. deleting or transferring a domain
  • Hold on to your domain for an extra 90 days if yyour billing method expires at renewal
  • Domain Protection puts your domain on lockdown that makes protection accidental and malicious transfers virtually
  • Domain Protection is online security guard which automatically scans malware and uses continuous security monitoring to tackle new threats. It also monitor search engine to protect your domain reputation and blacklists
  • All domain extensions (often ccTLDs) aren’t eligible for free Domains By Proxy®, and as a result cannot be used with Domain Privacy.

How to Transfer a Domain

Domain Transfer form own checklist

  • First unlock your domain. Your domain is unlocked and ready to transfer.
  • Make sure your administrative contact email is current. (It’s where we send your transfer authorization code.) We’ve also sent your authorization code to the administrative email address: hmmitu@gmail.com
  • Use the authorization code at your new registrar to complete your transfer.
  • Verify that the new registrar will set up your DNS zone files. If you don’t do this, your website and email could go down.
  • Start the domain transfer at your new registrar. (We email you to ensure you requested the transfer.)
  • Authorize the transfer with your new registrar. (Use the transfer authorization code we email you when you’re done here.)
  • We email you confirmation when your transfer completes, usually not more than 5-7 days.

Check List

Security Nameatg.comhad.comhal.com
Domain Information..
Domainatg.comYY
RegistrarGoDaddy.com, LLCYY
Registered On2013-11-03YY
Expires On2026-11-03YY
Updated On2022-11-24YY
Status:clientDeleteProhibited
clientRenewProhibited
clientTransferProhibited
clientUpdateProhibited
YY
Name Serversns1.dreamhost.com
ns2.dreamhost.com
Y.
.Registrant Contact..
NameRegistration PrivateNY
OrganizationDomains By Proxy, LLCNY
StreetDomainsByProxy.com
2155 E Warner Rd
Y.
CityTempe..
StateArizona..
Postal Code85284YY
CountryUS..
Phone+1.4806242599..
Fax+1.4806242598YY
EmailSelect Contact Domain Holder link at https://www.godaddy.com/whois/results.aspx?domain=aut.comYY
.Administrative Contact..
NameRegistration PrivateYY
OrganizationDomains By Proxy, LLCYY
StreetDomainsByProxy.com
2155 E Warner Rd
YY
CityTempeYY
StateArizonaYY
Postal Code85284..
CountryUSYY
Phone+1.4806242599YY
Fax+1.4806242598..
Emailhttps://www.godaddy.com/whois/results.aspx?domain=aut.com..
.Technical Contact..
NameRegistration Private..
OrganizationDomains By Proxy, LLC..
StreetDomainsByProxy.com
2155 E Warner Rd
..
CityTempe..
StateArizonaYY
Postal Code85284YY
CountryUS..
Phone+1.4806242599..
Fax+1.4806242598
EmailSelect Contact Domain Holder link at https://www.godaddy.com/whois/results.aspx?domain=auto.comYY

Raw Whois Data

Domain Name: at.com
Registry Domain ID: 1833555994871_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.godaddy.com
Registrar URL: https://www.godaddy.com
Updated Date: 2021-03-09T09:44:25Z
Creation Date: 2013-11-03T01:16:19Z
Registrar Registration Expiration Date: 2026-11-03T01:16:19Z
Registrar: GoDaddy.com, LLC
Registrar IANA ID: 146
Registrar Abuse Contact Email: email@godaddy.com
Registrar Abuse Contact Phone: +1.4806242505
Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited
Domain Status: clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited
Domain Status: clientRenewProhibited https://icann.org/epp#clientRenewProhibited
Domain Status: clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited
Registry Registrant ID: Not Available From Registry
Registrant Name: Registration Private
Registrant Organization: Domains By Proxy, LLC
Registrant Street: DomainsByProxy.com
Registrant Street: 2155 E Warner Rd
Registrant City: Tempe
Registrant State/Province: Arizona
Registrant Postal Code: 85284
Registrant Country: US
Registrant Phone: +1.4806242599
Registrant Phone Ext:
Registrant Fax: +1.4806242598
Registrant Fax Ext:
Registrant Email: Select Contact Domain Holder link at https://www.godaddy.com/whois/results.aspx?domain=autogarment.com
Registry Admin ID: Not Available From Registry
Admin Name: Registration Private
Admin Organization: Domains By Proxy, LLC
Admin Street: DomainsByProxy.com
Admin Street: 2155 E Warner Rd
Admin City: Tempe
Admin State/Province: Arizona
Admin Postal Code: 85284
Admin Country: US
Admin Phone: +1.4806242599
Admin Phone Ext:
Admin Fax: +1.4806242598
Admin Fax Ext:
Admin Email: Select Contact Domain Holder link at https://www.godaddy.com/whois/results.aspx?domain=at.com
Registry Tech ID: Not Available From Registry
Tech Name: Registration Private
Tech Organization: Domains By Proxy, LLC
Tech Street: DomainsByProxy.com
Tech Street: 2155 E Warner Rd
Tech City: Tempe
Tech State/Province: Arizona
Tech Postal Code: 85284
Tech Country: US
Tech Phone: +1.4806242599
Tech Phone Ext:
Tech Fax: +1.4806242598
Tech Fax Ext:
Tech Email: Select Contact Domain Holder link at https://www.godaddy.com/whois/results.aspx?domain=at.com
Name Server: NS1.BLUEHOST.COM
Name Server: NS2.BLUEHOST.COM
DNSSEC: unsigned
URL of the ICANN WHOIS Data Problem Reporting System: http://wdprs.internic.net/

Last update of WHOIS database: 2023-05-24T04:34:10Z <<<
For more information on Whois status codes, please visit https://icann.org/epp

TopicsLink
Domain Privacygodaddy.com/en-in/domains/full-domain-privacy-and-protection

How to Optimize WordPress Database & Troubleshooting

How to Optimize WordPress Database & Troubleshooting

List of Basic WordPress Tables

There are 11 tables found in brand new WordPress site-

(1) wp_posts, (2) wp_postmeta, (3) wp_options, (4) wp_users, (5) wp_usermeta, (6) wp_term_taxonomy, (7) wp_terms, (8) wp_term_relationships, (9) wp_links, (10) wp_comments, (11) wp_commentmeta

| Size |
+——————————————————–+——-+
| tble_actionscheduler_actions | 11 MB |
| tble_actionscheduler_claims | 0 MB |
| tble_actionscheduler_groups | 0 MB |
| tble_actionscheduler_logs | 8 MB |
| tble_bkash_transactions | 0 MB |
| tble_commentmeta | 0 MB |
| tble_comments | 3 MB |
| tble_gglcptch_allowlist | 0 MB |
| tble_links | 0 MB |
| tble_mailchimp_carts | 0 MB |
| tble_mailchimp_jobs | 0 MB |
| tble_op_user_templates | 0 MB |
| tble_options | 4 MB |
| tble_postmeta | 36 MB |
| tble_posts | 6 MB |
| tble_pprh_table | 0 MB |
| tble_revslider_css | 0 MB |
| tble_revslider_css_bkp | 0 MB |
| tble_revslider_layer_animations | 0 MB |
| tble_revslider_layer_animations_bkp | 0 MB |
| tble_revslider_navigations | 0 MB |
| tble_revslider_navigations_bkp | 0 MB |
| tble_revslider_sliders | 0 MB |
| tble_revslider_sliders_bkp | 0 MB |
| tble_revslider_slides | 4 MB |
| tble_revslider_slides_bkp | 0 MB |
| tble_revslider_static_slides | 0 MB |
| tble_revslider_static_slides_bkp | 0 MB |
| tble_smush_dir_images | 0 MB |
| tble_social_users | 0 MB |
| tble_sslcare_woo_alert | 3 MB |
| tble_term_relationships | 1 MB |
| tble_term_taxonomy | 0 MB |
| tble_termmeta | 0 MB |
| tble_terms | 0 MB |
| tble_tm_taskmeta | 0 MB |
| tble_tm_tasks | 0 MB |
| tble_usermeta | 6 MB |
| tble_users | 0 MB |
| tble_wc_admin_note_actions | 0 MB |
| tble_wc_admin_notes | 0 MB |
| tble_wc_category_lookup | 0 MB |
| tble_wc_customer_lookup | 0 MB |
| tble_wc_download_log | 0 MB |
| tble_wc_order_coupon_lookup | 0 MB |
| tble_wc_order_product_lookup | 1 MB |
| tble_wc_order_stats | 1 MB |
| tble_wc_order_tax_lookup | 0 MB |
| tble_wc_product_meta_lookup | 1 MB |
| tble_wc_reserved_stock | 0 MB |
| tble_wc_tax_rate_classes | 0 MB |
| tble_wc_webhooks | 0 MB |
| tble_wcpdf_invoice_number | 0 MB |
| tble_wdp_order_items | 0 MB |
| tble_wdp_orders | 0 MB |
| tble_wdp_rules | 0 MB |
| tble_wdr_order_discounts | 0 MB |
| tble_wdr_order_item_discounts | 0 MB |
| tble_wdr_rules | 0 MB |
| tble_wfblockediplog | 0 MB |
| tble_wfblocks7 | 0 MB |
| tble_wfconfig | 0 MB |
| tble_wfcrawlers | 0 MB |
| tble_wffilechanges | 0 MB |
| tble_wffilemods | 7 MB |
| tble_wfhits | 0 MB |
| tble_wfhoover | 0 MB |
| tble_wfissues | 0 MB |
| tble_wfknownfilelist | 3 MB |
| tble_wflivetraffichuman | 0 MB |
| tble_wflocs | 0 MB |
| tble_wflogins | 0 MB |
| tble_wfls_2fa_secrets | 0 MB |
| tble_wfls_settings | 0 MB |
| tble_wfnotifications | 0 MB |
| tble_wfpendingissues | 0 MB |
| tble_wfpklist_template_data | 0 MB |
| tble_wfreversecache | 0 MB |
| tble_wfsnipcache | 0 MB |
| tble_wfstatus | 0 MB |
| tble_wftrafficrates | 0 MB |
| tble_woo_wallet_transaction_meta | 0 MB |
| tble_woo_wallet_transactions | 0 MB |
| tble_woocommerce_api_keys | 0 MB |
| tble_woocommerce_attribute_taxonomies | 0 MB |
| tble_woocommerce_downloadable_product_permissions | 0 MB |
| tble_woocommerce_log | 0 MB |
| tble_woocommerce_order_itemmeta | 10 MB |
| tble_woocommerce_order_items | 1 MB |
| tble_woocommerce_payment_tokenmeta | 0 MB |
| tble_woocommerce_payment_tokens | 0 MB |
| tble_woocommerce_sessions | 1 MB |
| tble_woocommerce_shipping_zone_locations | 0 MB |
| tble_woocommerce_shipping_zone_methods | 0 MB |
| tble_woocommerce_shipping_zones | 0 MB |
| tble_woocommerce_tax_rate_locations | 0 MB |
| tble_woocommerce_tax_rates | 0 MB |
| tble_woodmart_wishlist_products | 0 MB |
| tble_woodmart_wishlists | 0 MB |
| tble_wpbkash | 0 MB |
| tble_wpbkash_refund | 0 MB |
| tble_wpfm_backup | 0 MB |
| tble_wpmm_subscribers | 0 MB |
| tble_ycd_subscribers | 0 MB |
| tble_yoast_indexable | 2 MB |
| tble_yoast_indexable_hierarchy | 0 MB |
| tble_yoast_migrations | 0 MB |
| tble_yoast_primary_term | 0 MB |
| tble_yoast_seo_links | 0 MB |
| tble_yoast_seo_meta | 0 MB |

Question: How to Optimize WordPress Database & Troubleshooting

Answer: (1) Your database is very bloated. The options table is at 25MB (I’d expect no more than 4MB) (2) The autoloaded dats is over 1MB (I’d expect about 600KB).

Question: How can I optimize a database of wordpress?

Answer: You can optimize under cPanel>>phpmyadmin>>select the database>>select all tables>>optmize.

2. Optimize WordPress Database with Plugins

Advanced Database Cleaner Plugin Features

Clean Database: WordPress database accumulates a lot of extra data such as spam comments, revisions, trashed comments, etc.

Optimizing database will reclaim unused space in tables, which will reduce storage space & improve efficiency when accessing tables. It does not run any code that break down site or delete posts, pages, comments, etc

Revision: WordPress record called “revision” of each saved draft or published item. It allows to see what changes were made in each post &  page over time. It consumes a lot of space. SQP query to clean all revisions is: DELETE FROM posts WHERE post_type = ‘revision’

Auto Draft: WordPress saves your post/page when you are editing it before publish called an auto-draft. The sql query used by the plugin to clean all auto-drafts is: DELETE FROM posts WHERE post_status = ‘auto-draft’

Pending Comments:  Pending comments are published by users & waiting for your. SQL to clean all pending comments is: DELETE FROM comments WHERE comment_approved = ‘0’

Spam Comments: It is a comment that marked as spam. SQL to clean all spam comments is:
DELETE FROM comments WHERE comment_approved = ‘spam’

Trash comment: A trash comment that you have deleted from your WordPress & have been moved to the trash. SQL  to clean all trash comments is: DELETE FROM comments WHERE comment_approved = ‘trash’

Trackbacks: Trackbacks allows you to notify other websites have linked to their article on your website. These trackbacks is used to send huge amounts of spam. That is why they should be cleaned if you do not use them. The sql query used by the plugin to clean trackbacks is:
DELETE FROM comments WHERE comment_type = ‘trackback’

Pingbacks: Pingbacks allow you to notify other websites owners that you have linked to their article on your website. Trackback is basically the same things as a pingback. These pingbacks can be used to send huge amounts of spam. SQL to clean pingbacks is: DELETE FROM comments WHERE comment_type = ‘pingback’

Orphan post meta: The post meta data includes the author of the post, when it was posted. Sometimes post meta data information becomes orphan & does not belong to any post called “orphan postmeta” & should be cleaned since they are not useful. SQL to clean all orphan postmeta is: DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Orphan comment meta: Orphan comment meta concern comments & not posts. SQL to clean all orphan comment meta is:
DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM comments)

Orphan user meta: The user meta data is the information provide to viewers about each user. This information usually includes additional data that is not stored in the users table. Sometimes user meta data information becomes orphaned are called “orphaned usermeta” . SQL to clean all orphan comment meta is: DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)

Orphan user meta: It includes additional data that is not stored in the terms table and sometimes meta data information becomes orphaned. SQL to clean all orphan comment meta is:
DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms)

Orphan Relationships: Sometimes the wp_term_relationships table becomes bloated with many orphaned relationships. This happens particularly often if you’re using your site not as a blog but as some other type of content site where posts are deleted periodically. Over time, you could get thousand of term relationships for posts that no longer exist which consumes a lot of database space. SQL to clean all orphan relationships is: DELETE FROM term_relationships WHERE term_taxonomy_id=1 & object_id NOT IN (SELECT id FROM posts)

Expired Transients: A way of storing cached data in DB temporarily by giving it a name. Expired transients are expired & still exist in the database.

Advanced Database Cleaner Plugin Benifits

  • Remove old Revisions of posts & pages: WordPress stores a record called revision of each saved draft or published update. This system allows you to see what changes were made in each post and page over time
  • Remove old Auto drafts : WordPress automatically saves your post / page while you are editing it. This is called WordPress auto draft. If you don’t hit the publish/update button, then the post/page will be saved as auto-draft and any modification to your post/page will not be visible in your public site. Over time, you could have multiple auto-drafts that you will never publish and hence you can clean them.
  • Remove trash posts
  • Remove pending comments
  • Remove spam comments
  • Remove trash comments
  • Remove pingbacks
  • Remove trackbacks
  • Remove orphan post metadata
  • Remove orphan comment metadata
  • Remove orphan user metadata
  • Remove orphan term metadata
  • Remove orphan relationships
  • Remove expired transients
  • Display & view orphaned information before making a database clean-up so you can be sure about what you are going to clean-up
  • Schedule database clean up to run automatically
  • Display database tables information such as the number of rows, table size, etc.
  • Optimize database tables
  • Repair corrupted database tables or damaged ones
  • Schedule database optimization &/or reparation to run automatically & specify what tables should be optimized &/or repaired
  • Empty database tables rows
  • Clean & Remove database tables
  • Display options list
  • Display options information such as option name, option value, option size, option autoload
  • Clean & Remove options
  • Set options autoload
  • Clean & Remove scheduled tasks

Plugins Garbage Collector (Database Cleanup)

Some plugins create & use its own database tables. Those tables are left in your database after plugin deletion.

Database Management (Managed WordPress)

Question: What is the user name and password of phpmyadmin

Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”

Question: How to get login credential to upload files?

Answer: You can get that information from the panel > WordPress > managed WordPress > manage > show credentials under “manage database”

Question: My site is very slow and It is difficult to work so can u check?

Answer: Cache is not working currently, ttbx3_options | 26 MB | The optionts able earlier was at 26MB, which is very big. I cleaned it up so it is now 4MB. No, you would need to continually optimize / clean up. The possible plugins that may cache to go down -woodmart-core, woo-order-export-lite, wp-hide-security-enhancer, google-captcha. The possible plugins that may cache to go down.

Would it be okay to toggle these plugins for testing?

Database Management (Shared Hosting)

Question: Currently My Database size is large which is 800 Mb. As far I know my I am able to download upto 500 Mb data from server in my current hosting plan. Since it exceed upto 800 Mb, please help me to download it in File Manager. When download will complete I will download it from File Manager

Question: Today I have copy a database and folder of halal.hadisquran.com to make another sub domain named as boi.hadisquran.com.

At first I rename all url inside of autogar1_halaldp from halal.hadisquran.com to boi.hadisquran.com

After that I configured everything excluding htaccess file. Instead that My newly created subdomain boi.hadisquran.com is not working

Answer: Yes . Also, I’ll be very happy if I can help you with Safeguarding your account from Hackers, malwares etc. We actually have a service where our team of experts help customers all day safeguarding their accounts. The service is called Sitelock, where our specialists will recommend you the exact plan as per your requirements for the website security. So, Could you please let me know your Phone Number and Timezone so that I can ask our Experts to contact you?

Question: Who will be admin on Dedicated and VPS server?

Answer: The Dedicated server is self managed server, so once you purchase it you will be owner of it and you have all access to manage the server (b)

WordPress SQL

  • Change Username: UPDATE wp_users SET user_login = ‘mashiur’ WHERE user_login = ‘admiin’;
SubjectLink
SSH Commandhelp.dreamhost.com/hc/en-us/articles/4404267062164
List of Basic Tableblogvault.net/wordpress-database-schema/
Displays database name and size.developer.wordpress.org/cli/commands/db/size/
Clean Databaseonlinemediamasters.com/clean-wordpress-database/#remove-trash
Clean Database Plugininmotionhosting.com/support/edu/wordpress/plugins/wordpress-advanced-database-cleaner/
Clean Database Plugin (Dh)wordpress.org/plugins/advanced-database-cleaner/
Advance Database Cleaner.youtube.com/watch?v=95kfb3bgRAI
Clean Database (Unused Table)youtube.com/watch?v=2Xg1KOLQOpU
How to Open SQL Query in WPyoutube.com/watch?v=Yv0FDEfUsKw
WP SQL Commandsknownhost.com/wiki/resources/manage-wordpress-posts-using-sql
Database Optimizationsigmaplugin.com

YouTube Video Marketing Tips for Small Businesses

Video Marketing Tips for Small Businesses

Video Marketing Tips for Small Businesses

  • Put a keyword into your YouTube channel name
  • Fill out the About Us page
  • Use channel keyword tags under Advanced Settings
  • Include related tags and hashtags
  • Update your channel trailer
  • Rename your video file using a target keyword.
  • Insert your keyword naturally in the video title.
  • Optimize your video description and write more than 300 characters with keywords
  • Publish long videos
  • Speak Keywords in Your Videos
  • Tag your video with popular keywords that relate to your topic
  • Focus on first 15 seconds of video to maximize watch time
  • Create playlists that enhance watch time
  • Say your keywords in the video
  • Strengthen user interaction signals
  • Categorize your video.
  • Customize video thumbnails
  • Include compelling language in titles and the year in description
  • Use Video Cards and End Screens for added context and SEO value
  • Use an SRT file to add subtitles & closed captions.
  • Embrace live YouTube videos
  • Add hashtags to increase reach.
  • Leave a pinned comment on your own video
  • Encourage Engagement
  • Build Backlinks

Tutorials for Video Marketing Tips for Small Businesses

TopicsLink
Customize YouTube Channel by Sohagyoutube.com/watch?v=rkhgY6uQYWE