Search
Related topics are listed below.
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
MariaDB Space Optimizer
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Space Optimizer
Name: MariaDB Space Optimizer Platform: Mariadb Category: Availability Description: Tells the user how much space tables in a specific database consume. Long description: Version: 1 Default…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
MariaDB Index Redundancy Checker
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MariaDB Index Redundancy Checker
Name: MariaDB Index Redundancy Checker Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Version: 1 Default…
MySQL max connections
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL max connections
Name: MySQL max connections Platform: Mysql Category: Description: Checking if the system is near maximum connections Long description: Version: 1 Default…
MySQL mysqld process
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL mysqld process
Name: MySQL mysqld process Platform: Mysql Category: Description: Checking if mysqld process is running Long description: Version: 1 Default schedule: 15m Requires engine…
MySQL aborted connects
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » MySQL aborted connects
Name: MySQL aborted connects Platform: Mysql Category: Description: Checking if there is many aborted connects Long description: Version: 1 Default schedule: 1h Requires engine…
Adding a MySQL Instance
Using Control Center » Instance management » Adding a MySQL Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. This will bring up the “Add Instance” wizard, which will guide you through the following steps. Select Instance Type and Input…
Using SQL Performance package on MySQL
Installing and using additional modules » SQL Performance package » Using SQL Performance package on MySQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Adding MySQL Instance with Super Privilege Error
Troubleshooting Guide » Adding MySQL Instance with Super Privilege Error
MySQL Super Privilege Error When adding an instance for MySQL 5.0 or over, you may encounter the following error: This error happens when dbWatch Control Center is creating a user. This error appears indicating that the user has no super privilege rights. There…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
Editor for engine jobs
Customization » Monitoring » Editor for engine jobs
How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…
Blocking detector for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Blocking detector for RAC
Name: Blocking detector for RAC Platform: Oracle Category: Cluster and Replication Description: Checks if a session is waiting on a TX (transaction) lock. (RAC only) Long description: Task checks if a session is…
Email and SMS
Customization » Extensions and 3rd party integrations » Email and SMS
Configure In the dbWatch Monitor, go to the “Server”->”Server Extensions” menu. An item called “E-mail extension” should now be visible (v 5.2 or later). To configure the extension, select it and click “Configure”. You should now see the initial…
Network and communications
Product Overview » Network and communications
Network and communications Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. On each node there is a node.connections file that both lists what…
Issues and troubleshooting
Troubleshooting Guide » Issues and troubleshooting
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
Cluster and replication
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Cluster and replication
Jobs in the Cluster and replication category Control Center Jobs Description Oracle Blocking detector for RAC Checks if a session is waiting on a TX (transaction) lock. (RAC only) Memory session load for RAC Records the…
Memory session load for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC
Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
Disabling and Enabling Views
Using Control Center » Disabling and Enabling Views
You can enable or disable modules from your dbWatch Control Center by unticking their check boxes. If you check Views, you will see the default set up of modules that are visible. Once you disable all the modules, you’ll only be left with the Report Module. …
Schema growth and information
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Schema growth and information
Name: Schema growth and information Platform: Postgres Category: Capacity Description: Collects detailed schema growth rate information. Long description: Collects detailed schema growth rate…
Network Ports and Services
Advanced Topics » Product Security » Network Ports and Services
Network Ports and Services Default ports and protocol dbWatch Control Center uses by default port 7100/tcp for client to node and node to node connections. This can be configured to a different port. If enabled the webserver can run. Default port is 8080. On each…
Alert log check (java for 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java for 10g)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Repository management and monitoring
Installing and using additional modules » SQL Performance package » Repository management and monitoring
Introduction The SQL Performance package creates tables in the dbWatch schema/database on each database instance where the SQL Statistics job is installed and scheduled. The process combines two parts of dbWatch Control Center. The monitoring is used to schedule the…
Privileges and actions map
Using Control Center » Domain Configuration » Privileges and actions map
Overview of actions and required privilege Instance is the specific database instance. Instance system is a predefined security group controlling the overall instance monitoring and management. Domain configuration is a predefined security group controlling the…
Tablespace growth and information
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Tablespace growth and information
Name: Tablespace growth and information Platform: Postgres Category: Capacity Description: Shows an overview of tablespace growth and statistics. Long description: Shows an overview of tablespace growth and…
Locks held and statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Locks held and statistics
Name: Locks held and statistics Platform: Postgres Category: Performance Description: Shows locks held statistics. Long description: Task shows locks held statistics. Version: 1.6 Default…
Segment size status for old style tablespaces
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size status for old style tablespaces
Name: Segment size status for old style tablespaces Platform: Oracle Category: Capacity Description: Checks segment storage definitions in tablespaces where extent management is not set to local. Long…
Table and index scan statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan statistics
Name: Table and index scan statistics Platform: Postgres Category: Performance Description: This task gathers scan statistics on tables and indexes from pg_stat_all_tables view. Long description: Statistics from…
Lazy writer and checkpoint statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Lazy writer and checkpoint statistics
Name: Lazy writer and Checkpoint statistics Platform: Sqlserver Category: Performance Description: Monitors ‘Checkpoint pages/sec’, ‘Lazy writes/sec’ and ‘Page life expectancy’ by…
Extensions and 3rd party integrations
Customization » Extensions and 3rd party integrations
Configuring extensions and 3rd party integrations Email Contact support if you want to make sure you have installed the latest version of your extension. ← Reports / Email and SMS →
Monitor dashboards and overview screens
Product Overview » Monitor dashboards and overview screens
Being effective in database operations are one of the key focus areas for the dbWatch database operations team. This chapter will focus on the dashboards or overview screens used by our internal database operations team, what information they show, how they are used…
Table and index scan collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » Table and index scan collector
Name: Table and index scan collector Platform: Postgres Category: Performance Description: Shows locks held statistics. Long description: This job collects table and index scan statistics for all schemas i all…
Installing and using additional modules
Installing and using additional modules
Additional modules dbWatch Control Center also provides additional packages or modules to cover specific areas. They may be specific only to one or a few of the platforms supported by dbWatch Control Center. More details are found on the pages specific to the package…
Session load (8i and 9i)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Session load (8i and 9i)
Name: Session load Platform: Oracle Category: Performance Description: Records the number of active sessions over time. Long description: Task records the number of active sessions over a period of…
Check database and server principal mapping
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database and server principal mapping
Name: Check database and server principal mapping Platform: Sqlserver Category: Maintenance Description: Checks if the database owner (dbo) is maped into any Server Login (server principal). Long…
Platforms supported
About dbWatch Control Center » Platforms supported
Platforms supported for the main product. Current release supports the following platforms, versions, and setups: On-premise support Supports* Express edition, Standard edition, Standard edition one, Standard edition two, and Enterprise edition of the following…
About dbWatch Control Center
About dbWatch Control Center
dbWatch Control Center is a highly scalable software solution helping enterprises monitor and manage large numbers of database servers efficiently, providing total control over all aspects of operation, performance, and resource usage. dbWatch Control Center will give…
Replica state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica state
Name: Replica state Platform: Mariadb Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…
Control Center Jobs
Using Control Center » Monitoring » Control Center Jobs
Jobs (older dbWatch versions Tasks and alerts) are the cornerstone of the dbWatch Monitoring module. Jobs perform the actual monitoring of the database instance. There are two types of Monitoring in dbWatch. The Basic and Standard monitoring. To see each monitoring…
Replica count
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica count
Name: Replica count Platform: Mariadb Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…
Replica delay
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Replica delay
Name: Replica delay Platform: Mariadb Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2023-09-27) Download Important note Linux release is now available as an apt repository, see Linux install guide Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine) New…
Availability
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Availability
Jobs in the Availability category Control Center Jobs Description Oracle Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mariadb Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
MySQLd process alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » MySQLd process alert
Name: MySQLd process alert Platform: Mariadb Category: Availability Description: Checking if mysqld process is running Long description: Version: 1 Default…
NDB data node status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » NDB data node status
Name: NDB data node status Platform: Mariadb Category: Cluster and Replication Description: NDB data node status Long description: This checks the status of data nodes in NDB cluster…
NDB data memory usage check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » NDB data memory usage check
Name: NDB data memory usage check Platform: Mariadb Category: Cluster and Replication Description: NDB data memory usage check Long description: This checks the usage of data memory in NDB cluster…
Key buffer check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Key buffer check
Name: Key buffer check Platform: Mariadb Category: Performance Description: Checks key buffer efficiency Long description: Task checks key buffer efficiency Version: 2.22 Default…
Session load (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Session load (old)
Name: Session load Platform: Mariadb Category: Performance Description: Shows connection statistics Long description: Task shows connection data statistics Version: 2.21 Default…
Binlog cache check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Binlog cache check
Name: Binlog cache check Platform: Mariadb Category: Performance Description: Binlog cache performance check Long description: This checks the performance of the ‘Binlog…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Memory setup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Memory setup
Name: Memory setup Platform: Mariadb Category: Performance Description: Analyzes the memory setup of the server Long description: Task analyzes memory setup of the…
Query cache hitrate (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Query cache hitrate (old)
Name: Query cache hitrate Platform: Mariadb Category: Performance Description: Shows the query cache hit rate Long description: Task shows the hit rate of query cache Version: 2.42 Default…
Thread cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Thread cache hitrate
Name: Thread cache hitrate Platform: Mariadb Category: Performance Description: Shows the thread cache hit rate Long description: Task shows the hit rate of the thread…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Mariadb Category: Capacity Description: Collects detailed growth rate information. Long description: Collects detailed information on the growth rate of the…
Innodb buffer pool check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Innodb buffer pool check
Name: Innodb buffer pool check Platform: Mariadb Category: Performance Description: Checks the hit rate of the innodb buffer pool Long description: This checks the hit rate of the innodb buffer…
Lock statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Lock statistics
Name: Lock statistics Platform: Mariadb Category: Performance Description: Collects lock statistics Long description: This task collects lock data statistics Version: 2.11 Default…
Lock statistics (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Lock statistics (old)
Name: Lock statistics Platform: Mariadb Category: Performance Description: Collects lock statistics Long description: This task collects lock data statistics Version: 2.11 Default…
Replica state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica state
Name: Replica state Platform: Mysql Category: Cluster and Replication Description: This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a…
Aborted connects alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Aborted connects alert
Name: Aborted connects alert Platform: Mariadb Category: Availability Description: Checking if there is many aborted connects Long description: Version: 1 Default…
Maximum connections alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Maximum connections alert
Name: Maximum connections alert Platform: Mariadb Category: Availability Description: Checking if the system is near maximum connections Long description: Version: 1 Default…
Network traffic (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Network traffic (old)
Name: Network traffic Platform: Mariadb Category: Performance Description: Shows the network traffic Long description: Task shows amount of network traffic in the server Version: 2.2 Default…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Session load
Name: Session load Platform: Mariadb Category: Performance Description: Shows connection statistics Long description: Task shows connection data statistics Version: 2.21 Default…
DBMS uptime (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » DBMS uptime (old)
Name: DBMS uptime Platform: Mariadb Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Memory setup (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Memory setup (old)
Name: Memory setup Platform: Mariadb Category: Performance Description: Analyzes the memory setup of the server Long description: Task analyzes memory setup of the…
Database load (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load (old)
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Network traffic
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Network traffic
Name: Network traffic Platform: Mariadb Category: Performance Description: Shows the network traffic Long description: Task shows amount of network traffic in the server Version: 2.2 Default…
Key buffer check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Key buffer check (old)
Name: Key buffer check Platform: Mariadb Category: Performance Description: Checks key buffer efficiency Long description: Task checks key buffer efficiency Version: 2.21 Default…
Binlog cache check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Binlog cache check (old)
Name: Binlog cache check Platform: Mariadb Category: Performance Description: Binlog cache performance check Long description: This checks the performance of the ‘Binlog…
Database load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Database load
Name: Database load Platform: Mariadb Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Query cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Query cache hitrate
Name: Query cache hitrate Platform: Mariadb Category: Performance Description: Shows the query cache hit rate Long description: Task shows the hit rate of query cache Version: 2.42 Default…
Thread cache hitrate (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Thread cache hitrate (old)
Name: Thread cache hitrate Platform: Mariadb Category: Performance Description: Shows the thread cache hit rate Long description: Task shows the hit rate of the thread…
Temporary table check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Temporary table check
Name: Temporary table check Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Task shows the percentage of temporary tables which have…
Innodb buffer pool check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Innodb buffer pool check (old)
Name: Innodb buffer pool check Platform: Mariadb Category: Performance Description: Checks the hit rate of the innodb buffer pool Long description: This checks the hit rate of the innodb buffer…
Temporary table check (old)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB » Temporary table check (old)
Name: Temporary table check Platform: Mariadb Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Task shows the percentage of temporary tables which have…
Replica delay
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica delay
Name: Replica delay Platform: Mysql Category: Cluster and Replication Description: This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and…
Replica count
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Replica count
Name: Replica count Platform: Mysql Category: Cluster and Replication Description: This job checks all of replicas currently registered with the source. Long…
Defining Autodiscover Ports
Using Control Center » Autodiscover » Discovering Database Instances » Defining Autodiscover Ports
By default autodiscover scans the following ports: MS SQL Server: 1433 Oracle: 1520, 1521, 1522, 1523, 1524, 1526, 1527 Sybase: 4998, 4999, 5000, 5001, 5002 MySQL: 3304, 3305, 3306, 3307, 3308 PostgreSQL: 5429, 5430, 5431, 5432, 5433, 5434 You can override the…
SQL Performance package
Installing and using additional modules » SQL Performance package
SQL Performance package SQL Performance module is an optional module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and newer Oracle 11g and…
Innodb cluster switch
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster switch
Name: Innodb cluster switch Platform: Mysql Category: Cluster and Replication Description: This job checks if Innodb cluster PRIMARY/SECONDARY switch occurs. Long…
NDB data node status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » NDB data node status
Name: NDB data node status Platform: Mysql Category: Cluster and Replication Description: NDB data node status Long description: This checks the status of data nodes in NDB cluster…
Innodb cluster status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Innodb cluster status
Name: Innodb cluster status Platform: Mysql Category: Cluster and Replication Description: This job checks state of all members in Innodb cluster Long description: Version: 1.2 Default…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Mysql Category: Capacity Description: Collects database size and visualizes the growth rate of the server. Long description: Collects database size and…
NDB data memory usage check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » NDB data memory usage check
Name: NDB data memory usage check Platform: Mysql Category: Cluster and Replication Description: NDB data memory usage check Long description: This checks the usage of data memory in NDB cluster…
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Session load
Name: Session load Platform: Mysql Category: Performance Description: Shows connection statistics Long description: Task shows connection data statistics Version: 2.21 Default…
FAQs
Additional Resources » FAQs
In this section – you will find the frequently asked questions regarding the dbWatch. Do you offer an evaluation copy of your product? - Yes, we do offer a 30-day trial for a maximum of 25 database instances of any database platforms supported. We can also…
Thread cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Thread cache hitrate
Name: Thread cache hitrate Platform: Mysql Category: Performance Description: Shows the thread cache hit rate Long description: Task shows the hit rate of the thread…
Binlog cache check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Binlog cache check
Name: Binlog cache check Platform: Mysql Category: Performance Description: Binlog cache performance check Long description: This checks the performance of the ‘Binlog…
Network traffic
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Network traffic
Name: Network traffic Platform: Mysql Category: Performance Description: Shows the network traffic Long description: Task shows amount of network traffic in the server Version: 2.2 Default…
DBMS uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » DBMS uptime
Name: DBMS uptime Platform: Mysql Category: Availability Description: Collects uptime statistics in the database. Long description: Task collecs uptime data statistics in the database…
Memory setup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Memory setup
Name: Memory setup Platform: Mysql Category: Performance Description: Analyzes the memory setup of the server Long description: Task analyzes memory setup of the server Version: 2.11 Default…
Lock statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Lock statistics
Name: Lock statistics Platform: Mysql Category: Performance Description: Collects lock statistics Long description: This task collects lock data statistics Version: 2.11 Default…
Key buffer check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Key buffer check
Name: Key buffer check Platform: Mysql Category: Performance Description: Checks key buffer efficiency Long description: Task checks key buffer efficiency Version: 2.22 Default…
Temporary table check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Temporary table check
Name: Temporary table check Platform: Mysql Category: Performance Description: Shows percentage of temporary tables written to disk Long description: Task shows the percentage of temporary tables which have been…
Database load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Database load
Name: Database load Platform: Mysql Category: Performance Description: Provides information on the server load Long description: Task provides infomation on the server load in the database…
Query cache hitrate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL » Query cache hitrate
Name: Query cache hitrate Platform: Mysql Category: Performance Description: Shows the query cache hit rate Long description: Task shows the hit rate of query cache Version: 2.42 Default…