The Solr *Optimize Now* Button for Sitecore Use Cases

/ Konkretor / Leave a comment

Sitecore Architecture

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:

OptimizeNow.JPG

The inclusion of the badcauses 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 badicon 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

bash script mysql commands

/ Konkretor / Leave a comment

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

Found here

https://www.shellhacks.com/mysql-run-query-bash-script-linux-command-line/

https://alvinalexander.com/mysql/how-save-output-mysql-query-file/

the ‘information_schema global_status feature is disabled

/ Konkretor / Leave a comment

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)

How to create overlay networks using Linux Bridges and VXLANs

/ Konkretor / Leave a comment

I Learned How To...

Some time ago, I learned How to create a overlay network using Open vSwitch in order to connect LXC containers. Digging in the topic of overlay networks, I saw that linux bridges had included VXLAN capabilities, and also saw how some people were using it to create overlay networks in a LAN. As an example, it is made in this way in the OpenStack linux bridges plugin. So I decided to work by hand in this topic (in order to better understand how OpenStack was working) and learned…

How to create overlay networks using Linux Bridges and VXLANs

Well, I do not know when OpenStack started to use overlay networks using Linux Bridges, but as I started to search for information on how to do it by hand, I realized that it is a widespread topic. As an example, I found this post from VMWare that is a must if…

View original post 2,177 more words

windows start service without admin rights

/ Konkretor / Leave a comment

You need not really administrator rights to restart a service.

You can find here many options for that

https://stackoverflow.com/questions/4436558/start-stop-a-windows-service-from-a-non-administrator-user-account

In this post on stackoverflow I found a very simple solution to do that.

This little tool are called Service Security Editor and works very well.

https://www.coretechnologies.com/products/ServiceSecurityEditor/