API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 7th, 2016
86
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 62.28 KB | None | 0 0
raw download clone embed print report
  1. [root@kohadb ~]# cd /var/lib/mysql/*
  2. [root@kohadb ~]# du -sh /var/lib/mysql/*
  3. 4,0K /var/lib/mysql/403
  4. 8,7M /var/lib/mysql/biblio-utf8
  5. 6,9G /var/lib/mysql/ibdata1
  6. 50M /var/lib/mysql/ib_logfile0
  7. 50M /var/lib/mysql/ib_logfile1
  8. 2,1M /var/lib/mysql/koha_biblioudd
  9. 2,2M /var/lib/mysql/koha_udd
  10. 5,8M /var/lib/mysql/mysql
  11. 0 /var/lib/mysql/mysql.sock
  12. 4,0K /var/lib/mysql/test
  13. [root@kohadb ~]# cat /etc/my.cnf |grep -v "#"
  14. [mysqld]
  15. datadir=/var/lib/mysql
  16. socket=/var/lib/mysql/mysql.sock
  17. user=mysql
  18. key_buffer_size=500M
  19. query_cache_limit=16M
  20. query_cache_size=16M
  21. thread_cache_size=8
  22. table_open_cache=256
  23. innodb_buffer_pool_size=6G
  24. innodb_log_buffer_size=32M
  25. innodb_log_file_size=50M
  26. max_allowed_packet=64M
  27. max_connections=500
  28. max_user_connections=500
  29. interactive_timeout=180
  30. wait_timeout=180
  31. join_buffer_size=32M
  32. tmp_table_size=8M
  33. max_heap_table_size=8M
  34.  
  35.  
  36. init-connect = 'SET NAMES utf8'
  37. character-set-server=utf8
  38. collation-server=utf8_unicode_ci
  39. character_set_client=utf8
  40.  
  41. slow_query_log=1
  42. slow_query_log_file=/var/log/mysql-log-slow-queries.log
  43. long_query_time=1
  44. log_queries_not_using_indexes=1
  45.  
  46. symbolic-links=0
  47.  
  48. [mysqld_safe]
  49. default-character-set = utf8
  50. log-error=/var/log/mysqld.log
  51. pid-file=/var/run/mysqld/mysqld.pid
  52.  
  53. [mysql]
  54. default-character-set = utf8
  55.  
  56. [client]
  57. default-character-set = utf8
  58. [root@kohadb ~]# cat /etc/my.cnf |grep -v "#"
  59. [mysqld]
  60. datadir=/var/lib/mysql
  61. socket=/var/lib/mysql/mysql.sock
  62. user=mysql
  63. key_buffer_size=500M
  64. query_cache_limit=16M
  65. query_cache_size=16M
  66. thread_cache_size=8
  67. table_open_cache=256
  68. innodb_buffer_pool_size=6G
  69. innodb_log_buffer_size=32M
  70. innodb_log_file_size=50M
  71. max_allowed_packet=64M
  72. max_connections=500
  73. max_user_connections=500
  74. interactive_timeout=180
  75. wait_timeout=180
  76. join_buffer_size=32M
  77. tmp_table_size=8M
  78. max_heap_table_size=8M
  79.  
  80.  
  81. init-connect = 'SET NAMES utf8'
  82. character-set-server=utf8
  83. collation-server=utf8_unicode_ci
  84. character_set_client=utf8
  85.  
  86. slow_query_log=1
  87. slow_query_log_file=/var/log/mysql-log-slow-queries.log
  88. long_query_time=1
  89. log_queries_not_using_indexes=1
  90.  
  91. symbolic-links=0
  92.  
  93. [mysqld_safe]
  94. default-character-set = utf8
  95. log-error=/var/log/mysqld.log
  96. pid-file=/var/run/mysqld/mysqld.pid
  97.  
  98. [mysql]
  99. default-character-set = utf8
  100.  
  101. [client]
  102. default-character-set = utf8
  103.  
  104. [root@kohadb ~]# perl mysqltuner.pl
  105. Please enter your MySQL administrative login: root
  106. Please enter your MySQL administrative password: >> MySQLTuner 1.6.2 - Major Hayden <major@mhtx.net>
  107. >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
  108. >> Run with '--help' for additional options and output filtering
  109. [--] Skipped version check for MySQLTuner script
  110. [OK] Currently running supported MySQL version 5.1.73-log
  111. [OK] Operating on 64-bit architecture
  112.  
  113. -------- Storage Engine Statistics -------------------------------------------
  114. [--] Status: +CSV +InnoDB +MRG_MYISAM
  115. [--] Data in MyISAM tables: 4K (Tables: 2)
  116. [--] Data in InnoDB tables: 3G (Tables: 344)
  117. [!!] Total fragmented tables: 344
  118.  
  119. -------- Security Recommendations -------------------------------------------
  120. [!!] User '@kohadb' is an anonymous account.
  121. [!!] User '@localhost' is an anonymous account.
  122. [!!] User '@kohadb' has no password set.
  123. [!!] User '@localhost' has no password set.
  124. [!!] User 'root@127.0.0.1' has no password set.
  125. [!!] User 'root@kohadb' has no password set.
  126. [!!] User '@kohadb' has user name as password.
  127. [!!] User '@localhost' has user name as password.
  128. [!!] There is no basic password file list!
  129.  
  130. -------- CVE Security Recommendations -------------------------------------------
  131. [--] Skipped due to --cvefile option undefined
  132.  
  133. -------- Performance Metrics -------------------------------------------------
  134. [--] Up for: 18h 24m 39s (2M q [43.450 qps], 2K conn, TX: 5B, RX: 391M)
  135. [--] Reads / Writes: 97% / 3%
  136. [--] Binary logging is disabled
  137. [--] Total buffers: 6.5G global + 34.6M per thread (500 max threads)
  138. [!!] Maximum reached memory usage: 7.0G (91.28% of installed RAM)
  139. [!!] Maximum possible memory usage: 23.5G (305.06% of installed RAM)
  140. [OK] Slow queries: 0% (3K/2M)
  141. [OK] Highest usage of available connections: 2% (14/500)
  142. [OK] Aborted connections: 0.14% (3/2069)
  143. [OK] Query cache efficiency: 92.9% (2M cached / 2M selects)
  144. [!!] Query cache prunes per day: 140608
  145. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 54K sorts)
  146. [!!] Temporary tables created on disk: 84% (4K on disk / 5K total)
  147. [OK] Thread cache hit rate: 98% (31 created / 2K connections)
  148. [!!] Table cache hit rate: 7% (256 open / 3K opened)
  149. [OK] Open file limit used: 0% (3/2K)
  150. [OK] Table locks acquired immediately: 100% (302K immediate / 302K locks)
  151.  
  152. -------- MyISAM Metrics -----------------------------------------------------
  153. [!!] Key buffer used: 18.3% (95M used / 524M cache)
  154. [OK] Key buffer size / total MyISAM indexes: 500.0M/2.4M
  155. [OK] Read Key buffer hit rate: 99.9% (25K cached / 15 reads)
  156. [OK] Write Key buffer hit rate: 100.0% (7K cached / 0 writes)
  157.  
  158. -------- InnoDB Metrics -----------------------------------------------------
  159. [--] InnoDB is enabled.
  160. [OK] InnoDB buffer pool / data size: 6.0G/3.9G
  161. [!!] InnoDB Used buffer: 42.90% (168697 used/ 393216 total)
  162. [OK] InnoDB Read buffer efficiency: 99.96% (136682060 hits/ 136735441 total)
  163. [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
  164. [OK] InnoDB log waits: 0.00% (0 waits / 5737 writes)
  165.  
  166. -------- AriaDB Metrics -----------------------------------------------------
  167. [--] AriaDB is disabled.
  168.  
  169. -------- Replication Metrics -------------------------------------------------
  170. [--] No replication slave(s) for this server.
  171. [--] This is a standalone server..
  172.  
  173. -------- Recommendations -----------------------------------------------------
  174. General recommendations:
  175. Run OPTIMIZE TABLE to defragment tables for better performance
  176. Remove Anonymous User accounts - there are 2 anonymous accounts.
  177. Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
  178. Set up a Secure Password for user@host ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); )
  179. MySQL started within last 24 hours - recommendations may be inaccurate
  180. Reduce your overall MySQL memory footprint for system stability
  181. When making adjustments, make tmp_table_size/max_heap_table_size equal
  182. Reduce your SELECT DISTINCT queries which have no LIMIT clause
  183. Increase table_open_cache gradually to avoid file descriptor limits
  184. Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
  185. Beware that open_files_limit (2500) variable
  186. should be greater than table_open_cache ( 256)
  187. Variables to adjust:
  188. *** MySQL's maximum memory usage is dangerously high ***
  189. *** Add RAM before increasing MySQL buffer variables ***
  190. query_cache_size (> 16M)
  191. tmp_table_size (> 8M)
  192. max_heap_table_size (> 8M)
  193. table_open_cache (> 256)
  194. [root@kohadb ~]#
  195. mysql> show table status;
  196. +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------------+
  197. | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
  198. +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------------+
  199. | accountlines | InnoDB | 10 | Compact | 9692 | 163 | 1589248 | 0 | 704512 | 3088056320 | 9972 | 2016-04-04 09:25:59 | NULL | NULL | utf8_unicode_ci | NULL | | |
  200. | accountoffsets | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:25:59 | NULL | NULL | utf8_unicode_ci | NULL | | |
  201. | action_logs | InnoDB | 10 | Compact | 2132672 | 186 | 398311424 | 0 | 567803904 | 3088056320 | 2026089 | 2016-04-04 09:30:28 | NULL | NULL | utf8_unicode_ci | NULL | | |
  202. | additional_field_values | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  203. | additional_fields | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  204. | alert | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  205. | aqbasket | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 81920 | 3088056320 | 6 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  206. | aqbasketgroups | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  207. | aqbasketusers | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  208. | aqbooksellers | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 49152 | 3088056320 | 5 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  209. | aqbudgetborrowers | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  210. | aqbudgetperiods | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  211. | aqbudgets | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 81920 | 3088056320 | 9 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  212. | aqbudgets_planning | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  213. | aqcontacts | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 3088056320 | 5 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  214. | aqcontract | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  215. | aqinvoices | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 3088056320 | 6 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  216. | aqorder_users | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  217. | aqorders | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 114688 | 3088056320 | 9 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  218. | aqorders_items | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  219. | aqorders_transfers | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  220. | audio_alerts | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 3088056320 | 4 | 2016-04-04 09:30:30 | NULL | NULL | utf8_unicode_ci | NULL | | |
  221. | auth_header | InnoDB | 10 | Compact | 54991 | 1327 | 72990720 | 0 | 1589248 | 3088056320 | 54205 | 2016-04-04 09:30:40 | NULL | NULL | utf8_unicode_ci | NULL | | |
  222. | auth_subfield_structure | InnoDB | 10 | Compact | 8002 | 198 | 1589248 | 0 | 212992 | 3088056320 | NULL | 2016-04-04 09:30:40 | NULL | NULL | utf8_unicode_ci | NULL | | |
  223. | auth_tag_structure | InnoDB | 10 | Compact | 767 | 170 | 131072 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:30:40 | NULL | NULL | utf8_unicode_ci | NULL | | |
  224. | auth_types | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:30:41 | NULL | NULL | utf8_unicode_ci | NULL | | |
  225. | authorised_values | InnoDB | 10 | Compact | 82 | 799 | 65536 | 0 | 49152 | 3088056320 | 438 | 2016-04-04 09:30:41 | NULL | NULL | utf8_unicode_ci | NULL | | |
  226. | authorised_values_branches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:30:41 | NULL | NULL | utf8_unicode_ci | NULL | | |
  227. | biblio | InnoDB | 10 | Compact | 48875 | 182 | 8929280 | 0 | 524288 | 3088056320 | 52233 | 2016-04-04 09:30:43 | NULL | NULL | utf8_unicode_ci | NULL | | |
  228. | biblio_framework | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:30:43 | NULL | NULL | utf8_unicode_ci | NULL | | |
  229. | biblioimages | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:30:43 | NULL | NULL | utf8_unicode_ci | NULL | | |
  230. | biblioitems | InnoDB | 10 | Compact | 50846 | 5150 | 261881856 | 0 | 13205504 | 3088056320 | 52233 | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  231. | borrower_attribute_types | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  232. | borrower_attribute_types_branches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  233. | borrower_attributes | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  234. | borrower_debarments | InnoDB | 10 | Compact | 6868 | 69 | 475136 | 0 | 147456 | 3088056320 | 58063 | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  235. | borrower_files | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:31:08 | NULL | NULL | utf8_unicode_ci | NULL | | |
  236. | borrower_message_preferences | InnoDB | 10 | Compact | 42156 | 62 | 2637824 | 0 | 4751360 | 3088056320 | 69311 | 2016-04-04 09:31:10 | NULL | NULL | utf8_unicode_ci | NULL | | |
  237. | borrower_message_transport_preferences | InnoDB | 10 | Compact | 86 | 190 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:10 | NULL | NULL | utf8_unicode_ci | NULL | | |
  238. | borrower_modifications | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:10 | NULL | NULL | utf8_unicode_ci | NULL | | |
  239. | borrower_sync | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:31:10 | NULL | NULL | utf8_unicode_ci | NULL | | |
  240. | borrowers | InnoDB | 10 | Compact | 29491 | 302 | 8929280 | 0 | 10469376 | 3088056320 | 218907 | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  241. | branch_borrower_circ_rules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  242. | branch_item_rules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  243. | branch_transfer_limits | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  244. | branchcategories | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  245. | branches | InnoDB | 10 | Compact | 14 | 1170 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  246. | branchrelations | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  247. | branchtransfers | InnoDB | 10 | Compact | 2462 | 79 | 196608 | 0 | 262144 | 3088056320 | NULL | 2016-04-04 09:31:14 | NULL | NULL | utf8_unicode_ci | NULL | | |
  248. | browser | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  249. | categories | InnoDB | 10 | Compact | 11 | 1489 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  250. | categories_branches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  251. | cities | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  252. | class_sort_rules | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  253. | class_sources | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 49152 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  254. | collections | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  255. | collections_tracking | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  256. | columns_settings | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  257. | course_instructors | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  258. | course_items | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  259. | course_reserves | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  260. | courses | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  261. | creator_batches | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 49152 | 3088056320 | 9 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  262. | creator_images | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  263. | creator_layouts | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 3088056320 | 21 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  264. | creator_templates | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 16384 | 3088056320 | 24 | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  265. | currency | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  266. | default_borrower_circ_rules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  267. | default_branch_circ_rules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:15 | NULL | NULL | utf8_unicode_ci | NULL | | |
  268. | default_branch_item_rules | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:16 | NULL | NULL | utf8_unicode_ci | NULL | | |
  269. | default_circ_rules | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:16 | NULL | NULL | utf8_unicode_ci | NULL | | |
  270. | deletedbiblio | InnoDB | 10 | Compact | 309 | 424 | 131072 | 0 | 16384 | 3088056320 | 50812 | 2016-04-04 09:31:16 | NULL | NULL | utf8_unicode_ci | NULL | | |
  271. | deletedbiblioitems | InnoDB | 10 | Compact | 313 | 8427 | 2637824 | 0 | 81920 | 3088056320 | NULL | 2016-04-04 09:31:16 | NULL | NULL | utf8_unicode_ci | NULL | | |
  272. | deletedborrowers | InnoDB | 10 | Compact | 29763 | 264 | 7880704 | 0 | 3178496 | 3088056320 | NULL | 2016-04-04 09:31:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  273. | deleteditems | InnoDB | 10 | Compact | 5603 | 283 | 1589248 | 0 | 1097728 | 3088056320 | NULL | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  274. | discharges | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  275. | ethnicity | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  276. | export_format | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | Used for CSV export |
  277. | fieldmapping | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  278. | hold_fill_targets | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 49152 | 3088056320 | NULL | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  279. | import_auths | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:31:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  280. | import_batches | InnoDB | 10 | Compact | 14 | 1170 | 16384 | 0 | 16384 | 3088056320 | 15 | 2016-04-04 09:31:21 | NULL | NULL | utf8_unicode_ci | NULL | | |
  281. | import_biblios | InnoDB | 10 | Compact | 65861 | 103 | 6832128 | 0 | 12681216 | 3088056320 | NULL | 2016-04-04 09:31:26 | NULL | NULL | utf8_unicode_ci | NULL | | |
  282. | import_items | InnoDB | 10 | Compact | 161907 | 1072 | 173719552 | 0 | 7913472 | 3088056320 | 156741 | 2016-04-04 09:31:41 | NULL | NULL | utf8_unicode_ci | NULL | | |
  283. | import_record_matches | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:31:41 | NULL | NULL | utf8_unicode_ci | NULL | | |
  284. | import_records | InnoDB | 10 | Compact | 64713 | 4840 | 313262080 | 0 | 4767744 | 3088056320 | 60381 | 2016-04-04 09:31:59 | NULL | NULL | utf8_unicode_ci | NULL | | |
  285. | issues | InnoDB | 10 | Compact | 1846 | 106 | 196608 | 0 | 311296 | 3088056320 | 147823 | 2016-04-04 09:31:59 | NULL | NULL | utf8_unicode_ci | NULL | | |
  286. | issuingrules | InnoDB | 10 | Compact | 24 | 682 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:32:00 | NULL | NULL | utf8_unicode_ci | NULL | | |
  287. | item_circulation_alert_preferences | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:00 | NULL | NULL | utf8_unicode_ci | NULL | | |
  288. | items | InnoDB | 10 | Compact | 95434 | 302 | 28901376 | 0 | 49430528 | 3088056320 | 170165 | 2016-04-04 09:32:18 | NULL | NULL | utf8_unicode_ci | NULL | | |
  289. | items_search_fields | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  290. | itemtypes | InnoDB | 10 | Compact | 15 | 1092 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  291. | labels_profile | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  292. | labels_templates | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  293. | language_descriptions | InnoDB | 10 | Compact | 389 | 126 | 49152 | 0 | 32768 | 3088056320 | 503 | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  294. | language_rfc4646_to_iso639 | InnoDB | 10 | Compact | 74 | 221 | 16384 | 0 | 16384 | 3088056320 | 101 | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  295. | language_script_bidi | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  296. | language_script_mapping | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:19 | NULL | NULL | utf8_unicode_ci | NULL | | |
  297. | language_subtag_registry | InnoDB | 10 | Compact | 132 | 124 | 16384 | 0 | 16384 | 3088056320 | 206 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  298. | letter | InnoDB | 10 | Compact | 41 | 1198 | 49152 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  299. | linktracker | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 65536 | 3088056320 | 5 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  300. | localization | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  301. | marc_matchers | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 3088056320 | 3 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  302. | marc_modification_template_actions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  303. | marc_modification_templates | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:32:20 | NULL | NULL | utf8_unicode_ci | NULL | | |
  304. | marc_subfield_structure | InnoDB | 10 | Compact | 32154 | 114 | 3686400 | 0 | 4767744 | 3088056320 | NULL | 2016-04-04 09:32:23 | NULL | NULL | utf8_unicode_ci | NULL | | |
  305. | marc_tag_structure | InnoDB | 10 | Compact | 2786 | 123 | 344064 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:23 | NULL | NULL | utf8_unicode_ci | NULL | | |
  306. | matchchecks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 3088056320 | 1 | 2016-04-04 09:32:23 | NULL | NULL | utf8_unicode_ci | NULL | | |
  307. | matcher_matchpoints | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:32:23 | NULL | NULL | utf8_unicode_ci | NULL | | |
  308. | matchpoint_component_norms | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:23 | NULL | NULL | utf8_unicode_ci | NULL | | |
  309. | matchpoint_components | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 3088056320 | 3 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  310. | matchpoints | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 16384 | 3088056320 | 3 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  311. | message_attributes | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 16384 | 3088056320 | 7 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  312. | message_queue | InnoDB | 10 | Compact | 421 | 661 | 278528 | 0 | 32768 | 3088056320 | 59568 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  313. | message_transport_types | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  314. | message_transports | InnoDB | 10 | Compact | 16 | 1024 | 16384 | 0 | 49152 | 3088056320 | NULL | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  315. | messages | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 3088056320 | 10 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  316. | misc_files | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  317. | need_merge_authorities | InnoDB | 10 | Compact | 55 | 297 | 16384 | 0 | 0 | 3088056320 | 56 | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  318. | notifys | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:24 | NULL | NULL | utf8_unicode_ci | NULL | | |
  319. | oai_sets | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:25 | NULL | NULL | utf8_unicode_ci | NULL | | |
  320. | oai_sets_biblios | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:25 | NULL | NULL | utf8_unicode_ci | NULL | | |
  321. | oai_sets_descriptions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:25 | NULL | NULL | utf8_unicode_ci | NULL | | |
  322. | oai_sets_mappings | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:25 | NULL | NULL | utf8_unicode_ci | NULL | | |
  323. | old_issues | InnoDB | 10 | Compact | 149584 | 87 | 13123584 | 0 | 17891328 | 3088056320 | NULL | 2016-04-04 09:32:32 | NULL | NULL | utf8_unicode_ci | NULL | | |
  324. | old_reserves | InnoDB | 10 | Compact | 37 | 442 | 16384 | 0 | 65536 | 3088056320 | NULL | 2016-04-04 09:32:32 | NULL | NULL | utf8_unicode_ci | NULL | | |
  325. | opac_news | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 32768 | 3088056320 | 16 | 2016-04-04 09:32:32 | NULL | NULL | utf8_unicode_ci | NULL | | |
  326. | overduerules | InnoDB | 10 | Compact | 22 | 744 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:32 | NULL | NULL | utf8_unicode_ci | NULL | | |
  327. | overduerules_transport_types | InnoDB | 10 | Compact | 43 | 381 | 16384 | 0 | 32768 | 3088056320 | 298 | 2016-04-04 09:32:32 | NULL | NULL | utf8_unicode_ci | NULL | | |
  328. | patron_list_patrons | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  329. | patron_lists | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  330. | patroncards | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  331. | patronimage | InnoDB | 10 | Compact | 8 | 14336 | 114688 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  332. | pending_offline_operations | MyISAM | 10 | Dynamic | 1 | 56 | 56 | 281474976710655 | 2048 | 0 | 20 | 2016-04-04 09:32:33 | 2016-04-04 09:32:33 | NULL | utf8_unicode_ci | NULL | | |
  333. | permissions | InnoDB | 10 | Compact | 78 | 210 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  334. | plugin_data | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  335. | printers | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  336. | printers_profile | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 3088056320 | 17 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  337. | quotes | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  338. | ratings | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  339. | repeatable_holidays | InnoDB | 10 | Compact | 18 | 910 | 16384 | 0 | 0 | 3088056320 | 21 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  340. | reports_dictionary | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  341. | reserveconstraints | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  342. | reserves | InnoDB | 10 | Compact | 15 | 1092 | 16384 | 0 | 81920 | 3088056320 | 53 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  343. | reviews | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:32:33 | NULL | NULL | utf8_unicode_ci | NULL | | |
  344. | saved_reports | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  345. | saved_sql | InnoDB | 10 | Compact | 67 | 1711 | 114688 | 0 | 32768 | 3088056320 | 45 | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  346. | search_history | InnoDB | 10 | Compact | 241 | 339 | 81920 | 0 | 32768 | 3088056320 | 267 | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | Opac search history results |
  347. | serial | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  348. | serialitems | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  349. | services_throttle | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  350. | sessions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  351. | social_data | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:32:34 | NULL | NULL | utf8_unicode_ci | NULL | | |
  352. | special_holidays | InnoDB | 10 | Compact | 856 | 76 | 65536 | 0 | 0 | 3088056320 | 720 | 2016-04-04 09:32:35 | NULL | NULL | utf8_unicode_ci | NULL | | |
  353. | statistics | InnoDB | 10 | Compact | 337242 | 76 | 25755648 | 0 | 73564160 | 3088056320 | NULL | 2016-04-04 09:33:01 | NULL | NULL | utf8_unicode_ci | NULL | | |
  354. | stopwords | InnoDB | 10 | Compact | 98 | 167 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  355. | subscription | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  356. | subscription_frequencies | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 0 | 3088056320 | 14 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  357. | subscription_numberpatterns | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 3088056320 | 5 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  358. | subscriptionhistory | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  359. | subscriptionroutinglist | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 3088056320 | 1 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  360. | suggestions | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 98304 | 3088056320 | 26 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  361. | systempreferences | InnoDB | 10 | Compact | 523 | 281 | 147456 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  362. | tags | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  363. | tags_all | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  364. | tags_approval | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  365. | tags_index | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  366. | tmp_holdsqueue | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:33:02 | NULL | NULL | utf8_unicode_ci | NULL | | |
  367. | transport_cost | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 3088056320 | NULL | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  368. | uploaded_files | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 3088056320 | 1 | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  369. | user_permissions | InnoDB | 10 | Compact | 158 | 103 | 16384 | 0 | 32768 | 3088056320 | NULL | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  370. | userflags | InnoDB | 10 | Compact | 19 | 862 | 16384 | 0 | 0 | 3088056320 | NULL | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  371. | virtualshelfcontents | InnoDB | 10 | Compact | 637 | 102 | 65536 | 0 | 49152 | 3088056320 | NULL | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  372. | virtualshelfshares | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 3088056320 | 1 | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  373. | virtualshelves | InnoDB | 10 | Compact | 58 | 282 | 16384 | 0 | 16384 | 3088056320 | 71 | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  374. | z3950servers | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 0 | 3088056320 | 22 | 2016-04-04 09:33:03 | NULL | NULL | utf8_unicode_ci | NULL | | |
  375. | zebraqueue | InnoDB | 10 | Compact | 6049 | 89 | 540672 | 0 | 1572864 | 3088056320 | 445445 | 2016-04-04 09:44:49 | NULL | NULL | utf8_unicode_ci | NULL | | |
  376. +----------------------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+------------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+-----------------------------+
  377. 177 rows in set (0.71 sec)
  378.  
  379. mysql>
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!