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

mysql ÅäÖÃÎļþmy.cnf

·/etc/my.cnfÊÇĬÈϵÄMySQLÅäÖÃÎļþ¡£Ó¦¸Ã¶ÔÕâ¸öÎļþÅäÖÃÐ޸ġ£ËüÊÇΪѧϰĿµÄ¶øÉè¼ÆµÄ¡£
·my-small.cnfÊÇΪÁËСÐÍÊý¾Ý¿â¶øÉè¼ÆµÄ¡£²»Ó¦¸Ã°ÑÕâ¸öÄ£ÐÍÓÃÓÚº¬ÓÐһЩ³£ÓÃÏîÄ¿µÄÊý¾Ý¿â¡£
·my-medium.cnfÊÇΪÖеȹæÄ£µÄÊý¾Ý¿â¶øÉè¼ÆµÄ¡£Èç¹ûÄãÕýÔÚÆóÒµÖÐʹÓÃRHEL,¿ÉÄÜ»á±ÈÕâ¸ö²Ù×÷ϵͳµÄ×îСRAMÐèÇó(256MB)Ã÷ÏÔ¶àµÃ¶àµÄÎïÀíÄÚ´æ¡£Óɴ˿ɼû£¬Èç¹ûÓÐÄÇô¶àRAMÄÚ´æ¿ÉÒÔʹÓã¬×ÔÈ»¿ÉÒÔÔÚͬһ̨»úÆ÷ÉÏÔËÐÐÆäËü·þÎñ¡£
·my-large.cnfÊÇΪרÓÃÓÚÒ»¸öSQLÊý¾Ý¿âµÄ¼ÆËã»ú¶øÉè¼ÆµÄ¡£ÓÉÓÚËü¿ÉÒÔΪ¸ÃÊý¾Ý¿âʹÓöà´ï512MBµÄÄڴ棬ËùÒÔÔÚÕâÖÖÀàÐ͵ÄϵͳÉϽ«ÐèÒªÖÁÉÙ1GBµÄRAM,ÒÔ±ãËüÄܹ»Í¬Ê±´¦Àí²Ù×÷ϵͳÓëÊý¾Ý¿âÓ¦ÓóÌÐò¡£
·my-huge.cnfÊÇΪÆóÒµÖеÄÊý¾Ý¿â¶øÉè¼ÆµÄ¡£ÕâÑùµÄÊý¾Ý¿âÒªÇóרÓ÷þÎñÆ÷ºÍ1GB»ò1GBÒÔÉϵÄRAM¡£
ÕâЩѡÔñ¸ß¶ÈÒÀÀµÓÚÄÚ´æµÄÊýÁ¿¡¢¼ÆËã»úµÄÔËËãËÙ¶È¡¢Êý¾Ý¿âµÄϸ½Ú´óС¡¢·ÃÎÊÊý¾Ý¿âµÄÓû§ÊýÁ¿ÒÔ¼°ÔÚÊý¾Ý¿âÖÐ×°Èë²¢·ÃÎÊÊý¾ÝµÄÓû§ÊýÁ¿¡£Ëæ×ÅÊý¾Ý¿âºÍÓû§µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý¿âµÄÐÔÄÜ¿ÉÄܻᷢÉú±ä»¯¡£
ÎÒ½«Öð¸öµÄ˵Ã÷ÕâЩÅäÖÃÎļþ¡£Èç¹ûÓû§¾ö¶¨Ê¹ÓÃmy-*.cnfÎļþÖ®Ò»£¬½«Ê×ÏÈÐèÒª°ÑÕâ¸öÎļþ¸´ÖƵ½/etc/my.cnfÎļþÉÏ¡£


Ïà¹ØÎĵµ£º

±È½Ï²»´íµÄmysql²Ù×÷Àà

<?php
/*
 * by:lenush
 * qicq:707207845
 * email:lenus-h@163.com
 * site:www.hackthiswebsite.cn
 * that's all
 *
 */ 
class mysql{
 
 private $db_host;  //Êý¾Ý¿âÖ÷»ú
 private $db_user;  //Êý¾Ý¿âÓû§Ãû
 private $d ......

ÅäÖÃMySQLÊý¾Ý¿âË«»úÈȱ¸·Ý£¨×ª£©

      1¡¢mysql Êý¾Ý¿âûÓÐÔöÁ¿±¸·ÝµÄ»úÖÆ£¬µ±Êý¾ÝÁ¿Ì«´óµÄʱºò±¸·ÝÊÇÒ»¸öºÜ´óµÄÎÊÌâ¡£»¹ºÃ mysql Êý¾Ý¿âÌṩÁËÒ»ÖÖÖ÷´Ó±¸·ÝµÄ»úÖÆ£¬Æäʵ¾ÍÊǰÑÖ÷Êý¾Ý¿âµÄËùÓеÄÊý¾Ýͬʱдµ½±¸·ÝÊý¾Ý¿âÖС£ÊµÏÖ mysql Êý¾Ý¿âµÄÈȱ¸·Ý¡£
¡¡¡¡2¡¢ÒªÏëʵÏÖË«»úµÄÈȱ¸Ê×ÏÈÒªÁ˽âÖ÷´ÓÊý¾Ý¿â·þÎñÆ÷µÄ°æ±¾µÄÐèÇó¡£ÒªÊµÏ ......

railsʹÓÃsqlite3ºÍmysqlµÄÎÊÌâ

1¡¢Èç¹ûʹÓÃsqlite3ʱ³öÏÖÈçÏ´íÎó£º
/!\ FAILSAFE /!\  Thu Jul 30 22:16:15 +0800 2009
  Status: 500 Internal Server Error
  unknown error
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'
    c:/ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'
&nb ......

mysql JDBC URL¸ñʽ¼°Æä²ÎÊý˵Ã÷

×î½üÓöµ½ÕâÑùµÄÎÊÌâ
»á±¨at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQuery ......

mysql ÒÅÍüÃÜÂëºóÖØÐÂÉèÖÃÃÜÂë²½Öè

1. ÓÃcmd½øÈëmysql/binĿ¼
2. ÊäÈëmysqld-nt --skip-grant-tables
3. ÐÂÆôcmd ÊäÈëmysqladmin -u root flush-privileges password root
4. mysqladmin -u root -p shutdown
5. ÊäÈëеÄÃÜÂ룺XXX
6.ÐÞ¸ÄÃÜÂë³É¹¦ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