Chapter聽16.聽Writing a Custom Storage Engine - MySQL 5.1参考手册中文版

鍦ㄦ墽琛屼换浣曡�诲彇鎴栧啓鎿嶄綔涔嬪墠锛岃皟鐢�store_lock()鍑芥暟銆�

灏嗛攣瀹氭坊鍔犲埌琛ㄩ攣瀹氬�勭悊绋嬪簭涔嬪墠锛堣�峰弬瑙�thr_lock.c锛夛紝mysqld灏嗙敤璇锋眰鐨勯攣璋冪敤瀛樺偍閿佸畾銆傜洰鍓嶏紝瀛樺偍閿佸畾鑳藉皢鍐欓攣瀹氭洿鏀逛负璇婚攣瀹氾紙鎴栧叾浠栭攣瀹氾級锛屽拷鐣ラ攣瀹氾紙濡傛灉涓嶆墦绠椾娇鐢�MySQL閿佸畾鐨勮瘽锛夛紝鎴栦负寰堝�氳〃娣诲姞閿佸畾锛堝氨鍍忎娇鐢�MERGE澶勭悊绋嬪簭鏃朵綔鐨勯偅鏍凤級銆�

渚嬪�傦紝Berkeley DB鑳藉皢鎵�鏈夌殑WRITE閿佸畾鏇存敼涓�TL_WRITE_ALLOW_WRITE锛堣〃绀烘垜浠�姝ｅ湪鎵ц��WRITES锛屼絾鎴戜滑浠嶅厑璁稿叾浠栦汉鍛樿繘琛屾搷浣滐級銆�

閲婃斁閿佸畾鏃讹紝涔熷皢璋冪敤store_lock()锛屽湪杩欑�嶆儏鍐典笅锛岄�氬父涓嶉渶鍋氫换浣曚簨銆�

鍦ㄦ煇浜涚壒娈婃儏鍐典笅锛�MySQL鍙�鑳戒細鍙戦�佸��TL_IGNORE鐨勮�锋眰銆傝繖鎰忓懗鐫�鎴戜滑姝ｅ湪璇锋眰涓庝笂娆＄浉鍚岀殑閿佸畾锛岃繖涔熷簲琚�蹇界暐锛堝綋鎴戜滑鎵撳紑浜嗚〃鐨勬煇涓�閮ㄥ垎鏃讹紝濡傛灉鍏朵粬浜烘墽琛屼簡琛ㄥ埛鏂版搷浣滐紝灏变細鍑虹幇璇ユ儏鍐碉紝姝ゆ椂锛�mysqld灏嗗叧闂�骞跺啀娆℃墦寮�琛�锛岀劧鍚庤幏鍙栦笌涓婃�＄浉鍚岀殑閿佸畾锛夈�傛垜浠�鎵撶畻鍦ㄥ皢鏉ュ垹闄よ�ョ壒鎬с��

鍙�鑳界殑閿佸畾绫诲瀷瀹氫箟浜�includes/thr_lock.h涓�锛屽苟鍒楀湪涓嬮潰锛�

enum thr_lock_type

{

         TL_IGNORE=-1,

                    TL_UNLOCK,                             /* UNLOCK ANY LOCK */

                    TL_READ,                                 /* Read lock */

                    TL_READ_WITH_SHARED_LOCKS,  

         TL_READ_HIGH_PRIORITY,      /* High prior. than TL_WRITE. Allow concurrent insert */

         TL_READ_NO_INSERT,                /* READ, Don't allow concurrent insert */

         TL_WRITE_ALLOW_WRITE,                   /*   Write lock, but allow other threads to read / write. */

         TL_WRITE_ALLOW_READ,        /*       Write lock, but allow other threads to read / write. */

         TL_WRITE_CONCURRENT_INSERT, /* WRITE lock used by concurrent insert. */

         TL_WRITE_DELAYED,                 /* Write used by INSERT DELAYED.  Allows READ locks */

         TL_WRITE_LOW_PRIORITY,            /* WRITE lock that has lower priority than TL_READ */

         TL_WRITE,                         /* Normal WRITE lock */

         TL_WRITE_ONLY               /* Abort new lock request with an error */

};  

瀹為檯鐨勯攣瀹氬�勭悊鍥犻攣瀹氬疄鏂界殑涓嶅悓鑰屼笉鍚岋紝浣犲彲浠ラ�夋嫨鏌愪簺璇锋眰鐨勯攣瀹氱被鍨嬫垨涓嶉�夋嫨浠讳綍閿佸畾绫诲瀷锛屽苟鏍规嵁鎯呭喌鎭板綋鍦颁唬鍏ヤ綘鑷�宸辩殑鏂规硶銆備笅闈㈢粰鍑轰簡1涓�CSV瀛樺偍寮曟搸瀹炴柦绀轰緥锛�

THR_LOCK_DATA **ha_tina::store_lock(THD *thd,

                                     THR_LOCK_DATA **to,

                                     enum thr_lock_type lock_type)

 {

   if (lock_type != TL_IGNORE && lock.type == TL_UNLOCK)

     lock.type=lock_type;

   *to++= &lock;

   return to;

 }  

external_lock()鍑芥暟鏄�鍦ㄤ簨鍔″紑濮嬫椂璋冪敤鐨勶紝鎴栧彂鍑�LOCK TABLES璇�鍙ユ椂璋冪敤鐨勶紝鐢ㄤ簬浜嬪姟鎬у瓨鍌ㄥ紩鎿庛��

