Date: Mon, 10 Mar 2014 19:01:42 +0100 From: Adrian Gschwend <ml-ktk@netlabs.org> To: Steven Hartland <killing@multiplay.co.uk> Cc: freebsd-fs@freebsd.org Subject: Re: Reoccuring ZFS performance problems Message-ID: <531DFE06.40307@netlabs.org> In-Reply-To: <C673B581E12B479EA4E2B6FB9D5C5596@multiplay.co.uk> References: <531DF0DD.8070809@netlabs.org> <D0C1B46B015243048E05FE9E87EB5A38@multiplay.co.uk> <531DF924.5030109@netlabs.org> <C673B581E12B479EA4E2B6FB9D5C5596@multiplay.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?531DFE06.40307>