Guest User

Untitled

a guest
Nov 15th, 2013
43
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysql]
  2.  
  3. # CLIENT #
  4. port = 3306
  5. socket = /var/lib/mysql/mysql.sock
  6.  
  7. [mysqld]
  8.  
  9. # GENERAL #
  10. user = mysql
  11. default-storage-engine = InnoDB
  12. socket = /var/lib/mysql/mysql.sock
  13. pid-file = /var/lib/mysql/mysql.pid
  14.  
  15. # MyISAM #
  16. key-buffer-size = 32M
  17. myisam-recover = FORCE,BACKUP
  18.  
  19. # SAFETY #
  20. max-allowed-packet = 16M
  21. max-connect-errors = 1000000
  22.  
  23. # DATA STORAGE #
  24. datadir = /var/lib/mysql/
  25.  
  26. # BINARY LOGGING #
  27. log-bin = /var/lib/mysql/mysql-bin
  28. expire-logs-days = 14
  29. sync-binlog = 1
  30.  
  31. # CACHES AND LIMITS #
  32. tmp-table-size = 32M
  33. max-heap-table-size = 32M
  34. query-cache-type = 1
  35. query-cache-size = 10M
  36. max-connections = 15000
  37. thread-cache-size = 100
  38. open-files-limit = 65535
  39. table-definition-cache = 15
  40. table-open-cache = 2048
  41. max-allowed-packet = 16MB
  42.  
  43. # INNODB #
  44. innodb-flush-method = O_DIRECT
  45. innodb-log-files-in-group = 2
  46. innodb-log-file-size = 512M
  47. innodb-flush-log-at-trx-commit = 2
  48. innodb-file-per-table = 1
  49. innodb-buffer-pool-size = 18G
  50.  
  51. # INNODB MULTITHREADED #
  52. innodb_thread_concurrency = 0
  53. innodb_concurrency_tickets = 10
  54. innodb_thread_sleep_delay = 1000
  55. innodb_read_io_threads = 64
  56. innodb_write_io_threads = 64
  57. innodb_replication_delay = 1000
  58. innodb_use_sys_malloc = ON
  59.  
  60.  
  61. # LOGGING #
  62. log-error = /var/lib/mysql/mysql-error.log
  63. log-queries-not-using-indexes = 1
  64. slow-query-log = 1
  65. slow-query-log-file = /var/lib/mysql/mysql-slow.log
  66. userstat=1
RAW Paste Data