I'm missing something rather essential in your mail... are you actually experiencing performance problems, or are you just looking at variables and randomly deciding you don't like their value?
Always remember the golden rule: if it ain't broken, don't fix it. On July 4, 2014 8:00:31 PM CEST, "Antonio Fernández Pérez" <antoniofernan...@fabergroup.es> wrote: >Hi list, > >I have some doubts adjusting some MySQL variables. > I have checked MySQL status and maybe I should to increase some >variables >... > >For example: >InnoDB log waits is 103; innodb_log_buffer_size is 8M --> Maybe the >next >best value could be 16M? >Table cache hit rate is 12%; Open_tables is 627; table_open_cache is >1024 >--> Maybe the next best value could be 2048? >Key buffer hit rate is 93.7%; I have some queries that not using >indexes .. >join_buffer_size is 4M --> Next best value? Maybe 8M and then check it >again? > >That's all. > >I hope your advices. > >Regards, > >Antonio. -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
