MySQL monitoring & alerting

after: 
MonYog - paravi ista firma koja pravi i Sql Yog. Ima dosta mogucnosti preko web admin konzole ali mi nije nesto zapao za oko plus nije free.

after:
MySQL Enterprise monitor - nisam probao da se ne bih navukao :) i plus nije free.

after:
Neki osnovni do solidni advanced mysql monitoring ukljucujuci i monitoring samog OS se moze elegantno i dzabe izvesti i automatizovati sa shell skriptama koje prate mysql (da li je mysql UP, broj konekcija, stanje mysql/variabli, backup, provera backup...neogranicen broj mogucnosti uz mail notifikaciju za svaki problematicni slucaj + korektivne akcije za pojedine od njih) + pojedinacne shell skripte ili u okviru postojecih za pracenje OS - CPU, HDD, RAM, deo vezan za security, neovlasceni pristup ili pokusaj pristupa.

after:
E sada meni to lepo sve radi sa mysql serverima koji su na unix/linix OS. Imam problem sa mysql koji je na Windows OS. Sto se tice samog mysql DB monitoringa koji je na windowsu to nije problem. Problem mi je kako da radim monitoring Windows hosta (CPU, HDD, RAM,..) bilo lokalno bilo remote a da ne koristim (meni odbojne) VB skripte i VB jezik. Za HDD sam se nekako i snasao, mapiram/mountujem Windows particiju sa recimo CentOS ali za CPU i RAM a tek za security nemam pojam kako to da izvedem, nebitno da li koristeci windows bat scripting - samo da ne bude VB :). Probacu nesto sa Win power shell skriptama, pretpostavljam da je blizak logici/sintaksi bourne unix shell-a (nadam se da jeste).

after:
Takodje mi deluje kao super free resenje Nagios koji ima hrpu pluginova za mysql, radi monitoring hostova Windows/Linux plus moze da se postavi kao sveobuhvatno resenje za sve DB tipove: MySQL, MS SQL, Oracle, PostgreSQL,.. i za svaki OS. Jedino izgleda da je instalacija/konfigurisanje malo komplikovana i zahteva malo vise vremena da se savlada administracija.

nagios je golo ****o .. probaj zabbix :D 10000000x je bolji ja na primer sa njim monitorijem nginx, glassfish, apache, mysql, memcached i svasta jos nesto ..

Data Collected

Default install includes db named 'test'
MySQL: Accounts or Users excessive revokes
MySQL: Accounts with Alter privileges
MySQL: Accounts with blank host or wildcard specifiers
MySQL: Accounts with blank password
MySQL: Accounts with blank usernames
MySQL: Accounts with Delete privileges
MySQL: Accounts with Drop privileges
MySQL: Accounts with File privileges
MySQL: Accounts with Grant privileges
MySQL: Accounts with Insert privileges
MySQL: Accounts with Lock privileges
MySQL: Accounts with Process privileges
MySQL: Accounts with Shut Down privileges
MySQL: Accounts with Super privileges
MySQL: Accounts with Update privileges
MySQL: Architecture: Hardware supports total memory
MySQL: Architecture: Max mem MySQL could use
MySQL: Architecture: MySQL max mem over 32-bit capabilities
MySQL: Architecture: MySQL may use more memory than available
MySQL: Available
MySQL: Binlog: Cache size
MySQL: Binlog: Is enabled
MySQL: Binlog: Number of transactions that use the cache
MySQL: Binlog: Sync to disk each write
MySQL: Binlog: Transactions over binlog_cache_size
MySQL: Change innodb_additional_mem_pool_size
MySQL: Change innodb_buffer_pool_size
MySQL: Change innodb_log_buffer_size
MySQL: Change innodb_log_file_size
MySQL: Change key_buffer_size
MySQL: Change key_buffer_size
MySQL: Change query_cache_size
MySQL: Change read_buffer_size
MySQL: Change read_rnd_buffer_size
MySQL: Change sort_buffer_size
MySQL: Change table_cache
MySQL: Change tmp_table_size
MySQL: Clients: Count terminated abnormally
MySQL: Config: Expire log days
MySQL: Config: Files open vs. max allowed %
MySQL: Config: Idle time before client disconnected
MySQL: Config: Launch time for a slow thread
MySQL: Config: LOAD DATA LOCAL is insecure
MySQL: Config: Log queries w/o an index
MySQL: Config: Log slow queries
MySQL: Config: No password on root
MySQL: Config: Old password authentication allowed
MySQL: Config: Old passwords supported
MySQL: Config: Query exec and parsing buffer
MySQL: Config: Root account present
MySQL: Config: root login enabled
MySQL: Config: sql_mode
MySQL: Config: symlinks are enabled
MySQL: Config: Time before a query is 'slow'
MySQL: Config: Tmp table max size in-memory
MySQL: Config: Users can view all databases
MySQL: Connections: Max allowed
MySQL: Connections: Maximum ever used %
MySQL: Connections: Maximum number used
MySQL: Connections: Number aborted
MySQL: Connections: Percent of total used
MySQL: Connections: Refused
MySQL: Connections: Successful
MySQL: Connections: Total
MySQL: Current version
MySQL: Daily Controller
MySQL: InnoDB: Buffer used to store internal structures
MySQL: InnoDB: Buffer_pool size
MySQL: InnoDB: Data vs. buffer size %
MySQL: InnoDB: How to flush logs
MySQL: InnoDB: Log buffer size for tables
MySQL: InnoDB: Log writes to wait %
MySQL: InnoDB: Number of files in log group
MySQL: InnoDB: Percent hit rate of cache

MySQL: InnoDB: Percent of cache writes to wait
MySQL: InnoDB: Size of file in each log group
MySQL: InnoDB: Total size of log files

MySQL: Joins average not using indices per day
MySQL: Joins buffer size requiring full table scan
MySQL: Joins not using indices
MySQL: Last error number generated
MySQL: Last error string

MySQL: Live Controller
MySQL: MyISAM: Block size of the key buffer
MySQL: MyISAM: Buffer size for full-table scans
MySQL: MyISAM: Crashes not auto corrected
MySQL: MyISAM: Key block write requests
MySQL: MyISAM: Key buffer size
MySQL: MyISAM: Key cache blocks
MySQL: MyISAM: Key cache blocks requested
MySQL: MyISAM: Key cache blocks used
MySQL: MyISAM: Key cache Hit ratio %
MySQL: MyISAM: Key cache in use %
MySQL: MyISAM: Key cache write ratio %
MySQL: MyISAM: Key writes
MySQL: MyISAM: Number of reads of a key block from disk
MySQL: MyISAM: Sort buffer to rebuilding index after repair
MySQL: Network bytes received
MySQL: Network bytes sent
MySQL: Number of database alterations
MySQL: Number of database creations
MySQL: Number of databases dropped
MySQL: Number of functions created
MySQL: Number of functions dropped
MySQL: Number of indices created
MySQL: Number of indices dropped
MySQL: Number of permissions granted
MySQL: Number of recent schema changes
MySQL: Number of table alterations
MySQL: Number of tables created
MySQL: Number of tables dropped
MySQL: Number of users dropped
MySQL: Queries: % Deletes of overall
MySQL: Queries: % Full table scans
MySQL: Queries: % Inserts of overall
MySQL: Queries: % Selects of overall queries
MySQL: Queries: % Sorts requiring tmp tables
MySQL: Queries: % transactions saved to disk
MySQL: Queries: % Updates of overall queries
MySQL: Queries: % Write of overall queries
MySQL: Queries: Average rows returned
MySQL: Queries: Buffer used for ORDER BY
MySQL: Queries: Joins w/ full table scans of 2+ tables
MySQL: Queries: Number flagged as slow
MySQL: Queries: Queries per second
MySQL: Queries: Selects w/ full table scans
MySQL: Queries: Sort buffer size for in-memory sorting
MySQL: Queries: Sorts done using ranges
MySQL: Queries: Sorts that scanned a table
MySQL: Queries: Sorts total number
MySQL: Queries: Total number executed
MySQL: Queries: Total rows returned
MySQL: Queries: Total rows using indices
MySQL: Query cache average pruned from cache per day
MySQL: Query cache block size
MySQL: Query cache fragmentation
MySQL: Query cache free blocks
MySQL: Query cache free memory
MySQL: Query cache hit rate %
MySQL: Query cache hits
MySQL: Query cache is enabled
MySQL: Query cache number currently in cache
MySQL: Query cache number inserted
MySQL: Query cache number not cached
MySQL: Query cache number pruned due to memory %
MySQL: Query cache number pruned from query cache
MySQL: Query cache resultset max size
MySQL: Query cache size
MySQL: Query cache total blocks
MySQL: Query cache type
MySQL: Suggested innodb_additional_mem_pool_size
MySQL: Suggested innodb_buffer_pool_size
MySQL: Suggested innodb_log_buffer_size
MySQL: Suggested innodb_log_file_size
MySQL: Suggested key_buffer_size
MySQL: Suggested key_buffer_size
MySQL: Suggested query_cache_size
MySQL: Suggested read_buffer_size
MySQL: Suggested read_rnd_buffer_size
MySQL: Suggested sort_buffer_size
MySQL: Suggested table_cache
MySQL: Suggested tmp_table_size
MySQL: Table: Cache hit rate %
MySQL: Table: Currently open
MySQL: Table: Fragmented count in all databases
MySQL: Table: Locks acquired immediately
MySQL: Table: Locks that required waiting
MySQL: Table: Locks vs. table opens %
MySQL: Table: Maximum size of a memory table
MySQL: Table: Number of cache misses
MySQL: Table: Number that can be cached
MySQL: Threads cache size
MySQL: Threads cached
MySQL: Threads created
MySQL: Threads creation rate
MySQL: Threads currently connected
MySQL: Threads currently running
MySQL: Threads hitting the thread-cache %
MySQL: Threads launched which were slow
MySQL: Tmp files created due to > sort_buffer_size
MySQL: Tmp tables created
MySQL: Tmp tables created on disk
MySQL: Tmp tables written to disk %
MySQL: Uptime in seconds

