[collectd] MySQL collectd plugin replicaton client grant on *.*

Stuart Cracraft smcracraft at me.com
Wed Oct 8 23:03:17 CEST 2014


Hi Pavel,

We now have this up and understand. 

Great stuff.

I don't see seconds behind master
available. 

This is from the collectdctl listval:

mysql-mysql/cache_result-qcache-hits
mysql-mysql/cache_result-qcache-inserts
mysql-mysql/cache_result-qcache-not_cached
mysql-mysql/cache_result-qcache-prunes
mysql-mysql/cache_size-qcache
mysql-mysql/mysql_commands-admin_commands
mysql-mysql/mysql_commands-begin
mysql-mysql/mysql_commands-change_db
mysql-mysql/mysql_commands-commit
mysql-mysql/mysql_commands-create_user
mysql-mysql/mysql_commands-delete
mysql-mysql/mysql_commands-grant
mysql-mysql/mysql_commands-insert
mysql-mysql/mysql_commands-release_savepoint
mysql-mysql/mysql_commands-rollback_to_savepoint
mysql-mysql/mysql_commands-savepoint
mysql-mysql/mysql_commands-select
mysql-mysql/mysql_commands-set_option
mysql-mysql/mysql_commands-show_create_db
mysql-mysql/mysql_commands-show_create_table
mysql-mysql/mysql_commands-show_databases
mysql-mysql/mysql_commands-show_fields
mysql-mysql/mysql_commands-show_grants
mysql-mysql/mysql_commands-show_slave_status
mysql-mysql/mysql_commands-show_status
mysql-mysql/mysql_commands-show_table_status
mysql-mysql/mysql_commands-show_tables
mysql-mysql/mysql_commands-show_triggers
mysql-mysql/mysql_commands-show_variables
mysql-mysql/mysql_commands-unlock_tables
mysql-mysql/mysql_commands-update
mysql-mysql/mysql_handler-commit
mysql-mysql/mysql_handler-delete
mysql-mysql/mysql_handler-external_lock
mysql-mysql/mysql_handler-prepare
mysql-mysql/mysql_handler-read_first
mysql-mysql/mysql_handler-read_key
mysql-mysql/mysql_handler-read_last
mysql-mysql/mysql_handler-read_next
mysql-mysql/mysql_handler-read_prev
mysql-mysql/mysql_handler-read_rnd
mysql-mysql/mysql_handler-read_rnd_next
mysql-mysql/mysql_handler-savepoint
mysql-mysql/mysql_handler-savepoint_rollback
mysql-mysql/mysql_handler-update
mysql-mysql/mysql_handler-write
mysql-mysql/mysql_locks-immediate
mysql-mysql/mysql_locks-waited
mysql-mysql/mysql_log_position-slave-exec
mysql-mysql/mysql_log_position-slave-read
mysql-mysql/mysql_octets
mysql-mysql/threads-cached
mysql-mysql/threads-connected
mysql-mysql/threads-running
mysql-mysql/time_offset
mysql-mysql/total_threads-created

How can I get the seconds behind
master?

Thanks Pavel!!!

Stuart



> On Oct 8, 2014, at 9:00 AM, Pavel V. <pavel2000 at ngs.ru> wrote:
> 
> "Seconds_Behind_Master



More information about the collectd mailing list