鍦�sql/ha_innodb.cc鍜�sql/ha_berkeley.cc鏂囦欢涓�锛屽彲鎵惧埌浣跨敤external_lock()鐨勭ず渚嬶紝浣嗗ぇ澶氭暟瀛樺偍寮曟搸绠�鍗曞湴杩斿洖0锛�灏卞儚EXAMPLE瀛樺偍寮曟搸閭ｆ牱锛�

int ha_example::external_lock(THD *thd, int lock_type)

 {

   DBUG_ENTER("ha_example::external_lock");

   DBUG_RETURN(0);

 }

鍦ㄤ换浣曡〃鎵�鎻忎箣鍓嶈皟鐢ㄧ殑鍑芥暟鏄�rnd_init()鍑芥暟銆傚嚱鏁�rnd_init()鐢ㄤ簬涓鸿〃鎵�鎻忎綔鍑嗗�囷紝灏嗚�℃暟鍣ㄥ拰鎸囬拡澶嶄綅涓鸿〃鐨勫紑濮嬬姸鎬併��

涓嬭堪绀轰緥鏉ヨ嚜CSV瀛樺偍寮曟搸锛�

  int ha_tina::rnd_init(bool scan)
    {
      DBUG_ENTER("ha_tina::rnd_init");
 
      current_position= next_position= 0;
      records= 0;
      chain_ptr= chain;
 
      DBUG_RETURN(0);
    }  

ulonglong data_file_length;           /* Length off data file */

ulonglong max_data_file_length;       /* Length off data file */

ulonglong index_file_length;

ulonglong max_index_file_length;

ulonglong delete_length;              /* Free bytes */

ulonglong auto_increment_value;

ha_rows records;                      /* Records in table */

ha_rows deleted;                      /* Deleted records */

ulong raid_chunksize;

ulong mean_rec_length;         /* physical reclength */

time_t create_time;                   /* When table was created */

time_t check_time;

time_t update_time;  

鎵ц�屾煇浜涙搷浣滀箣鍓嶏紝搴旇皟鐢�extra()鍑芥暟锛屼互渚夸负瀛樺偍寮曟搸灏卞�備綍鎵ц�岀壒瀹氭搷浣滀簣浠ユ彁绀恒��

棰濆�栬皟鐢ㄤ腑鐨勬彁绀哄疄鏂戒笉鏄�寮哄埗鎬х殑锛屽ぇ澶氭暟瀛樺偍寮曟搸鍧囪繑鍥�0锛�

int ha_tina::extra(enum ha_extra_function operation)
 {
   DBUG_ENTER("ha_tina::extra");
   DBUG_RETURN(0);
 }

瀹屾垚琛ㄧ殑鍒濆�嬪寲鎿嶄綔鍚庯紝MySQL鏈嶅姟鍣ㄥ皢璋冪敤澶勭悊绋嬪簭鐨�rnd_next()鍑芥暟锛屾瘡涓や釜鎵�鎻忚�岃皟鐢�1娆★紝鐩磋嚦婊¤冻浜嗘湇鍔″櫒鐨勬悳绱㈡潯浠舵垨鍒拌揪鏂囦欢缁撳熬涓烘��锛屽湪鍚庝竴绉嶆儏鍐典笅锛屽�勭悊绋嬪簭灏嗚繑鍥�HA_ERR_END_OF_FILE銆�

rnd_next()鍑芥暟鏈変竴涓�鍚嶄负*buf鐨勫崟瀛楄妭鏁扮粍鍙傛暟銆傚�逛簬*buf鍙傛暟锛屽繀椤绘寜鍐呴儴MySQL鏍煎紡鐢ㄨ〃琛岀殑鍐呭�瑰～鍏呭畠銆�

鏈嶅姟鍣ㄩ噰鐢ㄤ簡涓夌�嶆暟鎹�鏍煎紡锛氬浐瀹氶暱搴﹁�岋紝鍙�鍙橀暱搴﹁�岋紝浠ュ強鍏锋湁BLOB鎸囬拡鐨勫彲鍙橀暱搴﹁�屻�傚�逛簬姣忕�嶆牸寮忥紝鍚勫垪灏嗘寜鐓у畠浠�鐢�CREATE TABLE璇�鍙ュ畾涔夌殑椤哄簭鏄剧ず锛堣〃瀹氫箟淇濆瓨鍦�.frm鏂囦欢涓�锛屼紭鍖栫▼搴忓拰澶勭悊绋嬪簭鍧囪兘浠庣浉鍚岀殑婧愶紝鍗�TABLE缁撴瀯锛岃�块棶琛ㄧ殑鍏冩暟鎹�锛夈��

姣忕�嶆牸寮忎互姣忓垪1姣旂壒鐨�"NULL bitmap"寮�濮嬨�傚�逛簬鍚�6涓�鍒楃殑琛�锛屽叾bitmap涓�1瀛楄妭锛屽�逛簬鍚�9锝�16鍒楃殑琛�锛屽叾bitmap涓�2瀛楄妭锛屼緷姝ょ被鎺ㄣ�傝�佹兂鎸囨槑鐗瑰畾鐨勫�兼槸NULL锛屽簲灏嗚�ュ垪NULL浣嶈�剧疆涓�1銆�

