-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 le
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.
Both columna and columnb are v
On Friday 06 December 2002 01:11, Qunfeng Dong wrote:
> Hi,
>
> I wish to tune our MySQL Server Parameter to increase
> the speed of Join. I was trying to do a simple join
> with two tables. One is big (~2,500,000 records); the
> other one is small. The current join seems to take
> forever to finis
> I wish to tune our MySQL Server Parameter to increase
> the speed of Join. I was trying to do a simple join
> with two tables. One is big (~2,500,000 records); the
> other one is small. The current join seems to take
> forever to finish even on the indexed attribute.
>
> I am trying to learn from
Hi,
I wish to tune our MySQL Server Parameter to increase
the speed of Join. I was trying to do a simple join
with two tables. One is big (~2,500,000 records); the
other one is small. The current join seems to take
forever to finish even on the indexed attribute.
I am trying to learn from
http: