danmcd: hei.. i let installer to the job.. did choose five disks and on next screen raidz..

yay i got sysbench working on omnios

ivaat - nice! Was it fairly straightforward? That's possibly a package that people would like to be available for installation.

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

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

in my case i had mysql 80 pkg installed from that other site... sfe.opencsw.org/SFEmysql80

oh and i. needed gcc 11.. otherwise complained about /libstdc++.so.6: version 'GLIBCXX_3.4.29' does not exist:

gcc 11 is installed from from omni repo

weird.. datadir has no effect in my.cnf

for mysql 80

ah i need to edit manifest

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

I think that's what's needed for the omnios-extra mysql packages too

yep, used svccfg to set at least mariadb options, i assume mysql is the same

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

it basically made machine not working anymore

simple w command hungs and test is over

same test with linux and freebsd on same machine runs fine

i mean OS does not hang

not bashing or anything.. just thinking what i can do now

this smells like severe memory consumption

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

well mysqld has 400G memory but i don't know how much sysbench itself consumed.. still waiting on OS. maybe it can recover

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).