API tools faq
paste
Advertisement
Ap3xH4x0r

Forside HT-Busser Database Dump #Anonsec

Ap3xH4x0r
Jul 1st, 2014
1,251
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 84.05 KB | None | 0 0
raw download clone embed print report
  1. _ _ ___
  2. _| || |_ / _ \
  3. |_ __ _/ /_\ \_ __ ___ _ __ ___ ___ ___
  4. _| || |_| _ | '_ \ / _ \| '_ \/ __|/ _ \/ __|
  5. |_ __ _| | | | | | | (_) | | | \__ \ __/ (__
  6. |_||_| \_| |_/_| |_|\___/|_| |_|___/\___|\___|
  7.  
  8. Laughing at your security since 2012
  9.  
  10.  
  11. We Are : Mrlele - AnonSec666 - 3r3b0s - 4prili666h05t - d3f4ult - Hannaichi - ap3x h4x0r
  12.  
  13.  
  14.  
  15. http://ht-busser.dk/
  16.  
  17.  
  18. DataBase: Ht_Busser_dk
  19.  
  20.  
  21. KSUM | NODEGROUP | DATA_FREE | TABLE_ROWS | TABLE_NAME | CHECK_TIME | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | AVG_ROW_LENGTH | PARTITION_NAME | TABLESPACE_NAME | MAX_DATA_LENGTH | PARTITION_METHOD | SUBPARTITION_NAME | PARTITION_COMMENT | SUBPARTITION_METHOD | PARTITION_EXPRESSION | PARTITION_DESCRIPTION | SUBPARTITION_EXPRESSION | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION |
  22. -----+-----------+-----------+------------+---------------------------------------+------------+---------------------+---------------------+-------------+--------------+--------------------+---------------+----------------+----------------+-----------------+------------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+
  23. | <blank> | 0 | 0 | CHARACTER_SETS | NULL | NULL | 2014-07-01 14:49:10 | 0 | 0 | information_schema | def | 384 | NULL | NULL | 2103657216 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  24. | <blank> | 0 | 0 | CLIENT_STATISTICS | NULL | NULL | 2014-07-01 14:49:11 | 0 | 0 | information_schema | def | 370 | NULL | NULL | 2113215040 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  25. | <blank> | 0 | 0 | COLLATIONS | NULL | NULL | 2014-07-01 14:49:11 | 0 | 0 | information_schema | def | 231 | NULL | NULL | 2138227245 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  26. | <blank> | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2014-07-01 14:49:12 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 2093796510 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  27. | <blank> | 0 | 0 | COLUMNS | NULL | 2014-07-01 14:49:13 | 2014-07-01 14:49:13 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  28. | <blank> | 0 | 0 | COLUMN_PRIVILEGES | NULL | NULL | 2014-07-01 14:49:13 | 0 | 0 | information_schema | def | 2565 | NULL | NULL | 2144973555 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  29. | <blank> | 0 | 0 | ENGINES | NULL | NULL | 2014-07-01 14:49:14 | 0 | 0 | information_schema | def | 731 | NULL | NULL | 2132894256 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  30. | <blank> | 0 | 0 | EVENTS | NULL | 2014-07-01 14:49:14 | 2014-07-01 14:49:14 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  31. | <blank> | 0 | 0 | FILES | NULL | NULL | 2014-07-01 14:49:15 | 0 | 0 | information_schema | def | 2677 | NULL | NULL | 2145077423 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  32. | <blank> | 0 | 0 | GLOBAL_STATUS | NULL | NULL | 2014-07-01 14:49:16 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 2144857028 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  33. | <blank> | 0 | 0 | GLOBAL_VARIABLES | NULL | NULL | 2014-07-01 14:49:16 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 2144857028 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  34. | <blank> | 0 | 0 | INDEX_STATISTICS | NULL | NULL | 2014-07-01 14:49:17 | 0 | 0 | information_schema | def | 1743 | NULL | NULL | 2146251765 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  35. | <blank> | 0 | 0 | KEY_CACHES | NULL | NULL | 2014-07-01 14:49:18 | 0 | 0 | information_schema | def | 659 | NULL | NULL | 2131312758 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  36. | <blank> | 0 | 0 | KEY_COLUMN_USAGE | NULL | NULL | 2014-07-01 14:49:38 | 0 | 0 | information_schema | def | 4637 | NULL | NULL | 2146091703 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  37. | <blank> | 0 | 0 | PARAMETERS | NULL | 2014-07-01 14:49:41 | 2014-07-01 14:49:41 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  38. | <blank> | 0 | 0 | PARTITIONS | NULL | 2014-07-01 14:49:42 | 2014-07-01 14:49:42 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  39. | <blank> | 0 | 0 | PLUGINS | NULL | 2014-07-01 14:49:45 | 2014-07-01 14:49:45 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  40. | <blank> | 0 | 0 | PROCESSLIST | NULL | 2014-07-01 14:49:47 | 2014-07-01 14:49:47 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  41. | <blank> | 0 | 0 | PROFILING | NULL | NULL | 2014-07-01 14:49:49 | 0 | 0 | information_schema | def | 308 | NULL | NULL | 2119951680 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  42. | <blank> | 0 | 0 | REFERENTIAL_CONSTRAINTS | NULL | NULL | 2014-07-01 14:49:51 | 0 | 0 | information_schema | def | 4814 | NULL | NULL | 2146591484 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  43. | <blank> | 0 | 0 | ROUTINES | NULL | 2014-07-01 14:49:53 | 2014-07-01 14:49:53 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  44. | <blank> | 0 | 0 | SCHEMATA | NULL | NULL | 2014-07-01 14:49:54 | 0 | 0 | information_schema | def | 3464 | NULL | NULL | 2142532496 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  45. | <blank> | 0 | 0 | SCHEMA_PRIVILEGES | NULL | NULL | 2014-07-01 14:49:56 | 0 | 0 | information_schema | def | 2179 | NULL | NULL | 2142567120 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  46. | <blank> | 0 | 0 | SESSION_STATUS | NULL | NULL | 2014-07-01 14:49:58 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 2144857028 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  47. | <blank> | 0 | 0 | SESSION_VARIABLES | NULL | NULL | 2014-07-01 14:49:59 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 2144857028 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  48. | <blank> | 0 | 0 | STATISTICS | NULL | NULL | 2014-07-01 14:50:00 | 0 | 0 | information_schema | def | 5753 | NULL | NULL | 2144873731 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  49. | <blank> | 0 | 0 | TABLES | NULL | NULL | 2014-07-01 14:50:01 | 0 | 0 | information_schema | def | 9450 | NULL | NULL | 2146113900 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  50. | <blank> | 0 | 0 | TABLESPACES | NULL | NULL | 2014-07-01 14:50:01 | 0 | 0 | information_schema | def | 6951 | NULL | NULL | 2147170851 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  51. | <blank> | 0 | 0 | TABLE_CONSTRAINTS | NULL | NULL | 2014-07-01 14:50:02 | 0 | 0 | information_schema | def | 2504 | NULL | NULL | 2140642056 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  52. | <blank> | 0 | 0 | TABLE_PRIVILEGES | NULL | NULL | 2014-07-01 14:50:03 | 0 | 0 | information_schema | def | 2372 | NULL | NULL | 2143868156 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  53. | <blank> | 0 | 0 | TABLE_STATISTICS | NULL | NULL | 2014-07-01 14:50:03 | 0 | 0 | information_schema | def | 1181 | NULL | NULL | 2142042293 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  54. | <blank> | 0 | 0 | TRIGGERS | NULL | 2014-07-01 14:50:04 | 2014-07-01 14:50:04 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  55. | <blank> | 0 | 0 | USER_PRIVILEGES | NULL | NULL | 2014-07-01 14:50:05 | 0 | 0 | information_schema | def | 1986 | NULL | NULL | 2141015244 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  56. | <blank> | 0 | 0 | USER_STATISTICS | NULL | NULL | 2014-07-01 14:50:06 | 0 | 0 | information_schema | def | 551 | NULL | NULL | 2143592768 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  57. | <blank> | 0 | 0 | VIEWS | NULL | 2014-07-01 14:50:06 | 2014-07-01 14:50:06 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  58. | <blank> | 0 | 0 | INNODB_CMPMEM_RESET | NULL | NULL | 2014-07-01 14:50:07 | 0 | 0 | information_schema | def | 29 | NULL | NULL | 1946157056 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  59. | <blank> | 0 | 0 | INNODB_RSEG | NULL | NULL | 2014-07-01 14:50:08 | 0 | 0 | information_schema | def | 49 | NULL | NULL | 1879048178 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  60. | <blank> | 0 | 0 | INNODB_UNDO_LOGS | NULL | NULL | 2014-07-01 14:50:08 | 0 | 0 | information_schema | def | 1620 | NULL | NULL | 2142194040 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  61. | <blank> | 0 | 0 | INNODB_CMPMEM | NULL | NULL | 2014-07-01 14:50:09 | 0 | 0 | information_schema | def | 29 | NULL | NULL | 1946157056 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  62. | <blank> | 0 | 0 | INNODB_SYS_TABLESTATS | NULL | NULL | 2014-07-01 14:50:09 | 0 | 0 | information_schema | def | 1796 | NULL | NULL | 2142710616 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  63. | <blank> | 0 | 0 | INNODB_LOCK_WAITS | NULL | NULL | 2014-07-01 14:50:10 | 0 | 0 | information_schema | def | 599 | NULL | NULL | 2143904261 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  64. | <blank> | 0 | 0 | INNODB_INDEX_STATS | NULL | NULL | 2014-07-01 14:50:11 | 0 | 0 | information_schema | def | 2529 | NULL | NULL | 2141554671 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  65. | <blank> | 0 | 0 | INNODB_CMP | NULL | NULL | 2014-07-01 14:50:11 | 0 | 0 | information_schema | def | 25 | NULL | NULL | 1677721600 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  66. | <blank> | 0 | 0 | INNODB_CMP_RESET | NULL | NULL | 2014-07-01 14:50:12 | 0 | 0 | information_schema | def | 25 | NULL | NULL | 1677721600 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  67. | <blank> | 0 | 0 | INNODB_CHANGED_PAGES | NULL | NULL | 2014-07-01 14:50:13 | 0 | 0 | information_schema | def | 25 | NULL | NULL | 1677721600 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  68. | <blank> | 0 | 0 | INNODB_BUFFER_POOL_PAGES | NULL | NULL | 2014-07-01 14:50:13 | 0 | 0 | information_schema | def | 234 | NULL | NULL | 2093796432 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  69. | <blank> | 0 | 0 | INNODB_TRX | NULL | NULL | 2014-07-01 14:50:15 | 0 | 0 | information_schema | def | 4534 | NULL | NULL | 2146536154 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  70. | <blank> | 0 | 0 | INNODB_BUFFER_POOL_PAGES_INDEX | NULL | NULL | 2014-07-01 14:50:16 | 0 | 0 | information_schema | def | 105 | NULL | NULL | 2013265905 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  71. | <blank> | 0 | 0 | INNODB_LOCKS | NULL | NULL | 2014-07-01 14:50:16 | 0 | 0 | information_schema | def | 31244 | NULL | NULL | 2147181412 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  72. | <blank> | 0 | 0 | INNODB_BUFFER_POOL_PAGES_BLOB | NULL | NULL | 2014-07-01 14:50:18 | 0 | 0 | information_schema | def | 65 | NULL | NULL | 1938700465 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  73. | <blank> | 0 | 0 | INNODB_SYS_TABLES | NULL | NULL | 2014-07-01 14:50:18 | 0 | 0 | information_schema | def | 1183 | NULL | NULL | 2145669799 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  74. | <blank> | 0 | 0 | INNODB_SYS_FIELDS | NULL | NULL | 2014-07-01 14:50:19 | 0 | 0 | information_schema | def | 594 | NULL | NULL | 2126008566 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  75. | <blank> | 0 | 0 | INNODB_SYS_COLUMNS | NULL | NULL | 2014-07-01 14:50:20 | 0 | 0 | information_schema | def | 610 | NULL | NULL | 2126566140 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  76. | <blank> | 0 | 0 | INNODB_SYS_STATS | NULL | NULL | 2014-07-01 14:50:20 | 0 | 0 | information_schema | def | 29 | NULL | NULL | 1946157056 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  77. | <blank> | 0 | 0 | QUERY_CACHE_INFO | NULL | 2014-07-01 14:50:21 | 2014-07-01 14:50:21 | 8192 | 8192 | information_schema | def | 0 | NULL | NULL | 4503599627288576 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  78. | <blank> | 0 | 0 | INNODB_SYS_INDEXES | NULL | NULL | 2014-07-01 14:50:22 | 0 | 0 | information_schema | def | 614 | NULL | NULL | 2140510836 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  79. | <blank> | 0 | 0 | XTRADB_ADMIN_COMMAND | NULL | NULL | 2014-07-01 14:50:23 | 0 | 0 | information_schema | def | 3075 | NULL | NULL | 2143994550 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  80. | <blank> | 0 | 0 | INNODB_TABLE_STATS | NULL | NULL | 2014-07-01 14:50:23 | 0 | 0 | information_schema | def | 1189 | NULL | NULL | 2142078620 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  81. | <blank> | 0 | 0 | INNODB_SYS_FOREIGN_COLS | NULL | NULL | 2014-07-01 14:50:24 | 0 | 0 | information_schema | def | 1748 | NULL | NULL | 2142579536 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  82. | <blank> | 0 | 0 | INNODB_BUFFER_PAGE_LRU | NULL | NULL | 2014-07-01 14:50:25 | 0 | 0 | information_schema | def | 6669 | NULL | NULL | 2146517685 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  83. | <blank> | 0 | 0 | INNODB_BUFFER_POOL_STATS | NULL | NULL | 2014-07-01 14:50:25 | 0 | 0 | information_schema | def | 257 | NULL | NULL | 2090542599 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  84. | <blank> | 0 | 0 | INNODB_BUFFER_PAGE | NULL | NULL | 2014-07-01 14:50:26 | 0 | 0 | information_schema | def | 6852 | NULL | NULL | 2146224552 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  85. | <blank> | 0 | 0 | INNODB_SYS_FOREIGN | NULL | NULL | 2014-07-01 14:50:26 | 0 | 0 | information_schema | def | 1752 | NULL | NULL | 2137722072 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  86. | <blank> | 0 | 6324 | fotos | NULL | 2014-05-22 09:24:27 | 2014-05-22 09:24:27 | 1359880 | 96256 | ht_busser_dk | def | 215 | NULL | NULL | 281474976710655 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  87. | <blank> | 0 | 176 | kategorier | NULL | 2014-05-22 09:24:27 | 2014-05-22 09:24:27 | 28032 | 5120 | ht_busser_dk | def | 159 | NULL | NULL | 281474976710655 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  88. | <blank> | 0 | 181 | menu | NULL | 2014-05-22 09:24:27 | 2014-05-22 09:24:27 | 3077 | 5120 | ht_busser_dk | def | 17 | NULL | NULL | 4785074604081151 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  89. | <blank> | 0 | 63 | menu1 | NULL | 2014-05-22 09:24:27 | 2014-05-22 09:24:27 | 819 | 2048 | ht_busser_dk | def | 13 | NULL | NULL | 3659174697238527 | NULL | NULL | <blank> | NULL | NULL | NULL | NULL | NULL | NULL |
  90. -----+-----------+-----------+------------+---------------------------------------+------------+---------------------+-----------------
  91.  
  92. +-------------+--------------------------------+--------------------+---------------+----------------------------+----------------+----------------+----------------+-----------------+----------------------------------------------------------------------------+---------------------+---------------------+------------------------+
  93. | LOAD_OPTION | PLUGIN_NAME | PLUGIN_TYPE | PLUGIN_STATUS | PLUGIN_AUTHOR | PLUGIN_VERSION | PLUGIN_LICENSE | PLUGIN_LIBRARY | PLUGIN_MATURITY | PLUGIN_DESCRIPTION | PLUGIN_AUTH_VERSION | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY_VERSION |
  94. +-------------+--------------------------------+--------------------+---------------+----------------------------+----------------+----------------+----------------+-----------------+----------------------------------------------------------------------------+---------------------+---------------------+------------------------+
  95. | FORCE | binlog | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | GPL | NULL | Stable | This is a pseudo storage engine to represent the binlog in a transaction | 1.0 | 50538.0 | NULL |
  96. | FORCE | mysql_native_password | AUTHENTICATION | ACTIVE | R.J.Silk, Sergei Golubchik | 1.0 | GPL | NULL | Beta | Native MySQL authentication | 1.0 | 2.0 | NULL |
  97. | FORCE | mysql_old_password | AUTHENTICATION | ACTIVE | R.J.Silk, Sergei Golubchik | 1.0 | GPL | NULL | Beta | Old MySQL-4.0 authentication | 1.0 | 2.0 | NULL |
  98. | FORCE | MEMORY | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | GPL | NULL | Stable | Hash based, stored in memory, useful for temporary tables | 1.0 | 50538.0 | NULL |
  99. | FORCE | MyISAM | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | GPL | NULL | Stable | MyISAM storage engine | 1.0 | 50538.0 | NULL |
  100. | FORCE | CSV | STORAGE ENGINE | ACTIVE | Brian Aker, MySQL AB | 1.0 | GPL | NULL | Stable | CSV storage engine | 1.0 | 50538.0 | NULL |
  101. | FORCE | MRG_MYISAM | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | GPL | NULL | Stable | Collection of identical MyISAM tables | 1.0 | 50538.0 | NULL |
  102. | FORCE | PERFORMANCE_SCHEMA | STORAGE ENGINE | ACTIVE | Marc Alff, Oracle | 0.1 | GPL | NULL | Gamma | Performance Schema | 0.1 | 50538.0 | NULL |
  103. | OFF | SPHINX | STORAGE ENGINE | DISABLED | Sphinx developers | 2.0 | GPL | NULL | Experimental | Sphinx storage engine | 2.0.4-release | 50538.0 | NULL |
  104. | ON | InnoDB | STORAGE ENGINE | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  105. | ON | INNODB_RSEG | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB rollback segment information | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  106. | ON | INNODB_UNDO_LOGS | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB rollback undo segment information | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  107. | ON | INNODB_TRX | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB transactions | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  108. | ON | INNODB_LOCKS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB conflicting locks | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  109. | ON | INNODB_LOCK_WAITS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB which lock is blocking which | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  110. | ON | INNODB_CMP | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | Statistics for the InnoDB compression | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  111. | ON | INNODB_CMP_RESET | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | Statistics for the InnoDB compression; reset cumulated counts | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  112. | ON | INNODB_CMPMEM | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | Statistics for the InnoDB compressed buffer pool | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  113. | ON | INNODB_CMPMEM_RESET | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  114. | ON | INNODB_SYS_TABLES | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_TABLES | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  115. | ON | INNODB_SYS_TABLESTATS | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_TABLESTATS | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  116. | ON | INNODB_SYS_INDEXES | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_INDEXES | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  117. | ON | INNODB_SYS_COLUMNS | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_COLUMNS | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  118. | ON | INNODB_SYS_FIELDS | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_FIELDS | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  119. | ON | INNODB_SYS_FOREIGN | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_FOREIGN | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  120. | ON | INNODB_SYS_FOREIGN_COLS | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | InnoDB SYS_FOREIGN_COLS | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  121. | ON | INNODB_SYS_STATS | INFORMATION SCHEMA | ACTIVE | Percona | 5.5 | GPL | NULL | Stable | XtraDB SYS_STATS table | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  122. | ON | INNODB_TABLE_STATS | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB table statistics in memory | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  123. | ON | INNODB_INDEX_STATS | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB index statistics in memory | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  124. | ON | INNODB_BUFFER_POOL_PAGES | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB buffer pool pages | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  125. | ON | INNODB_BUFFER_POOL_PAGES_INDEX | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB buffer pool index pages | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  126. | ON | INNODB_BUFFER_POOL_PAGES_BLOB | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB buffer pool blob pages | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  127. | ON | XTRADB_ADMIN_COMMAND | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | XtraDB specific command acceptor | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  128. | ON | INNODB_CHANGED_PAGES | INFORMATION SCHEMA | ACTIVE | Percona | 1.0 | GPL | NULL | Stable | InnoDB CHANGED_PAGES table | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  129. | ON | INNODB_BUFFER_PAGE | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB Buffer Page Information | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  130. | ON | INNODB_BUFFER_PAGE_LRU | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB Buffer Page in LRU | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  131. | ON | INNODB_BUFFER_POOL_STATS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.5 | GPL | NULL | Stable | InnoDB Buffer Pool Statistics Information | 5.5.37-MariaDB-35.0 | 50538.0 | NULL |
  132. | ON | ARCHIVE | STORAGE ENGINE | ACTIVE | Brian Aker, MySQL AB | 3.0 | GPL | NULL | Stable | Archive storage engine | 1.0 | 50538.0 | NULL |
  133. | ON | Aria | STORAGE ENGINE | ACTIVE | Monty Program Ab | 1.5 | GPL | NULL | Gamma | Crash-safe tables with MyISAM heritage | 1.5 | 50538.0 | NULL |
  134. | OFF | FEDERATED | STORAGE ENGINE | DISABLED | Patrick Galbraith | 2.0 | GPL | NULL | Beta | FederatedX pluggable storage engine | 2.0 | 50538.0 | NULL |
  135. | ON | BLACKHOLE | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | GPL | NULL | Stable | /dev/null storage engine (anything you write to it disappears) | 1.0 | 50538.0 | NULL |
  136. | ON | QUERY_CACHE_INFO | INFORMATION SCHEMA | ACTIVE | Roland Bouman | 1.0 | BSD | NULL | Alpha | Lists all queries in the query cache. | 1.0 | 50538.0 | NULL |
  137. | OFF | FEEDBACK | INFORMATION SCHEMA | DISABLED | Sergei Golubchik | 1.1 | GPL | NULL | Beta | MariaDB User Feedback Plugin | 1.1 | 50538.0 | NULL |
  138. | ON | partition | STORAGE ENGINE | ACTIVE | Mikael Ronstrom, MySQL AB | 1.0 | GPL | NULL | Stable | Partition Storage Engine Helper | 1.0 | 50538.0 | NULL |
  139. +-------------+--------------------------------+--------------------+---------------+----------------------------+----------------+----
  140. +---------------------------------------------------+----------------------------------------------------------------------------------
  141. | VARIABLE_NAME | VARIABLE_VALUE
  142. +---------------------------------------------------+----------------------------------------------------------------------------------
  143. [10:46:07] [WARNING] console output will be trimmed to last 256 rows due to large table size
  144. | SQL_MAX_JOIN_SIZE | 33554432
  145. | LOWER_CASE_TABLE_NAMES | 0
  146. | INNODB_RECOVERY_STATS | OFF
  147. | UNIQUE_CHECKS | ON
  148. | VERSION_COMPILE_MACHINE | x86_64
  149. | VERSION | 5.5.38-MariaDB-1~wheezy
  150. | QUERY_ALLOC_BLOCK_SIZE | 8192
  151. | SSL_CERT | <blank>
  152. | MIN_EXAMINED_ROW_LIMIT | 0
  153. | INNODB_SYNC_SPIN_LOOPS | 30
  154. | CHARACTER_SET_CLIENT | latin1
  155. | INNODB_BLOCKING_BUFFER_POOL_RESTORE | OFF
  156. | QUERY_CACHE_WLOCK_INVALIDATE | OFF
  157. | INNODB_SHOW_LOCKS_HELD | 10
  158. | THREAD_POOL_MAX_THREADS | 500
  159. | INNODB_ADAPTIVE_HASH_INDEX | ON
  160. | REPLICATE_EVENTS_MARKED_FOR_SKIP | replicate
  161. | INNODB_IBUF_ACCEL_RATE | 100
  162. | SKIP_NAME_RESOLVE | OFF
  163. | ARIA_BLOCK_SIZE | 8192
  164. | LOG_SLOW_QUERIES | OFF
  165. | INNODB_IBUF_MAX_SIZE | 536854528
  166. | FT_BOOLEAN_SYNTAX | + -><()~*:""&|
  167. | INNODB_DATA_HOME_DIR | /mnt/data/guests/mysql264/mysql_log_dir
  168. | INNODB_READ_IO_THREADS | 48
  169. | THREAD_POOL_STALL_LIMIT | 500
  170. | INNODB_MAX_BITMAP_FILE_SIZE | 104857600
  171. | MAX_BINLOG_CACHE_SIZE | 18446744073709547520
  172. | INNODB_BUFFER_POOL_INSTANCES | 1
  173. | TIMED_MUTEXES | OFF
  174. | INNODB_FORCE_RECOVERY | 0
  175. | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000
  176. | INNODB_LOG_FILES_IN_GROUP | 2
  177. | THREAD_POOL_SIZE | 24
  178. | REPLICATE_ANNOTATE_ROW_EVENTS | OFF
  179. | LOG_SLOW_RATE_LIMIT | 1
  180. | HAVE_DYNAMIC_LOADING | YES
  181. | SKIP_NETWORKING | OFF
  182. | SYNC_BINLOG | 0
  183. | INNODB_MAX_CHANGED_PAGES | 1000000
  184. | INNODB_PRINT_ALL_DEADLOCKS | OFF
  185. | INIT_CONNECT | <blank>
  186. | INNODB_OPEN_FILES | 16384
  187. | HAVE_GEOMETRY | YES
  188. | INNODB_IMPORT_TABLE_FROM_XTRABACKUP | 0
  189. | ENGINE_CONDITION_PUSHDOWN | OFF
  190. | INNODB_READ_AHEAD_THRESHOLD | 56
  191. | HAVE_PROFILING | YES
  192. | INNODB_ADAPTIVE_FLUSHING_METHOD | estimate
  193. | TMP_TABLE_SIZE | 2147483648
  194. | KEY_BUFFER_SIZE | 6442450944
  195. | THREAD_HANDLING | one-thread-per-connection
  196. | INNODB_USE_FALLOCATE | OFF
  197. | QUERY_CACHE_TYPE | ON
  198. | SQL_BIG_TABLES | OFF
  199. | INNODB_STATS_METHOD | nulls_equal
  200. | TABLE_DEFINITION_CACHE | 65535
  201. | INNODB_FAST_SHUTDOWN | 1
  202. | MAX_SP_RECURSION_DEPTH | 0
  203. | INNODB_RECOVERY_UPDATE_RELAY_LOG | OFF
  204. | REPORT_PORT | 3306
  205. | ARIA_SORT_BUFFER_SIZE | 134217728
  206. | SSL_CIPHER | <blank>
  207. | ARIA_GROUP_COMMIT | none
  208. | SLAVE_EXEC_MODE | STRICT
  209. | INNODB_STATS_SAMPLE_PAGES | 8
  210. | KEY_CACHE_AGE_THRESHOLD | 300
  211. | LOCAL_INFILE | ON
  212. | SQL_MODE | <blank>
  213. | HAVE_RTREE_KEYS | YES
  214. | INNODB_BUFFER_POOL_RESTORE_AT_STARTUP | 0
  215. | BINLOG_FORMAT | STATEMENT
  216. | BINLOG_CHECKSUM | NONE
  217. | MAX_USER_CONNECTIONS | 24
  218. | INNODB_PAGE_SIZE | 16384
  219. | KEEP_FILES_ON_CREATE | OFF
  220. | EXTRA_MAX_CONNECTIONS | 1
  221. | SYNC_MASTER_INFO | 0
  222. | RELAY_LOG_RECOVERY | OFF
  223. | KEY_CACHE_BLOCK_SIZE | 1024
  224. | MAX_DELAYED_THREADS | 0
  225. | HAVE_CSV | YES
  226. | ARIA_CHECKPOINT_LOG_ACTIVITY | 1048576
  227. | PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768
  228. | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1
  229. | PRELOAD_BUFFER_SIZE | 32768
  230. | MAX_RELAY_LOG_SIZE | 0
  231. | INNODB_LAZY_DROP_TABLE | 0
  232. | ARIA_CHECKPOINT_INTERVAL | 30
  233. | KEY_CACHE_DIVISION_LIMIT | 100
  234. | INNODB_CHECKPOINT_AGE_TARGET | 0
  235. | INNODB_SHOW_VERBOSE_LOCKS | 0
  236. | PORT | 3306
  237. | REPLICATE_DO_TABLE | <blank>
  238. | REPORT_USER | <blank>
  239. | TX_ISOLATION | REPEATABLE-READ
  240. | LOG_BIN_TRUST_FUNCTION_CREATORS | OFF
  241. | LOG_ERROR | <blank>
  242. | ARIA_FORCE_START_AFTER_RECOVERY_FAILURES | 0
  243. | INNODB_BUFFER_POOL_SIZE | 1073741824
  244. | MYISAM_BLOCK_SIZE | 1024
  245. | SOCKET | /var/run/mysqld/mysqld.sock
  246. | MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520
  247. | IGNORE_BUILTIN_INNODB | OFF
  248. | INNODB_BUFFER_POOL_POPULATE | OFF
  249. | NET_WRITE_TIMEOUT | 5
  250. | INNODB_SPIN_WAIT_DELAY | 6
  251. | DATADIR | /var/lib/mysql/
  252. | INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS | 1
  253. | LC_TIME_NAMES | en_US
  254. | DEFAULT_STORAGE_ENGINE | MyISAM
  255. | RELAY_LOG_SPACE_LIMIT | 0
  256. | INNODB_LOCK_WAIT_TIMEOUT | 60
  257. | SSL_CAPATH | <blank>
  258. | INNODB_OLD_BLOCKS_TIME | 0
  259. | INNODB_FILE_FORMAT_MAX | Antelope
  260. | RPL_RECOVERY_RANK | 0
  261. | SSL_CA | <blank>
  262. | HAVE_QUERY_CACHE | YES
  263. | REPLICATE_IGNORE_DB | <blank>
  264. | USERSTAT | ON
  265. | NET_READ_TIMEOUT | 5
  266. | LOCKED_IN_MEMORY | OFF
  267. | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF
  268. | INNODB_LOCKING_FAKE_CHANGES | ON
  269. | READ_RND_BUFFER_SIZE | 1048576
  270. | BIG_TABLES | OFF
  271. | REPLICATE_WILD_IGNORE_TABLE | <blank>
  272. | SSL_KEY | <blank>
  273. | SECURE_AUTH | OFF
  274. | JOIN_CACHE_LEVEL | 2
  275. | SLAVE_SKIP_ERRORS | OFF
  276. | OLD_ALTER_TABLE | OFF
  277. | INNODB_CONCURRENCY_TICKETS | 500
  278. | RELAY_LOG_PURGE | ON
  279. | VERSION_COMPILE_OS | debian-linux-gnu
  280. | INNODB_USE_SYS_STATS_TABLE | OFF
  281. | PROGRESS_REPORT_TIME | 5
  282. | INNODB_USE_STACKTRACE | OFF
  283. | SQL_WARNINGS | OFF
  284. | INNODB_LOG_BUFFER_SIZE | 8388608
  285. | MYISAM_MMAP_SIZE | 18446744073709551615
  286. | INNODB_STATS_UPDATE_NEED_LOCK | 1
  287. | SQL_SAFE_UPDATES | OFF
  288. | INNODB_MAX_PURGE_LAG | 0
  289. | PLUGIN_DIR | /usr/lib/mysql/plugin/
  290. | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232
  291. | TIME_FORMAT | %H:%i:%s
  292. | SLAVE_TYPE_CONVERSIONS | <blank>
  293. | COLLATION_CONNECTION | latin1_swedish_ci
  294. | SQL_NOTES | ON
  295. | KEY_CACHE_SEGMENTS | 0
  296. | OLD_MODE | <blank>
  297. | MAX_TMP_TABLES | 32
  298. | INNODB_USE_SYS_MALLOC | ON
  299. | INNODB_IBUF_ACTIVE_CONTRACT | 1
  300. | SQL_LOG_OFF | OFF
  301. | HAVE_COMPRESS | YES
  302. | HAVE_NDBCLUSTER | NO
  303. | INNODB_USE_ATOMIC_WRITES | OFF
  304. | MAX_ALLOWED_PACKET | 16777216
  305. | INNODB_DICT_SIZE_LIMIT | 0
  306. | SQL_AUTO_IS_NULL | ON
  307. | ARIA_PAGECACHE_AGE_THRESHOLD | 300
  308. | SLAVE_SQL_VERIFY_CHECKSUM | ON
  309. | MYISAM_REPAIR_THREADS | 1
  310. | OLD | OFF
  311. | DEFAULT_WEEK_FORMAT | 0
  312. | LOG_OUTPUT | FILE
  313. | MYISAM_STATS_METHOD | nulls_unequal
  314. | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000
  315. | CHARACTER_SET_DATABASE | latin1
  316. | INNODB_USE_NATIVE_AIO | ON
  317. | INNODB_FLUSH_METHOD | <blank>
  318. | INNODB_DOUBLEWRITE_FILE | <blank>
  319. | SYNC_RELAY_LOG | 0
  320. | TIME_ZONE | SYSTEM
  321. | STORAGE_ENGINE | MyISAM
  322. | INNODB_TRACK_CHANGED_PAGES | OFF
  323. | HAVE_SSL | DISABLED
  324. | DEADLOCK_SEARCH_DEPTH_SHORT | 4
  325. | INTERACTIVE_TIMEOUT | 300
  326. | FT_MIN_WORD_LEN | 2
  327. | PID_FILE | /var/run/mysqld/mysqld.pid
  328. | DEBUG_NO_THREAD_ALARM | OFF
  329. | LOG_SLAVE_UPDATES | OFF
  330. | SERVER_ID | 0
  331. | DEADLOCK_TIMEOUT_LONG | 50000000
  332. | ARIA_MAX_SORT_FILE_SIZE | 9223372036853727232
  333. | COLLATION_DATABASE | latin1_swedish_ci
  334. | SKIP_EXTERNAL_LOCKING | ON
  335. | INNODB_STATS_AUTO_UPDATE | 1
  336. | SYNC_RELAY_LOG_INFO | 0
  337. | INNODB_FILE_PER_TABLE | ON
  338. | ARIA_SYNC_LOG_DIR | NEWFILE
  339. | INNODB_LOG_GROUP_HOME_DIR | /mnt/data/guests/mysql264/mysql_log_dir
  340. | MAX_ERROR_COUNT | 64
  341. | INNODB_LARGE_PREFIX | OFF
  342. | INNODB_STATS_ON_METADATA | OFF
  343. | LOG_SLOW_FILTER | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  344. | ARIA_GROUP_COMMIT_INTERVAL | 0
  345. | BINLOG_ANNOTATE_ROW_EVENTS | OFF
  346. | PROFILING_HISTORY_SIZE | 15
  347. | SYNC_FRM | ON
  348. | INNODB_CHANGE_BUFFERING | all
  349. | INNODB_KILL_IDLE_TRANSACTION | 0
  350. | PERFORMANCE_SCHEMA | ON
  351. | INNODB_ADAPTIVE_FLUSHING | ON
  352. | BINLOG_OPTIMIZE_THREAD_SCHEDULING | ON
  353. | STORED_PROGRAM_CACHE | 256
  354. | MAX_WRITE_LOCK_COUNT | 4294967295
  355. | EXTRA_PORT | 0
  356. | SQL_SELECT_LIMIT | 18446744073709551615
  357. | INNODB_FILE_FORMAT_CHECK | ON
  358. | ARIA_STATS_METHOD | nulls_unequal
  359. | TMPDIR | /tmp
  360. | INNODB_FLUSH_NEIGHBOR_PAGES | area
  361. | THREAD_CACHE_SIZE | 1024
  362. | RELAY_LOG | <blank>
  363. | MASTER_VERIFY_CHECKSUM | OFF
  364. | PLUGIN_MATURITY | unknown
  365. | INNODB_MERGE_SORT_BLOCK_SIZE | 1048576
  366. | INNODB_FORCE_LOAD_CORRUPTED | OFF
  367. | PROFILING | OFF
  368. | INNODB_MAX_DIRTY_PAGES_PCT | 75
  369. | ARIA_PAGECACHE_BUFFER_SIZE | 268435456
  370. | IGNORE_DB_DIRS | <blank>
  371. | EXPENSIVE_SUBQUERY_LIMIT | 100
  372. | THREAD_CONCURRENCY | 10
  373. | GENERAL_LOG_FILE | mysql264.log
  374. | INNODB_OLD_BLOCKS_PCT | 37
  375. | SYSTEM_TIME_ZONE | UTC
  376. | INNODB_PURGE_THREADS | 1
  377. | DEADLOCK_SEARCH_DEPTH_LONG | 15
  378. | MRR_BUFFER_SIZE | 262144
  379. | DEADLOCK_TIMEOUT_SHORT | 10000
  380. | EXPIRE_LOGS_DAYS | 10
  381. | DIV_PRECISION_INCREMENT | 4
  382. | ARIA_RECOVER | NORMAL
  383. | DATETIME_FORMAT | %Y-%m-%d %H:%i:%s
  384. | FOREIGN_KEY_CHECKS | ON
  385. | SLAVE_NET_TIMEOUT | 3600
  386. | ARIA_LOG_PURGE_TYPE | immediate
  387. | QUERY_CACHE_STRIP_COMMENTS | OFF
  388. | SLAVE_LOAD_TMPDIR | /tmp
  389. | SQL_BUFFER_RESULT | OFF
  390. | INNODB_COMMIT_CONCURRENCY | 48
  391. | INNODB_DOUBLEWRITE | ON
  392. | INNODB_MIRRORED_LOG_GROUPS | 1
  393. | INNODB_TABLE_LOCKS | ON
  394. | INNODB_PURGE_BATCH_SIZE | 20
  395. | INNODB_ADDITIONAL_MEM_POOL_SIZE | 8388608
  396. | THREAD_STACK | 262144
  397. | INNODB_CORRUPT_TABLE_ACTION | assert
  398. | INNODB_SUPPORT_XA | ON
  399. | SLAVE_TRANSACTION_RETRIES | 10
  400. +---------------------------------------------------+------------------------------------------------------------------------------
  401.  
  402. Database: information_schema
  403. Table: ENGINES
  404. [11 entries]
  405. +------+--------------------+----------------------------------------------------------------------------+---------+------------+--------------+
  406. | XA | ENGINE | COMMENT | SUPPORT | SAVEPOINTS | TRANSACTIONS |
  407. +------+--------------------+----------------------------------------------------------------------------+---------+------------+--------------+
  408. | NO | MEMORY | Hash based, stored in memory, useful for temporary tables | YES | NO | NO |
  409. | NO | MRG_MYISAM | Collection of identical MyISAM tables | YES | NO | NO |
  410. | NO | MyISAM | MyISAM storage engine | DEFAULT | NO | NO |
  411. | NO | BLACKHOLE | /dev/null storage engine (anything you write to it disappears) | YES | NO | NO |
  412. | YES | InnoDB | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
  413. | NO | PERFORMANCE_SCHEMA | Performance Schema | YES | NO | NO |
  414. | NO | ARCHIVE | Archive storage engine | YES | NO | NO |
  415. | NULL | SPHINX | Sphinx storage engine | NO | NULL | NULL |
  416. | NULL | FEDERATED | FederatedX pluggable storage engine | NO | NULL | NULL |
  417. | NO | CSV | CSV storage engine | YES | NO | NO |
  418. | NO | Aria | Crash-safe tables with MyISAM heritage | YES | NO | NO |
  419. +------+--------------------+----------------------------------------------------------------------------+---------+------------+------
  420.  
  421. +---------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  422. | VARIABLE_NAME | VARIABLE_VALUE
  423. +---------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  424. [11:33:08] [WARNING] console output will be trimmed to last 256 rows due to large table size
  425. | INNODB_SYNC_SPIN_LOOPS | 30
  426. | CHARACTER_SET_CLIENT | latin1
  427. | INNODB_BLOCKING_BUFFER_POOL_RESTORE | OFF
  428. | QUERY_CACHE_WLOCK_INVALIDATE | OFF
  429. | INNODB_SHOW_LOCKS_HELD | 10
  430. | THREAD_POOL_MAX_THREADS | 500
  431. | INNODB_ADAPTIVE_HASH_INDEX | ON
  432. | REPLICATE_EVENTS_MARKED_FOR_SKIP | replicate
  433. | INNODB_IBUF_ACCEL_RATE | 100
  434. | SKIP_NAME_RESOLVE | OFF
  435. | ARIA_BLOCK_SIZE | 8192
  436. | LOG_SLOW_QUERIES | OFF
  437. | INNODB_IBUF_MAX_SIZE | 536854528
  438. | FT_BOOLEAN_SYNTAX | + -><()~*:""&|
  439. | INNODB_DATA_HOME_DIR | /mnt/data/guests/mysql264/mysql_log_dir
  440. | EXTERNAL_USER | <blank>
  441. | INNODB_READ_IO_THREADS | 48
  442. | THREAD_POOL_STALL_LIMIT | 500
  443. | INNODB_MAX_BITMAP_FILE_SIZE | 104857600
  444. | MAX_BINLOG_CACHE_SIZE | 18446744073709547520
  445. | INNODB_BUFFER_POOL_INSTANCES | 1
  446. | TIMED_MUTEXES | OFF
  447. | INNODB_FORCE_RECOVERY | 0
  448. | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000
  449. | INNODB_LOG_FILES_IN_GROUP | 2
  450. | THREAD_POOL_SIZE | 24
  451. | REPLICATE_ANNOTATE_ROW_EVENTS | OFF
  452. | LOG_SLOW_RATE_LIMIT | 1
  453. | HAVE_DYNAMIC_LOADING | YES
  454. | SKIP_NETWORKING | OFF
  455. | SYNC_BINLOG | 0
  456. | INNODB_MAX_CHANGED_PAGES | 1000000
  457. | INNODB_PRINT_ALL_DEADLOCKS | OFF
  458. | INIT_CONNECT | <blank>
  459. | INNODB_OPEN_FILES | 16384
  460. | HAVE_GEOMETRY | YES
  461. | INNODB_IMPORT_TABLE_FROM_XTRABACKUP | 0
  462. | ENGINE_CONDITION_PUSHDOWN | OFF
  463. | INNODB_READ_AHEAD_THRESHOLD | 56
  464. | HAVE_PROFILING | YES
  465. | INNODB_ADAPTIVE_FLUSHING_METHOD | estimate
  466. | TMP_TABLE_SIZE | 2147483648
  467. | KEY_BUFFER_SIZE | 6442450944
  468. | THREAD_HANDLING | one-thread-per-connection
  469. | INNODB_USE_FALLOCATE | OFF
  470. | QUERY_CACHE_TYPE | ON
  471. | PSEUDO_SLAVE_MODE | OFF
  472. | SQL_BIG_TABLES | OFF
  473. | INNODB_STATS_METHOD | nulls_equal
  474. | TABLE_DEFINITION_CACHE | 65535
  475. | INNODB_FAST_SHUTDOWN | 1
  476. | MAX_SP_RECURSION_DEPTH | 0
  477. | INNODB_RECOVERY_UPDATE_RELAY_LOG | OFF
  478. | REPORT_PORT | 3306
  479. | ARIA_SORT_BUFFER_SIZE | 134217728
  480. | SSL_CIPHER | <blank>
  481. | ARIA_GROUP_COMMIT | none
  482. | SLAVE_EXEC_MODE | STRICT
  483. | INNODB_STATS_SAMPLE_PAGES | 8
  484. | KEY_CACHE_AGE_THRESHOLD | 300
  485. | LOCAL_INFILE | ON
  486. | SQL_MODE | <blank>
  487. | HAVE_RTREE_KEYS | YES
  488. | IN_TRANSACTION | 0
  489. | INNODB_BUFFER_POOL_RESTORE_AT_STARTUP | 0
  490. | BINLOG_FORMAT | STATEMENT
  491. | BINLOG_CHECKSUM | NONE
  492. | MAX_USER_CONNECTIONS | 24
  493. | INNODB_PAGE_SIZE | 16384
  494. | KEEP_FILES_ON_CREATE | OFF
  495. | EXTRA_MAX_CONNECTIONS | 1
  496. | SYNC_MASTER_INFO | 0
  497. | RELAY_LOG_RECOVERY | OFF
  498. | KEY_CACHE_BLOCK_SIZE | 1024
  499. | MAX_DELAYED_THREADS | 0
  500. | HAVE_CSV | YES
  501. | ARIA_CHECKPOINT_LOG_ACTIVITY | 1048576
  502. | PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768
  503. | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1
  504. | PRELOAD_BUFFER_SIZE | 32768
  505. | MAX_RELAY_LOG_SIZE | 0
  506. | INNODB_LAZY_DROP_TABLE | 0
  507. | ARIA_CHECKPOINT_INTERVAL | 30
  508. | KEY_CACHE_DIVISION_LIMIT | 100
  509. | INNODB_CHECKPOINT_AGE_TARGET | 0
  510. | INNODB_SHOW_VERBOSE_LOCKS | 0
  511. | PORT | 3306
  512. | REPLICATE_DO_TABLE | <blank>
  513. | REPORT_USER | <blank>
  514. | TX_ISOLATION | REPEATABLE-READ
  515. | LOG_BIN_TRUST_FUNCTION_CREATORS | OFF
  516. | LOG_ERROR | <blank>
  517. | ARIA_FORCE_START_AFTER_RECOVERY_FAILURES | 0
  518. | INNODB_BUFFER_POOL_SIZE | 1073741824
  519. | MYISAM_BLOCK_SIZE | 1024
  520. | SOCKET | /var/run/mysqld/mysqld.sock
  521. | MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520
  522. | IGNORE_BUILTIN_INNODB | OFF
  523. | INNODB_BUFFER_POOL_POPULATE | OFF
  524. | NET_WRITE_TIMEOUT | 5
  525. | INNODB_SPIN_WAIT_DELAY | 6
  526. | DATADIR | /var/lib/mysql/
  527. | INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS | 1
  528. | LC_TIME_NAMES | en_US
  529. | DEFAULT_STORAGE_ENGINE | MyISAM
  530. | RELAY_LOG_SPACE_LIMIT | 0
  531. | INNODB_LOCK_WAIT_TIMEOUT | 60
  532. | SSL_CAPATH | <blank>
  533. | INNODB_OLD_BLOCKS_TIME | 0
  534. | INNODB_FILE_FORMAT_MAX | Antelope
  535. | RPL_RECOVERY_RANK | 0
  536. | SSL_CA | <blank>
  537. | HAVE_QUERY_CACHE | YES
  538. | REPLICATE_IGNORE_DB | <blank>
  539. | USERSTAT | ON
  540. | NET_READ_TIMEOUT | 5
  541. | LOCKED_IN_MEMORY | OFF
  542. | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF
  543. | INNODB_LOCKING_FAKE_CHANGES | ON
  544. | READ_RND_BUFFER_SIZE | 1048576
  545. | BIG_TABLES | OFF
  546. | REPLICATE_WILD_IGNORE_TABLE | <blank>
  547. | SSL_KEY | <blank>
  548. | SECURE_AUTH | OFF
  549. | JOIN_CACHE_LEVEL | 2
  550. | LAST_INSERT_ID | 0
  551. | SLAVE_SKIP_ERRORS | OFF
  552. | OLD_ALTER_TABLE | OFF
  553. | INSERT_ID | 0
  554. | INNODB_CONCURRENCY_TICKETS | 500
  555. | RELAY_LOG_PURGE | ON
  556. | VERSION_COMPILE_OS | debian-linux-gnu
  557. | INNODB_USE_SYS_STATS_TABLE | OFF
  558. | PROGRESS_REPORT_TIME | 5
  559. | INNODB_USE_STACKTRACE | OFF
  560. | SQL_WARNINGS | OFF
  561. | INNODB_LOG_BUFFER_SIZE | 8388608
  562. | MYISAM_MMAP_SIZE | 18446744073709551615
  563. | INNODB_STATS_UPDATE_NEED_LOCK | 1
  564. | SQL_SAFE_UPDATES | OFF
  565. | INNODB_MAX_PURGE_LAG | 0
  566. | PLUGIN_DIR | /usr/lib/mysql/plugin/
  567. | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232
  568. | TIME_FORMAT | %H:%i:%s
  569. | SLAVE_TYPE_CONVERSIONS | <blank>
  570. | COLLATION_CONNECTION | latin1_swedish_ci
  571. | SQL_NOTES | ON
  572. | KEY_CACHE_SEGMENTS | 0
  573. | OLD_MODE | <blank>
  574. | MAX_TMP_TABLES | 32
  575. | IDENTITY | 0
  576. | INNODB_USE_SYS_MALLOC | ON
  577. | INNODB_IBUF_ACTIVE_CONTRACT | 1
  578. | SQL_LOG_OFF | OFF
  579. | HAVE_COMPRESS | YES
  580. | HAVE_NDBCLUSTER | NO
  581. | INNODB_USE_ATOMIC_WRITES | OFF
  582. | MAX_ALLOWED_PACKET | 16777216
  583. | INNODB_DICT_SIZE_LIMIT | 0
  584. | SQL_AUTO_IS_NULL | ON
  585. | ARIA_PAGECACHE_AGE_THRESHOLD | 300
  586. | SLAVE_SQL_VERIFY_CHECKSUM | ON
  587. | MYISAM_REPAIR_THREADS | 1
  588. | OLD | OFF
  589. | DEFAULT_WEEK_FORMAT | 0
  590. | WARNING_COUNT | 0
  591. | LOG_OUTPUT | FILE
  592. | MYISAM_STATS_METHOD | nulls_unequal
  593. | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | 50000
  594. | CHARACTER_SET_DATABASE | latin1
  595. | INNODB_USE_NATIVE_AIO | ON
  596. | INNODB_FLUSH_METHOD | <blank>
  597. | INNODB_DOUBLEWRITE_FILE | <blank>
  598. | SYNC_RELAY_LOG | 0
  599. | TIME_ZONE | SYSTEM
  600. | STORAGE_ENGINE | MyISAM
  601. | INNODB_TRACK_CHANGED_PAGES | OFF
  602. | HAVE_SSL | DISABLED
  603. | DEADLOCK_SEARCH_DEPTH_SHORT | 4
  604. | INTERACTIVE_TIMEOUT | 300
  605. | FT_MIN_WORD_LEN | 2
  606. | PID_FILE | /var/run/mysqld/mysqld.pid
  607. | DEBUG_NO_THREAD_ALARM | OFF
  608. | LOG_SLAVE_UPDATES | OFF
  609. | SERVER_ID | 0
  610. | DEADLOCK_TIMEOUT_LONG | 50000000
  611. | ARIA_MAX_SORT_FILE_SIZE | 9223372036853727232
  612. | COLLATION_DATABASE | latin1_swedish_ci
  613. | SKIP_EXTERNAL_LOCKING | ON
  614. | INNODB_STATS_AUTO_UPDATE | 1
  615. | SYNC_RELAY_LOG_INFO | 0
  616. | INNODB_FILE_PER_TABLE | ON
  617. | ARIA_SYNC_LOG_DIR | NEWFILE
  618. | INNODB_LOG_GROUP_HOME_DIR | /mnt/data/guests/mysql264/mysql_log_dir
  619. | MAX_ERROR_COUNT | 64
  620. | INNODB_LARGE_PREFIX | OFF
  621. | INNODB_STATS_ON_METADATA | OFF
  622. | LOG_SLOW_FILTER | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  623. | ARIA_GROUP_COMMIT_INTERVAL | 0
  624. | BINLOG_ANNOTATE_ROW_EVENTS | OFF
  625. | PROFILING_HISTORY_SIZE | 15
  626. | SYNC_FRM | ON
  627. | INNODB_CHANGE_BUFFERING | all
  628. | INNODB_KILL_IDLE_TRANSACTION | 0
  629. | PERFORMANCE_SCHEMA | ON
  630. | INNODB_ADAPTIVE_FLUSHING | ON
  631. | BINLOG_OPTIMIZE_THREAD_SCHEDULING | ON
  632. | STORED_PROGRAM_CACHE | 256
  633. | MAX_WRITE_LOCK_COUNT | 4294967295
  634. | EXTRA_PORT | 0
  635. | SQL_SELECT_LIMIT | 18446744073709551615
  636. | INNODB_FILE_FORMAT_CHECK | ON
  637. | ARIA_STATS_METHOD | nulls_unequal
  638. | TMPDIR | /tmp
  639. | INNODB_FLUSH_NEIGHBOR_PAGES | area
  640. | THREAD_CACHE_SIZE | 1024
  641. | RELAY_LOG | <blank>
  642. | MASTER_VERIFY_CHECKSUM | OFF
  643. | PLUGIN_MATURITY | unknown
  644. | RAND_SEED2 | 0
  645. | INNODB_MERGE_SORT_BLOCK_SIZE | 1048576
  646. | INNODB_FORCE_LOAD_CORRUPTED | OFF
  647. | PROFILING | OFF
  648. | INNODB_MAX_DIRTY_PAGES_PCT | 75
  649. | ARIA_PAGECACHE_BUFFER_SIZE | 268435456
  650. | IGNORE_DB_DIRS | <blank>
  651. | EXPENSIVE_SUBQUERY_LIMIT | 100
  652. | THREAD_CONCURRENCY | 10
  653. | GENERAL_LOG_FILE | mysql264.log
  654. | INNODB_OLD_BLOCKS_PCT | 37
  655. | SYSTEM_TIME_ZONE | UTC
  656. | INNODB_PURGE_THREADS | 1
  657. | DEADLOCK_SEARCH_DEPTH_LONG | 15
  658. | ERROR_COUNT | 0
  659. | MRR_BUFFER_SIZE | 262144
  660. | DEADLOCK_TIMEOUT_SHORT | 10000
  661. | EXPIRE_LOGS_DAYS | 10
  662. | DIV_PRECISION_INCREMENT | 4
  663. | ARIA_RECOVER | NORMAL
  664. | DATETIME_FORMAT | %Y-%m-%d %H:%i:%s
  665. | FOREIGN_KEY_CHECKS | ON
  666. | SLAVE_NET_TIMEOUT | 3600
  667. | ARIA_LOG_PURGE_TYPE | immediate
  668. | QUERY_CACHE_STRIP_COMMENTS | OFF
  669. | SLAVE_LOAD_TMPDIR | /tmp
  670. | SQL_BUFFER_RESULT | OFF
  671. | INNODB_COMMIT_CONCURRENCY | 48
  672. | INNODB_DOUBLEWRITE | ON
  673. | INNODB_MIRRORED_LOG_GROUPS | 1
  674. | INNODB_TABLE_LOCKS | ON
  675. | INNODB_PURGE_BATCH_SIZE | 20
  676. | INNODB_ADDITIONAL_MEM_POOL_SIZE | 8388608
  677. | THREAD_STACK | 262144
  678. | INNODB_CORRUPT_TABLE_ACTION | assert
  679. | INNODB_SUPPORT_XA | ON
  680. | SLAVE_TRANSACTION_RETRIES | 10
  681. +---------------------------------------------------+----------------------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!