API tools faq
paste
Advertisement
Guest User

mysqltuner.txt

a guest
Oct 29th, 2020 (edited)
243
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 205.50 KB | None | 0 0
raw download clone embed print report
  1.  >>  MySQLTuner 1.7.19 - Major Hayden <major@mhtx.net>
  2.  >>  Bug reports, feature requests, and downloads at http://mysqltuner.pl/
  3.  >>  Run with '--help' for additional options and output filtering
  4. [OK] You have the latest version of MySQLTuner(1.7.19)
  5. [OK] Currently running supported MySQL version 5.7.32-0ubuntu0.18.04.1
  6. [OK] Operating on 64-bit architecture
  7.  
  8. -------- System Linux Recommendations --------------------------------------------------------------
  9. Look for related Linux system recommendations
  10. [--] Ubuntu 18.04.5 LTS
  11. [--] Machine type          : Virtual machine
  12. [--] Internet              : Connected
  13. [--] Number of Core CPU : 2
  14.  
  15. [--] Operating System Type : GNU/Linux
  16. [--] Kernel Release        : 5.4.0-1025-aws
  17. [--] Hostname              : ip-172-31-20-67
  18. [--] Network Cards         :
  19. [--]    ens5: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 9001
  20. [--]            inet 172.31.20.67  netmask 255.255.240.0  broadcast 172.31.31.255
  21. [--]    --
  22. [--]    lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
  23. [--]            inet 127.0.0.1  netmask 255.0.0.0
  24. [--] Internal IP           : 172.31.20.67
  25. [--] HTTP client found: /usr/bin/curl
  26. [--] External IP           :   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current,                                  Dload  Upload   Total   Spent    Left  Speed,
  27.   0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
  28. 100    10  100    10    0     0     83      0 --:--:-- --:--:-- --:--:--    83, 3.8.39.189
  29. [--] Name Servers          : 127.0.0.53
  30. [--] Logged In users       :
  31. [--]    ubuntu   pts/0        2020-10-29 09:02 (82.37.170.154)
  32. [--] Ram Usages in Mb      :
  33. [--]                  total        used        free      shared  buff/cache   available
  34. [--]    Mem:          15550        1456        6834           3        7259       13793
  35. [--]    Swap:             0           0           0
  36. [--] Load Average          :
  37. [--]    top - 09:03:56 up 19 days, 18:07,  1 user,  load average: 0.08, 0.04, 0.01
  38. [--] System Uptime         :
  39. [--]     09:03:57 up 19 days, 18:07,  1 user,  load average: 0.08, 0.04, 0.01
  40. [--] User process except mysqld used 354M RAM.
  41. [--] Other user process except mysqld used less than 15% of total physical memory 2.28% (354M / 15G)
  42. [--] mount point / is using 85 % of total space
  43. [!!] mount point /snap/amazon-ssm-agent/2012 is using 100 % total space
  44. [!!] mount point /snap/core/10126 is using 100 % total space
  45. [!!] mount point /snap/core/10185 is using 100 % total space
  46. [--] mount point / is using 12 % of max allowed inodes
  47. [!!] mount point /snap/amazon-ssm-agent/2012 is using 100 % of max allowed inodes
  48. [!!] mount point /snap/core/10126 is using 100 % of max allowed inodes
  49. [!!] mount point /snap/core/10185 is using 100 % of max allowed inodes
  50. [--] Information about kernel tuning:
  51. [--]    fs.aio-max-nr = 1048576
  52. [--]    fs.aio-nr = 2661
  53. [--]    fs.file-max = 1589208
  54. [--]    vm.swappiness = 10
  55. [--] Swappiness is < 10.
  56. [--] TCP slot entries is > 100.
  57. [--] Max Number of AIO events is > 1M.
  58.  
  59. -------- Log file Recommendations ------------------------------------------------------------------
  60. [OK] Log file /var/log/mysql/error.log exists
  61. [--] Log file: /var/log/mysql/error.log(106B)
  62. [OK] Log file /var/log/mysql/error.log is readable.
  63. [OK] Log file /var/log/mysql/error.log is not empty
  64. [OK] Log file /var/log/mysql/error.log is smaller than 32 Mb
  65. [OK] /var/log/mysql/error.log doesn't contain any warning.
  66. [OK] /var/log/mysql/error.log doesn't contain any error.
  67. [--] 0 start(s) detected in /var/log/mysql/error.log
  68. [--] 0 shutdown(s) detected in /var/log/mysql/error.log
  69.  
  70. -------- Storage Engine Statistics -----------------------------------------------------------------
  71. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  72. [--] Data in InnoDB tables: 4.2M (Tables: 62)
  73. [OK] Total fragmented tables: 0
  74.  
  75. -------- Analysis Performance Metrics --------------------------------------------------------------
  76. [--] innodb_stats_on_metadata: OFF
  77. [OK] No stat updates during querying INFORMATION_SCHEMA.
  78.  
  79. -------- Database Metrics --------------------------------------------------------------------------
  80. [--] There is 1 Database(s).
  81. [--] All User Databases:
  82. [--]  +-- TABLE : 61
  83. [--]  +-- ROWS  : 8750
  84. [--]  +-- DATA  : 2.9M(68.03%)
  85. [--]  +-- INDEX : 1.3M(31.97%)
  86. [--]  +-- SIZE  : 4.2M
  87. [--]  +-- COLLA : 3 (utf8_general_ci, utf8_bin, latin1_swedish_ci, NULL, latin1_general_ci)
  88. [--]  +-- ENGIN : 1 (MEMORY, InnoDB, MyISAM, CSV, PERFORMANCE_SCHEMA, NULL)
  89. [--] Database: tradingsim
  90. [--]  +-- TABLE: 61
  91. [--]  +-- COLL : 3 (latin1_swedish_ci, latin1_general_ci, utf8_general_ci)
  92. [--]  +-- ROWS : 8750
  93. [--]  +-- DATA : 2.9M(68.03%)
  94. [--]  +-- INDEX: 1.3M(31.97%)
  95. [--]  +-- TOTAL: 4.2M
  96. [--]  +-- ENGIN : 1 (InnoDB)
  97. [!!] 3 different collations for database tradingsim
  98. [OK] 1 engine for tradingsim database.
  99. [--] Charsets for tradingsim database table column: latin1, utf8
  100. [!!] tradingsim table column(s) has several charsets defined for all text like column(s).
  101. [--] Collations for tradingsim database table column: latin1_swedish_ci, latin1_general_ci, utf8_general_ci
  102. [!!] tradingsim table column(s) has several collations defined for all text like column(s).
  103.  
  104. -------- Table Column Metrics ----------------------------------------------------------------------
  105. [--] Database: tradingsim
  106. [--]  +-- TABLE: abstract_traders
  107. [--]      +-- Column abstract_traders.ID:
  108. [--]       Current Fieldtype: INT(11) NOT NULL
  109. [--]       Optimal Fieldtype: ENUM( ... )
  110. [--]      +-- Column abstract_traders.scenario_ID:
  111. [--]       Current Fieldtype: INT(11) NOT NULL
  112. [--]       Optimal Fieldtype: ENUM( ... )
  113. [--]      +-- Column abstract_traders.name:
  114. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  115. [--]       Optimal Fieldtype: ENUM( ... )
  116. [--]      +-- Column abstract_traders.description:
  117. [--]       Current Fieldtype: VARCHAR(255)
  118. [--]       Optimal Fieldtype: ENUM( ... )
  119. [--]      +-- Column abstract_traders.type:
  120. [--]       Current Fieldtype: ENUM('COMPUTER')
  121. [--]       Optimal Fieldtype: ENUM( ... )
  122. [--]      +-- Column abstract_traders.buyside:
  123. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  124. [--]       Optimal Fieldtype: ENUM( ... )
  125. [--]      +-- Column abstract_traders.marketmaker:
  126. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  127. [--]       Optimal Fieldtype: ENUM( ... )
  128. [--]      +-- Column abstract_traders.flow_spread_tolerance:
  129. [--]       Current Fieldtype: INT(11) NOT NULL
  130. [--]       Optimal Fieldtype: ENUM( ... )
  131. [--]      +-- Column abstract_traders.dealer_spread_tolerance:
  132. [--]       Current Fieldtype: INT(11) NOT NULL
  133. [--]       Optimal Fieldtype: ENUM( ... )
  134. [--]      +-- Column abstract_traders.sub_type:
  135. [--]       Current Fieldtype: ENUM('DEALER','IDB')
  136. [--]       Optimal Fieldtype: ENUM( ... )
  137. [--]      +-- Column abstract_traders.response_flow_tolerance:
  138. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  139. [--]       Optimal Fieldtype: ENUM( ... )
  140. [--]      +-- Column abstract_traders.response_notional_sensitivity:
  141. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  142. [--]       Optimal Fieldtype: ENUM( ... )
  143. [--]      +-- Column abstract_traders.response_maturity_sensitivity:
  144. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  145. [--]       Optimal Fieldtype: ENUM( ... )
  146. [--]      +-- Column abstract_traders.response_improvement_half_spread:
  147. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  148. [--]       Optimal Fieldtype: ENUM( ... )
  149. [--]      +-- Column abstract_traders.response_offence_tolerance:
  150. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  151. [--]       Optimal Fieldtype: ENUM( ... )
  152. [--]      +-- Column abstract_traders.response_favour_tolerance:
  153. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  154. [--]       Optimal Fieldtype: ENUM( ... )
  155. [--]      +-- Column abstract_traders.deviation_bias:
  156. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  157. [--]       Optimal Fieldtype: ENUM( ... )
  158. [--]      +-- Column abstract_traders.deviation_width:
  159. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  160. [--]       Optimal Fieldtype: ENUM( ... )
  161. [--]      +-- Column abstract_traders.color:
  162. [--]       Current Fieldtype: CHAR(6)
  163. [--]       Optimal Fieldtype: ENUM( ... )
  164. [--]  +-- TABLE: annotations
  165. [--]      +-- Column annotations.ID:
  166. [--]       Current Fieldtype: INT(11) NOT NULL
  167. [--]       Optimal Fieldtype: ENUM( ... )
  168. [--]      +-- Column annotations.scenario_ID:
  169. [--]       Current Fieldtype: INT(11) NOT NULL
  170. [--]       Optimal Fieldtype: ENUM( ... )
  171. [--]      +-- Column annotations.title:
  172. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  173. [--]       Optimal Fieldtype: ENUM( ... )
  174. [--]      +-- Column annotations.body:
  175. [--]       Current Fieldtype: VARCHAR(255) NOT NULL
  176. [--]       Optimal Fieldtype: ENUM( ... )
  177. [--]      +-- Column annotations.tick:
  178. [--]       Current Fieldtype: INT(11) NOT NULL
  179. [--]       Optimal Fieldtype: ENUM( ... )
  180. [--]  +-- TABLE: autopilot
  181. [--]      +-- Column autopilot.ID:
  182. [--]       Current Fieldtype: INT(11) NOT NULL
  183. [--]      +-- Column autopilot.trader_ID:
  184. [--]       Current Fieldtype: INT(11) NOT NULL
  185. [--]      +-- Column autopilot.client_tick_speed:
  186. [--]       Current Fieldtype: INT(11) NOT NULL
  187. [--]      +-- Column autopilot.dealer_rate:
  188. [--]       Current Fieldtype: INT(11) NOT NULL
  189. [--]      +-- Column autopilot.broker_rate:
  190. [--]       Current Fieldtype: INT(11) NOT NULL
  191. [--]      +-- Column autopilot.graph_scrub_rate:
  192. [--]       Current Fieldtype: INT(11) NOT NULL
  193. [--]      +-- Column autopilot.reload_rate:
  194. [--]       Current Fieldtype: INT(11) NOT NULL
  195. [--]  +-- TABLE: bond_maturities
  196. [--]      +-- Column bond_maturities.ID:
  197. [--]       Current Fieldtype: INT(11) NOT NULL
  198. [--]       Optimal Fieldtype: ENUM( ... )
  199. [--]      +-- Column bond_maturities.scenario_ID:
  200. [--]       Current Fieldtype: INT(11) NOT NULL
  201. [--]       Optimal Fieldtype: ENUM( ... )
  202. [--]      +-- Column bond_maturities.name:
  203. [--]       Current Fieldtype: CHAR(4) NOT NULL
  204. [--]       Optimal Fieldtype: ENUM( ... )
  205. [--]      +-- Column bond_maturities.lower:
  206. [--]       Current Fieldtype: INT(11) NOT NULL
  207. [--]       Optimal Fieldtype: ENUM( ... )
  208. [--]      +-- Column bond_maturities.upper:
  209. [--]       Current Fieldtype: INT(11) NOT NULL
  210. [--]       Optimal Fieldtype: ENUM( ... )
  211. [--]      +-- Column bond_maturities.defaultlimit:
  212. [--]       Current Fieldtype: INT(11) NOT NULL
  213. [--]       Optimal Fieldtype: ENUM( ... )
  214. [--]  +-- TABLE: broken_limits
  215. [--]      +-- Column broken_limits.ID:
  216. [--]       Current Fieldtype: INT(11) NOT NULL
  217. [--]      +-- Column broken_limits.trader_ID:
  218. [--]       Current Fieldtype: INT(11) NOT NULL
  219. [--]      +-- Column broken_limits.broken:
  220. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  221. [--]      +-- Column broken_limits.type:
  222. [--]       Current Fieldtype: ENUM('CURRENTACCOUNT','COUNTERPARTY','MATURITY','DELTACASH','DELTAOPTION','DELTA','VEGA','NOSTROACCOUNT','GAMMA','THETA','DELTAMATURITY')
  223. [--]      +-- Column broken_limits.broken_thing_ID:
  224. [--]       Current Fieldtype: INT(11) NOT NULL
  225. [--]      +-- Column broken_limits.tick_broken:
  226. [--]       Current Fieldtype: INT(11) NOT NULL
  227. [--]      +-- Column broken_limits.time_broken:
  228. [--]       Current Fieldtype: DATETIME NOT NULL
  229. [--]      +-- Column broken_limits.tick_fixed:
  230. [--]       Current Fieldtype: INT(11) NOT NULL
  231. [--]      +-- Column broken_limits.time_fixed:
  232. [--]       Current Fieldtype: DATETIME NOT NULL
  233. [--]      +-- Column broken_limits.amount_broken:
  234. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  235. [--]      +-- Column broken_limits.frequency_broken:
  236. [--]       Current Fieldtype: INT(11) NOT NULL
  237. [--]      +-- Column broken_limits.client_induced:
  238. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  239. [--]  +-- TABLE: call_log
  240. [--]      +-- Column call_log.ID:
  241. [--]       Current Fieldtype: INT(11) NOT NULL
  242. [--]      +-- Column call_log.trader_ID:
  243. [--]       Current Fieldtype: INT(11) NOT NULL
  244. [--]      +-- Column call_log.tick:
  245. [--]       Current Fieldtype: INT(11) NOT NULL
  246. [--]      +-- Column call_log.caller_ID:
  247. [--]       Current Fieldtype: INT(11) NOT NULL
  248. [--]      +-- Column call_log.call_result:
  249. [--]       Current Fieldtype: ENUM('UNKNOWN','MISSED','HUNGUP','FAVOR','ACCEPT','REJECT','OFFENCE') NOT NULL
  250. [--]      +-- Column call_log.price_dispersal:
  251. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  252. [--]  +-- TABLE: changelog
  253. [--]      +-- Column changelog.change_number:
  254. [--]       Current Fieldtype: BIGINT(20) NOT NULL
  255. [--]      +-- Column changelog.complete_dt:
  256. [--]       Current Fieldtype: TIMESTAMP NOT NULL
  257. [--]      +-- Column changelog.applied_by:
  258. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  259. [--]      +-- Column changelog.description:
  260. [--]       Current Fieldtype: VARCHAR(500) NOT NULL
  261. [--]  +-- TABLE: chat_messages
  262. [--]      +-- Column chat_messages.ID:
  263. [--]       Current Fieldtype: INT(11) NOT NULL
  264. [--]      +-- Column chat_messages.sender_ID:
  265. [--]       Current Fieldtype: INT(11) NOT NULL
  266. [--]      +-- Column chat_messages.receiver_ID:
  267. [--]       Current Fieldtype: INT(11) NOT NULL
  268. [--]      +-- Column chat_messages.instance_ID:
  269. [--]       Current Fieldtype: INT(11) NOT NULL
  270. [--]      +-- Column chat_messages.timestamp:
  271. [--]       Current Fieldtype: DATETIME
  272. [--]      +-- Column chat_messages.content:
  273. [--]       Current Fieldtype: VARCHAR(255)
  274. [--]  +-- TABLE: client
  275. [--]      +-- Column client.ID:
  276. [--]       Current Fieldtype: INT(11) NOT NULL
  277. [--]       Optimal Fieldtype: ENUM( ... )
  278. [--]      +-- Column client.name:
  279. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  280. [--]       Optimal Fieldtype: ENUM( ... )
  281. [--]      +-- Column client.system_branding:
  282. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  283. [--]       Optimal Fieldtype: ENUM( ... )
  284. [--]      +-- Column client.originator_id:
  285. [--]       Current Fieldtype: INT(11) NOT NULL
  286. [--]       Optimal Fieldtype: ENUM( ... )
  287. [--]      +-- Column client.client_theme:
  288. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  289. [--]       Optimal Fieldtype: ENUM( ... )
  290. [--]  +-- TABLE: conditional_trades
  291. [--]      +-- Column conditional_trades.ID:
  292. [--]       Current Fieldtype: INT(11) NOT NULL
  293. [--]      +-- Column conditional_trades.trade_master_ID:
  294. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  295. [--]      +-- Column conditional_trades.trade_leg_ID:
  296. [--]       Current Fieldtype: INT(11) NOT NULL
  297. [--]      +-- Column conditional_trades.quote_unit:
  298. [--]       Current Fieldtype: ENUM('NOTIONAL','DV01')
  299. [--]      +-- Column conditional_trades.direction:
  300. [--]       Current Fieldtype: ENUM('BUY','SELL')
  301. [--]  +-- TABLE: currencies
  302. [--]      +-- Column currencies.ID:
  303. [--]       Current Fieldtype: INT(11) NOT NULL
  304. [--]       Optimal Fieldtype: ENUM( ... )
  305. [--]      +-- Column currencies.scenario_ID:
  306. [--]       Current Fieldtype: INT(11) NOT NULL
  307. [--]       Optimal Fieldtype: ENUM( ... )
  308. [--]      +-- Column currencies.name:
  309. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  310. [--]       Optimal Fieldtype: ENUM( ... )
  311. [--]      +-- Column currencies.code:
  312. [--]       Current Fieldtype: VARCHAR(4) NOT NULL
  313. [--]       Optimal Fieldtype: ENUM( ... )
  314. [--]      +-- Column currencies.exchange_rate_stored_path_ID:
  315. [--]       Current Fieldtype: INT(11) NOT NULL
  316. [--]       Optimal Fieldtype: ENUM( ... )
  317. [--]      +-- Column currencies.swap_exchange_currencies:
  318. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  319. [--]       Optimal Fieldtype: ENUM( ... )
  320. [--]      +-- Column currencies.interest_rate_stored_path_ID:
  321. [--]       Current Fieldtype: INT(11) NOT NULL
  322. [--]       Optimal Fieldtype: ENUM( ... )
  323. [--]  +-- TABLE: current_accounts
  324. [--]      +-- Column current_accounts.ID:
  325. [--]       Current Fieldtype: INT(11) NOT NULL
  326. [--]      +-- Column current_accounts.trader_ID:
  327. [--]       Current Fieldtype: INT(11) NOT NULL
  328. [--]      +-- Column current_accounts.currency_ID:
  329. [--]       Current Fieldtype: INT(11) NOT NULL
  330. [--]      +-- Column current_accounts.amount:
  331. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  332. [--]      +-- Column current_accounts.tick:
  333. [--]       Current Fieldtype: INT(11) NOT NULL
  334. [--]      +-- Column current_accounts.audit_trail:
  335. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  336. [--]      +-- Column current_accounts.instrument_ID:
  337. [--]       Current Fieldtype: INT(11) NOT NULL
  338. [--]  +-- TABLE: erp2_instructions
  339. [--]      +-- Column erp2_instructions.ID:
  340. [--]       Current Fieldtype: INT(11) NOT NULL
  341. [--]       Optimal Fieldtype: ENUM( ... )
  342. [--]      +-- Column erp2_instructions.role_node_ID:
  343. [--]       Current Fieldtype: INT(11) NOT NULL
  344. [--]       Optimal Fieldtype: ENUM( ... )
  345. [--]      +-- Column erp2_instructions.name:
  346. [--]       Current Fieldtype: VARCHAR(128) NOT NULL
  347. [--]       Optimal Fieldtype: ENUM( ... )
  348. [--]      +-- Column erp2_instructions.tab_ID:
  349. [--]       Current Fieldtype: INT(11) NOT NULL
  350. [--]       Optimal Fieldtype: ENUM( ... )
  351. [--]      +-- Column erp2_instructions.internal_only:
  352. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  353. [--]       Optimal Fieldtype: ENUM( ... )
  354. [--]      +-- Column erp2_instructions.skip_auth:
  355. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  356. [--]       Optimal Fieldtype: ENUM( ... )
  357. [--]  +-- TABLE: erp2_links_persons_role_nodes
  358. [--]      +-- Column erp2_links_persons_role_nodes.person_ID:
  359. [--]       Current Fieldtype: INT(11) NOT NULL
  360. [--]       Optimal Fieldtype: ENUM( ... )
  361. [--]      +-- Column erp2_links_persons_role_nodes.role_node_ID:
  362. [--]       Current Fieldtype: INT(11) NOT NULL
  363. [--]       Optimal Fieldtype: ENUM( ... )
  364. [--]  +-- TABLE: erp2_role_nodes
  365. [--]      +-- Column erp2_role_nodes.ID:
  366. [--]       Current Fieldtype: INT(11) NOT NULL
  367. [--]       Optimal Fieldtype: ENUM( ... )
  368. [--]      +-- Column erp2_role_nodes.parent_ID:
  369. [--]       Current Fieldtype: INT(11)
  370. [--]       Optimal Fieldtype: ENUM( ... )
  371. [--]      +-- Column erp2_role_nodes.description:
  372. [--]       Current Fieldtype: VARCHAR(255)
  373. [--]       Optimal Fieldtype: ENUM( ... )
  374. [--]  +-- TABLE: erp2_tabs
  375. [--]      +-- Column erp2_tabs.ID:
  376. [--]       Current Fieldtype: INT(11) NOT NULL
  377. [--]      +-- Column erp2_tabs.name:
  378. [--]       Current Fieldtype: VARCHAR(32) NOT NULL
  379. [--]      +-- Column erp2_tabs.sort_order:
  380. [--]       Current Fieldtype: INT(11) NOT NULL
  381. [--]      +-- Column erp2_tabs.link:
  382. [--]       Current Fieldtype: VARCHAR(255)
  383. [--]      +-- Column erp2_tabs.legacy_role:
  384. [--]       Current Fieldtype: VARCHAR(64) NOT NULL
  385. [--]  +-- TABLE: event_log
  386. [--]      +-- Column event_log.ID:
  387. [--]       Current Fieldtype: INT(11) NOT NULL
  388. [--]      +-- Column event_log.instance_ID:
  389. [--]       Current Fieldtype: INT(11) NOT NULL
  390. [--]      +-- Column event_log.description:
  391. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  392. [--]      +-- Column event_log.tick_occured:
  393. [--]       Current Fieldtype: INT(11) NOT NULL
  394. [--]      +-- Column event_log.time_occured:
  395. [--]       Current Fieldtype: DATETIME NOT NULL
  396. [--]  +-- TABLE: forward_rates
  397. [--]      +-- Column forward_rates.ID:
  398. [--]       Current Fieldtype: INT(11) NOT NULL
  399. [--]       Optimal Fieldtype: ENUM( ... )
  400. [--]      +-- Column forward_rates.currency_ID:
  401. [--]       Current Fieldtype: INT(11) NOT NULL
  402. [--]       Optimal Fieldtype: ENUM( ... )
  403. [--]      +-- Column forward_rates.tick:
  404. [--]       Current Fieldtype: INT(11) NOT NULL
  405. [--]       Optimal Fieldtype: ENUM( ... )
  406. [--]      +-- Column forward_rates.ON:
  407. [--]       Current Fieldtype: FLOAT NOT NULL
  408. [--]       Optimal Fieldtype: ENUM( ... )
  409. [--]      +-- Column forward_rates.1W:
  410. [--]       Current Fieldtype: FLOAT NOT NULL
  411. [--]       Optimal Fieldtype: ENUM( ... )
  412. [--]      +-- Column forward_rates.2W:
  413. [--]       Current Fieldtype: FLOAT NOT NULL
  414. [--]       Optimal Fieldtype: ENUM( ... )
  415. [--]      +-- Column forward_rates.1M:
  416. [--]       Current Fieldtype: FLOAT NOT NULL
  417. [--]       Optimal Fieldtype: ENUM( ... )
  418. [--]      +-- Column forward_rates.3M:
  419. [--]       Current Fieldtype: FLOAT NOT NULL
  420. [--]       Optimal Fieldtype: ENUM( ... )
  421. [--]      +-- Column forward_rates.6M:
  422. [--]       Current Fieldtype: FLOAT NOT NULL
  423. [--]       Optimal Fieldtype: ENUM( ... )
  424. [--]  +-- TABLE: held_instruments
  425. [--]      +-- Column held_instruments.ID:
  426. [--]       Current Fieldtype: INT(11) NOT NULL
  427. [--]      +-- Column held_instruments.trader_ID:
  428. [--]       Current Fieldtype: INT(11) NOT NULL
  429. [--]      +-- Column held_instruments.counterparty_trader_ID:
  430. [--]       Current Fieldtype: INT(11) NOT NULL
  431. [--]      +-- Column held_instruments.instrument_ID:
  432. [--]       Current Fieldtype: INT(11) NOT NULL
  433. [--]      +-- Column held_instruments.strike:
  434. [--]       Current Fieldtype: DECIMAL(6,2)
  435. [--]      +-- Column held_instruments.expiry:
  436. [--]       Current Fieldtype: INT(11) NOT NULL
  437. [--]      +-- Column held_instruments.call_put:
  438. [--]       Current Fieldtype: ENUM('CALL','PUT') NOT NULL
  439. [--]      +-- Column held_instruments.tick_traded:
  440. [--]       Current Fieldtype: INT(11) NOT NULL
  441. [--]      +-- Column held_instruments.price_traded_each:
  442. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  443. [--]      +-- Column held_instruments.price_paid_each:
  444. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  445. [--]      +-- Column held_instruments.reval_price_each:
  446. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  447. [--]      +-- Column held_instruments.quantity:
  448. [--]       Current Fieldtype: INT(11) NOT NULL
  449. [--]      +-- Column held_instruments.quantity_left:
  450. [--]       Current Fieldtype: INT(11) NOT NULL
  451. [--]      +-- Column held_instruments.open:
  452. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  453. [--]      +-- Column held_instruments.tick_closed:
  454. [--]       Current Fieldtype: INT(11) NOT NULL
  455. [--]      +-- Column held_instruments.delta:
  456. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  457. [--]      +-- Column held_instruments.gamma:
  458. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  459. [--]      +-- Column held_instruments.vega:
  460. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  461. [--]      +-- Column held_instruments.theta:
  462. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  463. [--]      +-- Column held_instruments.trade_ID:
  464. [--]       Current Fieldtype: INT(11)
  465. [--]      +-- Column held_instruments.yield_paid_each:
  466. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  467. [--]      +-- Column held_instruments.delta_last_tick:
  468. [--]       Current Fieldtype: DECIMAL(18,7)
  469. [--]  +-- TABLE: instances
  470. [--]      +-- Column instances.ID:
  471. [--]       Current Fieldtype: INT(11) NOT NULL
  472. [--]       Optimal Fieldtype: ENUM( ... )
  473. [--]      +-- Column instances.name:
  474. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  475. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  476. [!!] Consider changing type for column name in table tradingsim.instances
  477. [--]      +-- Column instances.scenario_ID:
  478. [--]       Current Fieldtype: INT(11) NOT NULL
  479. [--]       Optimal Fieldtype: ENUM( ... )
  480. [--]      +-- Column instances.current_tick:
  481. [--]       Current Fieldtype: INT(11) NOT NULL
  482. [--]       Optimal Fieldtype: ENUM( ... )
  483. [--]      +-- Column instances.status:
  484. [--]       Current Fieldtype: ENUM('PLAYING','PAUSED','FINISHED') NOT NULL
  485. [--]       Optimal Fieldtype: ENUM( ... )
  486. [--]      +-- Column instances.tick_length:
  487. [--]       Current Fieldtype: DOUBLE NOT NULL
  488. [--]       Optimal Fieldtype: ENUM( ... )
  489. [--]      +-- Column instances.time_started:
  490. [OK] tradingsim.instances (time_started) type: DATETIME
  491. [--]      +-- Column instances.time_prev_tick:
  492. [OK] tradingsim.instances (time_prev_tick) type: DATETIME
  493. [--]      +-- Column instances.open:
  494. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  495. [--]       Optimal Fieldtype: ENUM( ... )
  496. [--]      +-- Column instances.been_played:
  497. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  498. [--]       Optimal Fieldtype: ENUM( ... )
  499. [--]      +-- Column instances.available:
  500. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  501. [--]       Optimal Fieldtype: ENUM( ... )
  502. [--]      +-- Column instances.clienttrade_rate:
  503. [--]       Current Fieldtype: INT(11) NOT NULL
  504. [--]       Optimal Fieldtype: ENUM( ... )
  505. [--]      +-- Column instances.quotetrade_rate:
  506. [--]       Current Fieldtype: INT(11) NOT NULL
  507. [--]       Optimal Fieldtype: ENUM( ... )
  508. [--]      +-- Column instances.max_incoming_trades:
  509. [--]       Current Fieldtype: INT(11) NOT NULL
  510. [--]       Optimal Fieldtype: ENUM( ... )
  511. [--]      +-- Column instances.limit_currentaccount:
  512. [--]       Current Fieldtype: INT(11) NOT NULL
  513. [--]       Optimal Fieldtype: ENUM( ... )
  514. [--]      +-- Column instances.limit_counterparty:
  515. [--]       Current Fieldtype: INT(11) NOT NULL
  516. [--]       Optimal Fieldtype: ENUM( ... )
  517. [--]      +-- Column instances.limit_maturity:
  518. [--]       Current Fieldtype: INT(11) NOT NULL
  519. [--]       Optimal Fieldtype: ENUM( ... )
  520. [--]      +-- Column instances.limit_delta:
  521. [--]       Current Fieldtype: INT(11) NOT NULL
  522. [--]       Optimal Fieldtype: ENUM( ... )
  523. [--]      +-- Column instances.limit_gamma:
  524. [--]       Current Fieldtype: INT(11) NOT NULL
  525. [--]       Optimal Fieldtype: ENUM( ... )
  526. [--]      +-- Column instances.limit_vega:
  527. [--]       Current Fieldtype: INT(11) NOT NULL
  528. [--]       Optimal Fieldtype: ENUM( ... )
  529. [--]      +-- Column instances.incoming_trade_timeout:
  530. [--]       Current Fieldtype: INT(11) NOT NULL
  531. [--]       Optimal Fieldtype: ENUM( ... )
  532. [--]      +-- Column instances.computer_price_tolerance:
  533. [--]       Current Fieldtype: FLOAT NOT NULL
  534. [--]       Optimal Fieldtype: ENUM( ... )
  535. [--]      +-- Column instances.random_trades:
  536. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  537. [--]       Optimal Fieldtype: ENUM( ... )
  538. [--]      +-- Column instances.show_human_traders:
  539. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  540. [--]       Optimal Fieldtype: ENUM( ... )
  541. [--]      +-- Column instances.skin:
  542. [--]       Current Fieldtype: ENUM('BASE','7C_NEW','7C_CQF','RBS_NEW','ICMA_NEW','FITCH')
  543. [--]       Optimal Fieldtype: ENUM( ... )
  544. [--]      +-- Column instances.option_prices_as_premiums:
  545. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  546. [--]       Optimal Fieldtype: ENUM( ... )
  547. [--]      +-- Column instances.single_option_multiple_strikes:
  548. [--]       Current Fieldtype: INT(11) NOT NULL
  549. [--]       Optimal Fieldtype: ENUM( ... )
  550. [--]      +-- Column instances.implied_vol_curve:
  551. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  552. [--]       Optimal Fieldtype: ENUM( ... )
  553. [--]      +-- Column instances.intensity:
  554. [--]       Current Fieldtype: FLOAT NOT NULL
  555. [--]       Optimal Fieldtype: ENUM( ... )
  556. [--]      +-- Column instances.outcry_trades_allowed:
  557. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  558. [--]       Optimal Fieldtype: ENUM( ... )
  559. [--]      +-- Column instances.pl_weighting:
  560. [--]       Current Fieldtype: INT(11) NOT NULL
  561. [--]       Optimal Fieldtype: ENUM( ... )
  562. [--]      +-- Column instances.flow_weighting:
  563. [--]       Current Fieldtype: INT(11) NOT NULL
  564. [--]       Optimal Fieldtype: ENUM( ... )
  565. [--]      +-- Column instances.dealer_weighting:
  566. [--]       Current Fieldtype: INT(11) NOT NULL
  567. [--]       Optimal Fieldtype: ENUM( ... )
  568. [--]      +-- Column instances.max_trade_value:
  569. [--]       Current Fieldtype: INT(11) NOT NULL
  570. [--]       Optimal Fieldtype: ENUM( ... )
  571. [--]      +-- Column instances.owner_ID:
  572. [--]       Current Fieldtype: INT(11) NOT NULL
  573. [--]       Optimal Fieldtype: ENUM( ... )
  574. [--]      +-- Column instances.variable_quote_quantity:
  575. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  576. [--]       Optimal Fieldtype: ENUM( ... )
  577. [--]      +-- Column instances.limit_stopout_threshold:
  578. [--]       Current Fieldtype: ENUM('0','5','10','15','20','25') NOT NULL
  579. [--]       Optimal Fieldtype: ENUM( ... )
  580. [--]      +-- Column instances.limit_theta:
  581. [--]       Current Fieldtype: INT(11) NOT NULL
  582. [--]       Optimal Fieldtype: ENUM( ... )
  583. [--]      +-- Column instances.trade_mode:
  584. [--]       Current Fieldtype: ENUM('OTC','BUYSIDE') NOT NULL
  585. [--]       Optimal Fieldtype: ENUM( ... )
  586. [--]      +-- Column instances.display_mode:
  587. [--]       Current Fieldtype: ENUM('LCD','PROJECTOR','DEMO') NOT NULL
  588. [--]       Optimal Fieldtype: ENUM( ... )
  589. [--]      +-- Column instances.date_display_convention:
  590. [--]       Current Fieldtype: ENUM('DD/MM/YY','MM/DD/YY') NOT NULL
  591. [--]       Optimal Fieldtype: ENUM( ... )
  592. [--]      +-- Column instances.date_display_format:
  593. [--]       Current Fieldtype: VARCHAR(30)
  594. [--]       Optimal Fieldtype: CHAR(0)
  595. [!!] Consider changing type for column date_display_format in table tradingsim.instances
  596. [--]      +-- Column instances.default_commission_bps:
  597. [--]       Current Fieldtype: INT(11) NOT NULL
  598. [--]       Optimal Fieldtype: ENUM( ... )
  599. [--]      +-- Column instances.show_benchmark:
  600. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  601. [--]       Optimal Fieldtype: ENUM( ... )
  602. [--]      +-- Column instances.human_trade_style:
  603. [--]       Current Fieldtype: ENUM('QUOTE','REPORT')
  604. [--]       Optimal Fieldtype: ENUM( ... )
  605. [--]      +-- Column instances.improve_rate:
  606. [--]       Current Fieldtype: INT(11) NOT NULL
  607. [--]       Optimal Fieldtype: ENUM( ... )
  608. [--]      +-- Column instances.track_offence:
  609. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  610. [--]       Optimal Fieldtype: ENUM( ... )
  611. [--]      +-- Column instances.display_offence:
  612. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  613. [--]       Optimal Fieldtype: ENUM( ... )
  614. [--]      +-- Column instances.use_stop_limits:
  615. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  616. [--]       Optimal Fieldtype: ENUM( ... )
  617. [--]      +-- Column instances.dealer_volatility:
  618. [--]       Current Fieldtype: INT(11) NOT NULL
  619. [--]       Optimal Fieldtype: ENUM( ... )
  620. [--]      +-- Column instances.mean_dealer_width:
  621. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  622. [--]       Optimal Fieldtype: ENUM( ... )
  623. [--]      +-- Column instances.broker_response_to_position_rate:
  624. [--]       Current Fieldtype: INT(11) NOT NULL
  625. [--]       Optimal Fieldtype: ENUM( ... )
  626. [--]      +-- Column instances.liquidity_profile_ID:
  627. [--]       Current Fieldtype: INT(11)
  628. [--]       Optimal Fieldtype: ENUM( ... )
  629. [--]      +-- Column instances.show_broker_graph:
  630. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  631. [--]       Optimal Fieldtype: ENUM( ... )
  632. [--]      +-- Column instances.allow_partial_take:
  633. [--]       Current Fieldtype: ENUM('YES','NO')
  634. [--]       Optimal Fieldtype: ENUM( ... )
  635. [--]      +-- Column instances.weight_trading:
  636. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  637. [--]       Optimal Fieldtype: ENUM( ... )
  638. [--]      +-- Column instances.weight_client_quotes:
  639. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  640. [--]       Optimal Fieldtype: ENUM( ... )
  641. [--]      +-- Column instances.weight_discipline:
  642. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  643. [--]       Optimal Fieldtype: ENUM( ... )
  644. [--]      +-- Column instances.weight_dealer_response:
  645. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  646. [--]       Optimal Fieldtype: ENUM( ... )
  647. [--]      +-- Column instances.weight_losses:
  648. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  649. [--]       Optimal Fieldtype: ENUM( ... )
  650. [--]      +-- Column instances.price_decimal_display:
  651. [--]       Current Fieldtype: INT(11) NOT NULL
  652. [--]       Optimal Fieldtype: ENUM( ... )
  653. [--]      +-- Column instances.min_option_price:
  654. [--]       Current Fieldtype: DECIMAL(9,7) NOT NULL
  655. [--]       Optimal Fieldtype: ENUM( ... )
  656. [--]  +-- TABLE: instruments
  657. [--]      +-- Column instruments.ID:
  658. [--]       Current Fieldtype: INT(11) NOT NULL
  659. [--]       Optimal Fieldtype: ENUM( ... )
  660. [--]      +-- Column instruments.scenario_ID:
  661. [--]       Current Fieldtype: INT(11) NOT NULL
  662. [--]       Optimal Fieldtype: ENUM( ... )
  663. [--]      +-- Column instruments.name:
  664. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  665. [--]       Optimal Fieldtype: ENUM( ... )
  666. [--]      +-- Column instruments.shortName:
  667. [--]       Current Fieldtype: VARCHAR(10) NOT NULL
  668. [--]       Optimal Fieldtype: ENUM( ... )
  669. [--]      +-- Column instruments.type:
  670. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  671. [--]       Optimal Fieldtype: ENUM( ... )
  672. [--]      +-- Column instruments.currency_dp_shift:
  673. [--]       Current Fieldtype: INT(11)
  674. [--]       Optimal Fieldtype: ENUM( ... )
  675. [--]      +-- Column instruments.currency_var_ID:
  676. [--]       Current Fieldtype: INT(11)
  677. [--]       Optimal Fieldtype: ENUM( ... )
  678. [--]      +-- Column instruments.currency_ID:
  679. [--]       Current Fieldtype: INT(11) NOT NULL
  680. [--]       Optimal Fieldtype: ENUM( ... )
  681. [--]      +-- Column instruments.bid_stored_path_ID:
  682. [--]       Current Fieldtype: INT(11) NOT NULL
  683. [--]       Optimal Fieldtype: ENUM( ... )
  684. [--]      +-- Column instruments.offer_stored_path_ID:
  685. [--]       Current Fieldtype: INT(11) NOT NULL
  686. [--]       Optimal Fieldtype: ENUM( ... )
  687. [--]      +-- Column instruments.vol_stored_path_ID:
  688. [--]       Current Fieldtype: INT(11) NOT NULL
  689. [--]       Optimal Fieldtype: ENUM( ... )
  690. [--]      +-- Column instruments.underlying_instrument_ID:
  691. [--]       Current Fieldtype: INT(11) NOT NULL
  692. [--]       Optimal Fieldtype: ENUM( ... )
  693. [--]      +-- Column instruments.maturity:
  694. [--]       Current Fieldtype: INT(11) NOT NULL
  695. [--]       Optimal Fieldtype: ENUM( ... )
  696. [--]      +-- Column instruments.coupon:
  697. [--]       Current Fieldtype: DECIMAL(5,3)
  698. [--]       Optimal Fieldtype: ENUM( ... )
  699. [--]      +-- Column instruments.instrument_group_ID:
  700. [--]       Current Fieldtype: INT(11)
  701. [--]       Optimal Fieldtype: CHAR(0)
  702. [!!] Consider changing type for column instrument_group_ID in table tradingsim.instruments
  703. [--]      +-- Column instruments.underlyings_per_contract:
  704. [--]       Current Fieldtype: INT(5) NOT NULL
  705. [--]       Optimal Fieldtype: ENUM( ... )
  706. [--]      +-- Column instruments.strike_interval:
  707. [--]       Current Fieldtype: FLOAT NOT NULL
  708. [--]       Optimal Fieldtype: ENUM( ... )
  709. [--]      +-- Column instruments.benchmark_ID:
  710. [--]       Current Fieldtype: INT(11) NOT NULL
  711. [--]       Optimal Fieldtype: ENUM( ... )
  712. [--]      +-- Column instruments.is_traded:
  713. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  714. [--]       Optimal Fieldtype: ENUM( ... )
  715. [--]      +-- Column instruments.description:
  716. [--]       Current Fieldtype: ENUM('SHARE','UNIT','BOND','OPTION','FORWARD','CONTRACT') NOT NULL
  717. [--]       Optimal Fieldtype: ENUM( ... )
  718. [--]      +-- Column instruments.price_display_convention:
  719. [--]       Current Fieldtype: ENUM('32NDS','8THS','DECIMAL') NOT NULL
  720. [--]       Optimal Fieldtype: ENUM( ... )
  721. [--]      +-- Column instruments.tradable_from_tick:
  722. [--]       Current Fieldtype: INT(11) NOT NULL
  723. [--]       Optimal Fieldtype: ENUM( ... )
  724. [--]      +-- Column instruments.tradable_to_tick:
  725. [--]       Current Fieldtype: INT(11) NOT NULL
  726. [--]       Optimal Fieldtype: ENUM( ... )
  727. [--]      +-- Column instruments.sort_order:
  728. [--]       Current Fieldtype: INT(11) NOT NULL
  729. [--]       Optimal Fieldtype: ENUM( ... )
  730. [--]      +-- Column instruments.face_value:
  731. [--]       Current Fieldtype: FLOAT
  732. [--]       Optimal Fieldtype: ENUM( ... )
  733. [--]      +-- Column instruments.frequency:
  734. [--]       Current Fieldtype: INT(4) NOT NULL
  735. [--]       Optimal Fieldtype: ENUM( ... )
  736. [--]      +-- Column instruments.issuer:
  737. [--]       Current Fieldtype: VARCHAR(10) NOT NULL
  738. [--]       Optimal Fieldtype: ENUM( ... )
  739. [--]      +-- Column instruments.number_option_strikes:
  740. [--]       Current Fieldtype: INT(11)
  741. [--]       Optimal Fieldtype: ENUM( ... )
  742. [--]      +-- Column instruments.quote_decimals:
  743. [--]       Current Fieldtype: ENUM('YES','NO')
  744. [--]       Optimal Fieldtype: ENUM( ... )
  745. [--]  +-- TABLE: instrument_chain
  746. [--]      +-- Column instrument_chain.ID:
  747. [--]       Current Fieldtype: INT(11) NOT NULL
  748. [--]       Optimal Fieldtype: ENUM( ... )
  749. [--]      +-- Column instrument_chain.name:
  750. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  751. [--]       Optimal Fieldtype: ENUM( ... )
  752. [--]      +-- Column instrument_chain.root_instrument_ID:
  753. [--]       Current Fieldtype: INT(11)
  754. [--]       Optimal Fieldtype: ENUM( ... )
  755. [--]  +-- TABLE: instrument_chain_entries
  756. [--]      +-- Column instrument_chain_entries.ID:
  757. [--]       Current Fieldtype: INT(11) NOT NULL
  758. [--]       Optimal Fieldtype: ENUM( ... )
  759. [--]      +-- Column instrument_chain_entries.instrument_chain_ID:
  760. [--]       Current Fieldtype: INT(11) NOT NULL
  761. [--]       Optimal Fieldtype: ENUM( ... )
  762. [--]      +-- Column instrument_chain_entries.instrument_ID:
  763. [--]       Current Fieldtype: INT(11) NOT NULL
  764. [--]       Optimal Fieldtype: ENUM( ... )
  765. [--]      +-- Column instrument_chain_entries.parent_instrument_ID:
  766. [--]       Current Fieldtype: INT(11)
  767. [--]       Optimal Fieldtype: ENUM( ... )
  768. [--]      +-- Column instrument_chain_entries.tick:
  769. [--]       Current Fieldtype: INT(11)
  770. [--]       Optimal Fieldtype: ENUM( ... )
  771. [--]      +-- Column instrument_chain_entries.mid_price:
  772. [--]       Current Fieldtype: DECIMAL(18,7)
  773. [--]       Optimal Fieldtype: ENUM( ... )
  774. [--]      +-- Column instrument_chain_entries.mid_currency:
  775. [--]       Current Fieldtype: DECIMAL(18,7)
  776. [--]       Optimal Fieldtype: ENUM( ... )
  777. [--]      +-- Column instrument_chain_entries.mid_yield:
  778. [--]       Current Fieldtype: DECIMAL(18,7)
  779. [--]       Optimal Fieldtype: ENUM( ... )
  780. [--]      +-- Column instrument_chain_entries.parent_mid_price:
  781. [--]       Current Fieldtype: DECIMAL(18,7)
  782. [--]       Optimal Fieldtype: ENUM( ... )
  783. [--]  +-- TABLE: instrument_groups
  784. [--]      +-- Column instrument_groups.ID:
  785. [--]       Current Fieldtype: INT(11) NOT NULL
  786. [--]      +-- Column instrument_groups.name:
  787. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  788. [--]      +-- Column instrument_groups.shortName:
  789. [--]       Current Fieldtype: VARCHAR(5) NOT NULL
  790. [--]      +-- Column instrument_groups.scenario_ID:
  791. [--]       Current Fieldtype: INT(11) NOT NULL
  792. [--]      +-- Column instrument_groups.tradable_by:
  793. [--]       Current Fieldtype: ENUM('ELECTRONIC','OUTCRY','ALL')
  794. [--]  +-- TABLE: layouts
  795. [--]      +-- Column layouts.ID:
  796. [--]       Current Fieldtype: INT(11) NOT NULL
  797. [--]       Optimal Fieldtype: ENUM( ... )
  798. [--]      +-- Column layouts.platform:
  799. [--]       Current Fieldtype: CHAR(6) NOT NULL
  800. [--]       Optimal Fieldtype: ENUM( ... )
  801. [--]      +-- Column layouts.name:
  802. [--]       Current Fieldtype: CHAR(30) NOT NULL
  803. [--]       Optimal Fieldtype: ENUM( ... )
  804. [--]  +-- TABLE: layout_details
  805. [--]      +-- Column layout_details.ID:
  806. [--]       Current Fieldtype: INT(11) NOT NULL
  807. [--]       Optimal Fieldtype: ENUM( ... )
  808. [--]      +-- Column layout_details.layout_ID:
  809. [--]       Current Fieldtype: INT(11) NOT NULL
  810. [--]       Optimal Fieldtype: ENUM( ... )
  811. [--]      +-- Column layout_details.dom_ID:
  812. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  813. [--]       Optimal Fieldtype: ENUM( ... )
  814. [--]      +-- Column layout_details.top:
  815. [--]       Current Fieldtype: INT(11) NOT NULL
  816. [--]       Optimal Fieldtype: ENUM( ... )
  817. [--]      +-- Column layout_details.lft:
  818. [--]       Current Fieldtype: INT(11) NOT NULL
  819. [--]       Optimal Fieldtype: ENUM( ... )
  820. [--]      +-- Column layout_details.height:
  821. [--]       Current Fieldtype: INT(11) NOT NULL
  822. [--]       Optimal Fieldtype: ENUM( ... )
  823. [--]      +-- Column layout_details.width:
  824. [--]       Current Fieldtype: INT(11) NOT NULL
  825. [--]       Optimal Fieldtype: ENUM( ... )
  826. [--]      +-- Column layout_details.zindex:
  827. [--]       Current Fieldtype: INT(11) NOT NULL
  828. [--]       Optimal Fieldtype: ENUM( ... )
  829. [--]      +-- Column layout_details.windowstate:
  830. [--]       Current Fieldtype: ENUM('NORMAL','MINIMIZED')
  831. [--]       Optimal Fieldtype: ENUM( ... )
  832. [--]  +-- TABLE: layout_manager
  833. [--]      +-- Column layout_manager.ID:
  834. [--]       Current Fieldtype: INT(11) NOT NULL
  835. [--]      +-- Column layout_manager.trader_ID:
  836. [--]       Current Fieldtype: INT(11) NOT NULL
  837. [--]      +-- Column layout_manager.dom_ID:
  838. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  839. [--]      +-- Column layout_manager.top:
  840. [--]       Current Fieldtype: INT(11) NOT NULL
  841. [--]      +-- Column layout_manager.lft:
  842. [--]       Current Fieldtype: INT(11) NOT NULL
  843. [--]      +-- Column layout_manager.height:
  844. [--]       Current Fieldtype: INT(11) NOT NULL
  845. [--]      +-- Column layout_manager.width:
  846. [--]       Current Fieldtype: INT(11) NOT NULL
  847. [--]      +-- Column layout_manager.zindex:
  848. [--]       Current Fieldtype: INT(11) NOT NULL
  849. [--]      +-- Column layout_manager.windowstate:
  850. [--]       Current Fieldtype: ENUM('NORMAL','MINIMIZED')
  851. [--]  +-- TABLE: links_persons_person_groups
  852. [--]      +-- Column links_persons_person_groups.ID:
  853. [--]       Current Fieldtype: INT(11) NOT NULL
  854. [--]      +-- Column links_persons_person_groups.person_ID:
  855. [--]       Current Fieldtype: INT(11) NOT NULL
  856. [--]      +-- Column links_persons_person_groups.person_group_ID:
  857. [--]       Current Fieldtype: INT(11) NOT NULL
  858. [--]  +-- TABLE: links_persons_traders
  859. [--]      +-- Column links_persons_traders.ID:
  860. [--]       Current Fieldtype: INT(11) NOT NULL
  861. [--]      +-- Column links_persons_traders.person_ID:
  862. [--]       Current Fieldtype: INT(11) NOT NULL
  863. [--]      +-- Column links_persons_traders.trader_ID:
  864. [--]       Current Fieldtype: INT(11) NOT NULL
  865. [--]      +-- Column links_persons_traders.grid:
  866. [--]       Current Fieldtype: VARCHAR(20)
  867. [--]      +-- Column links_persons_traders.sound:
  868. [--]       Current Fieldtype: ENUM('YES','NO')
  869. [--]  +-- TABLE: links_scenarios_trader_responses
  870. [--]      +-- Column links_scenarios_trader_responses.ID:
  871. [--]       Current Fieldtype: INT(11) NOT NULL
  872. [--]       Optimal Fieldtype: ENUM( ... )
  873. [--]      +-- Column links_scenarios_trader_responses.scenario_ID:
  874. [--]       Current Fieldtype: INT(11) NOT NULL
  875. [--]       Optimal Fieldtype: ENUM( ... )
  876. [--]      +-- Column links_scenarios_trader_responses.trader_response_ID:
  877. [--]       Current Fieldtype: INT(11) NOT NULL
  878. [--]       Optimal Fieldtype: ENUM( ... )
  879. [--]  +-- TABLE: liquidity_profile
  880. [--]      +-- Column liquidity_profile.ID:
  881. [--]       Current Fieldtype: INT(11) NOT NULL
  882. [--]       Optimal Fieldtype: ENUM( ... )
  883. [--]      +-- Column liquidity_profile.name:
  884. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  885. [--]       Optimal Fieldtype: ENUM( ... )
  886. [--]      +-- Column liquidity_profile.bid:
  887. [--]       Current Fieldtype: INT(11) NOT NULL
  888. [--]       Optimal Fieldtype: ENUM( ... )
  889. [--]      +-- Column liquidity_profile.offer:
  890. [--]       Current Fieldtype: INT(11) NOT NULL
  891. [--]       Optimal Fieldtype: ENUM( ... )
  892. [--]      +-- Column liquidity_profile.max_age:
  893. [--]       Current Fieldtype: INT(11) NOT NULL
  894. [--]       Optimal Fieldtype: ENUM( ... )
  895. [--]      +-- Column liquidity_profile.yield_half_spread_min:
  896. [--]       Current Fieldtype: INT(11) NOT NULL
  897. [--]       Optimal Fieldtype: ENUM( ... )
  898. [--]      +-- Column liquidity_profile.yield_half_spread_max:
  899. [--]       Current Fieldtype: INT(11) NOT NULL
  900. [--]       Optimal Fieldtype: ENUM( ... )
  901. [--]      +-- Column liquidity_profile.max_deviation:
  902. [--]       Current Fieldtype: INT(11) NOT NULL
  903. [--]       Optimal Fieldtype: ENUM( ... )
  904. [--]      +-- Column liquidity_profile.trade_with_dealers:
  905. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  906. [--]       Optimal Fieldtype: ENUM( ... )
  907. [--]      +-- Column liquidity_profile.reprice_or_cancel:
  908. [--]       Current Fieldtype: ENUM('REPRICE','CANCEL') NOT NULL
  909. [--]       Optimal Fieldtype: ENUM( ... )
  910. [--]      +-- Column liquidity_profile.lead_market:
  911. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  912. [--]       Optimal Fieldtype: ENUM( ... )
  913. [--]  +-- TABLE: maturity_limits
  914. [--]      +-- Column maturity_limits.ID:
  915. [--]       Current Fieldtype: INT(11) NOT NULL
  916. [--]      +-- Column maturity_limits.instance_ID:
  917. [--]       Current Fieldtype: INT(11) NOT NULL
  918. [--]      +-- Column maturity_limits.bond_maturity_ID:
  919. [--]       Current Fieldtype: INT(11) NOT NULL
  920. [--]      +-- Column maturity_limits.risklimit:
  921. [--]       Current Fieldtype: INT(11) NOT NULL
  922. [--]  +-- TABLE: news
  923. [--]      +-- Column news.ID:
  924. [--]       Current Fieldtype: INT(11) NOT NULL
  925. [--]       Optimal Fieldtype: ENUM( ... )
  926. [--]      +-- Column news.scenario_ID:
  927. [--]       Current Fieldtype: INT(11) NOT NULL
  928. [--]       Optimal Fieldtype: ENUM( ... )
  929. [--]      +-- Column news.title:
  930. [--]       Current Fieldtype: VARCHAR(255) NOT NULL
  931. [--]       Optimal Fieldtype: TINYTEXT NOT NULL
  932. [!!] Consider changing type for column title in table tradingsim.news
  933. [--]      +-- Column news.body:
  934. [--]       Current Fieldtype: LONGTEXT NOT NULL
  935. [--]       Optimal Fieldtype: TEXT NOT NULL
  936. [!!] Consider changing type for column body in table tradingsim.news
  937. [--]      +-- Column news.tick:
  938. [--]       Current Fieldtype: INT(11) NOT NULL
  939. [--]       Optimal Fieldtype: ENUM( ... )
  940. [--]      +-- Column news.target_trader_ID:
  941. [--]       Current Fieldtype: INT(11) NOT NULL
  942. [--]       Optimal Fieldtype: ENUM( ... )
  943. [--]      +-- Column news.type:
  944. [--]       Current Fieldtype: ENUM('','FLOW','TECHNICAL','NEWS')
  945. [--]       Optimal Fieldtype: ENUM( ... )
  946. [--]  +-- TABLE: offence_snapshot
  947. [--]      +-- Column offence_snapshot.ID:
  948. [--]       Current Fieldtype: INT(11) NOT NULL
  949. [--]      +-- Column offence_snapshot.trader_ID:
  950. [--]       Current Fieldtype: INT(11) NOT NULL
  951. [--]      +-- Column offence_snapshot.tick:
  952. [--]       Current Fieldtype: INT(11) NOT NULL
  953. [--]      +-- Column offence_snapshot.total:
  954. [--]       Current Fieldtype: INT(11) NOT NULL
  955. [--]  +-- TABLE: option_market
  956. [--]      +-- Column option_market.ID:
  957. [--]       Current Fieldtype: INT(11) NOT NULL
  958. [--]      +-- Column option_market.tick:
  959. [--]       Current Fieldtype: INT(11) NOT NULL
  960. [--]      +-- Column option_market.instance_id:
  961. [--]       Current Fieldtype: INT(11) NOT NULL
  962. [--]      +-- Column option_market.instrument_id:
  963. [--]       Current Fieldtype: INT(11) NOT NULL
  964. [--]      +-- Column option_market.strike:
  965. [--]       Current Fieldtype: INT(11) NOT NULL
  966. [--]      +-- Column option_market.expiry_month:
  967. [--]       Current Fieldtype: INT(11) NOT NULL
  968. [--]      +-- Column option_market.underlying_bid:
  969. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  970. [--]      +-- Column option_market.underlying_ask:
  971. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  972. [--]      +-- Column option_market.underlying_mid:
  973. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  974. [--]      +-- Column option_market.realized_vol:
  975. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  976. [--]      +-- Column option_market.implied_vol:
  977. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  978. [--]      +-- Column option_market.implied_vol_bid:
  979. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  980. [--]      +-- Column option_market.implied_vol_ask:
  981. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  982. [--]      +-- Column option_market.call_bid:
  983. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  984. [--]      +-- Column option_market.call_ask:
  985. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  986. [--]      +-- Column option_market.put_bid:
  987. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  988. [--]      +-- Column option_market.put_ask:
  989. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  990. [--]      +-- Column option_market.call_delta:
  991. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  992. [--]      +-- Column option_market.put_delta:
  993. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  994. [--]      +-- Column option_market.option_gamma:
  995. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  996. [--]      +-- Column option_market.call_theta:
  997. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  998. [--]      +-- Column option_market.put_theta:
  999. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1000. [--]      +-- Column option_market.option_vega:
  1001. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1002. [--]  +-- TABLE: persons
  1003. [--]      +-- Column persons.ID:
  1004. [--]       Current Fieldtype: INT(11) NOT NULL
  1005. [--]       Optimal Fieldtype: ENUM( ... )
  1006. [--]      +-- Column persons.firstname:
  1007. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1008. [--]       Optimal Fieldtype: ENUM( ... )
  1009. [--]      +-- Column persons.secondname:
  1010. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1011. [--]       Optimal Fieldtype: VARCHAR(10) NOT NULL
  1012. [!!] Consider changing type for column secondname in table tradingsim.persons
  1013. [--]      +-- Column persons.title:
  1014. [--]       Current Fieldtype: VARCHAR(100)
  1015. [--]       Optimal Fieldtype: ENUM( ... )
  1016. [--]      +-- Column persons.email_address:
  1017. [--]       Current Fieldtype: VARCHAR(100)
  1018. [--]       Optimal Fieldtype: ENUM( ... )
  1019. [--]      +-- Column persons.second_email:
  1020. [--]       Current Fieldtype: VARCHAR(100)
  1021. [--]       Optimal Fieldtype: CHAR(0)
  1022. [!!] Consider changing type for column second_email in table tradingsim.persons
  1023. [--]      +-- Column persons.work_phone:
  1024. [--]       Current Fieldtype: VARCHAR(80) NOT NULL
  1025. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  1026. [!!] Consider changing type for column work_phone in table tradingsim.persons
  1027. [--]      +-- Column persons.mobile_phone:
  1028. [--]       Current Fieldtype: VARCHAR(80) NOT NULL
  1029. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  1030. [!!] Consider changing type for column mobile_phone in table tradingsim.persons
  1031. [--]      +-- Column persons.home_phone:
  1032. [--]       Current Fieldtype: VARCHAR(80) NOT NULL
  1033. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  1034. [!!] Consider changing type for column home_phone in table tradingsim.persons
  1035. [--]      +-- Column persons.dob:
  1036. [--]       Current Fieldtype: DATE NOT NULL
  1037. [--]       Optimal Fieldtype: ENUM( ... )
  1038. [--]      +-- Column persons.username:
  1039. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1040. [--]       Optimal Fieldtype: VARCHAR(15) NOT NULL
  1041. [!!] Consider changing type for column username in table tradingsim.persons
  1042. [--]      +-- Column persons.password:
  1043. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1044. [--]       Optimal Fieldtype: ENUM( ... )
  1045. [--]      +-- Column persons.photo_url:
  1046. [--]       Current Fieldtype: VARCHAR(200) NOT NULL
  1047. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  1048. [!!] Consider changing type for column photo_url in table tradingsim.persons
  1049. [--]      +-- Column persons.joining_instructions_sent:
  1050. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1051. [--]       Optimal Fieldtype: ENUM( ... )
  1052. [--]      +-- Column persons.email_type:
  1053. [--]       Current Fieldtype: ENUM('HTML','TEXT')
  1054. [--]       Optimal Fieldtype: CHAR(0)
  1055. [!!] Consider changing type for column email_type in table tradingsim.persons
  1056. [--]      +-- Column persons.post_address_ID:
  1057. [--]       Current Fieldtype: INT(11)
  1058. [--]       Optimal Fieldtype: ENUM( ... )
  1059. [--]      +-- Column persons.fax_number:
  1060. [--]       Current Fieldtype: VARCHAR(80) NOT NULL
  1061. [--]       Optimal Fieldtype: CHAR(0) NOT NULL
  1062. [!!] Consider changing type for column fax_number in table tradingsim.persons
  1063. [--]      +-- Column persons.mts_priority:
  1064. [--]       Current Fieldtype: INT(11)
  1065. [--]       Optimal Fieldtype: CHAR(0)
  1066. [!!] Consider changing type for column mts_priority in table tradingsim.persons
  1067. [--]      +-- Column persons.emailaday_type:
  1068. [--]       Current Fieldtype: ENUM('DEFAULT','RANDOM','SELFHEALING') NOT NULL
  1069. [--]       Optimal Fieldtype: ENUM( ... )
  1070. [--]      +-- Column persons.marketing_allowed:
  1071. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1072. [--]       Optimal Fieldtype: ENUM( ... )
  1073. [--]      +-- Column persons.send_newsletter:
  1074. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1075. [--]       Optimal Fieldtype: ENUM( ... )
  1076. [--]      +-- Column persons.global_deactivate:
  1077. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1078. [--]       Optimal Fieldtype: ENUM( ... )
  1079. [--]      +-- Column persons.business_entity_ID:
  1080. [--]       Current Fieldtype: INT(11) NOT NULL
  1081. [--]       Optimal Fieldtype: ENUM( ... )
  1082. [--]      +-- Column persons.silent_login_group_ID:
  1083. [--]       Current Fieldtype: INT(11)
  1084. [--]       Optimal Fieldtype: CHAR(0)
  1085. [!!] Consider changing type for column silent_login_group_ID in table tradingsim.persons
  1086. [--]      +-- Column persons.job_area:
  1087. [--]       Current Fieldtype: VARCHAR(100)
  1088. [--]       Optimal Fieldtype: ENUM( ... )
  1089. [--]      +-- Column persons.displayCompany:
  1090. [--]       Current Fieldtype: VARCHAR(128)
  1091. [--]       Optimal Fieldtype: ENUM( ... )
  1092. [--]      +-- Column persons.marketing_feedback:
  1093. [--]       Current Fieldtype: INT(11)
  1094. [--]       Optimal Fieldtype: CHAR(0)
  1095. [!!] Consider changing type for column marketing_feedback in table tradingsim.persons
  1096. [--]      +-- Column persons.person_type:
  1097. [--]       Current Fieldtype: VARCHAR(25)
  1098. [--]       Optimal Fieldtype: CHAR(0)
  1099. [!!] Consider changing type for column person_type in table tradingsim.persons
  1100. [--]      +-- Column persons.left_company:
  1101. [--]       Current Fieldtype: DATE
  1102. [--]       Optimal Fieldtype: CHAR(0)
  1103. [!!] Consider changing type for column left_company in table tradingsim.persons
  1104. [--]      +-- Column persons.immutable_ID:
  1105. [--]       Current Fieldtype: VARCHAR(255)
  1106. [--]       Optimal Fieldtype: CHAR(0)
  1107. [!!] Consider changing type for column immutable_ID in table tradingsim.persons
  1108. [--]      +-- Column persons.media_server_ID:
  1109. [--]       Current Fieldtype: INT(11)
  1110. [--]       Optimal Fieldtype: CHAR(0)
  1111. [!!] Consider changing type for column media_server_ID in table tradingsim.persons
  1112. [--]      +-- Column persons.jobtitle:
  1113. [--]       Current Fieldtype: VARCHAR(255)
  1114. [--]       Optimal Fieldtype: CHAR(0)
  1115. [!!] Consider changing type for column jobtitle in table tradingsim.persons
  1116. [--]      +-- Column persons.rdr_training_requirements:
  1117. [--]       Current Fieldtype: ENUM('CPD','QUAL_CPD','QUAL','RDR_READY')
  1118. [--]       Optimal Fieldtype: CHAR(0)
  1119. [!!] Consider changing type for column rdr_training_requirements in table tradingsim.persons
  1120. [--]      +-- Column persons.rdr_qualifications_correct:
  1121. [--]       Current Fieldtype: ENUM('CORRECT','INCORRECT')
  1122. [--]       Optimal Fieldtype: CHAR(0)
  1123. [!!] Consider changing type for column rdr_qualifications_correct in table tradingsim.persons
  1124. [--]      +-- Column persons.rdr_study_qualifications_correct:
  1125. [--]       Current Fieldtype: ENUM('CORRECT','INCORRECT')
  1126. [--]       Optimal Fieldtype: CHAR(0)
  1127. [!!] Consider changing type for column rdr_study_qualifications_correct in table tradingsim.persons
  1128. [--]      +-- Column persons.har:
  1129. [--]       Current Fieldtype: VARCHAR(255)
  1130. [--]       Optimal Fieldtype: CHAR(0)
  1131. [!!] Consider changing type for column har in table tradingsim.persons
  1132. [--]      +-- Column persons.personal_email:
  1133. [--]       Current Fieldtype: VARCHAR(100)
  1134. [--]       Optimal Fieldtype: CHAR(0)
  1135. [!!] Consider changing type for column personal_email in table tradingsim.persons
  1136. [--]      +-- Column persons.show_mobile:
  1137. [--]       Current Fieldtype: ENUM('YES','NO')
  1138. [--]       Optimal Fieldtype: ENUM( ... )
  1139. [--]  +-- TABLE: person_groups
  1140. [--]      +-- Column person_groups.ID:
  1141. [--]       Current Fieldtype: SMALLINT(6) NOT NULL
  1142. [--]      +-- Column person_groups.type:
  1143. [--]       Current Fieldtype: ENUM('GLOBAL','COMPANY_SPECIFIC') NOT NULL
  1144. [--]      +-- Column person_groups.company_ID:
  1145. [--]       Current Fieldtype: MEDIUMINT(9) NOT NULL
  1146. [--]      +-- Column person_groups.name:
  1147. [--]       Current Fieldtype: VARCHAR(200) NOT NULL
  1148. [--]      +-- Column person_groups.show_to_training_manager:
  1149. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1150. [--]      +-- Column person_groups.created:
  1151. [--]       Current Fieldtype: TIMESTAMP NOT NULL
  1152. [--]      +-- Column person_groups.updated:
  1153. [--]       Current Fieldtype: TIMESTAMP NOT NULL
  1154. [--]      +-- Column person_groups.protected:
  1155. [--]       Current Fieldtype: ENUM('YES','NO')
  1156. [--]      +-- Column person_groups.graduate:
  1157. [--]       Current Fieldtype: ENUM('YES','NO')
  1158. [--]      +-- Column person_groups.secure:
  1159. [--]       Current Fieldtype: ENUM('YES','NO')
  1160. [--]  +-- TABLE: pl_snapshots
  1161. [--]      +-- Column pl_snapshots.ID:
  1162. [--]       Current Fieldtype: INT(11) NOT NULL
  1163. [--]      +-- Column pl_snapshots.value:
  1164. [--]       Current Fieldtype: DECIMAL(12,2) NOT NULL
  1165. [--]      +-- Column pl_snapshots.tick:
  1166. [--]       Current Fieldtype: INT(11) NOT NULL
  1167. [--]      +-- Column pl_snapshots.trader_ID:
  1168. [--]       Current Fieldtype: INT(11) NOT NULL
  1169. [--]      +-- Column pl_snapshots.realised_value:
  1170. [--]       Current Fieldtype: INT(11) NOT NULL
  1171. [--]      +-- Column pl_snapshots.unrealised_value:
  1172. [--]       Current Fieldtype: INT(11) NOT NULL
  1173. [--]      +-- Column pl_snapshots.instrument_ID:
  1174. [--]       Current Fieldtype: INT(11) NOT NULL
  1175. [--]      +-- Column pl_snapshots.cash_delta:
  1176. [--]       Current Fieldtype: INT(11) NOT NULL
  1177. [--]      +-- Column pl_snapshots.option_delta:
  1178. [--]       Current Fieldtype: INT(11) NOT NULL
  1179. [--]      +-- Column pl_snapshots.var:
  1180. [--]       Current Fieldtype: DECIMAL(18,7)
  1181. [--]  +-- TABLE: realised_pl
  1182. [--]      +-- Column realised_pl.ID:
  1183. [--]       Current Fieldtype: INT(11) NOT NULL
  1184. [--]      +-- Column realised_pl.trader_ID:
  1185. [--]       Current Fieldtype: INT(11) NOT NULL
  1186. [--]      +-- Column realised_pl.value:
  1187. [--]       Current Fieldtype: FLOAT NOT NULL
  1188. [--]      +-- Column realised_pl.currency_ID:
  1189. [--]       Current Fieldtype: INT(11) NOT NULL
  1190. [--]  +-- TABLE: risk_snapshot
  1191. [--]      +-- Column risk_snapshot.ID:
  1192. [--]       Current Fieldtype: INT(11) NOT NULL
  1193. [--]      +-- Column risk_snapshot.trader_ID:
  1194. [--]       Current Fieldtype: INT(11) NOT NULL
  1195. [--]      +-- Column risk_snapshot.bond_maturity_ID:
  1196. [--]       Current Fieldtype: INT(11) NOT NULL
  1197. [--]      +-- Column risk_snapshot.tick:
  1198. [--]       Current Fieldtype: INT(11) NOT NULL
  1199. [--]      +-- Column risk_snapshot.balance:
  1200. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1201. [--]  +-- TABLE: sales_credits
  1202. [--]      +-- Column sales_credits.ID:
  1203. [--]       Current Fieldtype: INT(11) NOT NULL
  1204. [--]      +-- Column sales_credits.trade_ID:
  1205. [--]       Current Fieldtype: INT(11) NOT NULL
  1206. [--]      +-- Column sales_credits.amount:
  1207. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1208. [--]  +-- TABLE: scenarios
  1209. [--]      +-- Column scenarios.ID:
  1210. [--]       Current Fieldtype: INT(11) NOT NULL
  1211. [--]       Optimal Fieldtype: ENUM( ... )
  1212. [--]      +-- Column scenarios.client_ID:
  1213. [--]       Current Fieldtype: INT(11)
  1214. [--]       Optimal Fieldtype: ENUM( ... )
  1215. [--]      +-- Column scenarios.name:
  1216. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1217. [--]       Optimal Fieldtype: ENUM( ... )
  1218. [--]      +-- Column scenarios.description:
  1219. [--]       Current Fieldtype: MEDIUMTEXT NOT NULL
  1220. [--]       Optimal Fieldtype: ENUM( ... )
  1221. [--]      +-- Column scenarios.start_date:
  1222. [OK] tradingsim.scenarios (start_date) type: DATETIME NOT NULL
  1223. [--]      +-- Column scenarios.tick_length:
  1224. [--]       Current Fieldtype: INT(11) NOT NULL
  1225. [--]       Optimal Fieldtype: ENUM( ... )
  1226. [--]      +-- Column scenarios.tick_number:
  1227. [--]       Current Fieldtype: INT(11) NOT NULL
  1228. [--]       Optimal Fieldtype: ENUM( ... )
  1229. [--]      +-- Column scenarios.default_currency_ID:
  1230. [--]       Current Fieldtype: INT(11) NOT NULL
  1231. [--]       Optimal Fieldtype: ENUM( ... )
  1232. [--]      +-- Column scenarios.base_currency_ID:
  1233. [--]       Current Fieldtype: INT(11) NOT NULL
  1234. [--]       Optimal Fieldtype: ENUM( ... )
  1235. [--]      +-- Column scenarios.usable:
  1236. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1237. [--]       Optimal Fieldtype: ENUM( ... )
  1238. [--]      +-- Column scenarios.option_prices_as_premiums:
  1239. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1240. [--]       Optimal Fieldtype: ENUM( ... )
  1241. [--]      +-- Column scenarios.pe_ticks_per_page:
  1242. [--]       Current Fieldtype: INT(11) NOT NULL
  1243. [--]       Optimal Fieldtype: ENUM( ... )
  1244. [--]      +-- Column scenarios.platform:
  1245. [--]       Current Fieldtype: ENUM('FI','FOREX','EQUITY','OPTION') NOT NULL
  1246. [--]       Optimal Fieldtype: ENUM( ... )
  1247. [--]      +-- Column scenarios.owner_ID:
  1248. [--]       Current Fieldtype: INT(11) NOT NULL
  1249. [--]       Optimal Fieldtype: ENUM( ... )
  1250. [--]      +-- Column scenarios.originator_ID:
  1251. [--]       Current Fieldtype: INT(11) NOT NULL
  1252. [--]       Optimal Fieldtype: ENUM( ... )
  1253. [--]      +-- Column scenarios.sound_call:
  1254. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1255. [--]       Optimal Fieldtype: ENUM( ... )
  1256. [--]      +-- Column scenarios.sound_headline:
  1257. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1258. [--]       Optimal Fieldtype: ENUM( ... )
  1259. [--]      +-- Column scenarios.sound_technical:
  1260. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1261. [--]       Optimal Fieldtype: ENUM( ... )
  1262. [--]      +-- Column scenarios.sound_flow:
  1263. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1264. [--]       Optimal Fieldtype: ENUM( ... )
  1265. [--]      +-- Column scenarios.sound_news:
  1266. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1267. [--]       Optimal Fieldtype: ENUM( ... )
  1268. [--]      +-- Column scenarios.on_the_run:
  1269. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  1270. [--]       Optimal Fieldtype: ENUM( ... )
  1271. [--]      +-- Column scenarios.reissue_period:
  1272. [--]       Current Fieldtype: INT(11) NOT NULL
  1273. [--]       Optimal Fieldtype: ENUM( ... )
  1274. [--]  +-- TABLE: scheduled_trades
  1275. [--]      +-- Column scheduled_trades.ID:
  1276. [--]       Current Fieldtype: INT(11) NOT NULL
  1277. [--]      +-- Column scheduled_trades.initiating_trader_ID:
  1278. [--]       Current Fieldtype: INT(11) NOT NULL
  1279. [--]      +-- Column scheduled_trades.price:
  1280. [--]       Current Fieldtype: DECIMAL(10,3) NOT NULL
  1281. [--]      +-- Column scheduled_trades.quantity:
  1282. [--]       Current Fieldtype: INT(11) NOT NULL
  1283. [--]      +-- Column scheduled_trades.instrument_ID:
  1284. [--]       Current Fieldtype: INT(11) NOT NULL
  1285. [--]      +-- Column scheduled_trades.tick_to_trade:
  1286. [--]       Current Fieldtype: INT(11) NOT NULL
  1287. [--]      +-- Column scheduled_trades.instance_ID:
  1288. [--]       Current Fieldtype: INT(11) NOT NULL
  1289. [--]      +-- Column scheduled_trades.call_put:
  1290. [--]       Current Fieldtype: ENUM('PUT','CALL') NOT NULL
  1291. [--]      +-- Column scheduled_trades.expiry:
  1292. [--]       Current Fieldtype: INT(11) NOT NULL
  1293. [--]  +-- TABLE: stored_paths
  1294. [--]      +-- Column stored_paths.ID:
  1295. [--]       Current Fieldtype: INT(11) NOT NULL
  1296. [--]       Optimal Fieldtype: ENUM( ... )
  1297. [--]      +-- Column stored_paths.scenario_ID:
  1298. [--]       Current Fieldtype: INT(11) NOT NULL
  1299. [--]       Optimal Fieldtype: ENUM( ... )
  1300. [--]      +-- Column stored_paths.name:
  1301. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  1302. [--]       Optimal Fieldtype: ENUM( ... )
  1303. [--]  +-- TABLE: stored_paths2
  1304. [--]      +-- Column stored_paths2.ID:
  1305. [--]       Current Fieldtype: INT(11) NOT NULL
  1306. [--]      +-- Column stored_paths2.scenario_ID:
  1307. [--]       Current Fieldtype: INT(11) NOT NULL
  1308. [--]      +-- Column stored_paths2.name:
  1309. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  1310. [--]      +-- Column stored_paths2.instrument_type:
  1311. [--]       Current Fieldtype: VARCHAR(30) NOT NULL
  1312. [--]      +-- Column stored_paths2.instrument_ID:
  1313. [--]       Current Fieldtype: INT(11) NOT NULL
  1314. [--]  +-- TABLE: stored_path_data
  1315. [--]      +-- Column stored_path_data.ID:
  1316. [--]       Current Fieldtype: INT(11) NOT NULL
  1317. [--]       Optimal Fieldtype: MEDIUMINT(7) UNSIGNED NOT NULL
  1318. [!!] Consider changing type for column ID in table tradingsim.stored_path_data
  1319. [--]      +-- Column stored_path_data.stored_path_ID:
  1320. [--]       Current Fieldtype: INT(11) NOT NULL
  1321. [--]       Optimal Fieldtype: ENUM( ... )
  1322. [--]      +-- Column stored_path_data.tick:
  1323. [--]       Current Fieldtype: INT(11) NOT NULL
  1324. [--]       Optimal Fieldtype: ENUM( ... )
  1325. [--]      +-- Column stored_path_data.value:
  1326. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1327. [--]       Optimal Fieldtype: DECIMAL(18, 7) NOT NULL
  1328. [!!] Consider changing type for column value in table tradingsim.stored_path_data
  1329. [--]      +-- Column stored_path_data.type:
  1330. [--]       Current Fieldtype: ENUM('INTERPOLATED','MANUAL') NOT NULL
  1331. [--]       Optimal Fieldtype: ENUM( ... )
  1332. [--]  +-- TABLE: stored_path_data2
  1333. [--]      +-- Column stored_path_data2.ID:
  1334. [--]       Current Fieldtype: INT(11) NOT NULL
  1335. [--]      +-- Column stored_path_data2.stored_path_ID:
  1336. [--]       Current Fieldtype: INT(11) NOT NULL
  1337. [--]      +-- Column stored_path_data2.tick:
  1338. [--]       Current Fieldtype: INT(11) NOT NULL
  1339. [--]      +-- Column stored_path_data2.value:
  1340. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1341. [--]      +-- Column stored_path_data2.type:
  1342. [--]       Current Fieldtype: ENUM('INTERPOLATED','MANUAL') NOT NULL
  1343. [--]  +-- TABLE: system_logins
  1344. [--]      +-- Column system_logins.person_ID:
  1345. [--]       Current Fieldtype: INT(11) NOT NULL
  1346. [--]      +-- Column system_logins.logon_time:
  1347. [--]       Current Fieldtype: DATETIME NOT NULL
  1348. [--]  +-- TABLE: system_performance
  1349. [--]      +-- Column system_performance.ID:
  1350. [--]       Current Fieldtype: INT(11) NOT NULL
  1351. [--]      +-- Column system_performance.person_ID:
  1352. [--]       Current Fieldtype: INT(11)
  1353. [--]      +-- Column system_performance.page:
  1354. [--]       Current Fieldtype: VARCHAR(255) NOT NULL
  1355. [--]      +-- Column system_performance.time_start:
  1356. [--]       Current Fieldtype: DOUBLE NOT NULL
  1357. [--]      +-- Column system_performance.time_end:
  1358. [--]       Current Fieldtype: DOUBLE
  1359. [--]  +-- TABLE: system_settings
  1360. [--]      +-- Column system_settings.ID:
  1361. [--]       Current Fieldtype: INT(11) NOT NULL
  1362. [--]       Optimal Fieldtype: ENUM( ... )
  1363. [--]      +-- Column system_settings.name:
  1364. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  1365. [--]       Optimal Fieldtype: ENUM( ... )
  1366. [--]      +-- Column system_settings.value:
  1367. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  1368. [--]       Optimal Fieldtype: ENUM( ... )
  1369. [--]  +-- TABLE: traders
  1370. [--]      +-- Column traders.ID:
  1371. [--]       Current Fieldtype: INT(11) NOT NULL
  1372. [--]      +-- Column traders.instance_ID:
  1373. [--]       Current Fieldtype: INT(11) NOT NULL
  1374. [--]      +-- Column traders.name:
  1375. [--]       Current Fieldtype: VARCHAR(50) NOT NULL
  1376. [--]      +-- Column traders.description:
  1377. [--]       Current Fieldtype: VARCHAR(255)
  1378. [--]      +-- Column traders.type:
  1379. [--]       Current Fieldtype: ENUM('HUMAN','COMPUTER') NOT NULL
  1380. [--]      +-- Column traders.buyside:
  1381. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1382. [--]      +-- Column traders.marketmaker:
  1383. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1384. [--]      +-- Column traders.tick_joined:
  1385. [--]       Current Fieldtype: INT(11) NOT NULL
  1386. [--]      +-- Column traders.flow_spread_tolerance:
  1387. [--]       Current Fieldtype: INT(11) NOT NULL
  1388. [--]      +-- Column traders.dealer_spread_tolerance:
  1389. [--]       Current Fieldtype: INT(11) NOT NULL
  1390. [--]      +-- Column traders.sub_type:
  1391. [--]       Current Fieldtype: ENUM('DEALER','IDB')
  1392. [--]      +-- Column traders.response_notional_sensitivity:
  1393. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1394. [--]      +-- Column traders.response_flow_tolerance:
  1395. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1396. [--]      +-- Column traders.response_maturity_sensitivity:
  1397. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1398. [--]      +-- Column traders.response_improvement_half_spread:
  1399. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1400. [--]      +-- Column traders.response_offence_tolerance:
  1401. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1402. [--]      +-- Column traders.response_favour_tolerance:
  1403. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1404. [--]      +-- Column traders.use_stop_limits:
  1405. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1406. [--]      +-- Column traders.current_bias:
  1407. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1408. [--]      +-- Column traders.deviation_bias:
  1409. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1410. [--]      +-- Column traders.target_bias:
  1411. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1412. [--]      +-- Column traders.current_width:
  1413. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1414. [--]      +-- Column traders.deviation_width:
  1415. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1416. [--]      +-- Column traders.target_width:
  1417. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1418. [--]      +-- Column traders.color:
  1419. [--]       Current Fieldtype: CHAR(6)
  1420. [--]  +-- TABLE: trader_relationship
  1421. [--]      +-- Column trader_relationship.ID:
  1422. [--]       Current Fieldtype: INT(11) NOT NULL
  1423. [--]      +-- Column trader_relationship.computer_trader_ID:
  1424. [--]       Current Fieldtype: INT(11) NOT NULL
  1425. [--]      +-- Column trader_relationship.human_trader_ID:
  1426. [--]       Current Fieldtype: INT(11) NOT NULL
  1427. [--]      +-- Column trader_relationship.offence_count:
  1428. [--]       Current Fieldtype: INT(11) NOT NULL
  1429. [--]  +-- TABLE: trader_responses
  1430. [--]      +-- Column trader_responses.ID:
  1431. [--]       Current Fieldtype: INT(11) NOT NULL
  1432. [--]       Optimal Fieldtype: ENUM( ... )
  1433. [--]      +-- Column trader_responses.platform:
  1434. [--]       Current Fieldtype: ENUM('FI','FOREX','EQUITY','OPTION') NOT NULL
  1435. [--]       Optimal Fieldtype: ENUM( ... )
  1436. [--]      +-- Column trader_responses.trade_type:
  1437. [--]       Current Fieldtype: ENUM('CLIENTINBOUND','CLIENTOUTBOUND','DEALERINBOUND','DEALEROUTBOUND','BROKERINBOUND','BROKEROUTBOUND','HUMANOUTCRY') NOT NULL
  1438. [--]       Optimal Fieldtype: ENUM( ... )
  1439. [--]      +-- Column trader_responses.stage:
  1440. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1441. [--]       Optimal Fieldtype: ENUM( ... )
  1442. [--]      +-- Column trader_responses.response:
  1443. [--]       Current Fieldtype: VARCHAR(250) NOT NULL
  1444. [--]       Optimal Fieldtype: ENUM( ... )
  1445. [--]      +-- Column trader_responses.instance_ID:
  1446. [--]       Current Fieldtype: INT(11)
  1447. [--]       Optimal Fieldtype: CHAR(0)
  1448. [!!] Consider changing type for column instance_ID in table tradingsim.trader_responses
  1449. [--]      +-- Column trader_responses.use_not_offended:
  1450. [--]       Current Fieldtype: ENUM('YES','NO')
  1451. [--]       Optimal Fieldtype: ENUM( ... )
  1452. [--]      +-- Column trader_responses.use_offended:
  1453. [--]       Current Fieldtype: ENUM('NO','YES')
  1454. [--]       Optimal Fieldtype: ENUM( ... )
  1455. [--]  +-- TABLE: trader_toasts
  1456. [--]      +-- Column trader_toasts.ID:
  1457. [--]       Current Fieldtype: INT(11) NOT NULL
  1458. [--]      +-- Column trader_toasts.trader_ID:
  1459. [--]       Current Fieldtype: INT(11) NOT NULL
  1460. [--]      +-- Column trader_toasts.title:
  1461. [--]       Current Fieldtype: VARCHAR(100) NOT NULL
  1462. [--]      +-- Column trader_toasts.message:
  1463. [--]       Current Fieldtype: TEXT
  1464. [--]      +-- Column trader_toasts.style:
  1465. [--]       Current Fieldtype: ENUM('INFO','ERROR','SUCCESS','NOTICE')
  1466. [--]      +-- Column trader_toasts.trade_ID:
  1467. [--]       Current Fieldtype: INT(11) NOT NULL
  1468. [--]      +-- Column trader_toasts.tick_generated:
  1469. [--]       Current Fieldtype: INT(11)
  1470. [--]      +-- Column trader_toasts.tick_confirmed:
  1471. [--]       Current Fieldtype: INT(11)
  1472. [--]      +-- Column trader_toasts.width:
  1473. [--]       Current Fieldtype: INT(11)
  1474. [--]      +-- Column trader_toasts.sticky:
  1475. [--]       Current Fieldtype: ENUM('YES','NO')
  1476. [--]  +-- TABLE: trades
  1477. [--]      +-- Column trades.ID:
  1478. [--]       Current Fieldtype: INT(11) NOT NULL
  1479. [--]      +-- Column trades.type:
  1480. [--]       Current Fieldtype: ENUM('QUOTE','OUTCRY','CLIENT','NULL','CONDITIONAL','DEALERQUOTE') NOT NULL
  1481. [--]      +-- Column trades.initiating_trader_ID:
  1482. [--]       Current Fieldtype: INT(11)
  1483. [--]      +-- Column trades.counterparty_trader_ID:
  1484. [--]       Current Fieldtype: INT(11)
  1485. [--]      +-- Column trades.instrument_ID:
  1486. [--]       Current Fieldtype: INT(11)
  1487. [--]      +-- Column trades.request_quantity:
  1488. [--]       Current Fieldtype: INT(11)
  1489. [--]      +-- Column trades.request_price:
  1490. [--]       Current Fieldtype: DECIMAL(18,7)
  1491. [--]      +-- Column trades.request_price_type:
  1492. [--]       Current Fieldtype: ENUM('MARKET','MIDMARKET','BETTERTHAN') NOT NULL
  1493. [--]      +-- Column trades.strike:
  1494. [--]       Current Fieldtype: DECIMAL(18,7)
  1495. [--]      +-- Column trades.expiry:
  1496. [--]       Current Fieldtype: INT(11)
  1497. [--]      +-- Column trades.call_put:
  1498. [--]       Current Fieldtype: ENUM('CALL','PUT') NOT NULL
  1499. [--]      +-- Column trades.with_delta:
  1500. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1501. [--]      +-- Column trades.tick_initiated:
  1502. [--]       Current Fieldtype: INT(11) NOT NULL
  1503. [--]      +-- Column trades.time_initiated:
  1504. [--]       Current Fieldtype: DATETIME NOT NULL
  1505. [--]      +-- Column trades.counterparty_quoted:
  1506. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1507. [--]      +-- Column trades.quote_quantity:
  1508. [--]       Current Fieldtype: INT(11) NOT NULL
  1509. [--]      +-- Column trades.tick_quoted:
  1510. [--]       Current Fieldtype: INT(11) NOT NULL
  1511. [--]      +-- Column trades.time_quoted:
  1512. [--]       Current Fieldtype: DATETIME NOT NULL
  1513. [--]      +-- Column trades.bid_price:
  1514. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1515. [--]      +-- Column trades.offer_price:
  1516. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1517. [--]      +-- Column trades.trader_answered:
  1518. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1519. [--]      +-- Column trades.tick_answered:
  1520. [--]       Current Fieldtype: INT(11) NOT NULL
  1521. [--]      +-- Column trades.time_answered:
  1522. [--]       Current Fieldtype: DATETIME NOT NULL
  1523. [--]      +-- Column trades.trade_quantity:
  1524. [--]       Current Fieldtype: INT(11) NOT NULL
  1525. [--]      +-- Column trades.initiating_shown_conf:
  1526. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1527. [--]      +-- Column trades.counterparty_shown_conf:
  1528. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1529. [--]      +-- Column trades.version:
  1530. [--]       Current Fieldtype: INT(11) NOT NULL
  1531. [--]      +-- Column trades.active:
  1532. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1533. [--]      +-- Column trades.cancelled:
  1534. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1535. [--]      +-- Column trades.cancelled_reason:
  1536. [--]       Current Fieldtype: ENUM('TIMEDOUT','REQUESTED') NOT NULL
  1537. [--]      +-- Column trades.cancelled_by:
  1538. [--]       Current Fieldtype: ENUM('INIT','CP') NOT NULL
  1539. [--]      +-- Column trades.time_inactive:
  1540. [--]       Current Fieldtype: DATETIME NOT NULL
  1541. [--]      +-- Column trades.bid_premium:
  1542. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1543. [--]      +-- Column trades.offer_premium:
  1544. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1545. [--]      +-- Column trades.quote_offended:
  1546. [--]       Current Fieldtype: ENUM('NO','YES') NOT NULL
  1547. [--]      +-- Column trades.dealer_width:
  1548. [--]       Current Fieldtype: ENUM('NARROW','WIDE') NOT NULL
  1549. [--]      +-- Column trades.request_quantity_type:
  1550. [--]       Current Fieldtype: ENUM('','NOTIONAL','DV01')
  1551. [--]  +-- TABLE: trade_conversations
  1552. [--]      +-- Column trade_conversations.trade_ID:
  1553. [--]       Current Fieldtype: INT(11) NOT NULL
  1554. [--]      +-- Column trade_conversations.trade_type:
  1555. [--]       Current Fieldtype: ENUM('CLIENTINBOUND','CLIENTOUTBOUND','DEALERINBOUND','DEALEROUTBOUND','BROKERINBOUND','BROKEROUTBOUND','HUMANOUTCRY') NOT NULL
  1556. [--]      +-- Column trade_conversations.stage:
  1557. [--]       Current Fieldtype: VARCHAR(20) NOT NULL
  1558. [--]      +-- Column trade_conversations.message_ID:
  1559. [--]       Current Fieldtype: INT(11)
  1560. [--]      +-- Column trade_conversations.ringing:
  1561. [--]       Current Fieldtype: ENUM('YES','NO')
  1562. [--]      +-- Column trade_conversations.improve:
  1563. [--]       Current Fieldtype: ENUM('YES','NO') NOT NULL
  1564. [--]      +-- Column trade_conversations.working_order_ID:
  1565. [--]       Current Fieldtype: INT(11)
  1566. [--]  +-- TABLE: typos
  1567. [--]      +-- Column typos.ID:
  1568. [--]       Current Fieldtype: INT(11) NOT NULL
  1569. [--]      +-- Column typos.trader_ID:
  1570. [--]       Current Fieldtype: INT(11) NOT NULL
  1571. [--]      +-- Column typos.tick_occured:
  1572. [--]       Current Fieldtype: INT(11) NOT NULL
  1573. [--]      +-- Column typos.time_occured:
  1574. [--]       Current Fieldtype: DATETIME NOT NULL
  1575. [--]  +-- TABLE: wizard
  1576. [--]      +-- Column wizard.ID:
  1577. [--]       Current Fieldtype: INT(11) NOT NULL
  1578. [--]       Optimal Fieldtype: ENUM( ... )
  1579. [--]      +-- Column wizard.platform:
  1580. [--]       Current Fieldtype: ENUM('FI','FOREX','EQUITY','OPTION') NOT NULL
  1581. [--]       Optimal Fieldtype: ENUM( ... )
  1582. [--]      +-- Column wizard.scenario_ID:
  1583. [--]       Current Fieldtype: INT(11)
  1584. [--]       Optimal Fieldtype: ENUM( ... )
  1585. [--]      +-- Column wizard.page:
  1586. [--]       Current Fieldtype: INT(11) NOT NULL
  1587. [--]       Optimal Fieldtype: ENUM( ... )
  1588. [--]      +-- Column wizard.sort_order:
  1589. [--]       Current Fieldtype: INT(11) NOT NULL
  1590. [--]       Optimal Fieldtype: ENUM( ... )
  1591. [--]      +-- Column wizard.fieldname:
  1592. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  1593. [--]       Optimal Fieldtype: ENUM( ... )
  1594. [--]      +-- Column wizard.fieldlabel:
  1595. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  1596. [--]       Optimal Fieldtype: ENUM( ... )
  1597. [--]      +-- Column wizard.fieldvalue:
  1598. [--]       Current Fieldtype: VARCHAR(40) NOT NULL
  1599. [--]       Optimal Fieldtype: ENUM( ... )
  1600. [--]      +-- Column wizard.visible:
  1601. [--]       Current Fieldtype: ENUM('YES','NO')
  1602. [--]       Optimal Fieldtype: ENUM( ... )
  1603. [--]      +-- Column wizard.editable:
  1604. [--]       Current Fieldtype: ENUM('YES','NO')
  1605. [--]       Optimal Fieldtype: ENUM( ... )
  1606. [--]      +-- Column wizard.description:
  1607. [--]       Current Fieldtype: TEXT
  1608. [--]       Optimal Fieldtype: ENUM( ... )
  1609. [--]  +-- TABLE: working_orders
  1610. [--]      +-- Column working_orders.ID:
  1611. [--]       Current Fieldtype: INT(11) NOT NULL
  1612. [--]      +-- Column working_orders.trader_ID:
  1613. [--]       Current Fieldtype: INT(11) NOT NULL
  1614. [--]      +-- Column working_orders.client_trader_ID:
  1615. [--]       Current Fieldtype: INT(11)
  1616. [--]      +-- Column working_orders.instrument_ID:
  1617. [--]       Current Fieldtype: INT(11) NOT NULL
  1618. [--]      +-- Column working_orders.qty:
  1619. [--]       Current Fieldtype: INT(11) NOT NULL
  1620. [--]      +-- Column working_orders.price_requested:
  1621. [--]       Current Fieldtype: DECIMAL(18,7)
  1622. [--]      +-- Column working_orders.yield_requested:
  1623. [--]       Current Fieldtype: DECIMAL(18,7)
  1624. [--]      +-- Column working_orders.fix:
  1625. [--]       Current Fieldtype: ENUM('PRICE','YIELD') NOT NULL
  1626. [--]      +-- Column working_orders.qty_remaining:
  1627. [--]       Current Fieldtype: INT(11) NOT NULL
  1628. [--]      +-- Column working_orders.tick_placed:
  1629. [--]       Current Fieldtype: INT(11) NOT NULL
  1630. [--]  +-- TABLE: working_order_trades
  1631. [--]      +-- Column working_order_trades.ID:
  1632. [--]       Current Fieldtype: INT(11) NOT NULL
  1633. [--]      +-- Column working_order_trades.working_order_ID:
  1634. [--]       Current Fieldtype: INT(11) NOT NULL
  1635. [--]      +-- Column working_order_trades.trade_ID:
  1636. [--]       Current Fieldtype: INT(11) NOT NULL
  1637. [--]  +-- TABLE: yield_curve
  1638. [--]      +-- Column yield_curve.ID:
  1639. [--]       Current Fieldtype: INT(11) NOT NULL
  1640. [--]       Optimal Fieldtype: ENUM( ... )
  1641. [--]      +-- Column yield_curve.scenario_ID:
  1642. [--]       Current Fieldtype: INT(11) NOT NULL
  1643. [--]       Optimal Fieldtype: ENUM( ... )
  1644. [--]      +-- Column yield_curve.day:
  1645. [--]       Current Fieldtype: INT(11) NOT NULL
  1646. [--]       Optimal Fieldtype: ENUM( ... )
  1647. [--]      +-- Column yield_curve.yield1m:
  1648. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1649. [--]       Optimal Fieldtype: ENUM( ... )
  1650. [--]      +-- Column yield_curve.yield3m:
  1651. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1652. [--]       Optimal Fieldtype: ENUM( ... )
  1653. [--]      +-- Column yield_curve.yield6m:
  1654. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1655. [--]       Optimal Fieldtype: ENUM( ... )
  1656. [--]      +-- Column yield_curve.yield1y:
  1657. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1658. [--]       Optimal Fieldtype: ENUM( ... )
  1659. [--]      +-- Column yield_curve.yield2y:
  1660. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1661. [--]       Optimal Fieldtype: ENUM( ... )
  1662. [--]      +-- Column yield_curve.yield3y:
  1663. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1664. [--]       Optimal Fieldtype: ENUM( ... )
  1665. [--]      +-- Column yield_curve.yield5y:
  1666. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1667. [--]       Optimal Fieldtype: ENUM( ... )
  1668. [--]      +-- Column yield_curve.yield7y:
  1669. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1670. [--]       Optimal Fieldtype: ENUM( ... )
  1671. [--]      +-- Column yield_curve.yield10y:
  1672. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1673. [--]       Optimal Fieldtype: ENUM( ... )
  1674. [--]      +-- Column yield_curve.yield20y:
  1675. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1676. [--]       Optimal Fieldtype: ENUM( ... )
  1677. [--]      +-- Column yield_curve.yield30y:
  1678. [--]       Current Fieldtype: DECIMAL(18,7) NOT NULL
  1679. [--]       Optimal Fieldtype: ENUM( ... )
  1680.  
  1681. -------- Indexes Metrics ---------------------------------------------------------------------------
  1682. [--] Worst selectivity indexes:
  1683. [--] Index: post_address_ID(post_address_ID)
  1684. [--]  +-- COLUMN      : tradingsim.persons
  1685. [--]  +-- NB SEQS     : 1 sequence(s)
  1686. [--]  +-- NB COLS     : 1 column(s)
  1687. [--]  +-- CARDINALITY : 1 distinct values
  1688. [--]  +-- NB ROWS     : 806 rows
  1689. [--]  +-- TYPE        : BTREE
  1690. [--]  +-- SELECTIVITY : 0.12%
  1691. [!!] post_address_ID(post_address_ID) has a low selectivity
  1692. [--] Index: cID(currency_ID)
  1693. [--]  +-- COLUMN      : tradingsim.forward_rates
  1694. [--]  +-- NB SEQS     : 1 sequence(s)
  1695. [--]  +-- NB COLS     : 1 column(s)
  1696. [--]  +-- CARDINALITY : 10 distinct values
  1697. [--]  +-- NB ROWS     : 3600 rows
  1698. [--]  +-- TYPE        : BTREE
  1699. [--]  +-- SELECTIVITY : 0.28%
  1700. [!!] cID(currency_ID) has a low selectivity
  1701. [--] Index: firstname(firstname)
  1702. [--]  +-- COLUMN      : tradingsim.persons
  1703. [--]  +-- NB SEQS     : 1 sequence(s)
  1704. [--]  +-- NB COLS     : 1 column(s)
  1705. [--]  +-- CARDINALITY : 7 distinct values
  1706. [--]  +-- NB ROWS     : 806 rows
  1707. [--]  +-- TYPE        : BTREE
  1708. [--]  +-- SELECTIVITY : 0.87%
  1709. [!!] firstname(firstname) has a low selectivity
  1710. [--] Index: passthrough(scenario_ID)
  1711. [--]  +-- COLUMN      : tradingsim.links_scenarios_trader_responses
  1712. [--]  +-- NB SEQS     : 1 sequence(s)
  1713. [--]  +-- NB COLS     : 2 column(s)
  1714. [--]  +-- CARDINALITY : 4 distinct values
  1715. [--]  +-- NB ROWS     : 172 rows
  1716. [--]  +-- TYPE        : BTREE
  1717. [--]  +-- SELECTIVITY : 2.33%
  1718. [!!] passthrough(scenario_ID) has a low selectivity
  1719. [--] Index: scenarioId(scenario_ID)
  1720. [--]  +-- COLUMN      : tradingsim.news
  1721. [--]  +-- NB SEQS     : 1 sequence(s)
  1722. [--]  +-- NB COLS     : 1 column(s)
  1723. [--]  +-- CARDINALITY : 72 distinct values
  1724. [--]  +-- NB ROWS     : 3062 rows
  1725. [--]  +-- TYPE        : BTREE
  1726. [--]  +-- SELECTIVITY : 2.35%
  1727. [!!] scenarioId(scenario_ID) has a low selectivity
  1728. [--] Index: scenario_ID(scenario_ID)
  1729. [--]  +-- COLUMN      : tradingsim.bond_maturities
  1730. [--]  +-- NB SEQS     : 1 sequence(s)
  1731. [--]  +-- NB COLS     : 1 column(s)
  1732. [--]  +-- CARDINALITY : 4 distinct values
  1733. [--]  +-- NB ROWS     : 48 rows
  1734. [--]  +-- TYPE        : BTREE
  1735. [--]  +-- SELECTIVITY : 8.33%
  1736. [!!] scenario_ID(scenario_ID) has a low selectivity
  1737. [--] Index: tick(tick)
  1738. [--]  +-- COLUMN      : tradingsim.forward_rates
  1739. [--]  +-- NB SEQS     : 1 sequence(s)
  1740. [--]  +-- NB COLS     : 1 column(s)
  1741. [--]  +-- CARDINALITY : 360 distinct values
  1742. [--]  +-- NB ROWS     : 3600 rows
  1743. [--]  +-- TYPE        : BTREE
  1744. [--]  +-- SELECTIVITY : 10.00%
  1745. [!!] tick(tick) has a low selectivity
  1746. [--] Index: scenarioId(scenario_ID)
  1747. [--]  +-- COLUMN      : tradingsim.instruments
  1748. [--]  +-- NB SEQS     : 1 sequence(s)
  1749. [--]  +-- NB COLS     : 1 column(s)
  1750. [--]  +-- CARDINALITY : 74 distinct values
  1751. [--]  +-- NB ROWS     : 570 rows
  1752. [--]  +-- TYPE        : BTREE
  1753. [--]  +-- SELECTIVITY : 12.98%
  1754. [!!] scenarioId(scenario_ID) has a low selectivity
  1755. [--] Index: tick(tick)
  1756. [--]  +-- COLUMN      : tradingsim.news
  1757. [--]  +-- NB SEQS     : 1 sequence(s)
  1758. [--]  +-- NB COLS     : 1 column(s)
  1759. [--]  +-- CARDINALITY : 517 distinct values
  1760. [--]  +-- NB ROWS     : 3062 rows
  1761. [--]  +-- TYPE        : BTREE
  1762. [--]  +-- SELECTIVITY : 16.88%
  1763. [!!] tick(tick) has a low selectivity
  1764. [--] Index: dom_ID(dom_ID)
  1765. [--]  +-- COLUMN      : tradingsim.layout_details
  1766. [--]  +-- NB SEQS     : 1 sequence(s)
  1767. [--]  +-- NB COLS     : 1 column(s)
  1768. [--]  +-- CARDINALITY : 10 distinct values
  1769. [--]  +-- NB ROWS     : 40 rows
  1770. [--]  +-- TYPE        : BTREE
  1771. [--]  +-- SELECTIVITY : 25.00%
  1772. [--] Unused indexes:
  1773. [!!] Index: tick_broken on tradingsim.broken_limits is not used.
  1774. [!!] Index: trader_ID on tradingsim.broken_limits is not used.
  1775. [!!] Index: tick_fixed on tradingsim.broken_limits is not used.
  1776. [!!] Index: trader_ID on tradingsim.call_log is not used.
  1777. [!!] Index: tick on tradingsim.call_log is not used.
  1778. [!!] Index: trade_master_ID on tradingsim.conditional_trades is not used.
  1779. [!!] Index: trade_leg_ID on tradingsim.conditional_trades is not used.
  1780. [!!] Index: trader_ID on tradingsim.current_accounts is not used.
  1781. [!!] Index: currency_ID on tradingsim.current_accounts is not used.
  1782. [!!] Index: tick on tradingsim.current_accounts is not used.
  1783. [!!] Index: instance_ID on tradingsim.event_log is not used.
  1784. [!!] Index: instrumentId on tradingsim.held_instruments is not used.
  1785. [!!] Index: counterparty_trader_ID on tradingsim.held_instruments is not used.
  1786. [!!] Index: traderId on tradingsim.held_instruments is not used.
  1787. [!!] Index: dom_ID on tradingsim.layout_manager is not used.
  1788. [!!] Index: trader_ID on tradingsim.layout_manager is not used.
  1789. [!!] Index: uni on tradingsim.links_persons_person_groups is not used.
  1790. [!!] Index: person_ID on tradingsim.links_persons_traders is not used.
  1791. [!!] Index: trader_ID on tradingsim.links_persons_traders is not used.
  1792. [!!] Index: bond_maturity_ID on tradingsim.maturity_limits is not used.
  1793. [!!] Index: trader_ID on tradingsim.offence_snapshot is not used.
  1794. [!!] Index: tick on tradingsim.offence_snapshot is not used.
  1795. [!!] Index: tick on tradingsim.option_market is not used.
  1796. [!!] Index: tick_2 on tradingsim.option_market is not used.
  1797. [!!] Index: instrument_id on tradingsim.option_market is not used.
  1798. [!!] Index: company_ID on tradingsim.person_groups is not used.
  1799. [!!] Index: trader_ID on tradingsim.risk_snapshot is not used.
  1800. [!!] Index: bond_maturity_ID on tradingsim.risk_snapshot is not used.
  1801. [!!] Index: trade_ID on tradingsim.sales_credits is not used.
  1802. [!!] Index: instance_ID on tradingsim.scheduled_trades is not used.
  1803. [!!] Index: scenarioId on tradingsim.stored_paths2 is not used.
  1804. [!!] Index: compound on tradingsim.stored_path_data2 is not used.
  1805. [!!] Index: tick on tradingsim.stored_path_data2 is not used.
  1806. [!!] Index: person on tradingsim.system_logins is not used.
  1807. [!!] Index: page on tradingsim.system_performance is not used.
  1808. [!!] Index: person_ID on tradingsim.system_performance is not used.
  1809. [!!] Index: instance_ID on tradingsim.traders is not used.
  1810. [!!] Index: computer_trader_ID on tradingsim.trader_relationship is not used.
  1811. [!!] Index: initiatingTraderId on tradingsim.trades is not used.
  1812. [!!] Index: counterpartyTraderId on tradingsim.trades is not used.
  1813. [!!] Index: instrumentId on tradingsim.trades is not used.
  1814. [!!] Index: tickMade on tradingsim.trades is not used.
  1815. [!!] Index: trader_ID on tradingsim.typos is not used.
  1816. [!!] Index: tick_occured on tradingsim.typos is not used.
  1817. [!!] Index: trader_ID on tradingsim.working_orders is not used.
  1818. [!!] Index: client_trader_ID on tradingsim.working_orders is not used.
  1819. [!!] Index: working_order_ID on tradingsim.working_order_trades is not used.
  1820. [!!] Index: trade_ID on tradingsim.working_order_trades is not used.
  1821.  
  1822. -------- Security Recommendations ------------------------------------------------------------------
  1823. [OK] There are no anonymous accounts for any database users
  1824. [OK] All database users have passwords assigned
  1825. [!!] User 'simulations@%' does not specify hostname restrictions.
  1826. [!!] There is no basic password file list!
  1827.  
  1828. -------- CVE Security Recommendations --------------------------------------------------------------
  1829. [--] Skipped due to --cvefile option undefined
  1830.  
  1831. -------- Performance Metrics -----------------------------------------------------------------------
  1832. [--] Up for: 2h 52m 46s (48K q [4.720 qps], 1K conn, TX: 156M, RX: 12M)
  1833. [--] Reads / Writes: 100% / 0%
  1834. [--] Binary logging is disabled
  1835. [--] Physical Memory     : 15.2G
  1836. [--] Max MySQL memory    : 13.6G
  1837. [--] Other process memory: 368.7M
  1838. [--] Total buffers: 11.0G global + 17.2M per thread (151 max threads)
  1839. [--] P_S Max memory usage: 72B
  1840. [--] Galera GCache Max memory usage: 0B
  1841. [--] Global Buffers
  1842. [--]  +-- Key Buffer: 16.0M
  1843. [--]  +-- Max Tmp Table: 16.0M
  1844. [--] Query Cache Buffers
  1845. [--]  +-- Query Cache: OFF - DISABLED
  1846. [--]  +-- Query Cache Size: 0B
  1847. [--] Per Thread Buffers
  1848. [--]  +-- Read Buffer: 128.0K
  1849. [--]  +-- Read RND Buffer: 256.0K
  1850. [--]  +-- Sort Buffer: 256.0K
  1851. [--]  +-- Thread stack: 192.0K
  1852. [--]  +-- Join Buffer: 384.0K
  1853. [OK] Maximum reached memory usage: 11.2G (73.52% of installed RAM)
  1854. [!!] Maximum possible memory usage: 13.6G (89.44% of installed RAM)
  1855. [OK] Overall possible memory usage with other process is compatible with memory available
  1856. [OK] Slow queries: 0% (0/48K)
  1857. [OK] Highest usage of available connections: 4% (7/151)
  1858. [OK] Aborted connections: 0.08%  (1/1228)
  1859. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  1860. [OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
  1861. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 173 sorts)
  1862. [!!] Joins performed without indexes: 2246
  1863. [OK] Temporary tables created on disk: 8% (9K on disk / 118K total)
  1864. [OK] Thread cache hit rate: 99% (7 created / 1K connections)
  1865. [!!] Table cache hit rate: 6% (2K open / 30K opened)
  1866. [OK] table_definition_cache(1400) is upper than number of tables(341)
  1867. [OK] Open file limit used: 0% (9/5K)
  1868. [OK] Table locks acquired immediately: 100% (19K immediate / 19K locks)
  1869.  
  1870. -------- Performance schema ------------------------------------------------------------------------
  1871. [--] Memory used by P_S: 72B
  1872. [--] Sys schema is installed.
  1873. [--] Sys schema Version: 1.5.2
  1874.  
  1875. -------- Performance schema: Top 5 user per connection ---------------------------------------------
  1876. [--]  +-- 1: root   1887 conn(s)
  1877. [--]  +-- 2: simulations    696 conn(s)
  1878. [--]  +-- 3: pmm    523 conn(s)
  1879. [--]  +-- 4: background 28 conn(s)
  1880. [--]  +-- 5: debian-sys-maint   2 conn(s)
  1881.  
  1882. -------- Performance schema: Top 5 user per statement ----------------------------------------------
  1883. [--]  +-- 1: pmm    40138 stmt(s)
  1884. [--]  +-- 2: simulations    12463 stmt(s)
  1885. [--]  +-- 3: root   5861 stmt(s)
  1886. [--]  +-- 4: debian-sys-maint   4 stmt(s)
  1887. [--]  +-- 5: background 0 stmt(s)
  1888.  
  1889. -------- Performance schema: Top 5 user per statement latency --------------------------------------
  1890. [--]  +-- 1: pmm    624337544.8453
  1891. [--]  +-- 2: root   277575907.2913
  1892. [--]  +-- 3: simulations    118066859.0227
  1893. [--]  +-- 4: debian-sys-maint   25557250.0000
  1894. [--]  +-- 5: background 0.0000
  1895.  
  1896. -------- Performance schema: Top 5 user per lock latency -------------------------------------------
  1897. [--]  +-- 1: pmm    6216898000000
  1898. [--]  +-- 2: simulations    607884000000
  1899. [--]  +-- 3: root   191512000000
  1900. [--]  +-- 4: debian-sys-maint   0
  1901. [--]  +-- 5: background 0
  1902.  
  1903. -------- Performance schema: Top 5 user per nb full scans ------------------------------------------
  1904. [--]  +-- 1: pmm    22143
  1905. [--]  +-- 2: simulations    5882
  1906. [--]  +-- 3: root   1743
  1907. [--]  +-- 4: debian-sys-maint   0
  1908. [--]  +-- 5: background 0
  1909.  
  1910. -------- Performance schema: Top 5 user per rows sent ----------------------------------------------
  1911. [--]  +-- 1: pmm    1721020
  1912. [--]  +-- 2: root   6187
  1913. [--]  +-- 3: simulations    697
  1914. [--]  +-- 4: debian-sys-maint   0
  1915. [--]  +-- 5: background 0
  1916.  
  1917. -------- Performance schema: Top 5 user per rows modified ------------------------------------------
  1918. [--]  +-- 1: pmm    0
  1919. [--]  +-- 2: root   0
  1920. [--]  +-- 3: simulations    0
  1921. [--]  +-- 4: debian-sys-maint   0
  1922. [--]  +-- 5: background 0
  1923.  
  1924. -------- Performance schema: Top 5 user per io -----------------------------------------------------
  1925. [--]  +-- 1: pmm    27649
  1926. [--]  +-- 2: background 13431
  1927. [--]  +-- 3: root   2452
  1928. [--]  +-- 4: simulations    81
  1929. [--]  +-- 5: debian-sys-maint   0
  1930.  
  1931. -------- Performance schema: Top 5 user per io latency ---------------------------------------------
  1932. [--]  +-- 1: root   552373756000
  1933. [--]  +-- 2: pmm    523275103200
  1934. [--]  +-- 3: background 403510726400
  1935. [--]  +-- 4: simulations    3746428000
  1936. [--]  +-- 5: debian-sys-maint   0
  1937.  
  1938. -------- Performance schema: Top 5 host per connection ---------------------------------------------
  1939. [--]  +-- 1: localhost  3117 conn(s)
  1940.  
  1941. -------- Performance schema: Top 5 host per statement ----------------------------------------------
  1942. [--]  +-- 1: localhost  234768 stmt(s)
  1943.  
  1944. -------- Performance schema: Top 5 host per statement latency --------------------------------------
  1945. [--]  +-- 1: localhost  481401428.0603
  1946.  
  1947. -------- Performance schema: Top 5 host per lock latency -------------------------------------------
  1948. [--]  +-- 1: localhost  7018745000000
  1949. [--]  +-- 2: background 0
  1950.  
  1951. -------- Performance schema: Top 5 host per nb full scans ------------------------------------------
  1952. [--]  +-- 1: localhost  29779
  1953. [--]  +-- 2: background 0
  1954.  
  1955. -------- Performance schema: Top 5 host per rows sent ----------------------------------------------
  1956. [--]  +-- 1: localhost  1727940
  1957. [--]  +-- 2: background 0
  1958.  
  1959. -------- Performance schema: Top 5 host per rows modified ------------------------------------------
  1960. [--]  +-- 1: background 0
  1961. [--]  +-- 2: localhost  0
  1962.  
  1963. -------- Performance schema: Top 5 host per io -----------------------------------------------------
  1964. [--]  +-- 1: localhost  120728
  1965.  
  1966. -------- Performance schema: Top 5 host per io latency ---------------------------------------------
  1967. [--]  +-- 1: localhost  4317581148800
  1968.  
  1969. -------- Performance schema: Top IO type order by total io -----------------------------------------
  1970. [--]  +-- 1: innodb/innodb_data_file    14431 i/o
  1971. [--]  +-- 2: myisam/dfile   13800 i/o
  1972. [--]  +-- 3: myisam/kfile   7320 i/o
  1973. [--]  +-- 4: sql/FRM    3013 i/o
  1974. [--]  +-- 5: csv/metadata   2776 i/o
  1975. [--]  +-- 6: csv/data   1054 i/o
  1976. [--]  +-- 7: sql/file_parser    968 i/o
  1977. [--]  +-- 8: archive/data   173 i/o
  1978. [--]  +-- 9: sql/dbopt  24 i/o
  1979. [--]  +-- 10: innodb/innodb_log_file    21 i/o
  1980. [--]  +-- 11: sql/casetest  15 i/o
  1981. [--]  +-- 12: sql/ERRMSG    5 i/o
  1982. [--]  +-- 13: mysys/cnf 5 i/o
  1983. [--]  +-- 14: mysys/charset 3 i/o
  1984. [--]  +-- 15: sql/pid   3 i/o
  1985. [--]  +-- 16: sql/global_ddl_log    2 i/o
  1986.  
  1987. -------- Performance schema: Top IO type order by total latency ------------------------------------
  1988. [--]  +-- 1: innodb/innodb_data_file    1174026934400.0
  1989. [--]  +-- 2: csv/metadata   187458953600.0
  1990. [--]  +-- 3: sql/file_parser    38102466400.0
  1991. [--]  +-- 4: myisam/dfile   30174548000.0
  1992. [--]  +-- 5: myisam/kfile   19996214400.0
  1993. [--]  +-- 6: csv/data   17301278400.0
  1994. [--]  +-- 7: innodb/innodb_log_file 7640976800.0
  1995. [--]  +-- 8: sql/FRM    5949796000.0
  1996. [--]  +-- 9: sql/casetest   1756456800.0
  1997. [--]  +-- 10: archive/data  300750400.0
  1998. [--]  +-- 11: sql/dbopt 105436800.0
  1999. [--]  +-- 12: sql/ERRMSG    38397600.0
  2000. [--]  +-- 13: mysys/charset 19412800.0
  2001. [--]  +-- 14: mysys/cnf 17276800.0
  2002. [--]  +-- 15: sql/pid   13528800.0
  2003. [--]  +-- 16: sql/global_ddl_log    3585600.0
  2004.  
  2005. -------- Performance schema: Top IO type order by max latency --------------------------------------
  2006. [--]  +-- 1: sql/file_parser    34373627200
  2007. [--]  +-- 2: csv/data   13980696000
  2008. [--]  +-- 3: innodb/innodb_data_file    13302598400
  2009. [--]  +-- 4: innodb/innodb_log_file 2482088000
  2010. [--]  +-- 5: csv/metadata   2283669600
  2011. [--]  +-- 6: sql/casetest   1680216000
  2012. [--]  +-- 7: myisam/kfile   29322400
  2013. [--]  +-- 8: myisam/dfile   25918400
  2014. [--]  +-- 9: sql/dbopt  25907200
  2015. [--]  +-- 10: sql/FRM   24810400
  2016. [--]  +-- 11: sql/ERRMSG    21449600
  2017. [--]  +-- 12: sql/pid   9758400
  2018. [--]  +-- 13: mysys/charset 9634400
  2019. [--]  +-- 14: mysys/cnf 9516800
  2020. [--]  +-- 15: archive/data  3459200
  2021. [--]  +-- 16: sql/global_ddl_log    1980800
  2022.  
  2023. -------- Performance schema: Top Stages order by total io ------------------------------------------
  2024. [--]  +-- 1: innodb/buffer pool load    1 i/o
  2025.  
  2026. -------- Performance schema: Top Stages order by total latency -------------------------------------
  2027. [--]  +-- 1: innodb/buffer pool load    21515530000.0
  2028.  
  2029. -------- Performance schema: Top Stages order by avg latency ---------------------------------------
  2030. [--]  +-- 1: innodb/buffer pool load    21515530000
  2031.  
  2032. -------- Performance schema: Top 5 host per table scans --------------------------------------------
  2033. [--]  +-- 1: localhost  119160
  2034.  
  2035. -------- Performance schema: InnoDB Buffer Pool by schema ------------------------------------------
  2036. [--]  +-- 1: InnoDB System  55296000    50962855    3375 page(s)
  2037. [--]  +-- 2: tradingsim 35340288    24747219    2157 page(s)
  2038. [--]  +-- 3: mysql  1409024 818630  86 page(s)
  2039.  
  2040. -------- Performance schema: 40 InnoDB Buffer Pool by table ----------------------------------------
  2041. [--]  +-- 1: InnoDB System  SYS_TABLES  120733696   111523804   7369 page(s)
  2042. [--]  +-- 2: tradingsim stored_path_data    30277632    22233767    1848 page(s)
  2043. [--]  +-- 3: tradingsim news    1196032 975187  73 page(s)
  2044. [--]  +-- 4: tradingsim yield_curve 1015808 794423  62 page(s)
  2045. [--]  +-- 5: mysql  help_topic  802816  626402  49 page(s)
  2046. [--]  +-- 6: tradingsim forward_rates   442368  288352  27 page(s)
  2047. [--]  +-- 7: tradingsim stored_paths    180224  96244   11 page(s)
  2048. [--]  +-- 8: tradingsim persons 163840  110792  10 page(s)
  2049. [--]  +-- 9: mysql  help_keyword    147456  82194   9 page(s)
  2050. [--]  +-- 10: tradingsim    abstract_traders    131072  85130   8 page(s)
  2051. [--]  +-- 11: tradingsim    instruments 131072  77437   8 page(s)
  2052. [--]  +-- 12: mysql help_relation   98304   46988   6 page(s)
  2053. [--]  +-- 13: InnoDB System SYS_COLUMNS 81920   48365   5 page(s)
  2054. [--]  +-- 14: mysql innodb_index_stats  81920   48083   5 page(s)
  2055. [--]  +-- 15: tradingsim    trades  81920   0   5 page(s)
  2056. [--]  +-- 16: tradingsim    broken_limits   65536   0   4 page(s)
  2057. [--]  +-- 17: tradingsim    current_accounts    65536   0   4 page(s)
  2058. [--]  +-- 18: tradingsim    held_instruments    65536   0   4 page(s)
  2059. [--]  +-- 19: tradingsim    option_market   65536   0   4 page(s)
  2060. [--]  +-- 20: tradingsim    wizard  65536   28042   4 page(s)
  2061. [--]  +-- 21: mysql help_category   49152   10019   3 page(s)
  2062. [--]  +-- 22: tradingsim    call_log    49152   0   3 page(s)
  2063. [--]  +-- 23: tradingsim    conditional_trades  49152   0   3 page(s)
  2064. [--]  +-- 24: tradingsim    layout_manager  49152   0   3 page(s)
  2065. [--]  +-- 25: tradingsim    links_persons_traders   49152   0   3 page(s)
  2066. [--]  +-- 26: tradingsim    offence_snapshot    49152   0   3 page(s)
  2067. [--]  +-- 27: tradingsim    risk_snapshot   49152   0   3 page(s)
  2068. [--]  +-- 28: tradingsim    stored_path_data2   49152   0   3 page(s)
  2069. [--]  +-- 29: tradingsim    system_performance  49152   0   3 page(s)
  2070. [--]  +-- 30: tradingsim    typos   49152   0   3 page(s)
  2071. [--]  +-- 31: tradingsim    working_orders  49152   0   3 page(s)
  2072. [--]  +-- 32: tradingsim    working_order_trades    49152   0   3 page(s)
  2073. [--]  +-- 33: InnoDB System SYS_FOREIGN 32768   0   2 page(s)
  2074. [--]  +-- 34: tradingsim    bond_maturities 32768   2640    2 page(s)
  2075. [--]  +-- 35: tradingsim    currencies  32768   7409    2 page(s)
  2076. [--]  +-- 36: tradingsim    erp2_instructions   32768   982 2 page(s)
  2077. [--]  +-- 37: tradingsim    event_log   32768   0   2 page(s)
  2078. [--]  +-- 38: tradingsim    instances   32768   244 2 page(s)
  2079. [--]  +-- 39: tradingsim    layout_details  32768   3712    2 page(s)
  2080. [--]  +-- 40: tradingsim    links_persons_person_groups 32768   0   2 page(s)
  2081.  
  2082. -------- Performance schema: Process per time ------------------------------------------------------
  2083. [--]  +-- 1: sql/main   NULL    10379
  2084. [--]  +-- 2: sql/compress_gtid_table    Daemon  10379
  2085. [--]  +-- 3: pmm@localhost  Sleep   3
  2086. [--]  +-- 4: pmm@localhost  Sleep   3
  2087. [--]  +-- 5: pmm@localhost  Sleep   3
  2088. [--]  +-- 6: pmm@localhost  Sleep   2
  2089. [--]  +-- 7: root@localhost Query   0
  2090. [--]  +-- 8: simulations@localhost  Sleep   0
  2091. [--]  +-- 9: sql/thread_timer_notifier  NULL    NULL
  2092. [--]  +-- 10: innodb/io_ibuf_thread NULL    NULL
  2093. [--]  +-- 11: innodb/io_log_thread  NULL    NULL
  2094. [--]  +-- 12: innodb/io_read_thread NULL    NULL
  2095. [--]  +-- 13: innodb/io_read_thread NULL    NULL
  2096. [--]  +-- 14: innodb/io_read_thread NULL    NULL
  2097. [--]  +-- 15: innodb/io_read_thread NULL    NULL
  2098. [--]  +-- 16: innodb/io_write_thread    NULL    NULL
  2099. [--]  +-- 17: innodb/io_write_thread    NULL    NULL
  2100. [--]  +-- 18: innodb/io_write_thread    NULL    NULL
  2101. [--]  +-- 19: innodb/io_write_thread    NULL    NULL
  2102. [--]  +-- 20: innodb/page_cleaner_thread    NULL    NULL
  2103. [--]  +-- 21: innodb/srv_lock_timeout_thread    NULL    NULL
  2104. [--]  +-- 22: innodb/srv_error_monitor_thread   NULL    NULL
  2105. [--]  +-- 23: innodb/srv_monitor_thread NULL    NULL
  2106. [--]  +-- 24: innodb/srv_master_thread  NULL    NULL
  2107. [--]  +-- 25: innodb/srv_purge_thread   NULL    NULL
  2108. [--]  +-- 26: innodb/srv_worker_thread  NULL    NULL
  2109. [--]  +-- 27: innodb/srv_worker_thread  NULL    NULL
  2110. [--]  +-- 28: innodb/srv_worker_thread  NULL    NULL
  2111. [--]  +-- 29: innodb/dict_stats_thread  NULL    NULL
  2112. [--]  +-- 30: innodb/buf_dump_thread    NULL    NULL
  2113. [--]  +-- 31: sql/signal_handler    NULL    NULL
  2114.  
  2115. -------- Performance schema: InnoDB Lock Waits -----------------------------------------------------
  2116. [--] No information found or indicators deactivated.
  2117.  
  2118. -------- Performance schema: Thread IO Latency -----------------------------------------------------
  2119. [--]  +-- 1: page_cleaner_thread    267496092000    4352651200
  2120. [--]  +-- 2: main   107769023200    4650288000
  2121. [--]  +-- 3: buf_dump_thread    20713526400 641034400
  2122. [--]  +-- 4: srv_master_thread  4637816000  2478940000
  2123. [--]  +-- 5: io_log_thread  2890568000  2482088000
  2124. [--]  +-- 6: io_write_thread    3700800 3700800
  2125.  
  2126. -------- Performance schema: Top 15 Most latency statements ----------------------------------------
  2127. [--]  +-- 1: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,    1307850397000
  2128. [--]  +-- 2: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,    910478404000
  2129. [--]  +-- 3: SELECT `stored_path_ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)   301838926000
  2130. [--]  +-- 4: SELECT `ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)   248518800000
  2131. [--]  +-- 5: SELECT `value` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    237830806000
  2132. [--]  +-- 6: SELECT `tick` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     67810448000
  2133. [--]  +-- 7: SELECT `type` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     62908721000
  2134. [--]  +-- 8: SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P   36622228000
  2135. [--]  +-- 9: SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche   33321106000
  2136. [--]  +-- 10: SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)   24040212000
  2137. [--]  +-- 11: SELECT `yield1m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  19802294000
  2138. [--]  +-- 12: SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem  8105959000
  2139. [--]  +-- 13: SELECT `ON` FROM `tradingsim` . `forward_rates` PROCEDURE ANALYSE (?)     7214683000
  2140. [--]  +-- 14: SELECT `ID` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)   5020695000
  2141. [--]  +-- 15: SELECT `day` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  4419624000
  2142.  
  2143. -------- Performance schema: Top 15 slower queries -------------------------------------------------
  2144. [--]  +-- 1: SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche   352 s
  2145. [--]  +-- 2: SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem   6 s
  2146. [--]  +-- 3: SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem   5 s
  2147. [--]  +-- 4: SELECT `name` FROM `tradingsim` . `instruments` PROCEDURE ANALYSE (?)  1 s
  2148. [--]  +-- 5: SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES`  1 s
  2149. [--]  +-- 6: SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES`     1 s
  2150. [--]  +-- 7: SELECT `ID` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)   1 s
  2151. [--]  +-- 8: SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)    1 s
  2152. [--]  +-- 9: SELECT `tick` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)     1 s
  2153. [--]  +-- 10: SELECT `ID` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)   1 s
  2154. [--]  +-- 11: SELECT `day` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  1 s
  2155. [--]  +-- 12: SELECT `yield1m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  1 s
  2156. [--]  +-- 13: SELECT `yield3m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  1 s
  2157. [--]  +-- 14: SELECT `yield6m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  1 s
  2158. [--]  +-- 15: SELECT `yield1y` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)  1 s
  2159.  
  2160. -------- Performance schema: Top 15 nb statement type ----------------------------------------------
  2161. [--]  +-- 1: select 39811
  2162. [--]  +-- 2: Init DB    5892
  2163. [--]  +-- 3: Ping   3289
  2164. [--]  +-- 4: Quit   3134
  2165. [--]  +-- 5: show_status    2078
  2166. [--]  +-- 6: show_engine_status 1044
  2167. [--]  +-- 7: show_slave_status  1039
  2168. [--]  +-- 8: show_variables 694
  2169. [--]  +-- 9: set_option 522
  2170. [--]  +-- 10: jump_if_not   346
  2171. [--]  +-- 11: error 173
  2172. [--]  +-- 12: Prepare   173
  2173. [--]  +-- 13: Close stmt    173
  2174. [--]  +-- 14: Execute   173
  2175. [--]  +-- 15: empty_query   173
  2176.  
  2177. -------- Performance schema: Top 15 statement by total latency -------------------------------------
  2178. [--]  +-- 1: select 26603264773000
  2179. [--]  +-- 2: show_status    2110257033000
  2180. [--]  +-- 3: show_variables 922049307000
  2181. [--]  +-- 4: show_engine_status 316119987000
  2182. [--]  +-- 5: Init DB    239600869000
  2183. [--]  +-- 6: Ping   119558712000
  2184. [--]  +-- 7: Execute    116733647000
  2185. [--]  +-- 8: show_slave_status  62791732000
  2186. [--]  +-- 9: set_option 24505257000
  2187. [--]  +-- 10: Quit  17922201000
  2188. [--]  +-- 11: Prepare   15982910000
  2189. [--]  +-- 12: show_table_status 15077530000
  2190. [--]  +-- 13: error 8745118000
  2191. [--]  +-- 14: empty_query   4565993000
  2192. [--]  +-- 15: Close stmt    2212493000
  2193.  
  2194. -------- Performance schema: Top 15 statement by lock latency --------------------------------------
  2195. [--]  +-- 1: select 6783993000000
  2196. [--]  +-- 2: show_status    176603000000
  2197. [--]  +-- 3: show_variables 52713000000
  2198. [--]  +-- 4: show_table_status  4901000000
  2199. [--]  +-- 5: Execute    4880000000
  2200. [--]  +-- 6: show_databases 61000000
  2201. [--]  +-- 7: show_storage_engines   29000000
  2202. [--]  +-- 8: Statistics 0
  2203. [--]  +-- 9: error  0
  2204. [--]  +-- 10: set_option    0
  2205. [--]  +-- 11: Prepare   0
  2206. [--]  +-- 12: freturn   0
  2207. [--]  +-- 13: show_slave_hosts  0
  2208. [--]  +-- 14: show_engine_status    0
  2209. [--]  +-- 15: Close stmt    0
  2210.  
  2211. -------- Performance schema: Top 15 statement by full scans ----------------------------------------
  2212. [--]  +-- 1: select 26850
  2213. [--]  +-- 2: show_status    2078
  2214. [--]  +-- 3: show_variables 694
  2215. [--]  +-- 4: Execute    173
  2216. [--]  +-- 5: show_table_status  4
  2217. [--]  +-- 6: show_databases 2
  2218. [--]  +-- 7: show_storage_engines   1
  2219. [--]  +-- 8: Quit   0
  2220. [--]  +-- 9: empty_query    0
  2221. [--]  +-- 10: show_slave_status 0
  2222. [--]  +-- 11: Statistics    0
  2223. [--]  +-- 12: error 0
  2224. [--]  +-- 13: set_option    0
  2225. [--]  +-- 14: Prepare   0
  2226. [--]  +-- 15: freturn   0
  2227.  
  2228. -------- Performance schema: Top 15 statement by rows sent -----------------------------------------
  2229. [--]  +-- 1: select 835577
  2230. [--]  +-- 2: show_status    735615
  2231. [--]  +-- 3: show_variables 88039
  2232. [--]  +-- 4: Execute    68670
  2233. [--]  +-- 5: show_table_status  280
  2234. [--]  +-- 6: show_databases 10
  2235. [--]  +-- 7: show_storage_engines   9
  2236. [--]  +-- 8: Statistics 0
  2237. [--]  +-- 9: error  0
  2238. [--]  +-- 10: set_option    0
  2239. [--]  +-- 11: Prepare   0
  2240. [--]  +-- 12: freturn   0
  2241. [--]  +-- 13: show_slave_hosts  0
  2242. [--]  +-- 14: show_engine_status    0
  2243. [--]  +-- 15: Close stmt    0
  2244.  
  2245. -------- Performance schema: Top 15 statement by rows modified -------------------------------------
  2246. [--]  +-- 1: Execute    0
  2247. [--]  +-- 2: Quit   0
  2248. [--]  +-- 3: empty_query    0
  2249. [--]  +-- 4: show_slave_status  0
  2250. [--]  +-- 5: select 0
  2251. [--]  +-- 6: Statistics 0
  2252. [--]  +-- 7: error  0
  2253. [--]  +-- 8: set_option 0
  2254. [--]  +-- 9: show_variables 0
  2255. [--]  +-- 10: Prepare   0
  2256. [--]  +-- 11: freturn   0
  2257. [--]  +-- 12: show_slave_hosts  0
  2258. [--]  +-- 13: show_engine_status    0
  2259. [--]  +-- 14: Close stmt    0
  2260. [--]  +-- 15: Init DB   0
  2261.  
  2262. -------- Performance schema: 15 sample queries using temp table ------------------------------------
  2263. [--]  +-- 1: SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche
  2264. [--]  +-- 2: SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p
  2265. [--]  +-- 3: SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`
  2266. [--]  +-- 4: SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =
  2267. [--]  +-- 5: SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =
  2268. [--]  +-- 6: SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA
  2269. [--]  +-- 7: SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ?
  2270. [--]  +-- 8: SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES`
  2271. [--]  +-- 9: SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES`
  2272. [--]  +-- 10: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,
  2273. [--]  +-- 11: SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,
  2274. [--]  +-- 12: SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem
  2275. [--]  +-- 13: SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P
  2276. [--]  +-- 14: SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL
  2277. [--]  +-- 15: SELECT DISTINCTROW ( `COLLATION_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `COLLATION_NAME` IS NOT NULL AND `TA
  2278.  
  2279. -------- Performance schema: Unused indexes --------------------------------------------------------
  2280. [--]  +-- 1: tradingsim broken_limits   trader_ID
  2281. [--]  +-- 2: tradingsim broken_limits   tick_fixed
  2282. [--]  +-- 3: tradingsim broken_limits   tick_broken
  2283. [--]  +-- 4: tradingsim call_log    tick
  2284. [--]  +-- 5: tradingsim call_log    trader_ID
  2285. [--]  +-- 6: tradingsim conditional_trades  trade_master_ID
  2286. [--]  +-- 7: tradingsim conditional_trades  trade_leg_ID
  2287. [--]  +-- 8: tradingsim current_accounts    tick
  2288. [--]  +-- 9: tradingsim current_accounts    currency_ID
  2289. [--]  +-- 10: tradingsim    current_accounts    trader_ID
  2290. [--]  +-- 11: tradingsim    event_log   instance_ID
  2291. [--]  +-- 12: tradingsim    held_instruments    counterparty_trader_ID
  2292. [--]  +-- 13: tradingsim    held_instruments    instrumentId
  2293. [--]  +-- 14: tradingsim    held_instruments    traderId
  2294. [--]  +-- 15: tradingsim    layout_manager  dom_ID
  2295. [--]  +-- 16: tradingsim    layout_manager  trader_ID
  2296. [--]  +-- 17: tradingsim    links_persons_traders   trader_ID
  2297. [--]  +-- 18: tradingsim    links_persons_traders   person_ID
  2298. [--]  +-- 19: tradingsim    maturity_limits bond_maturity_ID
  2299. [--]  +-- 20: tradingsim    offence_snapshot    trader_ID
  2300. [--]  +-- 21: tradingsim    offence_snapshot    tick
  2301. [--]  +-- 22: tradingsim    option_market   tick
  2302. [--]  +-- 23: tradingsim    option_market   instrument_id
  2303. [--]  +-- 24: tradingsim    person_groups   company_ID
  2304. [--]  +-- 25: tradingsim    risk_snapshot   bond_maturity_ID
  2305. [--]  +-- 26: tradingsim    risk_snapshot   trader_ID
  2306. [--]  +-- 27: tradingsim    sales_credits   trade_ID
  2307. [--]  +-- 28: tradingsim    scheduled_trades    instance_ID
  2308. [--]  +-- 29: tradingsim    stored_paths2   scenarioId
  2309. [--]  +-- 30: tradingsim    stored_path_data2   tick
  2310. [--]  +-- 31: tradingsim    system_logins   person
  2311. [--]  +-- 32: tradingsim    system_performance  page
  2312. [--]  +-- 33: tradingsim    system_performance  person_ID
  2313. [--]  +-- 34: tradingsim    traders instance_ID
  2314. [--]  +-- 35: tradingsim    trader_relationship computer_trader_ID
  2315. [--]  +-- 36: tradingsim    trades  instrumentId
  2316. [--]  +-- 37: tradingsim    trades  counterpartyTraderId
  2317. [--]  +-- 38: tradingsim    trades  initiatingTraderId
  2318. [--]  +-- 39: tradingsim    trades  tickMade
  2319. [--]  +-- 40: tradingsim    typos   tick_occured
  2320. [--]  +-- 41: tradingsim    typos   trader_ID
  2321. [--]  +-- 42: tradingsim    working_orders  client_trader_ID
  2322. [--]  +-- 43: tradingsim    working_orders  trader_ID
  2323. [--]  +-- 44: tradingsim    working_order_trades    trade_ID
  2324. [--]  +-- 45: tradingsim    working_order_trades    working_order_ID
  2325.  
  2326. -------- Performance schema: Tables with full table scans ------------------------------------------
  2327. [--]  +-- 1: tradingsim stored_path_data    634386  300485552000
  2328. [--]  +-- 2: tradingsim yield_curve 56320   46980177600
  2329. [--]  +-- 3: tradingsim persons 27404   10075750400
  2330. [--]  +-- 4: tradingsim forward_rates   21600   14785632000
  2331. [--]  +-- 5: tradingsim instruments 15390   7594671200
  2332. [--]  +-- 6: tradingsim abstract_traders    11952   3474658400
  2333. [--]  +-- 7: tradingsim news    11864   26880288000
  2334. [--]  +-- 8: tradingsim instances   5249    115835522400
  2335. [--]  +-- 9: tradingsim wizard  2820    1005516800
  2336. [--]  +-- 10: tradingsim    stored_paths    1895    2708216800
  2337. [--]  +-- 11: tradingsim    scenarios   1554    804632000
  2338. [--]  +-- 12: tradingsim    instrument_chain_entries    1440    659220800
  2339. [--]  +-- 13: tradingsim    system_settings 1392    10616959200
  2340. [--]  +-- 14: tradingsim    currencies  660 229975200
  2341. [--]  +-- 15: tradingsim    trader_responses    301 191658400
  2342. [--]  +-- 16: tradingsim    layout_details  280 173083200
  2343. [--]  +-- 17: tradingsim    bond_maturities 192 89212000
  2344. [--]  +-- 18: tradingsim    liquidity_profile   170 184245600
  2345. [--]  +-- 19: tradingsim    erp2_instructions   48  61515200
  2346. [--]  +-- 20: tradingsim    instrument_chain    36  37842400
  2347. [--]  +-- 21: tradingsim    layouts 8   32351200
  2348. [--]  +-- 22: tradingsim    client  8   48260800
  2349. [--]  +-- 23: tradingsim    erp2_role_nodes 6   23388000
  2350. [--]  +-- 24: tradingsim    annotations 4   36196000
  2351.  
  2352. -------- Performance schema: Latest FILE IO by latency ---------------------------------------------
  2353. [--] No information found or indicators deactivated.
  2354.  
  2355. -------- Performance schema: FILE by IO read bytes -------------------------------------------------
  2356. [--]  +-- 1: /var/lib/mysql/tradingsim/stored_path_data.ibd 30621696
  2357. [--]  +-- 2: /var/lib/mysql/mysql/proc.MYD  7254410
  2358. [--]  +-- 3: /var/lib/mysql/ibdata1 7045120
  2359. [--]  +-- 4: /var/lib/mysql/tradingsim/news.ibd 1228800
  2360. [--]  +-- 5: /var/lib/mysql/tradingsim/yield_curve.ibd  1048576
  2361. [--]  +-- 6: /var/lib/mysql/mysql/help_topic.ibd    950272
  2362. [--]  +-- 7: /var/lib/mysql/tradingsim/forward_rates.ibd    475136
  2363. [--]  +-- 8: /var/lib/mysql/tradingsim/stored_paths.ibd 212992
  2364. [--]  +-- 9: /var/lib/mysql/mysql/help_keyword.ibd  196608
  2365. [--]  +-- 10: /var/lib/mysql/tradingsim/persons.ibd 196608
  2366. [--]  +-- 11: /var/lib/mysql/mysql/help_relation.ibd    163840
  2367. [--]  +-- 12: /var/lib/mysql/tradingsim/abstract_traders.ibd    163840
  2368. [--]  +-- 13: /var/lib/mysql/tradingsim/instruments.ibd 163840
  2369. [--]  +-- 14: /var/lib/mysql/sys/sys_config.TRG 138240
  2370. [--]  +-- 15: /var/lib/mysql/mysql/innodb_index_stats.ibd   131072
  2371.  
  2372. -------- Performance schema: FILE by IO written bytes ----------------------------------------------
  2373. [--]  +-- 1: /var/lib/mysql/ibtmp1  196788224
  2374. [--]  +-- 2: /var/lib/mysql/ibdata1 65536
  2375. [--]  +-- 3: /var/lib/mysql/mysql/general_log.CSM   6055
  2376. [--]  +-- 4: /var/lib/mysql/mysql/slow_log.CSM  6055
  2377. [--]  +-- 5: /var/lib/mysql/ib_logfile0 2048
  2378. [--]  +-- 6: /run/mysqld/mysqld.pid 6
  2379. [--]  +-- 7: /var/lib/mysql/sys/memory_by_thread_by_current_bytes.frm   0
  2380. [--]  +-- 8: /usr/share/mysql/english/errmsg.sys    0
  2381. [--]  +-- 9: /var/lib/mysql/sys/memory_by_user_by_current_bytes.frm 0
  2382. [--]  +-- 10: /usr/share/mysql/charsets/Index.xml   0
  2383. [--]  +-- 11: /var/lib/mysql/sys/memory_global_by_current_bytes.frm 0
  2384. [--]  +-- 12: /var/lib/mysql/sys/memory_global_total.frm    0
  2385. [--]  +-- 13: /var/lib/mysql/sys/metrics.frm    0
  2386. [--]  +-- 14: /var/lib/mysql/sys/processlist.frm    0
  2387. [--]  +-- 15: /var/lib/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm    0
  2388.  
  2389. -------- Performance schema: file per IO total latency ---------------------------------------------
  2390. [--]  +-- 1: /var/lib/mysql/tradingsim/stored_path_data.ibd 459428426400
  2391. [--]  +-- 2: /var/lib/mysql/ibtmp1  308797509600
  2392. [--]  +-- 3: /var/lib/mysql/mysql/general_log.CSM   97873154400
  2393. [--]  +-- 4: /var/lib/mysql/mysql/slow_log.CSM  89585799200
  2394. [--]  +-- 5: /var/lib/mysql/ibdata1 57598871200
  2395. [--]  +-- 6: /var/lib/mysql/sys/host_summary_by_file_io.frm 34398446400
  2396. [--]  +-- 7: /var/lib/mysql/tradingsim/news.ibd 31801684800
  2397. [--]  +-- 8: /var/lib/mysql/tradingsim/yield_curve.ibd  29577159200
  2398. [--]  +-- 9: /var/lib/mysql/mysql/slave_worker_info.ibd 19508376000
  2399. [--]  +-- 10: /var/lib/mysql/tradingsim/forward_rates.ibd   18305059200
  2400. [--]  +-- 11: /var/lib/mysql/mysql/proc.MYD 17770232800
  2401. [--]  +-- 12: /var/lib/mysql/tradingsim/event_log.ibd   15637275200
  2402. [--]  +-- 13: /var/lib/mysql/mysql/slow_log.CSV 15164835200
  2403. [--]  +-- 14: /var/lib/mysql/mysql/help_topic.ibd   12554544800
  2404. [--]  +-- 15: /var/lib/mysql/tradingsim/abstract_traders.ibd    10986934400
  2405. [--]  +-- 16: /var/lib/mysql/mysql/help_keyword.ibd 9915809600
  2406. [--]  +-- 17: /var/lib/mysql/tradingsim/persons.ibd 9890566400
  2407. [--]  +-- 18: /var/lib/mysql/tradingsim/instruments.ibd 8026596000
  2408. [--]  +-- 19: /var/lib/mysql/ib_logfile0    7631786400
  2409. [--]  +-- 20: /var/lib/mysql/mysql/slave_master_info.ibd    5702172000
  2410.  
  2411. -------- Performance schema: file per IO read latency ----------------------------------------------
  2412. [--]  +-- 1: /var/lib/mysql/tradingsim/stored_path_data.ibd 459395919200
  2413. [--]  +-- 2: /var/lib/mysql/ibdata1 55616718400
  2414. [--]  +-- 3: /var/lib/mysql/tradingsim/news.ibd 31775020000
  2415. [--]  +-- 4: /var/lib/mysql/tradingsim/yield_curve.ibd  29550692800
  2416. [--]  +-- 5: /var/lib/mysql/mysql/slave_worker_info.ibd 19478627200
  2417. [--]  +-- 6: /var/lib/mysql/tradingsim/forward_rates.ibd    18276605600
  2418. [--]  +-- 7: /var/lib/mysql/tradingsim/event_log.ibd    15611968800
  2419. [--]  +-- 8: /var/lib/mysql/mysql/help_topic.ibd    12525843200
  2420. [--]  +-- 9: /var/lib/mysql/mysql/proc.MYD  11595867200
  2421. [--]  +-- 10: /var/lib/mysql/tradingsim/abstract_traders.ibd    10957474400
  2422. [--]  +-- 11: /var/lib/mysql/mysql/help_keyword.ibd 9884932800
  2423. [--]  +-- 12: /var/lib/mysql/tradingsim/persons.ibd 9864053600
  2424. [--]  +-- 13: /var/lib/mysql/tradingsim/instruments.ibd 7997438400
  2425. [--]  +-- 14: /var/lib/mysql/mysql/slave_master_info.ibd    5680726400
  2426. [--]  +-- 15: /var/lib/mysql/mysql/slave_relay_log_info.ibd 5547496000
  2427. [--]  +-- 16: /var/lib/mysql/tradingsim/risk_snapshot.ibd   5292509600
  2428. [--]  +-- 17: /var/lib/mysql/tradingsim/system_performance.ibd  5229648800
  2429. [--]  +-- 18: /var/lib/mysql/tradingsim/option_market.ibd   4898484800
  2430. [--]  +-- 19: /var/lib/mysql/tradingsim/person_groups.ibd   4886620800
  2431. [--]  +-- 20: /var/lib/mysql/tradingsim/autopilot.ibd   4831405600
  2432.  
  2433. -------- Performance schema: file per IO write latency ---------------------------------------------
  2434. [--]  +-- 1: /var/lib/mysql/ibtmp1  307460176000
  2435. [--]  +-- 2: /var/lib/mysql/mysql/general_log.CSM   1866524800
  2436. [--]  +-- 3: /var/lib/mysql/mysql/slow_log.CSM  1554108800
  2437. [--]  +-- 4: /var/lib/mysql/ibdata1 701017600
  2438. [--]  +-- 5: /var/lib/mysql/ib_logfile0 71003200
  2439. [--]  +-- 6: /run/mysqld/mysqld.pid 2649600
  2440. [--]  +-- 7: /var/lib/mysql/sys/memory_by_thread_by_current_bytes.frm   0
  2441. [--]  +-- 8: /usr/share/mysql/english/errmsg.sys    0
  2442. [--]  +-- 9: /var/lib/mysql/sys/memory_by_user_by_current_bytes.frm 0
  2443. [--]  +-- 10: /usr/share/mysql/charsets/Index.xml   0
  2444. [--]  +-- 11: /var/lib/mysql/sys/memory_global_by_current_bytes.frm 0
  2445. [--]  +-- 12: /var/lib/mysql/sys/memory_global_total.frm    0
  2446. [--]  +-- 13: /var/lib/mysql/sys/metrics.frm    0
  2447. [--]  +-- 14: /var/lib/mysql/sys/processlist.frm    0
  2448. [--]  +-- 15: /var/lib/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm    0
  2449. [--]  +-- 16: /var/lib/mysql/ib_logfile1    0
  2450. [--]  +-- 17: /var/lib/mysql/sys/ps_check_lost_instrumentation.frm  0
  2451. [--]  +-- 18: /var/lib/mysql/mysql/engine_cost.ibd  0
  2452. [--]  +-- 19: /var/lib/mysql/sys/schema_auto_increment_columns.frm  0
  2453. [--]  +-- 20: /var/lib/mysql/mysql/gtid_executed.ibd    0
  2454.  
  2455. -------- Performance schema: Event Wait by read bytes ----------------------------------------------
  2456. [--]  +-- 1: innodb/innodb_data_file    47300608
  2457. [--]  +-- 2: sql/io_cache   34288290
  2458. [--]  +-- 3: myisam/dfile   7261793
  2459. [--]  +-- 4: myisam/kfile   787450
  2460. [--]  +-- 5: sql/FRM    720800
  2461. [--]  +-- 6: sql/file_parser    138240
  2462. [--]  +-- 7: sql/ERRMSG 79247
  2463. [--]  +-- 8: innodb/innodb_log_file 70144
  2464. [--]  +-- 9: mysys/charset  19404
  2465. [--]  +-- 10: csv/metadata  12180
  2466. [--]  +-- 11: sql/dbopt 252
  2467. [--]  +-- 12: mysys/cnf 56
  2468. [--]  +-- 13: sql/casetest  0
  2469. [--]  +-- 14: sql/global_ddl_log    0
  2470. [--]  +-- 15: sql/pid   0
  2471.  
  2472. -------- Performance schema: Event Wait written bytes ----------------------------------------------
  2473. [--]  +-- 1: innodb/innodb_data_file    196853760
  2474. [--]  +-- 2: sql/io_cache   34288290
  2475. [--]  +-- 3: csv/metadata   12110
  2476. [--]  +-- 4: innodb/innodb_log_file 2048
  2477. [--]  +-- 5: sql/pid    6
  2478. [--]  +-- 6: sql/casetest   0
  2479. [--]  +-- 7: sql/dbopt  0
  2480. [--]  +-- 8: sql/ERRMSG 0
  2481. [--]  +-- 9: sql/file_parser    0
  2482. [--]  +-- 10: sql/FRM   0
  2483. [--]  +-- 11: sql/global_ddl_log    0
  2484. [--]  +-- 12: mysys/charset 0
  2485. [--]  +-- 13: mysys/cnf 0
  2486. [--]  +-- 14: csv/data  0
  2487. [--]  +-- 15: myisam/dfile  0
  2488.  
  2489. -------- Performance schema: event per wait total latency ------------------------------------------
  2490. [--]  +-- 1: innodb/innodb_data_file    1174026934400
  2491. [--]  +-- 2: csv/metadata   187458953600
  2492. [--]  +-- 3: sql/FRM    40764481600
  2493. [--]  +-- 4: myisam/dfile   30169368000
  2494. [--]  +-- 5: sql/io_cache   29480142400
  2495. [--]  +-- 6: myisam/kfile   19996214400
  2496. [--]  +-- 7: csv/data   17301278400
  2497. [--]  +-- 8: innodb/innodb_log_file 7640976800
  2498. [--]  +-- 9: sql/file_parser    3287780800
  2499. [--]  +-- 10: sql/casetest  1756456800
  2500. [--]  +-- 11: archive/data  300750400
  2501. [--]  +-- 12: sql/dbopt 105436800
  2502. [--]  +-- 13: sql/ERRMSG    38397600
  2503. [--]  +-- 14: mysys/charset 19412800
  2504. [--]  +-- 15: mysys/cnf 17276800
  2505. [--]  +-- 16: sql/pid   13528800
  2506. [--]  +-- 17: sql/global_ddl_log    3585600
  2507.  
  2508. -------- Performance schema: event per wait read latency -------------------------------------------
  2509. [--]  +-- 1: innodb/innodb_data_file    860926268800
  2510. [--]  +-- 2: myisam/dfile   11605972000
  2511. [--]  +-- 3: sql/io_cache   4830549600
  2512. [--]  +-- 4: myisam/kfile   3261939200
  2513. [--]  +-- 5: csv/metadata   2304024000
  2514. [--]  +-- 6: sql/FRM    1467530400
  2515. [--]  +-- 7: sql/file_parser    483469600
  2516. [--]  +-- 8: innodb/innodb_log_file 59624800
  2517. [--]  +-- 9: sql/dbopt  32164000
  2518. [--]  +-- 10: sql/ERRMSG    25385600
  2519. [--]  +-- 11: mysys/charset 9634400
  2520. [--]  +-- 12: mysys/cnf 4998400
  2521. [--]  +-- 13: archive/data  0
  2522. [--]  +-- 14: csv/data  0
  2523. [--]  +-- 15: sql/pid   0
  2524. [--]  +-- 16: sql/global_ddl_log    0
  2525. [--]  +-- 17: sql/casetest  0
  2526.  
  2527. -------- Performance schema: event per wait write latency ------------------------------------------
  2528. [--]  +-- 1: innodb/innodb_data_file    308161193600
  2529. [--]  +-- 2: sql/io_cache   20076005600
  2530. [--]  +-- 3: csv/metadata   3420633600
  2531. [--]  +-- 4: innodb/innodb_log_file 71003200
  2532. [--]  +-- 5: sql/pid    2649600
  2533. [--]  +-- 6: mysys/charset  0
  2534. [--]  +-- 7: archive/data   0
  2535. [--]  +-- 8: myisam/kfile   0
  2536. [--]  +-- 9: myisam/dfile   0
  2537. [--]  +-- 10: csv/data  0
  2538. [--]  +-- 11: mysys/cnf 0
  2539. [--]  +-- 12: sql/global_ddl_log    0
  2540. [--]  +-- 13: sql/FRM   0
  2541. [--]  +-- 14: sql/file_parser   0
  2542. [--]  +-- 15: sql/ERRMSG    0
  2543. [--]  +-- 16: sql/dbopt 0
  2544. [--]  +-- 17: sql/casetest  0
  2545.  
  2546. -------- Performance schema: TOP 15 most read indexes ----------------------------------------------
  2547. [--]  +-- 1: tradingsim stored_path_data    tick    634386
  2548. [--]  +-- 2: tradingsim stored_path_data    compound    317193
  2549. [--]  +-- 3: tradingsim yield_curve scenario_ID 10240
  2550. [--]  +-- 4: tradingsim forward_rates   cID 7200
  2551. [--]  +-- 5: tradingsim news    scenarioId  5932
  2552. [--]  +-- 6: tradingsim yield_curve day 5120
  2553. [--]  +-- 7: tradingsim stored_paths    scenarioId  3790
  2554. [--]  +-- 8: tradingsim forward_rates   tick    3600
  2555. [--]  +-- 9: tradingsim news    tick    2966
  2556. [--]  +-- 10: tradingsim    persons post_address_ID 1612
  2557. [--]  +-- 11: tradingsim    instruments scenarioId  1140
  2558. [--]  +-- 12: tradingsim    persons firstname   806
  2559. [--]  +-- 13: tradingsim    persons secondname  806
  2560. [--]  +-- 14: tradingsim    client  PRIMARY 697
  2561. [--]  +-- 15: tradingsim    abstract_traders    PRIMARY 664
  2562.  
  2563. -------- Performance schema: TOP 15 most modified indexes ------------------------------------------
  2564. [--]  +-- 1: tradingsim client  PRIMARY 0
  2565. [--]  +-- 2: tradingsim system_settings PRIMARY 0
  2566. [--]  +-- 3: tradingsim instances   PRIMARY 0
  2567. [--]  +-- 4: tradingsim instances   scenarioId  0
  2568. [--]  +-- 5: sys    sys_config  PRIMARY 0
  2569. [--]  +-- 6: tradingsim abstract_traders    PRIMARY 0
  2570. [--]  +-- 7: tradingsim annotations PRIMARY 0
  2571. [--]  +-- 8: tradingsim autopilot   PRIMARY 0
  2572. [--]  +-- 9: tradingsim bond_maturities PRIMARY 0
  2573. [--]  +-- 10: tradingsim    bond_maturities scenario_ID 0
  2574. [--]  +-- 11: tradingsim    broken_limits   PRIMARY 0
  2575. [--]  +-- 12: tradingsim    broken_limits   trader_ID   0
  2576. [--]  +-- 13: tradingsim    broken_limits   tick_broken 0
  2577. [--]  +-- 14: tradingsim    broken_limits   tick_fixed  0
  2578. [--]  +-- 15: tradingsim    call_log    PRIMARY 0
  2579.  
  2580. -------- Performance schema: TOP 15 high read latency index ----------------------------------------
  2581. [--]  +-- 1: tradingsim stored_path_data    tick    315853488000
  2582. [--]  +-- 2: tradingsim stored_path_data    compound    301631947200
  2583. [--]  +-- 3: tradingsim client  PRIMARY 5500994400
  2584. [--]  +-- 4: tradingsim yield_curve scenario_ID 5495863200
  2585. [--]  +-- 5: tradingsim forward_rates   cID 4401354400
  2586. [--]  +-- 6: tradingsim yield_curve day 4260287200
  2587. [--]  +-- 7: tradingsim news    scenarioId  3579436800
  2588. [--]  +-- 8: tradingsim news    tick    2939513600
  2589. [--]  +-- 9: tradingsim forward_rates   tick    2768020800
  2590. [--]  +-- 10: tradingsim    abstract_traders    PRIMARY 2676441600
  2591. [--]  +-- 11: tradingsim    stored_paths    scenarioId  2424549600
  2592. [--]  +-- 12: tradingsim    erp2_links_persons_role_nodes   PRIMARY 1268244000
  2593. [--]  +-- 13: tradingsim    persons secondname  1013790400
  2594. [--]  +-- 14: tradingsim    instruments scenarioId  884847200
  2595. [--]  +-- 15: tradingsim    persons post_address_ID 860403200
  2596.  
  2597. -------- Performance schema: TOP 15 most modified indexes ------------------------------------------
  2598. [--]  +-- 1: tradingsim client  PRIMARY 0
  2599. [--]  +-- 2: tradingsim system_settings PRIMARY 0
  2600. [--]  +-- 3: tradingsim instances   PRIMARY 0
  2601. [--]  +-- 4: tradingsim instances   scenarioId  0
  2602. [--]  +-- 5: sys    sys_config  PRIMARY 0
  2603. [--]  +-- 6: tradingsim abstract_traders    PRIMARY 0
  2604. [--]  +-- 7: tradingsim annotations PRIMARY 0
  2605. [--]  +-- 8: tradingsim autopilot   PRIMARY 0
  2606. [--]  +-- 9: tradingsim bond_maturities PRIMARY 0
  2607. [--]  +-- 10: tradingsim    bond_maturities scenario_ID 0
  2608. [--]  +-- 11: tradingsim    broken_limits   PRIMARY 0
  2609. [--]  +-- 12: tradingsim    broken_limits   trader_ID   0
  2610. [--]  +-- 13: tradingsim    broken_limits   tick_broken 0
  2611. [--]  +-- 14: tradingsim    broken_limits   tick_fixed  0
  2612. [--]  +-- 15: tradingsim    call_log    PRIMARY 0
  2613.  
  2614. -------- Performance schema: TOP 15 high update latency index --------------------------------------
  2615. [--]  +-- 1: tradingsim client  PRIMARY 0
  2616. [--]  +-- 2: tradingsim system_settings PRIMARY 0
  2617. [--]  +-- 3: tradingsim instances   PRIMARY 0
  2618. [--]  +-- 4: tradingsim instances   scenarioId  0
  2619. [--]  +-- 5: sys    sys_config  PRIMARY 0
  2620. [--]  +-- 6: tradingsim abstract_traders    PRIMARY 0
  2621. [--]  +-- 7: tradingsim annotations PRIMARY 0
  2622. [--]  +-- 8: tradingsim autopilot   PRIMARY 0
  2623. [--]  +-- 9: tradingsim bond_maturities PRIMARY 0
  2624. [--]  +-- 10: tradingsim    bond_maturities scenario_ID 0
  2625. [--]  +-- 11: tradingsim    broken_limits   PRIMARY 0
  2626. [--]  +-- 12: tradingsim    broken_limits   trader_ID   0
  2627. [--]  +-- 13: tradingsim    broken_limits   tick_broken 0
  2628. [--]  +-- 14: tradingsim    broken_limits   tick_fixed  0
  2629. [--]  +-- 15: tradingsim    call_log    PRIMARY 0
  2630.  
  2631. -------- Performance schema: TOP 15 high delete latency index --------------------------------------
  2632. [--]  +-- 1: tradingsim client  PRIMARY 0
  2633. [--]  +-- 2: tradingsim system_settings PRIMARY 0
  2634. [--]  +-- 3: tradingsim instances   PRIMARY 0
  2635. [--]  +-- 4: tradingsim instances   scenarioId  0
  2636. [--]  +-- 5: sys    sys_config  PRIMARY 0
  2637. [--]  +-- 6: tradingsim abstract_traders    PRIMARY 0
  2638. [--]  +-- 7: tradingsim annotations PRIMARY 0
  2639. [--]  +-- 8: tradingsim autopilot   PRIMARY 0
  2640. [--]  +-- 9: tradingsim bond_maturities PRIMARY 0
  2641. [--]  +-- 10: tradingsim    bond_maturities scenario_ID 0
  2642. [--]  +-- 11: tradingsim    broken_limits   PRIMARY 0
  2643. [--]  +-- 12: tradingsim    broken_limits   trader_ID   0
  2644. [--]  +-- 13: tradingsim    broken_limits   tick_broken 0
  2645. [--]  +-- 14: tradingsim    broken_limits   tick_fixed  0
  2646. [--]  +-- 15: tradingsim    call_log    PRIMARY 0
  2647.  
  2648. -------- Performance schema: TOP 15 most read tables -----------------------------------------------
  2649. [--]  +-- 1: tradingsim stored_path_data    1585965
  2650. [--]  +-- 2: tradingsim yield_curve 71680
  2651. [--]  +-- 3: tradingsim forward_rates   32400
  2652. [--]  +-- 4: tradingsim persons 30628
  2653. [--]  +-- 5: tradingsim news    20762
  2654. [--]  +-- 6: tradingsim instruments 16530
  2655. [--]  +-- 7: tradingsim abstract_traders    12616
  2656. [--]  +-- 8: tradingsim stored_paths    5685
  2657. [--]  +-- 9: tradingsim instances   5251
  2658. [--]  +-- 10: tradingsim    wizard  3102
  2659. [--]  +-- 11: tradingsim    scenarios   1628
  2660. [--]  +-- 12: tradingsim    instrument_chain_entries    1620
  2661. [--]  +-- 13: tradingsim    system_settings 1393
  2662. [--]  +-- 14: tradingsim    currencies  924
  2663. [--]  +-- 15: tradingsim    client  705
  2664.  
  2665. -------- Performance schema: TOP 15 most modified tables -------------------------------------------
  2666. [--]  +-- 1: tradingsim stored_paths2   0
  2667. [--]  +-- 2: tradingsim news    0
  2668. [--]  +-- 3: tradingsim changelog   0
  2669. [--]  +-- 4: tradingsim abstract_traders    0
  2670. [--]  +-- 5: tradingsim call_log    0
  2671. [--]  +-- 6: tradingsim scenarios   0
  2672. [--]  +-- 7: tradingsim held_instruments    0
  2673. [--]  +-- 8: tradingsim erp2_instructions   0
  2674. [--]  +-- 9: tradingsim event_log   0
  2675. [--]  +-- 10: tradingsim    layouts 0
  2676. [--]  +-- 11: tradingsim    person_groups   0
  2677. [--]  +-- 12: tradingsim    sales_credits   0
  2678. [--]  +-- 13: tradingsim    stored_path_data2   0
  2679. [--]  +-- 14: tradingsim    instances   0
  2680. [--]  +-- 15: tradingsim    trade_conversations 0
  2681.  
  2682. -------- Performance schema: TOP 15 high read latency tables ---------------------------------------
  2683. [--]  +-- 1: tradingsim stored_path_data    917970987200
  2684. [--]  +-- 2: tradingsim instances   116322632000
  2685. [--]  +-- 3: tradingsim yield_curve 56736328000
  2686. [--]  +-- 4: tradingsim news    33399238400
  2687. [--]  +-- 5: tradingsim forward_rates   21955007200
  2688. [--]  +-- 6: tradingsim persons 12548423200
  2689. [--]  +-- 7: tradingsim system_settings 10627846400
  2690. [--]  +-- 8: tradingsim instruments 8479518400
  2691. [--]  +-- 9: tradingsim abstract_traders    6151100000
  2692. [--]  +-- 10: tradingsim    client  5549255200
  2693. [--]  +-- 11: tradingsim    stored_paths    5132766400
  2694. [--]  +-- 12: tradingsim    erp2_links_persons_role_nodes   1268244000
  2695. [--]  +-- 13: tradingsim    wizard  1107581600
  2696. [--]  +-- 14: tradingsim    scenarios   844336000
  2697. [--]  +-- 15: tradingsim    currencies  751649600
  2698.  
  2699. -------- Performance schema: TOP 15 high insert latency tables -------------------------------------
  2700. [--]  +-- 1: tradingsim stored_paths2   0
  2701. [--]  +-- 2: tradingsim news    0
  2702. [--]  +-- 3: tradingsim changelog   0
  2703. [--]  +-- 4: tradingsim abstract_traders    0
  2704. [--]  +-- 5: tradingsim call_log    0
  2705. [--]  +-- 6: tradingsim scenarios   0
  2706. [--]  +-- 7: tradingsim held_instruments    0
  2707. [--]  +-- 8: tradingsim erp2_instructions   0
  2708. [--]  +-- 9: tradingsim event_log   0
  2709. [--]  +-- 10: tradingsim    layouts 0
  2710. [--]  +-- 11: tradingsim    person_groups   0
  2711. [--]  +-- 12: tradingsim    sales_credits   0
  2712. [--]  +-- 13: tradingsim    stored_path_data2   0
  2713. [--]  +-- 14: tradingsim    instances   0
  2714. [--]  +-- 15: tradingsim    trade_conversations 0
  2715.  
  2716. -------- Performance schema: TOP 15 high update latency tables -------------------------------------
  2717. [--]  +-- 1: tradingsim stored_path_data    0
  2718. [--]  +-- 2: tradingsim system_performance  0
  2719. [--]  +-- 3: tradingsim persons 0
  2720. [--]  +-- 4: tradingsim traders 0
  2721. [--]  +-- 5: tradingsim stored_paths    0
  2722. [--]  +-- 6: tradingsim working_orders  0
  2723. [--]  +-- 7: tradingsim instrument_chain_entries    0
  2724. [--]  +-- 8: tradingsim autopilot   0
  2725. [--]  +-- 9: tradingsim maturity_limits 0
  2726. [--]  +-- 10: tradingsim    trader_responses    0
  2727. [--]  +-- 11: tradingsim    pl_snapshots    0
  2728. [--]  +-- 12: tradingsim    erp2_role_nodes 0
  2729. [--]  +-- 13: tradingsim    stored_paths2   0
  2730. [--]  +-- 14: tradingsim    news    0
  2731. [--]  +-- 15: tradingsim    changelog   0
  2732.  
  2733. -------- Performance schema: TOP 15 high delete latency tables -------------------------------------
  2734. [--]  +-- 1: tradingsim stored_paths2   0
  2735. [--]  +-- 2: tradingsim news    0
  2736. [--]  +-- 3: tradingsim changelog   0
  2737. [--]  +-- 4: tradingsim abstract_traders    0
  2738. [--]  +-- 5: tradingsim call_log    0
  2739. [--]  +-- 6: tradingsim scenarios   0
  2740. [--]  +-- 7: tradingsim held_instruments    0
  2741. [--]  +-- 8: tradingsim erp2_instructions   0
  2742. [--]  +-- 9: tradingsim event_log   0
  2743. [--]  +-- 10: tradingsim    layouts 0
  2744. [--]  +-- 11: tradingsim    person_groups   0
  2745. [--]  +-- 12: tradingsim    sales_credits   0
  2746. [--]  +-- 13: tradingsim    stored_path_data2   0
  2747. [--]  +-- 14: tradingsim    instances   0
  2748. [--]  +-- 15: tradingsim    trade_conversations 0
  2749.  
  2750. -------- Performance schema: Redundant indexes -----------------------------------------------------
  2751. [--] No information found or indicators deactivated.
  2752.  
  2753. -------- Performance schema: Table not using InnoDB buffer -----------------------------------------
  2754. [--]  +-- 1: sys    sys_config
  2755.  
  2756. -------- Performance schema: Top 15 Tables using InnoDB buffer -------------------------------------
  2757. [--]  +-- 1: tradingsim stored_path_data    30277632
  2758. [--]  +-- 2: tradingsim news    1196032
  2759. [--]  +-- 3: tradingsim yield_curve 1015808
  2760. [--]  +-- 4: tradingsim forward_rates   442368
  2761. [--]  +-- 5: tradingsim stored_paths    180224
  2762. [--]  +-- 6: tradingsim persons 163840
  2763. [--]  +-- 7: tradingsim abstract_traders    131072
  2764. [--]  +-- 8: tradingsim instruments 131072
  2765. [--]  +-- 9: tradingsim trades  81920
  2766. [--]  +-- 10: tradingsim    broken_limits   65536
  2767. [--]  +-- 11: tradingsim    current_accounts    65536
  2768. [--]  +-- 12: tradingsim    wizard  65536
  2769. [--]  +-- 13: tradingsim    option_market   65536
  2770. [--]  +-- 14: tradingsim    held_instruments    65536
  2771. [--]  +-- 15: tradingsim    conditional_trades  49152
  2772.  
  2773. -------- Performance schema: Top 15 Tables with InnoDB buffer free ---------------------------------
  2774. [--]  +-- 1: tradingsim stored_path_data    8043865
  2775. [--]  +-- 2: tradingsim yield_curve 221385
  2776. [--]  +-- 3: tradingsim news    220845
  2777. [--]  +-- 4: tradingsim forward_rates   154016
  2778. [--]  +-- 5: tradingsim stored_paths    83980
  2779. [--]  +-- 6: tradingsim trades  81920
  2780. [--]  +-- 7: tradingsim current_accounts    65536
  2781. [--]  +-- 8: tradingsim option_market   65536
  2782. [--]  +-- 9: tradingsim held_instruments    65536
  2783. [--]  +-- 10: tradingsim    broken_limits   65536
  2784. [--]  +-- 11: tradingsim    instruments 53635
  2785. [--]  +-- 12: tradingsim    persons 53048
  2786. [--]  +-- 13: tradingsim    links_persons_traders   49152
  2787. [--]  +-- 14: tradingsim    layout_manager  49152
  2788. [--]  +-- 15: tradingsim    risk_snapshot   49152
  2789.  
  2790. -------- Performance schema: Top 15 Most executed queries ------------------------------------------
  2791. [--]  +-- 1: tradingsim SELECT * FROM `instances` WHERE OPEN = ? AND STATUS = ?     5189
  2792. [--]  +-- 2: NULL   SELECT @@`version`  3288
  2793. [--]  +-- 3: NULL   SHOW GLOBAL STATUS  2078
  2794. [--]  +-- 4: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  2077
  2795. [--]  +-- 5: NULL   SELECT `COUNT_TRANSACTIONS_IN_QUEUE` AS `transactions_in_queue` , `COUNT_TRANSACTIONS_CHECKED` AS `transactions_checked_    2077
  2796. [--]  +-- 6: NULL   SELECT `COUNT_TRANSACTIONS_IN_QUEUE` AS `transactions_in_queue` , `COUNT_TRANSACTIONS_CHECKED` AS `transactions_checked_    2077
  2797. [--]  +-- 7: NULL   SELECT `conn_status` . `channel_name` AS `channel_name` , `conn_status` . `service_state` AS RELAY_THREAD , `applier_sta    2077
  2798. [--]  +-- 8: NULL   SELECT `conn_status` . `channel_name` AS `channel_name` , `conn_status` . `service_state` AS RELAY_THREAD , `applier_sta    2077
  2799. [--]  +-- 9: NULL   SELECT `CHANNEL_NAME` AS `channel_name` , `MEMBER_ID` AS `member_id` , `MEMBER_HOST` AS `member_host` , `MEMBER_PORT` AS    2077
  2800. [--]  +-- 10: NULL  SELECT `CHANNEL_NAME` AS `channel_name` , `MEMBER_ID` AS `member_id` , `MEMBER_HOST` AS `member_host` , `MEMBER_PORT` AS    2077
  2801. [--]  +-- 11: NULL  SELECT `performance_schema` . `events_statements_history` . `SQL_TEXT` , `performance_schema` . `events_statements_histo    2077
  2802. [--]  +-- 12: NULL  SELECT @@`version_comment` LIMIT ?  1954
  2803. [--]  +-- 13: NULL  SHOW SLAVE STATUS   1039
  2804. [--]  +-- 14: NULL  SELECT @@`version` , @@`version_comment`    1038
  2805. [--]  +-- 15: NULL  SELECT `OBJECT_SCHEMA` , `OBJECT_NAME` , `COUNT_READ_NORMAL` , `COUNT_READ_WITH_SHARED_LOCKS` , `COUNT_READ_HIGH_PRIORIT    1038
  2806.  
  2807. -------- Performance schema: Latest SQL queries in errors or warnings ------------------------------
  2808. [--]  +-- 1: SELECT `UNIX_TIMESTAMP` ( `ts` ) , `UNIX_TIMESTAMP` ( NOW (?) ) , `server_id` FROM `heartbeat` . `heartbeat`   2020-10-29 09:03:18
  2809. [--]  +-- 2: SELECT `ID` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)   2020-10-29 09:03:57
  2810. [--]  +-- 3: SELECT `scenario_ID` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:57
  2811. [--]  +-- 4: SELECT `name` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)     2020-10-29 09:03:57
  2812. [--]  +-- 5: SELECT `description` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:57
  2813. [--]  +-- 6: SELECT `type` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)     2020-10-29 09:03:57
  2814. [--]  +-- 7: SELECT `buyside` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:57
  2815. [--]  +-- 8: SELECT `marketmaker` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2816. [--]  +-- 9: SELECT `flow_spread_tolerance` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2817. [--]  +-- 10: SELECT `dealer_spread_tolerance` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2818. [--]  +-- 11: SELECT `sub_type` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2819. [--]  +-- 12: SELECT `response_flow_tolerance` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2820. [--]  +-- 13: SELECT `response_notional_sensitivity` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2821. [--]  +-- 14: SELECT `response_maturity_sensitivity` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2822. [--]  +-- 15: SELECT `response_improvement_half_spread` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2823. [--]  +-- 16: SELECT `response_offence_tolerance` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2824. [--]  +-- 17: SELECT `response_favour_tolerance` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2825. [--]  +-- 18: SELECT `deviation_bias` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2826. [--]  +-- 19: SELECT `deviation_width` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2827. [--]  +-- 20: SELECT `color` FROM `tradingsim` . `abstract_traders` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2828. [--]  +-- 21: SELECT `ID` FROM `tradingsim` . `annotations` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2829. [--]  +-- 22: SELECT `scenario_ID` FROM `tradingsim` . `annotations` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2830. [--]  +-- 23: SELECT `title` FROM `tradingsim` . `annotations` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2831. [--]  +-- 24: SELECT `body` FROM `tradingsim` . `annotations` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2832. [--]  +-- 25: SELECT `tick` FROM `tradingsim` . `annotations` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2833. [--]  +-- 26: SELECT `ID` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2834. [--]  +-- 27: SELECT `trader_ID` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2835. [--]  +-- 28: SELECT `client_tick_speed` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2836. [--]  +-- 29: SELECT `dealer_rate` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2837. [--]  +-- 30: SELECT `broker_rate` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2838. [--]  +-- 31: SELECT `graph_scrub_rate` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2839. [--]  +-- 32: SELECT `reload_rate` FROM `tradingsim` . `autopilot` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2840. [--]  +-- 33: SELECT `ID` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)   2020-10-29 09:03:58
  2841. [--]  +-- 34: SELECT `scenario_ID` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2842. [--]  +-- 35: SELECT `name` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2843. [--]  +-- 36: SELECT `lower` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2844. [--]  +-- 37: SELECT `upper` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)    2020-10-29 09:03:58
  2845. [--]  +-- 38: SELECT `defaultlimit` FROM `tradingsim` . `bond_maturities` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2846. [--]  +-- 39: SELECT `ID` FROM `tradingsim` . `broken_limits` PROCEDURE ANALYSE (?)     2020-10-29 09:03:58
  2847. [--]  +-- 40: SELECT `trader_ID` FROM `tradingsim` . `broken_limits` PROCEDURE ANALYSE (?)  2020-10-29 09:03:58
  2848.  
  2849. -------- Performance schema: Top 20 queries with full table scans ----------------------------------
  2850. [--]  +-- 1: tradingsim SELECT * FROM `instances` WHERE OPEN = ? AND STATUS = ?     5189
  2851. [--]  +-- 2: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  2077
  2852. [--]  +-- 3: NULL   SELECT `COUNT_TRANSACTIONS_IN_QUEUE` AS `transactions_in_queue` , `COUNT_TRANSACTIONS_CHECKED` AS `transactions_checked_    2077
  2853. [--]  +-- 4: NULL   SELECT `conn_status` . `channel_name` AS `channel_name` , `conn_status` . `service_state` AS RELAY_THREAD , `applier_sta    2077
  2854. [--]  +-- 5: NULL   SELECT `CHANNEL_NAME` AS `channel_name` , `MEMBER_ID` AS `member_id` , `MEMBER_HOST` AS `member_host` , `MEMBER_PORT` AS    2077
  2855. [--]  +-- 6: NULL   SELECT `performance_schema` . `events_statements_history` . `SQL_TEXT` , `performance_schema` . `events_statements_histo    2077
  2856. [--]  +-- 7: NULL   SELECT `OBJECT_SCHEMA` , `OBJECT_NAME` , `COUNT_READ_NORMAL` , `COUNT_READ_WITH_SHARED_LOCKS` , `COUNT_READ_HIGH_PRIORIT    1038
  2857. [--]  +-- 8: NULL   SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p    1038
  2858. [--]  +-- 9: NULL   SELECT `EVENT_NAME` , `COUNT_READ` , `SUM_TIMER_READ` , `SUM_NUMBER_OF_BYTES_READ` , `COUNT_WRITE` , `SUM_TIMER_WRITE` ,    1038
  2859. [--]  +-- 10: NULL  SELECT `EVENT_NAME` , `COUNT_STAR` , `SUM_TIMER_WAIT` FROM `performance_schema` . `events_waits_summary_global_by_event_    1038
  2860. [--]  +-- 11: NULL  SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`     1038
  2861. [--]  +-- 12: NULL  SELECT `page_size` , `compress_ops` , `compress_ops_ok` , `compress_time` , `uncompress_ops` , `uncompress_time` FROM `i    1038
  2862. [--]  +-- 13: NULL  SELECT `page_size` , `buffer_pool_instance` , `pages_used` , `pages_free` , `relocation_ops` , `relocation_time` FROM `i    1038
  2863. [--]  +-- 14: tradingsim    SELECT `system_branding` FROM CLIENT `c` JOIN `system_settings` `s` ON `s` . `value` = `c` . `id` WHERE `s` . `name` = ?    695
  2864. [--]  +-- 15: NULL  SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  2865. [--]  +-- 16: NULL  SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  2866. [--]  +-- 17: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    352
  2867. [--]  +-- 18: NULL  SELECT `OBJECT_SCHEMA` , `OBJECT_NAME` , `COUNT_FETCH` , `COUNT_INSERT` , `COUNT_UPDATE` , `COUNT_DELETE` , `SUM_TIMER_F    173
  2868. [--]  +-- 19: NULL  SELECT `SPACE` , NAME , `ifnull` ( `FILE_FORMAT` , ? ) AS `FILE_FORMAT` , `ifnull` ( ROW_FORMAT , ? ) AS ROW_FORMAT , `i    173
  2869. [--]  +-- 20: NULL  SELECT SCHEMA_NAME FROM `information_schema` . `schemata` WHERE SCHEMA_NAME NOT IN (...)    173
  2870.  
  2871. -------- Performance schema: Last 50 queries with full table scans ---------------------------------
  2872. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:15
  2873. [--]  +-- 2: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  2874. [--]  +-- 3: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  2875. [--]  +-- 4: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  2876. [--]  +-- 5: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  2020-10-29 09:04:14
  2877. [--]  +-- 6: NULL   SELECT `COUNT_TRANSACTIONS_IN_QUEUE` AS `transactions_in_queue` , `COUNT_TRANSACTIONS_CHECKED` AS `transactions_checked_    2020-10-29 09:04:14
  2878. [--]  +-- 7: NULL   SELECT `conn_status` . `channel_name` AS `channel_name` , `conn_status` . `service_state` AS RELAY_THREAD , `applier_sta    2020-10-29 09:04:14
  2879. [--]  +-- 8: NULL   SELECT `CHANNEL_NAME` AS `channel_name` , `MEMBER_ID` AS `member_id` , `MEMBER_HOST` AS `member_host` , `MEMBER_PORT` AS    2020-10-29 09:04:14
  2880. [--]  +-- 9: NULL   SELECT `performance_schema` . `events_statements_history` . `SQL_TEXT` , `performance_schema` . `events_statements_histo    2020-10-29 09:04:14
  2881. [--]  +-- 10: tradingsim    SELECT * FROM `instances` WHERE OPEN = ? AND STATUS = ?     2020-10-29 09:04:13
  2882. [--]  +-- 11: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    2020-10-29 09:04:12
  2883. [--]  +-- 12: NULL  SELECT `r` . `trx_wait_started` AS `wait_started` , `timediff` ( NOW ( ) , `r` . `trx_wait_started` ) AS `wait_age` , TI    2020-10-29 09:04:12
  2884. [--]  +-- 13: NULL  SELECT IF ( `isnull` ( `performance_schema` . `threads` . `PROCESSLIST_ID` ) , `substring_index` ( `performance_schema`     2020-10-29 09:04:12
  2885. [--]  +-- 14: NULL  SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     2020-10-29 09:04:12
  2886. [--]  +-- 15: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:12
  2887. [--]  +-- 16: sys   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:12
  2888. [--]  +-- 17: NULL  SELECT `t` . `OBJECT_SCHEMA` AS `object_schema` , `t` . `OBJECT_NAME` AS `object_name` , `t` . `INDEX_NAME` AS `index_na    2020-10-29 09:04:12
  2889. [--]  +-- 18: NULL  SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `object_schema` , `performanc    2020-10-29 09:04:12
  2890. [--]  +-- 19: sys   SELECT IF ( `isnull` ( `information_schema` . `processlist` . `ID` ) , `concat` ( `substring_index` ( `performance_schem    2020-10-29 09:04:12
  2891. [--]  +-- 20: NULL  SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  2892. [--]  +-- 21: NULL  SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  2893. [--]  +-- 22: sys   SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  2894. [--]  +-- 23: NULL  SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    2020-10-29 09:04:12
  2895. [--]  +-- 24: sys   SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    2020-10-29 09:04:12
  2896. [--]  +-- 25: sys   SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    2020-10-29 09:04:12
  2897. [--]  +-- 26: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    2020-10-29 09:04:12
  2898. [--]  +-- 27: sys   SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    2020-10-29 09:04:12
  2899. [--]  +-- 28: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:11
  2900. [--]  +-- 29: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    2020-10-29 09:04:09
  2901. [--]  +-- 30: NULL  SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    2020-10-29 09:04:09
  2902. [--]  +-- 31: NULL  SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    2020-10-29 09:04:09
  2903. [--]  +-- 32: NULL  SELECT `yield10y` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)   2020-10-29 09:04:09
  2904. [--]  +-- 33: NULL  SELECT `yield20y` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)   2020-10-29 09:04:09
  2905. [--]  +-- 34: NULL  SELECT `yield30y` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)   2020-10-29 09:04:09
  2906. [--]  +-- 35: NULL  SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta    2020-10-29 09:04:09
  2907. [--]  +-- 36: NULL  SELECT ? FROM `information_schema` . `columns` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME = ?  2020-10-29 09:04:09
  2908. [--]  +-- 37: NULL  SELECT `CONCAT` ( SYSTEM_USER , ? , HOST ) FROM `mysql` . `user` WHERE ( `authentication_string` = ? OR `authentication_    2020-10-29 09:04:09
  2909. [--]  +-- 38: NULL  SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?    2020-10-29 09:04:09
  2910. [--]  +-- 39: NULL  SELECT `CONCAT` ( SYSTEM_USER , ? , HOST ) FROM `mysql` . `user` WHERE CAST ( `authentication_string` AS BINARY ) = PASS    2020-10-29 09:04:09
  2911. [--]  +-- 40: NULL  SELECT COUNT ( * ) FROM `information_schema` . `tables`     2020-10-29 09:04:09
  2912. [--]  +-- 41: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    2020-10-29 09:04:09
  2913. [--]  +-- 42: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    2020-10-29 09:04:09
  2914. [--]  +-- 43: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    2020-10-29 09:04:09
  2915. [--]  +-- 44: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:09
  2916. [--]  +-- 45: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  2917. [--]  +-- 46: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  2918. [--]  +-- 47: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    2020-10-29 09:04:09
  2919. [--]  +-- 48: NULL  SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ?    2020-10-29 09:04:08
  2920. [--]  +-- 49: NULL  SELECT `cancelled_reason` FROM `tradingsim` . `trades` PROCEDURE ANALYSE (?)    2020-10-29 09:04:08
  2921. [--]  +-- 50: NULL  SELECT `cancelled_by` FROM `tradingsim` . `trades` PROCEDURE ANALYSE (?)    2020-10-29 09:04:08
  2922.  
  2923. -------- Performance schema: TOP 15 reader queries (95% percentile) --------------------------------
  2924. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    27621
  2925. [--]  +-- 2: sys    SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    90
  2926. [--]  +-- 3: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     71
  2927. [--]  +-- 4: NULL   SELECT `t` . `OBJECT_SCHEMA` AS `object_schema` , `t` . `OBJECT_NAME` AS `object_name` , `t` . `INDEX_NAME` AS `index_na    45
  2928. [--]  +-- 5: NULL   SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    31
  2929. [--]  +-- 6: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    25
  2930. [--]  +-- 7: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     15
  2931. [--]  +-- 8: NULL   SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES`  6
  2932. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    6
  2933. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `threads` . `PROCESSLIST_ID` ) , `substring_index` ( `performance_schema`     6
  2934. [--]  +-- 11: NULL  SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES`   5
  2935. [--]  +-- 12: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3
  2936. [--]  +-- 13: NULL  SELECT `name` FROM `tradingsim` . `instruments` PROCEDURE ANALYSE (?)   1
  2937. [--]  +-- 14: NULL  SELECT `ID` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)    1
  2938. [--]  +-- 15: NULL  SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)     1
  2939.  
  2940. -------- Performance schema: TOP 15 most row look queries (95% percentile) -------------------------
  2941. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2926717
  2942. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     726438
  2943. [--]  +-- 3: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    713133
  2944. [--]  +-- 4: NULL   SELECT `ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    317193
  2945. [--]  +-- 5: NULL   SELECT `stored_path_ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    317193
  2946. [--]  +-- 6: NULL   SELECT `tick` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  317193
  2947. [--]  +-- 7: NULL   SELECT `value` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     317193
  2948. [--]  +-- 8: NULL   SELECT `type` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  317193
  2949. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    20425
  2950. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `threads` . `PROCESSLIST_ID` ) , `substring_index` ( `performance_schema`     10037
  2951. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    9834
  2952. [--]  +-- 12: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    9291
  2953. [--]  +-- 13: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    7458
  2954. [--]  +-- 14: sys   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     5587
  2955. [--]  +-- 15: NULL  SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     5402
  2956.  
  2957. -------- Performance schema: TOP 15 total latency queries (95% percentile) -------------------------
  2958. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    11729029627000
  2959. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3670748252000
  2960. [--]  +-- 3: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     1307850397000
  2961. [--]  +-- 4: NULL   SELECT `stored_path_ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    301838926000
  2962. [--]  +-- 5: NULL   SELECT `ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    248518800000
  2963. [--]  +-- 6: NULL   SELECT `value` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     237830806000
  2964. [--]  +-- 7: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     80231379000
  2965. [--]  +-- 8: NULL   SELECT `tick` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  67810448000
  2966. [--]  +-- 9: NULL   SELECT `type` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  62908721000
  2967. [--]  +-- 10: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    45589950000
  2968. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    40529795000
  2969. [--]  +-- 12: NULL  SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     37567143000
  2970. [--]  +-- 13: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    36622228000
  2971. [--]  +-- 14: NULL  SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)     24040212000
  2972. [--]  +-- 15: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    21319021000
  2973.  
  2974. -------- Performance schema: TOP 15 max latency queries (95% percentile) ---------------------------
  2975. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     1307850397000
  2976. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     924039314000
  2977. [--]  +-- 3: NULL   SELECT `stored_path_ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    301838926000
  2978. [--]  +-- 4: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    254537909000
  2979. [--]  +-- 5: NULL   SELECT `ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    248518800000
  2980. [--]  +-- 6: NULL   SELECT `value` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     237830806000
  2981. [--]  +-- 7: NULL   SELECT `tick` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  67810448000
  2982. [--]  +-- 8: NULL   SELECT `type` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  62908721000
  2983. [--]  +-- 9: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     40245657000
  2984. [--]  +-- 10: NULL  SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     37567143000
  2985. [--]  +-- 11: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    36622228000
  2986. [--]  +-- 12: NULL  SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)     24040212000
  2987. [--]  +-- 13: NULL  SELECT `yield1m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)    19802294000
  2988. [--]  +-- 14: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    8742198000
  2989. [--]  +-- 15: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    7786551000
  2990.  
  2991. -------- Performance schema: TOP 15 average latency queries (95% percentile) -----------------------
  2992. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     1307850397000
  2993. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     917687063000
  2994. [--]  +-- 3: NULL   SELECT `stored_path_ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    301838926000
  2995. [--]  +-- 4: NULL   SELECT `ID` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)    248518800000
  2996. [--]  +-- 5: NULL   SELECT `value` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)     237830806000
  2997. [--]  +-- 6: NULL   SELECT `tick` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  67810448000
  2998. [--]  +-- 7: NULL   SELECT `type` FROM `tradingsim` . `stored_path_data` PROCEDURE ANALYSE (?)  62908721000
  2999. [--]  +-- 8: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     40298131000
  3000. [--]  +-- 9: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     37567143000
  3001. [--]  +-- 10: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    36622228000
  3002. [--]  +-- 11: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    33321106000
  3003. [--]  +-- 12: NULL  SELECT `title` FROM `tradingsim` . `news` PROCEDURE ANALYSE (?)     24040212000
  3004. [--]  +-- 13: NULL  SELECT `yield1m` FROM `tradingsim` . `yield_curve` PROCEDURE ANALYSE (?)    19802294000
  3005. [--]  +-- 14: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    8105959000
  3006. [--]  +-- 15: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    7598325000
  3007.  
  3008. -------- Performance schema: Top 20 queries with sort ----------------------------------------------
  3009. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    352
  3010. [--]  +-- 2: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    173
  3011. [--]  +-- 3: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    6
  3012. [--]  +-- 4: sys    SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    6
  3013. [--]  +-- 5: sys    SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    6
  3014. [--]  +-- 6: sys    SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    6
  3015. [--]  +-- 7: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    5
  3016. [--]  +-- 8: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     5
  3017. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    4
  3018. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    4
  3019. [--]  +-- 11: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     4
  3020. [--]  +-- 12: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    3
  3021. [--]  +-- 13: sys   SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    3
  3022. [--]  +-- 14: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2
  3023. [--]  +-- 15: NULL  SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2
  3024. [--]  +-- 16: NULL  SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2
  3025. [--]  +-- 17: sys   SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2
  3026. [--]  +-- 18: NULL  SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    2
  3027. [--]  +-- 19: NULL  SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2
  3028. [--]  +-- 20: NULL  SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     1
  3029.  
  3030. -------- Performance schema: Last 50 queries with sort ---------------------------------------------
  3031. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:15
  3032. [--]  +-- 2: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  3033. [--]  +-- 3: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  3034. [--]  +-- 4: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  3035. [--]  +-- 5: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     2020-10-29 09:04:15
  3036. [--]  +-- 6: NULL   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:15
  3037. [--]  +-- 7: NULL   SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    2020-10-29 09:04:12
  3038. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `threads` . `PROCESSLIST_ID` ) , `substring_index` ( `performance_schema`     2020-10-29 09:04:12
  3039. [--]  +-- 9: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     2020-10-29 09:04:12
  3040. [--]  +-- 10: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:12
  3041. [--]  +-- 11: sys   SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     2020-10-29 09:04:12
  3042. [--]  +-- 12: NULL  SELECT `t` . `OBJECT_SCHEMA` AS `object_schema` , `t` . `OBJECT_NAME` AS `object_name` , `t` . `INDEX_NAME` AS `index_na    2020-10-29 09:04:12
  3043. [--]  +-- 13: NULL  SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `object_schema` , `performanc    2020-10-29 09:04:12
  3044. [--]  +-- 14: NULL  SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  3045. [--]  +-- 15: NULL  SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  3046. [--]  +-- 16: sys   SELECT `performance_schema` . `file_summary_by_instance` . `FILE_NAME` AS `file` , `performance_schema` . `file_summary_    2020-10-29 09:04:12
  3047. [--]  +-- 17: NULL  SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    2020-10-29 09:04:12
  3048. [--]  +-- 18: sys   SELECT `substring_index` ( `performance_schema` . `file_summary_by_event_name` . `EVENT_NAME` , ? , - (?) ) AS `event_na    2020-10-29 09:04:12
  3049. [--]  +-- 19: sys   SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    2020-10-29 09:04:12
  3050. [--]  +-- 20: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    2020-10-29 09:04:12
  3051. [--]  +-- 21: sys   SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    2020-10-29 09:04:12
  3052. [--]  +-- 22: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:11
  3053. [--]  +-- 23: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    2020-10-29 09:04:09
  3054. [--]  +-- 24: NULL  SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta    2020-10-29 09:04:09
  3055. [--]  +-- 25: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    2020-10-29 09:04:09
  3056. [--]  +-- 26: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    2020-10-29 09:04:09
  3057. [--]  +-- 27: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    2020-10-29 09:04:09
  3058. [--]  +-- 28: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:09
  3059. [--]  +-- 29: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  3060. [--]  +-- 30: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  3061. [--]  +-- 31: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    2020-10-29 09:04:09
  3062. [--]  +-- 32: NULL  SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     2020-10-29 09:03:57
  3063. [--]  +-- 33: NULL  SELECT TABLE_NAME FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY TABLE_NAME    2020-10-29 09:03:57
  3064. [--]  +-- 34: NULL  SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    2020-10-29 09:03:18
  3065.  
  3066. -------- Performance schema: TOP 15 row sorting queries with sort ----------------------------------
  3067. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     40039
  3068. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     5624
  3069. [--]  +-- 3: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     3233
  3070. [--]  +-- 4: sys    SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    2208
  3071. [--]  +-- 5: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     615
  3072. [--]  +-- 6: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    554
  3073. [--]  +-- 7: sys    SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    278
  3074. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    150
  3075. [--]  +-- 9: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    139
  3076. [--]  +-- 10: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    93
  3077. [--]  +-- 11: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    90
  3078. [--]  +-- 12: sys   SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    90
  3079. [--]  +-- 13: NULL  SELECT `performance_schema` . `events_statements_summary_by_digest` . `DIGEST_TEXT` AS `query` , `performance_schema` .     70
  3080. [--]  +-- 14: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    66
  3081. [--]  +-- 15: NULL  SELECT TABLE_NAME FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY TABLE_NAME    61
  3082.  
  3083. -------- Performance schema: TOP 15 total latency queries with sort --------------------------------
  3084. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    11729029627000
  3085. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3670748252000
  3086. [--]  +-- 3: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     1307850397000
  3087. [--]  +-- 4: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     201493903000
  3088. [--]  +-- 5: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    155927467000
  3089. [--]  +-- 6: sys    SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    45589950000
  3090. [--]  +-- 7: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    40529795000
  3091. [--]  +-- 8: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     37567143000
  3092. [--]  +-- 9: NULL   SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    36622228000
  3093. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    21319021000
  3094. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    10866810000
  3095. [--]  +-- 12: sys   SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    6674422000
  3096. [--]  +-- 13: sys   SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    5070635000
  3097. [--]  +-- 14: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    4948347000
  3098. [--]  +-- 15: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    4249418000
  3099.  
  3100. -------- Performance schema: TOP 15 merge queries with sort ----------------------------------------
  3101. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     32
  3102. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     4
  3103. [--]  +-- 3: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    0
  3104. [--]  +-- 4: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    0
  3105. [--]  +-- 5: NULL   SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     0
  3106. [--]  +-- 6: NULL   SELECT TABLE_NAME FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY TABLE_NAME    0
  3107. [--]  +-- 7: NULL   SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta    0
  3108. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    0
  3109. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    0
  3110. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    0
  3111. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    0
  3112. [--]  +-- 12: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3113. [--]  +-- 13: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3114. [--]  +-- 14: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    0
  3115. [--]  +-- 15: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    0
  3116.  
  3117. -------- Performance schema: TOP 15 average sort merges queries with sort --------------------------
  3118. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     8
  3119. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     4
  3120. [--]  +-- 3: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    0
  3121. [--]  +-- 4: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    0
  3122. [--]  +-- 5: NULL   SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     0
  3123. [--]  +-- 6: NULL   SELECT TABLE_NAME FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY TABLE_NAME    0
  3124. [--]  +-- 7: NULL   SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta    0
  3125. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    0
  3126. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    0
  3127. [--]  +-- 10: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    0
  3128. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    0
  3129. [--]  +-- 12: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3130. [--]  +-- 13: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3131. [--]  +-- 14: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    0
  3132. [--]  +-- 15: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    0
  3133.  
  3134. -------- Performance schema: TOP 15 scans queries with sort ----------------------------------------
  3135. [--]  +-- 1: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    173
  3136. [--]  +-- 2: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    30
  3137. [--]  +-- 3: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    30
  3138. [--]  +-- 4: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     20
  3139. [--]  +-- 5: sys    SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    18
  3140. [--]  +-- 6: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     17
  3141. [--]  +-- 7: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    8
  3142. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    8
  3143. [--]  +-- 9: sys    SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    6
  3144. [--]  +-- 10: sys   SELECT `performance_schema` . `table_io_waits_summary_by_index_usage` . `OBJECT_SCHEMA` AS `table_schema` , `performance    6
  3145. [--]  +-- 11: NULL  SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     4
  3146. [--]  +-- 12: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    3
  3147. [--]  +-- 13: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    3
  3148. [--]  +-- 14: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3
  3149. [--]  +-- 15: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    3
  3150.  
  3151. -------- Performance schema: TOP 15 range queries with sort ----------------------------------------
  3152. [--]  +-- 1: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    0
  3153. [--]  +-- 2: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    0
  3154. [--]  +-- 3: NULL   SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     0
  3155. [--]  +-- 4: NULL   SELECT TABLE_NAME FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` = ? ORDER BY TABLE_NAME    0
  3156. [--]  +-- 5: NULL   SELECT `CONCAT` ( `CONCAT` ( `object_schema` , ? ) , `object_name` ) AS ? , `index_name` FROM `performance_schema` . `ta    0
  3157. [--]  +-- 6: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    0
  3158. [--]  +-- 7: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    0
  3159. [--]  +-- 8: NULL   SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    0
  3160. [--]  +-- 9: NULL   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    0
  3161. [--]  +-- 10: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3162. [--]  +-- 11: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    0
  3163. [--]  +-- 12: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    0
  3164. [--]  +-- 13: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     0
  3165. [--]  +-- 14: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     0
  3166. [--]  +-- 15: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    0
  3167.  
  3168. -------- Performance schema: Top 20 queries with temp table ----------------------------------------
  3169. [--]  +-- 1: NULL   SHOW GLOBAL STATUS  2078
  3170. [--]  +-- 2: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  2077
  3171. [--]  +-- 3: NULL   SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p    1038
  3172. [--]  +-- 4: NULL   SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`     1038
  3173. [--]  +-- 5: NULL   SELECT `page_size` , `compress_ops` , `compress_ops_ok` , `compress_time` , `uncompress_ops` , `uncompress_time` FROM `i    1038
  3174. [--]  +-- 6: NULL   SELECT `page_size` , `buffer_pool_instance` , `pages_used` , `pages_free` , `relocation_ops` , `relocation_time` FROM `i    1038
  3175. [--]  +-- 7: NULL   SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  3176. [--]  +-- 8: NULL   SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  3177. [--]  +-- 9: NULL   SHOW VARIABLES WHERE `Variable_Name` = ? OR `Variable_Name` = ?     519
  3178. [--]  +-- 10: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    352
  3179. [--]  +-- 11: NULL  SHOW GLOBAL VARIABLES   174
  3180. [--]  +-- 12: NULL  SELECT `SPACE` , NAME , `ifnull` ( `FILE_FORMAT` , ? ) AS `FILE_FORMAT` , `ifnull` ( ROW_FORMAT , ? ) AS ROW_FORMAT , `i    173
  3181. [--]  +-- 13: NULL  SELECT SCHEMA_NAME FROM `information_schema` . `schemata` WHERE SCHEMA_NAME NOT IN (...)    173
  3182. [--]  +-- 14: NULL  SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    173
  3183. [--]  +-- 15: NULL  SELECT `TABLE_SCHEMA` , TABLE_NAME , `TABLE_TYPE` , `ifnull` ( ENGINE , ? ) AS ENGINE , `ifnull` ( `VERSION` , ? ) AS `V    173
  3184. [--]  +-- 16: NULL  SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ?    61
  3185. [--]  +-- 17: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    6
  3186. [--]  +-- 18: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    6
  3187. [--]  +-- 19: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    6
  3188. [--]  +-- 20: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    5
  3189.  
  3190. -------- Performance schema: Last 50 queries with temp table ---------------------------------------
  3191. [--]  +-- 1: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:15
  3192. [--]  +-- 2: sys    SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     2020-10-29 09:04:15
  3193. [--]  +-- 3: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  2020-10-29 09:04:14
  3194. [--]  +-- 4: NULL   SHOW GLOBAL STATUS  2020-10-29 09:04:14
  3195. [--]  +-- 5: NULL   SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    2020-10-29 09:04:12
  3196. [--]  +-- 6: NULL   SELECT `r` . `trx_wait_started` AS `wait_started` , `timediff` ( NOW ( ) , `r` . `trx_wait_started` ) AS `wait_age` , TI    2020-10-29 09:04:12
  3197. [--]  +-- 7: NULL   SELECT IF ( `isnull` ( `performance_schema` . `threads` . `PROCESSLIST_ID` ) , `substring_index` ( `performance_schema`     2020-10-29 09:04:12
  3198. [--]  +-- 8: NULL   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     2020-10-29 09:04:12
  3199. [--]  +-- 9: sys    SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:12
  3200. [--]  +-- 10: NULL  SELECT `t` . `OBJECT_SCHEMA` AS `object_schema` , `t` . `OBJECT_NAME` AS `object_name` , `t` . `INDEX_NAME` AS `index_na    2020-10-29 09:04:12
  3201. [--]  +-- 11: sys   SELECT IF ( `isnull` ( `information_schema` . `processlist` . `ID` ) , `concat` ( `substring_index` ( `performance_schem    2020-10-29 09:04:12
  3202. [--]  +-- 12: sys   SELECT `extract_schema_from_file_name` ( `performance_schema` . `file_summary_by_instance` . `FILE_NAME` ) AS `table_sch    2020-10-29 09:04:12
  3203. [--]  +-- 13: sys   SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    2020-10-29 09:04:12
  3204. [--]  +-- 14: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     2020-10-29 09:04:11
  3205. [--]  +-- 15: NULL  SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    2020-10-29 09:04:09
  3206. [--]  +-- 16: NULL  SHOW SCHEMAS    2020-10-29 09:04:09
  3207. [--]  +-- 17: NULL  SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    2020-10-29 09:04:09
  3208. [--]  +-- 18: NULL  SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    2020-10-29 09:04:09
  3209. [--]  +-- 19: NULL  SELECT ? FROM `information_schema` . `columns` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME = ?  2020-10-29 09:04:09
  3210. [--]  +-- 20: NULL  SELECT COUNT ( * ) FROM `information_schema` . `plugins` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS` = ?    2020-10-29 09:04:09
  3211. [--]  +-- 21: NULL  SELECT COUNT ( * ) FROM `information_schema` . `tables`     2020-10-29 09:04:09
  3212. [--]  +-- 22: NULL  SELECT ? AS `sys_version` , `version` ( ) AS `mysql_version`    2020-10-29 09:04:09
  3213. [--]  +-- 23: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    2020-10-29 09:04:09
  3214. [--]  +-- 24: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_user_by_event_name` . `USER` ) , ? , `perfor    2020-10-29 09:04:09
  3215. [--]  +-- 25: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_host_by_event_name` . `HOST` ) , ? , `performance_schem    2020-10-29 09:04:09
  3216. [--]  +-- 26: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_statements_summary_by_host_by_event_name` . `HOST` ) , ? , `perfor    2020-10-29 09:04:09
  3217. [--]  +-- 27: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  3218. [--]  +-- 28: NULL  SELECT IF ( `isnull` ( `performance_schema` . `events_waits_summary_by_host_by_event_name` . `HOST` ) , ? , `performance    2020-10-29 09:04:09
  3219. [--]  +-- 29: sys   SELECT IF ( `isnull` ( `performance_schema` . `events_stages_summary_by_host_by_event_name` . `HOST` ) , ? , `performanc    2020-10-29 09:04:09
  3220. [--]  +-- 30: NULL  SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ?    2020-10-29 09:04:08
  3221. [--]  +-- 31: NULL  SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p    2020-10-29 09:04:06
  3222. [--]  +-- 32: NULL  SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`     2020-10-29 09:04:06
  3223. [--]  +-- 33: NULL  SELECT `page_size` , `compress_ops` , `compress_ops_ok` , `compress_time` , `uncompress_ops` , `uncompress_time` FROM `i    2020-10-29 09:04:06
  3224. [--]  +-- 34: NULL  SELECT `page_size` , `buffer_pool_instance` , `pages_used` , `pages_free` , `relocation_ops` , `relocation_time` FROM `i    2020-10-29 09:04:06
  3225. [--]  +-- 35: NULL  SHOW GLOBAL VARIABLES   2020-10-29 09:03:57
  3226. [--]  +-- 36: NULL  SHOW VARIABLES  2020-10-29 09:03:57
  3227. [--]  +-- 37: NULL  SHOW STATUS     2020-10-29 09:03:57
  3228. [--]  +-- 38: NULL  SHOW ENGINES    2020-10-29 09:03:57
  3229. [--]  +-- 39: NULL  SELECT ENGINE , `SUPPORT` FROM `information_schema` . `ENGINES` ORDER BY ENGINE ASC     2020-10-29 09:03:57
  3230. [--]  +-- 40: NULL  SHOW TABLE STATUS FROM `mysql`  2020-10-29 09:03:57
  3231. [--]  +-- 41: NULL  SHOW TABLE STATUS FROM `performance_schema`     2020-10-29 09:03:57
  3232. [--]  +-- 42: NULL  SHOW TABLE STATUS FROM `tradingsim`     2020-10-29 09:03:57
  3233. [--]  +-- 43: NULL  SELECT DISTINCTROW `TABLE_SCHEMA` FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` NOT IN (...)    2020-10-29 09:03:57
  3234. [--]  +-- 44: NULL  SELECT SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `INDEX_LENGTH` ) ,     2020-10-29 09:03:57
  3235. [--]  +-- 45: NULL  SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES`   2020-10-29 09:03:57
  3236. [--]  +-- 46: NULL  SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES`  2020-10-29 09:03:57
  3237. [--]  +-- 47: NULL  SELECT `TABLE_SCHEMA` , SUM ( `TABLE_ROWS` ) , SUM ( `DATA_LENGTH` ) , SUM ( `INDEX_LENGTH` ) , SUM ( `DATA_LENGTH` + `I    2020-10-29 09:03:57
  3238. [--]  +-- 48: NULL  SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ?  2020-10-29 09:03:57
  3239. [--]  +-- 49: NULL  SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES` WHERE `TABLE_SCHEMA` = ?     2020-10-29 09:03:57
  3240. [--]  +-- 50: NULL  SELECT DISTINCTROW ( `CHARACTER_SET_NAME` ) FROM `information_schema` . `COLUMNS` WHERE `CHARACTER_SET_NAME` IS NOT NULL    2020-10-29 09:03:57
  3241.  
  3242. -------- Performance schema: TOP 15 total latency queries with temp table --------------------------
  3243. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    11729029627000
  3244. [--]  +-- 2: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3670748252000
  3245. [--]  +-- 3: NULL   SHOW GLOBAL STATUS  2111069583000
  3246. [--]  +-- 4: NULL   SELECT NAME , `subsystem` , TYPE , COMMENT , `count` FROM `information_schema` . `innodb_metrics` WHERE STATUS = ?  1357797569000
  3247. [--]  +-- 5: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     1307850397000
  3248. [--]  +-- 6: NULL   SHOW VARIABLES WHERE `Variable_Name` = ? OR `Variable_Name` = ?     687545407000
  3249. [--]  +-- 7: NULL   SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`     451199667000
  3250. [--]  +-- 8: NULL   SELECT `TABLE_SCHEMA` , TABLE_NAME , `TABLE_TYPE` , `ifnull` ( ENGINE , ? ) AS ENGINE , `ifnull` ( `VERSION` , ? ) AS `V    365388191000
  3251. [--]  +-- 9: NULL   SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p    360833136000
  3252. [--]  +-- 10: NULL  SHOW GLOBAL VARIABLES   233328136000
  3253. [--]  +-- 11: sys   SELECT COUNT (?) AS `cnt` , `round` ( ( `performance_schema` . `events_statements_summary_by_digest` . `AVG_TIMER_WAIT`     201493903000
  3254. [--]  +-- 12: NULL  SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    155927467000
  3255. [--]  +-- 13: NULL  SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    152752936000
  3256. [--]  +-- 14: NULL  SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    150442746000
  3257. [--]  +-- 15: NULL  SELECT `page_size` , `buffer_pool_instance` , `pages_used` , `pages_free` , `relocation_ops` , `relocation_time` FROM `i    147058557000
  3258.  
  3259. -------- Performance schema: TOP 15 queries with temp table to disk --------------------------------
  3260. [--]  +-- 1: NULL   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_sche    7318
  3261. [--]  +-- 2: NULL   SELECT COALESCE ( `command` , ? ) , COALESCE ( `state` , ? ) , COUNT ( * ) , SUM ( TIME ) FROM `information_schema` . `p    1038
  3262. [--]  +-- 3: NULL   SELECT COUNT ( `PLUGIN_NAME` ) AS `c` FROM `INFORMATION_SCHEMA` . `PLUGINS` WHERE `PLUGIN_NAME` = ? AND `PLUGIN_STATUS`     1038
  3263. [--]  +-- 4: NULL   SELECT `COLUMN_TYPE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  3264. [--]  +-- 5: NULL   SELECT `IS_NULLABLE` FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ? AND COLUMN_NAME =    592
  3265. [--]  +-- 6: NULL   SELECT `ifnull` ( SCHEMA_NAME , ? ) AS SCHEMA_NAME , `DIGEST` , LEFT ( `DIGEST_TEXT` , ? ) AS `DIGEST_TEXT` , `COUNT_STA    173
  3266. [--]  +-- 7: NULL   SELECT COLUMN_NAME FROM `information_schema` . `COLUMNS` WHERE `TABLE_SCHEMA` = ? AND TABLE_NAME = ?    61
  3267. [--]  +-- 8: NULL   SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     12
  3268. [--]  +-- 9: NULL   SELECT DISTINCTROW ( `TABLE_COLLATION` ) FROM `information_schema` . `TABLES`   10
  3269. [--]  +-- 10: NULL  SELECT DISTINCTROW ( ENGINE ) FROM `information_schema` . `TABLES`  10
  3270. [--]  +-- 11: NULL  SELECT `t` . `OBJECT_SCHEMA` AS `object_schema` , `t` . `OBJECT_NAME` AS `object_name` , `t` . `INDEX_NAME` AS `index_na    10
  3271. [--]  +-- 12: NULL  SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ) = ? ) , ? , REPLACE ( `substring_index` ( `ibp` . `TABLE_NAME` , ?,     3
  3272. [--]  +-- 13: sys   SELECT `information_schema` . `STATISTICS` . `TABLE_SCHEMA` AS `table_schema` , `information_schema` . `STATISTICS` . `T    3
  3273. [--]  +-- 14: NULL  SELECT IF ( `isnull` ( `performance_schema` . `memory_summary_by_user_by_event_name` . `USER` ) , ? , `performance_schem    2
  3274. [--]  +-- 15: NULL  SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `t` . `NAME` = ? ) , `concat` ( `t` . `PROCESSLIST_USER` , ? , `t` . `P    2
  3275.  
  3276. -------- Performance schema: TOP 15 class events by number -----------------------------------------
  3277. [--]  +-- 1: wait/io/table  1792887
  3278. [--]  +-- 2: wait/io/file   48200
  3279. [--]  +-- 3: wait/lock/table    7174
  3280.  
  3281. -------- Performance schema: TOP 30 events by number -----------------------------------------------
  3282. [--]  +-- 1: wait/io/table/sql/handler  1792887
  3283. [--]  +-- 2: wait/io/file/innodb/innodb_data_file   14431
  3284. [--]  +-- 3: wait/io/file/myisam/dfile  13853
  3285. [--]  +-- 4: wait/io/file/myisam/kfile  7320
  3286. [--]  +-- 5: wait/lock/table/sql/handler    7174
  3287. [--]  +-- 6: wait/io/file/sql/io_cache  4534
  3288. [--]  +-- 7: wait/io/file/sql/FRM   3113
  3289. [--]  +-- 8: wait/io/file/csv/metadata  2776
  3290. [--]  +-- 9: wait/io/file/csv/data  1054
  3291. [--]  +-- 10: wait/io/file/sql/file_parser  868
  3292. [--]  +-- 11: wait/io/file/archive/data 173
  3293. [--]  +-- 12: wait/io/file/sql/dbopt    24
  3294. [--]  +-- 13: wait/io/file/innodb/innodb_log_file   21
  3295. [--]  +-- 14: wait/io/file/sql/casetest 15
  3296. [--]  +-- 15: wait/io/file/mysys/cnf    5
  3297. [--]  +-- 16: wait/io/file/sql/ERRMSG   5
  3298. [--]  +-- 17: wait/io/file/mysys/charset    3
  3299. [--]  +-- 18: wait/io/file/sql/pid  3
  3300. [--]  +-- 19: wait/io/file/sql/global_ddl_log   2
  3301.  
  3302. -------- Performance schema: TOP 15 class events by total latency ----------------------------------
  3303. [--]  +-- 1: wait/io/file   1580760007200
  3304. [--]  +-- 2: wait/io/table  1202754390400
  3305. [--]  +-- 3: wait/lock/table    6671395200
  3306.  
  3307. -------- Performance schema: TOP 30 events by total latency ----------------------------------------
  3308. [--]  +-- 1: wait/io/table/sql/handler  1202754390400
  3309. [--]  +-- 2: wait/io/file/innodb/innodb_data_file   1174026934400
  3310. [--]  +-- 3: wait/io/file/csv/metadata  187458953600
  3311. [--]  +-- 4: wait/io/file/sql/io_cache  97769632800
  3312. [--]  +-- 5: wait/io/file/sql/FRM   40764481600
  3313. [--]  +-- 6: wait/io/file/myisam/dfile  30258908800
  3314. [--]  +-- 7: wait/io/file/myisam/kfile  19996214400
  3315. [--]  +-- 8: wait/io/file/csv/data  17301278400
  3316. [--]  +-- 9: wait/io/file/innodb/innodb_log_file    7640976800
  3317. [--]  +-- 10: wait/lock/table/sql/handler   6671395200
  3318. [--]  +-- 11: wait/io/file/sql/file_parser  3287780800
  3319. [--]  +-- 12: wait/io/file/sql/casetest 1756456800
  3320. [--]  +-- 13: wait/io/file/archive/data 300750400
  3321. [--]  +-- 14: wait/io/file/sql/dbopt    105436800
  3322. [--]  +-- 15: wait/io/file/sql/ERRMSG   38397600
  3323. [--]  +-- 16: wait/io/file/mysys/charset    19412800
  3324. [--]  +-- 17: wait/io/file/mysys/cnf    17276800
  3325. [--]  +-- 18: wait/io/file/sql/pid  13528800
  3326. [--]  +-- 19: wait/io/file/sql/global_ddl_log   3585600
  3327.  
  3328. -------- Performance schema: TOP 15 class events by max latency ------------------------------------
  3329. [--]  +-- 1: wait/io/table  301631947200
  3330. [--]  +-- 2: wait/io/file   34373627200
  3331. [--]  +-- 3: wait/lock/table    24331200
  3332.  
  3333. -------- Performance schema: TOP 30 events by max latency ------------------------------------------
  3334. [--]  +-- 1: wait/io/table/sql/handler  301631947200
  3335. [--]  +-- 2: wait/io/file/sql/FRM   34373627200
  3336. [--]  +-- 3: wait/io/file/csv/data  13980696000
  3337. [--]  +-- 4: wait/io/file/innodb/innodb_data_file   13302598400
  3338. [--]  +-- 5: wait/io/file/innodb/innodb_log_file    2482088000
  3339. [--]  +-- 6: wait/io/file/csv/metadata  2283669600
  3340. [--]  +-- 7: wait/io/file/sql/io_cache  1709012800
  3341. [--]  +-- 8: wait/io/file/sql/casetest  1680216000
  3342. [--]  +-- 9: wait/io/file/myisam/kfile  29322400
  3343. [--]  +-- 10: wait/io/file/sql/file_parser  28869600
  3344. [--]  +-- 11: wait/io/file/myisam/dfile 25918400
  3345. [--]  +-- 12: wait/io/file/sql/dbopt    25907200
  3346. [--]  +-- 13: wait/lock/table/sql/handler   24331200
  3347. [--]  +-- 14: wait/io/file/sql/ERRMSG   21449600
  3348. [--]  +-- 15: wait/io/file/sql/pid  9758400
  3349. [--]  +-- 16: wait/io/file/mysys/charset    9634400
  3350. [--]  +-- 17: wait/io/file/mysys/cnf    9516800
  3351. [--]  +-- 18: wait/io/file/archive/data 3459200
  3352. [--]  +-- 19: wait/io/file/sql/global_ddl_log   1980800
  3353.  
  3354. -------- ThreadPool Metrics ------------------------------------------------------------------------
  3355. [--] ThreadPool stat is disabled.
  3356.  
  3357. -------- MyISAM Metrics ----------------------------------------------------------------------------
  3358. [!!] Key buffer used: 18.2% (3M used / 16M cache)
  3359. [OK] Key buffer size / total MyISAM indexes: 16.0M/43.0K
  3360. [OK] Read Key buffer hit rate: 99.9% (5K cached / 5 reads)
  3361.  
  3362. -------- InnoDB Metrics ----------------------------------------------------------------------------
  3363. [--] InnoDB is enabled.
  3364. [--] InnoDB Buffers
  3365. [--]  +-- InnoDB Buffer Pool: 11.0G
  3366. [--]  +-- InnoDB Buffer Pool Instances: 11
  3367. [--]  +-- InnoDB Buffer Pool Chunk Size: 128.0M
  3368. [--]  +-- InnoDB Log File Size: 2.0G
  3369. [--]  +-- InnoDB Log File In Group: 2
  3370. [--]  +-- InnoDB Total Log File Size: 4.0G(36.3636363636364 % of buffer pool)
  3371. [--]  +-- InnoDB Log Buffer: 16.0M
  3372. [--]  +-- InnoDB Log Buffer Free: 703.3K
  3373. [--]  +-- InnoDB Log Buffer Used: 703.9K
  3374. [--] InnoDB Thread Concurrency: 0
  3375. [OK] InnoDB File per table is activated
  3376. [OK] InnoDB buffer pool / data size: 11.0G/4.2M
  3377. [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (36.3636363636364 %): 2.0G * 2/11.0G should be equal to 25%
  3378. [OK] InnoDB buffer pool instances: 11
  3379. [--] Number of InnoDB Buffer Pool Chunk : 88 for 11 Buffer Pool Instance(s)
  3380. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  3381. [OK] InnoDB Read buffer efficiency: 99.84% (365571 hits/ 366150 total)
  3382. [!!] InnoDB Write Log efficiency: 0% (2 hits/ 0 total)
  3383. [OK] InnoDB log waits: 0.00% (0 waits / 2 writes)
  3384.  
  3385. -------- AriaDB Metrics ----------------------------------------------------------------------------
  3386. [--] AriaDB is disabled.
  3387.  
  3388. -------- TokuDB Metrics ----------------------------------------------------------------------------
  3389. [--] TokuDB is disabled.
  3390.  
  3391. -------- XtraDB Metrics ----------------------------------------------------------------------------
  3392. [--] XtraDB is disabled.
  3393.  
  3394. -------- Galera Metrics ----------------------------------------------------------------------------
  3395. [--] Galera is disabled.
  3396.  
  3397. -------- Replication Metrics -----------------------------------------------------------------------
  3398. [--] Galera Synchronous replication: NO
  3399. [--] No replication slave(s) for this server.
  3400. [--] Binlog format: ROW
  3401. [--] XA support enabled: ON
  3402. [--] Semi synchronous replication Master: Not Activated
  3403. [--] Semi synchronous replication Slave: Not Activated
  3404. [--] This is a standalone server
  3405.  
  3406. -------- Recommendations ---------------------------------------------------------------------------
  3407. General recommendations:
  3408.     Add some space to /snap/amazon-ssm-agent/2012 mountpoint.
  3409.     Add some space to /snap/core/10126 mountpoint.
  3410.     Add some space to /snap/core/10185 mountpoint.
  3411.     Cleanup files from /snap/amazon-ssm-agent/2012 mountpoint or reformat you filesystem.
  3412.     Cleanup files from /snap/core/10126 mountpoint or reformat you filesystem.
  3413.     Cleanup files from /snap/core/10185 mountpoint or reformat you filesystem.
  3414.     Check all table collations are identical for all tables in tradingsim database.
  3415.     Limit charset for column to one charset if possible for tradingsim database.
  3416.     Limit collations for column to one collation if possible for tradingsim database.
  3417.     ALTER TABLE `tradingsim`.`instances` MODIFY `name` CHAR(0) NOT NULL;
  3418.     ALTER TABLE `tradingsim`.`instances` MODIFY `date_display_format` CHAR(0);
  3419.     ALTER TABLE `tradingsim`.`instruments` MODIFY `instrument_group_ID` CHAR(0);
  3420.     ALTER TABLE `tradingsim`.`news` MODIFY `title` TINYTEXT NOT NULL;
  3421.     ALTER TABLE `tradingsim`.`news` MODIFY `body` TEXT NOT NULL;
  3422.     ALTER TABLE `tradingsim`.`persons` MODIFY `secondname` VARCHAR(10) NOT NULL;
  3423.     ALTER TABLE `tradingsim`.`persons` MODIFY `second_email` CHAR(0);
  3424.     ALTER TABLE `tradingsim`.`persons` MODIFY `work_phone` CHAR(0) NOT NULL;
  3425.     ALTER TABLE `tradingsim`.`persons` MODIFY `mobile_phone` CHAR(0) NOT NULL;
  3426.     ALTER TABLE `tradingsim`.`persons` MODIFY `home_phone` CHAR(0) NOT NULL;
  3427.     ALTER TABLE `tradingsim`.`persons` MODIFY `username` VARCHAR(15) NOT NULL;
  3428.     ALTER TABLE `tradingsim`.`persons` MODIFY `photo_url` CHAR(0) NOT NULL;
  3429.     ALTER TABLE `tradingsim`.`persons` MODIFY `email_type` CHAR(0);
  3430.     ALTER TABLE `tradingsim`.`persons` MODIFY `fax_number` CHAR(0) NOT NULL;
  3431.     ALTER TABLE `tradingsim`.`persons` MODIFY `mts_priority` CHAR(0);
  3432.     ALTER TABLE `tradingsim`.`persons` MODIFY `silent_login_group_ID` CHAR(0);
  3433.     ALTER TABLE `tradingsim`.`persons` MODIFY `marketing_feedback` CHAR(0);
  3434.     ALTER TABLE `tradingsim`.`persons` MODIFY `person_type` CHAR(0);
  3435.     ALTER TABLE `tradingsim`.`persons` MODIFY `left_company` CHAR(0);
  3436.     ALTER TABLE `tradingsim`.`persons` MODIFY `immutable_ID` CHAR(0);
  3437.     ALTER TABLE `tradingsim`.`persons` MODIFY `media_server_ID` CHAR(0);
  3438.     ALTER TABLE `tradingsim`.`persons` MODIFY `jobtitle` CHAR(0);
  3439.     ALTER TABLE `tradingsim`.`persons` MODIFY `rdr_training_requirements` CHAR(0);
  3440.     ALTER TABLE `tradingsim`.`persons` MODIFY `rdr_qualifications_correct` CHAR(0);
  3441.     ALTER TABLE `tradingsim`.`persons` MODIFY `rdr_study_qualifications_correct` CHAR(0);
  3442.     ALTER TABLE `tradingsim`.`persons` MODIFY `har` CHAR(0);
  3443.     ALTER TABLE `tradingsim`.`persons` MODIFY `personal_email` CHAR(0);
  3444.     ALTER TABLE `tradingsim`.`stored_path_data` MODIFY `ID` MEDIUMINT(7) UNSIGNED NOT NULL;
  3445.     ALTER TABLE `tradingsim`.`stored_path_data` MODIFY `value` DECIMAL(18, 7) NOT NULL;
  3446.     ALTER TABLE `tradingsim`.`trader_responses` MODIFY `instance_ID` CHAR(0);
  3447.     Remove unused indexes.
  3448.     Restrict Host for 'simulations'@% to simulations@SpecificDNSorIp
  3449.     UPDATE mysql.user SET host ='SpecificDNSorIp' WHERE user='simulations' AND host ='%'; FLUSH PRIVILEGES;
  3450.     MySQL was started within the last 24 hours - recommendations may be inaccurate
  3451.     Reduce your overall MySQL memory footprint for system stability
  3452.     Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  3453.     We will suggest raising the 'join_buffer_size' until JOINs not using indexes are found.
  3454.              See https://dev.mysql.com/doc/internals/en/join-buffer-size.html
  3455.              (specially the conclusions at the bottom of the page).
  3456.     Increase table_open_cache gradually to avoid file descriptor limits
  3457.     Read this before increasing table_open_cache over 64: https://bit.ly/2Fulv7r
  3458.     Read this before increasing for MariaDB https://mariadb.com/kb/en/library/optimizing-table_open_cache/
  3459.     This is MyISAM only table_cache scalability problem, InnoDB not affected.
  3460.     See more details here: https://bugs.mysql.com/bug.php?id=49177
  3461.     This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
  3462.     Beware that open_files_limit (5000) variable
  3463.     should be greater than table_open_cache (2000)
  3464.     Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU
  3465. Variables to adjust:
  3466.     join_buffer_size (> 384.0K, or always use indexes with JOINs)
  3467.     table_open_cache (> 2000)
  3468.     innodb_log_file_size should be (=1G) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
  3469.  
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!