MySQL 8.0.33
Source Code Documentation
dict0stats.h
Go to the documentation of this file.
1/*****************************************************************************
2
3Copyright (c) 2009, 2023, Oracle and/or its affiliates.
4
5This program is free software; you can redistribute it and/or modify it under
6the terms of the GNU General Public License, version 2.0, as published by the
7Free Software Foundation.
8
9This program is also distributed with certain software (including but not
10limited to OpenSSL) that is licensed under separate terms, as designated in a
11particular file or component or in included license documentation. The authors
12of MySQL hereby grant you an additional permission to link the program and
13your derivative works with the separately licensed software that they have
14included with MySQL.
15
16This program is distributed in the hope that it will be useful, but WITHOUT
17ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
18FOR A PARTICULAR PURPOSE. See the GNU General Public License, version 2.0,
19for more details.
20
21You should have received a copy of the GNU General Public License along with
22this program; if not, write to the Free Software Foundation, Inc.,
2351 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
24
25*****************************************************************************/
26
27/** @file include/dict0stats.h
28 Code used for calculating and manipulating table statistics.
29
30 Created Jan 06, 2010 Vasil Dimov
31 *******************************************************/
32
33#ifndef dict0stats_h
34#define dict0stats_h
35
36#include "univ.i"
37
38#include "dict0types.h"
39#include "mem0mem.h"
40#include "trx0types.h"
41
43 DICT_STATS_RECALC_PERSISTENT, /* (re) calculate the
44 statistics using a precise and slow
45 algo and save them to the persistent
46 storage, if the persistent storage is
47 not present then emit a warning and
48 fall back to transient stats */
49 DICT_STATS_RECALC_TRANSIENT, /* (re) calculate the statistics
50 using an imprecise quick algo
51 without saving the results
52 persistently */
53 DICT_STATS_EMPTY_TABLE, /* Write all zeros (or 1 where it makes sense)
54 into a table and its indexes' statistics
55 members. The resulting stats correspond to an
56 empty table. If the table is using persistent
57 statistics, then they are saved on disk. */
59 from the persistent storage if the in-memory
60 structures have not been initialized yet,
61 otherwise do nothing */
62};
63
64/** Set the persistent statistics flag for a given table. This is set only in
65the in-memory table object and is not saved on disk. It will be read from the
66.frm file upon first open from MySQL after a server restart.
67@param[in,out] table table
68@param[in] ps_on persistent stats explicitly enabled
69@param[in] ps_off persistent stats explicitly disabled */
70static inline void dict_stats_set_persistent(dict_table_t *table, bool ps_on,
71 bool ps_off);
72
73/** Check whether persistent statistics is enabled for a given table.
74 @return true if enabled, false otherwise */
75[[nodiscard]] static inline bool dict_stats_is_persistent_enabled(
76 const dict_table_t *table); /*!< in: table */
77
78/** Set the auto recalc flag for a given table (only honored for a persistent
79stats enabled table). The flag is set only in the in-memory table object and is
80not saved in InnoDB files. It will be read from the .frm file upon first open
81from MySQL after a server restart.
82@param[in,out] table table
83@param[in] auto_recalc_on explicitly enabled
84@param[in] auto_recalc_off explicitly disabled */
85static inline void dict_stats_auto_recalc_set(dict_table_t *table,
86 bool auto_recalc_on,
87 bool auto_recalc_off);
88
89/** Check whether auto recalc is enabled for a given table.
90 @return true if enabled, false otherwise */
92 const dict_table_t *table); /*!< in: table */
93
94/** Initialize table's stats for the first time when opening a table. */
95static inline void dict_stats_init(dict_table_t *table); /*!< in/out: table */
96
97/** Deinitialize table's stats after the last close of the table. This is
98 used to detect "FLUSH TABLE" and refresh the stats upon next open. */
99static inline void dict_stats_deinit(dict_table_t *table); /*!< in/out: table */
100
101/** Calculates new estimates for table and index statistics. The statistics
102 are used in query optimization.
103 @return DB_* error code or DB_SUCCESS */
104dberr_t dict_stats_update(dict_table_t *table, /*!< in/out: table */
105 dict_stats_upd_option_t stats_upd_option);
106/*!< in: whether to (re) calc
107the stats or to fetch them from
108the persistent storage */
109
110/** Removes the information for a particular index's stats from the persistent
111 storage if it exists and if there is data stored for this index.
112 This function creates its own trx and commits it.
113 @return DB_SUCCESS or error code */
115 const char *tname, /*!< in: table name */
116 const char *iname, /*!< in: index name */
117 char *errstr, /*!< out: error message if != DB_SUCCESS
118 is returned */
119 ulint errstr_sz); /*!< in: size of the errstr buffer */
120
121/** Removes the statistics for a table and all of its indexes from the
122 persistent storage if it exists and if there is data stored for the table.
123 This function creates its own transaction and commits it.
124 @return DB_SUCCESS or error code */
126 const char *table_name, /*!< in: table name */
127 char *errstr, /*!< out: error message
128 if != DB_SUCCESS is returned */
129 ulint errstr_sz); /*!< in: size of errstr buffer */
130
131/** Fetches or calculates new estimates for index statistics. */
132void dict_stats_update_for_index(dict_index_t *index); /*!< in/out: index */
133
134/** Renames a table in InnoDB persistent stats storage.
135 This function creates its own transaction and commits it.
136 @return DB_SUCCESS or error code */
137dberr_t dict_stats_rename_table(const char *old_name, /*!< in: old table name */
138 const char *new_name, /*!< in: new table name */
139 char *errstr, /*!< out: error string if !=
140 DB_SUCCESS is returned */
141 size_t errstr_sz); /*!< in: errstr size */
142
143/** Renames an index in InnoDB persistent stats storage.
144 This function creates its own transaction and commits it.
145 @return DB_SUCCESS or error code. DB_STATS_DO_NOT_EXIST will be returned
146 if the persistent stats do not exist. */
147[[nodiscard]] dberr_t dict_stats_rename_index(
148 const dict_table_t *table, /*!< in: table whose index
149 is renamed */
150 const char *old_index_name, /*!< in: old index name */
151 const char *new_index_name); /*!< in: new index name */
152
153/** Evict the stats tables if they loaded in tablespace cache and also
154close the stats .ibd files. We have to close stats tables because
1558.0 stats tables will use the same name. We load the stats from 5.7
156with a suffix "_backup57" and migrate the statistics. */
158
159/** Represent the record of innodb_table_stats table. */
161 public:
162 /** Constructor. */
164
165 /** Destructor. */
167
168 /** Set the data for the innodb_table_stats record.
169 @param[in] data data to be set in the record
170 @param[in] col_offset column offset
171 @param[in] len length of the data. */
172 void set_data(const byte *data, ulint col_offset, ulint len);
173
174 /** Get the table name from innodb_table_stats record.
175 @retval table name of the table_stats record. */
176 char *get_tbl_name() const;
177
178 /** Set the table name for the innodb_table_stats record.
179 @param[in] data data to be set in the record
180 @param[in] len length of the data. */
181 void set_tbl_name(const byte *data, ulint len);
182
183 /** Get the db name from the innodb_table_stats record.
184 @retval db name of the table stats record. */
185 char *get_db_name() const;
186
187 /** Set the db name for the innodb_table_stats record.
188 @param[in] data data to be set
189 @param[in] len length of the data. */
190 void set_db_name(const byte *data, ulint len);
191
192 /** Get the n_rows from the innodb_table_stats record.
193 @retval n_rows from the record. */
194 uint64_t get_n_rows() const;
195
196 /** Set the n_rows for the innodb_table_stats record.
197 @param[in] no_of_rows number of rows. */
198 void set_n_rows(uint64_t no_of_rows);
199
200 /** Get the clustered index size from
201 innodb_table_stats record.
202 @retval size of the clustered index. */
204
205 /** Set the clustered index size for the
206 innodb_table_stats record.
207 @param[in] clust_size clustered index size. */
208 void set_clustered_index_size(ulint clust_size);
209
210 /** Get the sum of other index size.
211 @retval sum of secondary index size. */
213
214 /** Set the sum of sec index size.
215 @param[in] sum_of_other_index_size sum of secondary index size. */
216 void set_sum_of_other_index_size(ulint sum_of_other_index_size);
217
218 /** Column number of innodb_table_stats.database_name. */
219 static constexpr unsigned DB_NAME_COL_NO = 0;
220 /** Column number of innodb_table_stats.table_name. */
221 static constexpr unsigned TABLE_NAME_COL_NO = 1;
222 /** Column number of innodb_table_stats.n_rows. */
223 static constexpr unsigned N_ROWS_COL_NO = 3;
224 /** Column number of innodb_table_stats.clustered_index_size. */
225 static constexpr unsigned CLUST_INDEX_SIZE_COL_NO = 4;
226 /** Column number of innodb_table_stats.sum_of_other_index_sizes. */
227 static constexpr unsigned SUM_OF_OTHER_INDEX_SIZE_COL_NO = 5;
228
229 private:
230 /** Database name. */
232 /** Table name. */
234 /** Number of rows. */
235 uint64_t m_n_rows;
236 /** Clustered index size. */
238 /** Sum of other index size. */
240 /** Heap to store db_name, tbl_name for the record. */
242};
243
244#include "dict0stats.ic"
245
246#ifdef UNIV_ENABLE_UNIT_TEST_DICT_STATS
247void test_dict_stats_all();
248#endif /* UNIV_ENABLE_UNIT_TEST_DICT_STATS */
249
250#endif /* dict0stats_h */
Represent the record of innodb_table_stats table.
Definition: dict0stats.h:160
ulint m_sum_of_other_index_sizes
Sum of other index size.
Definition: dict0stats.h:239
void set_db_name(const byte *data, ulint len)
Set the db name for the innodb_table_stats record.
Definition: dict0stats.cc:3536
void set_n_rows(uint64_t no_of_rows)
Set the n_rows for the innodb_table_stats record.
Definition: dict0stats.cc:3513
void set_clustered_index_size(ulint clust_size)
Set the clustered index size for the innodb_table_stats record.
Definition: dict0stats.cc:3521
char * m_tbl_name
Table name.
Definition: dict0stats.h:233
void set_data(const byte *data, ulint col_offset, ulint len)
Set the data for the innodb_table_stats record.
Definition: dict0stats.cc:3556
static constexpr unsigned CLUST_INDEX_SIZE_COL_NO
Column number of innodb_table_stats.clustered_index_size.
Definition: dict0stats.h:225
static constexpr unsigned DB_NAME_COL_NO
Column number of innodb_table_stats.database_name.
Definition: dict0stats.h:219
mem_heap_t * m_heap
Heap to store db_name, tbl_name for the record.
Definition: dict0stats.h:241
void set_tbl_name(const byte *data, ulint len)
Set the table name for the innodb_table_stats record.
Definition: dict0stats.cc:3547
ulint m_clustered_index_size
Clustered index size.
Definition: dict0stats.h:237
static constexpr unsigned TABLE_NAME_COL_NO
Column number of innodb_table_stats.table_name.
Definition: dict0stats.h:221
void set_sum_of_other_index_size(ulint sum_of_other_index_size)
Set the sum of sec index size.
Definition: dict0stats.cc:3529
static constexpr unsigned N_ROWS_COL_NO
Column number of innodb_table_stats.n_rows.
Definition: dict0stats.h:223
ulint get_sum_of_other_index_size() const
Get the sum of other index size.
Definition: dict0stats.cc:3525
char * get_db_name() const
Get the db name from the innodb_table_stats record.
Definition: dict0stats.cc:3534
TableStatsRecord()
Constructor.
Definition: dict0stats.cc:3503
~TableStatsRecord()
Destructor.
Definition: dict0stats.cc:3505
static constexpr unsigned SUM_OF_OTHER_INDEX_SIZE_COL_NO
Column number of innodb_table_stats.sum_of_other_index_sizes.
Definition: dict0stats.h:227
char * m_db_name
Database name.
Definition: dict0stats.h:231
char * get_tbl_name() const
Get the table name from innodb_table_stats record.
Definition: dict0stats.cc:3545
uint64_t m_n_rows
Number of rows.
Definition: dict0stats.h:235
uint64_t get_n_rows() const
Get the n_rows from the innodb_table_stats record.
Definition: dict0stats.cc:3511
ulint get_clustered_index_size() const
Get the clustered index size from innodb_table_stats record.
Definition: dict0stats.cc:3517
dberr_t
Definition: db0err.h:38
static bool dict_stats_auto_recalc_is_enabled(const dict_table_t *table)
Check whether auto recalc is enabled for a given table.
static void dict_stats_init(dict_table_t *table)
Initialize table's stats for the first time when opening a table.
void dict_stats_evict_tablespaces()
Evict the stats tables if they loaded in tablespace cache and also close the stats ....
Definition: dict0stats.cc:3461
dberr_t dict_stats_rename_table(const char *old_name, const char *new_name, char *errstr, size_t errstr_sz)
Renames a table in InnoDB persistent stats storage.
Definition: dict0stats.cc:3283
dict_stats_upd_option_t
Definition: dict0stats.h:42
@ DICT_STATS_RECALC_PERSISTENT
Definition: dict0stats.h:43
@ DICT_STATS_RECALC_TRANSIENT
Definition: dict0stats.h:49
@ DICT_STATS_FETCH_ONLY_IF_NOT_IN_MEMORY
Definition: dict0stats.h:58
@ DICT_STATS_EMPTY_TABLE
Definition: dict0stats.h:53
dberr_t dict_stats_drop_table(const char *table_name, char *errstr, ulint errstr_sz)
Removes the statistics for a table and all of its indexes from the persistent storage if it exists an...
Definition: dict0stats.cc:3129
void dict_stats_update_for_index(dict_index_t *index)
Fetches or calculates new estimates for index statistics.
Definition: dict0stats.cc:2793
static void dict_stats_auto_recalc_set(dict_table_t *table, bool auto_recalc_on, bool auto_recalc_off)
Set the auto recalc flag for a given table (only honored for a persistent stats enabled table).
dberr_t dict_stats_drop_index(const char *tname, const char *iname, char *errstr, ulint errstr_sz)
Removes the information for a particular index's stats from the persistent storage if it exists and i...
Definition: dict0stats.cc:2990
static bool dict_stats_is_persistent_enabled(const dict_table_t *table)
Check whether persistent statistics is enabled for a given table.
static void dict_stats_set_persistent(dict_table_t *table, bool ps_on, bool ps_off)
Set the persistent statistics flag for a given table.
dberr_t dict_stats_update(dict_table_t *table, dict_stats_upd_option_t stats_upd_option)
Calculates new estimates for table and index statistics.
Definition: dict0stats.cc:2816
dberr_t dict_stats_rename_index(const dict_table_t *table, const char *old_index_name, const char *new_index_name)
Renames an index in InnoDB persistent stats storage.
Definition: dict0stats.cc:3414
static void dict_stats_deinit(dict_table_t *table)
Deinitialize table's stats after the last close of the table.
Code used for calculating and manipulating table statistics.
Data dictionary global types.
The memory management.
const char * table_name
Definition: rules_table_service.cc:55
Data structure for an index.
Definition: dict0mem.h:1045
Data structure for a database table.
Definition: dict0mem.h:1908
The info structure stored at the beginning of a heap block.
Definition: mem0mem.h:301
Transaction system global type definitions.
Version control for database, common definitions, and include files.
unsigned long int ulint
Definition: univ.i:405