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…
-
JQuery로 Checkbox check여부 확인 및 Label 활용 방법.
Label로 묶어 주면 check button이 아니라 글자를 눌러도 check button 누르는 것 처럼 된다. <label><input type=’checkbox’ id=’check_all’ class=’input_check’ /> <b>Check me</b></label> Checke…
-
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…
-
windows)how to reduce of time_wait
after “regedit” and find key as below HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesTcpipParameters and make key as DWORD, name is “TcpTimeWaitDelay” and value is 30 ( recom…
-
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(…
-
server monitoring solutions.
https://www.nagios.org/ ( Open Source ) http://www.whatap.io ( SaaS ) opinions for whatap ( http://archmond.net/?p=3609 )
-
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…
