Formulation of my.cnf

view story

http://www.linuxquestions.org – Hi. Planning big to improve mysql performance, so I need to have some information: 1- I am looking for general formulation so that I can calculate the amount of memory of buffers and caches I need to configure in my.cnf based on my traffic and number of connections. Can anybody help me? I am not even sure if there is such thing, I can't find any... (For example, I want to know how much qcache I need, or, for adjusting tmp_table_size) 2- How can I monitor my traffic? I need to know e.g the average size of queries Thanks. (HowTos)