|
현재 저희서버 상태입니다.
innodb 상태를 보시고 조언 좀 부탁드립니다.
시스템이 너무 느리네요.ㅠㅠ
현재 저희서버 상태입니다.
innodb 상태를 보시고 조언 좀 부탁드립니다.
시스템이 너무 느리네요.ㅠㅠ
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
110530 11:00:35 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 34 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 101472 srv_active, 0 srv_shutdown, 91951 srv_idle
srv_master_thread log flush and writes: 193440
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 264286, signal count 289497
Mutex spin waits 192855619, rounds 191122568, OS waits 41755
RW-shared spins 207746, rounds 3498962, OS waits 97184
RW-excl spins 17122, rounds 276916, OS waits 4695
Spin rounds per wait: 0.99 mutex, 16.84 RW-shared, 16.17 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 5567CD75
Purge done for trx's n:o < 5567CD05 undo n:o < 0
History list length 3064
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0, not started, process no 18472, OS thread id 1703512976
MySQL thread id 644, query id 4852623 localhost root
SHOW ENGINE INNODB STATUS
---TRANSACTION 55679C68, not started, process no 18472, OS thread id 1700232080
MySQL thread id 642, query id 4783169
---TRANSACTION 5565B68F, not started, process no 18472, OS thread id 1703914384
MySQL thread id 431, query id 4158520
---TRANSACTION 5565B56A, not started, process no 18472, OS thread id 1704115088
MySQL thread id 430, query id 4156929
---TRANSACTION 5565AA35, not started, process no 18472, OS thread id 1704315792
MySQL thread id 429, query id 4144663
---TRANSACTION 5565A5B6, not started, process no 18472, OS thread id 1704516496
MySQL thread id 428, query id 4139562
---TRANSACTION 5565A3A5, not started, process no 18472, OS thread id 1704717200
MySQL thread id 427, query id 4137276
---TRANSACTION 5565A169, not started, process no 18472, OS thread id 1704917904
MySQL thread id 426, query id 4133669
---TRANSACTION 55659F15, not started, process no 18472, OS thread id 1705118608
MySQL thread id 425, query id 4130729
---TRANSACTION 55659A0F, not started, process no 18472, OS thread id 1705319312
MySQL thread id 424, query id 4125998
---TRANSACTION 5565962E, not started, process no 18472, OS thread id 1705520016
MySQL thread id 423, query id 4121806
---TRANSACTION 556591B1, not started, process no 18472, OS thread id 1705720720
MySQL thread id 422, query id 4118192
---TRANSACTION 55658969, not started, process no 18472, OS thread id 1705921424
MySQL thread id 421, query id 4116242
---TRANSACTION 55657FF3, not started, process no 18472, OS thread id 1706122128
MySQL thread id 420, query id 4113996
---TRANSACTION 55657254, not started, process no 18472, OS thread id 1706322832
MySQL thread id 419, query id 4111190
---TRANSACTION 5567BDC8, not started, process no 18472, OS thread id 1706523536
MySQL thread id 418, query id 4829863
---TRANSACTION 5567A4FF, not started, process no 18472, OS thread id 1706724240
MySQL thread id 417, query id 4793405
---TRANSACTION 556783FB, not started, process no 18472, OS thread id 1706924944
MySQL thread id 416, query id 4750452
---TRANSACTION 556768A8, not started, process no 18472, OS thread id 1707125648
MySQL thread id 415, query id 4717413
---TRANSACTION 55675109, not started, process no 18472, OS thread id 1707326352
MySQL thread id 414, query id 4696373
---TRANSACTION 55673EC0, not started, process no 18472, OS thread id 1707527056
MySQL thread id 413, query id 4673664
---TRANSACTION 5567236B, not started, process no 18472, OS thread id 1707727760
MySQL thread id 412, query id 4634947
---TRANSACTION 55670923, not started, process no 18472, OS thread id 1707928464
MySQL thread id 411, query id 4595001
---TRANSACTION 5566EAF5, not started, process no 18472, OS thread id 1708129168
MySQL thread id 410, query id 4549055
---TRANSACTION 5566C202, not started, process no 18472, OS thread id 1722051472
MySQL thread id 409, query id 4494124
---TRANSACTION 5566A731, not started, process no 18472, OS thread id 1722252176
MySQL thread id 408, query id 4457850
---TRANSACTION 55668CD0, not started, process no 18472, OS thread id 1725152144
MySQL thread id 407, query id 4416501
---TRANSACTION 55666B1B, not started, process no 18472, OS thread id 1727208336
MySQL thread id 406, query id 4367236
---TRANSACTION 5566569E, not started, process no 18472, OS thread id 1737735056
MySQL thread id 405, query id 4345524
---TRANSACTION 5566434D, not started, process no 18472, OS thread id 1737935760
MySQL thread id 404, query id 4324803
---TRANSACTION 55663699, not started, process no 18472, OS thread id 1738136464
MySQL thread id 403, query id 4305252
---TRANSACTION 55662801, not started, process no 18472, OS thread id 1738337168
MySQL thread id 402, query id 4287513
---TRANSACTION 55661B76, not started, process no 18472, OS thread id 1740233616
MySQL thread id 401, query id 4273510
---TRANSACTION 55660DC2, not started, process no 18472, OS thread id 1723054992
MySQL thread id 400, query id 4256427
---TRANSACTION 55660161, not started, process no 18472, OS thread id 1731423120
MySQL thread id 399, query id 4244111
---TRANSACTION 5565F726, not started, process no 18472, OS thread id 1729215376
MySQL thread id 398, query id 4232981
---TRANSACTION 5565EA54, not started, process no 18472, OS thread id 1725954960
MySQL thread id 397, query id 4214248
---TRANSACTION 5565E004, not started, process no 18472, OS thread id 1734232976
MySQL thread id 396, query id 4203995
---TRANSACTION 5565D8A5, not started, process no 18472, OS thread id 1732426640
MySQL thread id 395, query id 4194905
---TRANSACTION 5565D095, not started, process no 18472, OS thread id 1733229456
MySQL thread id 394, query id 4185715
---TRANSACTION 5565C9C8, not started, process no 18472, OS thread id 1736440720
MySQL thread id 393, query id 4180207
---TRANSACTION 5565C4BA, not started, process no 18472, OS thread id 1728211856
MySQL thread id 392, query id 4175049
---TRANSACTION 5565BFF6, not started, process no 18472, OS thread id 1730419600
MySQL thread id 391, query id 4169641
---TRANSACTION 5565BF03, not started, process no 18472, OS thread id 1728613264
MySQL thread id 390, query id 4168292
---TRANSACTION 5565BDD5, not started, process no 18472, OS thread id 1727409040
MySQL thread id 389, query id 4166942
---TRANSACTION 5567CD49, not started, process no 18472, OS thread id 1729616784
MySQL thread id 534, query id 4852517
---TRANSACTION 5567CD3E, not started, process no 18472, OS thread id 1733028752
MySQL thread id 532, query id 4852549
---TRANSACTION 5567CD5D, not started, process no 18472, OS thread id 1736240016
MySQL thread id 533, query id 4852614
---TRANSACTION 5567CD65, not started, process no 18472, OS thread id 1734634384
MySQL thread id 531, query id 4852533
---TRANSACTION 5567CD5E, not started, process no 18472, OS thread id 1732828048
MySQL thread id 530, query id 4852616
---TRANSACTION 5567CD5C, not started, process no 18472, OS thread id 1723857808
MySQL thread id 529, query id 4852612
---TRANSACTION 5567CD26, not started, process no 18472, OS thread id 1735838608
MySQL thread id 528, query id 4852513
---TRANSACTION 5567CD6D, not started, process no 18472, OS thread id 1732025232
MySQL thread id 527, query id 4852557
---TRANSACTION 5567CD4A, not started, process no 18472, OS thread id 1734835088
MySQL thread id 526, query id 4852519
---TRANSACTION 5567CD50, not started, process no 18472, OS thread id 1728412560
MySQL thread id 525, query id 4852573
---TRANSACTION 5567CD5F, not started, process no 18472, OS thread id 1731222416
MySQL thread id 523, query id 4852515
---TRANSACTION 5567CD68, not started, process no 18472, OS thread id 1725754256
MySQL thread id 524, query id 4852541
---TRANSACTION 5567CD63, not started, process no 18472, OS thread id 1791191952
MySQL thread id 521, query id 4852529
---TRANSACTION 5567CD51, not started, process no 18472, OS thread id 1722452880
MySQL thread id 522, query id 4852537
---TRANSACTION 5567CD4B, not started, process no 18472, OS thread id 1723657104
MySQL thread id 520, query id 4852521
---TRANSACTION 5567CD5A, not started, process no 18472, OS thread id 1735437200
MySQL thread id 519, query id 4852477
---TRANSACTION 5567CD45, not started, process no 18472, OS thread id 1727810448
MySQL thread id 518, query id 4852620
---TRANSACTION 5567CD70, not started, process no 18472, OS thread id 1722653584
MySQL thread id 517, query id 4852563
---TRANSACTION 5567CD61, not started, process no 18472, OS thread id 1732627344
MySQL thread id 515, query id 4852525
---TRANSACTION 5567CD6E, not started, process no 18472, OS thread id 1735035792
MySQL thread id 513, query id 4852559
---TRANSACTION 5567CD62, not started, process no 18472, OS thread id 1738537872
MySQL thread id 514, query id 4852527
---TRANSACTION 5567CD15, not started, process no 18472, OS thread id 1723456400
MySQL thread id 512, query id 4852553
---TRANSACTION 5567CD40, not started, process no 18472, OS thread id 1731623824
MySQL thread id 511, query id 4852571
---TRANSACTION 5567CD64, not started, process no 18472, OS thread id 1733831568
MySQL thread id 510, query id 4852531
---TRANSACTION 5567CD6B, not started, process no 18472, OS thread id 1728011152
MySQL thread id 509, query id 4852547
---TRANSACTION 5567CD60, not started, process no 18472, OS thread id 1730620304
MySQL thread id 508, query id 4852523
---TRANSACTION 5567CD44, not started, process no 18472, OS thread id 1727609744
MySQL thread id 507, query id 4852618
---TRANSACTION 5567CD5B, not started, process no 18472, OS thread id 1725553552
MySQL thread id 506, query id 4852479
---TRANSACTION 5567CD72, not started, process no 18472, OS thread id 1728813968
MySQL thread id 505, query id 4852567
---TRANSACTION 5567CD59, not started, process no 18472, OS thread id 1742015376
MySQL thread id 504, query id 4852602
---TRANSACTION 5567CD6A, not started, process no 18472, OS thread id 1736039312
MySQL thread id 503, query id 4852545
---TRANSACTION 5567CD6C, not started, process no 18472, OS thread id 1730821008
MySQL thread id 502, query id 4852555
---TRANSACTION 5567CD47, not started, process no 18472, OS thread id 1729817488
MySQL thread id 501, query id 4852505
---TRANSACTION 5567CD19, not started, process no 18472, OS thread id 1703312272
MySQL thread id 500, query id 4852551
---TRANSACTION 5567CD57, not started, process no 18472, OS thread id 1729416080
MySQL thread id 499, query id 4852587
---TRANSACTION 5567CD24, not started, process no 18472, OS thread id 1730218896
MySQL thread id 498, query id 4852509
---TRANSACTION 5567CD66, not started, process no 18472, OS thread id 1735236496
MySQL thread id 497, query id 4852535
---TRANSACTION 5567CCAE, not started, process no 18472, OS thread id 1723255696
MySQL thread id 496, query id 4851526
---TRANSACTION 5567CD55, not started, process no 18472, OS thread id 1735637904
MySQL thread id 495, query id 4852606
---TRANSACTION 5567CD6F, not started, process no 18472, OS thread id 1734032272
MySQL thread id 494, query id 4852561
---TRANSACTION 5567CD4F, not started, process no 18472, OS thread id 1734433680
MySQL thread id 493, query id 4852569
---TRANSACTION 5567CD67, not started, process no 18472, OS thread id 1731824528
MySQL thread id 492, query id 4852539
---TRANSACTION 5567CD58, not started, process no 18472, OS thread id 1740635024
MySQL thread id 491, query id 4852594
---TRANSACTION 5567CD73, not started, process no 18472, OS thread id 1740434320
MySQL thread id 488, query id 4852575
---TRANSACTION 5567CD31, not started, process no 18472, OS thread id 1732225936
MySQL thread id 487, query id 4852213
---TRANSACTION 5567CD56, not started, process no 18472, OS thread id 1729014672
MySQL thread id 485, query id 4852583
---TRANSACTION 5567CD25, not started, process no 18472, OS thread id 1742416784
MySQL thread id 489, query id 4852511
---TRANSACTION 5567CD69, not started, process no 18472, OS thread id 1739832208
MySQL thread id 486, query id 4852543
---TRANSACTION 5567CD71, not started, process no 18472, OS thread id 1733630864
MySQL thread id 490, query id 4852565
---TRANSACTION 5565BAAC, not started, process no 18472, OS thread id 1733430160
MySQL thread id 388, query id 4163238
---TRANSACTION 5565B9BA, not started, process no 18472, OS thread id 1730018192
MySQL thread id 387, query id 4162304
---TRANSACTION 5565B862, not started, process no 18472, OS thread id 1731021712
MySQL thread id 386, query id 4160804
---TRANSACTION 5567CD74, ACTIVE 0 sec, process no 18472, OS thread id 1725352848 fetching rows
mysql tables in use 1, locked 0
MySQL thread id 516, query id 4852622 Sending data
select if(count(image_id) > 0,'Y', 'N') from album_comment where delete_yn = 'N' and image_id=2956566 and to_days(now()) - to_days(write_date) <= 7
Trx read view will not see trx with id >= 5567CD75, sees < 5567CD75
--------
FILE I/O
--------
I/O thread 0 state: waiting for i/o request (insert buffer thread)
I/O thread 1 state: waiting for i/o request (log thread)
I/O thread 2 state: waiting for i/o request (read thread)
I/O thread 3 state: waiting for i/o request (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 state: waiting for i/o request (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
1734446 OS file reads, 840009 OS file writes, 179459 OS fsyncs
20.71 reads/s, 16384 avg bytes/read, 1.15 writes/s, 1.15 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 5, seg size 7, 4543 merges
merged operations:
insert 9131, delete mark 6, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 4425227, node heap has 3531 buffer(s)
6713.42 hash searches/s, 98996.85 non-hash searches/s
---
LOG
---
Log sequence number 34548730728
Log flushed up to 34548730728
Pages flushed up to 34548716820
Last checkpoint at 34548716820
0 pending log writes, 0 pending chkp writes
115968 log i/o's done, 1.15 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 1093926912; in additional pool allocated 0
Dictionary memory allocated 1799894
Buffer pool size 65535
Free buffers 0
Database pages 62004
Old database pages 22868
Modified db pages 92
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 9427812, not young 0
100.76 youngs/s, 0.00 non-youngs/s
Pages read 6101195, created 281912, written 1248733
20.71 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 62004, unzip_LRU len: 0
I/O sum[2383]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
2 read views open inside InnoDB
Main thread process no. 18472, id 1801882512, state: sleeping
Number of rows inserted 19768622, updated 41732, deleted 0, read 339653859
0.68 inserts/s, 0.32 updates/s, 0.00 deletes/s, 937789.95 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.02 sec)
|
