Êý¾Ý¿âÓÅ»¯
Ë÷Òý£ºÈ·±£ÔÚÊý¾Ý¿âÖÐÌí¼ÓÁËÊʵ±µÄË÷Òý£¬ÒÔ¼ÓËÙÅÌÎÊËÙ¶È¡£¿ÉÒÔʹÓÃÒÔÏÂÃüÁî¼ì²é±íµÄË÷ÒýÇé¿ö£ºSHOWINDEXFROMyour_table;ÅÌÎÊÓÅ»¯£º¼ì²é²¢ÓÅ»¯ÂýÅÌÎÊ¡£¿ÉÒÔʹÓÃÒÔÏÂÃüÁîÆôÓÃÂýÅÌÎÊÈÕÖ¾£ºSETglobalslow_query_log='ON';SETgloballong_query_time=2;
È»ºó¼ì²ìÂýÅÌÎÊÈÕÖ¾Îļþ£¨Í¨³£ÔÚ/var/log/mysql/slow.log£©£¬ÕÒ³ö²¢ÓÅ»¯ÂýÅÌÎÊ¡£
Êý¾Ý¿âÁ¬½Óʧ°Ü
Èç¹ûÍøÕ¾ÔÚÆô¶¯Ê±ÌáʾÊý¾Ý¿âÁ¬½Óʧ°Ü?£¬¿ÉÒÔͨ¹ýÒÔϰ취ÅŲ飺
È·ÈÏÊý¾Ý¿âЧÀÍÆ÷ÊÇ·ñÕý³£ÔËÐУ¬Ê¹ÓÃÃüÁîsudosystemctlstatusmysql¼ì²é¡£¼ì²éÊý¾Ý¿âÅäÖÃÎļþÖеÄÊý¾Ý¿âÁ¬½ÓÐÅÏ¢ÊÇ·ñÕýÈ·¡£È·ÈÏÊý¾Ý¿âÓû§µÄȨÏÞÊÇ·ñ×ã¹»£¬¿ÉÒÔʹÓÃÒÔÏÂÃüÁGRANTALLPRIVILEGESONyour_database.*TO'your_user'@'localhost'IDENTIFIEDBY'your_password';FLUSHPRIVILEGES;
×ܽá
ͨ¹ýÒÔÉϰ취£¬ÄúÓ¦¸ÃÄܹ»Ë³Àû°²?×°²¢?ÔËÐоþÃÎçÒ¹×ÛºÏÍøÕ¾£¬²¢ÇÒ¶Ô³£¼ûµÄÎÊÌâÓлù±¾µÄÅŲéÒªÁì¡£ÎÞÂÛÄúÊǼ¼ÊõÐÂÊÖÕÕ¾ÉÓÐÒ»¶¨¾ÑéµÄÍøÕ¾ÔËÓªÕߣ¬±¾ÎÄÌṩµÄÖ¸µ¼¶¼½«ÎªÄúÌṩ×ÊÖú¡£Èç¹ûÔÚ×°ÖÃÀú³ÌÖÐÓöµ½ÆäËûÎÊÌ⣬½¨Òé²éÔĹٷ½Îĵµ»òѰÇóרҵ¼¼ÊõÖ§³Ö¡£
Ï£Íû±¾ÎÄÄÜΪÄúÌṩÓмÛÖµµÄÐÅÏ¢£¬×£ÄúÍøÕ¾Ë³ÀûÔËÐв¢È¡µÃÀֳɣ¡
ЧÀÍÆ÷Çé¿ö×¼±¸
ҪװÖþþÃÎçÒ¹×ÛºÏÍøÕ¾£¬Ê×ÏÈÐèÒªÒ»¸ö¾ß±¸ÒÔÏÂÇé¿öµÄЧÀÍÆ÷£º
²Ù×÷ϵͳ£ºÍƼöʹÓÃLinuxЧÀÍÆ÷£¬ÈçCentOS»òUbuntu¡£WebЧÀÍÆ÷£º°²?×°²¢?ÅäÖúÃApache»òNginx¡£Êý¾Ý¿â£º×°Öò¢ÅäÖúÃMySQL»òMariaDB¡£PHP°æ±¾£º½¨ÒéʹÓÃPHP7.4»òÒÔÉϰ汾¡£
ginxÅäÖÃ
server{listen80;server_nameyourdomain.com;root/path/to/webroot/;indexindex.phpindex.htmlindex.htm;location/{try_files$uri$uri/=404;}location~\.php${includesnippets/fastcgi-php.conf;fastcgi_passunix:/var/run/php/php7.4-fpm.sock;}location~/\.ht{denyall;}}
ÔÚPHPÅäÖÃÎļþphp.iniÖÐÆôÓÃOPcache£ºzend_extension=opcache.soopcache.enable=1opcache.memory_consumption=128opcache.interned_strings_buffer=8opcache.max_accelerated_files=4000opcache.revalidate_freq=60opcache.fast_shutdown=1
Èç¹ûÍøÕ¾ÌáʾÎļþȨÏÞȱ·¦£¬¿ÉÒÔͨ¹ýÒÔϰ취ÅŲ飺
È·ÈÏÎļþºÍĿ¼µÄËùÓÐȨºÍȨÏÞÊÇ·ñÕýÈ·¡£¿ÉÒÔʹÓÃÃüÁîsudochown-Rwww-data:www-data/var/www/html/jjwzºÍsudochmod-R755/var/www/html/jjwzÀ´ÉèÖÃȨÏÞ¡£
ͨ¹ýÒÔÉϰ취£¬ÄãÓ¦¸ÃÄܹ»Ë³ÀûÍê³É¾Ã¾ÃÎçÒ¹×ÛºÏÍøÕ¾µÄ×°Ö㬲¢½â¾ö³£¼ûµÄ¹ÊÕÏÎÊÌâ¡£×£ÄãÍøÕ¾ÔËÐÐ˳Àû£¡
¼ÌÐø´ÓÉÏÒ»²¿·ÖµÄ×°Öð취ÖÐÎÒÃÇÒѾÏêϸ½éÉÜÁËÈçºÎ¿ìËÙ×°ÖþþÃÎçÒ¹×ÛºÏÍøÕ¾£¬²¢ÌṩÁ˳£¼û¹ÊÕϵÄÅŲéÒªÁì¡£±¾ÆªÎÄÕ½«½øÒ»²½ÉîÈë̽ÌÖ¸ü¶à×°ÖúÍÔËÓªµÄϸ½Ú£¬×ÊÖúÄã¸üºÃµØÕÆÎÕÕâ¿îÇ¿´óµÄÍøÕ¾Èí¼þ¡£
У¶Ô£º·ëΰ¹â(1C0m4pJyqZtPma0S7t9ZFfz4hTykKag)


