Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½Ì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Õâ¸öÎļþ


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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Óï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......

c#¿ØÖÆMysql ʵÏÖ×Ô¶¯É¾³ý¹¦ÄÜ - .NET¼¼Êõ / C#

Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