Got timeout reading communication packets

[szogun]

Hej od pewnego czasu zmagam się z problemem na vpsie, który dotyczy baz danych, mianowicie po x czasie działania co jakiś czas w logach widnieje (Got timeout reading communication packets)

 

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log

symbolic-links=0
  
skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1024M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

#innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=360
interactive_timeout=360
long_query_time=5

!includedir /etc/mysql/conf.d/

 

[Mesharsky]

Co masz w logach? Pokaż logi.

Ten błąd występuje w wielu przypadkach, najczęściej jest to wait_timeout. Spróbuj zwiększyć na np: 1800.
Pokaż specyfikację serwera, bo same ustawienia mysql nic nie dają.

Im więcej informacji przekażesz, tym na lepszą pomoc możesz liczyć. 

[Mion]

21 godzin temu, szogun napisał:

Hej od pewnego czasu zmagam się z problemem na vpsie,

Sugeruje zatrudnić fachoFca bo takie strzały w ciemno to starta czasu czego kiedyś sam też doświadczyłem.
Od siebie mogę polecić @patryk < sprawdzony w boju

[szogun]

7 godzin temu, Mion napisał:

Sugeruje zatrudnić fachoFca bo takie strzały w ciemno to starta czasu czego kiedyś sam też doświadczyłem.
Od siebie mogę polecić @patryk < sprawdzony w boju

Zatrudniając fachowca nie jest na rękę jak mam nauczyć się wtedy zażądaniem swojej maszyny gdy ktoś za mnie to wykona.

 

13 godzin temu, Mesharsky napisał:

Co masz w logach? Pokaż logi.
 

 

2020-07-09T13:17:59.148457Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for m$
2020-07-09T13:17:59.148604Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with s$
2020-07-09T13:17:59.154885Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30-0ubuntu0.18.04.1) starting as process 2839 ...
2020-07-09T13:17:59.193602Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-07-09T13:17:59.193908Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-07-09T13:17:59.193919Z 0 [Note] InnoDB: Uses event mutexes
2020-07-09T13:17:59.193925Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-07-09T13:17:59.193931Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-09T13:17:59.194211Z 0 [Note] InnoDB: Using Linux native AIO
2020-07-09T13:17:59.195668Z 0 [Note] InnoDB: Number of pools: 1
2020-07-09T13:17:59.196997Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-07-09T13:17:59.210589Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-07-09T13:17:59.256746Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-09T13:17:59.324080Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-07-09T13:17:59.935570Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-07-09T13:18:00.299188Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-09T13:18:00.299290Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-09T13:18:00.739935Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-07-09T13:18:00.741466Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-07-09T13:18:00.741484Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-07-09T13:18:00.748541Z 0 [Note] InnoDB: Waiting for purge to start
2020-07-09T13:18:00.798963Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 8081591580
2020-07-09T13:18:00.816943Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-07-09T13:18:00.817792Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-07-09T13:18:00.977738Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200709 15:18:00
2020-07-09T13:18:01.050689Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-07-09T13:18:01.051057Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-07-09T13:18:01.053426Z 0 [Warning] CA certificate ca.pem is self signed.
2020-07-09T13:18:01.053552Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-07-09T13:18:01.054453Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2020-07-09T13:18:01.056692Z 0 [Note] IPv6 is available.
2020-07-09T13:18:01.056712Z 0 [Note]   - '::' resolves to '::';
2020-07-09T13:18:01.056749Z 0 [Note] Server socket created on IP: '::'.
2020-07-09T13:18:01.406995Z 0 [Note] Event Scheduler: Loaded 0 events
2020-07-09T13:18:01.407647Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.30-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2020-07-09T13:34:05.540667Z 32 [Warning] IP address '145.239.91.62' has been resolved to the host name '62.ip-145-239-91.eu', which resembles IPv4-address itself.
2020-07-09T14:14:14.345216Z 73 [Note] Aborted connection 73 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)
2020-07-09T14:14:21.172253Z 75 [Note] Aborted connection 75 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)
2020-07-09T14:14:21.195903Z 72 [Note] Aborted connection 72 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)
2020-07-09T14:14:23.152501Z 74 [Note] Aborted connection 74 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)
2020-07-09T14:14:33.395273Z 70 [Note] Aborted connection 70 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)
2020-07-09T14:14:48.592982Z 71 [Note] Aborted connection 71 to db: 'xxx' user: 'xxx' host: 'xxx' (Got timeout reading communication packets)

 

13 godzin temu, Mesharsky napisał:

Pokaż specyfikację serwera, bo same ustawienia mysql nic nie dają.

Co dokładnie cie interesuje?