褰�NULL bitmap閫愪釜杩涘叆鍒楀悗锛屾瘡鍒楀皢鍏锋湁MySQL鎵嬪唽鐨勨��MySQL鏁版嵁绫诲瀷鈥濅竴鑺備腑鎸囧畾鐨勫ぇ灏忋�傚湪鏈嶅姟鍣ㄤ腑锛屽垪鐨勬暟鎹�绫诲瀷瀹氫箟鍦�sql/field.cc鏂囦欢涓�銆傚�逛簬鍥哄畾闀垮害琛屾牸寮忥紝鍒楀皢绠�鍗曞湴閫愪釜鏀剧疆銆傚�逛簬鍙�鍙橀暱搴﹁�岋紝VARCHAR鍒楀皢琚�缂栫爜涓�1瀛楄妭闀匡紝鍚庤窡瀛楃�︿覆銆傚�逛簬鍏锋湁BLOB鍒楃殑鍙�鍙橀暱搴﹁�岋紝姣忎釜blob鐢变袱閮ㄥ垎琛ㄧず锛氶�栧厛鏄�琛ㄧずBLOB瀹為檯澶у皬鐨勬暣鏁帮紝鐒跺悗鏄�鎸囧悜鍐呭瓨涓�BLOB鐨勬寚閽堛��

鍦ㄤ换浣曡〃澶勭悊绋嬪簭涓�浠�rnd_next()寮�濮嬶紝鍙�鎵惧埌琛岃浆鎹�锛堟垨鈥滃寘瑁呪�濓級鐨勭ず渚嬨�備緥濡傦紝鍦�ha_tina.cc涓�锛�find_current_row()鍐呯殑浠ｇ爜缁欏嚭浜嗕娇鐢�TABLE缁撴瀯锛堢敱琛ㄦ寚鍚戠殑锛夊拰瀛楃�︿覆瀵硅薄锛堝懡鍚嶇紦鍐诧級鍖呰�呭瓧绗︽暟鎹�锛堟潵鑷�CSV鏂囦欢锛夌殑鏂规硶銆傚皢琛屽啓鍥炵�佺洏闇�瑕佸弽鍚戣浆鎹�锛屼粠鍐呴儴鏍煎紡瑙ｅ寘銆�

涓嬭堪绀轰緥鏉ヨ嚜CSV瀛樺偍寮曟搸锛�

int ha_tina::rnd_next(byte *buf)

 {

   DBUG_ENTER("ha_tina::rnd_next");

   statistic_increment(table->in_use->status_var.ha_read_rnd_next_count, &LOCK_status);

   current_position= next_position;

   if (!share->mapped_file)

     DBUG_RETURN(HA_ERR_END_OF_FILE);

   if (HA_ERR_END_OF_FILE == find_current_row(buf) )

     DBUG_RETURN(HA_ERR_END_OF_FILE);

   records++;

   DBUG_RETURN(0);

 }  

瀵逛簬浠庡唴閮ㄨ�屾牸寮忓埌CSV琛屾牸寮忕殑杞�鎹�锛屽畠鏄�鍦�find_current_row()鍑芥暟涓�鎵ц�岀殑銆�

int ha_tina::find_current_row(byte *buf)

 {

   byte *mapped_ptr= (byte *)share->mapped_file + current_position;

   byte *end_ptr;

   DBUG_ENTER("ha_tina::find_current_row");

   /* EOF should be counted as new line */

   if ((end_ptr=  find_eoln(share->mapped_file, current_position,

                            share->file_stat.st_size)) == 0)

     DBUG_RETURN(HA_ERR_END_OF_FILE);

   for (Field **field=table->field ; *field ; field++)

   {

     buffer.length(0);

     mapped_ptr++; // Increment past the first quote

     for(;mapped_ptr != end_ptr; mapped_ptr++)

     {

       // Need to convert line feeds!

       if (*mapped_ptr == '"' &&

           (((mapped_ptr[1] == ',') && (mapped_ptr[2] == '"')) ||

            (mapped_ptr == end_ptr -1 )))

       {

         mapped_ptr += 2; // Move past the , and the "

         break;

       }

       if (*mapped_ptr == '\\' && mapped_ptr != (end_ptr - 1))

       {

         mapped_ptr++;

         if (*mapped_ptr == 'r')

           buffer.append('\r');

         else if (*mapped_ptr == 'n' )

           buffer.append('\n');

         else if ((*mapped_ptr == '\\') || (*mapped_ptr == '"'))

           buffer.append(*mapped_ptr);

         else  /* This could only happed with an externally created file */

         {

           buffer.append('\\');

           buffer.append(*mapped_ptr);

         }

       }

       else

         buffer.append(*mapped_ptr);

     }

     (*field)->store(buffer.ptr(), buffer.length(), system_charset_info);

   }

   next_position= (end_ptr - share->mapped_file)+1;

   /* Maybe use \N for null? */

   memset(buf, 0, table->s->null_bytes); /* We do not implement nulls! */

   DBUG_RETURN(0);

 }  

鐩�鐨�

瀹氫箟瀛樺偍寮曟搸鎵�浣跨敤鐨勬枃浠舵墿灞曘��

姒傝��

鎻忚堪

杩欐槸bas_ext鏂规硶銆傝皟鐢ㄥ畠锛屽彲涓�MySQL鏈嶅姟鍣ㄦ彁渚涘瓨鍌ㄥ紩鎿庢墍浣跨敤鐨勬枃浠舵墿灞曞垪琛ㄣ�傝�ュ垪琛ㄥ皢杩斿洖浠�Null缁堢粨鐨勫瓧绗︿覆鏁扮粍銆�

