June 18, 2013

Comment: Solving INFORMATION_SCHEMA slowness

… sometime in the future. Percona can help, read more here: http://www.mysqlperformanceblog.com/2013/01/28/percona-custom-development-services-how-we-can…

Comment: Rotating MySQL slow logs safely

Hi, Martin, Andrew, you are right on these. You can also use SET GLOBAL slow_query_log = on|off to turn slow log on and off, like Bill does in his tool here. http://www.mysqlperformanceblog.com/2012/11/22/get-me-some-query-logs/

Comment: Testing the Micron P320h

… p320h is faster than Virident. You can compare numbers here: http://www.mysqlperformanceblog.com/2013/03/21/testing-the-virident-flashmax-ii/ @Dimitri– The…

Comment: Testing the Micron P320h

… P320h compare to Virident? You benchmarked Virident a while ago (http://www.mysqlperformanceblog.com/2010/06/15/virident-tachion-new-player-on-flash-pci…

Comment: SimCity outages, traffic control and Thread Pool for MySQL

… about curve you can see from theoretical models, i.e.: http://www.mysqlperformanceblog.com/2011/02/28/is-voltdb-really-as-scalable-as-they…

Post: PBXT benchmarks

… script for sysbench http://www.mysqlperformanceblog.com/files/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT http://www.mysqlperformanceblog.com/files/benchpbxt/mysql.start and script to run whole loop of benchmarks http://www.mysqlperformanceblog.com/files/benchpbxt/go.run…

Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB

http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, http://www.mysqlperformanceblog.com/2009/10/26/air-traffic-queries-in-luciddb/, http://www.mysqlperformanceblog.com/2009… our Wiki http://www.percona.com/docs/wiki/benchmark:ssb:start and the specification of benchmarks you can get there http://www.percona.com/docs/wiki…

Post: New OLAP Wikistat benchmark: Introduction and call for feedbacks

… a lot of interest (links: http://www.mysqlperformanceblog.com/2010/01/07/star-schema-bechmark-infobright-infinidb-and-luciddb/ http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/ http://www.mysqlperformanceblog.com/2009/10/26/air-traffic-queries-in-luciddb/ http://www.mysqlperformanceblog.com/2009…

Post: Percona builds with patches

… can find there: http://www.mysqlperformanceblog.com/mysql/debian/ You can also add the following repositories into your sources.list: deb http://mysqlperformanceblog.com/mysql/debian/5…/ binary-amd64/ deb http://mysqlperformanceblog.com/mysql/debian/5.1/ source/ Also we have generic RPMs for x86-64 architecture: http://www.mysqlperformanceblog.com/mysql/RPM/. They…

Post: thread_concurrency doesn't do what you expect

…- It’s deprecated and removed on 5.6.1 http://bugs.mysql.com/bug.php?id=55001 2- It only works on…: http://www.mysqlperformanceblog.com/2011/07/28/how-innodb-contention-may-manifest-itself/ http://www.mysqlperformanceblog.com/2011/12/02/kernel_mutex-problem-cont-or-triple-your-throughput/ http://www.mysqlperformanceblog.com