…3 hash tables would need to be created each containing a hash table on n/3 rows. And so both the build…includes a new variable ‘join_cache_level‘, … NULL, `s_phone` char(15) DEFAULT NULL, `s_acctbal`…a where clause on a ‘non-indexed’ column In this test we can clearly see that Hash Join gives a lot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… a lot of things like how to build…level of tuning, from completely untuned to a system that’s already had a lot of expert attention. I use “tuning” in a… cpu family : 6 model : 15 model name : Intel(R…A lot of times, customers will tell us up front to limit the work to some number of hours, such as 3…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…a lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot… see the number is 2.3 for Percona Server 5.1…oprofile: 867964 15.1181 mysqld btr_cur_search_to_nth_level 792651 13….build_page_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur_search_to_nth_level…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…a great new feature – ability to build indexes by sort instead of via insertion. This process can be a lot…level commands or tools (like mysqldump) do not get advantage of it and will use old slow method of building…
Post: Where does HandlerSocket really save you time?
March 16, 2011 By Leave a Comment
… really generated a lot of interest because of the dual promises of ease-…from a couple of months back had some really good profile results for libmysql versus libhsclient (starting at slide 15…store_mysql_rec 193472.3826btr_cur_search_to_nth_level 167012.0568row_sel_convert_mysql_key_to_innobase – …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…more application changes such as building summary tables, significant schema changes, …and others (like excessive row level locks) may be caused by… unlikely more than 2-3 times faster than the …optimize it another 10-15% may be a great idea. On … our services is a good match for a lot of companies and …
