large query settings

[CalEvans]

4 suggestions:

1: get more RAM

2: Check out the sample cnf files. There is one for large systems. Read it over carefully, it may contain some insight.

3: Use EXPLAIN on your query to see if another index would help.

4: post on the mysql mailing lsit. There are guys there who have crossed this bridge before (Jeremy Zawoodny for one…and I know I misspelled his name)

=C=

[matt]

i am using the large system cnf file.

i was not aware of the EXPLAIN keyword. i will try to see if i need some more indexes or if it has any suggestions on arranging the queries. i will check out the mysql mailing list to see if i can get any further suggestions. thanks for your help.

[Shadow]

The table type may also affect which settings should be altered, but the following ones have the most influence on performance:

set-variable = read_buffer_size

set-variable = key_buffer_size

set-variable = max_allowed_packet

set-variable = table_cache

set-variable = sort_buffer

set-variable = net_buffer_length

set-variable = myisam_sort_buffer_size

4.5.6.4 SHOW VARIABLES section of MySql manual explains these settings in detail, but generally assigning higher values to these variables will increase the speed. But in case of such large tables, I would recommend to get additional memory (at least 512MB plus).

[Author]

Posts