…have performed a number of simple benchmarks. Let’s start with a…| | end | 0.000007 | | Waiting for query cache lock | 0.000002 | | end | 0.000007 | …the optimization disabled, and absolutely no effect on the optimized case…keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real …
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… – it saves you from many variants of “SQL Injection” – passing malformed data so query changes it…, or because query cache does not work. I’ve done a simple benchmark (using SysBench) to … inonvenient for analyses. Few notes: There is no statement cache – You can allocate multiple copies of same …
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced this benchmark. I am…-engine=MyISAM sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max_connections=100 query_cache_size=0 table_cache=256 tmp_table_size=93M thread_cache_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=0.637 ms … Note: There is no need to put that hosts file… SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. …cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… queries executed by the slave’s SQL thread. This patch allows you to …No Full_join: No Tmp_table: Yes Disk_tmp_table: No # Filesort: Yes Disk_filesort: No Merge_passes: 0 QC_Hit tells whether query cache…run successfully under stress with both synthetic benchmarks and real database traffic, it’s …
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… Linux. People with OLTP workloads should try 16k (no smaller) and 32k and look at SHOW GLOBAL …query rates is likely to be optimal until full benchmarking to determine perfect size can be done. It’…table_open_cache setting because we expect most tables to be InnoDB and use innodb_file_per_table. sql_…