閫氳繃鎻愪緵鎵╁睍鍒楄〃锛屽湪寰堝�氭儏鍐典笅锛屽瓨鍌ㄥ紩鎿庤兘鐪佺暐delete_table()鍑芥暟锛岃繖鏄�鍥犱负MySQL鏈嶅姟鍣ㄥ皢鍏抽棴鎵�鏈夊�硅〃鐨勫紩鐢�锛屽苟浣跨敤鎸囧畾鐨勬墿灞曞垹闄ゆ墍鏈夋枃浠躲��

鍙傛暟

璇ュ嚱鏁版棤鍙傛暟銆�

杩斿洖鍊�

鐢ㄦ硶

static const char *ha_tina_exts[] =
 {
   ".CSV",
   NullS
 };
        
const char **ha_tina::bas_ext() const
 {
   return ha_tina_exts;
 }  

榛樿�ゅ疄鏂�

static const char *ha_example_exts[] = {
   NullS
 };
 
const char **ha_example::bas_ext() const
 {
   return ha_example_exts;
 }

鐩�鐨�

鍏抽棴鎵撳紑鐨勮〃銆�

姒傝��

鎻忚堪

杩欐槸close鏂规硶銆�

鍏抽棴琛ㄣ�傝繖鏄�閲婃斁浠讳綍宸插垎閰嶈祫婧愮殑鎭板綋鏃舵満銆�

浠�sql_base.cc銆�sql_select.cc鍜�table.cc璋冪敤瀹冦�傚湪sql_select.cc涓�锛屽畠浠呯敤浜庡叧闂�涓存椂琛�锛屾垨鍦ㄥ皢涓存椂琛ㄨ浆鎹�涓�myisam琛ㄧ殑杩囩▼涓�鍏抽棴琛ㄣ�傚叧浜�sql_base.cc锛岃�锋煡鐪�close_data_tables()銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

鍙栬嚜CSV寮曟搸鐨勭ず渚嬶細

int ha_example::close(void)
{
  DBUG_ENTER("ha_example::close");
  DBUG_RETURN(free_share(share));
}

鐩�鐨�

鍒涘缓鏂拌〃銆�

姒傝��

鎻忚堪

杩欐槸create鏂规硶銆�

璋冪敤create()浠ュ垱寤鸿〃銆�鍙橀噺鍚嶇О涓鸿〃鐨勫悕绉般�傝皟鐢�create()鏃讹紝涓嶉渶瑕佹墦寮�琛ㄣ�傛�ゅ�栵紝鐢变簬宸插垱寤轰簡.frm鏂囦欢锛屼笉鎺ㄨ崘璋冩暣create_info銆�

鐢�ha_create_table()浠�handle.cc涓�璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

CSV鎼滅储寮曟搸绀轰緥锛�

int ha_tina::create(const char *name, TABLE *table_arg,
                    HA_CREATE_INFO *create_info)
{
  char name_buff[FN_REFLEN];
  File create_file;
  DBUG_ENTER("ha_tina::create");

  if ((create_file= my_create(fn_format(name_buff, name, "", ".CSV",
                                        MY_REPLACE_EXT|MY_UNPACK_FILENAME),0,
                              O_RDWR | O_TRUNC,MYF(MY_WME))) < 0)
    DBUG_RETURN(-1);

  my_close(create_file,MYF(0));

  DBUG_RETURN(0);
}          

鐩�鐨�

鍒犻櫎琛屻��

姒傝��

鎻忚堪

杩欐槸delete_row鏂规硶銆�

Buf鍖呭惈鍒犻櫎琛岀殑鍓�鏈�銆傝皟鐢ㄤ簡褰撳墠琛屽悗锛屾湇鍔″櫒灏嗙珛鍒昏皟鐢ㄥ畠锛堥�氳繃鍓嶄竴涓�rnd_next()鎴栫储寮曡皟鐢�锛夈�傚�傛灉瀛樺湪鎸囧悜涓婁竴琛岀殑鎸囬拡锛屾垨鑳藉�熻�块棶 涓婚敭锛屽垹闄ゆ搷浣滃皢鏇翠负瀹规槗銆傝�疯�颁綇锛屾湇鍔″櫒涓嶄繚璇佽繛缁�鍒犻櫎銆傚彲浠ヤ娇鐢�ORDER BY瀛愬彞銆�

鍦�sql_acl.cc鍜�sql_udf.cc涓�璋冪敤锛屼互绠＄悊鍐呴儴鐨勮〃淇℃伅銆�鍦�sql_delete.cc銆�sql_insert.cc鍜�sql_select.cc涓�璋冪敤銆�鍦�sql_select涓�锛�瀹冪敤浜庡垹闄ゅ壇鏈�锛岃�屽湪鎻掑叆鎿嶄綔涓�锛屽畠鐢ㄤ簬REPLACE璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

榛樿�ゅ疄鏂�

{ return  HA_ERR_WRONG_COMMAND; }

鐩�鐨�

鐢ㄦ潵鑷�bas_ext()鐨勬墿灞曞垹闄ゆ墍鏈夋枃浠躲��

姒傝��

鎻忚堪

杩欐槸delete_table鏂规硶銆�

鐢ㄤ簬鍒犻櫎琛ㄣ�傝皟鐢�delete_table()鏃讹紝鎵�鏈夊凡鎵撳紑鐨勫�硅�ヨ〃鐨勫紩鐢ㄥ潎灏嗚��鍏抽棴锛堝苟閲婃斁鍏ㄥ眬鍏变韩鐨勫紩鐢�锛夈�傚彉閲忓悕绉颁负琛ㄥ悕銆傛�ゆ椂锛岄渶瑕佸垹闄や换浣曞凡鍒涘缓鐨勬枃浠躲��

