Mysql performance

	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]"