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ÎļþÉÏ¡£
Ïà¹ØÎĵµ£º
<?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ÊÖ²áÀïÃæÓÐÒ»¶ÎÃèÊö¹ØÓÚlock tablesµÄÓï·¨µÄ. LOCK TABLES
tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}
[, tbl_name [AS alias] {READ [LOCAL] | [LOW_PRIORITY] WRITE}] ...
UNLOCK TABLES
READ
µ±±í²»´æÔÚ WRITE Ð´ËøÊ± READ ¶ÁËø±»Ö´ÐÐ,Õâ¸Ã ......
2008Äê2Ô±»SunÒÔ10ÒÚÃÀÔªÊÕ¹ºµÄMySQL£¬Ç°Â·ÈÔÈ»ÄÑÁÏ¡£¶ÔÓÚ´ó¼ÒÀ´Ëµ£¬±È½ÏÓÐÒâ˼µÄÊÇ£¬10ÔÂ27ÈÕ£¬Red HatÐû²¼ÒÔ1900ÍòÃÀԪע×Ê¿ªÔ´Êý¾Ý¿â³§ÉÌ—EnterpriseDB¡£ÏûÏ¢Ò»³ö£¬Á¢¿Ì±»Òµ½ç½â¶ÁΪRed HatÁí±Ùõè¾¶·¢Õ¹¿ªÔ´Êý¾Ý¿â£¬²»ÏëÒÔºóÊÜÖÆÓÚOracleºÍMySQL¡£
Èç¹ûMySQLµÄ´óÆìµ¹ÏÂÁË£¬ÖÚ¶àÁ¦Á¿·ÖÉ¢ÇÒÈõСµÄ¿ªÔ´Êý¾Ý¿â½«Õ¹¿ª ......
ÓÐʱºòΪÁË·½±ã£¬ÀûÓÃevent/triggerµ÷ÓÃϵͳÍⲿÃüÁ¿ÉÒòΪ°²È«ÎÊÌ⣬mysql×ÔÉí²¢Ã»ÓÐÌṩÏà¹ØÃüÁÕâÀïÌṩ¸öµ÷ÓÃϵͳÃüÁîµÄ×Ô¶¨Ò庯Êýmylab_sys_exec
soÎļþÏÂÔØ:mylab_sys_exec.so ( mysql5.1.34 ²âÊÔͨ¹ý)
¼ÓÔØ:
CREATE FUNCTION mylab_sys_exec RETURNS INTEGER SONAME "mylab_sys_exec.so";
ʹÓÃ:
SELECT myl ......
ĿǰLAMP (Linux + Apache + MySQL + PHP) ½ü¼¸ÄêÀ´·¢Õ¹Ñ¸ËÙ£¬ÒѾ³ÉΪWeb ·þÎñÆ÷µÄÊÂʵ±ê×¼¡£LAMP
Õâ¸ö´ÊµÄÓÉÀ´×îÔçʼÓڵ¹úÔÓÖ¾“c't Magazine”£¬Michael KunzeÔÚ1990Äê×îÏȰÑÕâЩÏîÄ¿×éºÏÔÚÒ»Æð´´ÔìÁËLAMPµÄËõд×Ö¡£ÕâЩ×é¼þËäÈ»²¢²»ÊÇ¿ª¿ªÊ¼¾ÍÉè¼ÆÎªÒ»ÆðʹÓõ쬵«ÊÇ£¬ÕâЩ¿ªÔ´Èí¼þ¶¼¿ÉÒԺܷ½±ã µÄË ......