濡傛灉鏈�瀹炴柦瀹冿紝灏嗕粠handler.cc璋冪敤榛樿�ょ殑delete_table()锛屽苟鐢�bas_ext()杩斿洖鐨勬枃浠舵墿灞�鍒犻櫎鎵�鏈夋枃浠躲�傚亣瀹氬�勭悊绋嬪簭杩斿洖鐨勬墿灞曟瘮鏂囦欢瀹為檯浣跨敤鐨勫�氥��

鐢�delete_table鍜�ha_create_table()浠�handler.cc璋冪敤銆傚�傛灉涓哄瓨鍌ㄥ紩鎿庢寚瀹氫簡table_flag HA_DROP_BEFORE_CREATE锛屼粎鍦ㄥ垱寤鸿繃绋嬩腑浣跨敤銆�

鍙傛暟

杩斿洖鍊�

鐢ㄦ硶

鐩�鐨�

涓轰簨鍔″�勭悊琛ㄩ攣瀹氥��

姒傝��

鎻忚堪

杩欐槸external_lock鏂规硶銆�

鍦�lock.cc涓�鈥�鐢ㄤ簬mysql鐨勯攣瀹氬嚱鏁�鈥�涓�鑺傦紝缁欏嚭浜嗗叧浜庤�ヨ��棰樼殑棰濆�栨敞閲婏紝鍊肩殑涓�璇汇��

鍦ㄨ〃涓婂垱寤洪攣瀹氥�傚�傛灉瀹炴柦浜嗚兘澶勭悊浜嬪姟鐨勫瓨鍌ㄥ紩鎿庯紝璇锋煡鐪�ha_berkely.cc锛屼互浜嗚В濡備綍鎵ц�岃�ユ搷浣滅殑鏂规硶銆傚惁鍒欙紝搴旇�冭檻鍦ㄦ�よ皟鐢�flock()銆�

鐢�lock_external()鍜�unlock_external()浠�lock.cc涓�璋冪敤銆備篃鑳界敱copy_data_between_tables()浠�sql_table.cc涓�璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

榛樿�ゅ疄鏂�

{ return 0; }

鐩�鐨�

灏嗘彁绀轰粠鏈嶅姟鍣ㄤ紶閫掔粰瀛樺偍寮曟搸銆�

姒傝��

鎻忚堪

杩欐槸extra鏂规硶銆�

鏃犺�轰綍鏃讹紝褰撴湇鍔″櫒甯屾湜灏嗘彁绀哄彂閫佸埌瀛樺偍寮曟搸鏃讹紝灏嗚皟鐢�extra()銆�MyISAM寮曟搸瀹炵幇浜嗗ぇ澶氭暟鎻愮ず銆�ha_innodb.cc缁欏嚭浜嗘渶璇﹀敖鐨勬彁绀哄垪琛ㄣ��

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

榛樿�ゅ疄鏂�

榛樿�ゆ儏鍐典笅锛屽瓨鍌ㄥ紩鎿庡�惧悜浜庝笉瀹炴柦浠讳綍鎻愮ず銆�

{ return 0; }

鐩�鐨�

鎻愮ず瀛樺偍寮曟搸閫氭姤缁熻�′俊鎭�銆�

姒傝��

鎻忚堪

杩欐槸info鏂规硶銆�

::info()鐢ㄤ簬灏嗕俊鎭�杩斿洖缁欎紭鍖栫▼搴忋�傜洰鍓嶏紝璇ヨ〃澶勭悊绋嬪簭鏈�瀹炴柦瀹為檯闇�瑕佺殑澶у�氭暟瀛楁�点��SHOW涔熻兘鍒╃敤璇ユ暟鎹�銆傛敞鎰忥紝鎴栬�镐綘鎵撶畻鍦ㄤ綘鐨勪唬鐮佷腑鍖呭惈涓嬭堪鍐呭�光��if (records > 2) records = 2鈥濄�傚師鍥犲湪浜庯紝鏈嶅姟鍣ㄤ粎浼樺寲鍏锋湁涓�鏉¤�板綍鐨勬儏褰�銆傚�傛灉鍦ㄨ〃鎵�鎻忚繃绋嬩腑锛屼綘涓嶆竻妤氳�板綍鐨勬暟鐩�锛屾渶濂藉皢璁板綍鏁拌�句负2锛屼互渚胯兘澶熻繑鍥炲敖鍙�鑳藉�氱殑鎵�闇�璁板綍銆傞櫎浜嗚�板綍澶栵紝浣犳垨璁歌繕甯屾湜璁剧疆鍏朵粬鍙橀噺锛屽寘鎷�锛氬垹闄ょ殑璁板綍锛�data_file_length锛�index_file_length锛�delete_length锛�check_time銆傛洿澶氫俊鎭�锛岃�峰弬瑙�handler.h涓�鐨勫叕鍏卞彉閲忋��

鍦ㄤ笅杩版枃浠朵腑璋冪敤锛�filesort.cc ha_heap.cc item_sum.cc opt_sum.cc sql_delete.cc sql_delete.cc sql_derived.cc sql_select.cc sql_select.cc sql_select.cc sql_select.cc sql_select.cc sql_show.cc sql_show.cc sql_show.cc sql_show.cc sql_table.cc sql_union.cc sql_update.cc

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

璇ョず渚嬪彇鑷�CSV瀛樺偍寮曟搸锛�

void ha_tina::info(uint flag)
{
  DBUG_ENTER("ha_tina::info");
  /* This is a lie, but you don't want the optimizer to see zero or 1 */
  if (records < 2)
    records= 2;
  DBUG_VOID_RETURN;
}          

