E faʻafefea ona faʻaputuina le tele o vaega o le WordPress Custom Sections / Fields / Domains?

WordPressE le gata ina malosi le koluma masani, ae e matua aoga foi.O le tele o autu o WordPress ma plug-ins e faʻaogaina koluma masani e faʻatino ai galuega eseese.

O loʻo vaʻaia e le tusiga fuainumera faʻapipiʻi WP-PostViews matou te faʻaaogaina o le tusia lea o koluma masani i totonu o le database ▼

views

O autu faʻaoga WordPress poʻo faʻapipiʻi e masani ona taofi a latou koluma masani i totonu o faʻamaumauga pe a uma ona faʻagata ma tape.

Afai o le aofaʻi o faʻamatalaga e tele, o taimi uma lava e fesiligia ai e le upega tafaʻilagi le faʻamaumauga, o le a faʻaumatia ai le mafaufau RAM a le talimalo, lea e mautinoa lava e aʻafia ai le faʻagaioiga masani o le upega tafaʻilagi.

matou te faiaSeo, tusia ni tala e sili atu ma le tasi, ma e matua faigata lava ona tape ma le lima nei koluma masani leaga.

O le mea moni, e na'o tatou mana'omiaphpMyAdminE ala i le faʻatinoina o se faʻatonuga SQL, o nei koluma masani masani e mafai ona tapeina i vaega mai le faʻamaumauga.

Lapataiga

Talu ai o le WordPress batch e tapeina koluma masani, e aofia aiMySQL databaseO le taotoga e aofia ai ni tulaga lamatia.

Ole mea lea, fa'amolemole ia mautinoa e fai se fa'amaumauga fa'amaumauga a'o le'i faia fa'agaioiga fa'amaumauga.

Metotia 1: Fa'atonuga o fa'amaumauga e tape ai koluma fa'ale-aganu'u ua tele (fautua)

1) A maeʻa ona e ulufale i totonu o le phpMyAdmin database, filifili lau faʻamaumauga.

2) Kiliki "SQL" i luga aʻe o faʻamaumauga.

3) Ulufale ma faʻatino le poloaiga lenei i le "SQL":

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

4) Ona, siaki le koluma masani i lau 'upega tafaʻilagi tusiga e faʻamaonia pe ua soloia manuia.

Metotia 2: PHP code e tape ai koluma masani masani

1) Fa'amolemole fa'aopoopo le code lea i le faila functions.php o le autu o lo'o iai nei ▼

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

2) Suia le "igoa koluma" i le koluma masani e te manaʻo e tape.

• O lenei koluma masani o le a otometi lava ona kilia mai le database.

3) O lenei code e faʻaaogaina pe a manaʻomia:

• Faamolemole ia mautinoa e tapeina pe a uma le galuega tapeina.
• Afai e te mana'o e fa'aoga i le isi taimi, fa'amolemole fa'aopoopo i le faila functions.php o le autu o lo'o iai nei.
• Ona e manaʻomia ona faʻaopoopo ma tape, e fai lava si faʻalavelave, o lea e le fautuaina.

Aveese faʻamaumauga postmeta le aoga

O faʻamaumauga o ogalaau atonu na tapeina, ae o faʻamaumauga i le log extension table postmeta e leʻi tapeina, o lea e mafai ai ona kilia ma le lima.

1) A maeʻa ona e ulufale i totonu o le phpMyAdmin database, filifili lau faʻamaumauga.

2) Kiliki "SQL" i luga aʻe o faʻamaumauga.

3) Ulufale ma faʻatino le poloaiga lenei i le "SQL" ▼

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

Afai e maualuga tele le CPU o lau upega tafaʻilagi WordPress ma le faʻaogaina o mafaufauga ...

Fa'amolemole tagai ile a'oa'oga lea mo le fofo▼

O le a le mea e tatau ona ou faia pe a maualuga tele le CPU ma le faʻaogaina o le faʻaogaina o le upega tafaʻilagi a WordPress?

O le a le mea e tatau ona ou faia pe a maualuga tele le CPU ma le faʻaogaina o le faʻaogaina o le upega tafaʻilagi a WordPress? 1) Siaki cron timing galuega Afai lava o le PPU ma le MEMORY o le upega tafaʻilagi a WordPress e sili atu le mamafa, e tatau ona faʻapipiʻi ma faʻaoga le WP Crontrol plugin.Siaki i "Meafaigaluega" → "WP-Cron Events"...