Re: Tuning MySQL Server Parameter

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Qunfeng Dong wrote:

Thanks! I copied
/usr/share/doc/mysql-server-3.23.49/my-huge.cnf into
/etc/my.cnf and restarted mysqld from
/etc/rc.d/init.d/mysqld

but it's not improving anything. my join query is very simple

select count(B.columnb) from B left join A on

B.columnb = A.columna.

What does 'EXPLAIN select count(B.columnb) from B left join A on B.columnb = A.columna' say?

Maybe your query is not using indexes for some reason?!

-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE98UKCtvXNTca6JD8RAsvXAKCDkJnkhTcDg7r6pLHRZ5nNEKN81ACgqr+Z
S62fWVXyFkzZpJyleVUpd/8=
=6O0j
-----END PGP SIGNATURE-----


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php