鐩�鐨�

鎵撳紑琛ㄣ��

姒傝��

鎻忚堪

杩欐槸open鏂规硶銆�

鐢ㄤ簬鎵撳紑琛ㄣ�傚悕绉版槸鏂囦欢鐨勫悕绉般�傚湪闇�瑕佹墦寮�琛ㄦ椂鎵撳紑瀹冦�備緥濡傦紝褰撹�锋眰鍦ㄨ〃涓婃墽琛岄�夋嫨鎿嶄綔鏃讹紙瀵逛簬姣忎竴璇锋眰锛岃〃鏈�鎵撳紑骞惰��鍏抽棴锛屽�瑰叾杩涜�岄珮閫熺紦鍐插�勭悊锛夈��

鐢�handler::ha_open()浠�handler.cc涓�璋冪敤銆傞�氳繃璋冪敤ha_open()锛岀劧鍚庤皟鐢ㄥ�勭悊绋嬪簭鐩稿叧鐨�open()锛屾湇鍔″櫒鎵撳紑鎵�鏈夎〃銆�

瀵逛簬澶勭悊绋嬪簭瀵硅薄锛屽皢浣滀负鍒濆�嬪寲鐨勪竴閮ㄥ垎骞跺湪灏嗗叾鐢ㄤ簬姝ｅ父鏌ヨ��涔嬪墠鎵撳紑瀹冿紙骞堕潪鎬诲湪鍏冩暟鎹�鍙樺寲涔嬪墠锛夈�傚�傛灉鎵撳紑浜嗗�硅薄锛屽湪鍒犻櫎涔嬪墠杩樺皢鍏抽棴瀹冦��

杩欐槸open鏂规硶銆傝皟鐢�open浠ユ墦寮�鏁版嵁搴撹〃銆�

绗�1涓�鍙傛暟鏄�瑕佹墦寮�鐨勮〃鐨勫悕绉般�傜��2涓�鍙傛暟鍐冲畾浜嗚�佹墦寮�鐨勬枃浠舵垨灏嗚�佹墽琛岀殑鎿嶄綔銆傝繖绫诲�煎畾涔変簬handler.h涓�锛屼负浜嗘柟渚胯捣瑙佸湪姝ゅ垪鍑猴細

        #define HA_OPEN_KEYFILE                 1

        #define HA_OPEN_RNDFILE                 2

        #define HA_GET_INDEX              4

        #define HA_GET_INFO                 8     /* do a ha_info() after open */

        #define HA_READ_ONLY              16    /* File opened as readonly */

        #define HA_TRY_READ_ONLY        32    /* Try readonly if can't open with read and write */

        #define HA_WAIT_IF_LOCKED       64      /* Wait if locked on open */

        #define HA_ABORT_IF_LOCKED    128       /* skip if locked on open.*/

        #define HA_BLOCK_LOCK             256   /* unlock when reading some records */

        #define HA_OPEN_TEMPORARY       512

鏈�鍚庣殑閫夐」瑙勫畾浜嗗湪鎵撳紑琛ㄤ箣鍓嶆槸鍚﹀簲妫�鏌ヨ〃涓婄殑閿佸畾銆�

鍏稿瀷鎯呭喌涓嬶紝瀛樺偍寮曟搸闇�瑕佸疄鐜版煇绉嶅舰寮忕殑鍏变韩璁块棶鎺у埗锛屼互闃叉�㈠�氱嚎绋嬬幆澧冧笅鐨勬枃浠舵崯鍧忋�傚叧浜庡�備綍瀹炵幇鏂囦欢閿佸畾鐨勭ず渚嬶紝璇峰弬瑙�sql/examples/ha_tina.cc鐨�get_share()鍜�free_share()鏂规硶銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

璇ョず渚嬪彇鑷�CSV瀛樺偍寮曟搸锛�

        int ha_tina::open(const char *name, int mode, uint test_if_locked)
        {
        DBUG_ENTER("ha_tina::open");
        
        if (!(share= get_share(name, table)))
        DBUG_RETURN(1);
        thr_lock_data_init(&share->lock,&lock,NULL);
        ref_length=sizeof(off_t);
        
        DBUG_RETURN(0);
        }          
      

鐩�鐨�

涓鸿〃鎵�鎻忓姛鑳藉垵濮嬪寲澶勭悊绋嬪簭銆�

姒傝��

鎻忚堪

杩欐槸rnd_init鏂规硶銆�

褰撶郴缁熷笇鏈涘瓨鍌ㄥ紩鎿庢墽琛岃〃鎵�鎻忔椂锛屽皢璋冪敤rnd_init()銆�

涓�index_init()涓嶅悓锛�rnd_init()鍙�浠ヨ皟鐢ㄤ袱娆★紝涓ゆ�¤皟鐢ㄤ箣闂翠笉浣跨敤rnd_end()锛堜粎褰�scan=1鏃舵墠鏈夋剰涔夛級銆傞殢鍚庯紝绗�2娆¤皟鐢ㄥ簲鍑嗗�囧ソ鏂扮殑琛ㄦ壂鎻忋�備緥濡傦紝濡傛灉rnd_init鍒嗛厤浜嗗厜鏍囷紝绗�2娆¤皟鐢ㄥ簲灏嗗厜鏍囧畾浣嶄簬琛ㄧ殑寮�濮嬮儴鍒嗭紝涓嶉渶瑕佹挙閿�鍒嗛厤骞跺啀娆″垎閰嶃��

