ha_innodb.h 8.61 KB
Newer Older
1
/* Copyright (C) 2000 MySQL AB && Innobase Oy
2 3 4 5 6

   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; either version 2 of the License, or
   (at your option) any later version.
7

8 9 10 11
   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.
12

13 14 15 16
   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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

17 18 19 20 21 22 23
/*
  This file is based on ha_berkeley.h of MySQL distribution

  This file defines the Innodb handler: the interface between MySQL and
  Innodb
*/

24
#ifdef USE_PRAGMA_INTERFACE
25 26 27 28 29 30 31 32 33 34
#pragma interface			/* gcc class implementation */
#endif

typedef struct st_innobase_share {
  THR_LOCK lock;
  pthread_mutex_t mutex;
  char *table_name;
  uint table_name_length,use_count;
} INNOBASE_SHARE;

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
35

36
/* The class defining a handle to an Innodb table */
37 38 39
class ha_innobase: public handler
{
	void*	innobase_prebuilt;	/* (row_prebuilt_t*) prebuilt
40
					struct in Innodb, used to save
41 42 43 44
					CPU */
	THD*		user_thd;	/* the thread handle of the user
					currently using the handle; this is
					set in external_lock function */
45 46
	ulong           last_query_id;  /* the latest query id where the
					handle was used */
47 48 49 50 51 52 53
  	THR_LOCK_DATA 	lock;
	INNOBASE_SHARE  *share;

  	gptr 		alloc_ptr;
  	byte*		upd_buff;	/* buffer used in updates */
  	byte*		key_val_buff;	/* buffer used in converting
  					search key values from MySQL format
54
  					to Innodb format */
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
55 56 57
	ulong		upd_and_key_val_buff_len;
					/* the length of each of the previous
					two buffers */
58
  	ulong 		int_table_flags;
59
  	uint 		primary_key;
monty@donna.mysql.fi's avatar
monty@donna.mysql.fi committed
60
	uint		last_dup_key;
61 62 63
	ulong		start_of_scan;	/* this is set to 1 when we are
					starting a table scan but have not
					yet fetched any row, else 0 */
64
	uint		last_match_mode;/* match mode of the latest search:
65 66
					ROW_SEL_EXACT, ROW_SEL_EXACT_PREFIX,
					or undefined */
67
	uint		num_write_row;	/* number of write_row() calls */
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
68
	longlong	auto_inc_counter_for_this_stat;
serg@serg.mylan's avatar
serg@serg.mylan committed
69
	ulong max_supported_row_length(const byte *buf);
70

71 72
	uint store_key_val_for_row(uint keynr, char* buff, uint buff_len,
					       const byte* record);
73 74 75
	int update_thd(THD* thd);
	int change_active_index(uint keynr);
	int general_fetch(byte* buf, uint direction, uint match_mode);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
76
	int innobase_read_and_init_auto_inc(longlong* ret);
77 78 79 80

