anchor.diff:      MYSQL_FLUSHMETHOD=O_DIRECT
   #######################
   
  -
  +# update mysql config file with our setting above, which means mysql ENV's are set at build time
   RUN echo "innodb_buffer_pool_size = ${MYSQL_BUFFERSIZE}" >> ${MYSQL_CONFIG} && \
       echo "innodb_log_file_size = ${MYSQL_LOGSIZE}" >> ${MYSQL_CONFIG} && \
       echo "innodb_flush_log_at_trx_commit = ${MYSQL_FLUSHLOG}" >> ${MYSQL_CONFIG} && \
  
positive.code: FROM mysql:5.7
  
  # TO USE:
  # 1. customize ENV's below
  # 2. start container and it will create databases (could take minutes or longer)
  # 3. run /opt/sysbench_run.sh to kick off a test run
  
  # NOTE: mysql has a VOLUME at /var/lib/mysql
  # so you may want to customize the volume storage for that or bind-mount to host
  
  ##
  ## install sysbench
  
negative.code: 
  
  # this will create DB's on container start, and may take some time depending on your ENV's above
  # if you set them inline with -e during docker run, you can override defaults above before db is created
  RUN echo 'sysbench --test=/sysbench/tests/include/oltp_legacy/oltp.lua --oltp-tables-count=${SYSBENCH_TABLE_COUNT} --oltp-table-size=${SYSBENCH_TABLE_SIZE} --mysql-db=${MYSQL_DATABASE} --mysql-user=root prepare' > /docker-entrypoint-initdb.d/sysbench_prepare.sh && \
      chmod +x /docker-entrypoint-initdb.d/sysbench_prepare.sh
  
  
  # run /opt/sysbench_run.sh to start a single test run
  # if you set them inline with -e during docker exec, you can override defaults above before testing starts
  RUN echo 'sysbench --test=/sysbench/tests/include/oltp_legacy/oltp.lua --oltp-tables-count=${SYSBENCH_TABLE_COUNT} --oltp-table-size=${SYSBENCH_TABLE_SIZE} --oltp-test-mode=complex --num-threads=${SYSBENCH_NUM_THREADS} --max-time=${SYSBENCH_MAX_TIME} --max-requests=${SYSBENCH_MAX_REQUESTS} --mysql-db=${MYSQL_DATABASE} --mysql-user=root run' > /opt/sysbench_run.sh && \
      chmod +x /opt/sysbench_run.sh
  