"µ¥ÀÌŸº£À̽º" Á¾·ù¸¦ À§ÇÑ ±â·Ï º¸°ü¼Ò

MySQL µ¥ÀÌŸº£À̽º ¼º°ú Á¶Á¤ ÃÖ»óÀÇ ¹æ¹ý ¿µ»ó ÀÚ½À¼­

È­¿äÀÏ, 2008³â 7¿ù 29

MySQL´Â ¿ªµ¿ÀûÀ¸·Î ºÀ»çÇÑ À¥»çÀÌÆ®¸¦ °­È­ÇÏ´Â ¼ö¹é¸¸À» °¡Áø À§Ä¡¸¦ Æ÷ÇÔÇÏ¿© ´ëÁßÀûÀÎ µ¥ÀÌŸº£À̽º °ü¸® ü°èÀÇ °Í ¸Å¸ÅÇÑ´Ù ¸ÅÀÏ ¹æ¹®ÀÚÀ̰í. ¸¹Àº À¥ ÆäÀÌÁö ¹× À¥ ¾ÖÇø®ÄÉÀÌ¼Ç ¶Ç´Â ¼­ºñ½º´Â MySQL¸¦ ¹æ¹®ÀÚ´Â ÀÐÀ» ¿ªµ¿ÀûÀ¸·Î À¥ ÆäÀÌÁöÀ̶ó°í °ÇÃàÇϴ¿¡ À¥ ¼­¹ö¿¡ ÀÇÇØ ±×¸®°í Àбâ À§ÇÏ¿© ¸¸È¸µÉ ³»¿ë ÀڷḦ ÀúÀåÇϱâ À§ÇÏ¿© ÀÇÁöÇÑ´Ù.

