질문/공유질답게시판

[스쿨호스팅] 디비 불러오는게 느린거 같아요

Lv15
이온디

도메인 설정을 바꿔주니 접속속도는 어느 정도 해결이 되었는데

innodb 사용해서 그런 건가? 코노하도 같지 싶은데..

이상하게 스쿨호스팅은 일반 게시판 속도는 비슷한데, 

유독 최근게시물을 많이 불러오는 위젯이 많은 페이지의 경우 20초 이상씩 걸리더라고요. -_-a;;

세팅도 뭐 별반 다르게 한 게 없는데도 코노하랑 비교하면 많이 차이가 나네요.

 

그리고 FTP 전송속도는 처음엔 1메가, 그 뒤로 6메가, 그 뒤로 10-11메가씩도 나옵니다. 이젠 10메가로 유지됩니다.

코노하는 2메가 고정입니다.

위로 아래로
댓글 7
  • Lv36
    512MB짜리 서버에서 InnoDB 쓰면 망한다고 몇 번을 말씀드렸는데 이 양반이 계속... ㅡ.ㅡ
  • Lv36 Lv15

    innodb 사용하는 건 어떻게 체크하는 거에요?;
    라엘님 블로그 세팅법 보고 따라한 건데;;
    https://blog.lael.be/post/2600

    코노하랑 스쿨호스팅인데

     

    http://conoha.eond.com/square

    http://xynex.vps.phps.kr/index.php?mid=square

     

    같은 페이지인데-_-;

    불러오는게 어마어마하게 차이가 나네요;;

     

    20170302-phps-mysql.png

    20170302-conoha-mysql.png

     

  • Lv36 Lv13
    ㅋㅋㅋ
  • Lv15 Lv36

    1. InnoDB로 만들어져 있는 테이블을 모두 찾아서 MyISAM으로 바꿉니다.
    2. 여기를 참고하여 my.cnf (또는 거기서 인클루드된 server.cnf) 파일을 수정합니다.

    3. MySQL(MariaDB)를 재시작합니다.

  • Lv36 Lv15
    1. 이렇게 보여지는데... -_-;; 그렇게 많이 사용하고 있는거 같진 않은데 기본적으로 사용하면 느린 거지요?;

    MariaDB [(none)]> SHOW ENGINE INNODB STATUS\G
    *************************** 1. row ***************************
    Type: InnoDB
    Name:
    Status:
    =====================================
    2017-03-02 18:18:27 7fb55410db00 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 27 seconds
    -----------------
    BACKGROUND THREAD
    -----------------
    srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 21520 srv_idle
    srv_master_thread log flush and writes: 21511
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 4
    OS WAIT ARRAY INFO: signal count 4
    Mutex spin waits 5, rounds 60, OS waits 2
    RW-shared spins 2, rounds 60, OS waits 2
    RW-excl spins 0, rounds 0, OS waits 0
    Spin rounds per wait: 12.00 mutex, 30.00 RW-shared, 0.00 RW-excl
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 5382
    Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle
    History list length 0
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 0, not started
    MySQL thread id 1283, OS thread handle 0x7fb55410db00, query id 160669 localhost root init
    SHOW ENGINE INNODB STATUS
    ---TRANSACTION 5379, not started
    MySQL thread id 1, OS thread handle 0x7fb558595b00, query id 0 Waiting for requests
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
    I/O thread 1 state: waiting for completed aio requests (log thread)
    I/O thread 2 state: waiting for completed aio requests (read thread)
    I/O thread 3 state: waiting for completed aio requests (read thread)
    I/O thread 4 state: waiting for completed aio requests (read thread)
    I/O thread 5 state: waiting for completed aio requests (read thread)
    I/O thread 6 state: waiting for completed aio requests (write thread)
    I/O thread 7 state: waiting for completed aio requests (write thread)
    I/O thread 8 state: waiting for completed aio requests (write thread)
    I/O thread 9 state: waiting for completed aio requests (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
    175 OS file reads, 5 OS file writes, 5 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 0, seg size 2, 0 merges
    merged operations:
    insert 0, delete mark 0, delete 0
    discarded operations:
    insert 0, delete mark 0, delete 0
    0.00 hash searches/s, 0.00 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 1616889
    Log flushed up to 1616889
    Pages flushed up to 1616889
    Last checkpoint at 1616889
    Max checkpoint age 80826164
    Checkpoint age target 78300347
    Modified age 0
    Checkpoint age 0
    0 pending log writes, 0 pending chkp writes
    8 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 140771328; in additional pool allocated 0
    Total memory allocated by read views 88
    Internal hash tables (constant factor + variable factor)
    Adaptive hash index 2217568 (2213368 + 4200)
    Page hash 139112 (buffer pool 0 only)
    Dictionary cache 630991 (554768 + 76223)
    File system 817696 (812272 + 5424)
    Lock system 333592 (332872 + 720)
    Recovery system 0 (0 + 0)
    Dictionary memory allocated 76223
    Buffer pool size 8191
    Buffer pool size, bytes 134201344
    Free buffers 8034
    Database pages 157
    Old database pages 0
    Modified db pages 0
    Percent of dirty pages(LRU & free pages): 0.000
    Max dirty pages percent: 75.000
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 0, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 157, created 0, written 1
    0.00 reads/s, 0.00 creates/s, 0.00 writes/s
    No buffer pool page gets since the last printout
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 157, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    0 read views open inside InnoDB
    0 RW transactions active inside InnoDB
    0 RO transactions active inside InnoDB
    0 out of 1000 descriptors used
    Main thread process no. 1522, id 140416162707200, state: sleeping
    Number of rows inserted 0, updated 0, deleted 0, read 0
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    Number of system rows inserted 0, updated 0, deleted 0, read 0
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================

    1 row in set (0.00 sec)
  • Lv15 Lv36

    아무 것도 안 하고 InnoDB를 켜놓기만 해도 기본으로 메모리를 200~300메가 정도 먹습니다.

  • Lv8
    512MB에 mariadb를 기본값으로 돌리면 메모리 부족으로 계속 죽어요;
    저는 스왑 2GB 주고, 설정 변경하고, db양도 적고, 홈페이지 접속자가 거의 없어서 innodb로도 원활히 잘 돌아가네요ㅎㅎ