API tools faq
paste
Advertisement
Guest User

mysql stats

a guest
Nov 26th, 2015
278
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.12 KB | None | 0 0
raw download clone embed print report
  1.  
  2. mysql> show global status;
  3. +-----------------------------------------------+----------------+
  4. | Variable_name | Value |
  5. +-----------------------------------------------+----------------+
  6. | Aborted_clients | 63 |
  7. | Aborted_connects | 11 |
  8. | Binlog_cache_disk_use | 0 |
  9. | Binlog_cache_use | 0 |
  10. | Binlog_stmt_cache_disk_use | 0 |
  11. | Binlog_stmt_cache_use | 0 |
  12. | Bytes_received | 543930938423 |
  13. | Bytes_sent | 1930266529754 |
  14. | Com_admin_commands | 132149988 |
  15. | Com_assign_to_keycache | 0 |
  16. | Com_alter_db | 0 |
  17. | Com_alter_db_upgrade | 0 |
  18. | Com_alter_event | 0 |
  19. | Com_alter_function | 0 |
  20. | Com_alter_procedure | 0 |
  21. | Com_alter_server | 0 |
  22. | Com_alter_table | 8105150 |
  23. | Com_alter_tablespace | 0 |
  24. | Com_alter_user | 0 |
  25. | Com_analyze | 0 |
  26. | Com_begin | 7511569 |
  27. | Com_binlog | 0 |
  28. | Com_call_procedure | 0 |
  29. | Com_change_db | 31947189 |
  30. | Com_change_master | 0 |
  31. | Com_check | 0 |
  32. | Com_checksum | 0 |
  33. | Com_commit | 741864016 |
  34. | Com_create_db | 0 |
  35. | Com_create_event | 0 |
  36. | Com_create_function | 0 |
  37. | Com_create_index | 147 |
  38. | Com_create_procedure | 0 |
  39. | Com_create_server | 0 |
  40. | Com_create_table | 5994921 |
  41. | Com_create_trigger | 0 |
  42. | Com_create_udf | 0 |
  43. | Com_create_user | 0 |
  44. | Com_create_view | 0 |
  45. | Com_dealloc_sql | 0 |
  46. | Com_delete | 1238003 |
  47. | Com_delete_multi | 0 |
  48. | Com_do | 0 |
  49. | Com_drop_db | 0 |
  50. | Com_drop_event | 0 |
  51. | Com_drop_function | 0 |
  52. | Com_drop_index | 0 |
  53. | Com_drop_procedure | 0 |
  54. | Com_drop_server | 0 |
  55. | Com_drop_table | 1 |
  56. | Com_drop_trigger | 0 |
  57. | Com_drop_user | 0 |
  58. | Com_drop_view | 0 |
  59. | Com_empty_query | 0 |
  60. | Com_execute_sql | 0 |
  61. | Com_flush | 0 |
  62. | Com_get_diagnostics | 0 |
  63. | Com_grant | 0 |
  64. | Com_ha_close | 0 |
  65. | Com_ha_open | 0 |
  66. | Com_ha_read | 0 |
  67. | Com_help | 585 |
  68. | Com_insert | 613230844 |
  69. | Com_insert_select | 97584 |
  70. | Com_install_plugin | 0 |
  71. | Com_kill | 5 |
  72. | Com_load | 0 |
  73. | Com_lock_tables | 10 |
  74. | Com_optimize | 0 |
  75. | Com_preload_keys | 0 |
  76. | Com_prepare_sql | 0 |
  77. | Com_purge | 0 |
  78. | Com_purge_before_date | 0 |
  79. | Com_release_savepoint | 0 |
  80. | Com_rename_table | 0 |
  81. | Com_rename_user | 0 |
  82. | Com_repair | 0 |
  83. | Com_replace | 30479625 |
  84. | Com_replace_select | 0 |
  85. | Com_reset | 0 |
  86. | Com_resignal | 0 |
  87. | Com_revoke | 0 |
  88. | Com_revoke_all | 0 |
  89. | Com_rollback | 735486482 |
  90. | Com_rollback_to_savepoint | 0 |
  91. | Com_savepoint | 0 |
  92. | Com_select | 3888296954 |
  93. | Com_set_option | 1594368652 |
  94. | Com_signal | 0 |
  95. | Com_show_binlog_events | 0 |
  96. | Com_show_binlogs | 0 |
  97. | Com_show_charsets | 0 |
  98. | Com_show_collations | 0 |
  99. | Com_show_create_db | 4 |
  100. | Com_show_create_event | 0 |
  101. | Com_show_create_func | 0 |
  102. | Com_show_create_proc | 0 |
  103. | Com_show_create_table | 2033 |
  104. | Com_show_create_trigger | 3 |
  105. | Com_show_databases | 116 |
  106. | Com_show_engine_logs | 0 |
  107. | Com_show_engine_mutex | 0 |
  108. | Com_show_engine_status | 0 |
  109. | Com_show_events | 0 |
  110. | Com_show_errors | 0 |
  111. | Com_show_fields | 5180849 |
  112. | Com_show_function_code | 0 |
  113. | Com_show_function_status | 5 |
  114. | Com_show_grants | 0 |
  115. | Com_show_keys | 116 |
  116. | Com_show_master_status | 0 |
  117. | Com_show_open_tables | 0 |
  118. | Com_show_plugins | 0 |
  119. | Com_show_privileges | 0 |
  120. | Com_show_procedure_code | 0 |
  121. | Com_show_procedure_status | 5 |
  122. | Com_show_processlist | 0 |
  123. | Com_show_profile | 0 |
  124. | Com_show_profiles | 0 |
  125. | Com_show_relaylog_events | 0 |
  126. | Com_show_slave_hosts | 0 |
  127. | Com_show_slave_status | 0 |
  128. | Com_show_status | 242328 |
  129. | Com_show_storage_engines | 0 |
  130. | Com_show_table_status | 2031 |
  131. | Com_show_tables | 72250813 |
  132. | Com_show_triggers | 2033 |
  133. | Com_show_variables | 6666028 |
  134. | Com_show_warnings | 0 |
  135. | Com_slave_start | 0 |
  136. | Com_slave_stop | 0 |
  137. | Com_stmt_close | 22 |
  138. | Com_stmt_execute | 22 |
  139. | Com_stmt_fetch | 0 |
  140. | Com_stmt_prepare | 23 |
  141. | Com_stmt_reprepare | 0 |
  142. | Com_stmt_reset | 0 |
  143. | Com_stmt_send_long_data | 0 |
  144. | Com_truncate | 13 |
  145. | Com_uninstall_plugin | 0 |
  146. | Com_unlock_tables | 10 |
  147. | Com_update | 71282659 |
  148. | Com_update_multi | 0 |
  149. | Com_xa_commit | 0 |
  150. | Com_xa_end | 0 |
  151. | Com_xa_prepare | 0 |
  152. | Com_xa_recover | 0 |
  153. | Com_xa_rollback | 0 |
  154. | Com_xa_start | 0 |
  155. | Compression | OFF |
  156. | Connection_errors_accept | 0 |
  157. | Connection_errors_internal | 0 |
  158. | Connection_errors_max_connections | 0 |
  159. | Connection_errors_peer_address | 0 |
  160. | Connection_errors_select | 0 |
  161. | Connection_errors_tcpwrap | 0 |
  162. | Connections | 21121749 |
  163. | Created_tmp_disk_tables | 6158440 |
  164. | Created_tmp_files | 5237 |
  165. | Created_tmp_tables | 92537439 |
  166. | Delayed_errors | 0 |
  167. | Delayed_insert_threads | 0 |
  168. | Delayed_writes | 0 |
  169. | Flush_commands | 1 |
  170. | Handler_commit | 3050776952 |
  171. | Handler_delete | 5072511 |
  172. | Handler_discover | 0 |
  173. | Handler_external_lock | 4961630837 |
  174. | Handler_mrr_init | 0 |
  175. | Handler_prepare | 0 |
  176. | Handler_read_first | 204122605 |
  177. | Handler_read_key | 12589768619 |
  178. | Handler_read_last | 170254486 |
  179. | Handler_read_next | 188407400964 |
  180. | Handler_read_prev | 36334380197 |
  181. | Handler_read_rnd | 353948044 |
  182. | Handler_read_rnd_next | 266467437770 |
  183. | Handler_rollback | 442669 |
  184. | Handler_savepoint | 0 |
  185. | Handler_savepoint_rollback | 0 |
  186. | Handler_update | 1939959583 |
  187. | Handler_write | 1639655890 |
  188. | Innodb_buffer_pool_dump_status | not started |
  189. | Innodb_buffer_pool_load_status | not started |
  190. | Innodb_buffer_pool_pages_data | 900939 |
  191. | Innodb_buffer_pool_bytes_data | 14760984576 |
  192. | Innodb_buffer_pool_pages_dirty | 138114 |
  193. | Innodb_buffer_pool_bytes_dirty | 2262859776 |
  194. | Innodb_buffer_pool_pages_flushed | 589768119 |
  195. | Innodb_buffer_pool_pages_free | 6560 |
  196. | Innodb_buffer_pool_pages_misc | 75537 |
  197. | Innodb_buffer_pool_pages_total | 983036 |
  198. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  199. | Innodb_buffer_pool_read_ahead | 74990994 |
  200. | Innodb_buffer_pool_read_ahead_evicted | 118776 |
  201. | Innodb_buffer_pool_read_requests | 370424607346 |
  202. | Innodb_buffer_pool_reads | 329533959 |
  203. | Innodb_buffer_pool_wait_free | 7409 |
  204. | Innodb_buffer_pool_write_requests | 6222595374 |
  205. | Innodb_data_fsyncs | 684041292 |
  206. | Innodb_data_pending_fsyncs | 1 |
  207. | Innodb_data_pending_reads | 3 |
  208. | Innodb_data_pending_writes | 0 |
  209. | Innodb_data_read | 7076096315392 |
  210. | Innodb_data_reads | 432234594 |
  211. | Innodb_data_writes | 776527256 |
  212. | Innodb_data_written | 19658832812544 |
  213. | Innodb_dblwr_pages_written | 589775536 |
  214. | Innodb_dblwr_writes | 14574293 |
  215. | Innodb_have_atomic_builtins | ON |
  216. | Innodb_log_waits | 0 |
  217. | Innodb_log_write_requests | 498149754 |
  218. | Innodb_log_writes | 167769519 |
  219. | Innodb_os_log_fsyncs | 168110249 |
  220. | Innodb_os_log_pending_fsyncs | 1 |
  221. | Innodb_os_log_pending_writes | 0 |
  222. | Innodb_os_log_written | 332945398784 |
  223. | Innodb_page_size | 16384 |
  224. | Innodb_pages_created | 5449900 |
  225. | Innodb_pages_read | 431976158 |
  226. | Innodb_pages_written | 589775536 |
  227. | Innodb_row_lock_current_waits | 0 |
  228. | Innodb_row_lock_time | 157424 |
  229. | Innodb_row_lock_time_avg | 113 |
  230. | Innodb_row_lock_time_max | 2216 |
  231. | Innodb_row_lock_waits | 1381 |
  232. | Innodb_rows_deleted | 5072514 |
  233. | Innodb_rows_inserted | 852758055 |
  234. | Innodb_rows_read | 491553491996 |
  235. | Innodb_rows_updated | 649110248 |
  236. | Innodb_num_open_files | 200000 |
  237. | Innodb_truncated_status_writes | 0 |
  238. | Innodb_available_undo_logs | 128 |
  239. | Key_blocks_not_flushed | 0 |
  240. | Key_blocks_unused | 22311 |
  241. | Key_blocks_used | 53585 |
  242. | Key_read_requests | 584034577 |
  243. | Key_reads | 29740659 |
  244. | Key_write_requests | 101349107 |
  245. | Key_writes | 14375595 |
  246. | Last_query_cost | 0.000000 |
  247. | Last_query_partial_plans | 0 |
  248. | Max_used_connections | 291 |
  249. | Not_flushed_delayed_rows | 0 |
  250. | Open_files | 9214 |
  251. | Open_streams | 0 |
  252. | Open_table_definitions | 315836 |
  253. | Open_tables | 200000 |
  254. | Opened_files | 110663380 |
  255. | Opened_table_definitions | 316971 |
  256. | Opened_tables | 285544112 |
  257. | Performance_schema_accounts_lost | 0 |
  258. | Performance_schema_cond_classes_lost | 0 |
  259. | Performance_schema_cond_instances_lost | 0 |
  260. | Performance_schema_digest_lost | 6335292065 |
  261. | Performance_schema_file_classes_lost | 0 |
  262. | Performance_schema_file_handles_lost | 130100394 |
  263. | Performance_schema_file_instances_lost | 0 |
  264. | Performance_schema_hosts_lost | 0 |
  265. | Performance_schema_locker_lost | 0 |
  266. | Performance_schema_mutex_classes_lost | 0 |
  267. | Performance_schema_mutex_instances_lost | 0 |
  268. | Performance_schema_rwlock_classes_lost | 0 |
  269. | Performance_schema_rwlock_instances_lost | 0 |
  270. | Performance_schema_session_connect_attrs_lost | 0 |
  271. | Performance_schema_socket_classes_lost | 0 |
  272. | Performance_schema_socket_instances_lost | 0 |
  273. | Performance_schema_stage_classes_lost | 0 |
  274. | Performance_schema_statement_classes_lost | 0 |
  275. | Performance_schema_table_handles_lost | 0 |
  276. | Performance_schema_table_instances_lost | 0 |
  277. | Performance_schema_thread_classes_lost | 0 |
  278. | Performance_schema_thread_instances_lost | 0 |
  279. | Performance_schema_users_lost | 0 |
  280. | Prepared_stmt_count | 0 |
  281. | Qcache_free_blocks | 1 |
  282. | Qcache_free_memory | 33536840 |
  283. | Qcache_hits | 0 |
  284. | Qcache_inserts | 0 |
  285. | Qcache_lowmem_prunes | 0 |
  286. | Qcache_not_cached | 3867473666 |
  287. | Qcache_queries_in_cache | 0 |
  288. | Qcache_total_blocks | 1 |
  289. | Queries | 8262090685 |
  290. | Questions | 7836091851 |
  291. | Select_full_join | 73414 |
  292. | Select_full_range_join | 64 |
  293. | Select_range | 271646459 |
  294. | Select_range_check | 0 |
  295. | Select_scan | 315076005 |
  296. | Slave_heartbeat_period | |
  297. | Slave_last_heartbeat | |
  298. | Slave_open_temp_tables | 0 |
  299. | Slave_received_heartbeats | |
  300. | Slave_retried_transactions | |
  301. | Slave_running | OFF |
  302. | Slow_launch_threads | 0 |
  303. | Slow_queries | 3130 |
  304. | Sort_merge_passes | 3187 |
  305. | Sort_range | 45799971 |
  306. | Sort_rows | 1329669813 |
  307. | Sort_scan | 4287235 |
  308. | Ssl_accept_renegotiates | 0 |
  309. | Ssl_accepts | 0 |
  310. | Ssl_callback_cache_hits | 0 |
  311. | Ssl_cipher | |
  312. | Ssl_cipher_list | |
  313. | Ssl_client_connects | 0 |
  314. | Ssl_connect_renegotiates | 0 |
  315. | Ssl_ctx_verify_depth | 0 |
  316. | Ssl_ctx_verify_mode | 0 |
  317. | Ssl_default_timeout | 0 |
  318. | Ssl_finished_accepts | 0 |
  319. | Ssl_finished_connects | 0 |
  320. | Ssl_server_not_after | |
  321. | Ssl_server_not_before | |
  322. | Ssl_session_cache_hits | 0 |
  323. | Ssl_session_cache_misses | 0 |
  324. | Ssl_session_cache_mode | NONE |
  325. | Ssl_session_cache_overflows | 0 |
  326. | Ssl_session_cache_size | 0 |
  327. | Ssl_session_cache_timeouts | 0 |
  328. | Ssl_sessions_reused | 0 |
  329. | Ssl_used_session_cache_entries | 0 |
  330. | Ssl_verify_depth | 0 |
  331. | Ssl_verify_mode | 0 |
  332. | Ssl_version | |
  333. | Table_locks_immediate | 2356575232 |
  334. | Table_locks_waited | 24 |
  335. | Table_open_cache_hits | 2115824470 |
  336. | Table_open_cache_misses | 285544112 |
  337. | Table_open_cache_overflows | 285343673 |
  338. | Tc_log_max_pages_used | 0 |
  339. | Tc_log_page_size | 0 |
  340. | Tc_log_page_waits | 0 |
  341. | Threads_cached | 19 |
  342. | Threads_connected | 272 |
  343. | Threads_created | 291 |
  344. | Threads_running | 22 |
  345. | Uptime | 1823180 |
  346. | Uptime_since_flush_status | 1823180 |
  347. +-----------------------------------------------+----------------+
  348. 341 rows in set (0.00 sec)
  349.  
  350.  
  351. show variables:
  352. Variable_name Value
  353. auto_increment_increment 1
  354. auto_increment_offset 1
  355. autocommit ON
  356. automatic_sp_privileges ON
  357. avoid_temporal_upgrade OFF
  358. back_log 100
  359. basedir /usr
  360. big_tables OFF
  361. bind_address *
  362. binlog_cache_size 32768
  363. binlog_checksum CRC32
  364. binlog_direct_non_transactional_updates OFF
  365. binlog_error_action IGNORE_ERROR
  366. binlog_format STATEMENT
  367. binlog_gtid_simple_recovery OFF
  368. binlog_max_flush_queue_time 0
  369. binlog_order_commits ON
  370. binlog_row_image FULL
  371. binlog_rows_query_log_events OFF
  372. binlog_stmt_cache_size 32768
  373. binlogging_impossible_mode IGNORE_ERROR
  374. block_encryption_mode aes-128-ecb
  375. bulk_insert_buffer_size 8388608
  376. character_set_client utf8
  377. character_set_connection utf8
  378. character_set_database latin1
  379. character_set_filesystem binary
  380. character_set_results utf8
  381. character_set_server latin1
  382. character_set_system utf8
  383. character_sets_dir /usr/share/mysql/charsets/
  384. collation_connection utf8_general_ci
  385. collation_database latin1_swedish_ci
  386. collation_server latin1_swedish_ci
  387. completion_type NO_CHAIN
  388. concurrent_insert AUTO
  389. connect_timeout 10
  390. core_file OFF
  391. datadir /dbdata/mysql/
  392. date_format %Y-%m-%d
  393. datetime_format %Y-%m-%d %H:%i:%s
  394. default_storage_engine InnoDB
  395. default_tmp_storage_engine InnoDB
  396. default_week_format 0
  397. delay_key_write ON
  398. delayed_insert_limit 100
  399. delayed_insert_timeout 300
  400. delayed_queue_size 1000
  401. disconnect_on_expired_password ON
  402. div_precision_increment 4
  403. end_markers_in_json OFF
  404. enforce_gtid_consistency OFF
  405. eq_range_index_dive_limit 10
  406. error_count 0
  407. event_scheduler OFF
  408. expire_logs_days 0
  409. explicit_defaults_for_timestamp OFF
  410. external_user
  411. flush OFF
  412. flush_time 0
  413. foreign_key_checks ON
  414. ft_boolean_syntax + -><()~*:""&|
  415. ft_max_word_len 84
  416. ft_min_word_len 4
  417. ft_query_expansion_limit 20
  418. ft_stopword_file (built-in)
  419. general_log OFF
  420. general_log_file /dbdata/mysql/db1-pvsense-b.log
  421. group_concat_max_len 1024
  422. gtid_executed
  423. gtid_mode OFF
  424. gtid_next AUTOMATIC
  425. gtid_owned
  426. gtid_purged
  427. have_compress YES
  428. have_crypt YES
  429. have_dynamic_loading YES
  430. have_geometry YES
  431. have_openssl DISABLED
  432. have_profiling YES
  433. have_query_cache YES
  434. have_rtree_keys YES
  435. have_ssl DISABLED
  436. have_symlink DISABLED
  437. host_cache_size 638
  438. hostname db1-pvsense-b
  439. identity 0
  440. ignore_builtin_innodb OFF
  441. ignore_db_dirs
  442. init_connect
  443. init_file
  444. init_slave
  445. innodb_adaptive_flushing ON
  446. innodb_adaptive_flushing_lwm 10
  447. innodb_adaptive_hash_index ON
  448. innodb_adaptive_max_sleep_delay 150000
  449. innodb_additional_mem_pool_size 8388608
  450. innodb_api_bk_commit_interval 5
  451. innodb_api_disable_rowlock OFF
  452. innodb_api_enable_binlog OFF
  453. innodb_api_enable_mdl OFF
  454. innodb_api_trx_level 0
  455. innodb_autoextend_increment 64
  456. innodb_autoinc_lock_mode 1
  457. innodb_buffer_pool_dump_at_shutdown OFF
  458. innodb_buffer_pool_dump_now OFF
  459. innodb_buffer_pool_filename ib_buffer_pool
  460. innodb_buffer_pool_instances 8
  461. innodb_buffer_pool_load_abort OFF
  462. innodb_buffer_pool_load_at_startup OFF
  463. innodb_buffer_pool_load_now OFF
  464. innodb_buffer_pool_size 16106127360
  465. innodb_change_buffer_max_size 25
  466. innodb_change_buffering all
  467. innodb_checksum_algorithm innodb
  468. innodb_checksums ON
  469. innodb_cmp_per_index_enabled OFF
  470. innodb_commit_concurrency 0
  471. innodb_compression_failure_threshold_pct 5
  472. innodb_compression_level 6
  473. innodb_compression_pad_pct_max 50
  474. innodb_concurrency_tickets 5000
  475. innodb_data_file_path ibdata1:12M:autoextend
  476. innodb_data_home_dir
  477. innodb_disable_sort_file_cache OFF
  478. innodb_doublewrite ON
  479. innodb_fast_shutdown 1
  480. innodb_file_format Antelope
  481. innodb_file_format_check ON
  482. innodb_file_format_max Antelope
  483. innodb_file_per_table ON
  484. innodb_flush_log_at_timeout 1
  485. innodb_flush_log_at_trx_commit 1
  486. innodb_flush_method O_DIRECT
  487. innodb_flush_neighbors 1
  488. innodb_flushing_avg_loops 30
  489. innodb_force_load_corrupted OFF
  490. innodb_force_recovery 0
  491. innodb_ft_aux_table
  492. innodb_ft_cache_size 8000000
  493. innodb_ft_enable_diag_print OFF
  494. innodb_ft_enable_stopword ON
  495. innodb_ft_max_token_size 84
  496. innodb_ft_min_token_size 3
  497. innodb_ft_num_word_optimize 2000
  498. innodb_ft_result_cache_limit 2000000000
  499. innodb_ft_server_stopword_table
  500. innodb_ft_sort_pll_degree 2
  501. innodb_ft_total_cache_size 640000000
  502. innodb_ft_user_stopword_table
  503. innodb_io_capacity 1000
  504. innodb_io_capacity_max 2000
  505. innodb_large_prefix OFF
  506. innodb_lock_wait_timeout 300
  507. innodb_locks_unsafe_for_binlog OFF
  508. innodb_log_buffer_size 134217728
  509. innodb_log_compressed_pages ON
  510. innodb_log_file_size 104857600
  511. innodb_log_files_in_group 2
  512. innodb_log_group_home_dir ./
  513. innodb_lru_scan_depth 1024
  514. innodb_max_dirty_pages_pct 75
  515. innodb_max_dirty_pages_pct_lwm 0
  516. innodb_max_purge_lag 0
  517. innodb_max_purge_lag_delay 0
  518. innodb_mirrored_log_groups 1
  519. innodb_monitor_disable
  520. innodb_monitor_enable
  521. innodb_monitor_reset
  522. innodb_monitor_reset_all
  523. innodb_old_blocks_pct 37
  524. innodb_old_blocks_time 1000
  525. innodb_online_alter_log_max_size 134217728
  526. innodb_open_files 200000
  527. innodb_optimize_fulltext_only OFF
  528. innodb_page_size 16384
  529. innodb_print_all_deadlocks OFF
  530. innodb_purge_batch_size 300
  531. innodb_purge_threads 1
  532. innodb_random_read_ahead OFF
  533. innodb_read_ahead_threshold 56
  534. innodb_read_io_threads 32
  535. innodb_read_only OFF
  536. innodb_replication_delay 0
  537. innodb_rollback_on_timeout OFF
  538. innodb_rollback_segments 128
  539. innodb_sort_buffer_size 1048576
  540. innodb_spin_wait_delay 6
  541. innodb_stats_auto_recalc ON
  542. innodb_stats_method nulls_equal
  543. innodb_stats_on_metadata OFF
  544. innodb_stats_persistent ON
  545. innodb_stats_persistent_sample_pages 20
  546. innodb_stats_sample_pages 8
  547. innodb_stats_transient_sample_pages 8
  548. innodb_status_output OFF
  549. innodb_status_output_locks OFF
  550. innodb_strict_mode OFF
  551. innodb_support_xa ON
  552. innodb_sync_array_size 1
  553. innodb_sync_spin_loops 30
  554. innodb_table_locks ON
  555. innodb_thread_concurrency 0
  556. innodb_thread_sleep_delay 10000
  557. innodb_undo_directory .
  558. innodb_undo_logs 128
  559. innodb_undo_tablespaces 0
  560. innodb_use_native_aio ON
  561. innodb_use_sys_malloc ON
  562. innodb_version 5.6.24
  563. innodb_write_io_threads 32
  564. insert_id 0
  565. interactive_timeout 3600
  566. join_buffer_size 524288
  567. keep_files_on_create OFF
  568. key_buffer_size 67108864
  569. key_cache_age_threshold 300
  570. key_cache_block_size 1024
  571. key_cache_division_limit 100
  572. large_files_support ON
  573. large_page_size 0
  574. large_pages OFF
  575. last_insert_id 0
  576. lc_messages en_US
  577. lc_messages_dir /usr/share/mysql/
  578. lc_time_names en_US
  579. license GPL
  580. local_infile ON
  581. lock_wait_timeout 31536000
  582. locked_in_memory OFF
  583. log_bin OFF
  584. log_bin_basename
  585. log_bin_index
  586. log_bin_trust_function_creators OFF
  587. log_bin_use_v1_row_events OFF
  588. log_error /var/log/mysqld.log
  589. log_output FILE
  590. log_queries_not_using_indexes OFF
  591. log_slave_updates OFF
  592. log_slow_admin_statements OFF
  593. log_slow_slave_statements OFF
  594. log_throttle_queries_not_using_indexes 0
  595. log_warnings 1
  596. long_query_time 10.000000
  597. low_priority_updates OFF
  598. lower_case_file_system OFF
  599. lower_case_table_names 0
  600. master_info_repository FILE
  601. master_verify_checksum OFF
  602. max_allowed_packet 16777216
  603. max_binlog_cache_size 18446744073709547520
  604. max_binlog_size 1073741824
  605. max_binlog_stmt_cache_size 18446744073709547520
  606. max_connect_errors 10000
  607. max_connections 700
  608. max_delayed_threads 20
  609. max_digest_length 1024
  610. max_error_count 64
  611. max_heap_table_size 67108864
  612. max_insert_delayed_threads 20
  613. max_join_size 18446744073709551615
  614. max_length_for_sort_data 1024
  615. max_prepared_stmt_count 16382
  616. max_relay_log_size 0
  617. max_seeks_for_key 18446744073709551615
  618. max_sort_length 1024
  619. max_sp_recursion_depth 0
  620. max_tmp_tables 32
  621. max_user_connections 0
  622. max_write_lock_count 18446744073709551615
  623. metadata_locks_cache_size 1024
  624. metadata_locks_hash_instances 8
  625. min_examined_row_limit 0
  626. multi_range_count 256
  627. myisam_data_pointer_size 6
  628. myisam_max_sort_file_size 9223372036853727232
  629. myisam_mmap_size 18446744073709551615
  630. myisam_recover_options OFF
  631. myisam_repair_threads 1
  632. myisam_sort_buffer_size 67108864
  633. myisam_stats_method nulls_unequal
  634. myisam_use_mmap OFF
  635. net_buffer_length 16384
  636. net_read_timeout 30
  637. net_retry_count 10
  638. net_write_timeout 60
  639. new OFF
  640. old OFF
  641. old_alter_table OFF
  642. old_passwords 0
  643. open_files_limit 800000
  644. optimizer_prune_level 1
  645. optimizer_search_depth 62
  646. optimizer_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
  647. optimizer_trace enabled=off,one_line=off
  648. optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  649. optimizer_trace_limit 1
  650. optimizer_trace_max_mem_size 16384
  651. optimizer_trace_offset -1
  652. performance_schema ON
  653. performance_schema_accounts_size 100
  654. performance_schema_digests_size 10000
  655. performance_schema_events_stages_history_long_size 10000
  656. performance_schema_events_stages_history_size 10
  657. performance_schema_events_statements_history_long_size 10000
  658. performance_schema_events_statements_history_size 10
  659. performance_schema_events_waits_history_long_size 10000
  660. performance_schema_events_waits_history_size 10
  661. performance_schema_hosts_size 100
  662. performance_schema_max_cond_classes 80
  663. performance_schema_max_cond_instances 1002900
  664. performance_schema_max_file_classes 50
  665. performance_schema_max_file_handles 32768
  666. performance_schema_max_file_instances 2308000
  667. performance_schema_max_mutex_classes 200
  668. performance_schema_max_mutex_instances 5005200
  669. performance_schema_max_rwlock_classes 40
  670. performance_schema_max_rwlock_instances 3001800
  671. performance_schema_max_socket_classes 10
  672. performance_schema_max_socket_instances 1420
  673. performance_schema_max_stage_classes 150
  674. performance_schema_max_statement_classes 168
  675. performance_schema_max_table_handles 400000
  676. performance_schema_max_table_instances 625000
  677. performance_schema_max_thread_classes 50
  678. performance_schema_max_thread_instances 1500
  679. performance_schema_session_connect_attrs_size 512
  680. performance_schema_setup_actors_size 100
  681. performance_schema_setup_objects_size 100
  682. performance_schema_users_size 100
  683. pid_file /var/run/mysqld/mysqld.pid
  684. plugin_dir /usr/lib64/mysql/plugin/
  685. port 3306
  686. preload_buffer_size 32768
  687. profiling OFF
  688. profiling_history_size 15
  689. protocol_version 10
  690. proxy_user
  691. pseudo_slave_mode OFF
  692. pseudo_thread_id 21122840
  693. query_alloc_block_size 8192
  694. query_cache_limit 1048576
  695. query_cache_min_res_unit 4096
  696. query_cache_size 33554432
  697. query_cache_type OFF
  698. query_cache_wlock_invalidate OFF
  699. query_prealloc_size 8192
  700. rand_seed1 0
  701. rand_seed2 0
  702. range_alloc_block_size 4096
  703. read_buffer_size 1048576
  704. read_only OFF
  705. read_rnd_buffer_size 2097152
  706. relay_log
  707. relay_log_basename
  708. relay_log_index
  709. relay_log_info_file relay-log.info
  710. relay_log_info_repository FILE
  711. relay_log_purge ON
  712. relay_log_recovery OFF
  713. relay_log_space_limit 0
  714. report_host
  715. report_password
  716. report_port 3306
  717. report_user
  718. rpl_stop_slave_timeout 31536000
  719. secure_auth ON
  720. secure_file_priv
  721. server_id 0
  722. server_id_bits 32
  723. server_uuid 98cb5a3f-e437-11e4-985b-42010afa023f
  724. show_old_temporals OFF
  725. simplified_binlog_gtid_recovery OFF
  726. skip_external_locking ON
  727. skip_name_resolve ON
  728. skip_networking OFF
  729. skip_show_database OFF
  730. slave_allow_batching OFF
  731. slave_checkpoint_group 512
  732. slave_checkpoint_period 300
  733. slave_compressed_protocol OFF
  734. slave_exec_mode STRICT
  735. slave_load_tmpdir /dbdata/mysql/tmp
  736. slave_max_allowed_packet 1073741824
  737. slave_net_timeout 3600
  738. slave_parallel_workers 0
  739. slave_pending_jobs_size_max 16777216
  740. slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN
  741. slave_skip_errors OFF
  742. slave_sql_verify_checksum ON
  743. slave_transaction_retries 10
  744. slave_type_conversions
  745. slow_launch_time 2
  746. slow_query_log OFF
  747. slow_query_log_file /dbdata/mysql/db1-pvsense-b-slow.log
  748. socket /dbdata/mysql/mysql.sock
  749. sort_buffer_size 524288
  750. sql_auto_is_null OFF
  751. sql_big_selects ON
  752. sql_buffer_result OFF
  753. sql_log_bin ON
  754. sql_log_off OFF
  755. sql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
  756. sql_notes ON
  757. sql_quote_show_create ON
  758. sql_safe_updates OFF
  759. sql_select_limit 18446744073709551615
  760. sql_slave_skip_counter 0
  761. sql_warnings OFF
  762. ssl_ca
  763. ssl_capath
  764. ssl_cert
  765. ssl_cipher
  766. ssl_crl
  767. ssl_crlpath
  768. ssl_key
  769. storage_engine InnoDB
  770. stored_program_cache 256
  771. sync_binlog 0
  772. sync_frm ON
  773. sync_master_info 10000
  774. sync_relay_log 10000
  775. sync_relay_log_info 10000
  776. system_time_zone GMT
  777. table_definition_cache 500000
  778. table_open_cache 200000
  779. table_open_cache_instances 4
  780. thread_cache_size 32
  781. thread_concurrency 10
  782. thread_handling one-thread-per-connection
  783. thread_stack 262144
  784. time_format %H:%i:%s
  785. time_zone SYSTEM
  786. timed_mutexes OFF
  787. timestamp 1448555642.776873
  788. tmp_table_size 8388608
  789. tmpdir /dbdata/mysql/tmp
  790. transaction_alloc_block_size 8192
  791. transaction_allow_batching OFF
  792. transaction_prealloc_size 4096
  793. tx_isolation REPEATABLE-READ
  794. tx_read_only OFF
  795. unique_checks ON
  796. updatable_views_with_limit YES
  797. version 5.6.24
  798. version_comment MySQL Community Server (GPL)
  799. version_compile_machine x86_64
  800. version_compile_os Linux
  801. wait_timeout 600
  802. warning_count 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!