°è¼ÓÇϽʽÿÀ µ¶¼­ MySQL µ¥ÀÌŸº£À̽º ¼º°ú Á¶Á¤ ÃÖ»óÀÇ ¹æ¹ý ¿µ»ó ÀÚ½À¼­¸¦"""


±â¾ï°ú °æ¿Ü¿¡ ÀÖ´Â ÆäÀÌÁö¸¦ Àá°¡¼­ Å« ·½ ü°è¿¡¼­ SQL ¼­¹ö 2000³â, 2005³â 2008³âÀ» ³«°üÇϽʽÿÀ

Åä¿äÀÏ, 2008³â 6¿ù 7ÀÏ

¸¶ÀÌÅ©·Î¼ÒÇÁÆ® SQL ¼­¹ö´Â ÀÚ·á ÁýÁß°ú ÀÐÈù µð½ºÅ© ÀÔ·Â/Ãâ·Â (±×¸®°í ¾²½Ê½Ã¿À) ÁýÁßÀûÀÎ µ¥ÀÌŸº£À̽º °ü¸® ü°èÀÌ´Ù. 4GB¸¦ °¡Áø ü°è¿Í °°Àº À°Ã¼ÀûÀÎ ·¥ ±â¾ï ÀåÄ¡ÀÇ ´Ù·® Å« Å©±â¸¦ °¡Áø ü°è ¹°¸®Àû ±â¾ï Àå¼ÒÀÇ 8GB ¶Ç´Â ±â°¡¹ÙÀÌÆ® ´õ¿¡ ´Þ¸®°í ÀÖ´Â SQL ¼­¹ö¸¦ À§ÇØ, ±×°ÍÀº ÁÖ¼Ò À©µµ¿ìÀ× Çü¼ºÇÑ °¡»ó ±â¾ïÀåÄ¡¿¡ ¼³Á¤µÈ ÇѰèÀ» ÃʰúÇÏ¿© ¹°¸®Àû ±â¾ï Àå¼Ò¸¦ ¾×¼¼½ºÇÒ ¼ö ÀÖ°Ô Çϱâ À§ÇÏ¿© ¿¬Àå (°æ¿Ü) API¸¦ ÀÌ¿ëÇϵµ·Ï Çü¼ºµÉ ¼ö ÀÖ°í, °í¼Ó Á¢±ÙÀ» À§ÇÑ ±â¾ï¿¡¼­ ÀϾ±â À§ÇÏ¿© ¸ðµç Âʸűâ±â¸¦ °­Á¦ÇÑ´Ù.

Àд °è¼ÓµÇ ³«°üÇÑ´Ù ±â¾ï°ú °æ¿Ü¿¡ ÀÖ´Â ÆäÀÌÁö¸¦" Àá°¡¼­" Å« ·½ ü°è"¿¡¼­ SQL ¼­¹ö 2000³â, 2005³â 2008³âÀ»

ÀÚÀ¯·Î¿î ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº ´ë¾È ¶Ç´Â º¸Ãæ

ÀÏ¿äÀÏ, 2007³â 11¿ù 25ÀÏ

¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº ÇÑ ¹ú°ú Á¦Ç°Àº ¸¹Àº ȸ»ç¿¡ ÀÖ´Â ´ëÁßÀûÀÎ »ç¹«½Ç »ý»ê·Â ½Åû ÇÑ ¹úÀÇ °Í ¹× ±â¾÷ÀÌ´Ù. ±×·¯³ª, ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº´Â ºñ½Î´Ù, Àü¸éÀ¸·Î °íÀÛ °ªÀ» ¸Å°Ü. ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº´Â ÇÊ¿ä·Î ÇÏ »ç¶÷ÀÌ °áÄÚ »ç¿ëÇØ°Å³ª ¼öµµ ÀÖÁö ¾Ê´Â ¸¹Àº Áøº¸µÈ Ư¡À¸·Î, »ç¿ëÇϱ⠽¬¿î °ø¿ë¿µ¿ªÀ¸·Î ¿Â´Ù. ¸î¸î ºÎÇ®Àº Ư¡À» Èñ»ýÇÏ´Â °ÍÀ» ÀǵµÇØ ´ç½ÅÀÌ, °Å±â ´À¸®°Ô ½ÃÀå Á¡À¯À²À» ¾ò±â ÀÖ´Â ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº¿¡´ÂÀ» À§ÇÑ ¿ÏÀüÇÑ º¸Ãæ ´ë¾ÈÀÇ ¸¹À½ÀÎ °æ¿ì¿¡. Àß ¸ðµÎÀÇ, ¾çÀÚÅÃÀÏ »ç¹«½ÇÀº ÀÚÀ¯·Ó, ´ç½ÅÀÌ ÀÌÁ¦±îÁö ÀÌ¿ëÇÒ Çʿ䰡 ÀÖ´Â ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº ÆÄÀÏ Çü½ÄÀ» À§ÇÑ °â¿ë¼º ±×¸®°í Áö¿øÀ» Æ÷ÇÔÇÏ¿© ¸ðµç Ư¡À», ¼ÒÀ¯ÇÑ´Ù.

ÀÚÀ¯·Î¿î ¸¶ÀÌÅ©·Î¼ÒÇÁÆ® ¿ÀÇǽº ´ë¾È ¶Ç´Â º¸ÃæÀ»" ÀдÂ" °è¼ÓµÇ"

Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections

Wednesday, October 31st, 2007

When connecting to an instance of Microsoft SQL Server 2005 database, including SQL Server 2005 Express, Developer and Enterprise editions, for authentication or accessing and retrieving and updating the data, the the following error message may appear. The problem happens no matter the connection is originated from remote computer or on SQL Server local computer itself, and can be caused by any program, such as SQLCMD utility, used to connect to SQL Server.

Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

Continue reading Error Has Occurred While Establishing A Connection To SQL Server 2005 Which Does Not Allow Local and Remote Connections » » »


Oracle PL/SQL ORA-00947 Not Enough Values Error

Tuesday, October 23rd, 2007

In Oracle database, the following error message may appear when an incorrect SQL statement is used, in SQL Plus or in anywhere that send SQL queries to the databases such as stored procedure or external programs.

PL/SQL: SQL Statement ignored
PL/SQL: ORA-00947: not enough values

Continue reading Oracle PL/SQL ORA-00947 Not Enough Values Error » » »

Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005

Sunday, October 14th, 2007

When database system administrator installs Microsoft SQL Server 2005 and creates a few database engine instances, there will be problem and hard time to remove and uninstall these multiple database instance components and the corresponding SQL Server services. When users try to uninstall Microsoft SQL Server 2005 or remove database instance components using Add and Remove Programs or Uninstall or change a programs (Vista) in Control Panel, only one SQL Server 2005 database engine can be selected. After uninstallation has completed, when users attempt to run the SQL Server 2K5 Uninstall to completely clean remove any other instances or components, the action will fail with error message saying the uninstaller shortcut entry is invalid and asked if you want to remove the link.

Continue reading Uninstall and Remove Multiple Database Instances of Microsoft SQL Server 2005 » » »

How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog

Saturday, October 6th, 2007

MySQL database server generates binary log files for every transaction to the databases, provided administrator does not disable or comment out the ¡°log-bin¡± parameter in my.cny configuration file. The binary log files are written in binary format. Although the binary logs, or also known as logbin are mainly used for MySQL database replication purpose, sometimes you may need to examine or read the contents of binary logs in text format, where the mysqlbinlog utility will come in handy.

Continue reading How to Read MySQL Binary Log Files (BinLog) with mysqlbinlog » » »

Check and Optimize MySQL Database Automatically with Crontab/Cron

Friday, September 21st, 2007

MySQL is a very popular free yet powerful database system. But even in great databases, the tables may get fragmented with overhead due to continuous update, or delete and insert operation on data stored in database. Beside, it¡¯s also possibility that the databases may get corrupted. Thus, performing health check on database and optimize MySQL server regularly is an important task.

Continue reading Check and Optimize MySQL Database Automatically with Crontab/Cron » » »