[]Conrad said:
2. How can up up my cache to 128, and how will this affect my system memory (I've got 1GB RAM)? What do I need to add to the "my.cnf" file, which is very bare at the moment (just 3 lines!):
[mysqld]
set-variable = max_connections=500
safe-show-database
[/]
Just add the variables that aren't defined yet to the configuration file.
So inserting:
table_cache = 128
will set your table cache to 128.
Same thing for key_buffer_size and all other thigs mentioned in Jeremy's text. If a variable isn't set in the config file a default value is used.
[]
3. Also, is there a procedure to follow when restarting MySQL? Or do I just switch the forums off and restart MySQL in WHM?
[/]
Yes, close the board and restart mysql.
[]
5. Last but not least, how do I protect the script from getting into the wrong hands (after all, I don't want to make my db login+password public...)? Placing it above the web root probably makes no sense, so am I doing the right thing by creating a new folder for this file and then setting a password on the folder via CPanel? Is that secure enough? [/]
Yes, that's fine.