From owner-freebsd-database@FreeBSD.ORG Thu May 26 16:46:06 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 1F47A16A41C for ; Thu, 26 May 2005 16:46:06 +0000 (GMT) (envelope-from pierre-gilles@netaktiv.com) Received: from aragon.netaktiv.com (ns3.netaktiv.com [62.212.103.139]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5695643D53 for ; Thu, 26 May 2005 16:46:04 +0000 (GMT) (envelope-from pierre-gilles@netaktiv.com) Received: from localhost (localhost [127.0.0.1]) by aragon.netaktiv.com (Postfix) with ESMTP id 3A3CF426F3 for ; Thu, 26 May 2005 18:46:02 +0200 (CEST) Received: from aragon.netaktiv.com ([127.0.0.1]) by localhost (aragon [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24026-24 for ; Thu, 26 May 2005 18:45:59 +0200 (CEST) Received: from laika (laika [172.21.0.3]) by aragon.netaktiv.com (Postfix) with ESMTP id 39111426ED for ; Thu, 26 May 2005 18:45:59 +0200 (CEST) From: Mialon Pierre-Gilles Organization: NetAktiv To: freebsd-database@freebsd.org Date: Thu, 26 May 2005 18:45:57 +0200 User-Agent: KMail/1.8 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200505261845.58035.pierre-gilles@netaktiv.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at aragon.netaktiv.com Subject: Mysql performance X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 May 2005 16:46:06 -0000 Hi, I run mysql on a dual-opteron with 2Go of Ram. I don't use the linuxthread. I use the mysql-server-4.1.10a on FreeBSD 5.3 AMD64 I don't understand why I have only one /usr/local/libexec/mysqld running in ps aux. And I'm looking for a good tutorial to speed up the mysql-server on a FreeBSD box. The output is the content of mysql query slow... Horrible !!! # User@Host: # Query_time: 837 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 SET timestamp=1117125449; SELECT articles.id_article,articles.id_rubrique,articles.id_secteur,articles.surtitre,articles.titre,articles.soustitre,articles.date,articles.date_redac,articles.date_modif,articles.visites,articles.popularite,articles.statut,articles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles AS articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE articles.id_article=lien_mot.id_article AND lien_mot.id_mot=mots.id_mot AND mots.titre='Bandeau' AND articles.statut='publie' GROUP BY articles.id_article ORDER BY alea LIMIT 0,1; # Time: 050526 18:37:31 # User@Host: # Query_time: 798 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 SET timestamp=1117125451; SELECT articles.id_article,articles.id_rubrique,articles.id_secteur,articles.surtitre,articles.titre,articles.soustitre,articles.date,articles.date_redac,articles.date_modif,articles.visites,articles.popularite,articles.statut,articles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles AS articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE articles.id_article=lien_mot.id_article AND lien_mot.id_mot=mots.id_mot AND mots.titre='Bandeau' AND articles.statut='publie' GROUP BY articles.id_article ORDER BY alea LIMIT 0,1; -- Pierre-Gilles Mialon mialon@netaktiv.com