Р
Intel 2xE5-2430v2 / 64GB RAM / 2x480GB SSD
Size: a a a
2020 December 05
DE
Че логи?
DE
Как ини настраивал?
Р
Такие sending to client висят по 300+ сек
Р
А если коннекктов боллее 100, то можно и не ддождаться
Р
Как ини настраивал?
my.cnf?
DE
Да
Р
max-connections = 24000
wait-timeout = 15
interactive-timeout = 30
key-buffer-size = 1073741824
sort-buffer-size = 536870912
table-open-cache = 16096
query-cache-size = 0
thread-cache-size = 64
innodb-open-files = 120000
max-heap-table-size = 536870912
tmp-table-size = 536870912
innodb-buffer-pool-size = 55834574848
innodb-buffer-pool-instances = 24
innodb-log-file-size = 536870912
innodb-log-buffer-size = 67108864
innodb-flush-log-at-trx-commit = 0
innodb-read-io-threads = 8
innodb-write-io-threads = 8
innodb-thread-concurrency = 28
innodb-flush-method = O_DIRECT
performance-schema = FALSE
sync-binlog = 0
back-log = 900
query-cache-type = ON
optimizer-search-depth = 0
query-cache-limit = 31457280
max-allowed-packet = 16777216
open-files-limit = 4048576
read-buffer-size = 268435456
read-rnd-buffer-size = 4194304
thread-stack = 524288
query-cache-wlock-invalidate = TRUE
+ skip-name...
S
max-connections = 24000
wait-timeout = 15
interactive-timeout = 30
key-buffer-size = 1073741824
sort-buffer-size = 536870912
table-open-cache = 16096
query-cache-size = 0
thread-cache-size = 64
innodb-open-files = 120000
max-heap-table-size = 536870912
tmp-table-size = 536870912
innodb-buffer-pool-size = 55834574848
innodb-buffer-pool-instances = 24
innodb-log-file-size = 536870912
innodb-log-buffer-size = 67108864
innodb-flush-log-at-trx-commit = 0
innodb-read-io-threads = 8
innodb-write-io-threads = 8
innodb-thread-concurrency = 28
innodb-flush-method = O_DIRECT
performance-schema = FALSE
sync-binlog = 0
back-log = 900
query-cache-type = ON
optimizer-search-depth = 0
query-cache-limit = 31457280
max-allowed-packet = 16777216
open-files-limit = 4048576
read-buffer-size = 268435456
read-rnd-buffer-size = 4194304
thread-stack = 524288
query-cache-wlock-invalidate = TRUE
+ skip-name...
DE
query-cache-size почему 0?
Р
skip-external-locking
Р
query-cache-size почему 0?
query-cache-size = 1073741824
Р
Такое тоже пробовал
DE
1048576
Р
У меня в основном селекты, работаю под орм
Р
ow-priority-updates
delay-key-write=OFF
delay-key-write=OFF
Р
стоит еще
DE
optimizer_search_depth 62
Р
Поставил
IZ
Доброго дня, кто разбирается, в чем может быть проблема? Конфиг +- настраивал норм, запрос на селект таблицы исполняется на локалке 0.11s, с клиента 50-500s
50 секунд?