Skip to content

Instantly share code, notes, and snippets.

@yivo

yivo/gist:fef48a9ee4f1834be3bf26e4f2a84e4f

Created October 16, 2017 02:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save yivo/fef48a9ee4f1834be3bf26e4f2a84e4f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save yivo/fef48a9ee4f1834be3bf26e4f2a84e4f to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. yivo revised this gist Oct 16, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -17,7 +17,7 @@ pid-file = /var/lib/mysql/mysql.pid

    # MyISAM #
    key-buffer-size = 32M
    myisam-recover = FORCE,BACKUP
    # myisam-recover = FORCE,BACKUP

    # SAFETY #
    max-allowed-packet = 16M
  2. yivo created this gist Oct 16, 2017.
    58 changes: 58 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,58 @@
    # Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
    # Configuration name server-67 generated for [email protected] at 2017-10-15 10:34:05

    [mysql]

    # CLIENT #
    port = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]

    # GENERAL #
    user = mysql
    default-storage-engine = InnoDB
    socket = /var/lib/mysql/mysql.sock
    pid-file = /var/lib/mysql/mysql.pid

    # MyISAM #
    key-buffer-size = 32M
    myisam-recover = FORCE,BACKUP

    # SAFETY #
    max-allowed-packet = 16M
    max-connect-errors = 1000000
    skip-name-resolve
    sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY
    sysdate-is-now = 1
    innodb = FORCE

    # DATA STORAGE #
    datadir = /var/lib/mysql/

    # CACHES AND LIMITS #
    tmp-table-size = 256M
    max-heap-table-size = 256M
    query-cache-type = 0
    query-cache-size = 0
    max-connections = 500
    thread-cache-size = 50
    open-files-limit = 65535
    table-definition-cache = 1024
    table-open-cache = 2048
    sort_buffer_size = 256K
    read_rnd_buffer_size = 256K

    # INNODB #
    innodb-flush-method = O_DIRECT
    innodb-log-files-in-group = 2
    innodb-log-file-size = 256M
    innodb-flush-log-at-trx-commit = 1
    innodb-file-per-table = 1
    innodb-buffer-pool-size = 3G

    # LOGGING #
    log-error = /var/lib/mysql/mysql-error.log
    log-queries-not-using-indexes = 1
    slow-query-log = 1
    slow-query-log-file = /var/lib/mysql/mysql-slow.log