'전체 글'에 해당되는 글 96건

How to reference

https://docs.mongodb.com/manual/reference/command/convertToCapped/


But,
1. This command makes db global lock while end this command. It takes several minutes or more according to how many data is stored.
2. This command will remove all indexes of target collection


'mongoDB' 카테고리의 다른 글

How to mount mongoDB disk to /data folder  (0) 2018.02.23
mongos setup on centos  (0) 2018.01.12
mongodb profiling 과 AWS EBS IOPS에대한 고찰이라고나 할까?  (0) 2015.05.06
Shading  (0) 2014.04.23
블로그 이미지

시간을 거스르는자

ytkang86@gmail.com

,

1. find all disk attached to this machine
    sudo fdisk -l
    Disk /dev/xvda: 8589 MB, 8589934592 bytes, 16777216 sectors
    ..
    Disk /dev/nvme0n1: 950.0 GB, 950000000000 bytes, 1855468750 sectors
    ..

2. select target to make as a /data folder
    "/dev/nvme0n1"

3. format disk to xfs filesystem
    sudo mkfs -t xfs /dev/nvme0n1

4. mount disk to /data folder
    sudo mkdir -p /data
    sudo mount /dev/nvme0n1 /data
    check mounted disk list: df -TH

5. give permission to mongod user
    sudo chown mongod:mongod /data



'mongoDB' 카테고리의 다른 글

mongodb "convert to capped collection" effect  (0) 2018.02.23
mongos setup on centos  (0) 2018.01.12
mongodb profiling 과 AWS EBS IOPS에대한 고찰이라고나 할까?  (0) 2015.05.06
Shading  (0) 2014.04.23
블로그 이미지

시간을 거스르는자

ytkang86@gmail.com

,

Making scheduler for expiry

mysql 2018. 1. 19. 16:37

use mydb;


alter EVENT expireRow

ON SCHEDULE

EVERY 1 HOUR

DO 

DELETE FROM thatTable 

WHERE TIMESTAMPDIFF(DAY, date , NOW()) > 7


==


SHOW EVENTS FROM mydb;

'mysql' 카테고리의 다른 글

connection, cursor, transaction 사용시 주의점  (0) 2015.02.04
블로그 이미지

시간을 거스르는자

ytkang86@gmail.com

,