Table에 생성되어 있는 Indexes 의 용량 확인 Table 최고 사이즈 확인 방법 SHOW TABLE STATUS FROM DB name LIKE ‘Table name’; 이 명령어 이후 Create_options에 있는 max_rows와 avg_row_length를 곱한 값이 용량이 된다….
- Category Archives 기술자료
-
-
Pair Programming Is Not Pair Coding
from : https://dzone.com/articles/pair-programming-is-not-pair-coding?edition=675393 The reason pair programming has never been as popular as other agile practices may be that we want to jump straight…
-
Mysql dynamic query in stored procedure
CREATE PROCEDURE `test1`(IN tab_name VARCHAR(40),IN w_team VARCHAR(40)) BEGIN SET @t1 =CONCAT(“SELECT * FROM “,tab_name,” where team='”,w_team,”‘”); PREPARE stmt3 FROM @t1; EXECUTE stmt3; DEALLOCATE P…
-
how to calculate duration time
http://stackoverflow.com/questions/6734375/c-boost-get-current-time-in-milliseconds int main(int argc, char* argv[]) { boost::posix_time::ptime t1 = boost::posix_time::second_clock::local_time(…
-
Learning Poco: Load XML Configuration
http://www.codeproject.com/Articles/253418/Learning-Poco-Load-XML-Configuration In this tutorial, we will load an XML configuration from the file system by using XMLConfiguration, and access specific…
-
How to install openssl on windows with visual studio 2015
cite from http://developer.covenanteyes.com/building-openssl-for-visual-studio/ and some edit.. ================================================== You need to install… Visual Studio 2015 (this…
-
How to install POCO C++ libraries on Windows with Visual studio 2015
1. Download Poco Libraries ( http://pocoproject.org/download/index.html ) 2. Extract(eg: extract to C:poco-1.6.1) 2-1. if you are choices included openssl version please openssl install on your win…
-
System Monitoring command
1. OS/system $ vmstat 2 10 // 10 system resource status to every 2 sec. $ iostat 2 10 // 10 I/O status to every 2 sec. $ sar 2 10 // 1…
-
TCPDump: Capture and Record Specific Protocols / Port
http://www.cyberciti.biz/faq/tcpdump-capture-record-protocols-port/ Q. How do I capture specific protocol or port such as 80 ( http ) using TCPDump tool under Linux / UNIX? How do I recording Traffic…
