Gecko [ www.leshallesdegournay.geraud-market.com ]

Name	Size	Permission	Date
atomic	[ DIR ]	drwxr-xr-x	2022-05-23 22:35
authors.h	9.35 KB	-rw-r--r--	2022-05-18 13:19
bounded_queue.h	6.61 KB	-rw-r--r--	2022-05-18 13:19
client_settings.h	1.89 KB	-rw-r--r--	2022-05-18 13:19
compat56.h	1.95 KB	-rw-r--r--	2022-05-18 13:19
config.h	14.49 KB	-rw-r--r--	2022-05-18 14:40
contributors.h	2.92 KB	-rw-r--r--	2022-05-18 13:19
create_options.h	4.21 KB	-rw-r--r--	2022-05-18 13:19
custom_conf.h	1.06 KB	-rw-r--r--	2022-05-18 13:19
datadict.h	1.48 KB	-rw-r--r--	2022-05-18 13:19
debug_sync.h	1.73 KB	-rw-r--r--	2022-05-18 13:19
derror.h	1.02 KB	-rw-r--r--	2022-05-18 13:19
des_key_file.h	1.21 KB	-rw-r--r--	2022-05-18 13:19
discover.h	1.57 KB	-rw-r--r--	2022-05-18 13:19
dur_prop.h	1.06 KB	-rw-r--r--	2022-05-18 13:19
embedded_priv.h	1.47 KB	-rw-r--r--	2022-05-18 13:19
event_data_objects.h	3.84 KB	-rw-r--r--	2022-05-18 13:19
event_db_repository.h	3.41 KB	-rw-r--r--	2022-05-18 13:19
event_parse_data.h	2.87 KB	-rw-r--r--	2022-05-18 13:19
event_queue.h	3.29 KB	-rw-r--r--	2022-05-18 13:19
event_scheduler.h	3.21 KB	-rw-r--r--	2022-05-18 13:19
events.h	4.43 KB	-rw-r--r--	2022-05-18 13:19
field.h	147.53 KB	-rw-r--r--	2022-05-18 13:19
filesort.h	4.61 KB	-rw-r--r--	2022-05-18 13:19
filesort_utils.h	4 KB	-rw-r--r--	2022-05-18 13:19
ft_global.h	3.04 KB	-rw-r--r--	2022-05-18 13:19
gcalc_slicescan.h	16.86 KB	-rw-r--r--	2022-05-18 13:19
gcalc_tools.h	11.38 KB	-rw-r--r--	2022-05-18 13:19
group_by_handler.h	3.08 KB	-rw-r--r--	2022-05-18 13:19
gstream.h	2.44 KB	-rw-r--r--	2022-05-18 13:19
ha_partition.h	50.87 KB	-rw-r--r--	2022-05-18 13:19
handler.h	155.48 KB	-rw-r--r--	2022-05-18 13:19
hash.h	4.39 KB	-rw-r--r--	2022-05-18 13:19
hash_filo.h	5.4 KB	-rw-r--r--	2022-05-18 13:19
heap.h	9.23 KB	-rw-r--r--	2022-05-18 13:19
hostname.h	5.35 KB	-rw-r--r--	2022-05-18 13:19
ilist.h	6.27 KB	-rw-r--r--	2022-05-18 13:19
init.h	955 B	-rw-r--r--	2022-05-18 13:19
innodb_priv.h	1.39 KB	-rw-r--r--	2022-05-18 13:19
item.h	203.54 KB	-rw-r--r--	2022-05-18 13:19
item_cmpfunc.h	91.97 KB	-rw-r--r--	2022-05-18 13:19
item_create.h	6.76 KB	-rw-r--r--	2022-05-18 13:19
item_func.h	80.86 KB	-rw-r--r--	2022-05-18 13:19
item_geofunc.h	23.31 KB	-rw-r--r--	2022-05-18 13:19
item_inetfunc.h	7.61 KB	-rw-r--r--	2022-05-18 13:19
item_jsonfunc.h	13.04 KB	-rw-r--r--	2022-05-18 13:19
item_row.h	4.33 KB	-rw-r--r--	2022-05-18 13:19
item_strfunc.h	46.53 KB	-rw-r--r--	2022-05-18 13:19
item_subselect.h	51.04 KB	-rw-r--r--	2022-05-18 13:19
item_sum.h	56.22 KB	-rw-r--r--	2022-05-18 13:19
item_timefunc.h	41 KB	-rw-r--r--	2022-05-18 13:19
item_windowfunc.h	22.36 KB	-rw-r--r--	2022-05-18 13:19
item_xmlfunc.h	3.42 KB	-rw-r--r--	2022-05-18 13:19
key.h	2.05 KB	-rw-r--r--	2022-05-18 13:19
keycaches.h	1.94 KB	-rw-r--r--	2022-05-18 13:19
lex.h	26.32 KB	-rw-r--r--	2022-05-18 13:19
lex_hash.h	126.06 KB	-rw-r--r--	2022-05-18 14:44
lex_symbol.h	1.29 KB	-rw-r--r--	2022-05-18 13:19
lex_token.h	37.96 KB	-rw-r--r--	2022-05-18 14:44
lf.h	6.24 KB	-rw-r--r--	2022-05-18 13:19
lock.h	2.11 KB	-rw-r--r--	2022-05-18 13:19
log.h	41.65 KB	-rw-r--r--	2022-05-18 13:19
log_event.h	158.17 KB	-rw-r--r--	2022-05-18 13:19
log_event_old.h	19.2 KB	-rw-r--r--	2022-05-18 13:19
log_slow.h	1.55 KB	-rw-r--r--	2022-05-18 13:19
maria.h	17.28 KB	-rw-r--r--	2022-05-18 13:19
mdl.h	33.03 KB	-rw-r--r--	2022-05-18 13:19
mem_root_array.h	6.77 KB	-rw-r--r--	2022-05-18 13:19
message.h	2.06 KB	-rw-r--r--	2022-05-18 13:19
multi_range_read.h	22.17 KB	-rw-r--r--	2022-05-18 13:19
my_alarm.h	2.24 KB	-rw-r--r--	2022-05-18 13:19
my_apc.h	4.61 KB	-rw-r--r--	2022-05-18 13:19
my_atomic.h	16.66 KB	-rw-r--r--	2022-05-18 13:19
my_base.h	25.05 KB	-rw-r--r--	2022-05-18 13:19
my_bit.h	3.15 KB	-rw-r--r--	2022-05-18 13:19
my_bitmap.h	5.98 KB	-rw-r--r--	2022-05-18 13:19
my_check_opt.h	2.56 KB	-rw-r--r--	2022-05-18 13:19
my_compare.h	5.36 KB	-rw-r--r--	2022-05-18 13:19
my_context.h	6.59 KB	-rw-r--r--	2022-05-18 13:19
my_cpu.h	1.45 KB	-rw-r--r--	2022-05-18 13:19
my_crypt.h	904 B	-rw-r--r--	2022-05-18 13:19
my_decimal.h	12.52 KB	-rw-r--r--	2022-05-18 13:19
my_default.h	2.47 KB	-rw-r--r--	2022-05-18 13:19
my_handler_errors.h	4.52 KB	-rw-r--r--	2022-05-18 13:19
my_json_writer.h	4.88 KB	-rw-r--r--	2022-05-18 13:19
my_libwrap.h	1.16 KB	-rw-r--r--	2022-05-18 13:19
my_md5.h	1.45 KB	-rw-r--r--	2022-05-18 13:19
my_nosys.h	1.4 KB	-rw-r--r--	2022-05-18 13:19
my_rdtsc.h	3.87 KB	-rw-r--r--	2022-05-18 13:19
my_rnd.h	1.04 KB	-rw-r--r--	2022-05-18 13:19
my_service_manager.h	1.47 KB	-rw-r--r--	2022-05-18 13:19
my_stacktrace.h	2.97 KB	-rw-r--r--	2022-05-18 13:19
my_time.h	8.75 KB	-rw-r--r--	2022-05-18 13:19
my_tree.h	3.89 KB	-rw-r--r--	2022-05-18 13:19
my_uctype.h	67.9 KB	-rw-r--r--	2022-05-18 13:19
my_user.h	1.12 KB	-rw-r--r--	2022-05-18 13:19
myisam.h	16.84 KB	-rw-r--r--	2022-05-18 13:19
myisamchk.h	4.7 KB	-rw-r--r--	2022-05-18 13:19
myisammrg.h	4.63 KB	-rw-r--r--	2022-05-18 13:19
myisampack.h	14.58 KB	-rw-r--r--	2022-05-18 13:19
mysql_async.h	1.77 KB	-rw-r--r--	2022-05-18 13:19
mysqld.h	31.32 KB	-rw-r--r--	2022-05-18 13:19
mysqld_default_groups.h	169 B	-rw-r--r--	2022-05-18 13:19
mysqld_suffix.h	1.17 KB	-rw-r--r--	2022-05-18 13:19
mysys_err.h	2.81 KB	-rw-r--r--	2022-05-18 13:19
nt_servc.h	3 KB	-rw-r--r--	2022-05-18 13:19
opt_range.h	53.25 KB	-rw-r--r--	2022-05-18 13:19
opt_subselect.h	13.76 KB	-rw-r--r--	2022-05-18 13:19
parse_file.h	4.12 KB	-rw-r--r--	2022-05-18 13:19
partition_element.h	4.52 KB	-rw-r--r--	2022-05-18 13:19
partition_info.h	14.25 KB	-rw-r--r--	2022-05-18 13:19
password.h	1.17 KB	-rw-r--r--	2022-05-18 13:19
pcre.h	30.97 KB	-rw-r--r--	2022-05-18 14:40
probes_mysql.h	973 B	-rw-r--r--	2022-05-18 13:19
probes_mysql_dtrace.h	32.23 KB	-rw-r--r--	2022-05-18 14:43
probes_mysql_nodtrace.h	4.89 KB	-rw-r--r--	2022-05-18 14:43
procedure.h	5.83 KB	-rw-r--r--	2022-05-18 13:19
protocol.h	9.72 KB	-rw-r--r--	2022-05-18 13:19
queues.h	3.51 KB	-rw-r--r--	2022-05-18 13:19
records.h	2.99 KB	-rw-r--r--	2022-05-18 13:19
repl_failsafe.h	1.69 KB	-rw-r--r--	2022-05-18 13:19
replication.h	15.96 KB	-rw-r--r--	2022-05-18 13:19
rijndael.h	1.67 KB	-rw-r--r--	2022-05-18 13:19
rpl_constants.h	3.28 KB	-rw-r--r--	2022-05-18 13:19
rpl_filter.h	4.41 KB	-rw-r--r--	2022-05-18 13:19
rpl_gtid.h	10.47 KB	-rw-r--r--	2022-05-18 13:19
rpl_handler.h	5.53 KB	-rw-r--r--	2022-05-18 13:19
rpl_injector.h	9.42 KB	-rw-r--r--	2022-05-18 13:19
rpl_mi.h	12.36 KB	-rw-r--r--	2022-05-18 13:19
rpl_parallel.h	13.3 KB	-rw-r--r--	2022-05-18 13:19
rpl_record.h	1.61 KB	-rw-r--r--	2022-05-18 13:19
rpl_record_old.h	1.37 KB	-rw-r--r--	2022-05-18 13:19
rpl_reporting.h	2.96 KB	-rw-r--r--	2022-05-18 13:19
rpl_rli.h	31.89 KB	-rw-r--r--	2022-05-18 13:19
rpl_tblmap.h	3.1 KB	-rw-r--r--	2022-05-18 13:19
rpl_utility.h	9.32 KB	-rw-r--r--	2022-05-18 13:19
scheduler.h	3.43 KB	-rw-r--r--	2022-05-18 13:19
service_versions.h	1.82 KB	-rw-r--r--	2022-05-18 13:19
session_tracker.h	8.8 KB	-rw-r--r--	2022-05-18 13:19
set_var.h	14.52 KB	-rw-r--r--	2022-05-18 13:19
slave.h	11.14 KB	-rw-r--r--	2022-05-18 13:19
sp.h	7.13 KB	-rw-r--r--	2022-05-18 13:19
sp_cache.h	2.02 KB	-rw-r--r--	2022-05-18 13:19
sp_head.h	36.17 KB	-rw-r--r--	2022-05-18 13:19
sp_pcontext.h	16.61 KB	-rw-r--r--	2022-05-18 13:19
sp_rcontext.h	15.43 KB	-rw-r--r--	2022-05-18 13:19
span.h	3.83 KB	-rw-r--r--	2022-05-18 13:19
spatial.h	20.68 KB	-rw-r--r--	2022-05-18 13:19
sql_acl.h	17.23 KB	-rw-r--r--	2022-05-18 13:19
sql_admin.h	2.69 KB	-rw-r--r--	2022-05-18 13:19
sql_alter.h	12 KB	-rw-r--r--	2022-05-18 13:19
sql_analyse.h	10.91 KB	-rw-r--r--	2022-05-18 13:19
sql_analyze_stmt.h	7.61 KB	-rw-r--r--	2022-05-18 13:19
sql_array.h	5.92 KB	-rw-r--r--	2022-05-18 13:19
sql_audit.h	14.57 KB	-rw-r--r--	2022-05-18 13:19
sql_base.h	24.9 KB	-rw-r--r--	2022-05-18 13:19
sql_basic_types.h	951 B	-rw-r--r--	2022-05-18 13:19
sql_binlog.h	895 B	-rw-r--r--	2022-05-18 13:19
sql_bitmap.h	7.2 KB	-rw-r--r--	2022-05-18 13:19
sql_bootstrap.h	1.63 KB	-rw-r--r--	2022-05-18 13:19
sql_cache.h	20.88 KB	-rw-r--r--	2022-05-18 13:19
sql_callback.h	1.51 KB	-rw-r--r--	2022-05-18 13:19
sql_class.h	195.45 KB	-rw-r--r--	2022-05-18 13:19
sql_cmd.h	7.26 KB	-rw-r--r--	2022-05-18 13:19
sql_connect.h	3.56 KB	-rw-r--r--	2022-05-18 13:19
sql_const.h	10.43 KB	-rw-r--r--	2022-05-18 13:19
sql_crypt.h	1.39 KB	-rw-r--r--	2022-05-18 13:19
sql_cte.h	14.64 KB	-rw-r--r--	2022-05-18 13:19
sql_cursor.h	2.02 KB	-rw-r--r--	2022-05-18 13:19
sql_db.h	2.01 KB	-rw-r--r--	2022-05-18 13:19
sql_delete.h	1.32 KB	-rw-r--r--	2022-05-18 13:19
sql_derived.h	1.51 KB	-rw-r--r--	2022-05-18 13:19
sql_digest.h	3.72 KB	-rw-r--r--	2022-05-18 13:19
sql_digest_stream.h	1.53 KB	-rw-r--r--	2022-05-18 13:19
sql_do.h	954 B	-rw-r--r--	2022-05-18 13:19
sql_error.h	29.86 KB	-rw-r--r--	2022-05-18 13:19
sql_explain.h	24.63 KB	-rw-r--r--	2022-05-18 13:19
sql_expression_cache.h	4.21 KB	-rw-r--r--	2022-05-18 13:19
sql_get_diagnostics.h	7.66 KB	-rw-r--r--	2022-05-18 13:19
sql_handler.h	2.68 KB	-rw-r--r--	2022-05-18 13:19
sql_help.h	920 B	-rw-r--r--	2022-05-18 13:19
sql_hset.h	3.2 KB	-rw-r--r--	2022-05-18 13:19
sql_insert.h	2.06 KB	-rw-r--r--	2022-05-18 13:19
sql_join_cache.h	46.6 KB	-rw-r--r--	2022-05-18 13:19
sql_lex.h	103.48 KB	-rw-r--r--	2022-05-18 13:19
sql_lifo_buffer.h	9.23 KB	-rw-r--r--	2022-05-18 13:19
sql_list.h	21.37 KB	-rw-r--r--	2022-05-18 13:19
sql_load.h	1.24 KB	-rw-r--r--	2022-05-18 13:19
sql_locale.h	2.67 KB	-rw-r--r--	2022-05-18 13:19
sql_manager.h	960 B	-rw-r--r--	2022-05-18 13:19
sql_mode.h	6.57 KB	-rw-r--r--	2022-05-18 13:19
sql_parse.h	8.02 KB	-rw-r--r--	2022-05-18 13:19
sql_partition.h	11.43 KB	-rw-r--r--	2022-05-18 13:19
sql_partition_admin.h	5.68 KB	-rw-r--r--	2022-05-18 13:19
sql_plist.h	7.58 KB	-rw-r--r--	2022-05-18 13:19
sql_plugin.h	7.48 KB	-rw-r--r--	2022-05-18 13:19
sql_plugin_compat.h	2.18 KB	-rw-r--r--	2022-05-18 13:19
sql_prepare.h	11.3 KB	-rw-r--r--	2022-05-18 13:19
sql_priv.h	15.99 KB	-rw-r--r--	2022-05-18 13:19
sql_profile.h	7.39 KB	-rw-r--r--	2022-05-18 13:19
sql_reload.h	1.01 KB	-rw-r--r--	2022-05-18 13:19
sql_rename.h	941 B	-rw-r--r--	2022-05-18 13:19
sql_repl.h	3.24 KB	-rw-r--r--	2022-05-18 13:19
sql_select.h	77.03 KB	-rw-r--r--	2022-05-18 13:19
sql_servers.h	1.78 KB	-rw-r--r--	2022-05-18 13:19
sql_show.h	8.84 KB	-rw-r--r--	2022-05-18 13:19
sql_signal.h	4.05 KB	-rw-r--r--	2022-05-18 13:19
sql_sort.h	4.1 KB	-rw-r--r--	2022-05-18 13:19
sql_statistics.h	11.56 KB	-rw-r--r--	2022-05-18 13:19
sql_string.h	21.94 KB	-rw-r--r--	2022-05-18 13:19
sql_table.h	11.06 KB	-rw-r--r--	2022-05-18 13:19
sql_tablespace.h	956 B	-rw-r--r--	2022-05-18 13:19
sql_test.h	1.45 KB	-rw-r--r--	2022-05-18 13:19
sql_time.h	10.28 KB	-rw-r--r--	2022-05-18 13:19
sql_trigger.h	10.58 KB	-rw-r--r--	2022-05-18 13:19
sql_truncate.h	2.01 KB	-rw-r--r--	2022-05-18 13:19
sql_type.h	19.73 KB	-rw-r--r--	2022-05-18 13:19
sql_type_int.h	2.85 KB	-rw-r--r--	2022-05-18 13:19
sql_udf.h	4.04 KB	-rw-r--r--	2022-05-18 13:19
sql_union.h	1.1 KB	-rw-r--r--	2022-05-18 13:19
sql_update.h	1.92 KB	-rw-r--r--	2022-05-18 13:19
sql_view.h	2.26 KB	-rw-r--r--	2022-05-18 13:19
sql_window.h	5.89 KB	-rw-r--r--	2022-05-18 13:19
sql_yacc.h	35.19 KB	-rw-r--r--	2022-05-18 13:19
ssl_compat.h	2.97 KB	-rw-r--r--	2022-05-18 13:19
strfunc.h	2.21 KB	-rw-r--r--	2022-05-18 13:19
structs.h	20.36 KB	-rw-r--r--	2022-05-18 13:19
sys_vars_shared.h	2.6 KB	-rw-r--r--	2022-05-18 13:19
t_ctype.h	5.51 KB	-rw-r--r--	2022-05-18 13:19
table.h	95.89 KB	-rw-r--r--	2022-05-18 13:19
table_cache.h	4.24 KB	-rw-r--r--	2022-05-18 13:19
thr_alarm.h	2.87 KB	-rw-r--r--	2022-05-18 13:19
thr_lock.h	6.66 KB	-rw-r--r--	2022-05-18 13:19
thr_malloc.h	1.22 KB	-rw-r--r--	2022-05-18 13:19
thr_timer.h	1.43 KB	-rw-r--r--	2022-05-18 13:19
thread_pool_priv.h	4.48 KB	-rw-r--r--	2022-05-18 13:19
threadpool.h	4.32 KB	-rw-r--r--	2022-05-18 13:19
transaction.h	1.57 KB	-rw-r--r--	2022-05-18 13:19
tzfile.h	4.9 KB	-rw-r--r--	2022-05-18 13:19
tztime.h	3.28 KB	-rw-r--r--	2022-05-18 13:19
uniques.h	4.05 KB	-rw-r--r--	2022-05-18 13:19
unireg.h	7.22 KB	-rw-r--r--	2022-05-18 13:19
violite.h	9.83 KB	-rw-r--r--	2022-05-18 13:19
waiting_threads.h	4.45 KB	-rw-r--r--	2022-05-18 13:19
welcome_copyright_notice.h	1.19 KB	-rw-r--r--	2022-05-18 13:19
win_tzname_data.h	6.31 KB	-rw-r--r--	2022-05-18 13:19
winservice.h	1.17 KB	-rw-r--r--	2022-05-18 13:19
wqueue.h	1.55 KB	-rw-r--r--	2022-05-18 13:19
wsrep.h	3.01 KB	-rw-r--r--	2022-05-18 13:19
wsrep_applier.h	1.67 KB	-rw-r--r--	2022-05-18 13:19
wsrep_binlog.h	2.06 KB	-rw-r--r--	2022-05-18 13:19
wsrep_mysqld.h	13.88 KB	-rw-r--r--	2022-05-18 13:19
wsrep_mysqld_c.h	1.2 KB	-rw-r--r--	2022-05-18 13:19
wsrep_priv.h	2.07 KB	-rw-r--r--	2022-05-18 13:19
wsrep_sst.h	3.08 KB	-rw-r--r--	2022-05-18 13:19
wsrep_thd.h	2.05 KB	-rw-r--r--	2022-05-18 13:19
wsrep_utils.h	9.02 KB	-rw-r--r--	2022-05-18 13:19
wsrep_var.h	3.72 KB	-rw-r--r--	2022-05-18 13:19
wsrep_xid.h	1.38 KB	-rw-r--r--	2022-05-18 13:19

Rename

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

typedef
enum enum_use_stat_tables_mode
{
  NEVER,
  COMPLEMENTARY,
  PREFERABLY,
} 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);
}

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, LEX_STRING *db, LEX_STRING *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, LEX_STRING *db, LEX_STRING *tab,
                                LEX_STRING *new_db, LEX_STRING *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 char *db, const char *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;

static inline
int rename_table_in_stat_tables(THD *thd, const char *db, const char *tab,
                                const char *new_db, const char *new_tab)
{
  LEX_STRING od= { const_cast<char*>(db), strlen(db) };
  LEX_STRING ot= { const_cast<char*>(tab), strlen(tab) };
  LEX_STRING nd= { const_cast<char*>(new_db), strlen(new_db) };
  LEX_STRING nt= { const_cast<char*>(new_tab), strlen(new_tab) };
  return rename_table_in_stat_tables(thd, &od, &ot, &nd, &nt);
}

/* 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 */