Reoccuring ZFS performance problems

[Adrian Gschwend]

On 10.03.14 18:50, Steven Hartland wrote:

Hi Steven,

> Its enabled but not in use as the devices are reporting unsupported.

ah ok

> Disabled atime, configured innodb settings?

tank/storage/data/db/data  atime     off    inherited from tank/storage

my.cnf (part of it, let me know if you want full):

--
# CACHES AND LIMITS #
tmp-table-size                 = 32M
max-heap-table-size            = 32M
query-cache-type               = 0
query-cache-size               = 0
max-connections                = 500
thread-cache-size              = 50
open-files-limit               = 65535
table-definition-cache         = 4096
table-open-cache               = 4096

# INNODB #
innodb-flush-method            = O_DIRECT
innodb-log-files-in-group      = 2
innodb-log-file-size           = 256M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table          = 1
innodb-buffer-pool-size        = 4G
skip-innodb_doublewrite        = 1
--


MySQL is up again and it's getting slower:

(same at pastebin: http://pastebin.com/1qrWFppK )

dT: 1.010s  w: 1.000s
 L(q)  ops/s    r/s   kBps   ms/r    w/s   kBps   ms/w    d/s   kBps
ms/d   %busy Name
   10    249     74    191    0.6    171    531   37.5      0      0
0.0   75.9| vtbd0
    0      0      0      0    0.0      0      0    0.0      0      0
0.0    0.0| vtbd0p1
    0      0      0      0    0.0      0      0    0.0      0      0
0.0    0.0| vtbd0p2
   10    249     74    191   14.0    171    531   38.4      0      0
0.0   95.7| vtbd0p3
    0      0      0      0    0.0      0      0    0.0      0      0
0.0    0.0| cd0
    0      0      0      0    0.0      0      0    0.0      0      0
0.0    0.0| gptid/e402ecce-89ca-11e2-a867-3264262b9894
    0      0      0      0    0.0      0      0    0.0      0      0
0.0    0.0| gptid/e4112d88-89ca-11e2-a867-3264262b9894

regards

Adrian