View difference between Paste ID: qmA89REM and ma7Xm0w5

-tuning primer result
+        -- MYSQL PERFORMANCE TUNING PRIMER --
              - By: Matthew Montgomery -
 
-	-- MYSQL PERFORMANCE TUNING PRIMER --
+MySQL Version 5.5.37-cll x86_64
-	     - By: Matthew Montgomery -
+
 Uptime = 18 days 4 hrs 1 min 50 sec
-MySQL Version 5.5.36-cll x86_64
+Avg. qps = 124
 Total Questions = 196063773
-Uptime = 6 days 11 hrs 34 min 44 sec
+Threads Connected = 6
-Avg. qps = 122
+
-Total Questions = 68808780
+
-Threads Connected = 12
+
 
 To find out more information on how each of these
 runtime variables effects performance visit:
 http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html
 Visit http://www.mysql.com/products/enterprise/advisors.html
 for info about MySQL's Enterprise Monitoring and Advisory Service
 
 SLOW QUERIES
 The slow query log is enabled.
 Current long_query_time = 10.000000 sec.
 You have 17835 out of 196063868 that take longer than 10.000000 sec. to complete
-The slow query log is NOT enabled.
+
 
-You have 27500 out of 68809061 that take longer than 10.000000 sec. to complete
+
 The binary update log is NOT enabled.
 You will not be able to do point in time recovery
 See http://dev.mysql.com/doc/refman/5.5/en/point-in-time-recovery.html
 
 WORKER THREADS
 Current thread_cache_size = 12
 Current threads_cached = 8
 Current threads_per_sec = 0
 Historic threads_per_sec = 0
-Current threads_cached = 9
+
 
 MAX CONNECTIONS
 Current max_connections = 200
 Current threads_connected = 13
 Historic max_used_connections = 115
 The number of used connections is 57% of the configured maximum.
-Current threads_connected = 11
+Your max_connections variable seems to be fine.
-Historic max_used_connections = 201
+
-The number of used connections is 100% of the configured maximum.
+
-You should raise max_connections
+Current InnoDB index space = 388 M
 Current InnoDB data space = 291 M
 Current InnoDB buffer pool free = 0 %
-Current InnoDB index space = 381 M
+
-Current InnoDB data space = 300 M
+
 to increase this value to up to 2 / 3 of total system memory
 
 MEMORY USAGE
 Max Memory Ever Allocated : 3.00 G
 Configured Max Per-thread Buffers : 3.63 G
 Configured Max Global Buffers : 936 M
-Max Memory Ever Allocated : 4.39 G
+Configured Max Memory Limit : 4.55 G
 Physical Memory : 17.08 G
-Configured Max Global Buffers : 758 M
+
-Configured Max Memory Limit : 4.37 G
+
-Physical Memory : 14.16 G
+
 Current MyISAM index space = 1.48 G
 Current key_buffer_size = 8 M
 Key cache miss rate is 1 : 20
-Current MyISAM index space = 1.05 G
+Key buffer free ratio = 74 %
 Your key_buffer_size seems to be fine
 
-Key buffer free ratio = 80 %
+
 Query cache is enabled
 Current query_cache_size = 512 M
 Current query_cache_used = 291 M
 Current query_cache_limit = 512 M
-Current query_cache_size = 334 M
+Current Query cache Memory fill ratio = 56.93 %
-Current query_cache_used = 183 M
+
-Current query_cache_limit = 256 M
+
-Current Query cache Memory fill ratio = 54.89 %
+
 SORT OPERATIONS
 Current sort_buffer_size = 2 M
 Current read_rnd_buffer_size = 256 K
 Sort buffer seems to be fine
 
 JOINS
 Current join_buffer_size = 16.00 M
 You have had 208973 queries where a join could not use an index properly
 You have had 449458 joins without keys that check for key usage after each row
 join_buffer_size >= 4 M
-You have had 118697 queries where a join could not use an index properly
+
-You have had 127057 joins without keys that check for key usage after each row
+
 Then look for non indexed joins in the slow query log.
 
 OPEN FILES LIMIT
 Current open_files_limit = 43762 files
 The open_files_limit should typically be set to at least 2x-3x
 that of table_cache if you have heavy MyISAM usage.
 Your open_files_limit value seems to be fine
 
 TABLE CACHE
 Current table_open_cache = 512 tables
 Current table_definition_cache = 400 tables
 You have a total of 8031 tables
 You have 512 open tables.
 Current table_cache hit rate is 0%
-You have a total of 7754 tables
+
 You should probably increase your table_cache
 You should probably increase your table_definition_cache value.
 
 TEMP TABLES
 Current max_heap_table_size = 1.00 G
 Current tmp_table_size = 1.00 G
 Of 6639839 temp tables, 35% were created on disk
 Perhaps you should increase your tmp_table_size and/or max_heap_table_size
 to reduce the number of disk-based temporary tables
-Of 2618612 temp tables, 32% were created on disk
+
 If you are using these columns raising these values might not impact your
 ratio of on disk temp tables.
 
-If you are using these columns raising these values might not impact your
+
 Current read_buffer_size = 128 K
 Current table scan ratio = 3261 : 1
 read_buffer_size seems to be fine
 
-Current table scan ratio = 2555 : 1
+
 Current Lock Wait ratio = 1 : 1619
 You may benefit from selective use of InnoDB.
 If you have long running SELECT's against MyISAM tables and perform
-Current Lock Wait ratio = 1 : 667
+
 If you have a high concurrency of inserts on Dynamic row-length tables
 consider setting 'concurrent_insert=ALWAYS'.