Triggers

Accounts with old passwords on Template_MySQL_Server {Template_MySQL_Server:mysql.secure_auth. last( 0 ) }=0
Anonymous users allowed on Template_MySQL_Server {Template_MySQL_Server:mysql.Anonymous_accounts_count. last( 0 ) }>0
Anonymous users alowed on Template_MySQL_Server {Template_MySQL_Server:mysql.Anonymous_accounts_count. last( 0 ) }>0
Binary log is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.log_bin. last( 0 ) }=0
Binlog is not sync'd to disk after each write on Template_MySQL_Server {Template_MySQL_Server:mysql.sync_binlog. last( 0 ) }=0
Binlog_cache_size too low (% written to disk) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_transactions_saved_tmp_file. last( 0 ) }>10
Binlog_cache_size too low (% written to disk) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_transactions_saved_tmp_file. last( 0 ) }>30
Excessive recent revokes on Template_MySQL_Server {Template_MySQL_Server:mysql.Excessive_revokes. last( 0 ) }>0
Excessive tmp disk tables created on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>25
InnoDB Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_hit_rate. last( 0 ) }<85
InnoDB Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_hit_rate. last( 0 ) }<95
InnoDB log flush status on Template_MySQL_Server {Template_MySQL_Server:mysql.innodb_flush_log_at_trx_commit. last( 0 ) }#2
LOAD DATA LOCAL allowed on Template_MySQL_Server {Template_MySQL_Server:mysql.local_infile. last( 0 ) }=1
Logs are not set to expire on Template_MySQL_Server {Template_MySQL_Server:mysql.expire_logs_days. last( 0 ) }=0
Long query time is high on Template_MySQL_Server {Template_MySQL_Server:mysql.Created_tmp_disk_tables. last( 0 ) }>25
MyISAM auto recovery not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.myisam_recover_options. last( 0 ) }=0
MyISAM: Key Cache Hit Rate {Template_MySQL_Server:mysql.Percent_myisam_key_cache_hit_rate. last( 0 ) }<85
MyISAM: Key Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_myisam_key_cache_hit_rate. last( 0 ) }<95
MyISAM: Key Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_myisam_key_cache_hit_rate. last( 0 ) }<85
MySQL: Accounts with old passwords on Template_MySQL_Server {Template_MySQL_Server:mysql.secure_auth. last( 0 ) }=0
MySQL: Anonymous users allowed on Template_MySQL_Server {Template_MySQL_Server:mysql.Anonymous_accounts_count. last( 0 ) }>0
MySQL: Binary log is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.log_bin. last( 0 ) }=0
MySQL: Binlog is not sync'd to disk after each write on Template_MySQL_Server {Template_MySQL_Server:mysql.sync_binlog. last( 0 ) }=0
MySQL: Binlog_cache_size too low (% written to disk) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_transactions_saved_tmp_file. last( 0 ) }>10
MySQL: Binlog_cache_size too low (% written to disk) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_transactions_saved_tmp_file. last( 0 ) }>30
MySQL: Change the innodb_additional_mem_pool_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_innodb_additional_mem_pool_size. last( 0 ) }=1
MySQL: Change the innodb_log_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_innodb_log_buffer_size. last( 0 ) }=1
MySQL: Change the innodb_log_file_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_innodb_log_file_size. last( 0 ) }=1
MySQL: Change the key_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_key_buffer_size. last( 0 ) }=1
MySQL: Change the myisam_sort_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_myisam_sort_buffer_size. last( 0 ) }=1
MySQL: Change the query_cache_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_query_cache_size. last( 0 ) }=1
MySQL: Change the read_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_read_buffer_size. last( 0 ) }=1
MySQL: Change the read_rnd_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_files_open. last( 0 ) }=1
MySQL: Change the sort_buffer_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_sort_buffer_size. last( 0 ) }=1
MySQL: Change the table_cache on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_table_cache. last( 0 ) }=1
MySQL: Change the tmp_table_size on Template_MySQL_Server {Template_MySQL_Server:mysql.Change_tmp_table_size. last( 0 ) }=1
MySQL: Excessive recent revokes on Template_MySQL_Server {Template_MySQL_Server:mysql.Excessive_revokes. last( 0 ) }>0
MySQL: Excessive tmp disk tables created on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>25
MySQL: InnoDB Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_hit_rate. last( 0 ) }<85
MySQL: InnoDB Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_hit_rate. last( 0 ) }<95
MySQL: InnoDB log flush status on Template_MySQL_Server {Template_MySQL_Server:mysql.innodb_flush_log_at_trx_commit. last( 0 ) }#2
MySQL: Joins without indices on Template_MySQL_Server {Template_MySQL_Server:mysql.Joins_without_indexes_per_day. last( 0 ) }>100
MySQL: LOAD DATA LOCAL allowed on Template_MySQL_Server {Template_MySQL_Server:mysql.local_infile. last( 0 ) }=1
MySQL: Logs are not set to expire on Template_MySQL_Server {Template_MySQL_Server:mysql.expire_logs_days. last( 0 ) }=0
MySQL: Long query time is high on Template_MySQL_Server {Template_MySQL_Server:mysql.Created_tmp_disk_tables. last( 0 ) }>25
MySQL: Long query time is high on Template_MySQL_Server {Template_MySQL_Server:mysql.long_query_time. last( 0 ) }>2
MySQL: MyISAM auto recovery not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.myisam_recover_options. last( 0 ) }=0
MySQL: MyISAM: Key Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_myisam_key_cache_hit_rate. last( 0 ) }<95
MySQL: MyISAM: Key Cache Hit Rate (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_myisam_key_cache_hit_rate. last( 0 ) }<85
MySQL: New GRANTs have been given on Template_MySQL_Server {Template_MySQL_Server:mysql.Com_grant. last( 0 ) }>0
MySQL: Percent of connections (%) aborted on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_aborted_connections. last( 0 ) }>25
MySQL: Percent of connections (%) aborted on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_aborted_connections. last( 0 ) }>30
MySQL: Percent of InnoDB cache writes (%) that had to wait on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_write_waits_required. last( 0 ) }>0.01
MySQL: Percent of InnoDB cache writes (%) that had to wait on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_write_waits_required. last( 0 ) }>0.1
MySQL: Percent total connections (%) used on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_connections_used. last( 0 ) }>75
MySQL: Percent total connections (%) used on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_connections_used. last( 0 ) }>85
MySQL: Percentage of queries (%) scanning full tables on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_full_table_scans. last( 0 ) }>19
MySQL: Percentage of queries (%) scanning full tables on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_full_table_scans. last( 0 ) }>39
MySQL: Queries pruning frequently on Template_MySQL_Server {Template_MySQL_Server:mysql.Qcache_lowmem_prunes_per_day. last( 0 ) }>100
MySQL: Queries require tmp sort table on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_sort_tables. last( 0 ) }>100
MySQL: Query cache fragmented > 20% on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_fragmentation. last( 0 ) }>20
MySQL: Query cache hit rate low on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_hit_rate. last( 0 ) }<20
MySQL: Query cache is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.have_query_cache. last( 0 ) }=0
MySQL: Query cache pruned (%) due to memory on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_pruned_from_inserts. last( 0 ) }>15
MySQL: Query cache pruned (%) due to memory on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_pruned_from_inserts. last( 0 ) }>20
MySQL: Root account present on Template_MySQL_Server {Template_MySQL_Server:mysql.Root_accounts_count. last( 0 ) }>0
MySQL: Root has no password on Template_MySQL_Server {Template_MySQL_Server:mysql.Is_root_without_password. last( 0 ) }=1
MySQL: Root remote login enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.Is_root_remote_login_enabled. last( 0 ) }=1
MySQL: Server generates old passwords on Template_MySQL_Server {Template_MySQL_Server:mysql.old_passwords. last( 0 ) }=1
MySQL: SHOW DATABASES is enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.skip_show_database. last( 0 ) }=0
MySQL: Sugges the ed on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_files_open. last( 0 ) }=1
MySQL: Symlinks are enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.have_symlink. last( 0 ) }=1
MySQL: Table cache hit rate (%) is low on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_cache_hit_rate. last( 0 ) }<95
MySQL: Table lock contention (%) is degrading performance on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_lock_contention. last( 0 ) }>30
MySQL: Table lock contention (%) is degrading performance on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_lock_contention. last( 0 ) }>60
MySQL: Tables are fragmented on Template_MySQL_Server {Template_MySQL_Server:mysql.Fragmented_table_count. last( 0 ) }>0
MySQL: Temp tables using disk (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>50
MySQL: Temp tables using disk (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>75
MySQL: Thread cache hit ratio (%) falling on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_thread_cache_hit_rate. last( 0 ) }<93
MySQL: Thread cache hit ratio (%) falling on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_thread_cache_hit_rate. last( 0 ) }<90
MySQL: Too many files open on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_files_open. last( 0 ) }>85
MySQL: Too many threads () running on Template_MySQL_Server {Template_MySQL_Server:mysql.Threads_running. last( 0 ) }>19
MySQL: Too many threads () running on Template_MySQL_Server {Template_MySQL_Server:mysql.Threads_running. last( 0 ) }>24
MySQL: Users have blank or wildcard hosts on Template_MySQL_Server {Template_MySQL_Server:mysql.Accounts_with_broad_host_specifier. last( 0 ) }>0
MySQL: Users without passwords on Template_MySQL_Server {Template_MySQL_Server:mysql.Accounts_without_password. last( 0 ) }>0
MySQL: Validation (sql_mode) is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.sql_mode. last( 0 ) }=0
New GRANTs have been given on Template_MySQL_Server {Template_MySQL_Server:mysql.Com_grant. last( 0 ) }>0
Percent of connections (%) aborted on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_aborted_connections. last( 0 ) }>25
Percent of connections (%) aborted on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_aborted_connections. last( 0 ) }>30
Percent of InnoDB cache writes (%) that had to wait on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_write_waits_required. last( 0 ) }>0.01
Percent of InnoDB cache writes (%) that had to wait on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_innodb_cache_write_waits_required. last( 0 ) }>0.1
Percent total connections (%) used on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_connections_used. last( 0 ) }>75
Percent total connections (%) used on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_connections_used. last( 0 ) }>85
Percentage of queries (%) scanning full tables on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_full_table_scans. last( 0 ) }>19
Percentage of queries (%) scanning full tables on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_full_table_scans. last( 0 ) }>39
Query cache is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.have_query_cache. last( 0 ) }=0
Query cache pruned (%) due to memory on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_pruned_from_inserts. last( 0 ) }<15
Query cache pruned (%) due to memory on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_pruned_from_inserts. last( 0 ) }>15
Query cache pruned (%) due to memory on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_query_cache_pruned_from_inserts. last( 0 ) }>20
Root account present on Template_MySQL_Server {Template_MySQL_Server:mysql.Root_accounts_count. last( 0 ) }>0
Root has no password on Template_MySQL_Server {Template_MySQL_Server:mysql.Is_root_without_password. last( 0 ) }=1
Root remote login enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.Is_root_remote_login_enabled. last( 0 ) }=1
Server generates old passwords on Template_MySQL_Server {Template_MySQL_Server:mysql.old_passwords. last( 0 ) }=1
SHOW DATABASES is enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.skip_show_database. last( 0 ) }=0
Symlinks are enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.have_symlink. last( 0 ) }=1
Table cache hit rate (%) is low on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_cache_hit_rate. last( 0 ) }<95
Table lock contention (%) is degrading performance on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_lock_contention. last( 0 ) }>30
Table lock contention (%) is degrading performance on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_table_lock_contention. last( 0 ) }>60
Temp tables using disk (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>50
Temp tables using disk (%) on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_tmp_tables_on_disk. last( 0 ) }>75
Thread cache hit ratio (%) falling on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_thread_cache_hit_rate. last( 0 ) }<93
Thread cache hit ratio (%) falling on Template_MySQL_Server {Template_MySQL_Server:mysql.Percent_thread_cache_hit_rate. last( 0 ) }<90
Too many threads () running on Template_MySQL_Server {Template_MySQL_Server:mysql.Threads_running. last( 0 ) }>19
Too many threads () running on Template_MySQL_Server {Template_MySQL_Server:mysql.Threads_running. last( 0 ) }>24
Users have blank or wildcard hosts on Template_MySQL_Server {Template_MySQL_Server:mysql.Accounts_with_broad_host_specifier. last( 0 ) }>0
Validation (sql_mode) is not enabled on Template_MySQL_Server {Template_MySQL_Server:mysql.sql_mode. last( 0 ) }=0