Isexwayiso sephutha le-WordPress: Iphutha ngenkathi kuthunyelwa iphakethe le-QUERY

Iphutha lombuzo we-PHP Iphutha ngenkathi kuthunyelwa iphakethe le-QUERY. PID=xxx

WordPressLapho iwebhusayithi ibuyekeza i-athikili, umlayezo wephutha olandelayo ungase uvele ▼ 

Warning: Error while sending QUERY packet. PID=13691 in /home/用户名/域名/public_html/wp-includes/wp-db.php on line 1942

• Le nkinga ihlobene neLinuxukucushwa kweseva, kukhonaEzentengiselwanoabantu abasebenzisaVestaCPNginale nkinga ngemva kwephaneli.
• Lokhu ukucushwa okuzenzakalelayo kwephaneli ye-VestaCPMySQLKukhona umkhawulo kusayizi wedatha.
• Ukuze ulungise lokhu, shintsha ipharamitha yephakethe lakho elikhulu_elivunyelwe.

Isixazululo

Ungakwazi ukuxazulula le nkinga ngokushesha ngokulandela lezi zinyathelo:

Isinyathelo sesi-1:Vula i-SFTP软件

Isinyathelo sesi-2:Hlela ifayela le-my.cnf ▼

/etc/my.cnf

ikhona[I-MYSQLD] isigaba, engeza noma lungisa amapharamitha alandelayo ▼

max_allowed_packet=524288000
wait_timeout = 100

Isinyathelo sesi-3:Qala kabusha isevisi ye-MySQL

Qala kabusha isevisi yakho ye-MySQL ngokufaka umyalo olandelayo nge-SSH ▼

service mysqld restart

Uma usebenzisa imininingwane egciniwe kaMariadb, sicela usebenzise umyalo olandelayo ukuze uqale kabusha isizindalwazi sikaMariadb ▼

service mariadb restart

Isinyathelo sesi-4:ngena eyakhoI-PHPMyAdminUkuphathwa kwesizindalwazi esibonakalayo.

Isinyathelo sesi-5:I-SQL yenza umyalo

Chofoza u-"SQL" bese ufaka umyalo olandelayo ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Chofoza "Khipha" ▼

希望U-Chen WeiliangIndlela yokwabelana ngebhulogi, ingakusiza ukuxazululaMySQL databaseUmbuzo wephutha lombuzo ^_^