tag:blogger.com,1999:blog-9149523927864751087.post4910943985020302335..comments2024-03-26T09:43:01.052-07:00Comments on Small Datum: Meltdown vs MySQL part 2: in-memory sysbench and a core i5 NUCMark Callaghanhttp://www.blogger.com/profile/09590445221922043181noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9149523927864751087.post-13065019410006813692018-01-12T13:32:06.680-08:002018-01-12T13:32:06.680-08:00From the point-query test where InnoDB does ~18k, ...From the point-query test where InnoDB does ~18k, ~32k, ~56k QPS at 1,2,8 threads the cs rates from vmstat are ~69k, ~121k, ~107k. The number of context switches per query is ~4, ~4, ~2 for 1,2,8 threads.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-9149523927864751087.post-34941772853095176172018-01-12T13:10:53.400-08:002018-01-12T13:10:53.400-08:00Thanks for sharing.
I was wondering what the host ...Thanks for sharing.<br />I was wondering what the host context switching rate per second ("sar -w 5" (or "sar -w" to view the history if sadc is running) , cs from "vmstat 5") , or the process/thread rates ( "pidstat -wt | sort -nrk6 | head" ) are when the (most contended) tests are running?<br />Anonymoushttps://www.blogger.com/profile/11231963268741754635noreply@blogger.com