Guest User

Untitled

a guest
Mar 22nd, 2015
222
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [code]root@vm1:~# cat /etc/mysql/my.cnf
  2. # Generated by Percona Configuration Wizard (http://tools.percona.com/) version REL5-20120208
  3. [mysql]
  4.  
  5. # CLIENT #
  6. # Configure default options for clients
  7. port = 3306
  8.  
  9. [mysqld]
  10.  
  11. # GENERAL #
  12. # Choose user for execution, default storage engine and location of the PID file
  13. user = mysql
  14. default-storage-engine = InnoDB
  15. pid-file = /var/run/mysqld/mysqld.pid
  16. socket = /var/run/mysqld/mysqld.sock
  17. tmpdir = /var/lib/mysql/tmp
  18. lc-messages-dir = /usr/share/mysql
  19. skip-external-locking
  20. character-set-server = utf8
  21. collation-server = utf8_unicode_ci
  22.  
  23. # MyISAM #
  24. # Setup MyISAM options with a minimal config, as InnoDB is our default engine
  25. key-buffer-size = 32M
  26. myisam-recover = FORCE,BACKUP
  27.  
  28. # SAFETY #
  29. # Enforce limits and safety checks
  30. max-allowed-packet = 16M
  31. max-connect-errors = 1000000
  32. innodb = FORCE
  33.  
  34. # DATA STORAGE #
  35. # Select location for database files
  36. datadir = /var/lib/mysql/
  37.  
  38. # BINARY LOGGING #
  39. # Enable and setup the binary log
  40. #log-bin = /var/lib/mysql/mysql-bin
  41. #expire-logs-days = 14
  42. #sync-binlog = 1
  43. #expire_logs_days = 10
  44. #max_binlog_size = 100M
  45.  
  46. # CACHES AND LIMITS #
  47. # Configure reasonable default limits throughout Percona Server
  48. tmp-table-size = 32M
  49. max-heap-table-size = 32M
  50. query-cache-size = 32M
  51. max-connections = 4000
  52. thread-cache-size = 50
  53. open-files-limit = 65535
  54. table-definition-cache = 1024
  55. table-open-cache = 2048
  56. join_buffer_size = 256K
  57. query_cache_limit = 2M
  58. table_cache = 2048
  59.  
  60.  
  61.  
  62. # INNODB #
  63. # Setup InnoDB/XtraDB engine a 300MB buffer pool and 32MB log file size
  64. #innodb_data_file_path = ibdata1:128M;ibdata2:128M:max:32G
  65. innodb_data_file_path = ibdata1:32M:autoextend:max:32G
  66. innodb_file_per_table = 1
  67. innodb-flush-method = O_DIRECT
  68. innodb-log-files-in-group = 2
  69. #innodb-log-file-size = 32M
  70. innodb_log_file_size = 512M
  71. innodb_log_files_in_group = 3
  72. innodb-flush-log-at-trx-commit = 0
  73. innodb-buffer-pool-size = 15G
  74. innodb_thread_concurrency = 32
  75. innodb_lock_wait_timeout = 30
  76. innodb_autoextend_increment = 32
  77. # LOGGING #
  78. # Setup log file locations for error log and slow log
  79. # Slow log may be disabled on production setups to prevent extra IO
  80. log-queries-not-using-indexes = 1
  81. long_query_time = 2
  82. log-error=/var/log/mysql-errors.log
  83. log-slow-queries=/var/log/mysql-slow-queries.log
  84. [/code]
RAW Paste Data