ulvis.paste.net

Paste Search Dynamic
Recent pastes
mysql config
  1. [mysqld]
  2. # Server configuration
  3. user=mysql
  4. port=3306
  5. socket=/home/mysql/server/run/mysql.sock
  6.  
  7. # File locations
  8. datadir=/mysql/data
  9. basedir=/home/mysql/server
  10. lc_messages_dir=/usr/share/mysql-8.0
  11. plugin-dir=/lib64/mysql/plugin
  12. innodb_log_group_home_dir=/redolog/redologfiles
  13. innodb_data_file_path=ibdata1:12M:autoextend
  14. log-error=/home/mysql/server/logs/mysqld.log
  15. innodb_log_file_size=2147483648
  16. innodb_log_files_in_group=8
  17. innodb_page_size=16384
  18. innodb_checksum_algorithm=crc32
  19. innodb_buffer_pool_filename=ib_buffer_pool
  20. innodb_undo_tablespaces=2
  21. innodb_buffer_pool_filename=ib_buffer_pool
  22. skip-log-bin
  23.  
  24. # New server config
  25. character-set-server=latin1
  26. collation-server=latin1_swedish_ci
  27. connect_timeout=31530000
  28. net_read_timeout=31530000
  29. net_write_timeout=31530000
  30. innodb_buffer_pool_size=68719476736
  31. innodb_buffer_pool_instances=64
  32. innodb_temp_data_file_path=ibtmp1:512M:autoextend:max:512000M
  33. innodb_max_undo_log_size=4294967296
  34. innodb_read_io_threads=16
  35. binlog_expire_logs_seconds=259200
  36. #expire_logs_days=10
  37. max_binlog_size=1073741824
  38. sql_mode = ''
  39. max_connections=300
  40. log_timestamps=SYSTEM
  41. local_infile = 1
  42. max_digest_length = 3072
  43. performance_schema_max_digest_length=10240
  44. max_digest_length=10240
  45. performance_schema_max_sql_text_length=10240
  46. innodb_adaptive_hash_index = 0
  47.  
  48. interactive_timeout  = 86400
  49. mysqlx_interactive_timeout  = 86400
  50. mysqlx_wait_timeout  = 86400
  51. wait_timeout  = 86400
  52.  
  53. general_log = OFF
  54. general_log_file = /home/mysql/server/logs/mysqld_db.log
  55. [client]
  56. port=3306
  57. socket=/home/mysql/server/run/mysql.sock
  58.  
  59. #slow_query_log_file=/home/mysql/server/logs/mysql-slow.log
  60. #slow_query_log=ON
  61. #general_log_file=/home/mysql/server/logs/mysql_gen_db.log
  62. #general_log=ON
Parsed in 0.005 seconds