From owner-freebsd-questions@FreeBSD.ORG Wed May 22 13:52:46 2013 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id 133FD23B for ; Wed, 22 May 2013 13:52:46 +0000 (UTC) (envelope-from aimass@yabarana.com) Received: from mail-pb0-x235.google.com (mail-pb0-x235.google.com [IPv6:2607:f8b0:400e:c01::235]) by mx1.freebsd.org (Postfix) with ESMTP id EA183276 for ; Wed, 22 May 2013 13:52:45 +0000 (UTC) Received: by mail-pb0-f53.google.com with SMTP id un4so1717514pbc.12 for ; Wed, 22 May 2013 06:52:45 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type :x-gm-message-state; bh=/m1FwlL4YTz6Th2t07pTTetjIlZK4eOHfJPUuCOJZAw=; b=CJdiaDBQ6V3LepQGiWqTU3gFM2IV+jLWL9bRjwkcz3RZ3c3qv7w/cYwD32QBwBBhUS 0DpqyMR5GGTUs6kSC2Dvj9RvixWbCAv1K9fW2Aj2fd28FMI+k3khcH/bD+0VAb25NBrX A+L2uZmenzVJJnzMt3WCi1zbKYMEx/ONZGC9SZvzw9zcxo6n1h4+QeAcLrtoEomhTPqz AK1yDqdLxdOtNEvsbSg5CEtzVixpspv6loE0I8HQbMbSHsCJvekunMXr8wLq0dxfMPMd NXn24XqK+S3DA+nIFWPnJDi0BTOWCXJ2uwozwJnetZewr+JK2JsE8UqYGr0hd6OrlIT0 KJqw== MIME-Version: 1.0 X-Received: by 10.68.224.104 with SMTP id rb8mr7822807pbc.206.1369230765422; Wed, 22 May 2013 06:52:45 -0700 (PDT) Received: by 10.66.8.1 with HTTP; Wed, 22 May 2013 06:52:45 -0700 (PDT) Date: Wed, 22 May 2013 09:52:45 -0400 Message-ID: Subject: MySQL hangs server completely From: Alejandro Imass To: FreeBSD Questions Content-Type: text/plain; charset=ISO-8859-1 X-Gm-Message-State: ALoCoQmo99lYXFgXEeLQa4toiIdBgJbpEPR8gjxqbDpR2BrEb82DAZUZgo+Lxg8K9R6JqZEd+USr X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 22 May 2013 13:52:46 -0000 Hi, We've been having this problem with a customer for a while and it seems that some funky query makes MySQL use 100% of CPU. Nevertheless, even though you can see in top that it's only 1 CPU in 100% (out of 8) the server eventually becomes useless and stops responding completely. So my question is, how does a user process hang the whole server? What system resources could MySQL be draining to make the server stop responding completely? The MySQL database is running inside a Jail and perhaps that could help limit the damage it can cause. Has anyone else run into this problem? Thanks, -- Alejandro Imass