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

WordPressʻAʻole ikaika wale nā ​​kolamu maʻamau, akā hiki nō hoʻi. Nui nā kumumanaʻo WordPress a me nā plugins e hoʻohana i nā kolamu 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.

hana mākouSEO, e kākau i nā ʻatikala ʻoi aku ma mua o hoʻokahi, inā e holoi lima ʻoe i kēia mau kolamu maʻamau ʻōpala, ʻaʻole pono ia.

ʻOiaʻiʻo, pono wale mākouphpMyAdminE hoʻokō i kahi kauoha SQL e holoi i kēia mau kolamu maʻamau i loko o nā pūʻulu o ka waihona.

Pākuʻi ʻana

No ka hoʻopau ʻana o WordPress i nā kolamu maʻamau i ka nui, pili iaMySQL waihonaka hana, aia 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 ▼

🔗He aha kaʻu e hana ai inā kiʻekiʻe loa ka CPU a me ka hoʻohana ʻana i ka hoʻohana ʻana i ka pūnaewele WordPress?