Re: Suggested settings for MySql

[Hans Brost]

Thank you for the response.

I was hoping for simple values for the various settings that would maximize the 2G that I have available for the update.

As you can see, the entire DB will fit in 2G 5 times over.

Can I change values on a temporary basis in the PHP script itself to minimize run time?

There are only about 20 users on this DB, so anything online isn't that important.

Pragmatically speaking, on the old DV (with a lot more Ram of course), this script ran in 28 seconds, so while investigating the script itself may result in some gains, that's not the point. It's all index based, fwiw.

On the first DV I got the script ran in 1:30 or so........but this latest one hasn't been able to come close to that.

I was hoping for just some values for the various fields, i.e.:

These values....and any other settings you can advise on, to maximize the 2G Ram usage when running the script:

query-cache-type=1
query_cache_size=64M
query_cache_limit=32M

tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=512M

#Tried these at 64 and ran out of memory
read_buffer_size=8M
read_rnd_buffer_size=8M

sort_buffer_size=32M
thread_cache_size=10

You said get rid of query cache....no problema.....I'm assuming that only applies to online access and not particularly to an update script?

Thanks again for your time on this!

z