Help
I would like to ask you about following parameters which should be low or high for best performance:
please tell me
1) Thread cache size --- should be low or high for best mysql performance
2) thread cache hit rate -- should be low or high for best mysql performance
3) thread created --- should be low or high for best mysql performance
4) table lock --- should be low or high for best mysql performance
5) table lock wait --- should be low or high for best mysql performance
6) Maximum open file --- should be low or high for best mysql performance
7) total row returned --- should be low or high for best mysql performance
8) total row returned via index --- should be low or high for best mysql performance
9) table open --- should be low or high for best mysql performance
10) table cache --- should be low or high for best mysql performance
11) Average row per query -- should be low or high for best mysql performance
12) No. of byte received --- should be low or high for best mysql performance
13) No. of Byte sent --- should be low or high for best mysql performance
14) connection used -- should be low or high for best mysql performance
15) query in cache --- should be low or high for best mysql performance
16) query cache hit --- should be low or high for best mysql performance
17) query cache hit ratio -- should be low or high for best mysql performance
I request you to kindly provide me solution as soon as possible.
I am waiting your response.
