Questions about sqltuner results

icandoit

• June 02, 2016 04:44

SQL result says Variables to adjust: query_cache_type (=0) tmp_table_size (> 16M) max_heap_table_size (> 16M) innodb_buffer_pool_instances (=1) My cnf has: [mysqld] default-storage-engine=InnoDB innodb_file_per_table=1 max_allowed_packet=268435456 open_files_limit=10000 bind-address=127.0.0.1 So what I need to add? Thanks I am confused . Just learning ...

• 

  cPanelMichael

  • June 06, 2016 16:50

  Hello, You can search for each specific variable listed under "Variables To Adjust" to determine which configuration value it's referring to. For instance, with "query_cache_type", search engine results show a link to this page: MySQL :: MySQL 5.6 Reference Manual :: 8.10.3 The MySQL Query Cache You can review the comments section of this page to see how other users have utilized this option. Thank you.

  0

Please sign in to leave a comment.