	/* Init values for the class: */
 public:
  	ha_innobase(TABLE *table): handler(table),
81
	  int_table_flags(HA_REC_NOT_IN_SEQ |
serg@serg.mylan's avatar
serg@serg.mylan committed
82 83
			  HA_NULL_IN_KEY | HA_FAST_KEY_READ |
			  HA_CAN_INDEX_BLOBS |
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
84
			  HA_CAN_SQL_HANDLER |
85
			  HA_NOT_EXACT_COUNT |
86
			  HA_PRIMARY_KEY_IN_READ_INDEX |
87
			  HA_TABLE_SCAN_ON_INDEX),
88
	  last_dup_key((uint) -1),
89 90
	  start_of_scan(0),
	  num_write_row(0)
91 92 93 94
  	{
  	}
  	~ha_innobase() {}

95
  	const char* table_type() const { return("InnoDB");}
96
	const char *index_type(uint key_number) { return "BTREE"; }
97
  	const char** bas_ext() const;
98
 	ulong table_flags() const { return int_table_flags; }
99
	ulong index_flags(uint idx, uint part, bool all_parts) const
100
	{
serg@serg.mylan's avatar
serg@serg.mylan committed
101 102
	  return (HA_READ_NEXT | HA_READ_PREV | HA_READ_ORDER | HA_READ_RANGE |
                  HA_KEYREAD_ONLY);
103
	}
serg@serg.mylan's avatar
serg@serg.mylan committed
104
  	uint max_supported_keys()          const { return MAX_KEY; }
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
105 106 107 108
				/* An InnoDB page must store >= 2 keys;
				a secondary key record must also contain the
				primary key value:
				max key length is therefore set to slightly
heikki@donna.mysql.fi's avatar
heikki@donna.mysql.fi committed
109 110 111
				less than 1 / 4 of page size which is 16 kB;
				but currently MySQL does not work with keys
				whose size is > MAX_KEY_LENGTH */
serg@serg.mylan's avatar
serg@serg.mylan committed
112 113
  	uint max_supported_key_length() const { return 3500; }
  	uint max_supported_key_part_length() const { return 3500; }
serg@serg.mylan's avatar
serg@serg.mylan committed
114
	const key_map *keys_to_use_for_scanning() { return &key_map_full; }
115 116
  	bool has_transactions()  { return 1;}

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
117
  	int open(const char *name, int mode, uint test_if_locked);
118 119
  	int close(void);
  	double scan_time();
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
120
	double read_time(uint index, uint ranges, ha_rows rows);
121 122 123 124 125 126 127 128

  	int write_row(byte * buf);
  	int update_row(const byte * old_data, byte * new_data);
  	int delete_row(const byte * buf);

  	int index_init(uint index);
  	int index_end();
  	int index_read(byte * buf, const byte * key,
129
		       uint key_len, enum ha_rkey_function find_flag);
130
  	int index_read_idx(byte * buf, uint index, const byte * key,
131 132
			   uint key_len, enum ha_rkey_function find_flag);
	int index_read_last(byte * buf, const byte * key, uint key_len);
133 134 135 136 137 138
  	int index_next(byte * buf);
  	int index_next_same(byte * buf, const byte *key, uint keylen);
  	int index_prev(byte * buf);
  	int index_first(byte * buf);
  	int index_last(byte * buf);

139
  	int rnd_init(bool scan);
140 141 142 143 144 145
  	int rnd_end();
  	int rnd_next(byte *buf);
  	int rnd_pos(byte * buf, byte *pos);

  	void position(const byte *record);
  	void info(uint);
146
        int analyze(THD* thd,HA_CHECK_OPT* check_opt);
147
        int optimize(THD* thd,HA_CHECK_OPT* check_opt);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
148
	int discard_or_import_tablespace(my_bool discard);
149 150
  	int extra(enum ha_extra_function operation);
  	int external_lock(THD *thd, int lock_type);
151 152
	int start_stmt(THD *thd);

153
  	void position(byte *record);
154
  	ha_rows records_in_range(uint inx, key_range *min_key, key_range *max_key);
sergefp@mysql.com's avatar
sergefp@mysql.com committed
155
	ha_rows estimate_rows_upper_bound();
156 157 158 159 160

  	int create(const char *name, register TABLE *form,
					HA_CREATE_INFO *create_info);
  	int delete_table(const char *name);
	int rename_table(const char* from, const char* to);
161
	int check(THD* thd, HA_CHECK_OPT* check_opt);
162
        char* update_table_comment(const char* comment);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
163
	char* get_foreign_key_create_info();
164
	bool can_switch_engines();
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
165
  	uint referenced_by_foreign_key();
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
166
	void free_foreign_key_create_info(char* str);	
167 168
  	THR_LOCK_DATA **store_lock(THD *thd, THR_LOCK_DATA **to,
			     		enum thr_lock_type lock_type);
169
	void init_table_handle_for_HANDLER(); 
170
	longlong get_auto_increment();
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
171
        uint8 table_cache_type() { return HA_CACHE_TBL_ASKTRANSACT; }
guilhem@mysql.com's avatar
guilhem@mysql.com committed
172 173 174

