Mysql PG my.conf

[mysqld]

key_buffer_size     = 10000M
key-buffer-size     = 32M
max_allowed_packet  = 2048M
max-allowed-packet  = 64M
max-connect-errors  = 100000000
thread_stack        = 4048K
#thread_cache_size       = 600
#myisam_recover_options  = BACKUP
max_connections        = 1000
#table_cache            = 200
table_open_cache = 12000
table_definition_cache = 30000
join_buffer_size = 300K
performance_schema = O

max_user_connections    = 1000
query_cache_limit   = 2048M

max_binlog_size   = 100M

tmp-table-size                 = 6000M
max-heap-table-size            = 64M
query-cache-type               = 1
query-cache-size               = 1000M
max-connections                = 1000
thread-cache-size              = 100
open-files-limit               = 65535
table-definition-cache         = 4096
#table-open-cache               = 100
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 512M
innodb-flush-log-at-trx-commit = 2
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 45800M


interactive_timeout =14400
#skip-name-resolve=1
read_buffer_size=200M
key_buffer_size=2048M
#table_definition_cache = 4000
#table_open_cache = 5000