select *^M

from lf_inactive.fox_users fu ^M

where fu_name like '%황준선%'^M

order by fu_id desc

LIMIT 0, 200

2025-01-03 11:38:58 1525564867 [ERROR] InnoDB: Clustered record for sec rec not found index `idx02_fox_users` of table `lf_inactive`.`fox_users`

InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0

 0: len 19; hex 55323030393037313031323537373538333939; asc U200907101257758399;;

 1: len 6; hex 000063082c84; asc   c , ;;

InnoDB: clust index record PHYSICAL RECORD: n_fields 47; compact format; info bits 0

 0: len 6; hex 000063082c82; asc   c , ;;

 1: len 6; hex 000000000000; asc       ;;

 2: len 7; hex 80000000000000; asc        ;;

 3: len 19; hex 55323031323037303631303233313630313932; asc U201207061023160192;;

 4: len 19; hex 55323031323035323232303338313534383436; asc U201205222038154846;;

 5: SQL NULL;

 6: SQL NULL;

 7: len 9; hex ecb694eca780ec9ab0; asc          ;;

 8: SQL NULL;

 9: len 10; hex ec9ab0ecb08c30343036; asc       0406;;

 10: len 1; hex 4d; asc M;;

 11: SQL NULL;

 12: len 4; hex 80000000; asc     ;;

 13: len 9; hex 32303031303430362b; asc 20010406+;;

 14: SQL NULL;

 15: SQL NULL;

 16: SQL NULL;

 17: len 1; hex 59; asc Y;;

 18: SQL NULL;

 19: SQL NULL;

 20: SQL NULL;

 21: SQL NULL;

 22: len 2; hex 4b52; asc KR;;

 23: SQL NULL;

 24: SQL NULL;

 25: SQL NULL;

 26: len 5; hex 998cd50117; asc      ;;

 27: len 5; hex 998ccca5e0; asc      ;;

 28: len 2; hex 5544; asc UD;;

 29: len 1; hex 53; asc S;;

 30: SQL NULL;

 31: SQL NULL;

 32: SQL NULL;

 33: SQL NULL;

 34: len 5; hex 6b6f5f4b52; asc ko_KR;;

 35: SQL NULL;

 36: SQL NULL;

 37: SQL NULL;

 38: SQL NULL;

 39: len 1; hex 59; asc Y;;

 40: len 5; hex 99a0e523f9; asc    # ;;

 41: SQL NULL;

 42: SQL NULL;

 43: len 2; hex 4c46; asc LF;;

 44: SQL NULL;

 45: SQL NULL;

 46: len 2; hex 4c50; asc LP;;

TRANSACTION 421805267277624, ACTIVE 2 sec fetching rows

mysql tables in use 1, locked 0

0 lock struct(s), heap size 1128, 0 row lock(s)

MySQL thread id 1525564867, OS thread handle 140330272823040, query id 18398310151 10.2.1.108 dev_chakyunga Sending data

select *^M

from lf_inactive.fox_users fu ^M

where fu_name like '%황준선%'^M

order by fu_id desc

LIMIT 0, 200

MariaDB [(none)]> show create table lf_inactive.fox_users\G

*************************** 1. row ***************************

       Table: fox_users

Create Table: CREATE TABLE `fox_users` (

  `fu_id` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '유저id  (u+yyyymmddhh24mi+seq(4))',

  `p_fu_id` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '유저id  (u+yyyymmddhh24mi+seq(4))',

  `login_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '로그인id',

  `login_pw` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '로그인pw',

  `fu_name` varchar(65) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '사용자이름',

  `fu_name_en` varchar(65) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

  `fu_nick` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '사용자별명',

  `fu_sex` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '성별',

  `fu_level_old` int(10) DEFAULT NULL COMMENT '주로보는 동화 레벨',

  `school_grade` int(10) DEFAULT NULL COMMENT '학년지표(표준:0), fu_type:s',

  `birth_ymd` varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '생년월일',

  `email` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '이메일',

  `email_yn` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '이메일동의 받음:y, 안받음:n, a(자동처리)',

  `child_cnt` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '현재 등록하여 사용하는 자녀수',

  `home_yn` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '해외거주 구분',

  `post_no` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '우편번호',

  `post_addr` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '집주소',

  `phone1` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '전화번호(필수)',

  `phone2` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '전화번호',

  `country_code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '소속국가코드',

  `hint_question` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '힌트 질문',

  `hint_answer` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '힌트 답변',

  `join_type` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '가입형태:개인,단체(영리,비영리)j000/j001',

  `upd_date` datetime DEFAULT NULL COMMENT '수정일',

  `reg_date` datetime DEFAULT NULL COMMENT '가입일',

  `fu_status` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'up:결제전,ua:정상사용중, us:일시정지, ue:자동만료, rm:삭제, ab:일시정지(job제재), as:일시정지(관리자제재), ae:만료(관리자제재), ra:환불처리  ur: 환불 예정자. (사용할수없는기능 - 일시정지, 환불/환전, 결제)',

  `fu_type` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '직업: 일반-n, 학부모-p, 학생-s, 테스트-t',

  `fu_level` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '회원 독서 레벨 (자동) (사용안함)',

  `fu_level_acc_date` datetime DEFAULT NULL COMMENT '회원 독서 레벨 자동 취합일 (사용안함)',

  `login_pw2` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'login_pw2',

  `fu_custmize` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '{사용자 맞춤서비스}',

  `lang_code` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '국가코드(자동)',

  `geo_continent_code` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '국가코드(자동)',

  `geo_country_code` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '국가코드(자동)',

  `geo_city_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '국가코드(자동)',

  `line_type` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'cdn고정 파라미터 (k-kt, l-limelight)',

  `sleep_flag` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '휴면계정 여부',

  `sleep_date` datetime DEFAULT current_timestamp() COMMENT '휴면 처리일',

  `marketing_email` datetime DEFAULT NULL,

  `marketing_sms` datetime DEFAULT NULL,

  `SERVICE` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '최초 등록 서비스 (LF:리틀팍스 영어, PW:파닉스)',

  `LF_YN` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '리틀팍스 사용 여부 (Y:사용, N:미사용)',

  `PW_YN` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '파닉스 사용 여부 (Y:사용, N:미사용)',

  `AVAILABLE_SERVICE` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '파닉스+리틀팍스:LP(기본값), 리틀팍스:LF, 파닉스:PW',

  KEY `idx01_fox_users` (`sleep_date`),

  KEY `idx02_fox_users` (`fu_id`),

  KEY `idx04_fox_users` (`p_fu_id`),

  KEY `idx03_fox_users` (`login_id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='회원정보'

MariaDB [(none)]> show indexes from lf_inactive.fox_users;

+-----------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| Table     | Non_unique | Key_name        | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |

+-----------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

| fox_users |          1 | idx01_fox_users |            1 | sleep_date  | A         |      693603 |     NULL | NULL   | YES  | BTREE      |         |               |

| fox_users |          1 | idx02_fox_users |            1 | fu_id       | A         |      693603 |     NULL | NULL   |      | BTREE      |         |               |

| fox_users |          1 | idx04_fox_users |            1 | p_fu_id     | A         |      346801 |     NULL | NULL   | YES  | BTREE      |         |               |

| fox_users |          1 | idx03_fox_users |            1 | login_id    | A         |      693603 |     NULL | NULL   | YES  | BTREE      |         |               |

+-----------+------------+-----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

4 rows in set (0.000 sec)