key buffer is about 8M
key_buffer_size | 8388600
I just tried bumping my settings up to these that I found in the
manual...
safe_mysqld -O key_buffer=64M -O table_cache=256 \
-O sort_buffer=4M -O record_buffer=1M
It shaved a second off... 2.29, and later call took
only .88
3.23.41 on Solaris
I have an indexed table of cusips (9 character identifiers)
which I am comparing against a lookup tables of over
1,000,000 securities, also keyed by cusip, both fields are
char(9) fields.
My query is taking over 3 seconds, which may be the best I
can do, but I'm hoping I
On Mon, Nov 19, 2001 at 03:29:26PM -0500, Anthony R. J. Ball wrote:
3.23.41 on Solaris
I have an indexed table of cusips (9 character identifiers)
which I am comparing against a lookup tables of over
1,000,000 securities, also keyed by cusip, both fields are
char(9) fields.
How large