News for hackers. Stuff that matters.
Re:500k queries per second with MySQL 5.7 by viraptor on Tuesday October 08, 2013 @11:01AM (#6515411)
If you look at the config files at the end:

    innodb_checksums=0
    innodb_doublewrite=0
    innodb_support_xa=0
Ok, so this is a benchmark with no regards for data safety that you'd like on a live system. No two-phase commit, no protection from partial page writes. Great in theory, but it should be really pointed out in the article (or did I just miss it?)
Re:500k queries per second with MySQL 5.7 by MSM on Tuesday October 08, 2013 @11:09AM (#6515464)
It's admittedly hard to follow the writing style, but it's mentioned many times that these are read only queries.

I agree it's a little misleading, but at the same time if you're really in a readonly DW type environment you'd be crazy not to have all of the settings enabled to push throughput to the max.

Re:500k queries per second with MySQL 5.7 by viraptor on Tuesday October 08, 2013 @12:06PM (#6515875)
Duh... yeah, my bad. I looked so much for the option details that I missed the whole thing was R/O. Thanks for pointing this out.
Re:500k queries per second with MySQL 5.7 by eniacpx on Tuesday October 08, 2013 @11:07AM (#6515446)
Next they will show you how to increase MS SQL performance with "NOLOCK".