07:39:11 <ivaat> danmcd: hei.. i let installer to the job.. did choose five disks and on next screen raidz.. 
10:25:43 <ivaat> yay i got sysbench working on omnios
12:11:14 <andyf> ivaat - nice! Was it fairly straightforward? That's possibly a package that people would like to be available for installation.
12:14:02 <ivaat> andyf: sysbench 1.0.20 complains about mysql headers and libs not found.. even when added with configure flags. i only need this time mysql supported and then i took sysbench-0.4.12.16 from mysql.com download site. compiling: autogen.sh; configure and then gmake
12:14:43 <ivaat> it created tables so far. i am setting up proper dataset for innodb and then i will stress test.. then i can see does it work flawless
12:15:46 <ivaat> in my case i had mysql 80 pkg installed from that other site... https://sfe.opencsw.org/SFEmysql80
12:16:39 <ivaat> oh and i. needed gcc 11.. otherwise complained about /libstdc++.so.6: version 'GLIBCXX_3.4.29' does not exist:
12:17:50 <ivaat> gcc 11 is installed from from omni repo
12:47:42 <ivaat> weird.. datadir has no effect in my.cnf
12:47:49 <ivaat> for mysql 80
12:50:26 <ivaat> ah i need to edit manifest
12:50:56 <andyf> I don't know how the SFE packages are set up, but yes, you probably need to use `svccfg` to set properties on the service
12:51:15 <andyf> I think that's what's needed for the omnios-extra mysql packages too
13:05:14 <hpqoeu> yep, used svccfg to set at least mariadb options, i assume mysql is the same
13:09:31 <ivaat> so. machine has (62 or 64 vpcu.. cant see right now) and sysbench --threads=40 --test=oltp --oltp-test-mode=complex --max-time=60 --max-requests= --db-driver=mysql --mysql-db=test --mysql-user=root --mysql-password="" run
13:09:46 <ivaat> it basically made machine not working anymore
13:10:03 <ivaat> simple w command hungs and test is over
13:13:23 <ivaat> same test with linux and freebsd on same machine runs fine
13:13:49 <ivaat> i mean OS does not hang
13:14:07 <ivaat> not bashing or anything.. just thinking what i can do now
13:43:43 <tsoome> this smells like severe memory consumption
13:44:46 <tsoome> for whatever reason. try adding more ram or increase swap and before test, run mdb -k; during test you should be able to get ::memstat
13:52:05 <ivaat> well mysqld has 400G memory but i don't know how much sysbench itself consumed.. still waiting on OS. maybe it can recover
14:10:18 <tsoome> with very low free mem the vdev io will struggle, getting timeouts etc and it all will pile up (and corner case bugs are surfacing etc etc).