Mysql performance

[Anthony Schneider]

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 at 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 at 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 at netaktiv.com
> _______________________________________________
> freebsd-database at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-database
> To unsubscribe, send any mail to "freebsd-database-unsubscribe at freebsd.org"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-database/attachments/20050526/fb03013f/attachment.bin