浠庝笅杩版枃浠惰皟鐢�锛�filesort.cc, records.cc, sql_handler.cc, sql_select.cc, sql_table.cc, 鍜�sql_update.cc銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

璇ョず渚嬪彇鑷�CSV瀛樺偍寮曟搸锛�

int ha_tina::rnd_init(bool scan)
{
  DBUG_ENTER("ha_tina::rnd_init");

  current_position= next_position= 0;
  records= 0;
  chain_ptr= chain;
  DBUG_RETURN(0);
}          

鐩�鐨�

浠庤〃涓�璇诲彇涓嬩竴琛岋紝骞跺皢鍏惰繑鍥炴湇鍔″櫒銆�

姒傝��

鎻忚堪

杩欐槸rnd_next鏂规硶銆�

瀵逛簬琛ㄦ壂鎻忕殑姣忎竴琛岃皟鐢ㄥ畠銆傝�楀敖璁板綍鏃讹紝搴旇繑鍥�HA_ERR_END_OF_FILE銆傜敤琛屼俊鎭�濉�鍏�buff銆傝〃鐨勫瓧娈电粨鏋勬槸浠ユ湇鍔″櫒鑳界悊瑙ｇ殑鏂瑰紡灏嗘暟鎹�淇濆瓨鍒�buf涓�鐨勯敭銆�

浠庝笅杩版枃浠惰皟鐢�锛�filesort.cc, records.cc, sql_handler.cc, sql_select.cc, sql_table.cc, 鍜�sql_update.cc銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

涓嬭堪绀轰緥鍙栬嚜ARCHIVE瀛樺偍寮曟搸锛�

int ha_archive::rnd_next(byte *buf)
{
  int rc;
  DBUG_ENTER("ha_archive::rnd_next");

  if (share->crashed)
      DBUG_RETURN(HA_ERR_CRASHED_ON_USAGE);
 
  if (!scan_rows)
    DBUG_RETURN(HA_ERR_END_OF_FILE);
  scan_rows--;

  statistic_increment(table->in_use->status_var.ha_read_rnd_next_count,
		      &LOCK_status);
    current_position= gztell(archive);
  rc= get_row(archive, buf);
 
  if (rc != HA_ERR_END_OF_FILE)
    records++;

  DBUG_RETURN(rc);
}          

鐩�鐨�

鍒涘缓鍜岄噴鏀捐〃閿佸畾銆�

姒傝��

鎻忚堪

杩欐槸store_lock鏂规硶銆�

涓嬮潰浠嬬粛浜嗗叧浜�handler::store_lock()鐨勬�傚康锛�

璇ヨ��鍙ュ喅瀹氫簡鍦ㄨ〃涓婇渶瑕佷綍绉嶉攣瀹氥�傚�逛簬updates/deletes/inserts锛屾垜浠�寰楀埌WRITE閿佸畾锛涘�逛簬SELECT...锛屾垜浠�寰楀埌璇婚攣瀹氥��

灏嗛攣瀹氭坊鍔犲埌琛ㄩ攣瀹氬�勭悊绋嬪簭涔嬪墠锛堣�峰弬瑙�thr_lock.c锛夛紝mysqld灏嗙敤璇锋眰鐨勯攣瀹氳皟鐢ㄥ瓨鍌ㄩ攣瀹氥�傜洰鍓嶏紝瀛樺偍閿佸畾鑳藉皢鍐欓攣瀹氭洿鏀逛负璇婚攣瀹氾紙鎴栨煇浜涘叾浠栭攣瀹氾級锛屽拷鐣ラ攣瀹氾紙濡傛灉涓嶆墦绠椾娇鐢�MySQL琛ㄩ攣瀹氾級锛屾垨涓哄緢澶氳〃娣诲姞閿佸畾锛堝氨鍍忎娇鐢�MERGE澶勭悊绋嬪簭鏃堕偅鏍凤級銆�

渚嬪�傦紝Berkeley DB鑳藉�熷皢鎵�鏈夌殑WRITE閿佸畾鏇存敼涓�TL_WRITE_ALLOW_WRITE锛堣〃鏄庢�ｅ湪鎵ц��WRITES鎿嶄綔锛屼絾鎴戜滑浠嶅厑璁稿叾浠栦汉鎵ц�屾搷浣滐級銆�

閲婃斁閿佸畾鏃讹紝涔熷皢璋冪敤store_lock()銆傚湪杩欑�嶆儏鍐典笅锛岄�氬父涓嶉渶瑕佷綔浠讳綍浜嬨��

鍦ㄦ煇浜涚壒娈婃儏鍐典笅锛�MySQL鍙�鑳戒細鍙戦�佸��TL_IGNORE鐨勮�锋眰銆傝繖鎰忓懗鐫�鎴戜滑姝ｅ湪璇锋眰涓庝笂娆＄浉鍚岀殑閿佸畾锛岃繖涔熷簲琚�蹇界暐锛堝綋鎴戜滑鎵撳紑浜嗚〃鐨勬煇涓�閮ㄥ垎鏃讹紝濡傛灉鍏朵粬浜烘墽琛屼簡琛ㄥ埛鏂版搷浣滐紝灏变細鍑虹幇璇ユ儏鍐碉紝姝ゆ椂锛�mysqld灏嗗叧闂�骞跺啀娆℃墦寮�琛�锛岀劧鍚庤幏鍙栦笌涓婃�＄浉鍚岀殑閿佸畾锛夈�傛垜浠�鎵撶畻鍦ㄥ皢鏉ュ垹闄よ�ョ壒鎬с��

鐢�get_lock_data()浠�lock.cc涓�璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

