…test. All OS caches are dropped at this time as well. These set of queries were tested on… be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with…32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…single-node (on the left) vs. two-node (on the right) …transactions, its applicability is quite limited. Namely, it requires the list…log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M…max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…queries, similar to ones in benchmark InnoDB vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs…MHz : 1800.163 cache size : 1024 …LIMIT Query: SELECT state_id FROM $tableName WHERE country_id = %d LIMIT 5 The previous query but with LIMIT. READ_PK_POINT_INDEX Query…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…=1G –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write… from OS cache is not scaled. READ_KEY_POINT_LIMIT Query: SELECT name FROM $tableName WHERE country_id = %d LIMIT 5 The same query as…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 30 Comments
… from VARCHAR to ENUM or TINYINT affects row size significantly. In many cases size difference will be significantly less. All tests are… rows to make query times longer. 1) Results for ENUM: select SQL_NO_CACHE city, state from cities_enum limit 10000, 5; Result… SQL_NO_CACHE city, state from cities_varchar limit 10000, 5; Result time(mean): 0.003283 3) select SQL_NO_CACHE c.city…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…queries‘ execution plan (which includes things like whether Query cache…size 0 0 0 0 0 0 0 0 # Query size…limiting the number of results returned by the query, by using a LIMIT…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… need to increase it much further. open_files_limit is 5000 by default now vs 1024. innodb_auto_extend_increment is now… these days. query_cache_type and query_cache_size. The behavior is “no cache” by default still but it is achieved differently now. The query_cache_type is…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled during these benchmark runs and …_orderdate, o_shippriority order by revenue desc, o_orderdate LIMIT 10; In-memory workload Now let’s see … disabled, and the only difference in query time is 48.78s vs 48.91s, so I don’t …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
…. Index Condition Pushdown Traditional B-Tree index lookups have some limitations in cases such as range scans, where index parts after…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
…case performance difference was 9 seconds vs 8 minutes – 50 times. I… values. read_buffer_size and read_rnd_buffer_size – These are buffers…LIMIT queries as well as in some other cases. If you run SELECT * FROM LARGETABLE LIMIT…table_cache may slow your opens and closes down, too large query_cache may …
