Guest User

Untitled

a guest
Nov 20th, 2017
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.71 KB | None | 0 0
  1. innodb_read_io_threads
  2. innodb_write_io_threads
  3.  
  4. allow_client_hostname_forwarding=ON
  5. allow_repl_client_for_replication_config=OFF
  6. auto_generate_certs=ON
  7. auto_increment_increment=1
  8. auto_increment_offset=1
  9. autocommit=ON
  10. automatic_sp_privileges=ON
  11. avoid_temporal_upgrade=OFF
  12. back_log=850
  13. basedir=/mysql/
  14. big_tables=OFF
  15. bind_address=*
  16. binlog_cache_size=32768
  17. binlog_checksum=CRC32
  18. binlog_direct_non_transactional_updates=OFF
  19. binlog_error_action=ABORT_SERVER
  20. binlog_format=ROW
  21. binlog_group_commit_sync_delay=0
  22. binlog_group_commit_sync_no_delay_count=0
  23. binlog_gtid_simple_recovery=ON
  24. binlog_max_flush_queue_time=0
  25. binlog_order_commits=ON
  26. binlog_row_image=FULL
  27. binlog_rows_query_log_events=OFF
  28. binlog_stmt_cache_size=32768
  29. block_encryption_mode=aes-128-ecb
  30. block_slave_sql_access=0
  31. block_user_access=33280
  32. bulk_insert_buffer_size=8388608
  33. character_set_client=utf8
  34. character_set_connection=utf8
  35. character_set_database=utf8
  36. character_set_filesystem=binary
  37. character_set_results=utf8
  38. character_set_server=utf8
  39. character_set_system=utf8
  40. character_sets_dir=/usr/share/mysql/charsets/
  41. check_proxy_users=OFF
  42. collation_connection=utf8_general_ci
  43. collation_database=utf8_general_ci
  44. collation_server=utf8_general_ci
  45. completion_type=NO_CHAIN
  46. concurrent_insert=AUTO
  47. connect_timeout=10
  48. core_file=OFF
  49. datadir=/mysql/datadir/
  50. date_format=%Y-%m-%d
  51. datetime_format=%Y-%m-%d %H:%i:%s
  52. default_authentication_plugin=mysql_native_password
  53. default_password_lifetime=0
  54. default_storage_engine=InnoDB
  55. default_tmp_storage_engine=InnoDB
  56. default_week_format=0
  57. delay_key_write=ON
  58. delayed_insert_limit=100
  59. delayed_insert_timeout=300
  60. delayed_queue_size=1000
  61. disabled_storage_engines=
  62. disconnect_on_expired_password=ON
  63. div_precision_increment=4
  64. end_markers_in_json=OFF
  65. enforce_gtid_consistency=ON
  66. enforce_storage_engine=
  67. eq_range_index_dive_limit=200
  68. error_count=0
  69. event_scheduler=OFF
  70. expire_logs_days=0
  71. explicit_defaults_for_timestamp=OFF
  72. external_user=
  73. flush=OFF
  74. flush_time=0
  75. force_ssl_for_tcp=NONE
  76. foreign_key_checks=ON
  77. ft_boolean_syntax=+ -><()~*:""&|
  78. ft_max_word_len=84
  79. ft_min_word_len=4
  80. ft_query_expansion_limit=20
  81. ft_stopword_file=(built-in)
  82. general_log=OFF
  83. general_log_file=/mysql/logs/general.log
  84. group_concat_max_len=1024
  85. gtid_executed_compression_period=1000
  86. gtid_mode=ON
  87. gtid_next=AUTOMATIC
  88. gtid_owned=
  89. gtid_purged=5fd39415-ca37-11e6-9729-42010a800034:1-387725664
  90. have_compress=YES
  91. have_crypt=YES
  92. have_dynamic_loading=YES
  93. have_geometry=YES
  94. have_openssl=YES
  95. have_profiling=YES
  96. have_query_cache=YES
  97. have_rtree_keys=YES
  98. have_ssl=YES
  99. have_statement_timeout=YES
  100. have_symlink=YES
  101. host_cache_size=803
  102. hostname=localhost
  103. identity=0
  104. ignore_builtin_innodb=OFF
  105. ignore_db_dirs=
  106. init_connect=
  107. init_file=
  108. init_slave=
  109. innodb_adaptive_flushing=ON
  110. innodb_adaptive_flushing_lwm=10
  111. innodb_adaptive_hash_index=ON
  112. innodb_adaptive_hash_index_parts=8
  113. innodb_adaptive_max_sleep_delay=150000
  114. innodb_api_bk_commit_interval=5
  115. innodb_api_disable_rowlock=OFF
  116. innodb_api_enable_binlog=OFF
  117. innodb_api_enable_mdl=OFF
  118. innodb_api_trx_level=0
  119. innodb_autoextend_increment=64
  120. innodb_autoinc_lock_mode=1
  121. innodb_buffer_pool_chunk_size=134217728
  122. innodb_buffer_pool_dump_at_shutdown=ON
  123. innodb_buffer_pool_dump_now=OFF
  124. innodb_buffer_pool_dump_pct=25
  125. innodb_buffer_pool_filename=ib_buffer_pool
  126. innodb_buffer_pool_instances=8
  127. innodb_buffer_pool_load_abort=OFF
  128. innodb_buffer_pool_load_at_startup=ON
  129. innodb_buffer_pool_load_now=OFF
  130. innodb_buffer_pool_size=40802189312
  131. innodb_change_buffer_max_size=25
  132. innodb_change_buffering=all
  133. innodb_checksum_algorithm=crc32
  134. innodb_checksums=ON
  135. innodb_cmp_per_index_enabled=OFF
  136. innodb_commit_concurrency=0
  137. innodb_compression_failure_threshold_pct=5
  138. innodb_compression_level=6
  139. innodb_compression_pad_pct_max=50
  140. innodb_concurrency_tickets=5000
  141. innodb_data_file_path=ibdata1:12M:autoextend
  142. innodb_data_home_dir=
  143. innodb_default_row_format=dynamic
  144. innodb_disable_sort_file_cache=OFF
  145. innodb_doublewrite=ON
  146. innodb_fast_shutdown=1
  147. innodb_file_format=Barracuda
  148. innodb_file_format_check=ON
  149. innodb_file_format_max=Barracuda
  150. innodb_file_per_table=ON
  151. innodb_fill_factor=100
  152. innodb_flush_log_at_timeout=1
  153. innodb_flush_log_at_trx_commit=1
  154. innodb_flush_method=O_DIRECT
  155. innodb_flush_neighbors=2
  156. innodb_flush_sync=ON
  157. innodb_flushing_avg_loops=5
  158. innodb_force_load_corrupted=OFF
  159. innodb_force_recovery=0
  160. innodb_ft_aux_table=
  161. innodb_ft_cache_size=8000000
  162. innodb_ft_enable_diag_print=OFF
  163. innodb_ft_enable_stopword=ON
  164. innodb_ft_max_token_size=84
  165. innodb_ft_min_token_size=3
  166. innodb_ft_num_word_optimize=2000
  167. innodb_ft_result_cache_limit=2000000000
  168. innodb_ft_server_stopword_table=
  169. innodb_ft_sort_pll_degree=2
  170. innodb_ft_total_cache_size=640000000
  171. innodb_ft_user_stopword_table=
  172. innodb_io_capacity=5000
  173. innodb_io_capacity_max=10000
  174. innodb_large_prefix=ON
  175. innodb_lock_wait_timeout=50
  176. innodb_locks_unsafe_for_binlog=OFF
  177. innodb_log_buffer_size=16777216
  178. innodb_log_checksums=ON
  179. innodb_log_compressed_pages=ON
  180. innodb_log_file_size=536870912
  181. innodb_log_files_in_group=2
  182. innodb_log_group_home_dir=./
  183. innodb_log_write_ahead_size=8192
  184. innodb_lru_scan_depth=2048
  185. innodb_max_dirty_pages_pct=75.000000
  186. innodb_max_dirty_pages_pct_lwm=0.000000
  187. innodb_max_purge_lag=0
  188. innodb_max_purge_lag_delay=0
  189. innodb_max_undo_log_size=1073741824
  190. innodb_monitor_disable=
  191. innodb_monitor_enable=all
  192. innodb_monitor_reset=
  193. innodb_monitor_reset_all=
  194. innodb_old_blocks_pct=37
  195. innodb_old_blocks_time=1000
  196. innodb_online_alter_log_max_size=134217728
  197. innodb_open_files=2000
  198. innodb_optimize_fulltext_only=OFF
  199. innodb_page_cleaners=8
  200. innodb_page_size=16384
  201. innodb_print_all_deadlocks=OFF
  202. innodb_purge_batch_size=300
  203. innodb_purge_rseg_truncate_frequency=128
  204. innodb_purge_threads=4
  205. innodb_random_read_ahead=OFF
  206. innodb_read_ahead_threshold=56
  207. innodb_read_io_threads=4
  208. innodb_read_only=OFF
  209. innodb_replication_delay=0
  210. innodb_rollback_on_timeout=OFF
  211. innodb_rollback_segments=128
  212. innodb_sort_buffer_size=1048576
  213. innodb_spin_wait_delay=6
  214. innodb_stats_auto_recalc=ON
  215. innodb_stats_method=nulls_equal
  216. innodb_stats_on_metadata=OFF
  217. innodb_stats_persistent=ON
  218. innodb_stats_persistent_sample_pages=20
  219. innodb_stats_sample_pages=8
  220. innodb_stats_transient_sample_pages=8
  221. innodb_status_output=OFF
  222. innodb_status_output_locks=OFF
  223. innodb_strict_mode=ON
  224. innodb_support_xa=ON
  225. innodb_sync_array_size=1
  226. innodb_sync_spin_loops=30
  227. innodb_table_locks=ON
  228. innodb_temp_data_file_path=ibtmp1:12M:autoextend
  229. innodb_thread_concurrency=0
  230. innodb_thread_sleep_delay=10000
  231. innodb_tmpdir=
  232. innodb_undo_directory=./
  233. innodb_undo_log_truncate=OFF
  234. innodb_undo_logs=128
  235. innodb_undo_tablespaces=0
  236. innodb_use_native_aio=ON
  237. innodb_version=5.7.14
  238. innodb_write_io_threads=4
  239. insert_id=0
  240. interactive_timeout=28800
  241. internal_tmp_disk_storage_engine=InnoDB
  242. join_buffer_size=262144
  243. keep_files_on_create=OFF
  244. key_buffer_size=8388608
  245. key_cache_age_threshold=300
  246. key_cache_block_size=1024
  247. key_cache_division_limit=100
  248. large_files_support=ON
  249. large_page_size=0
  250. large_pages=OFF
  251. last_insert_id=0
  252. lc_messages=en_US
  253. lc_messages_dir=/usr/share/mysql/
  254. lc_time_names=en_US
  255. license=GPL
  256. local_infile=ON
  257. lock_wait_timeout=31536000
  258. locked_in_memory=OFF
  259. log_bin=ON
  260. log_bin_basename=/mysql/binlog/mysql-bin
  261. log_bin_index=/mysql/binlog/mysql-bin.index
  262. log_bin_trust_function_creators=OFF
  263. log_bin_use_v1_row_events=OFF
  264. log_builtin_as_identified_by_password=OFF
  265. log_error=stderr
  266. log_error_verbosity=3
  267. log_n_first_received_events=4
  268. log_n_first_sent_events=4
  269. log_output=TABLE
  270. log_queries_not_using_indexes=OFF
  271. log_slave_updates=ON
  272. log_slow_admin_statements=OFF
  273. log_slow_slave_statements=OFF
  274. log_statements_unsafe_for_binlog=ON
  275. log_syslog=OFF
  276. log_syslog_facility=daemon
  277. log_syslog_include_pid=ON
  278. log_syslog_tag=
  279. log_throttle_queries_not_using_indexes=0
  280. log_timestamps=UTC
  281. log_warnings=2
  282. long_query_time=2.000000
  283. low_priority_updates=OFF
  284. lower_case_file_system=OFF
  285. lower_case_table_names=0
  286. master_info_repository=TABLE
  287. master_verify_checksum=OFF
  288. max_allowed_packet=268435456
  289. max_binlog_cache_size=18446744073709547520
  290. max_binlog_size=104857600
  291. max_binlog_stmt_cache_size=18446744073709547520
  292. max_connect_errors=100
  293. max_connections=4000
  294. max_delayed_threads=20
  295. max_digest_length=1024
  296. max_error_count=64
  297. max_execution_time=0
  298. max_heap_table_size=16777216
  299. max_insert_delayed_threads=20
  300. max_join_size=18446744073709551615
  301. max_length_for_sort_data=1024
  302. max_points_in_geometry=65536
  303. max_prepared_stmt_count=16382
  304. max_relay_log_size=0
  305. max_seeks_for_key=18446744073709551615
  306. max_sort_length=1024
  307. max_sp_recursion_depth=0
  308. max_tmp_tables=32
  309. max_user_connections=0
  310. max_write_lock_count=18446744073709551615
  311. metadata_locks_cache_size=1024
  312. metadata_locks_hash_instances=8
  313. min_examined_row_limit=0
  314. multi_range_count=256
  315. mysql_native_password_proxy_users=OFF
  316. net_buffer_length=16384
  317. net_read_timeout=30
  318. net_retry_count=10
  319. net_write_timeout=60
  320. new=OFF
  321. ngram_token_size=2
  322. offline_mode=OFF
  323. old=OFF
  324. old_alter_table=OFF
  325. old_passwords=0
  326. open_files_limit=1048576
  327. optimizer_prune_level=1
  328. optimizer_search_depth=62
  329. optimizer_trace=enabled=off,one_line=off
  330. optimizer_trace_limit=1
  331. optimizer_trace_max_mem_size=16384
  332. optimizer_trace_offset=-1
  333. parser_max_mem_size=18446744073709551615
  334. performance_schema=OFF
  335. performance_schema_accounts_size=0
  336. performance_schema_digests_size=0
  337. performance_schema_events_stages_history_long_size=0
  338. performance_schema_events_stages_history_size=0
  339. performance_schema_events_statements_history_long_size=0
  340. performance_schema_events_statements_history_size=0
  341. performance_schema_events_transactions_history_long_size=0
  342. performance_schema_events_transactions_history_size=0
  343. performance_schema_events_waits_history_long_size=0
  344. performance_schema_events_waits_history_size=0
  345. performance_schema_hosts_size=0
  346. performance_schema_max_cond_classes=0
  347. performance_schema_max_cond_instances=0
  348. performance_schema_max_digest_length=0
  349. performance_schema_max_file_classes=0
  350. performance_schema_max_file_handles=0
  351. performance_schema_max_file_instances=0
  352. performance_schema_max_index_stat=0
  353. performance_schema_max_memory_classes=0
  354. performance_schema_max_metadata_locks=0
  355. performance_schema_max_mutex_classes=0
  356. performance_schema_max_mutex_instances=0
  357. performance_schema_max_prepared_statements_instances=0
  358. performance_schema_max_program_instances=0
  359. performance_schema_max_rwlock_classes=0
  360. performance_schema_max_rwlock_instances=0
  361. performance_schema_max_socket_classes=0
  362. performance_schema_max_socket_instances=0
  363. performance_schema_max_sql_text_length=0
  364. performance_schema_max_stage_classes=0
  365. performance_schema_max_statement_classes=0
  366. performance_schema_max_statement_stack=0
  367. performance_schema_max_table_handles=0
  368. performance_schema_max_table_instances=0
  369. performance_schema_max_table_lock_stat=0
  370. performance_schema_max_thread_classes=0
  371. performance_schema_max_thread_instances=0
  372. performance_schema_session_connect_attrs_size=0
  373. performance_schema_setup_actors_size=0
  374. performance_schema_setup_objects_size=0
  375. performance_schema_users_size=0
  376. pid_file=/mysql/mysql.pid
  377. plugin_dir=/usr/lib/mysql/plugin/
  378. port=3306
  379. preload_buffer_size=32768
  380. profiling=OFF
  381. profiling_history_size=15
  382. protocol_version=10
  383. proxy_user=
  384. pseudo_slave_mode=OFF
  385. pseudo_thread_id=162
  386. query_alloc_block_size=8192
  387. query_cache_limit=1048576
  388. query_cache_min_res_unit=4096
  389. query_cache_size=1048576
  390. query_cache_type=OFF
  391. query_cache_wlock_invalidate=OFF
  392. query_prealloc_size=8192
  393. rand_seed1=0
  394. rand_seed2=0
  395. range_alloc_block_size=4096
  396. range_optimizer_max_mem_size=8388608
  397. rbr_exec_mode=STRICT
  398. read_buffer_size=131072
  399. read_only=OFF
  400. read_rnd_buffer_size=262144
  401. relay_log=/mysql/relaylog/relay-log
  402. relay_log_basename=/mysql/relaylog/relay-log
  403. relay_log_index=/mysql/relaylog/relay-log.index
  404. relay_log_info_file=relay-log.info
  405. relay_log_info_repository=TABLE
  406. relay_log_purge=ON
  407. relay_log_recovery=ON
  408. relay_log_space_limit=0
  409. report_host=
  410. report_password=
  411. report_port=3306
  412. report_user=
  413. require_secure_transport=OFF
  414. require_super_for_system_schema_ddl=information_schema,mysql,performance_schema,sys
  415. require_super_for_system_table_writes=event,func,plugin,proc,heartbeat
  416. reserved_super_connections=20
  417. rpl_semi_sync_master_async_notify_sleep_interval=1000000
  418. rpl_semi_sync_master_async_notify_socket=/semisync/semisync.sock
  419. rpl_semi_sync_master_async_notify_timeout=5000000
  420. rpl_semi_sync_master_do_async_notify=ON
  421. rpl_semi_sync_master_enabled=ON
  422. rpl_semi_sync_master_slave_lag_heartbeat_frequency_us=500000
  423. rpl_semi_sync_master_timeout=3000
  424. rpl_semi_sync_master_trace_level=32
  425. rpl_semi_sync_master_wait_for_slave_count=1
  426. rpl_semi_sync_master_wait_no_slave=ON
  427. rpl_semi_sync_master_wait_point=AFTER_SYNC
  428. rpl_semi_sync_slave_enabled=OFF
  429. rpl_semi_sync_slave_lag_enabled=OFF
  430. rpl_semi_sync_slave_trace_level=32
  431. rpl_stop_slave_timeout=31536000
  432. secure_auth=ON
  433. secure_file_priv=/mysql/tmp/
  434. server_id=1655813737
  435. server_id_bits=32
  436. server_uuid=5fd39415-ca37-11e6-9729-42010a800034
  437. session_track_gtids=OFF
  438. session_track_schema=ON
  439. session_track_state_change=OFF
  440. session_track_system_variables=time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  441. session_track_transaction_info=OFF
  442. sha256_password_auto_generate_rsa_keys=ON
  443. sha256_password_private_key_path=private_key.pem
  444. sha256_password_proxy_users=OFF
  445. sha256_password_public_key_path=public_key.pem
  446. show_compatibility_56=OFF
  447. show_old_temporals=OFF
  448. skip_external_locking=ON
  449. skip_name_resolve=ON
  450. skip_networking=OFF
  451. skip_show_database=OFF
  452. slave_allow_batching=OFF
  453. slave_checkpoint_group=512
  454. slave_checkpoint_period=300
  455. slave_compressed_protocol=OFF
  456. slave_exec_mode=STRICT
  457. slave_load_tmpdir=/mysql/tmp
  458. slave_max_allowed_packet=1073741824
  459. slave_net_timeout=30
  460. slave_parallel_type=DATABASE
  461. slave_parallel_workers=0
  462. slave_pending_jobs_size_max=16777216
  463. slave_preserve_commit_order=OFF
  464. slave_rows_search_algorithms=TABLE_SCAN,INDEX_SCAN
  465. slave_skip_errors=OFF
  466. slave_sql_verify_checksum=ON
  467. slave_transaction_retries=10
  468. slave_type_conversions=
  469. slow_launch_time=2
  470. slow_query_log=ON
  471. slow_query_log_file=/mysql/logs/slow.log
  472. socket=/mysql/mysql.sock
  473. sort_buffer_size=262144
  474. sql_auto_is_null=OFF
  475. sql_big_selects=ON
  476. sql_buffer_result=OFF
  477. sql_log_bin=ON
  478. sql_log_off=OFF
  479. sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  480. sql_notes=ON
  481. sql_quote_show_create=ON
  482. sql_safe_updates=OFF
  483. sql_select_limit=18446744073709551615
  484. sql_slave_skip_counter=0
  485. sql_warnings=OFF
  486. ssl_ca=/mysql/datadir/client_ca_cert.pem
  487. ssl_capath=
  488. ssl_cert=/mysql/datadir/server_cert.pem
  489. ssl_cipher=ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
  490. ssl_crl=
  491. ssl_crlpath=
  492. ssl_key=/mysql/datadir/server_pkey.pem
  493. stored_program_cache=256
  494. super_read_only=OFF
  495. sync_binlog=1
  496. sync_frm=ON
  497. sync_master_info=10000
  498. sync_relay_log=10000
  499. sync_relay_log_info=10000
  500. system_time_zone=UTC
  501. system_user_table=ON
  502. table_definition_cache=1400
  503. table_open_cache=2000
  504. table_open_cache_instances=16
  505. thread_cache_size=48
  506. thread_handling=one-thread-per-connection
  507. thread_stack=262144
  508. time_format=%H:%i:%s
  509. time_zone=SYSTEM
  510. timestamp=1511213904.401692
  511. tls_version=TLSv1,TLSv1.1,TLSv1.2
  512. tmp_table_size=16777216
  513. tmpdir=/mysql/tmp
  514. transaction_alloc_block_size=8192
  515. transaction_allow_batching=OFF
  516. transaction_prealloc_size=4096
  517. transaction_write_set_extraction=OFF
  518. tx_isolation=REPEATABLE-READ
  519. tx_read_only=OFF
  520. unique_checks=ON
  521. updatable_views_with_limit=YES
  522. version=5.7.14-google-log
  523. version_comment=(Google)
  524. version_compile_machine=x86_64
  525. version_compile_os=Linux
  526. wait_timeout=28800
  527. warning_count=0
  528.  
  529. Per second averages calculated from the last 21 seconds
  530. -----------------
  531. BACKGROUND THREAD
  532. -----------------
  533. srv_master_thread loops: 454 srv_active, 0 srv_shutdown, 18 srv_idle
  534. srv_master_thread log flush and writes: 472
  535. ----------
  536. SEMAPHORES
  537. ----------
  538. OS WAIT ARRAY INFO: reservation count 22416
  539. OS WAIT ARRAY INFO: signal count 20532
  540. RW-shared spins 0, rounds 23685, OS waits 11571
  541. RW-excl spins 0, rounds 2629, OS waits 45
  542. RW-sx spins 1, rounds 30, OS waits 1
  543. Spin rounds per wait: 23685.00 RW-shared, 2629.00 RW-excl, 30.00 RW-sx
  544. ------------
  545. TRANSACTIONS
  546. ------------
  547. Trx id counter 923538034
  548. Purge done for trx's n:o < 923538030 undo n:o < 0 state: running but idle
  549. History list length 2188
  550. LIST OF TRANSACTIONS FOR EACH SESSION:
  551. ---TRANSACTION 375459551693520, not started
  552. 0 lock struct(s), heap size 1136, 0 row lock(s)
  553. ---TRANSACTION 375459551692608, not started
  554. 0 lock struct(s), heap size 1136, 0 row lock(s)
  555. ---TRANSACTION 375459551694432, not started
  556. 0 lock struct(s), heap size 1136, 0 row lock(s)
  557. --------
  558. FILE I/O
  559. --------
  560. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  561. I/O thread 1 state: waiting for completed aio requests (log thread)
  562. I/O thread 2 state: waiting for completed aio requests (read thread)
  563. I/O thread 3 state: waiting for completed aio requests (read thread)
  564. I/O thread 4 state: waiting for completed aio requests (read thread)
  565. I/O thread 5 state: waiting for completed aio requests (read thread)
  566. I/O thread 6 state: waiting for completed aio requests (write thread)
  567. I/O thread 7 state: waiting for completed aio requests (write thread)
  568. I/O thread 8 state: waiting for completed aio requests (write thread)
  569. I/O thread 9 state: waiting for completed aio requests (write thread)
  570. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  571. ibuf aio reads:, log i/o's:, sync i/o's:
  572. Pending flushes (fsync) log: 0; buffer pool: 0
  573. 132950 OS file reads, 17513 OS file writes, 11810 OS fsyncs
  574. 20.48 reads/s, 16384 avg bytes/read, 43.52 writes/s, 18.48 fsyncs/s
  575. -------------------------------------
  576. INSERT BUFFER AND ADAPTIVE HASH INDEX
  577. -------------------------------------
  578. Ibuf: size 1, free list len 81, seg size 83, 110 merges
  579. merged operations:
  580. insert 147, delete mark 5, delete 3
  581. discarded operations:
  582. insert 0, delete mark 0, delete 0
  583. Hash table size 10092529, node heap has 119 buffer(s)
  584. Hash table size 10092529, node heap has 41 buffer(s)
  585. Hash table size 10092529, node heap has 29 buffer(s)
  586. Hash table size 10092529, node heap has 1761 buffer(s)
  587. Hash table size 10092529, node heap has 77 buffer(s)
  588. Hash table size 10092529, node heap has 13 buffer(s)
  589. Hash table size 10092529, node heap has 14 buffer(s)
  590. Hash table size 10092529, node heap has 351 buffer(s)
  591. 3181.13 hash searches/s, 2702.35 non-hash searches/s
  592. ---
  593. LOG
  594. ---
  595. Log sequence number 231371250929
  596. Log flushed up to 231371250912
  597. Pages flushed up to 231371250069
  598. Last checkpoint at 231371237449
  599. 0 pending log flushes, 0 pending chkp writes
  600. 9390 log i/o's done, 12.86 log i/o's/second
  601. ----------------------
  602. BUFFER POOL AND MEMORY
  603. ----------------------
  604. Total large memory allocated 41778413568
  605. Dictionary memory allocated 15070313
  606. Buffer pool size 2490064
  607. Free buffers 2352880
  608. Database pages 134779
  609. Old database pages 49908
  610. Modified db pages 8
  611. Pending reads 0
  612. Pending writes: LRU 0, flush list 0, single page 0
  613. Pages made young 8, not young 0
  614. 0.05 youngs/s, 0.00 non-youngs/s
  615. Pages read 132333, created 2446, written 7006
  616. 20.28 reads/s, 0.19 creates/s, 29.81 writes/s
  617. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  618. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  619. LRU len: 134779, unzip_LRU len: 0
  620. I/O sum[0]:cur[1808], unzip sum[0]:cur[0]
  621. ----------------------
  622. INDIVIDUAL BUFFER POOL INFO
  623. ----------------------
  624. ---BUFFER POOL 0
  625. Buffer pool size 311258
  626. Free buffers 294470
  627. Database pages 16487
  628. Old database pages 6106
  629. Modified db pages 1
  630. Pending reads 0
  631. Pending writes: LRU 0, flush list 0, single page 0
  632. Pages made young 2, not young 0
  633. 0.05 youngs/s, 0.00 non-youngs/s
  634. Pages read 16164, created 323, written 1314
  635. 2.67 reads/s, 0.05 creates/s, 7.29 writes/s
  636. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  637. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  638. LRU len: 16487, unzip_LRU len: 0
  639. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  640. ---BUFFER POOL 1
  641. Buffer pool size 311258
  642. Free buffers 294680
  643. Database pages 16281
  644. Old database pages 6029
  645. Modified db pages 0
  646. Pending reads 0
  647. Pending writes: LRU 0, flush list 0, single page 0
  648. Pages made young 1, not young 0
  649. 0.00 youngs/s, 0.00 non-youngs/s
  650. Pages read 16022, created 259, written 593
  651. 2.14 reads/s, 0.00 creates/s, 1.81 writes/s
  652. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  653. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  654. LRU len: 16281, unzip_LRU len: 0
  655. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  656. ---BUFFER POOL 2
  657. Buffer pool size 311258
  658. Free buffers 293338
  659. Database pages 17627
  660. Old database pages 6526
  661. Modified db pages 1
  662. Pending reads 0
  663. Pending writes: LRU 0, flush list 0, single page 0
  664. Pages made young 3, not young 0
  665. 0.00 youngs/s, 0.00 non-youngs/s
  666. Pages read 17306, created 321, written 930
  667. 1.00 reads/s, 0.00 creates/s, 3.43 writes/s
  668. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  669. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  670. LRU len: 17627, unzip_LRU len: 0
  671. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  672. ---BUFFER POOL 3
  673. Buffer pool size 311258
  674. Free buffers 294783
  675. Database pages 16173
  676. Old database pages 5990
  677. Modified db pages 2
  678. Pending reads 0
  679. Pending writes: LRU 0, flush list 0, single page 0
  680. Pages made young 0, not young 0
  681. 0.00 youngs/s, 0.00 non-youngs/s
  682. Pages read 15824, created 349, written 1188
  683. 6.48 reads/s, 0.00 creates/s, 7.52 writes/s
  684. Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
  685. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  686. LRU len: 16173, unzip_LRU len: 0
  687. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  688. ---BUFFER POOL 4
  689. Buffer pool size 311258
  690. Free buffers 294111
  691. Database pages 16842
  692. Old database pages 6237
  693. Modified db pages 3
  694. Pending reads 0
  695. Pending writes: LRU 0, flush list 0, single page 0
  696. Pages made young 0, not young 0
  697. 0.00 youngs/s, 0.00 non-youngs/s
  698. Pages read 16515, created 327, written 847
  699. 2.48 reads/s, 0.00 creates/s, 2.14 writes/s
  700. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  701. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  702. LRU len: 16842, unzip_LRU len: 0
  703. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  704. ---BUFFER POOL 5
  705. Buffer pool size 311258
  706. Free buffers 293676
  707. Database pages 17285
  708. Old database pages 6400
  709. Modified db pages 0
  710. Pending reads 0
  711. Pending writes: LRU 0, flush list 0, single page 0
  712. Pages made young 2, not young 0
  713. 0.00 youngs/s, 0.00 non-youngs/s
  714. Pages read 16974, created 311, written 499
  715. 2.38 reads/s, 0.00 creates/s, 0.29 writes/s
  716. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  717. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  718. LRU len: 17285, unzip_LRU len: 0
  719. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  720. ---BUFFER POOL 6
  721. Buffer pool size 311258
  722. Free buffers 294669
  723. Database pages 16286
  724. Old database pages 6031
  725. Modified db pages 0
  726. Pending reads 0
  727. Pending writes: LRU 0, flush list 0, single page 0
  728. Pages made young 0, not young 0
  729. 0.00 youngs/s, 0.00 non-youngs/s
  730. Pages read 15999, created 287, written 816
  731. 1.29 reads/s, 0.14 creates/s, 4.38 writes/s
  732. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  733. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  734. LRU len: 16286, unzip_LRU len: 0
  735. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  736. ---BUFFER POOL 7
  737. Buffer pool size 311258
  738. Free buffers 293153
  739. Database pages 17798
  740. Old database pages 6589
  741. Modified db pages 1
  742. Pending reads 0
  743. Pending writes: LRU 0, flush list 0, single page 0
  744. Pages made young 0, not young 0
  745. 0.00 youngs/s, 0.00 non-youngs/s
  746. Pages read 17529, created 269, written 819
  747. 1.86 reads/s, 0.00 creates/s, 2.95 writes/s
  748. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  749. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  750. LRU len: 17798, unzip_LRU len: 0
  751. I/O sum[0]:cur[226], unzip sum[0]:cur[0]
  752. --------------
  753. ROW OPERATIONS
  754. --------------
  755. 0 queries inside InnoDB, 0 queries in queue
  756. 0 read views open inside InnoDB
  757. Process ID=1, Main thread ID=139645190752000, state: sleeping
  758. Number of rows inserted 232159, updated 7538, deleted 72, read 74948240
  759. 1.14 inserts/s, 10.19 updates/s, 0.00 deletes/s, 62857.63 reads/s
Add Comment
Please, Sign In to add comment