HomeWordpress

WordPress Database Optimize (Cleanup) Kaise Kare?

Like Tweet Pin it Share Share Email

optimize database

Kya aap apni wordpress site ke database ko regular optimize karte hain?




Yaha optimization ka matlab hai apni website ke databse ko completely junk free rakh kar site ki performance ko improve karna.

Read: WordPress site ki speed ko boost kaise kare?

Kya aap apna Database regular interval par clean karke optimize karte hain?

Agar nahi to aaj se karna start kar de, kyunki yah bahut jaruri hai, site ki speed aur performance ke liye.

Kyu Jaruri Hai Database (clean) optimize karna?

Aapke computer par Internet access karne se kayi tarah ki junk files store ho jaati hain, bus kuch usi tarah se wordpress me database me kayi tarah ki junk files store ho jati hain.




WordPress ki database file me aapki posts, pages, comments, plugin and theme ki settings save rahti hain.

Yah bahut is important file hoti hai aur isko optimize karna bahut jaruri hai kyun ki kayi unwanted data usme store hota rahta hai, see below:-

  • Post Revisions: Aap baar-baar post ko edit karte hain tab post revisions add hote rahte hain aur iska load database file par padta hai. Aise unwanted post revisions delete karna jaruri hota hai.
  • Spam comments: Spam comments ka data bhi aapko delete karna bahut jaruri hota hai. Yah site ki performance ke liye theek nahi hai.
  • Trashed pages and post: Aapne kayi trash posts and pages ki list save kar rakhi hai to wo bhi remove karna jaruri hai.
  • Deleted plugins data: Plugins Delete karne ke baad uske data ka kya kaam? wo bhi aapko remove karna jaruri hai.
  • Database table: Database table me kayi baar common issues ho jate hain, aise me tables ko regular optimize karna jaruri hai.

Ab aapko pata chal gaya hoga ki kyu regular database ko clean rakhna jaroori hai.

To ab hum wordpress par available 2 sabse best plugins ke bare me baat karenge jo Database ko completely clean aur optimize rakhti hain.

Ye dono plugins wordpress par free available hain aur sabse popular and most installs plugin hain.

Ok, to ab hum apni Database ko clean up karenge. Let’s see:

1. Optimize Database With WP-sweep plugin

20,000+ install and best rating ke sath WP -sweep sabse best plugin hai databse ko clean aur optimize karne ke liye.




Sabse pahle aapko WP Sweep plugin ko install karna hai, Install karne ke liye Plugins » Add New par click kare, Now search wp sweep and click Install, after that Activate plugin

wp sweep plugin

Plugin install and Activate karne ke baad aapko apne Dashboard panel par Tools » Sweep par click karna hai.

Sweep par click karne ke baad yah plugin aapke Database ko Analyze karegi aur screen par Report show karega ki aapko kya-kya clean karna hai. Report me aapko different section show karenge like post, comment, term, user etc.

sweep database wordpress

Aap chahe to one-by-one section ko Sweep par click karke clean kar sakte hain aur agar aapko single click me sab-kuch delete karna hai to Sweep All par click kar sakte hain.




Kuch hi seconds me unwanted data clean ho jayega.

Main aapko Database clean up karne ke liye WP Sweep plugin hi suggest karunga kyunki yah advanced work karti hai compare to others and trusted developer ne create ki hai. Aap is plugin se aap below data clean kar sakte hain:-

  • Revisions
  • Auto drafts
  • Deleted comments
  • Unapproved comments
  • Spammed comments
  • Deleted comments
  • Orphaned post meta
  • Orphaned comment meta
  • Orphaned user meta
  • Orphaned term meta
  • Orphan term relationships
  • Unused terms
  • Duplicated post meta
  • Duplicated comment meta
  • Duplicated user meta
  • Duplicated term meta
  • Transient options
  • Optimizes database tables
  • oEmbed caches in post meta

2. Optimize Database using WP-optimize

500,000+ install and best rating ke sath yah second sabse best plugin hai jo aap use kar sakte hain.

Sabse pahle plugin ko install kare, Plugins » Add New par click kare aur WP-optimize search karke install aur activate kare.

wp optimize

Plugin ko install and activate karne ke baad aap isko dashboard option me dekh sakte hain.




  • Wp-optimize par click aur open kare.
  • Clean-up options me Post revisions, auto draft post, spam comment, unapproved comment select kare
  • Actions me Optimize database tables ko select kare
  • Ab Processpar click kare
  • Done!

wp optimize database

To kuch is tarah se aap apna Database clean aur optimize kar sakte hain.

Aap kisi bhi plugin ka use kar sakte hain. Dono best hain.

Read also:

Comments (2)

  • Eske Alawa Or Kya-Kya Daily Clean Karna Jaruri Hota Hai.

    Reply
    • Author

      hello gaurav,
      Iske alawa aapko jo deactivated plugins hai wo complete delete karna jaruri hai.
      Database clean up karne se kafi improvement aapki website me aa jata hai. Theek waise hi jaise computer par temporary files delete karne se.
      Wordpress ko Speed up karne ke liye ye article aap read kar sakte hain.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *