MySQL 8.4.3
Source Code Documentation
myisam.h File Reference

This file should be included when using myisam functions. More...

#include "my_config.h"
#include <sys/types.h>
#include <time.h>
#include "keycache.h"
#include "my_base.h"
#include "my_check_opt.h"
#include "my_checksum.h"
#include "my_compare.h"
#include "my_inttypes.h"
#include "my_io.h"
#include "my_macros.h"
#include "mysql/strings/m_ctype.h"

Go to the source code of this file.

Classes

struct  MI_ISAMINFO
 
struct  MI_CREATE_INFO
 
struct  MI_KEYDEF
 
struct  MI_UNIQUEDEF
 
struct  MI_DECODE_TREE
 
struct  MI_COLUMNDEF
 
struct  SORT_KEY_BLOCKS
 
struct  MI_CHECK
 
struct  SORT_FT_BUF
 
struct  SORT_INFO
 

Macros

#define MI_MAX_KEY   MAX_INDEXES /* Max allowed keys */
 
#define MI_MAX_POSSIBLE_KEY_BUFF   HA_MAX_POSSIBLE_KEY_BUFF
 
#define MI_MAX_KEY_LENGTH   1000 /* Max length in bytes */
 
#define MI_MAX_KEY_SEG   16 /* Max segments for key */
 
#define MI_MAX_KEY_BUFF   (MI_MAX_KEY_LENGTH + MI_MAX_KEY_SEG * 6 + 8 + 8)
 
#define MI_MAX_MSG_BUF   1024 /* used in CHECK TABLE, REPAIR TABLE */
 
#define MI_NAME_IEXT   ".MYI"
 
#define MI_NAME_DEXT   ".MYD"
 
#define MI_KEY_BLOCK_LENGTH   1024U /* default key block length */
 
#define MI_MIN_KEY_BLOCK_LENGTH   1024U /* Min key block length */
 
#define MI_MAX_KEY_BLOCK_LENGTH   16384U
 
#define MI_KEYMAP_BITS   (8 * SIZEOF_LONG_LONG)
 
#define MI_KEYMAP_HIGH_MASK   (1ULL << (MI_KEYMAP_BITS - 1))
 
#define mi_get_mask_all_keys_active(_keys_)    (((_keys_) < MI_KEYMAP_BITS) ? ((1ULL << (_keys_)) - 1ULL) : (~0ULL))
 
#define mi_set_key_active(_keymap_, _keyno_)   (_keymap_) |= (1ULL << (_keyno_))
 
#define mi_clear_key_active(_keymap_, _keyno_)    (_keymap_) &= (~(1ULL << (_keyno_)))
 
#define mi_is_all_keys_active(_keymap_, _keys_)    ((_keymap_) == mi_get_mask_all_keys_active(_keys_))
 
#define mi_set_all_keys_active(_keymap_, _keys_)    (_keymap_) = mi_get_mask_all_keys_active(_keys_)
 
#define mi_clear_all_keys_active(_keymap_)   (_keymap_) = 0
 
#define mi_intersect_keys_active(_to_, _from_)   (_to_) &= (_from_)
 
#define mi_is_any_intersect_keys_active(_keymap1_, _keys_, _keymap2_)    ((_keymap1_) & (_keymap2_)&mi_get_mask_all_keys_active(_keys_))
 
#define mi_copy_keys_active(_to_, _maxkeys_, _from_)    (_to_) = (mi_get_mask_all_keys_active(_maxkeys_) & (_from_))
 
#define MI_UNIQUE_HASH_LENGTH   4
 
#define mi_close(file)   mi_close_share(file, NULL)
 
#define mi_open(name, mode, wait_if_locked)    mi_open_share(name, NULL, mode, wait_if_locked)
 
#define MEMMAP_EXTRA_MARGIN   7 /* Write this as a suffix for mmap file */
 
#define MYISAMCHK_REPAIR   1 /* equivalent to myisamchk -r */
 
#define MYISAMCHK_VERIFY   2 /* Verify, run repair if failure */
 
#define TT_USEFRM   1
 
#define TT_FOR_UPGRADE   2
 
#define O_NEW_INDEX   1 /* Bits set in out_flag */
 
#define O_NEW_DATA   2
 
#define O_DATA_LOST   4
 

Enumerations

enum  enum_mi_stats_method { MI_STATS_METHOD_NULLS_NOT_EQUAL , MI_STATS_METHOD_NULLS_EQUAL , MI_STATS_METHOD_IGNORE_NULLS }
 

Functions

bool mi_is_key_active (uint64 _keymap_, unsigned int _keyno_)
 
bool mi_is_any_key_active (uint64 _keymap_)
 
int mi_close_share (MI_INFO *file, bool *closed_share)
 
int mi_delete (MI_INFO *file, const uchar *buff)
 
MI_INFOmi_open_share (const char *name, MYISAM_SHARE *old_share, int mode, uint wait_if_locked)
 
int mi_panic (enum ha_panic_function function)
 
int mi_rfirst (MI_INFO *file, uchar *buf, int inx)
 
int mi_rkey (MI_INFO *info, uchar *buf, int inx, const uchar *key, key_part_map keypart_map, enum ha_rkey_function search_flag)
 
int mi_rlast (MI_INFO *file, uchar *buf, int inx)
 
int mi_rnext (MI_INFO *file, uchar *buf, int inx)
 
int mi_rnext_same (MI_INFO *info, uchar *buf)
 
int mi_rprev (MI_INFO *file, uchar *buf, int inx)
 
int mi_rrnd (MI_INFO *file, uchar *buf, my_off_t pos)
 
int mi_scan_init (MI_INFO *file)
 
int mi_scan (MI_INFO *file, uchar *buf)
 
int mi_rsame (MI_INFO *file, uchar *record, int inx)
 
int mi_rsame_with_pos (MI_INFO *file, uchar *record, int inx, my_off_t pos)
 
int mi_update (MI_INFO *file, const uchar *old, uchar *new_record)
 
int mi_write (MI_INFO *file, uchar *buff)
 
my_off_t mi_position (MI_INFO *file)
 
int mi_status (MI_INFO *info, MI_ISAMINFO *x, uint flag)
 
int mi_lock_database (MI_INFO *file, int lock_type)
 
int mi_create (const char *name, uint keys, MI_KEYDEF *keydef, uint columns, MI_COLUMNDEF *columndef, uint uniques, MI_UNIQUEDEF *uniquedef, MI_CREATE_INFO *create_info, uint flags)
 
int mi_delete_table (const char *name)
 
int mi_rename (const char *from, const char *to)
 
int mi_extra (MI_INFO *file, enum ha_extra_function function, void *extra_arg)
 
int mi_reset (MI_INFO *file)
 
ha_rows mi_records_in_range (MI_INFO *info, int inx, key_range *min_key, key_range *max_key)
 
int mi_log (int activate_log)
 
int mi_is_changed (MI_INFO *info)
 
int mi_delete_all_rows (MI_INFO *info)
 
ulong _mi_calc_blob_length (uint length, const uchar *pos)
 
uint mi_get_pointer_length (ulonglong file_length, uint def)
 
void myisamchk_init (MI_CHECK *param)
 
int chk_status (MI_CHECK *param, MI_INFO *info)
 
int chk_del (MI_CHECK *param, MI_INFO *info, uint test_flag)
 
int chk_size (MI_CHECK *param, MI_INFO *info)
 
int chk_key (MI_CHECK *param, MI_INFO *info)
 
int chk_data_link (MI_CHECK *param, MI_INFO *info, int extend)
 
int mi_repair (MI_CHECK *param, MI_INFO *info, char *name, int rep_quick, bool no_copy_stat)
 
int mi_sort_index (MI_CHECK *param, MI_INFO *info, char *name, bool no_copy_stat)
 
int mi_repair_by_sort (MI_CHECK *param, MI_INFO *info, const char *name, int rep_quick, bool no_copy_stat)
 
int change_to_newfile (const char *filename, const char *old_ext, const char *new_ext, myf myflags)
 
int lock_file (MI_CHECK *param, File file, int lock_type, const char *filetype, const char *filename)
 
void lock_memory (MI_CHECK *param)
 
void update_auto_increment_key (MI_CHECK *param, MI_INFO *info, bool repair)
 
int update_state_info (MI_CHECK *param, MI_INFO *info, uint update)
 
void update_key_parts (MI_KEYDEF *keyinfo, ulong *rec_per_key_part, ulonglong *unique, ulonglong *notnull, ulonglong records)
 
int filecopy (MI_CHECK *param, File to, File from, my_off_t start, my_off_t length, const char *type)
 
int movepoint (MI_INFO *info, uchar *record, my_off_t oldpos, my_off_t newpos, uint prot_key)
 
int write_data_suffix (SORT_INFO *sort_info, bool fix_datafile)
 
int test_if_almost_full (MI_INFO *info)
 
int recreate_table (MI_CHECK *param, MI_INFO **org_info, char *filename)
 
void mi_disable_non_unique_index (MI_INFO *info, ha_rows rows)
 
bool mi_test_if_sort_rep (MI_INFO *info, ha_rows rows, ulonglong key_map, bool force)
 
int mi_init_bulk_insert (MI_INFO *info, ulong cache_size, ha_rows rows)
 
void mi_flush_bulk_insert (MI_INFO *info, uint inx)
 
void mi_end_bulk_insert (MI_INFO *info)
 
int mi_assign_to_key_cache (MI_INFO *info, ulonglong key_map, KEY_CACHE *key_cache)
 
void mi_change_key_cache (KEY_CACHE *old_key_cache, KEY_CACHE *new_key_cache)
 
int mi_preload (MI_INFO *info, ulonglong key_map, bool ignore_leaves)
 
st_keycache_thread_varkeycache_thread_var ()
 

Variables

const char * myisam_log_filename
 
ulong myisam_block_size
 
ulong myisam_concurrent_insert
 
bool myisam_flush
 
bool myisam_delay_key_write
 
bool myisam_single_user
 
my_off_t myisam_max_temp_length
 
ulong myisam_data_pointer_size
 
int(* myisam_test_invalid_symlink )(const char *filename)
 
ulonglong myisam_mmap_size
 
ulonglong myisam_mmap_used
 
mysql_mutex_t THR_LOCK_myisam_mmap
 
st_keycache_thread_var main_thread_keycache_var
 

Detailed Description

This file should be included when using myisam functions.

Macro Definition Documentation

◆ MEMMAP_EXTRA_MARGIN

#define MEMMAP_EXTRA_MARGIN   7 /* Write this as a suffix for mmap file */

◆ mi_clear_all_keys_active

#define mi_clear_all_keys_active (   _keymap_)    (_keymap_) = 0

◆ mi_clear_key_active

#define mi_clear_key_active (   _keymap_,
  _keyno_ 
)     (_keymap_) &= (~(1ULL << (_keyno_)))

◆ mi_close

#define mi_close (   file)    mi_close_share(file, NULL)

◆ mi_copy_keys_active

#define mi_copy_keys_active (   _to_,
  _maxkeys_,
  _from_ 
)     (_to_) = (mi_get_mask_all_keys_active(_maxkeys_) & (_from_))

◆ mi_get_mask_all_keys_active

#define mi_get_mask_all_keys_active (   _keys_)     (((_keys_) < MI_KEYMAP_BITS) ? ((1ULL << (_keys_)) - 1ULL) : (~0ULL))

◆ mi_intersect_keys_active

#define mi_intersect_keys_active (   _to_,
  _from_ 
)    (_to_) &= (_from_)

◆ mi_is_all_keys_active

#define mi_is_all_keys_active (   _keymap_,
  _keys_ 
)     ((_keymap_) == mi_get_mask_all_keys_active(_keys_))

◆ mi_is_any_intersect_keys_active

#define mi_is_any_intersect_keys_active (   _keymap1_,
  _keys_,
  _keymap2_ 
)     ((_keymap1_) & (_keymap2_)&mi_get_mask_all_keys_active(_keys_))

◆ MI_KEY_BLOCK_LENGTH

#define MI_KEY_BLOCK_LENGTH   1024U /* default key block length */

◆ MI_KEYMAP_BITS

#define MI_KEYMAP_BITS   (8 * SIZEOF_LONG_LONG)

◆ MI_KEYMAP_HIGH_MASK

#define MI_KEYMAP_HIGH_MASK   (1ULL << (MI_KEYMAP_BITS - 1))

◆ MI_MAX_KEY

#define MI_MAX_KEY   MAX_INDEXES /* Max allowed keys */

◆ MI_MAX_KEY_BLOCK_LENGTH

#define MI_MAX_KEY_BLOCK_LENGTH   16384U

◆ MI_MAX_KEY_BUFF

#define MI_MAX_KEY_BUFF   (MI_MAX_KEY_LENGTH + MI_MAX_KEY_SEG * 6 + 8 + 8)

◆ MI_MAX_KEY_LENGTH

#define MI_MAX_KEY_LENGTH   1000 /* Max length in bytes */

◆ MI_MAX_KEY_SEG

#define MI_MAX_KEY_SEG   16 /* Max segments for key */

◆ MI_MAX_MSG_BUF

#define MI_MAX_MSG_BUF   1024 /* used in CHECK TABLE, REPAIR TABLE */

◆ MI_MAX_POSSIBLE_KEY_BUFF

#define MI_MAX_POSSIBLE_KEY_BUFF   HA_MAX_POSSIBLE_KEY_BUFF

◆ MI_MIN_KEY_BLOCK_LENGTH

#define MI_MIN_KEY_BLOCK_LENGTH   1024U /* Min key block length */

◆ MI_NAME_DEXT

#define MI_NAME_DEXT   ".MYD"

◆ MI_NAME_IEXT

#define MI_NAME_IEXT   ".MYI"

◆ mi_open

#define mi_open (   name,
  mode,
  wait_if_locked 
)     mi_open_share(name, NULL, mode, wait_if_locked)

◆ mi_set_all_keys_active

#define mi_set_all_keys_active (   _keymap_,
  _keys_ 
)     (_keymap_) = mi_get_mask_all_keys_active(_keys_)

◆ mi_set_key_active

#define mi_set_key_active (   _keymap_,
  _keyno_ 
)    (_keymap_) |= (1ULL << (_keyno_))

◆ MI_UNIQUE_HASH_LENGTH

#define MI_UNIQUE_HASH_LENGTH   4

◆ MYISAMCHK_REPAIR

#define MYISAMCHK_REPAIR   1 /* equivalent to myisamchk -r */

◆ MYISAMCHK_VERIFY

#define MYISAMCHK_VERIFY   2 /* Verify, run repair if failure */

◆ O_DATA_LOST

#define O_DATA_LOST   4

◆ O_NEW_DATA

#define O_NEW_DATA   2

◆ O_NEW_INDEX

#define O_NEW_INDEX   1 /* Bits set in out_flag */

◆ TT_FOR_UPGRADE

#define TT_FOR_UPGRADE   2

◆ TT_USEFRM

#define TT_USEFRM   1

Enumeration Type Documentation

◆ enum_mi_stats_method

Enumerator
MI_STATS_METHOD_NULLS_NOT_EQUAL 
MI_STATS_METHOD_NULLS_EQUAL 
MI_STATS_METHOD_IGNORE_NULLS 

Function Documentation

◆ _mi_calc_blob_length()

ulong _mi_calc_blob_length ( uint  length,
const uchar pos 
)

◆ change_to_newfile()

int change_to_newfile ( const char *  filename,
const char *  old_ext,
const char *  new_ext,
myf  myflags 
)

◆ chk_data_link()

int chk_data_link ( MI_CHECK param,
MI_INFO info,
int  extend 
)

◆ chk_del()

int chk_del ( MI_CHECK param,
MI_INFO info,
uint  test_flag 
)

◆ chk_key()

int chk_key ( MI_CHECK param,
MI_INFO info 
)

◆ chk_size()

int chk_size ( MI_CHECK param,
MI_INFO info 
)

◆ chk_status()

int chk_status ( MI_CHECK param,
MI_INFO info 
)

◆ filecopy()

int filecopy ( MI_CHECK param,
File  to,
File  from,
my_off_t  start,
my_off_t  length,
const char *  type 
)

◆ keycache_thread_var()

st_keycache_thread_var * keycache_thread_var ( )

◆ lock_file()

int lock_file ( MI_CHECK param,
File  file,
int  lock_type,
const char *  filetype,
const char *  filename 
)

◆ lock_memory()

void lock_memory ( MI_CHECK param)

◆ mi_assign_to_key_cache()

int mi_assign_to_key_cache ( MI_INFO info,
ulonglong  key_map,
KEY_CACHE key_cache 
)

◆ mi_change_key_cache()

void mi_change_key_cache ( KEY_CACHE old_key_cache,
KEY_CACHE new_key_cache 
)

◆ mi_close_share()

int mi_close_share ( MI_INFO file,
bool *  closed_share 
)

◆ mi_create()

int mi_create ( const char *  name,
uint  keys,
MI_KEYDEF keydef,
uint  columns,
MI_COLUMNDEF columndef,
uint  uniques,
MI_UNIQUEDEF uniquedef,
MI_CREATE_INFO create_info,
uint  flags 
)

◆ mi_delete()

int mi_delete ( MI_INFO file,
const uchar buff 
)

◆ mi_delete_all_rows()

int mi_delete_all_rows ( MI_INFO info)

◆ mi_delete_table()

int mi_delete_table ( const char *  name)

◆ mi_disable_non_unique_index()

void mi_disable_non_unique_index ( MI_INFO info,
ha_rows  rows 
)

◆ mi_end_bulk_insert()

void mi_end_bulk_insert ( MI_INFO info)

◆ mi_extra()

int mi_extra ( MI_INFO file,
enum ha_extra_function  function,
void *  extra_arg 
)

◆ mi_flush_bulk_insert()

void mi_flush_bulk_insert ( MI_INFO info,
uint  inx 
)

◆ mi_get_pointer_length()

uint mi_get_pointer_length ( ulonglong  file_length,
uint  def 
)

◆ mi_init_bulk_insert()

int mi_init_bulk_insert ( MI_INFO info,
ulong  cache_size,
ha_rows  rows 
)

◆ mi_is_any_key_active()

bool mi_is_any_key_active ( uint64  _keymap_)
inline

◆ mi_is_changed()

int mi_is_changed ( MI_INFO info)

◆ mi_is_key_active()

bool mi_is_key_active ( uint64  _keymap_,
unsigned int  _keyno_ 
)
inline

◆ mi_lock_database()

int mi_lock_database ( MI_INFO file,
int  lock_type 
)

◆ mi_log()

int mi_log ( int  activate_log)

◆ mi_open_share()

MI_INFO * mi_open_share ( const char *  name,
MYISAM_SHARE old_share,
int  mode,
uint  wait_if_locked 
)

◆ mi_panic()

int mi_panic ( enum ha_panic_function  function)

◆ mi_position()

my_off_t mi_position ( MI_INFO file)

◆ mi_preload()

int mi_preload ( MI_INFO info,
ulonglong  key_map,
bool  ignore_leaves 
)

◆ mi_records_in_range()

ha_rows mi_records_in_range ( MI_INFO info,
int  inx,
key_range min_key,
key_range max_key 
)

◆ mi_rename()

int mi_rename ( const char *  from,
const char *  to 
)

◆ mi_repair()

int mi_repair ( MI_CHECK param,
MI_INFO info,
char *  name,
int  rep_quick,
bool  no_copy_stat 
)

◆ mi_repair_by_sort()

int mi_repair_by_sort ( MI_CHECK param,
MI_INFO info,
const char *  name,
int  rep_quick,
bool  no_copy_stat 
)

◆ mi_reset()

int mi_reset ( MI_INFO file)

◆ mi_rfirst()

int mi_rfirst ( MI_INFO file,
uchar buf,
int  inx 
)

◆ mi_rkey()

int mi_rkey ( MI_INFO info,
uchar buf,
int  inx,
const uchar key,
key_part_map  keypart_map,
enum ha_rkey_function  search_flag 
)

◆ mi_rlast()

int mi_rlast ( MI_INFO file,
uchar buf,
int  inx 
)

◆ mi_rnext()

int mi_rnext ( MI_INFO file,
uchar buf,
int  inx 
)

◆ mi_rnext_same()

int mi_rnext_same ( MI_INFO info,
uchar buf 
)

◆ mi_rprev()

int mi_rprev ( MI_INFO file,
uchar buf,
int  inx 
)

◆ mi_rrnd()

int mi_rrnd ( MI_INFO file,
uchar buf,
my_off_t  pos 
)

◆ mi_rsame()

int mi_rsame ( MI_INFO file,
uchar record,
int  inx 
)

◆ mi_rsame_with_pos()

int mi_rsame_with_pos ( MI_INFO file,
uchar record,
int  inx,
my_off_t  pos 
)

◆ mi_scan()

int mi_scan ( MI_INFO file,
uchar buf 
)

◆ mi_scan_init()

int mi_scan_init ( MI_INFO file)

◆ mi_sort_index()

int mi_sort_index ( MI_CHECK param,
MI_INFO info,
char *  name,
bool  no_copy_stat 
)

◆ mi_status()

int mi_status ( MI_INFO info,
MI_ISAMINFO x,
uint  flag 
)

◆ mi_test_if_sort_rep()

bool mi_test_if_sort_rep ( MI_INFO info,
ha_rows  rows,
ulonglong  key_map,
bool  force 
)

◆ mi_update()

int mi_update ( MI_INFO file,
const uchar old,
uchar new_record 
)

◆ mi_write()

int mi_write ( MI_INFO file,
uchar buff 
)

◆ movepoint()

int movepoint ( MI_INFO info,
uchar record,
my_off_t  oldpos,
my_off_t  newpos,
uint  prot_key 
)

◆ myisamchk_init()

void myisamchk_init ( MI_CHECK param)

◆ recreate_table()

int recreate_table ( MI_CHECK param,
MI_INFO **  org_info,
char *  filename 
)

◆ test_if_almost_full()

int test_if_almost_full ( MI_INFO info)

◆ update_auto_increment_key()

void update_auto_increment_key ( MI_CHECK param,
MI_INFO info,
bool  repair 
)

◆ update_key_parts()

void update_key_parts ( MI_KEYDEF keyinfo,
ulong *  rec_per_key_part,
ulonglong unique,
ulonglong notnull,
ulonglong  records 
)

◆ update_state_info()

int update_state_info ( MI_CHECK param,
MI_INFO info,
uint  update 
)

◆ write_data_suffix()

int write_data_suffix ( SORT_INFO sort_info,
bool  fix_datafile 
)

Variable Documentation

◆ main_thread_keycache_var

st_keycache_thread_var main_thread_keycache_var
extern

◆ myisam_block_size

ulong myisam_block_size
extern

◆ myisam_concurrent_insert

ulong myisam_concurrent_insert
extern

◆ myisam_data_pointer_size

ulong myisam_data_pointer_size
extern

◆ myisam_delay_key_write

bool myisam_delay_key_write

◆ myisam_flush

bool myisam_flush
extern

◆ myisam_log_filename

const char* myisam_log_filename
extern

◆ myisam_max_temp_length

my_off_t myisam_max_temp_length
extern

◆ myisam_mmap_size

ulonglong myisam_mmap_size
extern

◆ myisam_mmap_used

ulonglong myisam_mmap_used

◆ myisam_single_user

bool myisam_single_user

◆ myisam_test_invalid_symlink

int(* myisam_test_invalid_symlink) (const char *filename) ( const char *  filename)
extern

◆ THR_LOCK_myisam_mmap

mysql_mutex_t THR_LOCK_myisam_mmap
extern