API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 13th, 2017
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.67 KB | None | 0 0
raw download clone embed print report
  1. ----------------------------
  2. mysqlreport output
  3. ----------------------------
  4.  
  5. MySQL 5.5.43-log uptime 73 18:49:37 Fri Jul 14 01:06:31 2017
  6.  
  7. __ Key _________________________________________________________________
  8. Buffer used 52.33M of 64.00M %Used: 81.76
  9. Current 53.47M %Usage: 83.55
  10. Write hit 99.89%
  11. Read hit 99.66%
  12.  
  13. __ Questions ___________________________________________________________
  14. Total 5.50G 862.1/s
  15. QC Hits 3.69G 579.6/s %Total: 67.23
  16. DMS 1.05G 164.1/s 19.04
  17. Com_ 515.62M 80.9/s 9.38
  18. COM_QUIT 253.01M 39.7/s 4.60
  19. -Unknown 14.01M 2.2/s 0.25
  20. Slow 2 s 279.42k 0.0/s 0.01 %DMS: 0.03 Log: ON
  21. DMS 1.05G 164.1/s 19.04
  22. SELECT 1.04G 163.5/s 18.97 99.61
  23. UPDATE 3.41M 0.5/s 0.06 0.33
  24. INSERT 697.43k 0.1/s 0.01 0.07
  25. DELETE 8.89k 0.0/s 0.00 0.00
  26. REPLACE 0 0/s 0.00 0.00
  27. Com_ 515.62M 80.9/s 9.38
  28. set_option 252.92M 39.7/s 4.60
  29. change_db 252.92M 39.7/s 4.60
  30. begin 4.88M 0.8/s 0.09
  31.  
  32. __ Rows ________________________________________________________________
  33. Rows 2.32T 364.7k/s
  34. Using idx 390.89G 61.3k/s %Index: 16.81
  35. Rows/question 423.02
  36.  
  37. __ SELECT and Sort _____________________________________________________
  38. Scan 151.61M 23.8/s %SELECT: 14.55
  39. Range 25.54M 4.0/s 2.45
  40. Full join 63.91k 0.0/s 0.01
  41. Range check 0 0/s 0.00
  42. Full rng join 0 0/s 0.00
  43. Sort scan 199.52M 31.3/s
  44. Sort range 704.66M 110.5/s
  45. Sort mrg pass 294.04k 0.0/s
  46.  
  47. __ Query Cache _________________________________________________________
  48. Memory usage 40.93M of 64.00M %Usage: 63.95
  49. Block Fragmnt 24.10%
  50. Hits 3.69G 579.6/s
  51. Inserts 1.04G 163.0/s
  52. Insrt:Prune 1.87:1 76.0/s
  53. Hit:Insert 3.56:1
  54.  
  55. __ Table Locks _________________________________________________________
  56. Waited 38.30k 0.0/s %Total: 0.00
  57. Immediate 1.17G 183.8/s
  58.  
  59. __ Tables ______________________________________________________________
  60. Open 1342 of 1024 %Cache: 131.05
  61. Opened 3.30k 0.0/s
  62.  
  63. __ Connections _________________________________________________________
  64. Max used 1020 of 2000 %Max: 51.00
  65. Total 253.05M 39.7/s
  66.  
  67. __ Created Temp ________________________________________________________
  68. Disk table 675.35k 0.1/s %Disk: 1.10
  69. Table 61.59M 9.7/s Size: 16.0M
  70. File 586.83k 0.1/s
  71.  
  72. __ Threads _____________________________________________________________
  73. Running 1001 of 1001
  74. Created 11.45k 0.0/s
  75. Slow 0 0/s
  76. Cached 19 of 128 %Hit: 100
  77.  
  78. __ Aborted _____________________________________________________________
  79. Clients 79.11k 0.0/s
  80. Connects 107.62k 0.0/s
  81.  
  82. __ Bytes _______________________________________________________________
  83. Sent 13.91T 2.2M/s
  84. Received 1.03T 160.8k/s
  85.  
  86. __ InnoDB Buffer Pool __________________________________________________
  87. Usage 127.98M of 127.98M %Usage: 100.00
  88. Read hit 99.38%
  89. Pages
  90. Free 0 %Total: 0.00
  91. Data 8.19k 99.98 %Drty: 0.00
  92. Misc 2 0.02
  93. Latched 0 0.00
  94. Reads 53.34G 8.4k/s
  95. From disk 330.23M 51.8/s %Disk: 0.62
  96. Ahead Rnd 0 0/s
  97. Writes 47.98M 7.5/s
  98. Wait Free 0 0/s %Wait: 0.00
  99. Flushes 6.42M 1.0/s
  100.  
  101. __ InnoDB Lock _________________________________________________________
  102. Waits 0 0/s
  103. Current 0
  104. Time acquiring
  105. Total 0 ms
  106. Average 0 ms
  107. Max 0 ms
  108.  
  109. __ InnoDB Data, Pages, Rows ____________________________________________
  110. Data
  111. Reads 433.99M 68.1/s
  112. Writes 10.80M 1.7/s
  113. fsync 4.62M 0.7/s
  114. Pending
  115. Reads 0
  116. Writes 0
  117. fsync 0
  118.  
  119. Pages
  120. Created 85.50k 0.0/s
  121. Read 433.99M 68.1/s
  122. Written 6.42M 1.0/s
  123.  
  124. Rows
  125. Deleted 2.69k 0.0/s
  126. Inserted 302.33k 0.0/s
  127. Read 334.24G 52.4k/s
  128. Updated 3.36M 0.5/s
  129.  
  130. ----------------------------
  131. MySQL settings
  132. ----------------------------
  133. [mysqld]
  134. datadir = /var/lib/mysql
  135. socket = /var/lib/mysql/mysql.sock
  136. user = mysql
  137. server-id = 70
  138. expire_logs_days = 10
  139.  
  140. # to prevent assorted security risks
  141. symbolic-links=0
  142.  
  143. # connection and thread variables
  144. max_allowed_packet = 64M
  145. max_connections = 2000
  146. max_user_connections = 1000
  147. max_connect_errors = 100
  148. thread_cache_size = 128
  149.  
  150. # query cache
  151. query_cache_type = 1
  152. query_cache_size = 64M
  153.  
  154. # session variables
  155. sort_buffer_size = 1M
  156. tmp_table_size = 16M
  157. read_buffer_size = 1M
  158. read_rnd_buffer_size = 1M
  159. join_buffer_size = 2M
  160.  
  161. # Other buffers and caches
  162. table_definition_cache = 400
  163. table_open_cache = 1024
  164.  
  165. # MyISAM variables
  166. key_buffer_size = 64M
  167.  
  168. # MEMORY variables
  169. max_heap_table_size = 16M
  170.  
  171. # InnoDB variables
  172.  
  173. #innodb_strict_mode = ON
  174. #innodb_file_format_check = 1
  175. #innodb_file_format = Barracuda
  176. #innodb_buffer_pool_size = 128M
  177. #innodb_buffer_pool_instances = 8
  178.  
  179. #innodb_file_per_table = 1
  180. #innodb_flush_method = O_DIRECT
  181. #innodb_write_io_threads = 8
  182. #innodb_read_io_threads = 8
  183. #innodb_io_capacity = 1000
  184.  
  185. #innodb_flush_log_at_trx_commit = 0
  186. #innodb_log_buffer_size = 8M
  187. #innodb_log_file_size = 256M
  188.  
  189.  
  190. # Default to using old password format for compatibility with mysql 3.x
  191. # clients (those using the mysqlclient10 compatibility package).
  192. #master-host = 172.16.4.230
  193. #master-user = replicate
  194. #master-password = redhat
  195. #master-port = 3306 #default MySQL already used port 3306)
  196. #replicate-ignore-db = mysql
  197.  
  198. log-bin = mysql-bin
  199. binlog_format=mixed
  200. skip_slave_start = 0
  201.  
  202. replicate-do-db = application_db
  203. replicate-do-db = frontend_db
  204. replicate-do-db = jgfg_frontend_db
  205. replicate-ignore-db = mysql
  206.  
  207.  
  208. skip-name-resolve
  209. log-slow-queries=/var/log/mysql-slow.log
  210. long_query_time = 2
  211.  
  212.  
  213. [mysqld_safe]
  214. log-error=/var/log/mysqld.log
  215. pid-file=/var/run/mysqld/mysqld.pid
  216.  
  217.  
  218. [mysqldump]
  219. quick
  220. max_allowed_packet = 16M
  221.  
  222. [mysql]
  223. no-auto-rehash
  224.  
  225. [isamchk]
  226. key_buffer = 128M
  227. sort_buffer_size = 128M
  228. read_buffer = 2M
  229. write_buffer = 2M
  230.  
  231. [myisamchk]
  232. key_buffer = 128M
  233. sort_buffer_size = 128M
  234. read_buffer = 2M
  235. write_buffer = 2M
  236.  
  237. [mysqlhotcopy]
  238. interactive-timeout
  239.  
  240.  
  241. ---
  242.  
  243. ----------------------------
  244. INNODB Status
  245. ----------------------------
  246. *************************** 1. row ***************************
  247. Type: InnoDB
  248. Name:
  249. Status:
  250. =====================================
  251. 170714 1:06:31 INNODB MONITOR OUTPUT
  252. =====================================
  253. Per second averages calculated from the last 32 seconds
  254. -----------------
  255. BACKGROUND THREAD
  256. -----------------
  257. srv_master_thread loops: 6147736 1_second, 6147514 sleeps, 598140 10_second, 169728 background, 169688 flush
  258. srv_master_thread log flush and writes: 6172507
  259. ----------
  260. SEMAPHORES
  261. ----------
  262. OS WAIT ARRAY INFO: reservation count 5682417, signal count 5781579
  263. Mutex spin waits 19405870, rounds 37075377, OS waits 66396
  264. RW-shared spins 8485025, rounds 221702441, OS waits 5323138
  265. RW-excl spins 955913, rounds 11098250, OS waits 151918
  266. Spin rounds per wait: 1.91 mutex, 26.13 RW-shared, 11.61 RW-excl
  267. ------------
  268. TRANSACTIONS
  269. ------------
  270. Trx id counter C81E4CD
  271. Purge done for trx's n:o < C81B515 undo n:o < 0
  272. History list length 2776
  273. LIST OF TRANSACTIONS FOR EACH SESSION:
  274. ---TRANSACTION 0, not started
  275. MySQL thread id 253045295, OS thread handle 0x7f6c35412700, query id 5506032207 localhost root
  276. show engine innodb status
  277. ---TRANSACTION 0, not started
  278. MySQL thread id 252940084, OS thread handle 0x7f6ee9d36700, query id 5506023411 172.16.4.225 moc-dbs Waiting for table level lock
  279. SELECT
  280. a.id
  281. ,a.title
  282. ,a.sub_title
  283. ,a.slug
  284. ,a.summary
  285. ,a.summary_2
  286. ,a.date_publish
  287. ,a.channel_level_1_id
  288. ,a.channel_level_2_id
  289. ,a.channel_id
  290. ,a.is_exclusive
  291. ,a.is_fastest
  292.  
  293. FROM articles a
  294. WHERE
  295. a.id IS NOT NULL
  296. AND a.is_running_news_level_1 = 1
  297.  
  298.  
  299. AND ( (a.channel_level_2_id NOT IN(104)) AND (a.channel_level_2_id NOT IN(50030)) OR a.channel_level_2_id IS NULL )
  300.  
  301. AND date_publish >= '2017-06-30 00:00:00'
  302.  
  303.  
  304. ORDER BY
  305. a.date_publish DESC
  306. LIMIT 0, 4
  307. ---TRANSACTION 0, not started
  308. MySQL thread id 252937909, OS thread handle 0x7f6ef0ebd700, query id 5506002385 172.16.4.225 moc-dbs Waiting for table level lock
  309. SELECT ara.id,
  310. ara.article_id,
  311. ara.related_article_id,
  312. ara.related_title,
  313. ara.related_slug,
  314. (SELECT channel_level_1_id FROM articles WHERE id=ara.related_article_id) AS related_channel_level_1_id,
  315. (SELECT channel_level_2_id FROM articles WHERE id=ara.related_article_id) AS related_channel_level_2_id,
  316. ara.channel_id,
  317. ara.related_date_publish,
  318. ara.channel_level_1_id
  319. FROM articles_related_articles AS ara
  320. WHERE ara.article_id = '932903'
  321.  
  322. ---TRANSACTION C81E465, not started
  323. MySQL thread id 1, OS thread handle 0x7f6f5a522700, query id 5506002236 Waiting for table level lock
  324. UPDATE `articles` SET `id` = '926422', `slug` = 'sinopsis-anandhi-15-juni-hadiah-sanchi', `title` = 'Sinopsis Anandhi 15 Juni: Hadiah Sanchi', `summary` = 'Kalyani meminta Jagdish untuk segera mengirim Gauri dari Hindu Badi.', `sub_title` = '', `body` = '<p><strong>VIVA.co.id</strong> – Di sinopsis Anandhi hari ini, Kamis, 15 Juni 2017 episode 457, keluarga di Kesar Bagh dan Badi Haveli merayakan Raksha Bandhan. Kalyani meminta Jagdish untuk segera mengirim Gauri dari Hindu Badi. </p>\r\n\r\n<p>Gauri mengatakan pada Jagdish bahwa dia seharusnya pulang ke rumah untuk merayakan Teej. Gang
  325. ---TRANSACTION C81B26A, ACTIVE 7398 sec
  326. mysql tables in use 1, locked 0
  327. MySQL thread id 252787448, OS thread handle 0x7f6f541f6700, query id 5502902407 172.16.4.225 moc-dbs Copying to tmp table
  328. SELECT
  329. a.id
  330. ,a.title
  331. ,a.slug
  332. ,a.summary
  333. ,a.summary_2
  334. ,a.date_publish
  335. ,b.viewed
  336. ,a.channel_level_1_id
  337. ,a.channel_level_2_id
  338. ,a.channel_id
  339. ,a.is_exclusive
  340. ,a.is_fastest
  341. ,a.meta_tags
  342. ,DATE(a.date_publish) AS pdate
  343. FROM articles a, count_viewed_article b
  344. WHERE
  345. a.id = b.id
  346.  
  347. AND a.channel_level_1_id IN (8,25400253) OR a.channel_level_2_id IN (8,25400253)
  348. AND a.channel_level_1_id NOT IN(31,35)
  349. AND a.channel_id NOT IN(80507,80508,80509,80510)
  350. AND DATE(b.last_viewed) >=
  351. Trx read view will not see trx with id >= C81B26B, sees < C81B21B
  352. ---TRANSACTION C81B261, ACTIVE 7398 sec
  353. mysql tables in use 1, locked 0
  354. MySQL thread id 252787437, OS thread handle 0x7f6ef90c5700, query id 5502902210 172.16.4.225 moc-dbs Copying to tmp table
  355. SELECT
  356. a.id
  357. ,a.title
  358. ,a.slug
  359. ,a.summary
  360. ,a.summary_2
  361. ,a.date_publish
  362. ,b.viewed
  363. ,a.channel_level_1_id
  364. ,a.channel_level_2_id
  365. ,a.channel_id
  366. ,a.is_exclusive
  367. ,a.is_fastest
  368. ,a.meta_tags
  369. ,DATE(a.date_publish) AS pdate
  370. FROM articles a, count_viewed_article b
  371. WHERE
  372. a.id = b.id
  373.  
  374. AND a.channel_level_1_id IN (8,25400253) OR a.channel_level_2_id IN (8,25400253)
  375. AND a.channel_level_1_id NOT IN(31,35)
  376. AND a.channel_id NOT IN(80507,80508,80509,80510)
  377. AND DATE(b.last_viewed) >=
  378. Trx read view will not see trx with id >= C81B262, sees < C81B21B
  379. ---TRANSACTION C81B21B, ACTIVE 7450 sec
  380. mysql tables in use 1, locked 0
  381. MySQL thread id 252785623, OS thread handle 0x7f6efa1c8700, query id 5502867040 172.16.4.225 moc-dbs Copying to tmp table
  382. SELECT
  383. a.id
  384. ,a.title
  385. ,a.slug
  386. ,a.summary
  387. ,a.summary_2
  388. ,a.date_publish
  389. ,b.viewed
  390. ,a.channel_level_1_id
  391. ,a.channel_level_2_id
  392. ,a.channel_id
  393. ,a.is_exclusive
  394. ,a.is_fastest
  395. ,a.meta_tags
  396. ,DATE(a.date_publish) AS pdate
  397. FROM articles a, count_viewed_article b
  398. WHERE
  399. a.id = b.id
  400.  
  401. AND a.channel_level_1_id IN (8,25400253) OR a.channel_level_2_id IN (8,25400253)
  402. AND a.channel_level_1_id NOT IN(31,35)
  403. AND a.channel_id NOT IN(80507,80508,80509,80510)
  404. AND DATE(b.last_viewed) >=
  405. Trx read view will not see trx with id >= C81B21C, sees < C81B21C
  406. --------
  407. FILE I/O
  408. --------
  409. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  410. I/O thread 1 state: waiting for completed aio requests (log thread)
  411. I/O thread 2 state: waiting for completed aio requests (read thread)
  412. I/O thread 3 state: waiting for completed aio requests (read thread)
  413. I/O thread 4 state: waiting for completed aio requests (read thread)
  414. I/O thread 5 state: waiting for completed aio requests (read thread)
  415. I/O thread 6 state: waiting for completed aio requests (write thread)
  416. I/O thread 7 state: waiting for completed aio requests (write thread)
  417. I/O thread 8 state: waiting for completed aio requests (write thread)
  418. I/O thread 9 state: waiting for completed aio requests (write thread)
  419. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  420. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  421. Pending flushes (fsync) log: 0; buffer pool: 0
  422. 433992319 OS file reads, 10803996 OS file writes, 4621276 OS fsyncs
  423. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  424. -------------------------------------
  425. INSERT BUFFER AND ADAPTIVE HASH INDEX
  426. -------------------------------------
  427. Ibuf: size 1, free list len 14, seg size 16, 1560149 merges
  428. merged operations:
  429. insert 1313493, delete mark 1405402, delete 303966
  430. discarded operations:
  431. insert 0, delete mark 0, delete 0
  432. Hash table size 276671, node heap has 2 buffer(s)
  433. 0.00 hash searches/s, 0.00 non-hash searches/s
  434. ---
  435. LOG
  436. ---
  437. Log sequence number 32050175226
  438. Log flushed up to 32050175226
  439. Last checkpoint at 32050175226
  440. 0 pending log writes, 0 pending chkp writes
  441. 4043661 log i/o's done, 0.00 log i/o's/second
  442. ----------------------
  443. BUFFER POOL AND MEMORY
  444. ----------------------
  445. Total memory allocated 137363456; in additional pool allocated 0
  446. Dictionary memory allocated 352743
  447. Buffer pool size 8191
  448. Free buffers 0
  449. Database pages 8189
  450. Old database pages 3002
  451. Modified db pages 0
  452. Pending reads 0
  453. Pending writes: LRU 0, flush list 0, single page 0
  454. Pages made young 635858659, not young 0
  455. 0.00 youngs/s, 0.00 non-youngs/s
  456. Pages read 433992406, created 85495, written 6423316
  457. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  458. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  459. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  460. LRU len: 8189, unzip_LRU len: 0
  461. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  462. --------------
  463. ROW OPERATIONS
  464. --------------
  465. 0 queries inside InnoDB, 0 queries in queue
  466. 4 read views open inside InnoDB
  467. Main thread process no. 10620, id 140116167300864, state: waiting for server activity
  468. Number of rows inserted 302335, updated 3364729, deleted 2685, read 334239518466
  469. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 3135.00 reads/s
  470. ----------------------------
  471. END OF INNODB MONITOR OUTPUT
  472. ============================
  473.  
  474.  
  475. ----------------------------
  476. MySQL Error Log
  477. ----------------------------
  478.  
  479. 170714 0:59:04 [ERROR] Invalid (old?) table or database name 'lost+found'
  480. 170714 0:59:04 [ERROR] Invalid (old?) table or database name 'lost+found'
  481. 170714 1:03:12 [ERROR] Invalid (old?) table or database name 'lost+found'
  482. 170714 1:03:12 [ERROR] Invalid (old?) table or database name 'lost+found'
  483. 170714 1:03:20 [ERROR] Invalid (old?) table or database name 'lost+found'
  484. 170714 1:03:20 [ERROR] Invalid (old?) table or database name 'lost+found'
  485. 170714 1:03:35 [ERROR] Invalid (old?) table or database name 'lost+found'
  486. 170714 1:03:35 [ERROR] Invalid (old?) table or database name 'lost+found'
  487. 170714 1:04:44 [ERROR] Invalid (old?) table or database name 'lost+found'
  488. 170714 1:04:44 [ERROR] Invalid (old?) table or database name 'lost+found'
  489. 170714 1:04:52 [ERROR] Invalid (old?) table or database name 'lost+found'
  490. 170714 1:04:52 [ERROR] Invalid (old?) table or database name 'lost+found'
  491. 170714 1:04:58 [ERROR] Invalid (old?) table or database name 'lost+found'
  492. 170714 1:06:25 [ERROR] Invalid (old?) table or database name 'lost+found'
  493. 170714 1:06:25 [ERROR] Invalid (old?) table or database name 'lost+found'
  494.  
  495. ----------------------------
  496. Total Server MyISAM and InnoDB Size
  497. ----------------------------
  498. *************************** 1. row ***************************
  499. innodb_tablespace_utilization_perc: 100
  500. total_size_gb: 7.548331723548472
  501. index_size_gb: 1.2553825378417969
  502. data_size_gb: 6.292949185706675
  503. innodb_total_size_gb: 0.8527679443359375
  504. innodb_data_size_gb: 0.5355377197265625
  505. innodb_index_size_gb: 0.317230224609375
  506. myisam_total_size_gb: 6.695563779212534
  507. myisam_data_size_gb: 5.7574114659801126
  508. myisam_index_size_gb: 0.9381523132324219
  509. perc_index: 16.631258100
  510. perc_data: 83.368741800
  511. innodb_perc_index: 37.200064400
  512. innodb_perc_data: 62.799935500
  513. myisam_perc_index: 14.011550600
  514. myisam_perc_data: 85.988449300
  515. innodb_perc_total_index: 25.269606200
  516. innodb_perc_total_data: 8.510123000
  517. myisam_perc_total_index: 74.730393700
  518. myisam_perc_total_data: 91.489876900
  519.  
  520. Report Complete:
  521. Fri Jul 14 01:06:31 WIB 2017
  522. ---------------------------
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!