涓嬭堪绀轰緥鍙栬嚜ARCHIVE瀛樺偍寮曟搸锛�

/* 
  Below is an example of how to setup row level locking.
*/
THR_LOCK_DATA **ha_archive::store_lock(THD *thd,
                                       THR_LOCK_DATA **to,
                                       enum thr_lock_type lock_type)
{
  if (lock_type == TL_WRITE_DELAYED)
    delayed_insert= TRUE;
  else
    delayed_insert= FALSE;

  if (lock_type != TL_IGNORE && lock.type == TL_UNLOCK) 
  {
    /* 
      Here is where we get into the guts of a row level lock.
      If TL_UNLOCK is set 
      If we are not doing a LOCK TABLE or DISCARD/IMPORT
      TABLESPACE, then allow multiple writers 
    */

    if ((lock_type >= TL_WRITE_CONCURRENT_INSERT &&
         lock_type <= TL_WRITE) && !thd->in_lock_tables
        && !thd->tablespace_op)
      lock_type = TL_WRITE_ALLOW_WRITE;

    /* 
      In queries of type INSERT INTO t1 SELECT ... FROM t2 ...
      MySQL would use the lock TL_READ_NO_INSERT on t2, and that
      would conflict with TL_WRITE_ALLOW_WRITE, blocking all inserts
      to t2. Convert the lock to a normal read lock to allow
      concurrent inserts to t2. 
    */

    if (lock_type == TL_READ_NO_INSERT && !thd->in_lock_tables) 
      lock_type = TL_READ;

    lock.type=lock_type;
  }

  *to++= &lock;
 
  return to;
}          

鐩�鐨�

鏇存柊宸叉湁琛岀殑鍐呭�广��

姒傝��

鎻忚堪

杩欐槸update_row鏂规硶銆�

old_data灏嗕繚瀛樺墠涓�琛岀殑璁板綍锛岃��new_data灏嗕繚瀛樻渶鏂扮殑鏁版嵁銆�

濡傛灉浣跨敤浜�ORDER BY瀛愬彞锛屾湇鍔″櫒鑳藉�熸牴鎹�鎺掑簭鎵ц�屾洿鏂版搷浣溿�備笉淇濊瘉杩炵画鎺掑簭銆�

鐩�鍓嶏紝new_data涓嶄細鎷ユ湁宸叉洿鏂扮殑auto_increament璁板綍锛屾垨宸叉洿鏂扮殑鏃堕棿鎴冲瓧娈点�備綘鍙�浠ラ�氳繃涓嬭堪鏂瑰紡锛堜緥濡傦級瀹屾垚璇ユ搷浣滐細if (table->timestamp_field_type & TIMESTAMP_AUTO_SET_ON_UPDATE) table->timestamp_field->set_time(); if (table->next_number_field && record == table->record[0]) update_auto_increment();

浠�sql_select.cc, sql_acl.cc, sql_update.cc鍜�sql_insert.cc璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

榛樿�ゅ疄鏂�

           { return  HA_ERR_WRONG_COMMAND; }
        

鐩�鐨�

涓鸿〃娣诲姞鏂拌�屻��

姒傝��

鎻忚堪

杩欐槸write_row鏂规硶銆�

write_row()鐢ㄤ簬鎻掑叆琛屻�傜洰鍓嶏紝濡傛灉鍑虹幇澶ч噺鍔犺浇锛屼笉浼氱粰鍑轰换浣�extra()鎻愮ず銆�buf鏄�鏁版嵁鐨勫瓧鑺傛暟缁勶紝澶у皬涓�table->s->reclength銆�

鍙�浠ヤ娇鐢ㄥ瓧娈典俊鎭�浠庢湰鍦板瓧鑺傛暟缁勭被鍨嬫彁鍙栨暟鎹�銆備緥濡傦細

for (Field **field=table->field ; *field ; field++) { ... }

BLOB蹇呴』鐗规畩澶勭悊锛�

for (ptr= table->s->blob_field, end= ptr + table->s->blob_fields ; ptr != end ; ptr++) 

  { 

        char *data_ptr; 

        uint32 size= ((Field_blob*)table->field[*ptr])->get_length();

        ((Field_blob*)table->field[*ptr])->get_ptr(&data_ptr); 

        ... 

  }

鍏充簬浠ュ瓧绗︿覆褰㈠紡鎻愬彇鎵�鏈夋暟鎹�鐨勭ず渚嬶紝璇峰弬瑙�ha_tina.cc銆傚湪ha_berkeley.cc涓�锛屽�逛簬ha_berkeley鑷�宸辩殑鏈�鍦板瓨鍌ㄧ被鍨嬶紝缁欏嚭浜嗕竴涓�閫氳繃鈥滃寘瑁呭姛鑳解�濆畬鏁翠繚瀛樺畠鐨勪緥瀛愩��

璇峰弬瑙�update_row()鍏充簬auto_increments鍜屾椂闂存埑鐨勬敞閲娿�傝�ユ儏褰�涔熼�傜敤浜�write_row()銆�

浠�item_sum.cc銆�item_sum.cc銆�sql_acl.cc銆�sql_insert.cc銆�sql_insert.cc銆�sql_select.cc銆�sql_table.cc銆�sql_udf.cc銆佷互鍙�sql_update.cc璋冪敤銆�

鍙傛暟

杩斿洖鍊�

鏃犺繑鍥炲�笺��

鐢ㄦ硶

榛樿�ゅ疄鏂�

           { return  HA_ERR_WRONG_COMMAND; }