BrnDmp

MySQL optimization & Security

NOTE: should do a MySQL optimization roundup on my servers.

Increase table_cache and open_files_limit. Check balance between global and per thread buffers. Check key_buffer_size. Check tmp_table_size and max_heap_table_size. Check relation between ulimit -n, that is standard set to 1024, but in my.cnf it is set to 8000 or something.

Parameters to check:

• key buffer hit rate
• query cache efficiency
• thread cache hit rate
• table cache hit rate
• open files limit used
• Data in tables (#tables)

Check out how to set mysql variables on run-time. Then of course also adjust them in the script.

Security

Article about GreenSQL, kind of a MySQL proxy to precent SQL injection. Should check it out.