show variables like ‘join_buffer_size%’;join_buffer_size=join_buffer_size+4kb

You have had 6 queries where a join could not use an index properly

这里的6是通过 show status like ‘Select_full_join’; 获得的

You should enable “log-queries-not-using-indexes”Then look for non indexed joins in the slow query log.If you are unable to optimize your queries you may want to increase yourjoin_buffer_size to accommodate larger joins in one pass.Note! This script will still suggest raising the join_buffer_size whenANY joins not using indexes are found.

############################################################################Usage: ./tuning-primer.sh [ mode ] ####Available Modes: ##all : perform all checks (default)##prompt : prompt for login credintials and socket##and execution mode## mem, memory : run checks for tunable options which ##effect memory usage##disk, file :run checks for options which effect##i/o performance or file handle limits##innodb : run InnoDB checks /* to be improved */# #misc : run checks for that don't categorise##well Slow Queries, Binary logs,##Used Connections and Worker Threads############################################################################# Set this socket variable ONLY if you have multiple instances running# # or we are unable to find your socket, and you don't want to to be## prompted for input each time you run this script.############################################################################socket=