Сегодня наконец решил проблему.
Нужно было добавить в конфигурацию домена
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; }
Благодарю за помощь. К сожалению, пока не получается разобраться в проблеме. Попробую еще погуглить.
Базу данных отредактировал с помощью Adminer (спасибо за подсказку), но все же хочется настроить phpmyadmin, тем более, что он работал.
На всякий случай выложу тут конфиг домена, возможно там что-то напутано
server { if ($http_user_agent ~ SputnikBot|Crowsnest|PaperLiBot|peerindex|ia_archiver|Slurp|Aport|NING|JS-Kit|rogerbot|BLEXBot|MJ12bot|Twiceler|Baiduspider|Java|CommentReader|Yeti|discobot|BTWebClient|Tagoobot|Ezooms|igdeSpyder|AhrefsBot|Teleport|Offline|DISCo|netvampire|Copier|HTTrack|WebCopier) { return 403; } listen ххх.хх.ххх.ххх:80; server_name ххххххх.ххх; server_name_in_redirect off; access_log /var/www/httpd-logs/ххххххх.ххх.access.log; error_log /var/www/httpd-logs/ххххххх.ххх.error.log notice; root /var/www/ххххххх/data/www/ххххххх.ххх; index index.php index.html index.htm default.html default.htm; # Support Clean (aka Search Engine Friendly) URLs location / { try_files $uri $uri/ /index.php?$args; } # deny running scripts inside writable directories location ~* /(images|cache|media|logs|tmp)/.*\.(php|pl|py|jsp|asp|sh|cgi)$ { return 403; error_page 403 /403_error.html; } location ~ \.php$ { fastcgi_pass unix:/var/www/php-fpm/ххххххх.sock; fastcgi_index index.php; include fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; include /etc/nginx/fastcgi_params; } # caching of files location ~* \.(ico|pdf|flv)$ { expires 1y; } location ~* \.(js|css|png|jpg|jpeg|gif|swf|xml|txt)$ { expires 14d; } }
nginx перезапускал
по http://ipадрес/phpmyadmin/ дальше 404 ошибка
кэш nginx не знаю как сбросить, даже не вижу директории, где бы он должен был быть
Сделал так. К сожалению, без изменений.
server { listen IPАДРЕС:80 default_server; location / { root /usr/share/; } }
в /usr/share/ у меня находится папка phpMyAdmin