Çë½Ìmysql innodbÊý¾ÝÎļþ´óС³¬¹ýϵͳÏÞÖÆµÄÎÊÌâ
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibdata1µÄ´óСÒѾ³¬¹ý32λϵͳ2GµÄÏÞÖÆ£¬ÒѾ´ïµ½2.6GÁË £¬µ¼Ö´óÁ¿Êý¾Ý±»×èÈû£¬Ö®ºó¸ü¸ÄÁËinnodb_data_file_path £¬Ð¼ÓÁ˼¸¸öÊý¾ÝÎļþ £¬²¢½«Êý¾ÝÎļþ´óСÏÞÖÆÎª2000M(ibdata1:XXXXM:autoextend;ibdataN:1000M:autoextend£ºmax£º2000M)£¬ÖØÐÂÆô¶¯Êý¾Ý¿âºó·¢ÏÖmysql»¹ÊÇÔÚдÔÀ´µÄibdata1Îļþ £¬ÇëÎÊÓÐûÓÐʲô°ì·¨ÈÃmysql½«Êý¾Ýдµ½ÆäËûÊý¾ÝÎļþÖУ¿ ¸ü¸ÄÁËmaxºóÔÀ´ibdata1ÖеÄÊý¾Ý»á²»»á¶ªÊ§£¿ ÎÒĿǰinnodbµÄÅäÖÃÒѾÊDZí½á¹¹ÎļþºÍÊý¾ÝÎļþ·ÖÀëÁ˵ġ£ ÔÝʱûÓлý·Ö·¢¸ø´ó¼Ò £¬Ïȹòл¸÷λÁË£¡
½«Ç°ÃæµÄibdataÎļþµÄ¡°autoextend¡±È¥µô¾Í¿ÉÒÔÁË£¬ÕâÑùÇ°ÃæÎļþÂúÁË×ÔȻдµ½ºóÃæµÄÎļþÀïÃæÈ¥ÁË¡£ÒýÓà ½«Ç°ÃæµÄibdataÎļþµÄ¡°autoextend¡±È¥µô¾Í¿ÉÒÔÁË£¬ÕâÑùÇ°ÃæÎļþÂúÁË×ÔȻдµ½ºóÃæµÄÎļþÀïÃæÈ¥ÁË¡£ È¥µôautoextend£ºmax£º2000MºóÔÙÖØÆô£¬·¢ÏÖ»¹ÊÇÒ»Ö±ÔÚдibdata1Õâ¸öÎļþ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0)) { AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл ½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£ http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ÉÊÇÎÒÕÒ ......