ijq4wDrn

1innodb_change_buffer_max_size=50
2	
3INSERT INTO `PerfCounters` SET `PerfID`='scriptname',`PID`=27802
4  ON DUPLICATE KEY UPDATE `ThisHour`=`ThisHour`+1;
5	
6CREATE TABLE IF NOT EXISTS `PerfCounters` (
7  `PerfID` varchar(30) NOT NULL,
8  `PID` int(11) NOT NULL DEFAULT '0',
9  `ThisHour` int(11) NOT NULL DEFAULT '1',
10  PRIMARY KEY (`PerfID`,`PID`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12	
13# User@Host: demouser[demouser] @ mysql.myhost.com [0.0.0.0]  Id: 453134
14# Query_time: 2.822141  Lock_time: 0.000096 Rows_sent: 0  Rows_examined: 0
15SET timestamp=1473074105;
16INSERT INTO `PerfCounters` SET `PerfID`='scriptname',`PID`=27802 ON DUPLICATE KEY UPDATE `ThisHour`=`ThisHour`+1;
17	
18auto_increment_increment=1
19auto_increment_offset=1
20autocommit=ON
21automatic_sp_privileges=ON
22avoid_temporal_upgrade=OFF
23back_log=90
24basedir=/usr
25big_tables=OFF
26bind_address=mysql.myhost.com
27binlog_cache_size=32,768
28binlog_checksum=CRC32
29binlog_direct_non_transactional_updates=OFF
30binlog_error_action=IGNORE_ERROR
31binlog_format=STATEMENT
32binlog_gtid_simple_recovery=OFF
33binlog_max_flush_queue_time=0
34binlog_order_commits=ON
35binlog_row_image=FULL
36binlog_rows_query_log_events=OFF
37binlog_stmt_cache_size=32,768
38binlogging_impossible_mode=IGNORE_ERROR
39block_encryption_mode=aes-128-ecb
40bulk_insert_buffer_size=8,388,608
41character_set_client=utf8
42character_set_connection=utf8
43character_set_database=latin1
44character_set_filesystem=binary
45character_set_results=utf8
46character_set_server=latin1
47character_set_system=utf8
48character_sets_dir=/usr/share/mysql/charsets/
49collation_connection=utf8_general_ci
50collation_database=latin1_swedish_ci
51collation_server=latin1_swedish_ci
52completion_type=NO_CHAIN
53concurrent_insert=AUTO
54connect_timeout=10
55core_file=OFF
56datadir=/var/lib/mysql/
57date_format=%Y-%m-%d
58datetime_format=%Y-%m-%d_%H:%i:%s
59default_storage_engine=InnoDB
60default_tmp_storage_engine=InnoDB
61default_week_format=0
62delay_key_write=ON
63delayed_insert_limit=100
64delayed_insert_timeout=300
65delayed_queue_size=1,000
66disconnect_on_expired_password=ON
67div_precision_increment=4
68end_markers_in_json=OFF
69enforce_gtid_consistency=OFF
70eq_range_index_dive_limit=10
71error_count=0
72event_scheduler=OFF
73expire_logs_days=10
74explicit_defaults_for_timestamp=OFF
75external_user=
76flush=OFF
77flush_time=0
78foreign_key_checks=ON
79ft_boolean_syntax=+_-><()~*:""&|
80ft_max_word_len=84
81ft_min_word_len=4
82ft_query_expansion_limit=20
83ft_stopword_file=(built-in)
84general_log=OFF
85general_log_file=/var/log/mysql/mysql.log
86group_concat_max_len=1,024
87gtid_executed=
88gtid_mode=OFF
89gtid_next=AUTOMATIC
90gtid_owned=
91gtid_purged=
92have_compress=YES
93have_crypt=YES
94have_dynamic_loading=YES
95have_geometry=YES
96have_openssl=DISABLED
97have_profiling=YES
98have_query_cache=YES
99have_rtree_keys=YES
100have_ssl=DISABLED
101have_symlink=YES
102host_cache_size=328
103hostname=mysqlhost.com
104identity=0
105ignore_builtin_innodb=OFF
106ignore_db_dirs=
107init_connect=
108init_file=
109init_slave=
110innodb_adaptive_flushing=ON
111innodb_adaptive_flushing_lwm=10
112innodb_adaptive_hash_index=ON
113innodb_adaptive_max_sleep_delay=150,000
114innodb_additional_mem_pool_size=8,388,608
115innodb_api_bk_commit_interval=5
116innodb_api_disable_rowlock=OFF
117innodb_api_enable_binlog=OFF
118innodb_api_enable_mdl=OFF
119innodb_api_trx_level=0
120innodb_autoextend_increment=64
121innodb_autoinc_lock_mode=1
122innodb_buffer_pool_dump_at_shutdown=OFF
123innodb_buffer_pool_dump_now=OFF
124innodb_buffer_pool_filename=ib_buffer_pool
125innodb_buffer_pool_instances=8
126innodb_buffer_pool_load_abort=OFF
127innodb_buffer_pool_load_at_startup=OFF
128innodb_buffer_pool_load_now=OFF
129innodb_buffer_pool_size=2,147,483,648
130innodb_change_buffer_max_size=50
131innodb_change_buffering=all
132innodb_checksum_algorithm=innodb
133innodb_checksums=ON
134innodb_cmp_per_index_enabled=OFF
135innodb_commit_concurrency=0
136innodb_compression_failure_threshold_pct=5
137innodb_compression_level=6
138innodb_compression_pad_pct_max=50
139innodb_concurrency_tickets=5,000
140innodb_data_file_path=ibdata1:12M:autoextend
141innodb_data_home_dir=
142innodb_disable_sort_file_cache=OFF
143innodb_doublewrite=ON
144innodb_fast_shutdown=1
145innodb_file_format=Antelope
146innodb_file_format_check=ON
147innodb_file_format_max=Antelope
148innodb_file_per_table=ON
149innodb_flush_log_at_timeout=1
150innodb_flush_log_at_trx_commit=1
151innodb_flush_method=O_DIRECT
152innodb_flush_neighbors=1
153innodb_flushing_avg_loops=30
154innodb_force_load_corrupted=OFF
155innodb_force_recovery=0
156innodb_ft_aux_table=
157innodb_ft_cache_size=8,000,000
158innodb_ft_enable_diag_print=OFF
159innodb_ft_enable_stopword=ON
160innodb_ft_max_token_size=84
161innodb_ft_min_token_size=3
162innodb_ft_num_word_optimize=2,000
163innodb_ft_result_cache_limit=2,000,000,000
164innodb_ft_server_stopword_table=
165innodb_ft_sort_pll_degree=2
166innodb_ft_total_cache_size=640,000,000
167innodb_ft_user_stopword_table=
168innodb_io_capacity=200
169innodb_io_capacity_max=2,000
170innodb_large_prefix=OFF
171innodb_lock_wait_timeout=50
172innodb_locks_unsafe_for_binlog=OFF
173innodb_log_buffer_size=33,554,432
174innodb_log_compressed_pages=ON
175innodb_log_file_size=134,217,728
176innodb_log_files_in_group=2
177innodb_log_group_home_dir=./
178innodb_lru_scan_depth=1,024
179innodb_max_dirty_pages_pct=75
180innodb_max_dirty_pages_pct_lwm=25
181innodb_max_purge_lag=0
182innodb_max_purge_lag_delay=0
183innodb_mirrored_log_groups=1
184innodb_monitor_disable=
185innodb_monitor_enable=
186innodb_monitor_reset=
187innodb_monitor_reset_all=
188innodb_old_blocks_pct=37
189innodb_old_blocks_time=1,000
190innodb_online_alter_log_max_size=134,217,728
191innodb_open_files=2,000
192innodb_optimize_fulltext_only=OFF
193innodb_page_size=16,384
194innodb_print_all_deadlocks=OFF
195innodb_purge_batch_size=300
196innodb_purge_threads=1
197innodb_random_read_ahead=OFF
198innodb_read_ahead_threshold=56
199innodb_read_io_threads=4
200innodb_read_only=OFF
201innodb_replication_delay=0
202innodb_rollback_on_timeout=OFF
203innodb_rollback_segments=128
204innodb_sort_buffer_size=1,048,576
205innodb_spin_wait_delay=6
206innodb_stats_auto_recalc=ON
207innodb_stats_method=nulls_equal
208innodb_stats_on_metadata=OFF
209innodb_stats_persistent=ON
210innodb_stats_persistent_sample_pages=20
211innodb_stats_sample_pages=8
212innodb_stats_transient_sample_pages=8
213innodb_status_output=OFF
214innodb_status_output_locks=OFF
215innodb_strict_mode=OFF
216innodb_support_xa=ON
217innodb_sync_array_size=1
218innodb_sync_spin_loops=30
219innodb_table_locks=ON
220innodb_thread_concurrency=0
221innodb_thread_sleep_delay=10,000
222innodb_tmpdir=
223innodb_undo_directory=.
224innodb_undo_logs=128
225innodb_undo_tablespaces=0
226innodb_use_native_aio=OFF
227innodb_use_sys_malloc=ON
228innodb_version=5.6.31
229innodb_write_io_threads=4
230insert_id=0
231interactive_timeout=28,800
232join_buffer_size=4,194,304
233keep_files_on_create=OFF
234key_buffer_size=301,989,888
235key_cache_age_threshold=300
236key_cache_block_size=1,024
237key_cache_division_limit=100
238large_files_support=ON
239large_page_size=0
240large_pages=OFF
241last_insert_id=0
242lc_messages=en_US
243lc_messages_dir=/usr/share/mysql/
244lc_time_names=en_US
245license=GPL
246local_infile=ON
247lock_wait_timeout=31,536,000
248locked_in_memory=OFF
249log_bin=OFF
250log_bin_basename=
251log_bin_index=
252log_bin_trust_function_creators=OFF
253log_bin_use_v1_row_events=OFF
254log_error=/var/log/mysql/error.log
255log_output=FILE
256log_queries_not_using_indexes=OFF
257log_slave_updates=OFF
258log_slow_admin_statements=OFF
259log_slow_slave_statements=OFF
260log_throttle_queries_not_using_indexes=0
261log_warnings=2
262long_query_time=10
263low_priority_updates=OFF
264lower_case_file_system=OFF
265lower_case_table_names=0
266master_info_repository=FILE
267master_verify_checksum=OFF
268max_allowed_packet=16,777,216
269max_binlog_cache_size=18446744073709547520
270max_binlog_size=1,073,741,824
271max_binlog_stmt_cache_size=18446744073709547520
272max_connect_errors=10,000
273max_connections=200
274max_delayed_threads=20
275max_digest_length=1,024
276max_error_count=64
277max_heap_table_size=134,217,728
278max_insert_delayed_threads=20
279max_join_size=18446744073709551615
280max_length_for_sort_data=1,024
281max_prepared_stmt_count=16,382
282max_relay_log_size=0
283max_seeks_for_key=18446744073709551615
284max_sort_length=1,024
285max_sp_recursion_depth=0
286max_tmp_tables=32
287max_user_connections=0
288max_write_lock_count=18446744073709551615
289metadata_locks_cache_size=1,024
290metadata_locks_hash_instances=8
291min_examined_row_limit=0
292multi_range_count=256
293myisam_data_pointer_size=6
294myisam_max_sort_file_size=9223372036853727232
295myisam_mmap_size=18446744073709551615
296myisam_recover_options=BACKUP,FORCE
297myisam_repair_threads=1
298myisam_sort_buffer_size=8,388,608
299myisam_stats_method=nulls_unequal
300myisam_use_mmap=OFF
301net_buffer_length=16,384
302net_read_timeout=30
303net_retry_count=10
304net_write_timeout=60
305new=OFF
306old=OFF
307old_alter_table=OFF
308old_passwords=0
309open_files_limit=10,000
310optimizer_prune_level=1
311optimizer_search_depth=62
312optimizer_switch=index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
313optimizer_trace=enabled=off,one_line=off
314optimizer_trace_features=greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
315optimizer_trace_limit=1
316optimizer_trace_max_mem_size=16,384
317optimizer_trace_offset=-1
318performance_schema=OFF
319performance_schema_accounts_size=-1
320performance_schema_digests_size=-1
321performance_schema_events_stages_history_long_size=-1
322performance_schema_events_stages_history_size=-1
323performance_schema_events_statements_history_long_size=-1
324performance_schema_events_statements_history_size=-1
325performance_schema_events_waits_history_long_size=-1
326performance_schema_events_waits_history_size=-1
327performance_schema_hosts_size=-1
328performance_schema_max_cond_classes=80
329performance_schema_max_cond_instances=-1
330performance_schema_max_digest_length=1,024
331performance_schema_max_file_classes=50
332performance_schema_max_file_handles=32,768
333performance_schema_max_file_instances=-1
334performance_schema_max_mutex_classes=200
335performance_schema_max_mutex_instances=-1
336performance_schema_max_rwlock_classes=40
337performance_schema_max_rwlock_instances=-1
338performance_schema_max_socket_classes=10
339performance_schema_max_socket_instances=-1
340performance_schema_max_stage_classes=150
341performance_schema_max_statement_classes=168
342performance_schema_max_table_handles=-1
343performance_schema_max_table_instances=-1
344performance_schema_max_thread_classes=50
345performance_schema_max_thread_instances=-1
346performance_schema_session_connect_attrs_size=-1
347performance_schema_setup_actors_size=100
348performance_schema_setup_objects_size=100
349performance_schema_users_size=-1
350pid_file=/var/run/mysqld/mysqld.pid
351plugin_dir=/usr/lib/mysql/plugin/
352port=3,306
353preload_buffer_size=32,768
354profiling=OFF
355profiling_history_size=15
356protocol_version=10
357proxy_user=
358pseudo_slave_mode=OFF
359pseudo_thread_id=517,506
360query_alloc_block_size=8,192
361query_cache_limit=5,242,880
362query_cache_min_res_unit=4,096
363query_cache_size=52,428,800
364query_cache_type=OFF
365query_cache_wlock_invalidate=OFF
366query_prealloc_size=8,192
367rand_seed1=0
368rand_seed2=0
369range_alloc_block_size=4,096
370read_buffer_size=1,048,576
371read_only=OFF
372read_rnd_buffer_size=262,144
373relay_log=
374relay_log_basename=
375relay_log_index=
376relay_log_info_file=relay-log.info
377relay_log_info_repository=FILE
378relay_log_purge=ON
379relay_log_recovery=OFF
380relay_log_space_limit=0
381report_host=
382report_password=
383report_port=3,306
384report_user=
385rpl_stop_slave_timeout=31,536,000
386secure_auth=ON
387secure_file_priv=
388server_id=0
389server_id_bits=32
390server_uuid=993bf09d-45a2-11e6-98f0-fa163ecd49dc
391show_old_temporals=OFF
392simplified_binlog_gtid_recovery=OFF
393skip_external_locking=ON
394skip_name_resolve=OFF
395skip_networking=OFF
396skip_show_database=OFF
397slave_allow_batching=OFF
398slave_checkpoint_group=512
399slave_checkpoint_period=300
400slave_compressed_protocol=OFF
401slave_exec_mode=STRICT
402slave_load_tmpdir=/tmp
403slave_max_allowed_packet=1,073,741,824
404slave_net_timeout=3,600
405slave_parallel_workers=0
406slave_pending_jobs_size_max=16,777,216
407slave_rows_search_algorithms=TABLE_SCAN,INDEX_SCAN
408slave_skip_errors=OFF
409slave_sql_verify_checksum=ON
410slave_transaction_retries=10
411slave_type_conversions=
412slow_launch_time=2
413slow_query_log=ON
414slow_query_log_file=/var/log/mysql/mysql-slow.log
415socket=/var/run/mysqld/mysqld.sock
416sort_buffer_size=2,097,152
417sql_auto_is_null=OFF
418sql_big_selects=ON
419sql_buffer_result=OFF
420sql_log_bin=ON
421sql_log_off=OFF
422sql_mode=NO_ENGINE_SUBSTITUTION
423sql_notes=ON
424sql_quote_show_create=ON
425sql_safe_updates=OFF
426sql_select_limit=18446744073709551615
427sql_slave_skip_counter=0
428sql_warnings=OFF
429ssl_ca=
430ssl_capath=
431ssl_cert=
432ssl_cipher=
433ssl_crl=
434ssl_crlpath=
435ssl_key=
436storage_engine=InnoDB
437stored_program_cache=256
438sync_binlog=0
439sync_frm=ON
440sync_master_info=10,000
441sync_relay_log=10,000
442sync_relay_log_info=10,000
443system_time_zone=PDT
444table_definition_cache=1,400
445table_open_cache=2,000
446table_open_cache_instances=1
447thread_cache_size=64
448thread_concurrency=10
449thread_handling=one-thread-per-connection
450thread_stack=262,144
451time_format=%H:%i:%s
452time_zone=SYSTEM
453timed_mutexes=OFF
454timestamp=1473081753.003525
455tmp_table_size=134,217,728
456tmpdir=/tmp
457transaction_alloc_block_size=8,192
458transaction_allow_batching=OFF
459transaction_prealloc_size=4,096
460tx_isolation=REPEATABLE-READ
461tx_read_only=OFF
462unique_checks=ON
463updatable_views_with_limit=YES
464version=5.6.31-0ubuntu0.14.04.2-log
465version_comment=(Ubuntu)
466version_compile_machine=x86_64
467version_compile_os=debian-linux-gnu
468wait_timeout=28,800
469warning_count=0
470Open_new_phpMyAdmin_window