… the execution in the log file. # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No… Rows_sent: 56 Rows_examined: 1113 # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No… COUNT(1) FROM t2; Important note: Although the patch was tested and run successfully under stress with both synthetic benchmarks and…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
… strict_mode (see http://www.mysqlperformanceblog.com/2009/06/15/testing-fusionio-strict_sync-is-too-strict/#comment-676717). While I…. All details available here. I used sysbench fileio benchmark for tests (full script available under link). Block size is 16KB and I…/sec max throughput. Write bandwidth vs filesize: So there I tested how filesize (fill factor) affects write performance ( 8 working threads…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
…. In many cases size difference will be significantly less. All tests are runned 1000 times and the result time is average…, though join cost still could be significant. And the last test – selecting city and name in arbitrary order, skipping first 10000… note the times themselves – traversing about same amount of rows full table scan performs about 25 times better than accessing rows…
Comment: Intel 320 SSD write performance - contd.
September 29, 2011 By 8 Comments
… full speed, when you create have written full drive capacity worth of data cleaning needs to start. Having large file size for test can impact test two ways… drive. This especially should make a difference for short write tests when amount of data written during creation might be most…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… look when we have 4GB of memory allocated to memcached (full dataset fits ): Here you can see that our “transactionsâ… update, and read from the db only when required. I tested with a memcached size of 1GB, 2GB, and 4GB. For… look when we have 4GB of memory allocated to memcached (full dataset fits ): Here you can see that our “transactionsâ…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… “Enterprise” but according to the tests I’ve done so far it is far from full solution yet. It is also interesting to see CPU comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron comes second and…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… protection from pages being overwritten in buffer pool by large full table scan HT: No PZ: Another possible area of optimization… see batch jobs killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy optimizations possible… hates it. What are your suggestions here? HT: According to tests by Peter Zaitsev, O_DIRECT works well to remove double…
Comment: NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
June 14, 2012 By 13 Comments
… also do (as root), LD_BIND_NOW=yes LD_DEBUG=full LD_DEBUG_OUTPUT=/tmp/mysqld.ld.out mysqld –user=mysql… you will need to login mysql -u root -pxxxx to test the loading) — including the one required for memcmp. The rationale… builtin code then that full disclosure stands invalid). If you want to build a vulnerable binary for testing you can also force…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… and then see how the joins perform for each test case. Test Case A – Join a small table that fits in memory…. Another interesting thing to note is that for both Test B and Test C, Hash Join takes similar amount of time both… are joining tables with no indexes on the join condition (Full Join). The best performance with Hash Join can be achieved…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… better performance on Fusion-io ioDrive card. Full report is available in PDF For tests we used tpcc-mysql package, which generates…. More details on hardware and software configuration are in full report tpcc-mysql tests were run for following combinations: 2400W, big buffer… even better performance for MySQL. I am looking forward to test it. Disclaimer: This benchmark is sponsored by Fusion-io, but…