        static char      *get_mysql_bin_log_name();
        static ulonglong get_mysql_bin_log_pos();
175 176 177
};

extern uint innobase_init_flags, innobase_lock_type;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
178
extern uint innobase_flush_log_at_trx_commit;
179 180 181
extern ulong innobase_cache_size;
extern char *innobase_home, *innobase_tmpdir, *innobase_logdir;
extern long innobase_lock_scan_time;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
182
extern long innobase_mirrored_log_groups, innobase_log_files_in_group;
183
extern long innobase_log_file_size, innobase_log_buffer_size;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
184 185
extern long innobase_buffer_pool_size, innobase_additional_mem_pool_size;
extern long innobase_buffer_pool_awe_mem_mb;
186
extern long innobase_file_io_threads, innobase_lock_wait_timeout;
monty@donna.mysql.fi's avatar
Merge  
monty@donna.mysql.fi committed
187
extern long innobase_force_recovery, innobase_thread_concurrency;
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
188
extern long innobase_open_files;
189 190
extern char *innobase_data_home_dir, *innobase_data_file_path;
extern char *innobase_log_group_home_dir, *innobase_log_arch_dir;
191
extern char *innobase_unix_file_flush_method;
192
/* The following variables have to be my_bool for SHOW VARIABLES to work */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
193
extern my_bool innobase_log_archive,
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
194
               innobase_use_native_aio, innobase_fast_shutdown,
serg@serg.mylan's avatar
serg@serg.mylan committed
195
	       innobase_file_per_table, innobase_locks_unsafe_for_binlog,
196
               innobase_create_status_file;
197 198 199 200 201
extern my_bool innobase_very_fast_shutdown; /* set this to 1 just before
					    calling innobase_end() if you want
					    InnoDB to shut down without
					    flushing the buffer pool: this
					    is equivalent to a 'crash' */
202 203
extern "C" {
extern ulong srv_max_buf_pool_modified_pct;
204
extern ulong srv_max_purge_lag;
205
extern ulong srv_auto_extend_increment;
206
}
207 208 209 210 211 212

extern TYPELIB innobase_lock_typelib;

bool innobase_init(void);
bool innobase_end(void);
bool innobase_flush_logs(void);
213
uint innobase_get_free_space(void);
214

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
215
int innobase_commit(THD *thd, void* trx_handle);
216 217 218 219 220
int innobase_report_binlog_offset_and_commit(
        THD*    thd,
	void*	trx_handle,
        char*   log_file_name,
        my_off_t end_offset);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
221 222
int innobase_commit_complete(
        void*   trx_handle);
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
223
int innobase_rollback(THD *thd, void* trx_handle);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
224 225 226 227 228 229 230 231
int innobase_rollback_to_savepoint(
	THD*	thd,
	char*	savepoint_name,
	my_off_t* binlog_cache_pos);
int innobase_savepoint(
	THD*	thd,
	char*	savepoint_name,
	my_off_t binlog_cache_pos);
232
int innobase_close_connection(THD *thd);
233
int innobase_drop_database(char *path);
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
234
int innodb_show_status(THD* thd);
235

heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
236 237
my_bool innobase_query_caching_of_table_permitted(THD* thd, char* full_name,
						uint full_name_len);
238
void innobase_release_temporary_latches(void* innobase_tid);
heikki@hundin.mysql.fi's avatar
 
heikki@hundin.mysql.fi committed
239 240

void innobase_store_binlog_offset_and_flush_log(char *binlog_name,longlong offset);
241

242
int innobase_start_trx_and_assign_read_view(THD* thd);