API tools faq
paste
Guest User

MySQL info

a guest
Oct 8th, 2018
645
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 271.85 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW GLOBAL STATUS;
  2. +-----------------------------------------------+--------------------------------------------------+
  3. | Variable_name | Value |
  4. +-----------------------------------------------+--------------------------------------------------+
  5. | Aborted_clients | 15 |
  6. | Aborted_connects | 526 |
  7. | Binlog_cache_disk_use | 0 |
  8. | Binlog_cache_use | 0 |
  9. | Binlog_stmt_cache_disk_use | 0 |
  10. | Binlog_stmt_cache_use | 0 |
  11. | Bytes_received | 1003121797 |
  12. | Bytes_sent | 523319074 |
  13. | Com_admin_commands | 6896 |
  14. | Com_assign_to_keycache | 0 |
  15. | Com_alter_db | 0 |
  16. | Com_alter_db_upgrade | 0 |
  17. | Com_alter_event | 0 |
  18. | Com_alter_function | 0 |
  19. | Com_alter_instance | 0 |
  20. | Com_alter_procedure | 0 |
  21. | Com_alter_server | 0 |
  22. | Com_alter_table | 156631 |
  23. | Com_alter_tablespace | 0 |
  24. | Com_alter_user | 0 |
  25. | Com_analyze | 0 |
  26. | Com_begin | 0 |
  27. | Com_binlog | 0 |
  28. | Com_call_procedure | 1308 |
  29. | Com_change_db | 1974 |
  30. | Com_change_master | 0 |
  31. | Com_change_repl_filter | 0 |
  32. | Com_check | 99 |
  33. | Com_checksum | 0 |
  34. | Com_commit | 14 |
  35. | Com_create_db | 0 |
  36. | Com_create_event | 0 |
  37. | Com_create_function | 0 |
  38. | Com_create_index | 0 |
  39. | Com_create_procedure | 0 |
  40. | Com_create_server | 0 |
  41. | Com_create_table | 232872 |
  42. | Com_create_trigger | 0 |
  43. | Com_create_udf | 0 |
  44. | Com_create_user | 0 |
  45. | Com_create_view | 228 |
  46. | Com_dealloc_sql | 798 |
  47. | Com_delete | 99973 |
  48. | Com_delete_multi | 19510 |
  49. | Com_do | 0 |
  50. | Com_drop_db | 0 |
  51. | Com_drop_event | 0 |
  52. | Com_drop_function | 0 |
  53. | Com_drop_index | 0 |
  54. | Com_drop_procedure | 0 |
  55. | Com_drop_server | 0 |
  56. | Com_drop_table | 357663 |
  57. | Com_drop_trigger | 0 |
  58. | Com_drop_user | 0 |
  59. | Com_drop_view | 228 |
  60. | Com_empty_query | 0 |
  61. | Com_execute_sql | 1860 |
  62. | Com_explain_other | 0 |
  63. | Com_flush | 13 |
  64. | Com_get_diagnostics | 0 |
  65. | Com_grant | 0 |
  66. | Com_ha_close | 0 |
  67. | Com_ha_open | 0 |
  68. | Com_ha_read | 0 |
  69. | Com_help | 0 |
  70. | Com_insert | 105242 |
  71. | Com_insert_select | 593024 |
  72. | Com_install_plugin | 0 |
  73. | Com_kill | 0 |
  74. | Com_load | 2 |
  75. | Com_lock_tables | 0 |
  76. | Com_optimize | 101 |
  77. | Com_preload_keys | 0 |
  78. | Com_prepare_sql | 1860 |
  79. | Com_purge | 0 |
  80. | Com_purge_before_date | 0 |
  81. | Com_release_savepoint | 0 |
  82. | Com_rename_table | 0 |
  83. | Com_rename_user | 0 |
  84. | Com_repair | 127 |
  85. | Com_replace | 19 |
  86. | Com_replace_select | 0 |
  87. | Com_reset | 0 |
  88. | Com_resignal | 0 |
  89. | Com_revoke | 0 |
  90. | Com_revoke_all | 0 |
  91. | Com_rollback | 0 |
  92. | Com_rollback_to_savepoint | 0 |
  93. | Com_savepoint | 0 |
  94. | Com_select | 397010 |
  95. | Com_set_option | 64770 |
  96. | Com_signal | 0 |
  97. | Com_show_binlog_events | 0 |
  98. | Com_show_binlogs | 3 |
  99. | Com_show_charsets | 0 |
  100. | Com_show_collations | 0 |
  101. | Com_show_create_db | 0 |
  102. | Com_show_create_event | 0 |
  103. | Com_show_create_func | 8 |
  104. | Com_show_create_proc | 26 |
  105. | Com_show_create_table | 254 |
  106. | Com_show_create_trigger | 0 |
  107. | Com_show_databases | 3 |
  108. | Com_show_engine_logs | 0 |
  109. | Com_show_engine_mutex | 0 |
  110. | Com_show_engine_status | 0 |
  111. | Com_show_events | 0 |
  112. | Com_show_errors | 0 |
  113. | Com_show_fields | 719 |
  114. | Com_show_function_code | 0 |
  115. | Com_show_function_status | 8 |
  116. | Com_show_grants | 3 |
  117. | Com_show_keys | 297 |
  118. | Com_show_master_status | 23 |
  119. | Com_show_open_tables | 0 |
  120. | Com_show_plugins | 22 |
  121. | Com_show_privileges | 0 |
  122. | Com_show_procedure_code | 0 |
  123. | Com_show_procedure_status | 8 |
  124. | Com_show_processlist | 3 |
  125. | Com_show_profile | 0 |
  126. | Com_show_profiles | 0 |
  127. | Com_show_relaylog_events | 0 |
  128. | Com_show_slave_hosts | 0 |
  129. | Com_show_slave_status | 26 |
  130. | Com_show_status | 5 |
  131. | Com_show_storage_engines | 15 |
  132. | Com_show_table_status | 18 |
  133. | Com_show_tables | 129 |
  134. | Com_show_triggers | 0 |
  135. | Com_show_variables | 124 |
  136. | Com_show_warnings | 3 |
  137. | Com_show_create_user | 0 |
  138. | Com_shutdown | 0 |
  139. | Com_slave_start | 0 |
  140. | Com_slave_stop | 0 |
  141. | Com_group_replication_start | 0 |
  142. | Com_group_replication_stop | 0 |
  143. | Com_stmt_execute | 3448 |
  144. | Com_stmt_close | 4646 |
  145. | Com_stmt_fetch | 0 |
  146. | Com_stmt_prepare | 4647 |
  147. | Com_stmt_reset | 1524 |
  148. | Com_stmt_send_long_data | 0 |
  149. | Com_truncate | 197552 |
  150. | Com_uninstall_plugin | 0 |
  151. | Com_unlock_tables | 0 |
  152. | Com_update | 113180 |
  153. | Com_update_multi | 304256 |
  154. | Com_xa_commit | 0 |
  155. | Com_xa_end | 0 |
  156. | Com_xa_prepare | 0 |
  157. | Com_xa_recover | 0 |
  158. | Com_xa_rollback | 0 |
  159. | Com_xa_start | 0 |
  160. | Com_stmt_reprepare | 0 |
  161. | Connection_errors_accept | 0 |
  162. | Connection_errors_internal | 0 |
  163. | Connection_errors_max_connections | 0 |
  164. | Connection_errors_peer_address | 0 |
  165. | Connection_errors_select | 0 |
  166. | Connection_errors_tcpwrap | 0 |
  167. | Connections | 63169 |
  168. | Created_tmp_disk_tables | 18688 |
  169. | Created_tmp_files | 1658 |
  170. | Created_tmp_tables | 634508 |
  171. | Delayed_errors | 0 |
  172. | Delayed_insert_threads | 0 |
  173. | Delayed_writes | 0 |
  174. | Flush_commands | 1 |
  175. | Handler_commit | 17 |
  176. | Handler_delete | 1342101 |
  177. | Handler_discover | 0 |
  178. | Handler_external_lock | 3686619 |
  179. | Handler_mrr_init | 0 |
  180. | Handler_prepare | 0 |
  181. | Handler_read_first | 524973 |
  182. | Handler_read_key | 10412568621 |
  183. | Handler_read_last | 188 |
  184. | Handler_read_next | 12151381300 |
  185. | Handler_read_prev | 15752 |
  186. | Handler_read_rnd | 25463844 |
  187. | Handler_read_rnd_next | 28496562615 |
  188. | Handler_rollback | 0 |
  189. | Handler_savepoint | 0 |
  190. | Handler_savepoint_rollback | 0 |
  191. | Handler_update | 218532469 |
  192. | Handler_write | 5233801985 |
  193. | Innodb_buffer_pool_dump_status | Dumping of buffer pool not started |
  194. | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 181008 0:17:44 |
  195. | Innodb_buffer_pool_resize_status | |
  196. | Innodb_buffer_pool_pages_data | 840 |
  197. | Innodb_buffer_pool_bytes_data | 13762560 |
  198. | Innodb_buffer_pool_pages_dirty | 0 |
  199. | Innodb_buffer_pool_bytes_dirty | 0 |
  200. | Innodb_buffer_pool_pages_flushed | 32958 |
  201. | Innodb_buffer_pool_pages_free | 7351 |
  202. | Innodb_buffer_pool_pages_misc | 0 |
  203. | Innodb_buffer_pool_pages_total | 8191 |
  204. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  205. | Innodb_buffer_pool_read_ahead | 0 |
  206. | Innodb_buffer_pool_read_ahead_evicted | 0 |
  207. | Innodb_buffer_pool_read_requests | 2509332 |
  208. | Innodb_buffer_pool_reads | 325 |
  209. | Innodb_buffer_pool_wait_free | 0 |
  210. | Innodb_buffer_pool_write_requests | 639781 |
  211. | Innodb_data_fsyncs | 9 |
  212. | Innodb_data_pending_fsyncs | 0 |
  213. | Innodb_data_pending_reads | 0 |
  214. | Innodb_data_pending_writes | 0 |
  215. | Innodb_data_read | 7164416 |
  216. | Innodb_data_reads | 475 |
  217. | Innodb_data_writes | 33041 |
  218. | Innodb_data_written | 540019712 |
  219. | Innodb_dblwr_pages_written | 2 |
  220. | Innodb_dblwr_writes | 1 |
  221. | Innodb_log_waits | 0 |
  222. | Innodb_log_write_requests | 0 |
  223. | Innodb_log_writes | 3 |
  224. | Innodb_os_log_fsyncs | 6 |
  225. | Innodb_os_log_pending_fsyncs | 0 |
  226. | Innodb_os_log_pending_writes | 0 |
  227. | Innodb_os_log_written | 1536 |
  228. | Innodb_page_size | 16384 |
  229. | Innodb_pages_created | 516 |
  230. | Innodb_pages_read | 324 |
  231. | Innodb_pages_written | 32958 |
  232. | Innodb_row_lock_current_waits | 0 |
  233. | Innodb_row_lock_time | 0 |
  234. | Innodb_row_lock_time_avg | 0 |
  235. | Innodb_row_lock_time_max | 0 |
  236. | Innodb_row_lock_waits | 0 |
  237. | Innodb_rows_deleted | 0 |
  238. | Innodb_rows_inserted | 1117118 |
  239. | Innodb_rows_read | 2056929 |
  240. | Innodb_rows_updated | 0 |
  241. | Innodb_num_open_files | 14 |
  242. | Innodb_truncated_status_writes | 0 |
  243. | Innodb_available_undo_logs | 128 |
  244. | Key_blocks_not_flushed | 67277 |
  245. | Key_blocks_unused | 640352 |
  246. | Key_blocks_used | 630025 |
  247. | Key_read_requests | 19162082182 |
  248. | Key_reads | 3470659 |
  249. | Key_write_requests | 147222333 |
  250. | Key_writes | 1606958 |
  251. | Locked_connects | 0 |
  252. | Max_execution_time_exceeded | 0 |
  253. | Max_execution_time_set | 0 |
  254. | Max_execution_time_set_failed | 0 |
  255. | Max_used_connections | 21 |
  256. | Max_used_connections_time | 2018-10-08 16:15:48 |
  257. | Not_flushed_delayed_rows | 0 |
  258. | Ongoing_anonymous_transaction_count | 0 |
  259. | Open_files | 469 |
  260. | Open_streams | 0 |
  261. | Open_table_definitions | 608 |
  262. | Open_tables | 412 |
  263. | Opened_files | 1757168 |
  264. | Opened_table_definitions | 1186966 |
  265. | Opened_tables | 735658 |
  266. | Performance_schema_accounts_lost | 0 |
  267. | Performance_schema_cond_classes_lost | 0 |
  268. | Performance_schema_cond_instances_lost | 0 |
  269. | Performance_schema_digest_lost | 0 |
  270. | Performance_schema_file_classes_lost | 0 |
  271. | Performance_schema_file_handles_lost | 0 |
  272. | Performance_schema_file_instances_lost | 1 |
  273. | Performance_schema_hosts_lost | 0 |
  274. | Performance_schema_index_stat_lost | 0 |
  275. | Performance_schema_locker_lost | 0 |
  276. | Performance_schema_memory_classes_lost | 0 |
  277. | Performance_schema_metadata_lock_lost | 0 |
  278. | Performance_schema_mutex_classes_lost | 0 |
  279. | Performance_schema_mutex_instances_lost | 0 |
  280. | Performance_schema_nested_statement_lost | 0 |
  281. | Performance_schema_prepared_statements_lost | 0 |
  282. | Performance_schema_program_lost | 0 |
  283. | Performance_schema_rwlock_classes_lost | 0 |
  284. | Performance_schema_rwlock_instances_lost | 0 |
  285. | Performance_schema_session_connect_attrs_lost | 0 |
  286. | Performance_schema_socket_classes_lost | 0 |
  287. | Performance_schema_socket_instances_lost | 0 |
  288. | Performance_schema_stage_classes_lost | 0 |
  289. | Performance_schema_statement_classes_lost | 0 |
  290. | Performance_schema_table_handles_lost | 0 |
  291. | Performance_schema_table_instances_lost | 0 |
  292. | Performance_schema_table_lock_stat_lost | 0 |
  293. | Performance_schema_thread_classes_lost | 0 |
  294. | Performance_schema_thread_instances_lost | 0 |
  295. | Performance_schema_users_lost | 0 |
  296. | Prepared_stmt_count | 1 |
  297. | Qcache_free_blocks | 1185 |
  298. | Qcache_free_memory | 29906776 |
  299. | Qcache_hits | 105614 |
  300. | Qcache_inserts | 138409 |
  301. | Qcache_lowmem_prunes | 23327 |
  302. | Qcache_not_cached | 258553 |
  303. | Qcache_queries_in_cache | 2050 |
  304. | Qcache_total_blocks | 5590 |
  305. | Queries | 2854975 |
  306. | Questions | 2801313 |
  307. | Select_full_join | 24190 |
  308. | Select_full_range_join | 0 |
  309. | Select_range | 38924 |
  310. | Select_range_check | 0 |
  311. | Select_scan | 555891 |
  312. | Slave_open_temp_tables | 0 |
  313. | Slow_launch_threads | 0 |
  314. | Slow_queries | 0 |
  315. | Sort_merge_passes | 864 |
  316. | Sort_range | 19245 |
  317. | Sort_rows | 31932990 |
  318. | Sort_scan | 426646 |
  319. | Ssl_accept_renegotiates | 0 |
  320. | Ssl_accepts | 0 |
  321. | Ssl_callback_cache_hits | 0 |
  322. | Ssl_cipher | |
  323. | Ssl_cipher_list | |
  324. | Ssl_client_connects | 0 |
  325. | Ssl_connect_renegotiates | 0 |
  326. | Ssl_ctx_verify_depth | 0 |
  327. | Ssl_ctx_verify_mode | 0 |
  328. | Ssl_default_timeout | 0 |
  329. | Ssl_finished_accepts | 0 |
  330. | Ssl_finished_connects | 0 |
  331. | Ssl_server_not_after | |
  332. | Ssl_server_not_before | |
  333. | Ssl_session_cache_hits | 0 |
  334. | Ssl_session_cache_misses | 0 |
  335. | Ssl_session_cache_mode | NONE |
  336. | Ssl_session_cache_overflows | 0 |
  337. | Ssl_session_cache_size | 0 |
  338. | Ssl_session_cache_timeouts | 0 |
  339. | Ssl_sessions_reused | 0 |
  340. | Ssl_used_session_cache_entries | 0 |
  341. | Ssl_verify_depth | 0 |
  342. | Ssl_verify_mode | 0 |
  343. | Ssl_version | |
  344. | Table_locks_immediate | 1672120 |
  345. | Table_locks_waited | 14527 |
  346. | Table_open_cache_hits | 1549591 |
  347. | Table_open_cache_misses | 149134 |
  348. | Table_open_cache_overflows | 147082 |
  349. | Tc_log_max_pages_used | 0 |
  350. | Tc_log_page_size | 0 |
  351. | Tc_log_page_waits | 0 |
  352. | Threads_cached | 3 |
  353. | Threads_connected | 18 |
  354. | Threads_created | 21 |
  355. | Threads_running | 9 |
  356. | Uptime | 58007 |
  357. | Uptime_since_flush_status | 58007 |
  358. +-----------------------------------------------+--------------------------------------------------+
  359. 353 rows in set (0.00 sec)
  360.  
  361. mysql> SHOW GLOBAL VARIABLES;
  362. +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  363. | Variable_name | Value |
  364. +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  365. | auto_increment_increment | 1 |
  366. | auto_increment_offset | 1 |
  367. | autocommit | ON |
  368. | automatic_sp_privileges | ON |
  369. | avoid_temporal_upgrade | OFF |
  370. | back_log | 80 |
  371. | basedir | /usr/ |
  372. | big_tables | OFF |
  373. | bind_address | 10.88.1.5 |
  374. | binlog_cache_size | 32768 |
  375. | binlog_checksum | CRC32 |
  376. | binlog_direct_non_transactional_updates | OFF |
  377. | binlog_error_action | ABORT_SERVER |
  378. | binlog_format | ROW |
  379. | binlog_group_commit_sync_delay | 0 |
  380. | binlog_group_commit_sync_no_delay_count | 0 |
  381. | binlog_gtid_simple_recovery | ON |
  382. | binlog_max_flush_queue_time | 0 |
  383. | binlog_order_commits | ON |
  384. | binlog_row_image | FULL |
  385. | binlog_rows_query_log_events | OFF |
  386. | binlog_stmt_cache_size | 32768 |
  387. | binlog_transaction_dependency_history_size | 25000 |
  388. | binlog_transaction_dependency_tracking | COMMIT_ORDER |
  389. | block_encryption_mode | aes-128-ecb |
  390. | bulk_insert_buffer_size | 8388608 |
  391. | character_set_client | latin1 |
  392. | character_set_connection | latin1 |
  393. | character_set_database | latin1 |
  394. | character_set_filesystem | binary |
  395. | character_set_results | latin1 |
  396. | character_set_server | latin1 |
  397. | character_set_system | utf8 |
  398. | character_sets_dir | /usr/share/mysql/charsets/ |
  399. | check_proxy_users | OFF |
  400. | collation_connection | latin1_spanish_ci |
  401. | collation_database | latin1_spanish_ci |
  402. | collation_server | latin1_spanish_ci |
  403. | completion_type | NO_CHAIN |
  404. | concurrent_insert | AUTO |
  405. | connect_timeout | 10 |
  406. | core_file | OFF |
  407. | datadir | /var/lib/mysql/ |
  408. | date_format | %Y-%m-%d |
  409. | datetime_format | %Y-%m-%d %H:%i:%s |
  410. | default_authentication_plugin | mysql_native_password |
  411. | default_password_lifetime | 0 |
  412. | default_storage_engine | MyISAM |
  413. | default_tmp_storage_engine | MyISAM |
  414. | default_week_format | 0 |
  415. | delay_key_write | ON |
  416. | delayed_insert_limit | 100 |
  417. | delayed_insert_timeout | 300 |
  418. | delayed_queue_size | 1000 |
  419. | disabled_storage_engines | |
  420. | disconnect_on_expired_password | ON |
  421. | div_precision_increment | 4 |
  422. | end_markers_in_json | OFF |
  423. | enforce_gtid_consistency | OFF |
  424. | eq_range_index_dive_limit | 200 |
  425. | event_scheduler | OFF |
  426. | expire_logs_days | 10 |
  427. | explicit_defaults_for_timestamp | OFF |
  428. | flush | OFF |
  429. | flush_time | 0 |
  430. | foreign_key_checks | ON |
  431. | ft_boolean_syntax | + -><()~*:""&| |
  432. | ft_max_word_len | 84 |
  433. | ft_min_word_len | 4 |
  434. | ft_query_expansion_limit | 20 |
  435. | ft_stopword_file | (built-in) |
  436. | general_log | OFF |
  437. | general_log_file | /var/lib/mysql/sol.log |
  438. | group_concat_max_len | 1024 |
  439. | gtid_executed | |
  440. | gtid_executed_compression_period | 1000 |
  441. | gtid_mode | OFF |
  442. | gtid_owned | |
  443. | gtid_purged | |
  444. | have_compress | YES |
  445. | have_crypt | YES |
  446. | have_dynamic_loading | YES |
  447. | have_geometry | YES |
  448. | have_openssl | DISABLED |
  449. | have_profiling | YES |
  450. | have_query_cache | YES |
  451. | have_rtree_keys | YES |
  452. | have_ssl | DISABLED |
  453. | have_statement_timeout | YES |
  454. | have_symlink | YES |
  455. | host_cache_size | 279 |
  456. | hostname | sol |
  457. | ignore_builtin_innodb | OFF |
  458. | ignore_db_dirs | |
  459. | init_connect | |
  460. | init_file | |
  461. | init_slave | |
  462. | innodb_adaptive_flushing | ON |
  463. | innodb_adaptive_flushing_lwm | 10 |
  464. | innodb_adaptive_hash_index | ON |
  465. | innodb_adaptive_hash_index_parts | 8 |
  466. | innodb_adaptive_max_sleep_delay | 150000 |
  467. | innodb_api_bk_commit_interval | 5 |
  468. | innodb_api_disable_rowlock | OFF |
  469. | innodb_api_enable_binlog | OFF |
  470. | innodb_api_enable_mdl | OFF |
  471. | innodb_api_trx_level | 0 |
  472. | innodb_autoextend_increment | 64 |
  473. | innodb_autoinc_lock_mode | 1 |
  474. | innodb_buffer_pool_chunk_size | 134217728 |
  475. | innodb_buffer_pool_dump_at_shutdown | ON |
  476. | innodb_buffer_pool_dump_now | OFF |
  477. | innodb_buffer_pool_dump_pct | 25 |
  478. | innodb_buffer_pool_filename | ib_buffer_pool |
  479. | innodb_buffer_pool_instances | 1 |
  480. | innodb_buffer_pool_load_abort | OFF |
  481. | innodb_buffer_pool_load_at_startup | ON |
  482. | innodb_buffer_pool_load_now | OFF |
  483. | innodb_buffer_pool_size | 134217728 |
  484. | innodb_change_buffer_max_size | 25 |
  485. | innodb_change_buffering | all |
  486. | innodb_checksum_algorithm | crc32 |
  487. | innodb_checksums | ON |
  488. | innodb_cmp_per_index_enabled | OFF |
  489. | innodb_commit_concurrency | 0 |
  490. | innodb_compression_failure_threshold_pct | 5 |
  491. | innodb_compression_level | 6 |
  492. | innodb_compression_pad_pct_max | 50 |
  493. | innodb_concurrency_tickets | 5000 |
  494. | innodb_data_file_path | ibdata1:12M:autoextend |
  495. | innodb_data_home_dir | |
  496. | innodb_deadlock_detect | ON |
  497. | innodb_default_row_format | dynamic |
  498. | innodb_disable_sort_file_cache | OFF |
  499. | innodb_doublewrite | ON |
  500. | innodb_fast_shutdown | 1 |
  501. | innodb_file_format | Barracuda |
  502. | innodb_file_format_check | ON |
  503. | innodb_file_format_max | Barracuda |
  504. | innodb_file_per_table | ON |
  505. | innodb_fill_factor | 100 |
  506. | innodb_flush_log_at_timeout | 1 |
  507. | innodb_flush_log_at_trx_commit | 1 |
  508. | innodb_flush_method | |
  509. | innodb_flush_neighbors | 1 |
  510. | innodb_flush_sync | ON |
  511. | innodb_flushing_avg_loops | 30 |
  512. | innodb_force_load_corrupted | OFF |
  513. | innodb_force_recovery | 0 |
  514. | innodb_ft_aux_table | |
  515. | innodb_ft_cache_size | 8000000 |
  516. | innodb_ft_enable_diag_print | OFF |
  517. | innodb_ft_enable_stopword | ON |
  518. | innodb_ft_max_token_size | 84 |
  519. | innodb_ft_min_token_size | 3 |
  520. | innodb_ft_num_word_optimize | 2000 |
  521. | innodb_ft_result_cache_limit | 2000000000 |
  522. | innodb_ft_server_stopword_table | |
  523. | innodb_ft_sort_pll_degree | 2 |
  524. | innodb_ft_total_cache_size | 640000000 |
  525. | innodb_ft_user_stopword_table | |
  526. | innodb_io_capacity | 200 |
  527. | innodb_io_capacity_max | 2000 |
  528. | innodb_large_prefix | ON |
  529. | innodb_lock_wait_timeout | 50 |
  530. | innodb_locks_unsafe_for_binlog | OFF |
  531. | innodb_log_buffer_size | 16777216 |
  532. | innodb_log_checksums | ON |
  533. | innodb_log_compressed_pages | ON |
  534. | innodb_log_file_size | 50331648 |
  535. | innodb_log_files_in_group | 2 |
  536. | innodb_log_group_home_dir | ./ |
  537. | innodb_log_write_ahead_size | 8192 |
  538. | innodb_lru_scan_depth | 1024 |
  539. | innodb_max_dirty_pages_pct | 75.000000 |
  540. | innodb_max_dirty_pages_pct_lwm | 0.000000 |
  541. | innodb_max_purge_lag | 0 |
  542. | innodb_max_purge_lag_delay | 0 |
  543. | innodb_max_undo_log_size | 1073741824 |
  544. | innodb_monitor_disable | |
  545. | innodb_monitor_enable | |
  546. | innodb_monitor_reset | |
  547. | innodb_monitor_reset_all | |
  548. | innodb_numa_interleave | OFF |
  549. | innodb_old_blocks_pct | 37 |
  550. | innodb_old_blocks_time | 1000 |
  551. | innodb_online_alter_log_max_size | 134217728 |
  552. | innodb_open_files | 431 |
  553. | innodb_optimize_fulltext_only | OFF |
  554. | innodb_page_cleaners | 1 |
  555. | innodb_page_size | 16384 |
  556. | innodb_print_all_deadlocks | OFF |
  557. | innodb_purge_batch_size | 300 |
  558. | innodb_purge_rseg_truncate_frequency | 128 |
  559. | innodb_purge_threads | 4 |
  560. | innodb_random_read_ahead | OFF |
  561. | innodb_read_ahead_threshold | 56 |
  562. | innodb_read_io_threads | 4 |
  563. | innodb_read_only | OFF |
  564. | innodb_replication_delay | 0 |
  565. | innodb_rollback_on_timeout | OFF |
  566. | innodb_rollback_segments | 128 |
  567. | innodb_sort_buffer_size | 1048576 |
  568. | innodb_spin_wait_delay | 6 |
  569. | innodb_stats_auto_recalc | ON |
  570. | innodb_stats_include_delete_marked | OFF |
  571. | innodb_stats_method | nulls_equal |
  572. | innodb_stats_on_metadata | OFF |
  573. | innodb_stats_persistent | ON |
  574. | innodb_stats_persistent_sample_pages | 20 |
  575. | innodb_stats_sample_pages | 8 |
  576. | innodb_stats_transient_sample_pages | 8 |
  577. | innodb_status_output | OFF |
  578. | innodb_status_output_locks | OFF |
  579. | innodb_strict_mode | ON |
  580. | innodb_support_xa | ON |
  581. | innodb_sync_array_size | 1 |
  582. | innodb_sync_spin_loops | 30 |
  583. | innodb_table_locks | ON |
  584. | innodb_temp_data_file_path | ibtmp1:12M:autoextend |
  585. | innodb_thread_concurrency | 0 |
  586. | innodb_thread_sleep_delay | 10000 |
  587. | innodb_tmpdir | |
  588. | innodb_undo_directory | ./ |
  589. | innodb_undo_log_truncate | OFF |
  590. | innodb_undo_logs | 128 |
  591. | innodb_undo_tablespaces | 0 |
  592. | innodb_use_native_aio | ON |
  593. | innodb_version | 5.7.23 |
  594. | innodb_write_io_threads | 4 |
  595. | interactive_timeout | 28800 |
  596. | internal_tmp_disk_storage_engine | InnoDB |
  597. | join_buffer_size | 524288 |
  598. | keep_files_on_create | OFF |
  599. | key_buffer_size | 1073741824 |
  600. | key_cache_age_threshold | 300 |
  601. | key_cache_block_size | 1024 |
  602. | key_cache_division_limit | 100 |
  603. | keyring_operations | ON |
  604. | large_files_support | ON |
  605. | large_page_size | 0 |
  606. | large_pages | OFF |
  607. | lc_messages | en_US |
  608. | lc_messages_dir | /usr/share/mysql/ |
  609. | lc_time_names | en_US |
  610. | license | GPL |
  611. | local_infile | ON |
  612. | lock_wait_timeout | 31536000 |
  613. | locked_in_memory | OFF |
  614. | log_bin | OFF |
  615. | log_bin_basename | |
  616. | log_bin_index | |
  617. | log_bin_trust_function_creators | OFF |
  618. | log_bin_use_v1_row_events | OFF |
  619. | log_builtin_as_identified_by_password | OFF |
  620. | log_error | /var/log/mysql/error.log |
  621. | log_error_verbosity | 3 |
  622. | log_output | FILE |
  623. | log_queries_not_using_indexes | OFF |
  624. | log_slave_updates | OFF |
  625. | log_slow_admin_statements | OFF |
  626. | log_slow_slave_statements | OFF |
  627. | log_statements_unsafe_for_binlog | ON |
  628. | log_syslog | OFF |
  629. | log_syslog_facility | daemon |
  630. | log_syslog_include_pid | ON |
  631. | log_syslog_tag | |
  632. | log_throttle_queries_not_using_indexes | 0 |
  633. | log_timestamps | UTC |
  634. | log_warnings | 2 |
  635. | long_query_time | 10.000000 |
  636. | low_priority_updates | OFF |
  637. | lower_case_file_system | OFF |
  638. | lower_case_table_names | 1 |
  639. | master_info_repository | FILE |
  640. | master_verify_checksum | OFF |
  641. | max_allowed_packet | 33554432 |
  642. | max_binlog_cache_size | 18446744073709547520 |
  643. | max_binlog_size | 104857600 |
  644. | max_binlog_stmt_cache_size | 18446744073709547520 |
  645. | max_connect_errors | 100 |
  646. | max_connections | 151 |
  647. | max_delayed_threads | 20 |
  648. | max_digest_length | 1024 |
  649. | max_error_count | 64 |
  650. | max_execution_time | 0 |
  651. | max_heap_table_size | 33554432 |
  652. | max_insert_delayed_threads | 20 |
  653. | max_join_size | 18446744073709551615 |
  654. | max_length_for_sort_data | 1024 |
  655. | max_points_in_geometry | 65536 |
  656. | max_prepared_stmt_count | 16382 |
  657. | max_relay_log_size | 0 |
  658. | max_seeks_for_key | 18446744073709551615 |
  659. | max_sort_length | 1024 |
  660. | max_sp_recursion_depth | 0 |
  661. | max_tmp_tables | 32 |
  662. | max_user_connections | 0 |
  663. | max_write_lock_count | 18446744073709551615 |
  664. | metadata_locks_cache_size | 1024 |
  665. | metadata_locks_hash_instances | 8 |
  666. | min_examined_row_limit | 0 |
  667. | multi_range_count | 256 |
  668. | myisam_data_pointer_size | 6 |
  669. | myisam_max_sort_file_size | 9223372036853727232 |
  670. | myisam_mmap_size | 18446744073709551615 |
  671. | myisam_recover_options | BACKUP |
  672. | myisam_repair_threads | 1 |
  673. | myisam_sort_buffer_size | 8388608 |
  674. | myisam_stats_method | nulls_unequal |
  675. | myisam_use_mmap | OFF |
  676. | mysql_native_password_proxy_users | OFF |
  677. | net_buffer_length | 16384 |
  678. | net_read_timeout | 30 |
  679. | net_retry_count | 10 |
  680. | net_write_timeout | 60 |
  681. | new | OFF |
  682. | ngram_token_size | 2 |
  683. | offline_mode | OFF |
  684. | old | OFF |
  685. | old_alter_table | OFF |
  686. | old_passwords | 0 |
  687. | open_files_limit | 1024 |
  688. | optimizer_prune_level | 1 |
  689. | optimizer_search_depth | 62 |
  690. | 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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on |
  691. | optimizer_trace | enabled=off,one_line=off |
  692. | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
  693. | optimizer_trace_limit | 1 |
  694. | optimizer_trace_max_mem_size | 16384 |
  695. | optimizer_trace_offset | -1 |
  696. | parser_max_mem_size | 18446744073709551615 |
  697. | performance_schema | ON |
  698. | performance_schema_accounts_size | -1 |
  699. | performance_schema_digests_size | 5000 |
  700. | performance_schema_events_stages_history_long_size | 1000 |
  701. | performance_schema_events_stages_history_size | 10 |
  702. | performance_schema_events_statements_history_long_size | 1000 |
  703. | performance_schema_events_statements_history_size | 10 |
  704. | performance_schema_events_transactions_history_long_size | 1000 |
  705. | performance_schema_events_transactions_history_size | 10 |
  706. | performance_schema_events_waits_history_long_size | 1000 |
  707. | performance_schema_events_waits_history_size | 10 |
  708. | performance_schema_hosts_size | -1 |
  709. | performance_schema_max_cond_classes | 80 |
  710. | performance_schema_max_cond_instances | -1 |
  711. | performance_schema_max_digest_length | 1024 |
  712. | performance_schema_max_file_classes | 80 |
  713. | performance_schema_max_file_handles | 32768 |
  714. | performance_schema_max_file_instances | -1 |
  715. | performance_schema_max_index_stat | -1 |
  716. | performance_schema_max_memory_classes | 320 |
  717. | performance_schema_max_metadata_locks | -1 |
  718. | performance_schema_max_mutex_classes | 210 |
  719. | performance_schema_max_mutex_instances | -1 |
  720. | performance_schema_max_prepared_statements_instances | -1 |
  721. | performance_schema_max_program_instances | -1 |
  722. | performance_schema_max_rwlock_classes | 40 |
  723. | performance_schema_max_rwlock_instances | -1 |
  724. | performance_schema_max_socket_classes | 10 |
  725. | performance_schema_max_socket_instances | -1 |
  726. | performance_schema_max_sql_text_length | 1024 |
  727. | performance_schema_max_stage_classes | 150 |
  728. | performance_schema_max_statement_classes | 193 |
  729. | performance_schema_max_statement_stack | 10 |
  730. | performance_schema_max_table_handles | -1 |
  731. | performance_schema_max_table_instances | -1 |
  732. | performance_schema_max_table_lock_stat | -1 |
  733. | performance_schema_max_thread_classes | 50 |
  734. | performance_schema_max_thread_instances | -1 |
  735. | performance_schema_session_connect_attrs_size | 512 |
  736. | performance_schema_setup_actors_size | -1 |
  737. | performance_schema_setup_objects_size | -1 |
  738. | performance_schema_users_size | -1 |
  739. | pid_file | /var/run/mysqld/mysqld.pid |
  740. | plugin_dir | /usr/lib/mysql/plugin/ |
  741. | port | 3306 |
  742. | preload_buffer_size | 32768 |
  743. | profiling | OFF |
  744. | profiling_history_size | 15 |
  745. | protocol_version | 10 |
  746. | query_alloc_block_size | 8192 |
  747. | query_cache_limit | 1048576 |
  748. | query_cache_min_res_unit | 4096 |
  749. | query_cache_size | 33554432 |
  750. | query_cache_type | ON |
  751. | query_cache_wlock_invalidate | OFF |
  752. | query_prealloc_size | 8192 |
  753. | range_alloc_block_size | 4096 |
  754. | range_optimizer_max_mem_size | 8388608 |
  755. | rbr_exec_mode | STRICT |
  756. | read_buffer_size | 262144 |
  757. | read_only | OFF |
  758. | read_rnd_buffer_size | 262144 |
  759. | relay_log | |
  760. | relay_log_basename | /var/lib/mysql/sol-relay-bin |
  761. | relay_log_index | /var/lib/mysql/sol-relay-bin.index |
  762. | relay_log_info_file | relay-log.info |
  763. | relay_log_info_repository | FILE |
  764. | relay_log_purge | ON |
  765. | relay_log_recovery | OFF |
  766. | relay_log_space_limit | 0 |
  767. | report_host | |
  768. | report_password | |
  769. | report_port | 3306 |
  770. | report_user | |
  771. | require_secure_transport | OFF |
  772. | rpl_stop_slave_timeout | 31536000 |
  773. | secure_auth | ON |
  774. | secure_file_priv | |
  775. | server_id | 0 |
  776. | server_id_bits | 32 |
  777. | server_uuid | 475e9820-778b-11e6-924f-a4bf0108f40a |
  778. | session_track_gtids | OFF |
  779. | session_track_schema | ON |
  780. | session_track_state_change | OFF |
  781. | session_track_system_variables | time_zone,autocommit,character_set_client,character_set_results,character_set_connection |
  782. | session_track_transaction_info | OFF |
  783. | sha256_password_proxy_users | OFF |
  784. | show_compatibility_56 | OFF |
  785. | show_create_table_verbosity | OFF |
  786. | show_old_temporals | OFF |
  787. | skip_external_locking | ON |
  788. | skip_name_resolve | ON |
  789. | skip_networking | OFF |
  790. | skip_show_database | OFF |
  791. | slave_allow_batching | OFF |
  792. | slave_checkpoint_group | 512 |
  793. | slave_checkpoint_period | 300 |
  794. | slave_compressed_protocol | OFF |
  795. | slave_exec_mode | STRICT |
  796. | slave_load_tmpdir | /tmp |
  797. | slave_max_allowed_packet | 1073741824 |
  798. | slave_net_timeout | 60 |
  799. | slave_parallel_type | DATABASE |
  800. | slave_parallel_workers | 0 |
  801. | slave_pending_jobs_size_max | 16777216 |
  802. | slave_preserve_commit_order | OFF |
  803. | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN |
  804. | slave_skip_errors | OFF |
  805. | slave_sql_verify_checksum | ON |
  806. | slave_transaction_retries | 10 |
  807. | slave_type_conversions | |
  808. | slow_launch_time | 2 |
  809. | slow_query_log | OFF |
  810. | slow_query_log_file | /var/lib/mysql/sol-slow.log |
  811. | socket | /var/run/mysqld/mysqld.sock |
  812. | sort_buffer_size | 524288 |
  813. | sql_auto_is_null | OFF |
  814. | sql_big_selects | ON |
  815. | sql_buffer_result | OFF |
  816. | sql_log_off | OFF |
  817. | sql_mode | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
  818. | sql_notes | ON |
  819. | sql_quote_show_create | ON |
  820. | sql_safe_updates | OFF |
  821. | sql_select_limit | 18446744073709551615 |
  822. | sql_slave_skip_counter | 0 |
  823. | sql_warnings | OFF |
  824. | ssl_ca | |
  825. | ssl_capath | |
  826. | ssl_cert | |
  827. | ssl_cipher | |
  828. | ssl_crl | |
  829. | ssl_crlpath | |
  830. | ssl_key | |
  831. | stored_program_cache | 256 |
  832. | super_read_only | OFF |
  833. | sync_binlog | 1 |
  834. | sync_frm | ON |
  835. | sync_master_info | 10000 |
  836. | sync_relay_log | 10000 |
  837. | sync_relay_log_info | 10000 |
  838. | system_time_zone | CEST |
  839. | table_definition_cache | 615 |
  840. | table_open_cache | 431 |
  841. | table_open_cache_instances | 16 |
  842. | thread_cache_size | 24 |
  843. | thread_handling | one-thread-per-connection |
  844. | thread_stack | 262144 |
  845. | time_format | %H:%i:%s |
  846. | time_zone | SYSTEM |
  847. | tls_version | TLSv1,TLSv1.1 |
  848. | tmp_table_size | 33554432 |
  849. | tmpdir | /tmp |
  850. | transaction_alloc_block_size | 8192 |
  851. | transaction_isolation | REPEATABLE-READ |
  852. | transaction_prealloc_size | 4096 |
  853. | transaction_read_only | OFF |
  854. | transaction_write_set_extraction | OFF |
  855. | tx_isolation | REPEATABLE-READ |
  856. | tx_read_only | OFF |
  857. | unique_checks | ON |
  858. | updatable_views_with_limit | YES |
  859. | version | 5.7.23-0ubuntu0.16.04.1 |
  860. | version_comment | (Ubuntu) |
  861. | version_compile_machine | x86_64 |
  862. | version_compile_os | Linux |
  863. | wait_timeout | 28800 |
  864. +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  865. 499 rows in set (0.00 sec)
  866.  
  867. mysql> SHOW ENGINE INNODB STATUS;
  868. +--------+------+-----------------------------------+
  869. | Type | Name | Status |
  870. +--------+------+-----------------------------------+
  871. | InnoDB | |
  872. =====================================
  873. 2018-10-08 16:29:36 0x7f47203e8700 INNODB MONITOR OUTPUT
  874. =====================================
  875. Per second averages calculated from the last 57 seconds
  876. -----------------
  877. BACKGROUND THREAD
  878. -----------------
  879. srv_master_thread loops: 12689 srv_active, 0 srv_shutdown, 45615 srv_idle
  880. srv_master_thread log flush and writes: 58304
  881. ----------
  882. SEMAPHORES
  883. ----------
  884. OS WAIT ARRAY INFO: reservation count 11
  885. OS WAIT ARRAY INFO: signal count 11
  886. RW-shared spins 0, rounds 7, OS waits 3
  887. RW-excl spins 0, rounds 211, OS waits 0
  888. RW-sx spins 0, rounds 0, OS waits 0
  889. Spin rounds per wait: 7.00 RW-shared, 211.00 RW-excl, 0.00 RW-sx
  890. ------------
  891. TRANSACTIONS
  892. ------------
  893. Trx id counter 88526338
  894. Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
  895. History list length 0
  896. LIST OF TRANSACTIONS FOR EACH SESSION:
  897. ---TRANSACTION 421418865856648, not started
  898. 0 lock struct(s), heap size 1136, 0 row lock(s)
  899. ---TRANSACTION 421418865855728, not started
  900. 0 lock struct(s), heap size 1136, 0 row lock(s)
  901. ---TRANSACTION 421418865851128, not started
  902. 0 lock struct(s), heap size 1136, 0 row lock(s)
  903. ---TRANSACTION 421418865854808, not started
  904. 0 lock struct(s), heap size 1136, 0 row lock(s)
  905. ---TRANSACTION 421418865850208, not started
  906. 0 lock struct(s), heap size 1136, 0 row lock(s)
  907. ---TRANSACTION 421418865852968, not started
  908. 0 lock struct(s), heap size 1136, 0 row lock(s)
  909. ---TRANSACTION 421418865853888, not started
  910. 0 lock struct(s), heap size 1136, 0 row lock(s)
  911. ---TRANSACTION 421418865852048, not started
  912. 0 lock struct(s), heap size 1136, 0 row lock(s)
  913. --------
  914. FILE I/O
  915. --------
  916. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  917. I/O thread 1 state: waiting for completed aio requests (log thread)
  918. I/O thread 2 state: waiting for completed aio requests (read thread)
  919. I/O thread 3 state: waiting for completed aio requests (read thread)
  920. I/O thread 4 state: waiting for completed aio requests (read thread)
  921. I/O thread 5 state: waiting for completed aio requests (read thread)
  922. I/O thread 6 state: waiting for completed aio requests (write thread)
  923. I/O thread 7 state: waiting for completed aio requests (write thread)
  924. I/O thread 8 state: waiting for completed aio requests (write thread)
  925. I/O thread 9 state: waiting for completed aio requests (write thread)
  926. Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
  927. ibuf aio reads:, log i/o's:, sync i/o's:
  928. Pending flushes (fsync) log: 0; buffer pool: 0
  929. 475 OS file reads, 34057 OS file writes, 9 OS fsyncs
  930. 0.00 reads/s, 0 avg bytes/read, 4.72 writes/s, 0.00 fsyncs/s
  931. -------------------------------------
  932. INSERT BUFFER AND ADAPTIVE HASH INDEX
  933. -------------------------------------
  934. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  935. merged operations:
  936. insert 0, delete mark 0, delete 0
  937. discarded operations:
  938. insert 0, delete mark 0, delete 0
  939. Hash table size 34673, node heap has 0 buffer(s)
  940. Hash table size 34673, node heap has 0 buffer(s)
  941. Hash table size 34673, node heap has 0 buffer(s)
  942. Hash table size 34673, node heap has 0 buffer(s)
  943. Hash table size 34673, node heap has 0 buffer(s)
  944. Hash table size 34673, node heap has 0 buffer(s)
  945. Hash table size 34673, node heap has 0 buffer(s)
  946. Hash table size 34673, node heap has 0 buffer(s)
  947. 0.00 hash searches/s, 0.00 non-hash searches/s
  948. ---
  949. LOG
  950. ---
  951. Log sequence number 123883693
  952. Log flushed up to 123883693
  953. Pages flushed up to 123883693
  954. Last checkpoint at 123883684
  955. 0 pending log flushes, 0 pending chkp writes
  956. 12 log i/o's done, 0.00 log i/o's/second
  957. ----------------------
  958. BUFFER POOL AND MEMORY
  959. ----------------------
  960. Total large memory allocated 137428992
  961. Dictionary memory allocated 93212
  962. Buffer pool size 8191
  963. Free buffers 7351
  964. Database pages 840
  965. Old database pages 290
  966. Modified db pages 3
  967. Pending reads 0
  968. Pending writes: LRU 0, flush list 0, single page 0
  969. Pages made young 0, not young 0
  970. 0.00 youngs/s, 0.00 non-youngs/s
  971. Pages read 324, created 516, written 33974
  972. 0.00 reads/s, 0.00 creates/s, 4.72 writes/s
  973. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  974. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  975. LRU len: 840, unzip_LRU len: 0
  976. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  977. --------------
  978. ROW OPERATIONS
  979. --------------
  980. 0 queries inside InnoDB, 0 queries in queue
  981. 0 read views open inside InnoDB
  982. Process ID=17175, Main thread ID=139943514990336, state: sleeping
  983. Number of rows inserted 1139912, updated 0, deleted 0, read 2087570
  984. 52.44 inserts/s, 0.00 updates/s, 0.00 deletes/s, 53.56 reads/s
  985. ----------------------------
  986. END OF INNODB MONITOR OUTPUT
  987. ============================
  988. +--------+------+-----------------------------------+
  989. 1 row in set (0.00 sec)
  990.  
  991.  
  992. # ulimit -a
  993. core file size (blocks, -c) 0
  994. data seg size (kbytes, -d) unlimited
  995. scheduling priority (-e) 0
  996. file size (blocks, -f) unlimited
  997. pending signals (-i) 256792
  998. max locked memory (kbytes, -l) 64
  999. max memory size (kbytes, -m) unlimited
  1000. open files (-n) 1024
  1001. pipe size (512 bytes, -p) 8
  1002. POSIX message queues (bytes, -q) 819200
  1003. real-time priority (-r) 0
  1004. stack size (kbytes, -s) 8192
  1005. cpu time (seconds, -t) unlimited
  1006. max user processes (-u) 256792
  1007. virtual memory (kbytes, -v) unlimited
  1008. file locks (-x) unlimited
  1009.  
  1010. # iostat -x
  1011. Linux 4.4.0-134-generic (sol) 10/08/2018 _x86_64_ (32 CPU)
  1012.  
  1013. avg-cpu: %user %nice %system %iowait %steal %idle
  1014. 4.25 0.00 5.05 0.35 0.00 90.35
  1015.  
  1016. Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
  1017. loop0 0.00 0.00 0.00 0.00 0.00 0.00 3.20 0.00 0.00 0.00 0.00 0.00 0.00
  1018. sda 3.25 3.76 54.85 9.52 1588.47 348.93 60.19 0.21 3.19 2.96 4.50 1.32 8.48
  1019. sdb 44.68 600.30 678.28 143.88 4745.30 3248.20 19.45 0.72 0.88 0.20 4.05 0.07 5.49
  1020.  
  1021. # df -h
  1022. Filesystem Size Used Avail Use% Mounted on
  1023. udev 32G 0 32G 0% /dev
  1024. tmpfs 6.3G 124M 6.2G 2% /run
  1025. /dev/sdb2 157G 49G 101G 33% /
  1026. tmpfs 32G 0 32G 0% /dev/shm
  1027. tmpfs 5.0M 4.0K 5.0M 1% /run/lock
  1028. tmpfs 32G 0 32G 0% /sys/fs/cgroup
  1029. /dev/sdb1 511M 3.4M 508M 1% /boot/efi
  1030. /dev/sda1 5.5T 4.5T 991G 83% /raid
  1031. tmpfs 6.3G 0 6.3G 0% /run/user/1000
Add Comment
Please, Sign In to add comment
Public Pastes
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!