Нужно было написать копирайт и частично рерайт для одного бизнес сайта. Все было сделано качественно и быстро. Планирую и дальше сотрудничать с ТС. Спасибо.
Был бы благодарен, если бы Вы мне помогли написать конфиг nginx, чтобы заблокировать Китай. В интернете очень много разных вариантов, боюсь что-то напутать. Заранее спасибо.
Спасибо, но если там не только Китай. Интересно, какие еще есть методы. Лимиты в nginx и тому подобное.
Сегодня наконец решил проблему.
Нужно было добавить в конфигурацию домена
include /etc/nginx/vhosts-includes/*.conf;include /etc/nginx/vhosts-resources/домен.info/*.conf;
KVM.
Количество процессов 133 Оперативная память (использовано / всего) 608 / 1839 MiB Продолжительность работы 2 hours 30 minutes Процессор 2 X QEMU Virtual CPU version 2.5+ 2599.998 MHz Размер дискового пространства 14.62 GiB Средняя загрузка (за 15 мин, 5 мин, 1 мин) 2.21 2.46 2.66 Файл подкачки (swap) 0 MiB
1 сайт на joomla. 200-300 человек в день.
Попробую обновить MariDB, если получится.
Да, VDS.Пока поменял:
innodb_buffer_pool_size=500M
max_connections=20
mysqltuner
Performance Metrics ------------------------------------------------- [--] Up for: 4m 14s (36K q [145.382 qps], 1K conn, TX: 119M, RX: 7M) [--] Reads / Writes: 93% / 7% [--] Binary logging is disabled [--] Total buffers: 1.1G global + 10.7M per thread (20 max threads) [OK] Maximum reached memory usage: 1.2G (65.75% of installed RAM) [OK] Maximum possible memory usage: 1.3G (74.44% of installed RAM) [OK] Slow queries: 0% (0/36K) [OK] Highest usage of available connections: 25% (5/20) [OK] Aborted connections: 0.10% (1/1023) [OK] Query cache efficiency: 47.9% (27K cached / 56K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 286 sorts) [!!] Joins performed without indexes: 9 [!!] Temporary tables created on disk: 98% (1K on disk / 1K total) [OK] Thread cache hit rate: 99% (5 created / 1K connections) [OK] Table cache hit rate: 110% (265 open / 239 opened) [OK] Open file limit used: 1% (273/16K) [OK] Table locks acquired immediately: 100% (5K immediate / 5K locks) -------- MyISAM Metrics ----------------------------------------------------- [!!] Key buffer used: 18.4% (24M used / 134M cache) [OK] Key buffer size / total MyISAM indexes: 128.0M/21.4M [OK] Read Key buffer hit rate: 97.0% (5K cached / 172 reads) [!!] Write Key buffer hit rate: 50.0% (6 cached / 3 writes) -------- InnoDB Metrics ----------------------------------------------------- [--] InnoDB is enabled. [OK] InnoDB buffer pool / data size: 500.0M/150.4M [OK] InnoDB buffer pool instances: 1 [!!] InnoDB Used buffer: 6.38% (2040 used/ 31999 total) [OK] InnoDB Read buffer efficiency: 99.15% (225893 hits/ 227840 total) [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total) [OK] InnoDB log waits: 0.00% (0 waits / 1683 writes) -------- AriaDB Metrics ----------------------------------------------------- [--] AriaDB is disabled. -------- Replication Metrics ------------------------------------------------- [--] No replication slave(s) for this server. [--] This is a standalone server.. -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Enable the slow query log to troubleshoot bad queries Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries which have no LIMIT clause Variables to adjust: join_buffer_size (> 8.0M, or always use indexes with joins) tmp_table_size (> 256M) max_heap_table_size (> 128M)
Спасибо. Вы правы.
phpmyadmin.conf
Alias /phpmyadmin /usr/share/phpMyAdmin <Directory /usr/share/phpMyAdmin> <IfModule itk.c> AssignUserID apache apache </IfModule> <IfModule mpm_itk_module> AssignUserID apache apache </IfModule> Order allow,deny Allow from all Options FollowSymLinks DirectoryIndex index.php <IfModule php5_module> AddType application/x-httpd-php .php .php3 .php4 .php5 .phtml <IfVersion >= 2.4> # Bug on centos-7 with open_basedir restriction and doc/html/index.html check php_flag error_reporting E_NONE </IfVersion> php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_admin_flag allow_url_fopen Off php_admin_flag engine on php_value include_path . php_admin_value upload_tmp_dir /tmp php_admin_value open_basedir "/usr/share/phpMyAdmin/:/etc/phpMyAdmin/:/var/lib/phpMyAdmin/upload:/tmp/:/usr/share/php/:/var/lib/php/session/:/opt/php53/share/pear:/opt/php54/share/pear:/opt/php55/share/pear:/opt/php56/share/pear" php_admin_value session.save_path "/var/lib/php/session" php_admin_value mbstring.func_overload 0 </IfModule> <IfModule php7_module> AddType application/x-httpd-php .php .php3 .php4 .php5 .phtml <IfVersion >= 2.4> # Bug on centos-7 with open_basedir restriction and doc/html/index.html check php_flag error_reporting E_NONE </IfVersion> php_flag magic_quotes_gpc Off php_flag track_vars On php_flag register_globals Off php_admin_flag allow_url_fopen Off php_admin_flag engine on php_value include_path . php_admin_value upload_tmp_dir /tmp php_admin_value open_basedir "/usr/share/phpMyAdmin/:/etc/phpMyAdmin/:/var/lib/phpMyAdmin/upload:/tmp/:/usr/share/php/:/var/lib/php/session/:/opt/php70/share/pear:/opt/php71/share/pear" php_admin_value session.save_path "/var/lib/php/session" </IfModule> RemoveHandler .php .php3 .php4 .phtml <FilesMatch "\.ph(p[3-5]?|tml)$"> SetHandler application/x-httpd-php </FilesMatch> <IfVersion >= 2.4> AllowOverride None Require all granted </IfVersion> </Directory> <Directory /usr/share/phpMyAdmin/setup> <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require all denied </RequireAny> </IfModule> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow Deny from All </IfModule> </Directory>
ispmgr.conf
WebUser apache WebGroup apache Option UsageStatAgree Option FirewalCountriesLoaded Option EnableWebTemplate Option AltPhpFpmUpgraded Option EULA Option ApsRepositoryUpdated Option NameVirtualHostDropped PWStrength 2 Firewall iptables MailMode none WebModules nginx apache SlaveNSManagement core ExpireLogsDays 365 ForwardedSecret ucyvq5G0SD99ECeY path secure-private-key /usr/local/mgr5/etc/ispmgr.pem path rh-iptables-save /usr/libexec/iptables/iptables.init save path rh-ip6tables-save /usr/libexec/iptables/ip6tables.init save path isp-php56_cgi-bin /opt/php56/bin/php-cgi path isp-php56_ini /opt/php56/etc/php.ini
/etc/apache2/conf.d/phpmyadmin-apache.conf - не вижу такого, у меня nginx
location /phpmyadmin { alias /usr/share/phpMyAdmin; index index.php; } location ~* ^/phpmyadmin/(.+\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ { alias /usr/share/phpMyAdmin/$1; error_page 404 @apache; } location ~ ^/phpmyadmin/(.+\.php)$ { alias /usr/share/phpMyAdmin/$1; fastcgi_pass unix:/var/run/php-fpm.apache.sock; fastcgi_index index.php; fastcgi_param SCRIPT_FILENAME $request_filename; include fastcgi_params; error_page 502 = @apache; error_page 404 = @apache; } location @apache { error_log /dev/null crit; proxy_pass http://127.0.0.1:8080; proxy_redirect http://127.0.0.1:8080 /; proxy_set_header Host $host; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header X-Forwarded-Proto $scheme; } location ^~ /phpmyadmin/setup { deny all; }
