If you have a SQL cluster under heavy load you can use proxy sql but is nowhere an alternative software? Of course last month was publish ReadySet comes with a nice a GUI to analyze your cache.
If you have multi servers Linux Distribution and should check only Ubuntu. Then you can use this script to select the os and if only match the OS then execute the command.
##!/bin/bash if [ -e "/etc/issue" ] ; then issue=`cat /etc/issue` set -- $issue if [ $1 = "Ubuntu" ] ; then nginx -v 2>&1 | grep -o 1.* | cut -c1-6 fi fi
If you are using Magento 2 and you got this 500 error from admin login page. Your Content Security Policy header are too long. Use Nging or reduce your headers.
Problem is AP_IOBUFSIZE cannot be changed by a conf file it is hardcoded in to the sourcecode. You have only 8192 Bytes and this os offen to low. If you reach this limit your apache willcrash and restart.
Look at the Bugzilla from Apache Webserver
How to enable php oauth with curl support.
apt remove php-oauth php7.4-oauth
php_ini `php7.4 --ini |
pecl uninstall oauth
If you’ve worked with Sitecore and Solr, you’re no stranger to the Solr Admin UI. There are great aspects to that UI, and some exciting extension points with Sitecore implications too, but I know one element of that Solr UI that causes some head-scratching . . . the “optimize now” feature:
The inclusion of the causes people to think “something is wrong . . . red bad . . . must click now!”
What is this Optimize?
I’m writing this for the benefit of Sitecore developers who may not be coming at this from a deep search background: do not worry if your Solr cores show this icon encouraging you to optimize now. Fight that instinct. For standard Sitecore Solr cores that are frequently updating, such as the sitecore_core_index, sitecore_master_index, sitecore_analytics_index, and — depending on your publishing strategy — sitecore_web_index, one may notice these…
View original post 696 more words
SSHFS is no longer maintained what can be used for alternative in this situation. Look at this Project GVfs from Gnome.
gio mount ssh://IP/
gio mount -u ssh://
I want to use this script to run with Ansible. My requirements were to read the maximum connections in mysql server. Also I want to write the output from mysql client in to a file.
You can use
mysql -e "show status like 'max_used_connections';" Or you can use
mysql <<EOF tee /tmp/mysql_max.txt show variables like 'max_connections'; show status like 'max_used_connections'; EOF output
Logging to file '/tmp/mysql_max.txt' Variable_name Value max_connections 100 Variable_name Value Max_used_connections 10
You can use following script to open programs on the right screen
If you want to import a MySQL dump in to your MySQL server 5.7 and you got following error
The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
Login in to your mysql root console and send this command to your mysql server
set @@global.show_compatibility_56=ON; SHOW VARIABLES LIKE '%compatibility%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | show_compatibility_56 | ON | +-----------------------+-------+ 1 row in set (0.00 sec)
Create a file under /etc/apache2/conf-enabled with following content
Header Set X-Robots-Tag “noindex, nofollow, noarchive, nosnippet”
Check your config with wget –server-response –spider example.com