recommended table cache settings

[werehere]

I have a dedicated p3 600MHZ with 128MB RAM and I am wondering what specific table cahce settings would be best to use for this. Or any other MySQL specific settings would be best.

Thanks

[werehere]

Anybody have any info to offer on this subject?:)

[John]

In MySQL, I would recommend increasing the values of these variables:

max_connections
tmp_table_size


For PHP, I would increase:
memory_limit
magic_quotes_gpc -> off

You could, if you are on a win32 system, look at loading the databases onto a ramdrive - I'm not sure if there is an equivalent for Unix. You would have to be careful of power outages.

That's all I can think of off the top of my head.

John

[bigsoccer tech]

John,

Can you please advise what a good setting is? I'm learning this stuff...

Jesse

[werehere]

Just wanted to tell you that I changed around the php.ini settings a little and my forum seems to be screaming now like this one.

memory_limit = 12
magic_quotes_gpc -> off


So I upped the memory from 8MB to 12MB and turned the magic_quotes_gpc off and it seems to be much better. I also upped max_connections to 800 (for my forums, but that is forum specific I would guess).

[Cold Steel]

What would be optimal for these two?

max_connections
tmp_table_size

Currently the values are

max_connections - 250
tmp_table_size - 1048576

Thanks!

[Cold Steel]

I'm upping the max_connections to 800, what about tmp_table_size?

Thanks!

[Cold Steel]

I have a dedicated AMD K6-2 400 MHZ with 128 RAM. Can someone help me with the recommended tmp_table_size?

[werehere]

Well dont take my word for this necessarily, but I have not found that it makes much differnce no matter if it set to default, or doubled. Have tried both, could not even tell.:)

[Edited by werehere on 06-06-2000 at 03:22 PM]