If I want to reduce disk I/O,what should be done with DBMaker? (From DBMR1742)

~ 0 min
2016-03-07 10:46

DBMaker 4.3 supports two internal configuration keywords (DB_DSYNC, and DB_JSYCN), they can turn off DBMaker flush function and let the OS to control IO. But it's dangerous, because If the system crashed by abnormal operation, it is possible to cause Database data inconsistent. So generally speaking, we do not suggest do that.

If surely want to reduce the database’s I/O, try doing the following items:

  • Ÿ    set DB_JSYNC = 0 (turn off journal file flush function, before start db, set it in dmconfig.ini)
  • Ÿ    set DB_DSYNC = 0 (turn off database data file flush function, before start db, set it in dmconfig.ini)
  • Ÿ    set DB_STSVR = 0 (turn off statistics server)
  • Ÿ    set DB_BKSVR = 0 (turn off back up server)
  • Ÿ    set DB_IOSVR = 0 (turn off IO daemon server)
  • Ÿ    don't use DISTINCT,GROUP BY, ORDER BY at query, join tables (if join result is huge), this is for avoid sorting by DBMaker (creating a temp file)
  • Ÿ    don't create System File Object (avoid file IO)
  • Ÿ    don't use Text Index , rebuild index (avoid index file IO)
  • Ÿ    turn off tablespace Auto-extend fuction.
Average rating 0 (0 Votes)

You cannot comment on this entry

Tags