/dports/databases/mariadb105-client/mariadb-10.5.15/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5.0 // 5 WHERE compares == one read macro 210 #define IDX_BLOCK_COPY_COST ((double) 1 / TIME_FOR_COMPARE) 218 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | rowid_filter.h | 448 return r * (1 - selectivity) / TIME_FOR_COMPARE; in get_cmp_gain()
|
H A D | rowid_filter.cc | 49 return (1+1.0/TIME_FOR_COMPARE) * (1 - selectivity) - in avg_access_and_eval_gain_per_row()
|
H A D | multi_range_read.cc | 326 cost->cpu_cost+= (rows2double(total_rows) / TIME_FOR_COMPARE + in multi_range_read_info_const() 406 cost->cpu_cost+= rows2double(n_rows) / TIME_FOR_COMPARE; in multi_range_read_info()
|
H A D | sql_select.cc | 7424 rows2double(records)/TIME_FOR_COMPARE); in adjust_quick_cost() 7970 if (tmp + 0.0001 < best_time - records/TIME_FOR_COMPARE) in best_access_path() 7973 best_time= COST_ADD(tmp, records/TIME_FOR_COMPARE); in best_access_path() 8016 double cmp_time= (s->records - rnd_records)/TIME_FOR_COMPARE; in best_access_path() 8154 double cmp_time= (s->records - rnd_records)/TIME_FOR_COMPARE; in best_access_path() 8197 COST_ADD(tmp, record_count/TIME_FOR_COMPARE*rnd_records) < in best_access_path() 8200 record_count/TIME_FOR_COMPARE*records))) in best_access_path() 8752 record_count / TIME_FOR_COMPARE)); in optimize_straight_join() 8945 record_count / TIME_FOR_COMPARE)); in greedy_search() 9723 TIME_FOR_COMPARE)); in best_extension_by_limited_search() [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5 // 5 compares == one read macro 210 #define IDX_BLOCK_COPY_COST ((double) 1 / TIME_FOR_COMPARE) 217 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | rowid_filter.h | 448 return r * (1 - selectivity) / TIME_FOR_COMPARE; in get_cmp_gain()
|
H A D | multi_range_read.cc | 157 cost->cpu_cost+= (double) total_rows / TIME_FOR_COMPARE; in multi_range_read_info_const() 163 cost->cpu_cost= (double) total_rows / TIME_FOR_COMPARE + 0.01; in multi_range_read_info_const() 236 cost->cpu_cost+= (double) n_rows / TIME_FOR_COMPARE; in multi_range_read_info() 242 cost->cpu_cost= (double) n_rows / TIME_FOR_COMPARE + 0.01; in multi_range_read_info()
|
H A D | rowid_filter.cc | 49 return (1+1.0/TIME_FOR_COMPARE) * (1 - selectivity) - in avg_access_and_eval_gain_per_row()
|
H A D | sql_select.cc | 7865 if (tmp + 0.0001 < best_time - records/(double) TIME_FOR_COMPARE) in best_access_path() 7868 best_time= COST_ADD(tmp, records/(double) TIME_FOR_COMPARE); in best_access_path() 7911 double cmp_time= (s->records - rnd_records)/(double) TIME_FOR_COMPARE; in best_access_path() 7921 COST_MULT((record_count*join_sel) / TIME_FOR_COMPARE, in best_access_path() 8049 double cmp_time= (s->records - rnd_records)/(double) TIME_FOR_COMPARE; in best_access_path() 8092 COST_ADD(tmp, record_count/(double) TIME_FOR_COMPARE*rnd_records) < in best_access_path() 8095 record_count/(double) TIME_FOR_COMPARE*records))) in best_access_path() 8647 record_count / (double) TIME_FOR_COMPARE)); in optimize_straight_join() 8840 record_count / (double) TIME_FOR_COMPARE)); in greedy_search() 9616 (double) TIME_FOR_COMPARE)); in best_extension_by_limited_search() [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5 // 5 compares == one read macro 210 #define IDX_BLOCK_COPY_COST ((double) 1 / TIME_FOR_COMPARE) 217 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | rowid_filter.h | 448 return r * (1 - selectivity) / TIME_FOR_COMPARE; in get_cmp_gain()
|
H A D | multi_range_read.cc | 157 cost->cpu_cost+= (double) total_rows / TIME_FOR_COMPARE; 163 cost->cpu_cost= (double) total_rows / TIME_FOR_COMPARE + 0.01; 236 cost->cpu_cost+= (double) n_rows / TIME_FOR_COMPARE; 242 cost->cpu_cost= (double) n_rows / TIME_FOR_COMPARE + 0.01;
|
H A D | rowid_filter.cc | 49 return (1+1.0/TIME_FOR_COMPARE) * (1 - selectivity) -
|
/dports/databases/mariadb105-server/mariadb-10.5.15/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5.0 // 5 WHERE compares == one read macro 210 #define IDX_BLOCK_COPY_COST ((double) 1 / TIME_FOR_COMPARE) 218 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | rowid_filter.h | 448 return r * (1 - selectivity) / TIME_FOR_COMPARE; in get_cmp_gain()
|
H A D | rowid_filter.cc | 49 return (1+1.0/TIME_FOR_COMPARE) * (1 - selectivity) - in avg_access_and_eval_gain_per_row()
|
H A D | multi_range_read.cc | 326 cost->cpu_cost+= (rows2double(total_rows) / TIME_FOR_COMPARE + in multi_range_read_info_const() 406 cost->cpu_cost+= rows2double(n_rows) / TIME_FOR_COMPARE; in multi_range_read_info()
|
H A D | sql_select.cc | 7424 rows2double(records)/TIME_FOR_COMPARE); in adjust_quick_cost() 7970 if (tmp + 0.0001 < best_time - records/TIME_FOR_COMPARE) in best_access_path() 7973 best_time= COST_ADD(tmp, records/TIME_FOR_COMPARE); in best_access_path() 8016 double cmp_time= (s->records - rnd_records)/TIME_FOR_COMPARE; in best_access_path() 8154 double cmp_time= (s->records - rnd_records)/TIME_FOR_COMPARE; in best_access_path() 8197 COST_ADD(tmp, record_count/TIME_FOR_COMPARE*rnd_records) < in best_access_path() 8200 record_count/TIME_FOR_COMPARE*records))) in best_access_path() 8752 record_count / TIME_FOR_COMPARE)); in optimize_straight_join() 8945 record_count / TIME_FOR_COMPARE)); in greedy_search() 9723 TIME_FOR_COMPARE)); in best_extension_by_limited_search() [all …]
|
/dports/databases/mysql55-client/mysql-5.5.62/sql/ |
H A D | sql_const.h | 164 #define TIME_FOR_COMPARE 5 // 5 compares == one read macro 170 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*2)
|
H A D | sql_select.cc | 4812 if (tmp < best_time - records/(double) TIME_FOR_COMPARE) in best_access_path() 4814 best_time= tmp + records/(double) TIME_FOR_COMPARE; in best_access_path() 4898 (s->found_records - rnd_records)/(double) TIME_FOR_COMPARE); in best_access_path() 4913 (s->records - rnd_records)/(double) TIME_FOR_COMPARE); in best_access_path() 4928 tmp+= (s->records - rnd_records)/(double) TIME_FOR_COMPARE; in best_access_path() 4938 (tmp + record_count/(double) TIME_FOR_COMPARE*rnd_records < in best_access_path() 4939 best + record_count/(double) TIME_FOR_COMPARE*records)) in best_access_path() 5208 read_time+= record_count / (double) TIME_FOR_COMPARE; in optimize_straight_join() 5559 (double) TIME_FOR_COMPARE), in best_extension_by_limited_search() 5663 read_time+=record_count/(double) TIME_FOR_COMPARE; in find_best() [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5 // 5 compares == one read macro 213 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | multi_range_read.cc | 129 cost->cpu_cost= (double) total_rows / TIME_FOR_COMPARE + 0.01; in multi_range_read_info_const()
|
/dports/databases/mariadb103-client/mariadb-10.3.34/sql/ |
H A D | sql_const.h | 207 #define TIME_FOR_COMPARE 5 // 5 compares == one read macro 213 #define TIME_FOR_COMPARE_ROWID (TIME_FOR_COMPARE*100)
|
H A D | multi_range_read.cc | 129 cost->cpu_cost= (double) total_rows / TIME_FOR_COMPARE + 0.01; in multi_range_read_info_const()
|