Hawkeyes kill hard disk usage by mysql #76


  • New
  • Defect
Open
Assigned to _ForgeUser7076494
  • _ForgeUser1334888 created this issue Oct 6, 2011

    -----------------------What is the problem?
    When Hawkeyes is started oon my (2) servers it use sqldatabase non stop (ibdata1 for xampp) and also use 100% of my hard disk activity and make crash my serveurs all the days or if no crash make heavy lag.

    -----------------------What steps will reproduce the problem?
    1.when people do something logged by hawkeyes
    2.when i use sql functionnality
    3.all time

    -----------------------What version of HawkEye are you using (shown in console during start-up)?
    1.0.5

    -----------------------Show me any console errors and/or your start-up console message for HawkEye
    no errors, never

    -----------------------Show me your config.yml and/or your config.php (REMOVE YOUR PASSWORD)
    ********************************
    block-filter:
    - 97
    - 98
    log:
        lava-bucket: true
        painting-place: true
        other: true
        pvp-death: true
        block-fade: true
        chat: true
        enderman-place: true
        quit: true
        sign-place: true
        enderman-pickup: true
        painting-break: true
        lava-flow: true
        flint-steel: true
        button: true
        command: true
        block-form: true
        teleport: true
        lever: true
        item-drop: true
        water-bucket: true
        block-burn: true
        sign-break: true
        block-break: true
        leaf-decay: true
        water-flow: true
        join: true
        door-interact: true
        block-place: true
        open-container: true
        item-pickup: true
        explosion: true
        container-transaction: true
        mob-death: true
        other-death: true
    general:
        check-for-updates: true
        max-lines: 0
        tool-block: '17'
        log-item-drops-on-death: false
        cleanse-age: '0'
        default-tool-command: ''
        delete-data-on-rollback: false
        cleanse-period: 20m
        log-ip-addresses: true
        debug: false
        max-radius: 0
        default-here-radius: 5
    mysql:
        hawkeye-table: hawkeye
        port: 3306
        player-table: hawk_players
        username: root
        world-table: hawk_worlds
        hostname: localhost
        max-connections: 10
        password: ********
        database: minecraft
    version: 1.0.5
    command-filter:
    - /login
    - /restartsrv
    - /register
    **********************

    -----------------------Have you checked the FAQ page?
    no

  • _ForgeUser1334888 added the tags Defect New Oct 6, 2011
  • _ForgeUser1334888 edited description Oct 6, 2011
  • _ForgeUser7076494 posted a comment Oct 7, 2011

    That's not HawkEye. Sounds like your MySQL setup is screwed up.

  • _ForgeUser593114 posted a comment Oct 10, 2011

    Turn off water flow and lava flow, those should be off by default. They log the flow of all environmental water/lava. You can keep their bucket counter-parts enable to find out if someone placed either.

    Also stuff like leaf decay is pointless and eats up performance/HD.

    Block pick up can also eat up HD. EVERY time someone picks up anything it gets logged. You'd rarely need to see the thousands of dirt blocks or cobblestone someone gathered.

  • _ForgeUser1334888 posted a comment Oct 12, 2011

    ok i will try to remove that, perhaps i will not have the problem again i push my serveurs on ssd disk sandforce3.


To post a comment, please login or register a new account.