Date: Thu, 26 May 2005 12:55:55 -0400 From: Anthony Schneider <anthony@x-anthony.com> To: Mialon Pierre-Gilles <pierre-gilles@netaktiv.com> Cc: freebsd-database@freebsd.org Subject: Re: Mysql performance Message-ID: <20050526165555.GA30296@x-anthony.com> In-Reply-To: <200505261845.58035.pierre-gilles@netaktiv.com> References: <200505261845.58035.pierre-gilles@netaktiv.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--rwEMma7ioTxnRzrJ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable are you maybe missing some inndexes? and, though i haven't used mysql in a while, i don't think that they have out-of-the-box smp parallelization. -Anthony. On Thu, May 26, 2005 at 06:45:57PM +0200, Mialon Pierre-Gilles wrote: >=20 > Hi, >=20 > 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=20 > /usr/local/libexec/mysqld running in ps aux. > And I'm looking for a good tutorial to speed up the mysql-server on a Fre= eBSD=20 > box.=20 >=20 > The output is the content of mysql query slow... Horrible !!!=20 > # User@Host:=20 > # Query_time: 837 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 > SET timestamp=3D1117125449; > SELECT=20 > articles.id_article,articles.id_rubrique,articles.id_secteur,articles.sur= titre,articles.titre,articles.soustitre,articles.date,articles.date_redac,a= rticles.date_modif,articles.visites,articles.popularite,articles.statut,art= icles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article= =20 > * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles = AS=20 > articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE=20 > articles.id_article=3Dlien_mot.id_article AND lien_mot.id_mot=3Dmots.id_m= ot AND=20 > mots.titre=3D'Bandeau' AND articles.statut=3D'publie' GROUP BY=20 > articles.id_article ORDER BY alea LIMIT 0,1; > # Time: 050526 18:37:31 > # User@Host:=20 > # Query_time: 798 Lock_time: 0 Rows_sent: 1 Rows_examined: 454060 > SET timestamp=3D1117125451; > SELECT=20 > articles.id_article,articles.id_rubrique,articles.id_secteur,articles.sur= titre,articles.titre,articles.soustitre,articles.date,articles.date_redac,a= rticles.date_modif,articles.visites,articles.popularite,articles.statut,art= icles.accepter_forum,articles.lang,articles.id_trad,MOD(articles.id_article= =20 > * UNIX_TIMESTAMP(), 32767) & UNIX_TIMESTAMP() AS alea FROM spip_articles = AS=20 > articles,spip_mots_articles AS lien_mot,spip_mots AS mots WHERE=20 > articles.id_article=3Dlien_mot.id_article AND lien_mot.id_mot=3Dmots.id_m= ot AND=20 > mots.titre=3D'Bandeau' AND articles.statut=3D'publie' GROUP BY=20 > articles.id_article ORDER BY alea LIMIT 0,1; >=20 > --=20 > Pierre-Gilles Mialon > mialon@netaktiv.com > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.or= g" --rwEMma7ioTxnRzrJ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFClf+aKUeW47UGY2kRAlzwAJwLQe/4oOIpGaF1sPVpe+4K3IZIZwCdHWeP qX4Dhe+uxywdFnOE05Y6+os= =6QKP -----END PGP SIGNATURE----- --rwEMma7ioTxnRzrJ--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050526165555.GA30296>