\uc6d0\uc778\uc740.. \u00a0POCO\uc5d0\uc11c\u00a0MYSQL\uc758 TIMESTAMP \ud0c0\uc785\uc744 \uc9c0\uc6d0 \ud558\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae34 \ubb38\uc81c.<\/p>\n
\uc774\ub97c \ud574\uacb0 \ud558\uae30 \uc704\ud574\uc11c POCO\ub77c\uc774\ube0c\ub7ec\ub9ac \uc18c\uc2a4\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \ud55c \ud6c4\uc5d0 \uc7ac \ucef4\ud30c\uc77c \ud574\uc900\ub2e4.<\/p>\n
POCO \uc18c\uc2a4 \ud3f4\ub354\uc5d0\uc11c Data\/MySQL\/src\/ResultMetadata.cpp \uc758 \ub0b4\uc6a9\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \r\n\r\nstd<\/span>::<\/span>size_t fieldSize<\/span>(<\/span>const MYSQL_FIELD<\/span>&<\/span> field<\/span>)<\/span>\r\n \/\/\/<\/span> Convert<\/span> field MySQL-type <\/span>and<\/span> field MySQL-length <\/span>to<\/span> actual field length\r\n<\/span>{<\/span>\r\n ...<\/span>\r\n\r\n case<\/span> MYSQL_TYPE_DATE<\/span>:<\/span>\r\n case<\/span> MYSQL_TYPE_TIME<\/span>:<\/span>\r\n case<\/span> MYSQL_TYPE_DATETIME<\/span>:<\/span>\r\n case<\/span> MYSQL_TYPE_TIMESTAMP<\/span>:<\/span> \/\/<\/span> <<\/span>-- add this line<\/span><\/span>\r\n return<\/span> sizeof<\/span>(<\/span>MYSQL_TIME<\/span>);<\/span>\r\n\r\n ...<\/span>\r\n\r\n}<\/span> \r\n\r\n\r\nPoco<\/span>::<\/span>Data<\/span>::<\/span>MetaColumn<\/span>::<\/span>ColumnDataType fieldType<\/span>(<\/span>const MYSQL_FIELD<\/span>&<\/span> field<\/span>)<\/span>\r\n \/\/\/<\/span> Convert<\/span> field MySQL-type <\/span>to<\/span> Poco-type \r\n<\/span>{<\/span>\r\n ...<\/span>\r\n\r\n case<\/span> MYSQL_TYPE_DATETIME<\/span>:<\/span>\r\n case<\/span> MYSQL_TYPE_TIMESTAMP<\/span>:<\/span> \/\/<\/span> <<\/span>-- add this line<\/span><\/span>\r\n return<\/span> Poco<\/span>::<\/span>Data<\/span>::<\/span>MetaColumn<\/span>::<\/span>FDT_TIMESTAMP<\/span>;<\/span>\r\n\r\n ...<\/span>\r\n\r\n}<\/span> <\/code><\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"\uc6d0\uc778\uc740.. \u00a0POCO\uc5d0\uc11c\u00a0MYSQL\uc758 TIMESTAMP \ud0c0\uc785\uc744 \uc9c0\uc6d0 \ud558\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae34 \ubb38\uc81c. \uc774\ub97c \ud574\uacb0 \ud558\uae30 \uc704\ud574\uc11c POCO\ub77c\uc774\ube0c\ub7ec\ub9ac \uc18c\uc2a4\ub97c \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 \ud55c \ud6c4\uc5d0 \uc7ac \ucef4\ud30c\uc77c \ud574\uc900\ub2e4. POCO \uc18c\uc2a4 \ud3f4\ub354\uc5d0\uc11c Data\/MySQL\/src\/ResultMetadata.cpp \uc758 \ub0b4\uc6a9\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815 std::size_t fieldSize(const MYSQL_FIELD& field) \/\/\/ Convert field MySQL-type and field MySQL-length to actual field length { … case MYSQL_TYPE_DATE: case MYSQL_TYPE_TIME: case MYSQL_TYPE_DATETIME: case MYSQL_TYPE_TIMESTAMP: \/\/ <– add this line return sizeof(MYSQL_TIME); … } Poco::Data::MetaColumn::ColumnDataType fieldType(const MYSQL_FIELD& field) \/\/\/ Convert field MySQL-type to Poco-type { … case MYSQL_TYPE_DATETIME: case MYSQL_TYPE_TIMESTAMP: \/\/ <– add this line return Poco::Data::MetaColumn::FDT_TIMESTAMP; … }<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-iJ","jetpack-related-posts":[{"id":801,"url":"https:\/\/blog.box.kr\/?p=801","url_meta":{"origin":1161,"position":0},"title":"[scrap] MySQL Replication \uc124\uc815\uacfc \uba87 \uac00\uc9c0 \ud14c\uc2a4\ud2b8","date":"2015-05-18","format":false,"excerpt":"http:\/\/blog.hibrainapps.net\/130 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 MySQL\uc744 DB\ub85c \uc0ac\uc6a9\ud558\uba74\uc11c \uc11c\ubc84\uc758 \ubd80\ud558 \ubd84\uc0b0\uc744 \uc704\ud55c \ubc29\ubc95 \uc911 \ud558\ub098\ub85c Replication \uc744 \uc0ac\uc6a9\ud55c\ub2e4. Replication \uc740 Master \ud558\ub098\uc5d0 n\uac1c\uc758 Slave\ub85c \uc9c0\uc815\uc774 \uac00\ub2a5\ud558\ub2e4. Slave\ub294 \ub2e4\uc2dc Master \uc5ed\ud560\uc744 \ud560\uc218 \uc788\uc73c\uba70 \uc5ed\uc2dc \ub610 \ub2e4\ub978 n\uac1c\uc758 Slave\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubd80\ud558 \ubd84\uc0b0\uc758 \ud6a8\uacfc\ub294 inser,update \ub4f1 \ubcc0\uacbd\uacfc \uad00\ub828\ub41c \ubaa8\ub4e0 \uc791\uc5c5\uc740\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":116,"url":"https:\/\/blog.box.kr\/?p=116","url_meta":{"origin":1161,"position":1},"title":"MYSQL + TOMCAT \ub610\ub294 MYSQL\ub97c\u2026","date":"2014-06-18","format":false,"excerpt":"MYSQL + TOMCAT \ub610\ub294 MYSQL\ub97c \uc0ac\uc6a9\ud558\ub294 WEB \uac1c\ubc1c \uc2dc Connection POLL\uc774 \uc790\uc8fc \ub04a\uae30\ub294 \uc77c\uc774 \ube48\ubc88 \ud568.. \u00a0 \uc774\ub97c \ub9c9\uae30 \uc704\ud574 WAS Connection POOL \uc124\uc815\uc5d0 AutoReconnect = true\ub97c \uc918 \ubd24\uc9c0\ub9cc \uc18c\uc6a9 \uc5c6\uc74c.. \uc0dd\uac01 \ub05d\uc5d0 DB\uc758 connection time out\uc774 \uc5bc\ub9c8 \uc77c\uae4c \ud655\uc778 \ud574\ubcf4\ub2c8.. \u00a0 \uae30\ubcf8 \uac12\uc774.. 10\ucd08\uc784.. \uc820\uc7a5.. \uadf8\ub798\uc11c 600 \ucd08\ub85c \ub298\ub824\uc8fc.\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":379,"url":"https:\/\/blog.box.kr\/?p=379","url_meta":{"origin":1161,"position":2},"title":"[\ud38c]\ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js","date":"2014-09-15","format":false,"excerpt":"http:\/\/bcho.tistory.com\/889 \ube60\ub974\uac8c \ud6dd\uc5b4 \ubcf4\ub294 node.js - #6 MongoDB \uc5f0\ub3d9 (mongo-native) \ud074\ub77c\uc6b0\ub4dc \ucef4\ud4e8\ud305 & NoSQL\/Vert.x & Node.js\u00a0|\u00a02014\/04\/03 23:49\u00a0|\u00a0Posted by\u00a0\uc870\ub300\ud611 \ube60\ub974\uac8c \ud6dd\uc5b4\ubcf4\ub294\u00a0node.js #6- mongo-native \ubaa8\ub4c8\uc744 \uc774\uc6a9\ud55c MongoDB \uc5f0\ub3d9 \uc870\ub300\ud611\u00a0(http:\/\/bcho.tistory.com Persistence\u00a0\uc5f0\ub3d9 node.js\ub294\u00a0DB\ub098\u00a0NoSQL\ub4f1\uc758 \uc5f0\ub3d9\uc744 \uc9c0\uc6d0\ud558\ub294\ub370,\u00a0\uc774 \uc5ed\uc2dc \ucca0\uc800\ud558\uac8c\u00a0non-blocking io\u00a0\ubc29\uc2dd\uc73c\ub85c \ub3d9\uc791\ud55c\ub2e4.\u00a0\uc989\u00a0db\u00a0\uc5f0\uacb0\u00a0socket\uc744 \uc5f4\uc5b4\uc11c\u00a0query\ub97c \ub358\uc838\ub193\uace0, query\u00a0\uacb0\uacfc\uac00 \uc624\uba74 \uc774\ubca4\ud2b8\ub97c \ubc1b\uc544\uc11c\u00a0callback\u00a0\ud568\uc218\ub85c \ucc98\ub9ac\ud558\ub294 \uc21c\uc11c\uc774\ub2e4. \uadf8\ub7ec\uba74 \uc5ec\uae30\uc11c\ub294 \uba87\uac00\uc9c0\u00a0persistence\u00a0\uc5f0\ub3d9 \ubc29\uc2dd\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud55c\ub2e4.\u2026","rel":"","context":"In "\ucc38\uace0\ub97c \uc704\ud55c \uc800\uc7a5\ubb3c"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":653,"url":"https:\/\/blog.box.kr\/?p=653","url_meta":{"origin":1161,"position":3},"title":"[\ud38c]Too many connection \ubb38\uc81c \ud574\uacb0","date":"2015-04-05","format":false,"excerpt":"http:\/\/netholic.tistory.com\/116 \u00a0 \u00a0 \uc774\ubc88\ud574 \ucd08\ubd80\ud130 \uc2dc\uc791\ub41c too many connection \ubb38\uc81c\uac00 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 mysql \uc744 \ubed7\uac8c \ub9cc\ub4e4\uc5c8\ub2e4. \ub418\ub294\ub300\ub85c... \uc544\ubb34\uac83\ub3c4 \ubaa8\ub978\ucc44\ub85c \ub9cc\ub4e0 \uc6b4\uc601\ud234\uc774 \uadf8 \uc6d0\uc778... \ucffc\ub9ac\ub3c4 10\ucd08 \uc774\uc0c1 \uac78\ub9ac\ub294 \uac83\ub3c4 \uc874\uc7ac\ud588\uace0..\uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uc548\uac78\ub824\uc788\uace0.. \uadf8\ub798\uc11c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc7a1\uace0 \uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uac78\uc5b4\uc11c...\uadf8\ub7f0 \ucffc\ub9ac\ubb38\uc81c\ub97c \uc5c6\uc570\uc73c\ub85c\uc11c \ucee4\ub125\uc158 \ubb38\uc81c\ub294 \uc5c6\uc5b4\uc9c8 \uc904 \uc54c\uc558\ub2e4. \uadf8\ub7f0\ub370 \uc5ec\uc804\ud788 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529...\uc11c\ubc84\ub97c \ub0b4\ub838\ub2e4\u2026","rel":"","context":"In "\uae30\uc220\uc790\ub8cc"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":521,"url":"https:\/\/blog.box.kr\/?p=521","url_meta":{"origin":1161,"position":4},"title":"MYSql \uc811\uc18d \ud504\ub85c\ud1a0\ucf5c \ubb38\uc81c","date":"2014-12-29","format":false,"excerpt":"Q1. \u00a0Mysql \uc811\uc18d\uc2dc\uc5d0 \"\u00a0MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)\u00a0\" \uc624\ub958 \ubc1c\uc0dd \uc6d0\uc778: \uc0ac\uc6a9\uc790 \uc554\ud638 \ud574\uc26c\uac12\uc744 \uc608\uc804 \uac83\uc744 \uc0ac\uc6a9\ud574\uc11c \uc0dd\uae30\ub294 \ubb38\uc81c \ud574\uacb0 1 : \u00a0\u00a0--skip-secure-auth \u00a0\uc635\uc158 \uc0ac\uc6a9 => \uc811\uc18d \ud560\ub54c Mysql\uc758 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uc554\ud638 Hash\uc218\uc900\uc744 \ub0ae \ucdb0\uc11c \uc811\uc18d ( \uc784\uc2dc\uc801\uc778 \ubc29\ubc95 )\u00a0\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1284,"url":"https:\/\/blog.box.kr\/?p=1284","url_meta":{"origin":1161,"position":5},"title":"MySql \uad00\ub9ac","date":"2021-12-30","format":false,"excerpt":"Table\uc5d0 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 Indexes \uc758 \uc6a9\ub7c9 \ud655\uc778 select database_name, table_name, index_name, round((stat_value*@@innodb_page_size)\/1024\/1024, 2) SizeMB, round(((100\/(SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = iis.table_name and t.TABLE_SCHEMA = iis.database_name))*(stat_value*@@innodb_page_size)), 2) `Percentage` from mysql.innodb_index_stats iis where stat_name='size' and table_name = 'TargetTable' and database_name = 'targetDB' show table status from database_name; -- databases\uc5d0 \uc788\ub294\u2026","rel":"","context":"In "DB\uad00\ub828"","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/1161"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1161"}],"version-history":[{"count":1,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/1161\/revisions"}],"predecessor-version":[{"id":1163,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/1161\/revisions\/1163"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}