리자

mysqldumpslow

· 2011-08-02 (화) 17:37:20 · 2909
slowquery.log 를 분석한다

/etc/my.cnf 에

[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

를 설정한다.


mysqldumpslow -s c

-s sort_type
How to sort the output. The value of sort_type should be chosen from the following list:
t, at: Sort by query time or average query time
l, al: Sort by lock time or average lock time
r, ar: Sort by rows sent or average rows sent
c: Sort by count
By default, mysqldumpslow sorts by average query time (equivalent to -s at).<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
11-08-25 조회 3,681
11-08-25 조회 2,882
11-08-25 조회 2,574
11-08-24 조회 2,476
11-08-24 조회 3,105
11-08-24 조회 4,426
11-08-23 조회 2,496
11-08-23 조회 4,335
11-08-23 조회 3,474
11-08-23 조회 2,561
11-08-23 조회 2,788
11-08-23 조회 2,705
11-08-23 조회 2,840
11-08-23 조회 2,294
11-08-23 조회 2,437
11-08-23 조회 2,599
11-08-23 조회 3,005
11-08-23 조회 2,595
11-08-22 조회 3,035
11-08-22 조회 2,746
11-08-22 조회 2,891
11-08-22 조회 2,489
11-08-22 조회 2,760
11-08-21 조회 2,698
11-08-21 조회 2,624
11-08-20 조회 2,525
11-08-20 조회 2,893
11-08-20 조회 3,319
11-08-19 조회 2,728
11-08-19 조회 2,511
11-08-19 조회 5,043
11-08-19 조회 2,661
11-08-19 조회 2,514
11-08-19 조회 3,784
11-08-19 조회 3,226
11-08-18 조회 3,719
11-08-18 조회 2,250
11-08-18 조회 2,481
11-08-18 조회 2,309
11-08-18 조회 2,157
11-08-18 조회 2,276
11-08-18 조회 2,408
11-08-17 조회 3,204
11-08-17 조회 2,598
11-08-17 조회 2,735
11-08-17 조회 2,281
11-08-17 조회 2,702
11-08-17 조회 3,413
11-08-17 조회 2,822
11-08-16 조회 3,063
11-08-16 조회 2,567
11-08-16 조회 2,651
11-08-16 조회 2,516
11-08-16 조회 2,848
11-08-16 조회 2,651
11-08-16 조회 2,063
11-08-16 조회 2,224
11-08-16 조회 2,275
11-08-16 조회 2,632
11-08-16 조회 2,534
11-08-16 조회 2,525
11-08-15 조회 2,488
11-08-15 조회 3,015
11-08-13 조회 2,640
11-08-13 조회 2,679
11-08-13 조회 2,569
11-08-12 조회 2,349
11-08-12 조회 3,492
11-08-12 조회 3,277
11-08-12 조회 2,720
11-08-12 조회 2,521
11-08-11 조회 3,699
11-08-11 조회 2,992
11-08-11 조회 2,931
11-08-11 조회 2,460
11-08-10 조회 3,230
11-08-10 조회 5,445
11-08-10 조회 4,144
11-08-09 조회 2,723
11-08-09 조회 2,325
11-08-09 조회 2,406
11-08-09 조회 3,025
11-08-09 조회 2,680
11-08-09 조회 2,970
11-08-08 조회 3,062
11-08-08 조회 3,108
11-08-08 조회 2,200
11-08-08 조회 2,479
11-08-08 조회 4,394
11-08-08 조회 2,418
11-08-08 조회 2,948
11-08-08 조회 2,499
11-08-08 조회 2,303
11-08-08 조회 3,075
11-08-08 조회 2,332
11-08-07 조회 3,145
11-08-07 조회 2,696
11-08-06 조회 3,309
11-08-06 조회 3,315
11-08-06 조회 2,873