|
- °Ë»öµÈ °Ô½ÃÆÇ ¸®½ºÆ® (9°³ÀÇ °Ô½ÃÆÇ, 78°³ÀÇ °Ô½Ã±Û, 7/8 ÆäÀÌÁö)
- HeartBeat¸¦ ÀÌ¿ëÇÑ MySQL HA ±¸¼º [»õâ]
Ãâó : <A href="http://imaso.co.kr/?doc=bbs/gnuboard.php&bo_table=article&wr_id=33696">http://imaso.co.kr/?doc=bbs/gnuboard.php&bo_table=article&wr_id=33696</A><BR><BR><BR><STRONG><FONT size=4>MySQL HA ±¸¼º<BR></F¡¦ 2010-01-13 23:00:52 ÃÖ°í°ü¸®ÀÚ
- mysql Á¶°Ç¹é¾÷ [»õâ]
-t : ½ºÅ°¸¶Á¦¿ÜÇÏ°í ¹é¾÷<BR><BR><BR> mysql -u user -h localhost -p -t --where="server_ip like '115.68.27.%'" Databases table > file.sql 2010-01-13 15:14:22 ÃÖ°í°ü¸®ÀÚ
- mysqlclient ÇÑ±Û ÀÔ·Â [»õâ]
1. shell¿¡¼´Â ÇѱÛÀÌ ÀÔ·ÂÀº µÇÁö¸¸ MySQL Client¿¡¼ ÇѱÛÀÌ ÀԷµÇÁö ¾ÊÀ» °æ¿ì<BR>mysql client°¡ Çѱۼ³Á¤°ú Ãæµ¹À» ÀÏÀ¸Å³ °æ¿ì¿¡ mysql client(ÄܼÖ)¿¡¼ ÇѱÛÀÌ µÇÁö ¾Ê½À´Ï´Ù.<BR>ÀÌ·²¶© LANG¼³Á¤À» ´Ù½Ã en_US·Î µ¹·Á³õ°í ½ÇÇàÇϸé ÇÑ±Û ÀÔ·ÂÀÌ °¡´ÉÇÕ´Ï´Ù.<BR>export LANG=en_US<BR>&l¡¦ 2009-12-15 10:43:14 ÃÖ°í°ü¸®ÀÚ
- MYSQL ÆÛÆ÷¸Õ½º Æ©´× ½ºÅ©¸³Æ® [»õâ]
<P>Âü°íÆäÀÌÁö<BR><A href="http://day32.com/MySQL/" target=_blank>http://day32.com/MySQL/</A><BR><A href="http://day32.com/MySQL/tuning-primer.sh" target=_blank>http://day32.com/MySQL/tuning-primer.sh</A></P>
<P><BR>This script takes inform¡¦ 2009-12-09 09:41:47 ÃÖ°í°ü¸®ÀÚ
- Sorting IP Addresses in MySQL [ț̢]
<h5 style="margin: 0px 0px 20px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-stretch: inherit; line-height: inherit; font-family: Kreon, serif; vertical-align: baseline; color: rgb(54, 57, 59);"><font size="2">Ãâó : http://matthewvince.com/2011/08/04/sorting¡¦ 2017-11-15 15:48:06 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] Named timezone ¼³Á¤ [»õâ]
<div style="color: rgb(0, 0, 0); font-family: ±¼¸²; font-size: 9pt; line-height: 1.5;"><font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;"><b>:: È®ÀÎ</b></span></font></div><div style="color: rgb(0, 0, 0); font-family: ±¼¸²; font-siz¡¦ 2015-10-20 11:29:32 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] ¹®ÀÚ¿ ÀÚ¸£±â left, substring, right [»õâ]
<div><span style="font-size: 9pt; line-height: 1.5;">mysql> select product_name from TB_SVC where ip='XXX.XXX.XXX.XXX';</span></div><div><div>+------------------------------------------+</div><div>| product_name  ¡¦ 2014-05-16 10:41:36 ÃÖ°í°ü¸®ÀÚ
- MYSQL ´ë¼Ò¹®ÀÚ °Ë»ö binary(name) [»õâ]
<div style="color: rgb(0, 0, 0); "><font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;">mysql> select code, name TX_ORXXX where od_uts like '2012-11-09%' and <b>binary(name)</b> like'CLOUD V%';</span></font></div¡¦ 2012-11-09 15:20:06 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] varchar ¼ýÀÚÁ¤·Ä [»õâ]
<DIV>mysql> DESC TB_Table;<BR>+--------+--------------+------+-----+---------+-------+<BR>| Field | Type | Null | Key | Default | Extra |<BR>+--------+--------------+---¡¦ 2011-09-26 10:33:11 ÃÖ°í°ü¸®ÀÚ
óÀ½ 1 2 3 4 5 6 7 8 ¸Ç³¡
|
|
|
|