Pehea e hoʻopau nui ai i nā ʻāpana / kahua / domain WordPress?

ʻAʻole wale ka mana o ka hiʻohiʻona mahele maʻamau o WordPress akā he mea pono loa hoʻi, a he nui nā kumumanaʻo WordPress a me nā plugins e hoʻohana i nā mahele maʻamau e hoʻokō i nā hana like ʻole.

ʻO ka plugin view statistics plugin WP-PostViews a mākou e hoʻohana ai e kākau i nā kolamu maʻamau i ka waihona ▼

views

Hoʻohana ʻia nā kumumanaʻo wordpress a i ʻole plugins, ma hope o ka hoʻopau ʻana a me ka holoi ʻana, mālama mau i kā lākou mau kahua maʻamau i ka waihona.

Inā nui ka nui o ka ʻikepili, i kēlā me kēia manawa e nīnau ai ka pūnaewele i ka waihona, e hoʻopau ia i ka hoʻomanaʻo RAM o ka mea hoʻokipa, e hoʻopilikia maoli i ka hana maʻamau o ka pūnaewele.

Ke hana mākou i ka SEO , kākau mākou ma mua o hoʻokahi ʻatikala. ʻO ka holoi lima ʻana i kēia mau māhele maʻamau junk he mea paʻakikī loa ia.

ʻO kaʻoiaʻiʻo, pono mākou e hoʻokō i hoʻokahi kauoha SQL ma phpMyAdmin e holoi i kēia mau kolamu maʻamau junk ma nā ʻāpana mai ka waihona ʻikepili.

Pākuʻi ʻana

ʻO ka holoi ʻana i nā māhele maʻamau i ka nui ma WordPress e pili ana i nā hana ma kahi waihona ʻikepili MySQL , kahi e halihali ai i kekahi mau pilikia.

No laila, e mālama pono i ka waihona waihona ma mua o ka hiki iā ʻoe ke hana i nā hana ʻikepili.

Ka Papa Hana 1: Holoi i nā kolamu maʻamau me nā kauoha ʻikepili (manaʻo ʻia)

1) Ma hope o kou komo ʻana i ka waihona phpMyAdmin, koho i kāu waihona.

2) Kaomi ma ka "SQL" ma luna o ka waihona.

3) E komo a hoʻokō i kēia mau kauoha ma "SQL":

DELETE FROM wp_postmeta WHERE meta_key = "自定义栏目名称";

4) A laila, e nānā i ka ʻāpana maʻamau i kāu ʻatikala pūnaewele e hōʻoia inā ua hoʻopau maikaʻi ʻia.

Hana 2: PHP code e holoi i nā kolamu maʻamau

1) E ʻoluʻolu e hoʻohui i kēia code i ka faila functions.php o ke kumuhana o kēia manawa ▼

global $wpdb;
$wpdb->query( "
DELETE FROM $wpdb->postmeta
WHERE `meta_key` = '栏目名称'
" );

2) Hoʻololi i ka "Column Name" i ke kolamu maʻamau āu e makemake ai e holoi.

  • E holoi ʻia ke kolamu maʻamau mai ka waihona.

3) Hoʻohana wale ʻia kēia code inā pono:

  • E holoi pono ma hope o ka pau ʻana o ka hana holoi.
  • Inā makemake ʻoe e hoʻohana iā ia i ka manawa aʻe, e ʻoluʻolu e hoʻohui iā ia i ka faila functions.php o ke kumuhana o kēia manawa,
  • No ka mea pono e hoʻohui a holoi ʻia, ʻoi aku ka paʻakikī, no laila ʻaʻole ʻōlelo ʻia.

Holoi i nā moʻolelo postmeta pono ʻole

Ua holoi ʻia paha ka moʻolelo moʻolelo, akā ʻaʻole i holoi ʻia ka ʻikepili i ka papa kuhikuhi log extension postmeta, no laila ua holoi lima ʻia.

1) Ma hope o kou komo ʻana i ka waihona phpMyAdmin, koho i kāu waihona.

2) Kaomi ma ka "SQL" ma luna o ka waihona.

3) E komo a hoʻokō i kēia kauoha ma "SQL" ▼

DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Inā kiʻekiʻe loa kāu pūnaewele WordPress, CPU, hoʻomanaʻo MEMORY ...

No ka hoʻonā, e ʻoluʻolu e nānā i kēia kumu aʻo ▼

 

评论

您的邮箱地址不会被公开。必填项已用*标注

Pepa la i ka luna