Gadzirisa WordPress kukanganisa Yambiro: Kanganiso paunenge uchitumira QUERY packet

PHP Yakanganisa pakutumira QUERY packet PID=xxx

WordPressKana iyo webhusaiti inogadziridza chinyorwa, inotevera mhosho meseji inogona kuoneka ▼ 

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

• Dambudziko iri rine chekuita neLinuxserver configuration, paneE-commercevanhu vanoshandisaVestaCPNdine dambudziko iri mushure mechikamu.
• Uku ndiko kumisikidzwa kweiyo VestaCP paniMySQLPane muganhu kune saizi yedata.
• Kugadzirisa izvi, shandura yako max_allowed_packet parameter.

Solution

Unogona kugadzirisa nyaya iyi nekukurumidza nekutevera matanho aya:

Chikamu 1 步:Vhura SFTP软件

Chikamu 2 步:Rongedza my.cnf file ▼

/etc/my.cnf

zviripo[MySQLD] chikamu, wedzera kana gadzirisa zvinotevera paramita ▼

max_allowed_packet=524288000
wait_timeout = 100

Chikamu 3 步:Tangazve iyo MySQL sevhisi

Tangazve yako MySQL sevhisi nekuisa unotevera kuraira kuburikidza neSSH ▼

service mysqld restart

Kana uchishandisa Mariadb dhatabhesi, ndapota shandisa unotevera kuraira kuti utangezve Mariadb dhatabhesi ▼

service mariadb restart

Chikamu 4 步:login yakoPHPMyAdminDatabase management interface.

Chikamu 5 步:SQL ita murairo

Dzvanya "SQL" uye isa murairo unotevera ▼

SHOW VARIABLES LIKE 'max_allowed_packet'

• Dzvanya "Execute" ▼

TariroChen WeiliangBlog yekugovera nzira, inogona kukubatsira kugadzirisaMySQL databaseMubvunzo wemhosho ^_^