On Tue, Jan 22, 2002 at 10:12:55AM -0600, Solsberry, Glendon wrote:
> I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
> RAM). The problem is that the main query (listed below) takes
> approximately 3 hours to run.
[snip]
Wow! Thanks for all the detail.
> The query is this
I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
RAM).
The problem is that the main query (listed below) takes approximately 3
hours to run.
my.cnf looks like:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=128M
