From owner-freebsd-database@freebsd.org Wed Sep 30 18:19:11 2020 Return-Path: Delivered-To: freebsd-database@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 5AA6442D8C4 for ; Wed, 30 Sep 2020 18:19:11 +0000 (UTC) (envelope-from cristian.cardoso11@gmail.com) Received: from mail-ed1-x52e.google.com (mail-ed1-x52e.google.com [IPv6:2a00:1450:4864:20::52e]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4C1kzf47ZDz4cFh for ; Wed, 30 Sep 2020 18:19:10 +0000 (UTC) (envelope-from cristian.cardoso11@gmail.com) Received: by mail-ed1-x52e.google.com with SMTP id j2so2887243eds.9 for ; Wed, 30 Sep 2020 11:19:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=gBKKnkRtNQV/wkJU4MIhKyO0GTEj/XYlMypZMbzoAjU=; b=tSvPRoWG57r07PJr2gX0PsSPnqZR+uiopoAXQTQJsEE4dm2VlpGkJIV1IR4VVasQyj LM9TUyy76oa7jxi0xNGS5ORR6JVUjlYJIylVYyHmfMGXMcMlvc8xhv9cEJ+jz5x4uEf3 XG86CTYuElRVJbIQsYA+P5eKkouwHoKt1gM9n4DMljP3LGWzhr9rHTZDCiloRfhCwWnI iqSmrijqWMD+6ZeYwwl0dLTi/ZKsc4fFdObJfSJXByrE3dyXSOJDHdC6UN+ZRvkMySrH shC0PzFyNoTCjph209yM4MXFaLgSdBHJa/FSFMTm1kedEGeHsCt7+tOW5XEP8kJM8i/x fosg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=gBKKnkRtNQV/wkJU4MIhKyO0GTEj/XYlMypZMbzoAjU=; b=k/zAca7xzAs9GdbRqJ1iOoexZ4X4EJUnrZAswyp4a79SNYDWSuL0e7+D2ClTRTyXsp H/TucOkMivEsIs2ZO0wHrXNJTsTpzSWQeAMallvSmXpmxwQ07E/d5aOuC2ekgUTCIPlW qZMYLNzsdbrxarFgmj7r9COH9/LE+FhYZEHzSvefTSGnB+2q8FRHQUpbzzZ4hgvEPfcV HaoiB+hY2Va4iDnlsUoWWgJ1VDGwLfZTYIjDVynjpd4t0dATHtzm4ZYExrnvMFaph8LX h/LjFmH1v/lEJvsl0//pWNdrKW5dNZuLwAxvJjJ/SxvarfZcW6tfrWM9bq91NAzEs0qY h05A== X-Gm-Message-State: AOAM533cudmJHYqjxoBVQ1rLZPEhnxzmf5yHMVNTCYcMdAh9vOHuMitD mCQoNzBR5L/USk5pxbKrwnp+o3oa0WoXPXvRiZuYGQwIT85Q X-Google-Smtp-Source: ABdhPJzUcxNOty1EOWq7msFfQJ/mMb+Mh/OwCBDcUM/cftL9ERf2m+toNEJ3XrPYDDcfWcJLuTWeKL4vm0OOFlxqXsk= X-Received: by 2002:a50:fe82:: with SMTP id d2mr4054137edt.86.1601489947660; Wed, 30 Sep 2020 11:19:07 -0700 (PDT) MIME-Version: 1.0 From: Cristian Cardoso Date: Wed, 30 Sep 2020 15:18:57 -0300 Message-ID: Subject: Mysql Swap To: freebsd-database@freebsd.org Content-Type: text/plain; charset="UTF-8" X-Rspamd-Queue-Id: 4C1kzf47ZDz4cFh X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=tSvPRoWG; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of cristiancardoso11@gmail.com designates 2a00:1450:4864:20::52e as permitted sender) smtp.mailfrom=cristiancardoso11@gmail.com X-Spamd-Result: default: False [-3.09 / 15.00]; RCVD_TLS_ALL(0.00)[]; ARC_NA(0.00)[]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; NEURAL_HAM_MEDIUM(-1.02)[-1.021]; FROM_HAS_DN(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_ALL(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; TO_DN_NONE(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; NEURAL_HAM_LONG(-0.98)[-0.982]; R_SPF_ALLOW(-0.20)[+ip6:2a00:1450:4000::/36]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; RCVD_IN_DNSWL_NONE(0.00)[2a00:1450:4864:20::52e:from]; NEURAL_HAM_SHORT(-0.09)[-0.089]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[]; MAILMAN_DEST(0.00)[freebsd-database]; RCVD_COUNT_TWO(0.00)[2] X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 30 Sep 2020 18:19:11 -0000 Hi I would like to know if anyone happens to have problems with swap consumption with Mysql. Here I run Mysql 5.7.30 on a FreeBSD 12.1 and over time, even with memory left, Mysql consumes all the swap, this consumption is normalized after the service restart. I already ran the mysql-tuner to see if it solved, but without success, even analyzing queries, the service with 8G of ram left over, over time ends the swap.