Re: Mysql performance

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:
> 
> 	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
> [email protected]
> _______________________________________________
> [email protected] mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "[email protected]"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQFClf+aKUeW47UGY2kRAlzwAJwLQe/4oOIpGaF1sPVpe+4K3IZIZwCdHWeP
qX4Dhe+uxywdFnOE05Y6+os=
=6QKP
-----END PGP SIGNATURE-----