Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqltuner.pl --outputfile result_mysqltuner.txt
- >> MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
- >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
- >> Run with '--help' for additional options and output filtering
- [--] Skipped version check for MySQLTuner script
- Please enter your MySQL administrative login: admin
- Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.6.26-log
- [OK] Operating on 64-bit architecture
- -------- Log file Recommendations ------------------------------------------------------------------
- [OK] Log file /var/log/mysql/error.log exists
- [--] Log file: /var/log/mysql/error.log(0B)
- [OK] Log file /var/log/mysql/error.log is readable.
- [!!] Log file /var/log/mysql/error.log is empty
- [OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
- [OK] /var/log/mysql/error.log doesn't contain any warning.
- [OK] /var/log/mysql/error.log doesn't contain any error.
- [--] 0 start(s) detected in /var/log/mysql/error.log
- [--] 0 shutdown(s) detected in /var/log/mysql/error.log
- -------- Storage Engine Statistics -----------------------------------------------------------------
- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
- [--] Data in MyISAM tables: 38.2M (Tables: 2552)
- [--] Data in InnoDB tables: 210.4G (Tables: 469134)
- [--] Data in MEMORY tables: 0B (Tables: 58)
- [!!] Total fragmented tables: 1
- -------- Analysis Performance Metrics --------------------------------------------------------------
- [--] innodb_stats_on_metadata: OFF
- [OK] No stat updates during querying INFORMATION_SCHEMA.
- -------- Security Recommendations ------------------------------------------------------------------
- [OK] There are no anonymous accounts for any database users
- [OK] All database users have passwords assigned
- -------- CVE Security Recommendations --------------------------------------------------------------
- [--] Skipped due to --cvefile option undefined
- -------- Performance Metrics -----------------------------------------------------------------------
- [--] Up for: 26d 7h 22m 42s (1B q [491.101 qps], 50M conn, TX: 6469G, RX: 349G)
- [--] Reads / Writes: 90% / 10%
- [--] Binary logging is enabled (GTID MODE: OFF)
- [--] Physical Memory : 56.1G
- [--] Max MySQL memory : 159.2G
- [--] Other process memory: 0B
- [--] Total buffers: 25.5G global + 44.2M per thread (3072 max threads)
- [--] P_S Max memory usage: 914M
- [--] Galera GCache Max memory usage: 0B
- [!!] Maximum reached memory usage: 48.3G (86.04% of installed RAM)
- [!!] Maximum possible memory usage: 159.2G (283.44% of installed RAM)
- [!!] Overall possible memory usage with other process exceeded memory
- [!!] Slow queries: 19% (214M/1B)
- [OK] Highest usage of available connections: 16% (507/3072)
- [OK] Aborted connections: 0.74% (370958/50206131)
- [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
- [!!] Query cache may be disabled by default due to mutex contention.
- [!!] Query cache efficiency: 0.0% (0 cached / 991M selects)
- [OK] Query cache prunes per day: 0
- [OK] Sorts requiring temporary tables: 0% (10K temp sorts / 291M sorts)
- [!!] Joins performed without indexes: 9385371
- [!!] Temporary tables created on disk: 35% (58M on disk / 165M total)
- [OK] Thread cache hit rate: 99% (12K created / 50M connections)
- [!!] Table cache hit rate: 0% (2K open / 279M opened)
- [!!] table_definition_cache(1400) is lower than number of tables(471905)
- [OK] Open file limit used: 0% (6/1M)
- [OK] Table locks acquired immediately: 99% (1B immediate / 1B locks)
- [OK] Binlog cache memory access: 0% (0 Memory / 0 Total)
- -------- Performance schema ------------------------------------------------------------------------
- [--] Memory used by P_S: 915.0M
- [--] Sys schema isn't installed.
- -------- ThreadPool Metrics ------------------------------------------------------------------------
- [--] ThreadPool stat is disabled.
- -------- MyISAM Metrics ----------------------------------------------------------------------------
- [!!] Key buffer used: 18.2% (195M used / 1B cache)
- [OK] Key buffer size / total MyISAM indexes: 1.0G/21.1M
- [OK] Read Key buffer hit rate: 100.0% (20B cached / 6M reads)
- [!!] Write Key buffer hit rate: 0.0% (4B cached / 48K writes)
- -------- InnoDB Metrics ----------------------------------------------------------------------------
- [--] InnoDB is enabled.
- [--] InnoDB Thread Concurrency: 0
- [OK] InnoDB File per table is activated
- [!!] InnoDB buffer pool / data size: 24.0G/210.4G
- [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (2.08333333333333 %): 256.0M * 2/24.0G should be equal to 25%
- [!!] InnoDB buffer pool instances: 8
- [--] InnoDB Buffer Pool Chunk Size not used or defined in your version
- [OK] InnoDB Read buffer efficiency: 99.98% (1361756316227 hits/ 1361975928793 total)
- [OK] InnoDB Write log efficiency: 94.21% (1127657366 hits/ 1196930296 total)
- [OK] InnoDB log waits: 0.00% (0 waits / 69272930 writes)
- -------- AriaDB Metrics ----------------------------------------------------------------------------
- [--] AriaDB is disabled.
- -------- TokuDB Metrics ----------------------------------------------------------------------------
- [--] TokuDB is disabled.
- -------- XtraDB Metrics ----------------------------------------------------------------------------
- [--] XtraDB is disabled.
- -------- Galera Metrics ----------------------------------------------------------------------------
- [--] Galera is disabled.
- -------- Replication Metrics -----------------------------------------------------------------------
- [--] Galera Synchronous replication: NO
- [--] No replication slave(s) for this server.
- [--] Binlog format: MIXED
- [--] XA support enabled: ON
- [--] Semi synchronous replication Master: Not Activated
- [--] Semi synchronous replication Slave: Not Activated
- [OK] This replication slave is running with the read_only option enabled.
- [OK] This replication slave is up to date with master.
- -------- Recommendations ---------------------------------------------------------------------------
- General recommendations:
- Reduce your overall MySQL memory footprint for system stability
- Dedicate this server to your database for highest performance.
- Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
- We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
- See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
- (specially the conclusions at the bottom of the page).
- When making adjustments, make tmp_table_size/max_heap_table_size equal
- Reduce your SELECT DISTINCT queries which have no LIMIT clause
- Increase table_open_cache gradually to avoid file descriptor limits
- Read this before increasing table_open_cache over 64: https://bit.ly/2Fulv7r
- Read this before increasing for MariaDB https://mariadb.com/kb/en/library/optimizing-table_open_cache/
- This is MyISAM only table_cache scalability problem, InnoDB not affected.
- See more details here: https://bugs.mysql.com/bug.php?id=49177
- This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
- Beware that open_files_limit (1024000) variable
- should be greater than table_open_cache (2000)
- Consider installing Sys schema from https://github.com/mysql/mysql-sys for MySQL
- Consider installing Sys schema from https://github.com/FromDual/mariadb-sys for MariaDB
- Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
- Variables to adjust:
- *** MySQL's maximum memory usage is dangerously high ***
- *** Add RAM before increasing MySQL buffer variables ***
- query_cache_size (=0)
- query_cache_type (=0)
- query_cache_limit (> 2M, or use smaller result sets)
- join_buffer_size (> 32.0M, or always use indexes with JOINs)
- tmp_table_size (> 192M)
- max_heap_table_size (> 192M)
- table_open_cache (> 2000)
- table_definition_cache(1400) > 471905 or -1 (autosizing if supported)
- innodb_buffer_pool_size (>= 210.4G) if possible.
- innodb_log_file_size should be (=3G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
- innodb_buffer_pool_instances(=24)
- mysql> SHOW GLOBAL STATUS\G;
- *************************** 1. row ***************************
- Variable_name: Aborted_clients
- Value: 9679
- *************************** 2. row ***************************
- Variable_name: Aborted_connects
- Value: 371132
- *************************** 3. row ***************************
- Variable_name: Binlog_cache_disk_use
- Value: 0
- *************************** 4. row ***************************
- Variable_name: Binlog_cache_use
- Value: 0
- *************************** 5. row ***************************
- Variable_name: Binlog_stmt_cache_disk_use
- Value: 0
- *************************** 6. row ***************************
- Variable_name: Binlog_stmt_cache_use
- Value: 0
- *************************** 7. row ***************************
- Variable_name: Bytes_received
- Value: 375611005675
- *************************** 8. row ***************************
- Variable_name: Bytes_sent
- Value: 6948696360269
- *************************** 9. row ***************************
- Variable_name: Com_admin_commands
- Value: 8749143
- *************************** 10. row ***************************
- Variable_name: Com_assign_to_keycache
- Value: 0
- *************************** 11. row ***************************
- Variable_name: Com_alter_db
- Value: 0
- *************************** 12. row ***************************
- Variable_name: Com_alter_db_upgrade
- Value: 0
- *************************** 13. row ***************************
- Variable_name: Com_alter_event
- Value: 0
- *************************** 14. row ***************************
- Variable_name: Com_alter_function
- Value: 0
- *************************** 15. row ***************************
- Variable_name: Com_alter_procedure
- Value: 0
- *************************** 16. row ***************************
- Variable_name: Com_alter_server
- Value: 0
- *************************** 17. row ***************************
- Variable_name: Com_alter_table
- Value: 14514
- *************************** 18. row ***************************
- Variable_name: Com_alter_tablespace
- Value: 0
- *************************** 19. row ***************************
- Variable_name: Com_alter_user
- Value: 0
- *************************** 20. row ***************************
- Variable_name: Com_analyze
- Value: 0
- *************************** 21. row ***************************
- Variable_name: Com_begin
- Value: 94675964
- *************************** 22. row ***************************
- Variable_name: Com_binlog
- Value: 0
- *************************** 23. row ***************************
- Variable_name: Com_call_procedure
- Value: 0
- *************************** 24. row ***************************
- Variable_name: Com_change_db
- Value: 41923101
- *************************** 25. row ***************************
- Variable_name: Com_change_master
- Value: 0
- *************************** 26. row ***************************
- Variable_name: Com_check
- Value: 0
- *************************** 27. row ***************************
- Variable_name: Com_checksum
- Value: 0
- *************************** 28. row ***************************
- Variable_name: Com_commit
- Value: 94675959
- *************************** 29. row ***************************
- Variable_name: Com_create_db
- Value: 23
- *************************** 30. row ***************************
- Variable_name: Com_create_event
- Value: 0
- *************************** 31. row ***************************
- Variable_name: Com_create_function
- Value: 0
- *************************** 32. row ***************************
- Variable_name: Com_create_index
- Value: 0
- *************************** 33. row ***************************
- Variable_name: Com_create_procedure
- Value: 0
- *************************** 34. row ***************************
- Variable_name: Com_create_server
- Value: 0
- *************************** 35. row ***************************
- Variable_name: Com_create_table
- Value: 8801
- *************************** 36. row ***************************
- Variable_name: Com_create_trigger
- Value: 0
- *************************** 37. row ***************************
- Variable_name: Com_create_udf
- Value: 0
- *************************** 38. row ***************************
- Variable_name: Com_create_user
- Value: 0
- *************************** 39. row ***************************
- Variable_name: Com_create_view
- Value: 9
- *************************** 40. row ***************************
- Variable_name: Com_dealloc_sql
- Value: 0
- *************************** 41. row ***************************
- Variable_name: Com_delete
- Value: 27289251
- *************************** 42. row ***************************
- Variable_name: Com_delete_multi
- Value: 5303
- *************************** 43. row ***************************
- Variable_name: Com_do
- Value: 0
- *************************** 44. row ***************************
- Variable_name: Com_drop_db
- Value: 2
- *************************** 45. row ***************************
- Variable_name: Com_drop_event
- Value: 0
- *************************** 46. row ***************************
- Variable_name: Com_drop_function
- Value: 0
- *************************** 47. row ***************************
- Variable_name: Com_drop_index
- Value: 0
- *************************** 48. row ***************************
- Variable_name: Com_drop_procedure
- Value: 0
- *************************** 49. row ***************************
- Variable_name: Com_drop_server
- Value: 0
- *************************** 50. row ***************************
- Variable_name: Com_drop_table
- Value: 89
- *************************** 51. row ***************************
- Variable_name: Com_drop_trigger
- Value: 0
- *************************** 52. row ***************************
- Variable_name: Com_drop_user
- Value: 0
- *************************** 53. row ***************************
- Variable_name: Com_drop_view
- Value: 0
- *************************** 54. row ***************************
- Variable_name: Com_empty_query
- Value: 5
- *************************** 55. row ***************************
- Variable_name: Com_execute_sql
- Value: 0
- *************************** 56. row ***************************
- Variable_name: Com_flush
- Value: 2
- *************************** 57. row ***************************
- Variable_name: Com_get_diagnostics
- Value: 0
- *************************** 58. row ***************************
- Variable_name: Com_grant
- Value: 0
- *************************** 59. row ***************************
- Variable_name: Com_ha_close
- Value: 0
- *************************** 60. row ***************************
- Variable_name: Com_ha_open
- Value: 0
- *************************** 61. row ***************************
- Variable_name: Com_ha_read
- Value: 0
- *************************** 62. row ***************************
- Variable_name: Com_help
- Value: 0
- *************************** 63. row ***************************
- Variable_name: Com_insert
- Value: 32572833
- *************************** 64. row ***************************
- Variable_name: Com_insert_select
- Value: 87096
- *************************** 65. row ***************************
- Variable_name: Com_install_plugin
- Value: 0
- *************************** 66. row ***************************
- Variable_name: Com_kill
- Value: 1
- *************************** 67. row ***************************
- Variable_name: Com_load
- Value: 0
- *************************** 68. row ***************************
- Variable_name: Com_lock_tables
- Value: 1421
- *************************** 69. row ***************************
- Variable_name: Com_optimize
- Value: 0
- *************************** 70. row ***************************
- Variable_name: Com_preload_keys
- Value: 0
- *************************** 71. row ***************************
- Variable_name: Com_prepare_sql
- Value: 0
- *************************** 72. row ***************************
- Variable_name: Com_purge
- Value: 0
- *************************** 73. row ***************************
- Variable_name: Com_purge_before_date
- Value: 0
- *************************** 74. row ***************************
- Variable_name: Com_release_savepoint
- Value: 2
- *************************** 75. row ***************************
- Variable_name: Com_rename_table
- Value: 68
- *************************** 76. row ***************************
- Variable_name: Com_rename_user
- Value: 0
- *************************** 77. row ***************************
- Variable_name: Com_repair
- Value: 0
- *************************** 78. row ***************************
- Variable_name: Com_replace
- Value: 6549371
- *************************** 79. row ***************************
- Variable_name: Com_replace_select
- Value: 0
- *************************** 80. row ***************************
- Variable_name: Com_reset
- Value: 0
- *************************** 81. row ***************************
- Variable_name: Com_resignal
- Value: 0
- *************************** 82. row ***************************
- Variable_name: Com_revoke
- Value: 0
- *************************** 83. row ***************************
- Variable_name: Com_revoke_all
- Value: 0
- *************************** 84. row ***************************
- Variable_name: Com_rollback
- Value: 0
- *************************** 85. row ***************************
- Variable_name: Com_rollback_to_savepoint
- Value: 1325
- *************************** 86. row ***************************
- Variable_name: Com_savepoint
- Value: 5
- *************************** 87. row ***************************
- Variable_name: Com_select
- Value: 991823843
- *************************** 88. row ***************************
- Variable_name: Com_set_option
- Value: 13689686
- *************************** 89. row ***************************
- Variable_name: Com_signal
- Value: 0
- *************************** 90. row ***************************
- Variable_name: Com_show_binlog_events
- Value: 0
- *************************** 91. row ***************************
- Variable_name: Com_show_binlogs
- Value: 6959
- *************************** 92. row ***************************
- Variable_name: Com_show_charsets
- Value: 0
- *************************** 93. row ***************************
- Variable_name: Com_show_collations
- Value: 0
- *************************** 94. row ***************************
- Variable_name: Com_show_create_db
- Value: 1419
- *************************** 95. row ***************************
- Variable_name: Com_show_create_event
- Value: 0
- *************************** 96. row ***************************
- Variable_name: Com_show_create_func
- Value: 0
- *************************** 97. row ***************************
- Variable_name: Com_show_create_proc
- Value: 0
- *************************** 98. row ***************************
- Variable_name: Com_show_create_table
- Value: 469784
- *************************** 99. row ***************************
- Variable_name: Com_show_create_trigger
- Value: 0
- *************************** 100. row ***************************
- Variable_name: Com_show_databases
- Value: 5
- *************************** 101. row ***************************
- Variable_name: Com_show_engine_logs
- Value: 0
- *************************** 102. row ***************************
- Variable_name: Com_show_engine_mutex
- Value: 0
- *************************** 103. row ***************************
- Variable_name: Com_show_engine_status
- Value: 6942
- *************************** 104. row ***************************
- Variable_name: Com_show_events
- Value: 0
- *************************** 105. row ***************************
- Variable_name: Com_show_errors
- Value: 0
- *************************** 106. row ***************************
- Variable_name: Com_show_fields
- Value: 472092
- *************************** 107. row ***************************
- Variable_name: Com_show_function_code
- Value: 0
- *************************** 108. row ***************************
- Variable_name: Com_show_function_status
- Value: 0
- *************************** 109. row ***************************
- Variable_name: Com_show_grants
- Value: 7
- *************************** 110. row ***************************
- Variable_name: Com_show_keys
- Value: 1
- *************************** 111. row ***************************
- Variable_name: Com_show_master_status
- Value: 162
- *************************** 112. row ***************************
- Variable_name: Com_show_open_tables
- Value: 0
- *************************** 113. row ***************************
- Variable_name: Com_show_plugins
- Value: 1
- *************************** 114. row ***************************
- Variable_name: Com_show_privileges
- Value: 0
- *************************** 115. row ***************************
- Variable_name: Com_show_procedure_code
- Value: 0
- *************************** 116. row ***************************
- Variable_name: Com_show_procedure_status
- Value: 0
- *************************** 117. row ***************************
- Variable_name: Com_show_processlist
- Value: 7092
- *************************** 118. row ***************************
- Variable_name: Com_show_profile
- Value: 0
- *************************** 119. row ***************************
- Variable_name: Com_show_profiles
- Value: 0
- *************************** 120. row ***************************
- Variable_name: Com_show_relaylog_events
- Value: 0
- *************************** 121. row ***************************
- Variable_name: Com_show_slave_hosts
- Value: 1
- *************************** 122. row ***************************
- Variable_name: Com_show_slave_status
- Value: 8761067
- *************************** 123. row ***************************
- Variable_name: Com_show_status
- Value: 7107
- *************************** 124. row ***************************
- Variable_name: Com_show_storage_engines
- Value: 1
- *************************** 125. row ***************************
- Variable_name: Com_show_table_status
- Value: 466781
- *************************** 126. row ***************************
- Variable_name: Com_show_tables
- Value: 1461
- *************************** 127. row ***************************
- Variable_name: Com_show_triggers
- Value: 465489
- *************************** 128. row ***************************
- Variable_name: Com_show_variables
- Value: 7119
- *************************** 129. row ***************************
- Variable_name: Com_show_warnings
- Value: 0
- *************************** 130. row ***************************
- Variable_name: Com_slave_start
- Value: 0
- *************************** 131. row ***************************
- Variable_name: Com_slave_stop
- Value: 0
- *************************** 132. row ***************************
- Variable_name: Com_stmt_close
- Value: 0
- *************************** 133. row ***************************
- Variable_name: Com_stmt_execute
- Value: 0
- *************************** 134. row ***************************
- Variable_name: Com_stmt_fetch
- Value: 0
- *************************** 135. row ***************************
- Variable_name: Com_stmt_prepare
- Value: 0
- *************************** 136. row ***************************
- Variable_name: Com_stmt_reprepare
- Value: 0
- *************************** 137. row ***************************
- Variable_name: Com_stmt_reset
- Value: 0
- *************************** 138. row ***************************
- Variable_name: Com_stmt_send_long_data
- Value: 0
- *************************** 139. row ***************************
- Variable_name: Com_truncate
- Value: 507
- *************************** 140. row ***************************
- Variable_name: Com_uninstall_plugin
- Value: 0
- *************************** 141. row ***************************
- Variable_name: Com_unlock_tables
- Value: 1427
- *************************** 142. row ***************************
- Variable_name: Com_update
- Value: 43830477
- *************************** 143. row ***************************
- Variable_name: Com_update_multi
- Value: 2061
- *************************** 144. row ***************************
- Variable_name: Com_xa_commit
- Value: 0
- *************************** 145. row ***************************
- Variable_name: Com_xa_end
- Value: 0
- *************************** 146. row ***************************
- Variable_name: Com_xa_prepare
- Value: 0
- *************************** 147. row ***************************
- Variable_name: Com_xa_recover
- Value: 0
- *************************** 148. row ***************************
- Variable_name: Com_xa_rollback
- Value: 0
- *************************** 149. row ***************************
- Variable_name: Com_xa_start
- Value: 0
- *************************** 150. row ***************************
- Variable_name: Compression
- Value: OFF
- *************************** 151. row ***************************
- Variable_name: Connection_errors_accept
- Value: 0
- *************************** 152. row ***************************
- Variable_name: Connection_errors_internal
- Value: 0
- *************************** 153. row ***************************
- Variable_name: Connection_errors_max_connections
- Value: 0
- *************************** 154. row ***************************
- Variable_name: Connection_errors_peer_address
- Value: 0
- *************************** 155. row ***************************
- Variable_name: Connection_errors_select
- Value: 0
- *************************** 156. row ***************************
- Variable_name: Connection_errors_tcpwrap
- Value: 0
- *************************** 157. row ***************************
- Variable_name: Connections
- Value: 50255694
- *************************** 158. row ***************************
- Variable_name: Created_tmp_disk_tables
- Value: 58100771
- *************************** 159. row ***************************
- Variable_name: Created_tmp_files
- Value: 87768
- *************************** 160. row ***************************
- Variable_name: Created_tmp_tables
- Value: 165917864
- *************************** 161. row ***************************
- Variable_name: Delayed_errors
- Value: 0
- *************************** 162. row ***************************
- Variable_name: Delayed_insert_threads
- Value: 0
- *************************** 163. row ***************************
- Variable_name: Delayed_writes
- Value: 0
- *************************** 164. row ***************************
- Variable_name: Flush_commands
- Value: 1
- *************************** 165. row ***************************
- Variable_name: Handler_commit
- Value: 1187083598
- *************************** 166. row ***************************
- Variable_name: Handler_delete
- Value: 496106687
- *************************** 167. row ***************************
- Variable_name: Handler_discover
- Value: 0
- *************************** 168. row ***************************
- Variable_name: Handler_external_lock
- Value: 3769307500
- *************************** 169. row ***************************
- Variable_name: Handler_mrr_init
- Value: 0
- *************************** 170. row ***************************
- Variable_name: Handler_prepare
- Value: 0
- *************************** 171. row ***************************
- Variable_name: Handler_read_first
- Value: 224449498
- *************************** 172. row ***************************
- Variable_name: Handler_read_key
- Value: 137279808270
- *************************** 173. row ***************************
- Variable_name: Handler_read_last
- Value: 2288715
- *************************** 174. row ***************************
- Variable_name: Handler_read_next
- Value: 1052470718194
- *************************** 175. row ***************************
- Variable_name: Handler_read_prev
- Value: 8284386963
- *************************** 176. row ***************************
- Variable_name: Handler_read_rnd
- Value: 25432088710
- *************************** 177. row ***************************
- Variable_name: Handler_read_rnd_next
- Value: 300963194594
- *************************** 178. row ***************************
- Variable_name: Handler_rollback
- Value: 84
- *************************** 179. row ***************************
- Variable_name: Handler_savepoint
- Value: 5
- *************************** 180. row ***************************
- Variable_name: Handler_savepoint_rollback
- Value: 1325
- *************************** 181. row ***************************
- Variable_name: Handler_update
- Value: 6763880761
- *************************** 182. row ***************************
- Variable_name: Handler_write
- Value: 29909252802
- *************************** 183. row ***************************
- Variable_name: Innodb_buffer_pool_dump_status
- Value: not started
- *************************** 184. row ***************************
- Variable_name: Innodb_buffer_pool_load_status
- Value: not started
- *************************** 185. row ***************************
- Variable_name: Innodb_buffer_pool_pages_data
- Value: 1468682
- *************************** 186. row ***************************
- Variable_name: Innodb_buffer_pool_bytes_data
- Value: 24062885888
- *************************** 187. row ***************************
- Variable_name: Innodb_buffer_pool_pages_dirty
- Value: 6740
- *************************** 188. row ***************************
- Variable_name: Innodb_buffer_pool_bytes_dirty
- Value: 110428160
- *************************** 189. row ***************************
- Variable_name: Innodb_buffer_pool_pages_flushed
- Value: 150193054
- *************************** 190. row ***************************
- Variable_name: Innodb_buffer_pool_pages_free
- Value: 7853
- *************************** 191. row ***************************
- Variable_name: Innodb_buffer_pool_pages_misc
- Value: 96325
- *************************** 192. row ***************************
- Variable_name: Innodb_buffer_pool_pages_total
- Value: 1572860
- *************************** 193. row ***************************
- Variable_name: Innodb_buffer_pool_read_ahead_rnd
- Value: 0
- *************************** 194. row ***************************
- Variable_name: Innodb_buffer_pool_read_ahead
- Value: 17291749
- *************************** 195. row ***************************
- Variable_name: Innodb_buffer_pool_read_ahead_evicted
- Value: 5476
- *************************** 196. row ***************************
- Variable_name: Innodb_buffer_pool_read_requests
- Value: 1362527306367
- *************************** 197. row ***************************
- Variable_name: Innodb_buffer_pool_reads
- Value: 223908924
- *************************** 198. row ***************************
- Variable_name: Innodb_buffer_pool_wait_free
- Value: 0
- *************************** 199. row ***************************
- Variable_name: Innodb_buffer_pool_write_requests
- Value: 18574211377
- *************************** 200. row ***************************
- Variable_name: Innodb_data_fsyncs
- Value: 114987861
- *************************** 201. row ***************************
- Variable_name: Innodb_data_pending_fsyncs
- Value: 0
- *************************** 202. row ***************************
- Variable_name: Innodb_data_pending_reads
- Value: 0
- *************************** 203. row ***************************
- Variable_name: Innodb_data_pending_writes
- Value: 0
- *************************** 204. row ***************************
- Variable_name: Innodb_data_read
- Value: 4122428100608
- *************************** 205. row ***************************
- Variable_name: Innodb_data_reads
- Value: 252125047
- *************************** 206. row ***************************
- Variable_name: Innodb_data_writes
- Value: 232092316
- *************************** 207. row ***************************
- Variable_name: Innodb_data_written
- Value: 5477843815424
- *************************** 208. row ***************************
- Variable_name: Innodb_dblwr_pages_written
- Value: 150193054
- *************************** 209. row ***************************
- Variable_name: Innodb_dblwr_writes
- Value: 11959746
- *************************** 210. row ***************************
- Variable_name: Innodb_have_atomic_builtins
- Value: ON
- *************************** 211. row ***************************
- Variable_name: Innodb_log_waits
- Value: 0
- *************************** 212. row ***************************
- Variable_name: Innodb_log_write_requests
- Value: 1197205996
- *************************** 213. row ***************************
- Variable_name: Innodb_log_writes
- Value: 69362297
- *************************** 214. row ***************************
- Variable_name: Innodb_os_log_fsyncs
- Value: 69612464
- *************************** 215. row ***************************
- Variable_name: Innodb_os_log_pending_fsyncs
- Value: 0
- *************************** 216. row ***************************
- Variable_name: Innodb_os_log_pending_writes
- Value: 0
- *************************** 217. row ***************************
- Variable_name: Innodb_os_log_written
- Value: 556204107264
- *************************** 218. row ***************************
- Variable_name: Innodb_page_size
- Value: 16384
- *************************** 219. row ***************************
- Variable_name: Innodb_pages_created
- Value: 8949645
- *************************** 220. row ***************************
- Variable_name: Innodb_pages_read
- Value: 251614384
- *************************** 221. row ***************************
- Variable_name: Innodb_pages_written
- Value: 150193054
- *************************** 222. row ***************************
- Variable_name: Innodb_row_lock_current_waits
- Value: 0
- *************************** 223. row ***************************
- Variable_name: Innodb_row_lock_time
- Value: 0
- *************************** 224. row ***************************
- Variable_name: Innodb_row_lock_time_avg
- Value: 0
- *************************** 225. row ***************************
- Variable_name: Innodb_row_lock_time_max
- Value: 0
- *************************** 226. row ***************************
- Variable_name: Innodb_row_lock_waits
- Value: 0
- *************************** 227. row ***************************
- Variable_name: Innodb_rows_deleted
- Value: 496172364
- *************************** 228. row ***************************
- Variable_name: Innodb_rows_inserted
- Value: 539630268
- *************************** 229. row ***************************
- Variable_name: Innodb_rows_read
- Value: 1419279067224
- *************************** 230. row ***************************
- Variable_name: Innodb_rows_updated
- Value: 471373449
- *************************** 231. row ***************************
- Variable_name: Innodb_num_open_files
- Value: 2000
- *************************** 232. row ***************************
- Variable_name: Innodb_truncated_status_writes
- Value: 0
- *************************** 233. row ***************************
- Variable_name: Innodb_available_undo_logs
- Value: 128
- *************************** 234. row ***************************
- Variable_name: Key_blocks_not_flushed
- Value: 0
- *************************** 235. row ***************************
- Variable_name: Key_blocks_unused
- Value: 857368
- *************************** 236. row ***************************
- Variable_name: Key_blocks_used
- Value: 6797
- *************************** 237. row ***************************
- Variable_name: Key_read_requests
- Value: 20817794454
- *************************** 238. row ***************************
- Variable_name: Key_reads
- Value: 6841275
- *************************** 239. row ***************************
- Variable_name: Key_write_requests
- Value: 4140103768
- *************************** 240. row ***************************
- Variable_name: Key_writes
- Value: 48618
- *************************** 241. row ***************************
- Variable_name: Last_query_cost
- Value: 0.000000
- *************************** 242. row ***************************
- Variable_name: Last_query_partial_plans
- Value: 0
- *************************** 243. row ***************************
- Variable_name: Max_used_connections
- Value: 507
- *************************** 244. row ***************************
- Variable_name: Not_flushed_delayed_rows
- Value: 0
- *************************** 245. row ***************************
- Variable_name: Open_files
- Value: 23
- *************************** 246. row ***************************
- Variable_name: Open_streams
- Value: 0
- *************************** 247. row ***************************
- Variable_name: Open_table_definitions
- Value: 1965
- *************************** 248. row ***************************
- Variable_name: Open_tables
- Value: 2000
- *************************** 249. row ***************************
- Variable_name: Opened_files
- Value: 466154876
- *************************** 250. row ***************************
- Variable_name: Opened_table_definitions
- Value: 232734466
- *************************** 251. row ***************************
- Variable_name: Opened_tables
- Value: 280606491
- *************************** 252. row ***************************
- Variable_name: Performance_schema_accounts_lost
- Value: 0
- *************************** 253. row ***************************
- Variable_name: Performance_schema_cond_classes_lost
- Value: 0
- *************************** 254. row ***************************
- Variable_name: Performance_schema_cond_instances_lost
- Value: 0
- *************************** 255. row ***************************
- Variable_name: Performance_schema_digest_lost
- Value: 544989142
- *************************** 256. row ***************************
- Variable_name: Performance_schema_file_classes_lost
- Value: 0
- *************************** 257. row ***************************
- Variable_name: Performance_schema_file_handles_lost
- Value: 0
- *************************** 258. row ***************************
- Variable_name: Performance_schema_file_instances_lost
- Value: 479785988
- *************************** 259. row ***************************
- Variable_name: Performance_schema_hosts_lost
- Value: 0
- *************************** 260. row ***************************
- Variable_name: Performance_schema_locker_lost
- Value: 0
- *************************** 261. row ***************************
- Variable_name: Performance_schema_mutex_classes_lost
- Value: 0
- *************************** 262. row ***************************
- Variable_name: Performance_schema_mutex_instances_lost
- Value: 0
- *************************** 263. row ***************************
- Variable_name: Performance_schema_rwlock_classes_lost
- Value: 0
- *************************** 264. row ***************************
- Variable_name: Performance_schema_rwlock_instances_lost
- Value: 0
- *************************** 265. row ***************************
- Variable_name: Performance_schema_session_connect_attrs_lost
- Value: 0
- *************************** 266. row ***************************
- Variable_name: Performance_schema_socket_classes_lost
- Value: 0
- *************************** 267. row ***************************
- Variable_name: Performance_schema_socket_instances_lost
- Value: 0
- *************************** 268. row ***************************
- Variable_name: Performance_schema_stage_classes_lost
- Value: 0
- *************************** 269. row ***************************
- Variable_name: Performance_schema_statement_classes_lost
- Value: 0
- *************************** 270. row ***************************
- Variable_name: Performance_schema_table_handles_lost
- Value: 0
- *************************** 271. row ***************************
- Variable_name: Performance_schema_table_instances_lost
- Value: 82646217
- *************************** 272. row ***************************
- Variable_name: Performance_schema_thread_classes_lost
- Value: 0
- *************************** 273. row ***************************
- Variable_name: Performance_schema_thread_instances_lost
- Value: 0
- *************************** 274. row ***************************
- Variable_name: Performance_schema_users_lost
- Value: 0
- *************************** 275. row ***************************
- Variable_name: Prepared_stmt_count
- Value: 0
- *************************** 276. row ***************************
- Variable_name: Qcache_free_blocks
- Value: 1
- *************************** 277. row ***************************
- Variable_name: Qcache_free_memory
- Value: 201308616
- *************************** 278. row ***************************
- Variable_name: Qcache_hits
- Value: 0
- *************************** 279. row ***************************
- Variable_name: Qcache_inserts
- Value: 0
- *************************** 280. row ***************************
- Variable_name: Qcache_lowmem_prunes
- Value: 0
- *************************** 281. row ***************************
- Variable_name: Qcache_not_cached
- Value: 991333108
- *************************** 282. row ***************************
- Variable_name: Qcache_queries_in_cache
- Value: 0
- *************************** 283. row ***************************
- Variable_name: Qcache_total_blocks
- Value: 1
- *************************** 284. row ***************************
- Variable_name: Queries
- Value: 1356675214
- *************************** 285. row ***************************
- Variable_name: Questions
- Value: 1116739310
- *************************** 286. row ***************************
- Variable_name: Select_full_join
- Value: 9374444
- *************************** 287. row ***************************
- Variable_name: Select_full_range_join
- Value: 1403795
- *************************** 288. row ***************************
- Variable_name: Select_range
- Value: 80555255
- *************************** 289. row ***************************
- Variable_name: Select_range_check
- Value: 12471
- *************************** 290. row ***************************
- Variable_name: Select_scan
- Value: 240278122
- *************************** 291. row ***************************
- Variable_name: Slave_heartbeat_period
- Value: 1800.000
- *************************** 292. row ***************************
- Variable_name: Slave_last_heartbeat
- Value:
- *************************** 293. row ***************************
- Variable_name: Slave_open_temp_tables
- Value: 0
- *************************** 294. row ***************************
- Variable_name: Slave_received_heartbeats
- Value: 0
- *************************** 295. row ***************************
- Variable_name: Slave_retried_transactions
- Value: 0
- *************************** 296. row ***************************
- Variable_name: Slave_running
- Value: ON
- *************************** 297. row ***************************
- Variable_name: Slow_launch_threads
- Value: 0
- *************************** 298. row ***************************
- Variable_name: Slow_queries
- Value: 214492490
- *************************** 299. row ***************************
- Variable_name: Sort_merge_passes
- Value: 10722
- *************************** 300. row ***************************
- Variable_name: Sort_range
- Value: 137109489
- *************************** 301. row ***************************
- Variable_name: Sort_rows
- Value: 20677341490
- *************************** 302. row ***************************
- Variable_name: Sort_scan
- Value: 154602967
- *************************** 303. row ***************************
- Variable_name: Ssl_accept_renegotiates
- Value: 0
- *************************** 304. row ***************************
- Variable_name: Ssl_accepts
- Value: 0
- *************************** 305. row ***************************
- Variable_name: Ssl_callback_cache_hits
- Value: 0
- *************************** 306. row ***************************
- Variable_name: Ssl_cipher
- Value:
- *************************** 307. row ***************************
- Variable_name: Ssl_cipher_list
- Value:
- *************************** 308. row ***************************
- Variable_name: Ssl_client_connects
- Value: 0
- *************************** 309. row ***************************
- Variable_name: Ssl_connect_renegotiates
- Value: 0
- *************************** 310. row ***************************
- Variable_name: Ssl_ctx_verify_depth
- Value: 0
- *************************** 311. row ***************************
- Variable_name: Ssl_ctx_verify_mode
- Value: 0
- *************************** 312. row ***************************
- Variable_name: Ssl_default_timeout
- Value: 0
- *************************** 313. row ***************************
- Variable_name: Ssl_finished_accepts
- Value: 0
- *************************** 314. row ***************************
- Variable_name: Ssl_finished_connects
- Value: 0
- *************************** 315. row ***************************
- Variable_name: Ssl_server_not_after
- Value:
- *************************** 316. row ***************************
- Variable_name: Ssl_server_not_before
- Value:
- *************************** 317. row ***************************
- Variable_name: Ssl_session_cache_hits
- Value: 0
- *************************** 318. row ***************************
- Variable_name: Ssl_session_cache_misses
- Value: 0
- *************************** 319. row ***************************
- Variable_name: Ssl_session_cache_mode
- Value: NONE
- *************************** 320. row ***************************
- Variable_name: Ssl_session_cache_overflows
- Value: 0
- *************************** 321. row ***************************
- Variable_name: Ssl_session_cache_size
- Value: 0
- *************************** 322. row ***************************
- Variable_name: Ssl_session_cache_timeouts
- Value: 0
- *************************** 323. row ***************************
- Variable_name: Ssl_sessions_reused
- Value: 0
- *************************** 324. row ***************************
- Variable_name: Ssl_used_session_cache_entries
- Value: 0
- *************************** 325. row ***************************
- Variable_name: Ssl_verify_depth
- Value: 0
- *************************** 326. row ***************************
- Variable_name: Ssl_verify_mode
- Value: 0
- *************************** 327. row ***************************
- Variable_name: Ssl_version
- Value:
- *************************** 328. row ***************************
- Variable_name: Table_locks_immediate
- Value: 1763086518
- *************************** 329. row ***************************
- Variable_name: Table_locks_waited
- Value: 9595
- *************************** 330. row ***************************
- Variable_name: Table_open_cache_hits
- Value: 1484933399
- *************************** 331. row ***************************
- Variable_name: Table_open_cache_misses
- Value: 280604315
- *************************** 332. row ***************************
- Variable_name: Table_open_cache_overflows
- Value: 280587711
- *************************** 333. row ***************************
- Variable_name: Tc_log_max_pages_used
- Value: 0
- *************************** 334. row ***************************
- Variable_name: Tc_log_page_size
- Value: 0
- *************************** 335. row ***************************
- Variable_name: Tc_log_page_waits
- Value: 0
- *************************** 336. row ***************************
- Variable_name: Threads_cached
- Value: 93
- *************************** 337. row ***************************
- Variable_name: Threads_connected
- Value: 5
- *************************** 338. row ***************************
- Variable_name: Threads_created
- Value: 12463
- *************************** 339. row ***************************
- Variable_name: Threads_running
- Value: 2
- *************************** 340. row ***************************
- Variable_name: Uptime
- Value: 2280932
- *************************** 341. row ***************************
- Variable_name: Uptime_since_flush_status
- Value: 2280932
- 341 rows in set (0.01 sec)
- mysql> SHOW GLOBAL VARIABLES\G;
- *************************** 1. row ***************************
- Variable_name: auto_increment_increment
- Value: 1
- *************************** 2. row ***************************
- Variable_name: auto_increment_offset
- Value: 1
- *************************** 3. row ***************************
- Variable_name: autocommit
- Value: ON
- *************************** 4. row ***************************
- Variable_name: automatic_sp_privileges
- Value: ON
- *************************** 5. row ***************************
- Variable_name: avoid_temporal_upgrade
- Value: OFF
- *************************** 6. row ***************************
- Variable_name: back_log
- Value: 664
- *************************** 7. row ***************************
- Variable_name: basedir
- Value: /usr
- *************************** 8. row ***************************
- Variable_name: big_tables
- Value: OFF
- *************************** 9. row ***************************
- Variable_name: bind_address
- Value: *
- *************************** 10. row ***************************
- Variable_name: binlog_cache_size
- Value: 32768
- *************************** 11. row ***************************
- Variable_name: binlog_checksum
- Value: CRC32
- *************************** 12. row ***************************
- Variable_name: binlog_direct_non_transactional_updates
- Value: OFF
- *************************** 13. row ***************************
- Variable_name: binlog_error_action
- Value: IGNORE_ERROR
- *************************** 14. row ***************************
- Variable_name: binlog_format
- Value: MIXED
- *************************** 15. row ***************************
- Variable_name: binlog_gtid_simple_recovery
- Value: OFF
- *************************** 16. row ***************************
- Variable_name: binlog_max_flush_queue_time
- Value: 0
- *************************** 17. row ***************************
- Variable_name: binlog_order_commits
- Value: ON
- *************************** 18. row ***************************
- Variable_name: binlog_row_image
- Value: FULL
- *************************** 19. row ***************************
- Variable_name: binlog_rows_query_log_events
- Value: OFF
- *************************** 20. row ***************************
- Variable_name: binlog_stmt_cache_size
- Value: 32768
- *************************** 21. row ***************************
- Variable_name: binlogging_impossible_mode
- Value: IGNORE_ERROR
- *************************** 22. row ***************************
- Variable_name: block_encryption_mode
- Value: aes-128-ecb
- *************************** 23. row ***************************
- Variable_name: bulk_insert_buffer_size
- Value: 8388608
- *************************** 24. row ***************************
- Variable_name: character_set_client
- Value: latin1
- *************************** 25. row ***************************
- Variable_name: character_set_connection
- Value: latin1
- *************************** 26. row ***************************
- Variable_name: character_set_database
- Value: latin1
- *************************** 27. row ***************************
- Variable_name: character_set_filesystem
- Value: binary
- *************************** 28. row ***************************
- Variable_name: character_set_results
- Value: latin1
- *************************** 29. row ***************************
- Variable_name: character_set_server
- Value: latin1
- *************************** 30. row ***************************
- Variable_name: character_set_system
- Value: utf8
- *************************** 31. row ***************************
- Variable_name: character_sets_dir
- Value: /usr/share/mysql/charsets/
- *************************** 32. row ***************************
- Variable_name: collation_connection
- Value: latin1_swedish_ci
- *************************** 33. row ***************************
- Variable_name: collation_database
- Value: latin1_swedish_ci
- *************************** 34. row ***************************
- Variable_name: collation_server
- Value: latin1_swedish_ci
- *************************** 35. row ***************************
- Variable_name: completion_type
- Value: NO_CHAIN
- *************************** 36. row ***************************
- Variable_name: concurrent_insert
- Value: AUTO
- *************************** 37. row ***************************
- Variable_name: connect_timeout
- Value: 8
- *************************** 38. row ***************************
- Variable_name: core_file
- Value: OFF
- *************************** 39. row ***************************
- Variable_name: datadir
- Value: /var/lib/mysql/
- *************************** 40. row ***************************
- Variable_name: date_format
- Value: %Y-%m-%d
- *************************** 41. row ***************************
- Variable_name: datetime_format
- Value: %Y-%m-%d %H:%i:%s
- *************************** 42. row ***************************
- Variable_name: default_storage_engine
- Value: InnoDB
- *************************** 43. row ***************************
- Variable_name: default_tmp_storage_engine
- Value: InnoDB
- *************************** 44. row ***************************
- Variable_name: default_week_format
- Value: 0
- *************************** 45. row ***************************
- Variable_name: delay_key_write
- Value: ON
- *************************** 46. row ***************************
- Variable_name: delayed_insert_limit
- Value: 100
- *************************** 47. row ***************************
- Variable_name: delayed_insert_timeout
- Value: 8
- *************************** 48. row ***************************
- Variable_name: delayed_queue_size
- Value: 1000
- *************************** 49. row ***************************
- Variable_name: disconnect_on_expired_password
- Value: ON
- *************************** 50. row ***************************
- Variable_name: div_precision_increment
- Value: 4
- *************************** 51. row ***************************
- Variable_name: end_markers_in_json
- Value: OFF
- *************************** 52. row ***************************
- Variable_name: enforce_gtid_consistency
- Value: OFF
- *************************** 53. row ***************************
- Variable_name: eq_range_index_dive_limit
- Value: 10
- *************************** 54. row ***************************
- Variable_name: event_scheduler
- Value: OFF
- *************************** 55. row ***************************
- Variable_name: expire_logs_days
- Value: 5
- *************************** 56. row ***************************
- Variable_name: explicit_defaults_for_timestamp
- Value: ON
- *************************** 57. row ***************************
- Variable_name: flush
- Value: OFF
- *************************** 58. row ***************************
- Variable_name: flush_time
- Value: 0
- *************************** 59. row ***************************
- Variable_name: foreign_key_checks
- Value: ON
- *************************** 60. row ***************************
- Variable_name: ft_boolean_syntax
- Value: + -><()~*:""&|
- *************************** 61. row ***************************
- Variable_name: ft_max_word_len
- Value: 84
- *************************** 62. row ***************************
- Variable_name: ft_min_word_len
- Value: 4
- *************************** 63. row ***************************
- Variable_name: ft_query_expansion_limit
- Value: 20
- *************************** 64. row ***************************
- Variable_name: ft_stopword_file
- Value: (built-in)
- *************************** 65. row ***************************
- Variable_name: general_log
- Value: OFF
- *************************** 66. row ***************************
- Variable_name: general_log_file
- Value: /var/lib/mysql/vm4521.log
- *************************** 67. row ***************************
- Variable_name: group_concat_max_len
- Value: 1024
- *************************** 68. row ***************************
- Variable_name: gtid_executed
- Value:
- *************************** 69. row ***************************
- Variable_name: gtid_mode
- Value: OFF
- *************************** 70. row ***************************
- Variable_name: gtid_owned
- Value:
- *************************** 71. row ***************************
- Variable_name: gtid_purged
- Value:
- *************************** 72. row ***************************
- Variable_name: have_compress
- Value: YES
- *************************** 73. row ***************************
- Variable_name: have_crypt
- Value: YES
- *************************** 74. row ***************************
- Variable_name: have_dynamic_loading
- Value: YES
- *************************** 75. row ***************************
- Variable_name: have_geometry
- Value: YES
- *************************** 76. row ***************************
- Variable_name: have_openssl
- Value: DISABLED
- *************************** 77. row ***************************
- Variable_name: have_profiling
- Value: YES
- *************************** 78. row ***************************
- Variable_name: have_query_cache
- Value: YES
- *************************** 79. row ***************************
- Variable_name: have_rtree_keys
- Value: YES
- *************************** 80. row ***************************
- Variable_name: have_ssl
- Value: DISABLED
- *************************** 81. row ***************************
- Variable_name: have_symlink
- Value: DISABLED
- *************************** 82. row ***************************
- Variable_name: host_cache_size
- Value: 756
- *************************** 83. row ***************************
- Variable_name: hostname
- Value: vm4521.cloud.seeweb.it
- *************************** 84. row ***************************
- Variable_name: ignore_builtin_innodb
- Value: OFF
- *************************** 85. row ***************************
- Variable_name: ignore_db_dirs
- Value: lost+found
- *************************** 86. row ***************************
- Variable_name: init_connect
- Value:
- *************************** 87. row ***************************
- Variable_name: init_file
- Value:
- *************************** 88. row ***************************
- Variable_name: init_slave
- Value:
- *************************** 89. row ***************************
- Variable_name: innodb_adaptive_flushing
- Value: ON
- *************************** 90. row ***************************
- Variable_name: innodb_adaptive_flushing_lwm
- Value: 10
- *************************** 91. row ***************************
- Variable_name: innodb_adaptive_hash_index
- Value: ON
- *************************** 92. row ***************************
- Variable_name: innodb_adaptive_max_sleep_delay
- Value: 150000
- *************************** 93. row ***************************
- Variable_name: innodb_additional_mem_pool_size
- Value: 8388608
- *************************** 94. row ***************************
- Variable_name: innodb_api_bk_commit_interval
- Value: 5
- *************************** 95. row ***************************
- Variable_name: innodb_api_disable_rowlock
- Value: OFF
- *************************** 96. row ***************************
- Variable_name: innodb_api_enable_binlog
- Value: OFF
- *************************** 97. row ***************************
- Variable_name: innodb_api_enable_mdl
- Value: OFF
- *************************** 98. row ***************************
- Variable_name: innodb_api_trx_level
- Value: 0
- *************************** 99. row ***************************
- Variable_name: innodb_autoextend_increment
- Value: 64
- *************************** 100. row ***************************
- Variable_name: innodb_autoinc_lock_mode
- Value: 1
- *************************** 101. row ***************************
- Variable_name: innodb_buffer_pool_dump_at_shutdown
- Value: OFF
- *************************** 102. row ***************************
- Variable_name: innodb_buffer_pool_dump_now
- Value: OFF
- *************************** 103. row ***************************
- Variable_name: innodb_buffer_pool_filename
- Value: ib_buffer_pool
- *************************** 104. row ***************************
- Variable_name: innodb_buffer_pool_instances
- Value: 8
- *************************** 105. row ***************************
- Variable_name: innodb_buffer_pool_load_abort
- Value: OFF
- *************************** 106. row ***************************
- Variable_name: innodb_buffer_pool_load_at_startup
- Value: OFF
- *************************** 107. row ***************************
- Variable_name: innodb_buffer_pool_load_now
- Value: OFF
- *************************** 108. row ***************************
- Variable_name: innodb_buffer_pool_size
- Value: 25769803776
- *************************** 109. row ***************************
- Variable_name: innodb_change_buffer_max_size
- Value: 25
- *************************** 110. row ***************************
- Variable_name: innodb_change_buffering
- Value: all
- *************************** 111. row ***************************
- Variable_name: innodb_checksum_algorithm
- Value: innodb
- *************************** 112. row ***************************
- Variable_name: innodb_checksums
- Value: ON
- *************************** 113. row ***************************
- Variable_name: innodb_cmp_per_index_enabled
- Value: OFF
- *************************** 114. row ***************************
- Variable_name: innodb_commit_concurrency
- Value: 0
- *************************** 115. row ***************************
- Variable_name: innodb_compression_failure_threshold_pct
- Value: 5
- *************************** 116. row ***************************
- Variable_name: innodb_compression_level
- Value: 6
- *************************** 117. row ***************************
- Variable_name: innodb_compression_pad_pct_max
- Value: 50
- *************************** 118. row ***************************
- Variable_name: innodb_concurrency_tickets
- Value: 5000
- *************************** 119. row ***************************
- Variable_name: innodb_data_file_path
- Value: ibdata1:12M:autoextend
- *************************** 120. row ***************************
- Variable_name: innodb_data_home_dir
- Value:
- *************************** 121. row ***************************
- Variable_name: innodb_disable_sort_file_cache
- Value: OFF
- *************************** 122. row ***************************
- Variable_name: innodb_doublewrite
- Value: ON
- *************************** 123. row ***************************
- Variable_name: innodb_fast_shutdown
- Value: 1
- *************************** 124. row ***************************
- Variable_name: innodb_file_format
- Value: Antelope
- *************************** 125. row ***************************
- Variable_name: innodb_file_format_check
- Value: ON
- *************************** 126. row ***************************
- Variable_name: innodb_file_format_max
- Value: Antelope
- *************************** 127. row ***************************
- Variable_name: innodb_file_per_table
- Value: ON
- *************************** 128. row ***************************
- Variable_name: innodb_flush_log_at_timeout
- Value: 1
- *************************** 129. row ***************************
- Variable_name: innodb_flush_log_at_trx_commit
- Value: 1
- *************************** 130. row ***************************
- Variable_name: innodb_flush_method
- Value: O_DIRECT
- *************************** 131. row ***************************
- Variable_name: innodb_flush_neighbors
- Value: 1
- *************************** 132. row ***************************
- Variable_name: innodb_flushing_avg_loops
- Value: 30
- *************************** 133. row ***************************
- Variable_name: innodb_force_load_corrupted
- Value: OFF
- *************************** 134. row ***************************
- Variable_name: innodb_force_recovery
- Value: 0
- *************************** 135. row ***************************
- Variable_name: innodb_ft_aux_table
- Value:
- *************************** 136. row ***************************
- Variable_name: innodb_ft_cache_size
- Value: 8000000
- *************************** 137. row ***************************
- Variable_name: innodb_ft_enable_diag_print
- Value: OFF
- *************************** 138. row ***************************
- Variable_name: innodb_ft_enable_stopword
- Value: ON
- *************************** 139. row ***************************
- Variable_name: innodb_ft_max_token_size
- Value: 84
- *************************** 140. row ***************************
- Variable_name: innodb_ft_min_token_size
- Value: 3
- *************************** 141. row ***************************
- Variable_name: innodb_ft_num_word_optimize
- Value: 2000
- *************************** 142. row ***************************
- Variable_name: innodb_ft_result_cache_limit
- Value: 2000000000
- *************************** 143. row ***************************
- Variable_name: innodb_ft_server_stopword_table
- Value:
- *************************** 144. row ***************************
- Variable_name: innodb_ft_sort_pll_degree
- Value: 2
- *************************** 145. row ***************************
- Variable_name: innodb_ft_total_cache_size
- Value: 640000000
- *************************** 146. row ***************************
- Variable_name: innodb_ft_user_stopword_table
- Value:
- *************************** 147. row ***************************
- Variable_name: innodb_io_capacity
- Value: 200
- *************************** 148. row ***************************
- Variable_name: innodb_io_capacity_max
- Value: 2000
- *************************** 149. row ***************************
- Variable_name: innodb_large_prefix
- Value: OFF
- *************************** 150. row ***************************
- Variable_name: innodb_lock_wait_timeout
- Value: 120
- *************************** 151. row ***************************
- Variable_name: innodb_locks_unsafe_for_binlog
- Value: OFF
- *************************** 152. row ***************************
- Variable_name: innodb_log_buffer_size
- Value: 134217728
- *************************** 153. row ***************************
- Variable_name: innodb_log_compressed_pages
- Value: ON
- *************************** 154. row ***************************
- Variable_name: innodb_log_file_size
- Value: 268435456
- *************************** 155. row ***************************
- Variable_name: innodb_log_files_in_group
- Value: 2
- *************************** 156. row ***************************
- Variable_name: innodb_log_group_home_dir
- Value: ./
- *************************** 157. row ***************************
- Variable_name: innodb_lru_scan_depth
- Value: 1024
- *************************** 158. row ***************************
- Variable_name: innodb_max_dirty_pages_pct
- Value: 75
- *************************** 159. row ***************************
- Variable_name: innodb_max_dirty_pages_pct_lwm
- Value: 0
- *************************** 160. row ***************************
- Variable_name: innodb_max_purge_lag
- Value: 0
- *************************** 161. row ***************************
- Variable_name: innodb_max_purge_lag_delay
- Value: 0
- *************************** 162. row ***************************
- Variable_name: innodb_mirrored_log_groups
- Value: 1
- *************************** 163. row ***************************
- Variable_name: innodb_monitor_disable
- Value:
- *************************** 164. row ***************************
- Variable_name: innodb_monitor_enable
- Value:
- *************************** 165. row ***************************
- Variable_name: innodb_monitor_reset
- Value:
- *************************** 166. row ***************************
- Variable_name: innodb_monitor_reset_all
- Value:
- *************************** 167. row ***************************
- Variable_name: innodb_old_blocks_pct
- Value: 37
- *************************** 168. row ***************************
- Variable_name: innodb_old_blocks_time
- Value: 1000
- *************************** 169. row ***************************
- Variable_name: innodb_online_alter_log_max_size
- Value: 134217728
- *************************** 170. row ***************************
- Variable_name: innodb_open_files
- Value: 2000
- *************************** 171. row ***************************
- Variable_name: innodb_optimize_fulltext_only
- Value: OFF
- *************************** 172. row ***************************
- Variable_name: innodb_page_size
- Value: 16384
- *************************** 173. row ***************************
- Variable_name: innodb_print_all_deadlocks
- Value: OFF
- *************************** 174. row ***************************
- Variable_name: innodb_purge_batch_size
- Value: 300
- *************************** 175. row ***************************
- Variable_name: innodb_purge_threads
- Value: 1
- *************************** 176. row ***************************
- Variable_name: innodb_random_read_ahead
- Value: OFF
- *************************** 177. row ***************************
- Variable_name: innodb_read_ahead_threshold
- Value: 56
- *************************** 178. row ***************************
- Variable_name: innodb_read_io_threads
- Value: 4
- *************************** 179. row ***************************
- Variable_name: innodb_read_only
- Value: OFF
- *************************** 180. row ***************************
- Variable_name: innodb_replication_delay
- Value: 0
- *************************** 181. row ***************************
- Variable_name: innodb_rollback_on_timeout
- Value: OFF
- *************************** 182. row ***************************
- Variable_name: innodb_rollback_segments
- Value: 128
- *************************** 183. row ***************************
- Variable_name: innodb_sort_buffer_size
- Value: 1048576
- *************************** 184. row ***************************
- Variable_name: innodb_spin_wait_delay
- Value: 6
- *************************** 185. row ***************************
- Variable_name: innodb_stats_auto_recalc
- Value: ON
- *************************** 186. row ***************************
- Variable_name: innodb_stats_method
- Value: nulls_equal
- *************************** 187. row ***************************
- Variable_name: innodb_stats_on_metadata
- Value: OFF
- *************************** 188. row ***************************
- Variable_name: innodb_stats_persistent
- Value: ON
- *************************** 189. row ***************************
- Variable_name: innodb_stats_persistent_sample_pages
- Value: 20
- *************************** 190. row ***************************
- Variable_name: innodb_stats_sample_pages
- Value: 8
- *************************** 191. row ***************************
- Variable_name: innodb_stats_transient_sample_pages
- Value: 8
- *************************** 192. row ***************************
- Variable_name: innodb_status_output
- Value: OFF
- *************************** 193. row ***************************
- Variable_name: innodb_status_output_locks
- Value: OFF
- *************************** 194. row ***************************
- Variable_name: innodb_strict_mode
- Value: OFF
- *************************** 195. row ***************************
- Variable_name: innodb_support_xa
- Value: ON
- *************************** 196. row ***************************
- Variable_name: innodb_sync_array_size
- Value: 1
- *************************** 197. row ***************************
- Variable_name: innodb_sync_spin_loops
- Value: 30
- *************************** 198. row ***************************
- Variable_name: innodb_table_locks
- Value: ON
- *************************** 199. row ***************************
- Variable_name: innodb_thread_concurrency
- Value: 0
- *************************** 200. row ***************************
- Variable_name: innodb_thread_sleep_delay
- Value: 10000
- *************************** 201. row ***************************
- Variable_name: innodb_undo_directory
- Value: .
- *************************** 202. row ***************************
- Variable_name: innodb_undo_logs
- Value: 128
- *************************** 203. row ***************************
- Variable_name: innodb_undo_tablespaces
- Value: 0
- *************************** 204. row ***************************
- Variable_name: innodb_use_native_aio
- Value: ON
- *************************** 205. row ***************************
- Variable_name: innodb_use_sys_malloc
- Value: ON
- *************************** 206. row ***************************
- Variable_name: innodb_version
- Value: 5.6.26
- *************************** 207. row ***************************
- Variable_name: innodb_write_io_threads
- Value: 4
- *************************** 208. row ***************************
- Variable_name: interactive_timeout
- Value: 720
- *************************** 209. row ***************************
- Variable_name: join_buffer_size
- Value: 33554432
- *************************** 210. row ***************************
- Variable_name: keep_files_on_create
- Value: OFF
- *************************** 211. row ***************************
- Variable_name: key_buffer_size
- Value: 1073741824
- *************************** 212. row ***************************
- Variable_name: key_cache_age_threshold
- Value: 300
- *************************** 213. row ***************************
- Variable_name: key_cache_block_size
- Value: 1024
- *************************** 214. row ***************************
- Variable_name: key_cache_division_limit
- Value: 100
- *************************** 215. row ***************************
- Variable_name: large_files_support
- Value: ON
- *************************** 216. row ***************************
- Variable_name: large_page_size
- Value: 0
- *************************** 217. row ***************************
- Variable_name: large_pages
- Value: OFF
- *************************** 218. row ***************************
- Variable_name: lc_messages
- Value: en_US
- *************************** 219. row ***************************
- Variable_name: lc_messages_dir
- Value: /usr/share/mysql/
- *************************** 220. row ***************************
- Variable_name: lc_time_names
- Value: en_US
- *************************** 221. row ***************************
- Variable_name: license
- Value: GPL
- *************************** 222. row ***************************
- Variable_name: local_infile
- Value: ON
- *************************** 223. row ***************************
- Variable_name: lock_wait_timeout
- Value: 31536000
- *************************** 224. row ***************************
- Variable_name: locked_in_memory
- Value: OFF
- *************************** 225. row ***************************
- Variable_name: log_bin
- Value: ON
- *************************** 226. row ***************************
- Variable_name: log_bin_basename
- Value: /var/lib/mysql/mysql-bin
- *************************** 227. row ***************************
- Variable_name: log_bin_index
- Value: /var/lib/mysql/mysql-bin.index
- *************************** 228. row ***************************
- Variable_name: log_bin_trust_function_creators
- Value: OFF
- *************************** 229. row ***************************
- Variable_name: log_bin_use_v1_row_events
- Value: OFF
- *************************** 230. row ***************************
- Variable_name: log_error
- Value: /var/log/mysql/error.log
- *************************** 231. row ***************************
- Variable_name: log_output
- Value: FILE
- *************************** 232. row ***************************
- Variable_name: log_queries_not_using_indexes
- Value: ON
- *************************** 233. row ***************************
- Variable_name: log_slave_updates
- Value: OFF
- *************************** 234. row ***************************
- Variable_name: log_slow_admin_statements
- Value: OFF
- *************************** 235. row ***************************
- Variable_name: log_slow_slave_statements
- Value: OFF
- *************************** 236. row ***************************
- Variable_name: log_throttle_queries_not_using_indexes
- Value: 0
- *************************** 237. row ***************************
- Variable_name: log_warnings
- Value: 1
- *************************** 238. row ***************************
- Variable_name: long_query_time
- Value: 10.000000
- *************************** 239. row ***************************
- Variable_name: low_priority_updates
- Value: OFF
- *************************** 240. row ***************************
- Variable_name: lower_case_file_system
- Value: OFF
- *************************** 241. row ***************************
- Variable_name: lower_case_table_names
- Value: 0
- *************************** 242. row ***************************
- Variable_name: master_info_repository
- Value: FILE
- *************************** 243. row ***************************
- Variable_name: master_verify_checksum
- Value: OFF
- *************************** 244. row ***************************
- Variable_name: max_allowed_packet
- Value: 4194304
- *************************** 245. row ***************************
- Variable_name: max_binlog_cache_size
- Value: 18446744073709547520
- *************************** 246. row ***************************
- Variable_name: max_binlog_size
- Value: 1073741824
- *************************** 247. row ***************************
- Variable_name: max_binlog_stmt_cache_size
- Value: 18446744073709547520
- *************************** 248. row ***************************
- Variable_name: max_connect_errors
- Value: 100
- *************************** 249. row ***************************
- Variable_name: max_connections
- Value: 3072
- *************************** 250. row ***************************
- Variable_name: max_delayed_threads
- Value: 20
- *************************** 251. row ***************************
- Variable_name: max_digest_length
- Value: 1024
- *************************** 252. row ***************************
- Variable_name: max_error_count
- Value: 64
- *************************** 253. row ***************************
- Variable_name: max_heap_table_size
- Value: 201326592
- *************************** 254. row ***************************
- Variable_name: max_insert_delayed_threads
- Value: 20
- *************************** 255. row ***************************
- Variable_name: max_join_size
- Value: 18446744073709551615
- *************************** 256. row ***************************
- Variable_name: max_length_for_sort_data
- Value: 1024
- *************************** 257. row ***************************
- Variable_name: max_prepared_stmt_count
- Value: 16382
- *************************** 258. row ***************************
- Variable_name: max_relay_log_size
- Value: 0
- *************************** 259. row ***************************
- Variable_name: max_seeks_for_key
- Value: 18446744073709551615
- *************************** 260. row ***************************
- Variable_name: max_sort_length
- Value: 1024
- *************************** 261. row ***************************
- Variable_name: max_sp_recursion_depth
- Value: 0
- *************************** 262. row ***************************
- Variable_name: max_tmp_tables
- Value: 32
- *************************** 263. row ***************************
- Variable_name: max_user_connections
- Value: 3072
- *************************** 264. row ***************************
- Variable_name: max_write_lock_count
- Value: 18446744073709551615
- *************************** 265. row ***************************
- Variable_name: metadata_locks_cache_size
- Value: 1024
- *************************** 266. row ***************************
- Variable_name: metadata_locks_hash_instances
- Value: 8
- *************************** 267. row ***************************
- Variable_name: min_examined_row_limit
- Value: 0
- *************************** 268. row ***************************
- Variable_name: multi_range_count
- Value: 256
- *************************** 269. row ***************************
- Variable_name: myisam_data_pointer_size
- Value: 6
- *************************** 270. row ***************************
- Variable_name: myisam_max_sort_file_size
- Value: 9223372036853727232
- *************************** 271. row ***************************
- Variable_name: myisam_mmap_size
- Value: 18446744073709551615
- *************************** 272. row ***************************
- Variable_name: myisam_recover_options
- Value: OFF
- *************************** 273. row ***************************
- Variable_name: myisam_repair_threads
- Value: 1
- *************************** 274. row ***************************
- Variable_name: myisam_sort_buffer_size
- Value: 8388608
- *************************** 275. row ***************************
- Variable_name: myisam_stats_method
- Value: nulls_unequal
- *************************** 276. row ***************************
- Variable_name: myisam_use_mmap
- Value: OFF
- *************************** 277. row ***************************
- Variable_name: net_buffer_length
- Value: 262144
- *************************** 278. row ***************************
- Variable_name: net_read_timeout
- Value: 30
- *************************** 279. row ***************************
- Variable_name: net_retry_count
- Value: 10
- *************************** 280. row ***************************
- Variable_name: net_write_timeout
- Value: 60
- *************************** 281. row ***************************
- Variable_name: new
- Value: OFF
- *************************** 282. row ***************************
- Variable_name: old
- Value: OFF
- *************************** 283. row ***************************
- Variable_name: old_alter_table
- Value: OFF
- *************************** 284. row ***************************
- Variable_name: old_passwords
- Value: 0
- *************************** 285. row ***************************
- Variable_name: open_files_limit
- Value: 1024000
- *************************** 286. row ***************************
- Variable_name: optimizer_prune_level
- Value: 1
- *************************** 287. row ***************************
- Variable_name: optimizer_search_depth
- Value: 62
- *************************** 288. row ***************************
- Variable_name: optimizer_switch
- Value: 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
- *************************** 289. row ***************************
- Variable_name: optimizer_trace
- Value: enabled=off,one_line=off
- *************************** 290. row ***************************
- Variable_name: optimizer_trace_features
- Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
- *************************** 291. row ***************************
- Variable_name: optimizer_trace_limit
- Value: 1
- *************************** 292. row ***************************
- Variable_name: optimizer_trace_max_mem_size
- Value: 16384
- *************************** 293. row ***************************
- Variable_name: optimizer_trace_offset
- Value: -1
- *************************** 294. row ***************************
- Variable_name: performance_schema
- Value: ON
- *************************** 295. row ***************************
- Variable_name: performance_schema_accounts_size
- Value: 100
- *************************** 296. row ***************************
- Variable_name: performance_schema_digests_size
- Value: 10000
- *************************** 297. row ***************************
- Variable_name: performance_schema_events_stages_history_long_size
- Value: 10000
- *************************** 298. row ***************************
- Variable_name: performance_schema_events_stages_history_size
- Value: 10
- *************************** 299. row ***************************
- Variable_name: performance_schema_events_statements_history_long_size
- Value: 10000
- *************************** 300. row ***************************
- Variable_name: performance_schema_events_statements_history_size
- Value: 10
- *************************** 301. row ***************************
- Variable_name: performance_schema_events_waits_history_long_size
- Value: 10000
- *************************** 302. row ***************************
- Variable_name: performance_schema_events_waits_history_size
- Value: 10
- *************************** 303. row ***************************
- Variable_name: performance_schema_hosts_size
- Value: 100
- *************************** 304. row ***************************
- Variable_name: performance_schema_max_cond_classes
- Value: 80
- *************************** 305. row ***************************
- Variable_name: performance_schema_max_cond_instances
- Value: 15188
- *************************** 306. row ***************************
- Variable_name: performance_schema_max_digest_length
- Value: 1024
- *************************** 307. row ***************************
- Variable_name: performance_schema_max_file_classes
- Value: 50
- *************************** 308. row ***************************
- Variable_name: performance_schema_max_file_handles
- Value: 32768
- *************************** 309. row ***************************
- Variable_name: performance_schema_max_file_instances
- Value: 31508
- *************************** 310. row ***************************
- Variable_name: performance_schema_max_mutex_classes
- Value: 200
- *************************** 311. row ***************************
- Variable_name: performance_schema_max_mutex_instances
- Value: 33432
- *************************** 312. row ***************************
- Variable_name: performance_schema_max_rwlock_classes
- Value: 40
- *************************** 313. row ***************************
- Variable_name: performance_schema_max_rwlock_instances
- Value: 14944
- *************************** 314. row ***************************
- Variable_name: performance_schema_max_socket_classes
- Value: 10
- *************************** 315. row ***************************
- Variable_name: performance_schema_max_socket_instances
- Value: 6164
- *************************** 316. row ***************************
- Variable_name: performance_schema_max_stage_classes
- Value: 150
- *************************** 317. row ***************************
- Variable_name: performance_schema_max_statement_classes
- Value: 168
- *************************** 318. row ***************************
- Variable_name: performance_schema_max_table_handles
- Value: 4000
- *************************** 319. row ***************************
- Variable_name: performance_schema_max_table_instances
- Value: 12500
- *************************** 320. row ***************************
- Variable_name: performance_schema_max_thread_classes
- Value: 50
- *************************** 321. row ***************************
- Variable_name: performance_schema_max_thread_instances
- Value: 6244
- *************************** 322. row ***************************
- Variable_name: performance_schema_session_connect_attrs_size
- Value: 512
- *************************** 323. row ***************************
- Variable_name: performance_schema_setup_actors_size
- Value: 100
- *************************** 324. row ***************************
- Variable_name: performance_schema_setup_objects_size
- Value: 100
- *************************** 325. row ***************************
- Variable_name: performance_schema_users_size
- Value: 100
- *************************** 326. row ***************************
- Variable_name: pid_file
- Value: /var/run/mysqld/mysqld.pid
- *************************** 327. row ***************************
- Variable_name: plugin_dir
- Value: /usr/lib/mysql/plugin/
- *************************** 328. row ***************************
- Variable_name: port
- Value: 3306
- *************************** 329. row ***************************
- Variable_name: preload_buffer_size
- Value: 32768
- *************************** 330. row ***************************
- Variable_name: profiling
- Value: OFF
- *************************** 331. row ***************************
- Variable_name: profiling_history_size
- Value: 15
- *************************** 332. row ***************************
- Variable_name: protocol_version
- Value: 10
- *************************** 333. row ***************************
- Variable_name: query_alloc_block_size
- Value: 8192
- *************************** 334. row ***************************
- Variable_name: query_cache_limit
- Value: 2097152
- *************************** 335. row ***************************
- Variable_name: query_cache_min_res_unit
- Value: 4096
- *************************** 336. row ***************************
- Variable_name: query_cache_size
- Value: 201326592
- *************************** 337. row ***************************
- Variable_name: query_cache_type
- Value: OFF
- *************************** 338. row ***************************
- Variable_name: query_cache_wlock_invalidate
- Value: OFF
- *************************** 339. row ***************************
- Variable_name: query_prealloc_size
- Value: 8192
- *************************** 340. row ***************************
- Variable_name: range_alloc_block_size
- Value: 4096
- *************************** 341. row ***************************
- Variable_name: read_buffer_size
- Value: 2097152
- *************************** 342. row ***************************
- Variable_name: read_only
- Value: ON
- *************************** 343. row ***************************
- Variable_name: read_rnd_buffer_size
- Value: 2097152
- *************************** 344. row ***************************
- Variable_name: relay_log
- Value:
- *************************** 345. row ***************************
- Variable_name: relay_log_basename
- Value:
- *************************** 346. row ***************************
- Variable_name: relay_log_index
- Value:
- *************************** 347. row ***************************
- Variable_name: relay_log_info_file
- Value: relay-log.info
- *************************** 348. row ***************************
- Variable_name: relay_log_info_repository
- Value: FILE
- *************************** 349. row ***************************
- Variable_name: relay_log_purge
- Value: ON
- *************************** 350. row ***************************
- Variable_name: relay_log_recovery
- Value: OFF
- *************************** 351. row ***************************
- Variable_name: relay_log_space_limit
- Value: 0
- *************************** 352. row ***************************
- Variable_name: report_host
- Value:
- *************************** 353. row ***************************
- Variable_name: report_password
- Value:
- *************************** 354. row ***************************
- Variable_name: report_port
- Value: 3306
- *************************** 355. row ***************************
- Variable_name: report_user
- Value:
- *************************** 356. row ***************************
- Variable_name: rpl_stop_slave_timeout
- Value: 31536000
- *************************** 357. row ***************************
- Variable_name: secure_auth
- Value: ON
- *************************** 358. row ***************************
- Variable_name: secure_file_priv
- Value:
- *************************** 359. row ***************************
- Variable_name: server_id
- Value: 1
- *************************** 360. row ***************************
- Variable_name: server_id_bits
- Value: 32
- *************************** 361. row ***************************
- Variable_name: server_uuid
- Value: 29954b68-ac1e-11e8-bfd7-525400dffdd7
- *************************** 362. row ***************************
- Variable_name: show_old_temporals
- Value: OFF
- *************************** 363. row ***************************
- Variable_name: simplified_binlog_gtid_recovery
- Value: OFF
- *************************** 364. row ***************************
- Variable_name: skip_external_locking
- Value: ON
- *************************** 365. row ***************************
- Variable_name: skip_name_resolve
- Value: OFF
- *************************** 366. row ***************************
- Variable_name: skip_networking
- Value: OFF
- *************************** 367. row ***************************
- Variable_name: skip_show_database
- Value: OFF
- *************************** 368. row ***************************
- Variable_name: slave_allow_batching
- Value: OFF
- *************************** 369. row ***************************
- Variable_name: slave_checkpoint_group
- Value: 512
- *************************** 370. row ***************************
- Variable_name: slave_checkpoint_period
- Value: 300
- *************************** 371. row ***************************
- Variable_name: slave_compressed_protocol
- Value: OFF
- *************************** 372. row ***************************
- Variable_name: slave_exec_mode
- Value: STRICT
- *************************** 373. row ***************************
- Variable_name: slave_load_tmpdir
- Value: /run/shm
- *************************** 374. row ***************************
- Variable_name: slave_max_allowed_packet
- Value: 1073741824
- *************************** 375. row ***************************
- Variable_name: slave_net_timeout
- Value: 3600
- *************************** 376. row ***************************
- Variable_name: slave_parallel_workers
- Value: 0
- *************************** 377. row ***************************
- Variable_name: slave_pending_jobs_size_max
- Value: 16777216
- *************************** 378. row ***************************
- Variable_name: slave_rows_search_algorithms
- Value: TABLE_SCAN,INDEX_SCAN
- *************************** 379. row ***************************
- Variable_name: slave_skip_errors
- Value: OFF
- *************************** 380. row ***************************
- Variable_name: slave_sql_verify_checksum
- Value: ON
- *************************** 381. row ***************************
- Variable_name: slave_transaction_retries
- Value: 10
- *************************** 382. row ***************************
- Variable_name: slave_type_conversions
- Value:
- *************************** 383. row ***************************
- Variable_name: slow_launch_time
- Value: 2
- *************************** 384. row ***************************
- Variable_name: slow_query_log
- Value: OFF
- *************************** 385. row ***************************
- Variable_name: slow_query_log_file
- Value: /var/log/mysql/slow.log
- *************************** 386. row ***************************
- Variable_name: socket
- Value: /var/run/mysqld/mysqld.sock
- *************************** 387. row ***************************
- Variable_name: sort_buffer_size
- Value: 4194304
- *************************** 388. row ***************************
- Variable_name: sql_auto_is_null
- Value: OFF
- *************************** 389. row ***************************
- Variable_name: sql_big_selects
- Value: ON
- *************************** 390. row ***************************
- Variable_name: sql_buffer_result
- Value: OFF
- *************************** 391. row ***************************
- Variable_name: sql_log_bin
- Value: ON
- *************************** 392. row ***************************
- Variable_name: sql_log_off
- Value: OFF
- *************************** 393. row ***************************
- Variable_name: sql_mode
- Value: NO_ENGINE_SUBSTITUTION
- *************************** 394. row ***************************
- Variable_name: sql_notes
- Value: ON
- *************************** 395. row ***************************
- Variable_name: sql_quote_show_create
- Value: ON
- *************************** 396. row ***************************
- Variable_name: sql_safe_updates
- Value: OFF
- *************************** 397. row ***************************
- Variable_name: sql_select_limit
- Value: 18446744073709551615
- *************************** 398. row ***************************
- Variable_name: sql_slave_skip_counter
- Value: 0
- *************************** 399. row ***************************
- Variable_name: sql_warnings
- Value: OFF
- *************************** 400. row ***************************
- Variable_name: ssl_ca
- Value:
- *************************** 401. row ***************************
- Variable_name: ssl_capath
- Value:
- *************************** 402. row ***************************
- Variable_name: ssl_cert
- Value:
- *************************** 403. row ***************************
- Variable_name: ssl_cipher
- Value:
- *************************** 404. row ***************************
- Variable_name: ssl_crl
- Value:
- *************************** 405. row ***************************
- Variable_name: ssl_crlpath
- Value:
- *************************** 406. row ***************************
- Variable_name: ssl_key
- Value:
- *************************** 407. row ***************************
- Variable_name: storage_engine
- Value: InnoDB
- *************************** 408. row ***************************
- Variable_name: stored_program_cache
- Value: 256
- *************************** 409. row ***************************
- Variable_name: sync_binlog
- Value: 1
- *************************** 410. row ***************************
- Variable_name: sync_frm
- Value: ON
- *************************** 411. row ***************************
- Variable_name: sync_master_info
- Value: 10000
- *************************** 412. row ***************************
- Variable_name: sync_relay_log
- Value: 10000
- *************************** 413. row ***************************
- Variable_name: sync_relay_log_info
- Value: 10000
- *************************** 414. row ***************************
- Variable_name: system_time_zone
- Value: CET
- *************************** 415. row ***************************
- Variable_name: table_definition_cache
- Value: 1400
- *************************** 416. row ***************************
- Variable_name: table_open_cache
- Value: 2000
- *************************** 417. row ***************************
- Variable_name: table_open_cache_instances
- Value: 1
- *************************** 418. row ***************************
- Variable_name: thread_cache_size
- Value: 96
- *************************** 419. row ***************************
- Variable_name: thread_concurrency
- Value: 12
- *************************** 420. row ***************************
- Variable_name: thread_handling
- Value: one-thread-per-connection
- *************************** 421. row ***************************
- Variable_name: thread_stack
- Value: 262144
- *************************** 422. row ***************************
- Variable_name: time_format
- Value: %H:%i:%s
- *************************** 423. row ***************************
- Variable_name: time_zone
- Value: SYSTEM
- *************************** 424. row ***************************
- Variable_name: timed_mutexes
- Value: OFF
- *************************** 425. row ***************************
- Variable_name: tmp_table_size
- Value: 201326592
- *************************** 426. row ***************************
- Variable_name: tmpdir
- Value: /run/shm
- *************************** 427. row ***************************
- Variable_name: transaction_alloc_block_size
- Value: 8192
- *************************** 428. row ***************************
- Variable_name: transaction_prealloc_size
- Value: 4096
- *************************** 429. row ***************************
- Variable_name: tx_isolation
- Value: REPEATABLE-READ
- *************************** 430. row ***************************
- Variable_name: tx_read_only
- Value: OFF
- *************************** 431. row ***************************
- Variable_name: unique_checks
- Value: ON
- *************************** 432. row ***************************
- Variable_name: updatable_views_with_limit
- Value: YES
- *************************** 433. row ***************************
- Variable_name: version
- Value: 5.6.26-log
- *************************** 434. row ***************************
- Variable_name: version_comment
- Value: MySQL Community Server (GPL)
- *************************** 435. row ***************************
- Variable_name: version_compile_machine
- Value: x86_64
- *************************** 436. row ***************************
- Variable_name: version_compile_os
- Value: Linux
- *************************** 437. row ***************************
- Variable_name: wait_timeout
- Value: 720
- 437 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement