Tuesday, April 10, 2012

Best practice Mysql configuration in development?

I tend to enable the following during development:



my.cnf



[mysqld]
 log_slow_queries    = /var/log/mysql/mysql-slow.log 
 sql_mode            = STRICT_ALL_TABLES


What other configurations would you recommend?




Posted by at

1 comment:

  1. javatubeApril 13, 2012 at 12:57 AM

    I would recommend the following additional options:

    # creates a innodb file per table instead of having all the tables in a single tablespace file
    innodb_file_per_table

    # increase the max allowed packet to a large size for file imports
    max_allowed_packet = 32M

    # the InnoDB pool size. use up to 80% available RAM for dedicated machines, and as much
    # as you can spare for development machines also depending on the size of the databases
    # you will be running so that as much of the database as possible fits into memory
    innodb_buffer_pool_size = 512M

    ReplyDelete

Subscribe to: Post Comments (Atom)