It's dead simple, just schedule a crontab with this line:
mysql -u root -p
This will query the slave status, grep the most important line and send you an email.
Hope this help
In case you want to watch the most important parameters of your memcache installation you can use this basic shell script:
watch "echo stats | nc 127.0.0.1 11211 |grep -v conn_yields |grep -v time|grep -v cmd|grep -v threads \
|grep -v evictions|grep -v reclaimed|grep -v auth|grep -v pointer_size|grep -v accepting_conns \
|grep -v bytes_read|grep -v bytes_written|grep -v badval|grep -v structures|grep -v pid \
|grep -v version|grep -v rusage|grep -v incr|grep -v decr|grep -v listen|grep -v cas \
|grep -v total_connections|grep -v delete|grep -v total_items|grep -v END"
It shows the most important parameters every two seconds ignoring the other ones, you can tune the showed params removing grep -v commands at your will.
Enjoy!
Com cada any publico un resum del que ha estat el 2014 en diferents categoríes, sobretot com a recordatori personal.
No edito gaire perquè els nens estàn a punt de llevar-se :)
Gadgets of the year (comprats o regalats):
Xarxa PLC amb Wifi
Impressora HP Deskjet Wifi
Samarretes del any:
Piedra, papel, tijera, lagarto, spock
Friky coses guays:
mailgun
mandrill
telegram
que seth macfarlane (padre de familia) es productor del nou Cosmos
que el prota de Prison Break es el guionista d'Stoker
Jacob Dhein mola molt
Kibana
red herring (literalment arenque rojo, metaforicament pista falsa)
Jocs als que m'he viciat aquest any:
StarWars Commander
Grups guays que he descobert aquest any:
Desert
Millors concerts als que he anat:
Arcade Fire
Pixies
Millors pelis que he vist:
The wolf of wall street
django unchained
Magnolia
Las brujas de zagarramurdi
