From owner-freebsd-database@freebsd.org Wed Sep 30 21:04:30 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 58EBB430B6F for ; Wed, 30 Sep 2020 21:04:30 +0000 (UTC) (envelope-from xxjack12xx@gmail.com) Received: from mail-qv1-xf33.google.com (mail-qv1-xf33.google.com [IPv6:2607:f8b0:4864:20::f33]) (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 4C1pfP2hRPz3Y1N for ; Wed, 30 Sep 2020 21:04:29 +0000 (UTC) (envelope-from xxjack12xx@gmail.com) Received: by mail-qv1-xf33.google.com with SMTP id z18so1709135qvp.6 for ; Wed, 30 Sep 2020 14:04:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=Gw+vm02IrFZS7js15yozDLQOQki3nqHRewDG8wOxQtM=; b=WDUVw+SJ9Kn+b2BrrzjWbkVxAy2TeL54DOY2I3rNORLCsn9KxvF0sH898ZPVBxCN+5 MYxyctPg8526RzwUqmPWkInUVA2oYdfe4mgfYMF9sZJw3Q7ivw0uhdKerPejDEfLStTt +PQLytVDxqP+1VhKKbHArQi2x7W36fnsDNTPGCGzHfzHmI244gv6U39qyIcizpQIRt+X Jn1Rve4cx74JPbkae7gaFZ5wKaA8UeYhYxoZ+aL7Z4oIrGnvSP+Netp3rpozs1gdrZ0g AKyXEuhVk2F0LdJC4lsZCC6tABEAtSHnx+bB7Xc75rp5bELxsWG5djkF2zEz5pyzNibI 4pPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=Gw+vm02IrFZS7js15yozDLQOQki3nqHRewDG8wOxQtM=; b=Xz5GF9uOlHxKsVjEfIEjYycuQBtm3KJjia3O0etSikKMayUYvqgrBhYNv/A+fX+G3y LKLkdUP9V4yU7GntJfX24B1VhRppirJ5O02iq32kvG1O6lgRq1lu1tOEFVdhxeSINMX6 mgd9UTVN8EPEOVOaYVRxGfwo4v8nrKaTZ6VOvuP6nRNWQUf5hVf58diko21b85JXjP6L cx7d/r8XIYgDgWxraMyMkvUWmDBw8KAX3GdW+4SxV1zv9o/T5pzZcGUI+0YA9Fv7ykMV Oov/rrsFZ9ioB/o5sUEAx8lUxPJgMN4wUczYAW1zM9CSRRIC0XXqMWpvRUYPyQQS6zE1 +oVw== X-Gm-Message-State: AOAM531a2lRrRjxb/CLBAc6QuWl60R0AeBsZ+hbpLC4fqz10Ml4jYfB7 Wp6G45nBnc3afC++OEebT39c6fbURusb/J6MmFg= X-Google-Smtp-Source: ABdhPJzmPE3IDfJ8eL0RXvSgP/zijaOLvazSfIbjAr9mK0eZAU6lSRppjnzxzOF1kSgFC5FgnrwsRfdWr1YUalGy1yc= X-Received: by 2002:a0c:b410:: with SMTP id u16mr4520036qve.52.1601499868318; Wed, 30 Sep 2020 14:04:28 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Jack L." Date: Wed, 30 Sep 2020 14:03:52 -0700 Message-ID: Subject: Re: Mysql Swap To: Cristian Cardoso Cc: freebsd-database@freebsd.org Content-Type: text/plain; charset="UTF-8" X-Rspamd-Queue-Id: 4C1pfP2hRPz3Y1N X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=WDUVw+SJ; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of xxjack12xx@gmail.com designates 2607:f8b0:4864:20::f33 as permitted sender) smtp.mailfrom=xxjack12xx@gmail.com X-Spamd-Result: default: False [-3.54 / 15.00]; TO_DN_SOME(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; DKIM_TRACE(0.00)[gmail.com:+]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; NEURAL_HAM_SHORT(-0.53)[-0.526]; FREEMAIL_TO(0.00)[gmail.com]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.03)[-1.027]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; NEURAL_HAM_LONG(-0.98)[-0.983]; TAGGED_RCPT(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-database@freebsd.org]; TO_MATCH_ENVRCPT_SOME(0.00)[]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::f33:from]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[]; MAILMAN_DEST(0.00)[freebsd-database] 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 21:04:30 -0000 That shouldn't happen if mysql is tuned properly. Each connection uses RAM configured in your buffer settings so if you have a lot of connections with high buffer configs, it can use too much RAM. On Wed, Sep 30, 2020 at 11:19 AM Cristian Cardoso wrote: > > 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. > _______________________________________________ > freebsd-database@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org"