Re: Tuning MySQL Server Parameter

2002-12-06 Thread 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 le

Re: Tuning MySQL Server Parameter

2002-12-06 Thread Qunfeng Dong
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

Re: Tuning MySQL Server Parameter

2002-12-06 Thread Georg Richter
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

Re: Tuning MySQL Server Parameter

2002-12-05 Thread David Bordas
> 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

Tuning MySQL Server Parameter

2002-12-05 Thread Qunfeng Dong
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: