# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log-bin = /Users/danwu/software/mysql-server-5.6/log/mysql-bin.log log-bin = mysql-bin general-log = /Users/danwu/software/mysql-server-5.6/log/mysql-log.log log-error = /Users/danwu/software/mysql-server-5.6/log/mysql_error.log
# These are commonly set, remove the # and set as required. basedir = /Users/danwu/software/mysql-server-5.6 datadir = /Users/danwu/software/mysql-server-5.6/data port = 3306 server_id = 1 socket = /Users/danwu/software/mysql-server-5.6/mysql.sock
# Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M
if (view->n_trx_ids > 0) { /* The last active transaction has the smallest id: */ view->up_limit_id = view->trx_ids[view->n_trx_ids - 1]; } else { view->up_limit_id = view->low_limit_id; }
/* Purge views are not added to the view list. */ if (cr_trx_id > 0) { read_view_add(view); }