Linux server.kiran-academy.com 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64
Apache/2.4.57 (Unix) OpenSSL/1.0.2k-fips
: 194.233.91.196 | : 216.73.216.216
Cant Read [ /etc/named.conf ]
7.4.32
finalho
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
usr /
include /
mysql /
server /
private /
[ HOME SHELL ]
Name
Size
Permission
Action
atomic
[ DIR ]
drwxr-xr-x
aria_backup.h
1.38
KB
-rw-r--r--
authors.h
9.59
KB
-rw-r--r--
backup.h
1.21
KB
-rw-r--r--
bounded_queue.h
6.58
KB
-rw-r--r--
client_settings.h
1.89
KB
-rw-r--r--
compat56.h
2.23
KB
-rw-r--r--
config.h
14.33
KB
-rw-r--r--
contributors.h
2.92
KB
-rw-r--r--
create_options.h
4.26
KB
-rw-r--r--
custom_conf.h
1.06
KB
-rw-r--r--
datadict.h
1.61
KB
-rw-r--r--
debug_sync.h
1.71
KB
-rw-r--r--
derived_handler.h
2.32
KB
-rw-r--r--
derror.h
980
B
-rw-r--r--
des_key_file.h
1.21
KB
-rw-r--r--
discover.h
1.53
KB
-rw-r--r--
dur_prop.h
1.06
KB
-rw-r--r--
embedded_priv.h
1.47
KB
-rw-r--r--
event_data_objects.h
3.88
KB
-rw-r--r--
event_db_repository.h
3.56
KB
-rw-r--r--
event_parse_data.h
2.83
KB
-rw-r--r--
event_queue.h
3.36
KB
-rw-r--r--
event_scheduler.h
3.21
KB
-rw-r--r--
events.h
4.54
KB
-rw-r--r--
field.h
189.86
KB
-rw-r--r--
field_comp.h
1.15
KB
-rw-r--r--
filesort.h
4.7
KB
-rw-r--r--
filesort_utils.h
3.78
KB
-rw-r--r--
ft_global.h
3.04
KB
-rw-r--r--
gcalc_slicescan.h
16.87
KB
-rw-r--r--
gcalc_tools.h
11.53
KB
-rw-r--r--
group_by_handler.h
3.09
KB
-rw-r--r--
gstream.h
2.38
KB
-rw-r--r--
ha_partition.h
62.15
KB
-rw-r--r--
ha_sequence.h
5.54
KB
-rw-r--r--
handle_connections_win.h
852
B
-rw-r--r--
handler.h
178.71
KB
-rw-r--r--
hash.h
4.33
KB
-rw-r--r--
hash_filo.h
5.41
KB
-rw-r--r--
heap.h
9.23
KB
-rw-r--r--
hostname.h
5.29
KB
-rw-r--r--
ilist.h
6.84
KB
-rw-r--r--
init.h
852
B
-rw-r--r--
innodb_priv.h
1.29
KB
-rw-r--r--
item.h
248.7
KB
-rw-r--r--
item_cmpfunc.h
120.42
KB
-rw-r--r--
item_create.h
8.39
KB
-rw-r--r--
item_func.h
110.72
KB
-rw-r--r--
item_geofunc.h
28.54
KB
-rw-r--r--
item_inetfunc.h
6.56
KB
-rw-r--r--
item_jsonfunc.h
13.63
KB
-rw-r--r--
item_row.h
5.02
KB
-rw-r--r--
item_strfunc.h
58.95
KB
-rw-r--r--
item_subselect.h
52.43
KB
-rw-r--r--
item_sum.h
63.56
KB
-rw-r--r--
item_timefunc.h
53.89
KB
-rw-r--r--
item_vers.h
3.63
KB
-rw-r--r--
item_windowfunc.h
30.7
KB
-rw-r--r--
item_xmlfunc.h
3.37
KB
-rw-r--r--
key.h
2
KB
-rw-r--r--
keycaches.h
1.95
KB
-rw-r--r--
lex.h
28.37
KB
-rw-r--r--
lex_hash.h
138.65
KB
-rw-r--r--
lex_string.h
2.07
KB
-rw-r--r--
lex_symbol.h
1.29
KB
-rw-r--r--
lex_token.h
41.28
KB
-rw-r--r--
lf.h
6.31
KB
-rw-r--r--
lock.h
2.16
KB
-rw-r--r--
log.h
43.43
KB
-rw-r--r--
log_event.h
160.18
KB
-rw-r--r--
log_event_old.h
19.2
KB
-rw-r--r--
log_slow.h
1.98
KB
-rw-r--r--
maria.h
17.38
KB
-rw-r--r--
mariadb.h
1.25
KB
-rw-r--r--
mdl.h
36.08
KB
-rw-r--r--
mem_root_array.h
6.94
KB
-rw-r--r--
message.h
1.17
KB
-rw-r--r--
multi_range_read.h
22.5
KB
-rw-r--r--
my_alarm.h
2.35
KB
-rw-r--r--
my_apc.h
4.62
KB
-rw-r--r--
my_atomic.h
7.11
KB
-rw-r--r--
my_atomic_wrapper.h
2.8
KB
-rw-r--r--
my_base.h
26.27
KB
-rw-r--r--
my_bit.h
3.44
KB
-rw-r--r--
my_bitmap.h
6.07
KB
-rw-r--r--
my_check_opt.h
2.56
KB
-rw-r--r--
my_compare.h
10.93
KB
-rw-r--r--
my_context.h
6.59
KB
-rw-r--r--
my_counter.h
1.68
KB
-rw-r--r--
my_cpu.h
4.01
KB
-rw-r--r--
my_crypt.h
904
B
-rw-r--r--
my_decimal.h
13.09
KB
-rw-r--r--
my_default.h
2.47
KB
-rw-r--r--
my_handler_errors.h
4.73
KB
-rw-r--r--
my_json_writer.h
17.11
KB
-rw-r--r--
my_libwrap.h
1.16
KB
-rw-r--r--
my_md5.h
1.45
KB
-rw-r--r--
my_minidump.h
848
B
-rw-r--r--
my_nosys.h
1.4
KB
-rw-r--r--
my_rdtsc.h
7.76
KB
-rw-r--r--
my_rnd.h
1.04
KB
-rw-r--r--
my_service_manager.h
1.47
KB
-rw-r--r--
my_stacktrace.h
2.99
KB
-rw-r--r--
my_time.h
10.22
KB
-rw-r--r--
my_tree.h
3.9
KB
-rw-r--r--
my_uctype.h
67.9
KB
-rw-r--r--
my_user.h
1.1
KB
-rw-r--r--
myisam.h
16.92
KB
-rw-r--r--
myisamchk.h
4.77
KB
-rw-r--r--
myisammrg.h
4.66
KB
-rw-r--r--
myisampack.h
14.58
KB
-rw-r--r--
mysql_async.h
1.77
KB
-rw-r--r--
mysqld.h
32.14
KB
-rw-r--r--
mysqld_default_groups.h
204
B
-rw-r--r--
mysqld_suffix.h
1.17
KB
-rw-r--r--
mysys_err.h
2.81
KB
-rw-r--r--
nt_servc.h
2.94
KB
-rw-r--r--
opt_range.h
54.69
KB
-rw-r--r--
opt_subselect.h
14.16
KB
-rw-r--r--
opt_trace.h
8.11
KB
-rw-r--r--
opt_trace_context.h
3.21
KB
-rw-r--r--
parse_file.h
4.12
KB
-rw-r--r--
partition_element.h
5.09
KB
-rw-r--r--
partition_info.h
16.77
KB
-rw-r--r--
password.h
1.14
KB
-rw-r--r--
pcre.h
30.97
KB
-rw-r--r--
probes_mysql.h
973
B
-rw-r--r--
probes_mysql_dtrace.h
32.23
KB
-rw-r--r--
probes_mysql_nodtrace.h
4.89
KB
-rw-r--r--
procedure.h
5.9
KB
-rw-r--r--
protocol.h
10.95
KB
-rw-r--r--
proxy_protocol.h
548
B
-rw-r--r--
queues.h
3.46
KB
-rw-r--r--
records.h
2.93
KB
-rw-r--r--
repl_failsafe.h
1.55
KB
-rw-r--r--
replication.h
15.73
KB
-rw-r--r--
rijndael.h
1.67
KB
-rw-r--r--
rowid_filter.h
15.07
KB
-rw-r--r--
rpl_constants.h
3.28
KB
-rw-r--r--
rpl_filter.h
4.41
KB
-rw-r--r--
rpl_gtid.h
13.25
KB
-rw-r--r--
rpl_injector.h
9.41
KB
-rw-r--r--
rpl_mi.h
13.65
KB
-rw-r--r--
rpl_parallel.h
13.52
KB
-rw-r--r--
rpl_record.h
1.55
KB
-rw-r--r--
rpl_record_old.h
1.37
KB
-rw-r--r--
rpl_reporting.h
2.96
KB
-rw-r--r--
rpl_rli.h
31.89
KB
-rw-r--r--
rpl_tblmap.h
3.1
KB
-rw-r--r--
rpl_utility.h
9.32
KB
-rw-r--r--
scheduler.h
3.4
KB
-rw-r--r--
scope.h
1.76
KB
-rw-r--r--
select_handler.h
1.99
KB
-rw-r--r--
semisync.h
2.23
KB
-rw-r--r--
semisync_master.h
22.68
KB
-rw-r--r--
semisync_master_ack_receiver.h
5.73
KB
-rw-r--r--
semisync_slave.h
3.47
KB
-rw-r--r--
service_versions.h
1.91
KB
-rw-r--r--
session_tracker.h
12.81
KB
-rw-r--r--
set_var.h
15.66
KB
-rw-r--r--
slave.h
11.99
KB
-rw-r--r--
source_revision.h
67
B
-rw-r--r--
sp.h
21.69
KB
-rw-r--r--
sp_cache.h
2
KB
-rw-r--r--
sp_head.h
59.95
KB
-rw-r--r--
sp_pcontext.h
24.3
KB
-rw-r--r--
sp_rcontext.h
14
KB
-rw-r--r--
span.h
3.84
KB
-rw-r--r--
spatial.h
20.82
KB
-rw-r--r--
sql_acl.h
17.83
KB
-rw-r--r--
sql_admin.h
2.74
KB
-rw-r--r--
sql_alloc.h
1.83
KB
-rw-r--r--
sql_alter.h
11.56
KB
-rw-r--r--
sql_analyse.h
10.91
KB
-rw-r--r--
sql_analyze_stmt.h
9.64
KB
-rw-r--r--
sql_array.h
6.29
KB
-rw-r--r--
sql_audit.h
13.55
KB
-rw-r--r--
sql_base.h
24.8
KB
-rw-r--r--
sql_basic_types.h
9.23
KB
-rw-r--r--
sql_binlog.h
895
B
-rw-r--r--
sql_bitmap.h
7.95
KB
-rw-r--r--
sql_bootstrap.h
1.63
KB
-rw-r--r--
sql_cache.h
21.15
KB
-rw-r--r--
sql_callback.h
1.51
KB
-rw-r--r--
sql_class.h
236.46
KB
-rw-r--r--
sql_cmd.h
8.47
KB
-rw-r--r--
sql_connect.h
3.77
KB
-rw-r--r--
sql_const.h
10.83
KB
-rw-r--r--
sql_crypt.h
1.4
KB
-rw-r--r--
sql_cte.h
16.01
KB
-rw-r--r--
sql_cursor.h
2.26
KB
-rw-r--r--
sql_db.h
2.16
KB
-rw-r--r--
sql_debug.h
4.65
KB
-rw-r--r--
sql_delete.h
1.37
KB
-rw-r--r--
sql_derived.h
1.26
KB
-rw-r--r--
sql_digest.h
3.73
KB
-rw-r--r--
sql_digest_stream.h
1.53
KB
-rw-r--r--
sql_do.h
954
B
-rw-r--r--
sql_error.h
37.79
KB
-rw-r--r--
sql_explain.h
26.09
KB
-rw-r--r--
sql_expression_cache.h
4.23
KB
-rw-r--r--
sql_get_diagnostics.h
7.66
KB
-rw-r--r--
sql_handler.h
2.84
KB
-rw-r--r--
sql_help.h
920
B
-rw-r--r--
sql_hset.h
3.17
KB
-rw-r--r--
sql_insert.h
2.1
KB
-rw-r--r--
sql_join_cache.h
47.04
KB
-rw-r--r--
sql_lex.h
160.22
KB
-rw-r--r--
sql_lifo_buffer.h
9.26
KB
-rw-r--r--
sql_list.h
21.55
KB
-rw-r--r--
sql_load.h
1.25
KB
-rw-r--r--
sql_locale.h
2.61
KB
-rw-r--r--
sql_manager.h
960
B
-rw-r--r--
sql_mode.h
6.58
KB
-rw-r--r--
sql_parse.h
8.12
KB
-rw-r--r--
sql_partition.h
12.31
KB
-rw-r--r--
sql_partition_admin.h
5.73
KB
-rw-r--r--
sql_plist.h
7.55
KB
-rw-r--r--
sql_plugin.h
7.43
KB
-rw-r--r--
sql_plugin_compat.h
2.18
KB
-rw-r--r--
sql_prepare.h
11.14
KB
-rw-r--r--
sql_priv.h
17.05
KB
-rw-r--r--
sql_profile.h
7.51
KB
-rw-r--r--
sql_reload.h
1.01
KB
-rw-r--r--
sql_rename.h
941
B
-rw-r--r--
sql_repl.h
2.96
KB
-rw-r--r--
sql_schema.h
3.69
KB
-rw-r--r--
sql_select.h
85.38
KB
-rw-r--r--
sql_sequence.h
5.06
KB
-rw-r--r--
sql_servers.h
1.74
KB
-rw-r--r--
sql_show.h
9.11
KB
-rw-r--r--
sql_signal.h
3.28
KB
-rw-r--r--
sql_sort.h
4.32
KB
-rw-r--r--
sql_statistics.h
11.96
KB
-rw-r--r--
sql_string.h
34.27
KB
-rw-r--r--
sql_table.h
11.04
KB
-rw-r--r--
sql_tablespace.h
956
B
-rw-r--r--
sql_test.h
1.55
KB
-rw-r--r--
sql_time.h
8.18
KB
-rw-r--r--
sql_trigger.h
10.74
KB
-rw-r--r--
sql_truncate.h
2.02
KB
-rw-r--r--
sql_tvc.h
2.24
KB
-rw-r--r--
sql_type.h
250.17
KB
-rw-r--r--
sql_type_int.h
8.03
KB
-rw-r--r--
sql_type_json.h
1.34
KB
-rw-r--r--
sql_type_real.h
1.23
KB
-rw-r--r--
sql_udf.h
4.43
KB
-rw-r--r--
sql_union.h
1.04
KB
-rw-r--r--
sql_update.h
1.88
KB
-rw-r--r--
sql_view.h
2.33
KB
-rw-r--r--
sql_window.h
6.65
KB
-rw-r--r--
ssl_compat.h
3.13
KB
-rw-r--r--
strfunc.h
2.2
KB
-rw-r--r--
structs.h
24.99
KB
-rw-r--r--
sys_vars_shared.h
2.61
KB
-rw-r--r--
t_ctype.h
5.51
KB
-rw-r--r--
table.h
110.56
KB
-rw-r--r--
table_cache.h
4.44
KB
-rw-r--r--
thr_alarm.h
2.87
KB
-rw-r--r--
thr_lock.h
6.69
KB
-rw-r--r--
thr_malloc.h
1.18
KB
-rw-r--r--
thr_timer.h
1.43
KB
-rw-r--r--
thread_pool_priv.h
4.37
KB
-rw-r--r--
threadpool.h
4.38
KB
-rw-r--r--
transaction.h
1.43
KB
-rw-r--r--
tzfile.h
4.9
KB
-rw-r--r--
tztime.h
3.3
KB
-rw-r--r--
uniques.h
4.05
KB
-rw-r--r--
unireg.h
7.12
KB
-rw-r--r--
vers_string.h
2.87
KB
-rw-r--r--
vers_utils.h
155
B
-rw-r--r--
violite.h
9.54
KB
-rw-r--r--
waiting_threads.h
4.43
KB
-rw-r--r--
welcome_copyright_notice.h
1.19
KB
-rw-r--r--
win_tzname_data.h
6.35
KB
-rw-r--r--
winservice.h
1.17
KB
-rw-r--r--
wqueue.h
1.53
KB
-rw-r--r--
wsrep.h
3.23
KB
-rw-r--r--
wsrep_applier.h
2.71
KB
-rw-r--r--
wsrep_binlog.h
3.36
KB
-rw-r--r--
wsrep_client_service.h
2.31
KB
-rw-r--r--
wsrep_client_state.h
1.53
KB
-rw-r--r--
wsrep_condition_variable.h
1.42
KB
-rw-r--r--
wsrep_high_priority_service.h
4.61
KB
-rw-r--r--
wsrep_mutex.h
1.16
KB
-rw-r--r--
wsrep_mysqld.h
15.87
KB
-rw-r--r--
wsrep_mysqld_c.h
1.2
KB
-rw-r--r--
wsrep_on.h
1.68
KB
-rw-r--r--
wsrep_priv.h
1.6
KB
-rw-r--r--
wsrep_schema.h
4.57
KB
-rw-r--r--
wsrep_server_service.h
3.25
KB
-rw-r--r--
wsrep_server_state.h
2.19
KB
-rw-r--r--
wsrep_sst.h
3.86
KB
-rw-r--r--
wsrep_storage_service.h
1.69
KB
-rw-r--r--
wsrep_thd.h
10.58
KB
-rw-r--r--
wsrep_trans_observer.h
18.72
KB
-rw-r--r--
wsrep_types.h
997
B
-rw-r--r--
wsrep_utils.h
9.07
KB
-rw-r--r--
wsrep_var.h
3.96
KB
-rw-r--r--
wsrep_xid.h
1.32
KB
-rw-r--r--
xa.h
1.46
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : sql_statistics.h
/* Copyright 2006-2008 MySQL AB, 2008 Sun Microsystems, Inc. This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 USA */ #ifndef SQL_STATISTICS_H #define SQL_STATISTICS_H /* For COMPLEMENTARY_FOR_QUERIES and PREFERABLY_FOR_QUERIES they are similar to the COMPLEMENTARY and PREFERABLY respectively except that with these values we would not be collecting EITS for queries like ANALYZE TABLE t1; To collect EITS with these values, we have to use PERSISITENT FOR analyze table t1 persistent for columns (col1,col2...) index (idx1, idx2...) or analyze table t1 persistent for all */ typedef enum enum_use_stat_tables_mode { NEVER, COMPLEMENTARY, PREFERABLY, COMPLEMENTARY_FOR_QUERIES, PREFERABLY_FOR_QUERIES } Use_stat_tables_mode; typedef enum enum_histogram_type { SINGLE_PREC_HB, DOUBLE_PREC_HB } Histogram_type; enum enum_stat_tables { TABLE_STAT, COLUMN_STAT, INDEX_STAT, }; /* These enumeration types comprise the dictionary of three statistical tables table_stat, column_stat and index_stat as they defined in ../scripts/mysql_system_tables.sql. It would be nice if the declarations of these types were generated automatically by the table definitions. */ enum enum_table_stat_col { TABLE_STAT_DB_NAME, TABLE_STAT_TABLE_NAME, TABLE_STAT_CARDINALITY, TABLE_STAT_N_FIELDS }; enum enum_column_stat_col { COLUMN_STAT_DB_NAME, COLUMN_STAT_TABLE_NAME, COLUMN_STAT_COLUMN_NAME, COLUMN_STAT_MIN_VALUE, COLUMN_STAT_MAX_VALUE, COLUMN_STAT_NULLS_RATIO, COLUMN_STAT_AVG_LENGTH, COLUMN_STAT_AVG_FREQUENCY, COLUMN_STAT_HIST_SIZE, COLUMN_STAT_HIST_TYPE, COLUMN_STAT_HISTOGRAM, COLUMN_STAT_N_FIELDS }; enum enum_index_stat_col { INDEX_STAT_DB_NAME, INDEX_STAT_TABLE_NAME, INDEX_STAT_INDEX_NAME, INDEX_STAT_PREFIX_ARITY, INDEX_STAT_AVG_FREQUENCY, INDEX_STAT_N_FIELDS }; inline Use_stat_tables_mode get_use_stat_tables_mode(THD *thd) { return (Use_stat_tables_mode) (thd->variables.use_stat_tables); } inline bool check_eits_collection_allowed(THD *thd) { return (get_use_stat_tables_mode(thd) == COMPLEMENTARY || get_use_stat_tables_mode(thd) == PREFERABLY); } inline bool check_eits_preferred(THD *thd) { return (get_use_stat_tables_mode(thd) == PREFERABLY || get_use_stat_tables_mode(thd) == PREFERABLY_FOR_QUERIES); } int read_statistics_for_tables_if_needed(THD *thd, TABLE_LIST *tables); int read_statistics_for_tables(THD *thd, TABLE_LIST *tables); int collect_statistics_for_table(THD *thd, TABLE *table); void delete_stat_values_for_table_share(TABLE_SHARE *table_share); int alloc_statistics_for_table(THD *thd, TABLE *table); int update_statistics_for_table(THD *thd, TABLE *table); int delete_statistics_for_table(THD *thd, const LEX_CSTRING *db, const LEX_CSTRING *tab); int delete_statistics_for_column(THD *thd, TABLE *tab, Field *col); int delete_statistics_for_index(THD *thd, TABLE *tab, KEY *key_info, bool ext_prefixes_only); int rename_table_in_stat_tables(THD *thd, const LEX_CSTRING *db, const LEX_CSTRING *tab, const LEX_CSTRING *new_db, const LEX_CSTRING *new_tab); int rename_column_in_stat_tables(THD *thd, TABLE *tab, Field *col, const char *new_name); void set_statistics_for_table(THD *thd, TABLE *table); double get_column_avg_frequency(Field * field); double get_column_range_cardinality(Field *field, key_range *min_endp, key_range *max_endp, uint range_flag); bool is_stat_table(const LEX_CSTRING *db, LEX_CSTRING *table); bool is_eits_usable(Field* field); class Histogram { private: Histogram_type type; uint8 size; /* Size of values array, in bytes */ uchar *values; uint prec_factor() { switch (type) { case SINGLE_PREC_HB: return ((uint) (1 << 8) - 1); case DOUBLE_PREC_HB: return ((uint) (1 << 16) - 1); } return 1; } public: uint get_width() { switch (type) { case SINGLE_PREC_HB: return size; case DOUBLE_PREC_HB: return size / 2; } return 0; } private: uint get_value(uint i) { DBUG_ASSERT(i < get_width()); switch (type) { case SINGLE_PREC_HB: return (uint) (((uint8 *) values)[i]); case DOUBLE_PREC_HB: return (uint) uint2korr(values + i * 2); } return 0; } /* Find the bucket which value 'pos' falls into. */ uint find_bucket(double pos, bool first) { uint val= (uint) (pos * prec_factor()); int lp= 0; int rp= get_width() - 1; int d= get_width() / 2; uint i= lp + d; for ( ; d; d= (rp - lp) / 2, i= lp + d) { if (val == get_value(i)) break; if (val < get_value(i)) rp= i; else if (val > get_value(i + 1)) lp= i + 1; else break; } if (val > get_value(i) && i < (get_width() - 1)) i++; if (val == get_value(i)) { if (first) { while(i && val == get_value(i - 1)) i--; } else { while(i + 1 < get_width() && val == get_value(i + 1)) i++; } } return i; } public: uint get_size() { return (uint) size; } Histogram_type get_type() { return type; } uchar *get_values() { return (uchar *) values; } void set_size (ulonglong sz) { size= (uint8) sz; } void set_type (Histogram_type t) { type= t; } void set_values (uchar *vals) { values= (uchar *) vals; } bool is_available() { return get_size() > 0 && get_values(); } /* This function checks that histograms should be usable only when 1) the level of optimizer_use_condition_selectivity > 3 2) histograms have been collected */ bool is_usable(THD *thd) { return thd->variables.optimizer_use_condition_selectivity > 3 && is_available(); } void set_value(uint i, double val) { switch (type) { case SINGLE_PREC_HB: ((uint8 *) values)[i]= (uint8) (val * prec_factor()); return; case DOUBLE_PREC_HB: int2store(values + i * 2, val * prec_factor()); return; } } void set_prev_value(uint i) { switch (type) { case SINGLE_PREC_HB: ((uint8 *) values)[i]= ((uint8 *) values)[i-1]; return; case DOUBLE_PREC_HB: int2store(values + i * 2, uint2korr(values + i * 2 - 2)); return; } } double range_selectivity(double min_pos, double max_pos) { double sel; double bucket_sel= 1.0/(get_width() + 1); uint min= find_bucket(min_pos, TRUE); uint max= find_bucket(max_pos, FALSE); sel= bucket_sel * (max - min + 1); return sel; } /* Estimate selectivity of "col=const" using a histogram */ double point_selectivity(double pos, double avg_sel); }; class Columns_statistics; class Index_statistics; /* Statistical data on a table */ class Table_statistics { public: my_bool cardinality_is_null; /* TRUE if the cardinality is unknown */ ha_rows cardinality; /* Number of rows in the table */ uchar *min_max_record_buffers; /* Record buffers for min/max values */ Column_statistics *column_stats; /* Array of statistical data for columns */ Index_statistics *index_stats; /* Array of statistical data for indexes */ /* Array of records per key for index prefixes */ ulonglong *idx_avg_frequency; uchar *histograms; /* Sequence of histograms */ }; /* Statistical data on a column Note: objects of this class may be "empty", where they have almost all fields as zeros, for example, get_avg_frequency() will return 0. objects are allocated in alloc_statistics_for_table[_share]. */ class Column_statistics { private: static const uint Scale_factor_nulls_ratio= 100000; static const uint Scale_factor_avg_length= 100000; static const uint Scale_factor_avg_frequency= 100000; public: /* Bitmap indicating what statistical characteristics are available for the column */ uint32 column_stat_nulls; /* For the below two, see comments in get_column_range_cardinality() */ /* Minimum value for the column */ Field *min_value; /* Maximum value for the column */ Field *max_value; private: /* The ratio Z/N multiplied by the scale factor Scale_factor_nulls_ratio, where N is the total number of rows, Z is the number of nulls in the column */ ulong nulls_ratio; /* Average number of bytes occupied by the representation of a value of the column in memory buffers such as join buffer multiplied by the scale factor Scale_factor_avg_length. CHAR values are stripped of trailing spaces. Flexible values are stripped of their length prefixes. */ ulonglong avg_length; /* The ratio N/D multiplied by the scale factor Scale_factor_avg_frequency, where N is the number of rows with not null value in the column, D the number of distinct values among them */ ulonglong avg_frequency; public: Histogram histogram; uint32 no_values_provided_bitmap() { return ((1 << (COLUMN_STAT_HISTOGRAM-COLUMN_STAT_COLUMN_NAME))-1) << (COLUMN_STAT_COLUMN_NAME+1); } void set_all_nulls() { column_stat_nulls= no_values_provided_bitmap(); } void set_not_null(uint stat_field_no) { column_stat_nulls&= ~(1 << stat_field_no); } bool is_null(uint stat_field_no) { return MY_TEST(column_stat_nulls & (1 << stat_field_no)); } double get_nulls_ratio() { return (double) nulls_ratio / Scale_factor_nulls_ratio; } double get_avg_length() { return (double) avg_length / Scale_factor_avg_length; } double get_avg_frequency() { return (double) avg_frequency / Scale_factor_avg_frequency; } void set_nulls_ratio (double val) { nulls_ratio= (ulong) (val * Scale_factor_nulls_ratio); } void set_avg_length (double val) { avg_length= (ulonglong) (val * Scale_factor_avg_length); } void set_avg_frequency (double val) { avg_frequency= (ulonglong) (val * Scale_factor_avg_frequency); } bool min_max_values_are_provided() { return !is_null(COLUMN_STAT_MIN_VALUE) && !is_null(COLUMN_STAT_MAX_VALUE); } /* This function checks whether the values for the fields of the statistical tables that were NULL by DEFAULT for a column have changed or not. @retval TRUE: Statistics are not present for a column FALSE: Statisitics are present for a column */ bool no_stat_values_provided() { if (column_stat_nulls == no_values_provided_bitmap()) return true; return false; } }; /* Statistical data on an index prefixes */ class Index_statistics { private: static const uint Scale_factor_avg_frequency= 100000; /* The k-th element of this array contains the ratio N/D multiplied by the scale factor Scale_factor_avg_frequency, where N is the number of index entries without nulls in the first k components, and D is the number of distinct k-component prefixes among them */ ulonglong *avg_frequency; public: void init_avg_frequency(ulonglong *ptr) { avg_frequency= ptr; } bool avg_frequency_is_inited() { return avg_frequency != NULL; } double get_avg_frequency(uint i) { return (double) avg_frequency[i] / Scale_factor_avg_frequency; } void set_avg_frequency(uint i, double val) { avg_frequency[i]= (ulonglong) (val * Scale_factor_avg_frequency); } }; #endif /* SQL_STATISTICS_H */
Close