- #CONNECTWISE DESKTOP CLIENT INSTALL UPDATE#
- #CONNECTWISE DESKTOP CLIENT INSTALL FULL#
- #CONNECTWISE DESKTOP CLIENT INSTALL FREE#
Ideally, you’d handle the matter without having to get the end user involved. The last thing you want to do when dealing with a situation like this is have to interrupt your end users to connect into their computer to repair or reinstall your agent.
#CONNECTWISE DESKTOP CLIENT INSTALL UPDATE#
Whether it be due to a macOS update or a system issue, the ConnectWise Automate Mac agent has experienced occasional problems that have been discussed among many partners. You can use the form below to enter into our daily drawing.If you utilize the ConnectWise suite of products to manage workstations that include Macs, you may have occasionally run into a need to reinstall your ConnectWise Automate agent due to lost communication or to troubleshoot a reporting issue.
#CONNECTWISE DESKTOP CLIENT INSTALL FREE#
Getting started with Database Index Packsĭatabase Index Packs is a free promotional product. Indexes are created on the following tables: Technical detailsĭatabase Index Packs are compatible with hosted and on-premise Automate servers, and are installed via a script. These differences come from both application usage patterns (an index won’t be used if it’s table is never queried) along with the configuration of MySQL (indexes are increasingly used as data size increases). It’s important to note when reviewing Database Index Packs performance that the ultimate impact will vary between Automate instances. It’s also worth noting that this particular table ships with a composite index, but it’s columns are in the wrong order for this query.
In this particular example the file sort is unavoidable due to the query structure, but with the addition of the index (and a 66% reduction in rows returned from the first table) it’s increasingly likely that the data set is smaller and that the temporary table will be able to fit into memory and not be written to disk.
#CONNECTWISE DESKTOP CLIENT INSTALL FULL#
The original query performed a full table scan on the workspacepermissions table (the worst case scenario for performance at scale). With the stock indexes, this produces a full table scan. Each time an agent is opened all the subnet mask data is populated from the inv_networkcard table. Below are a couple of example queries that run each time a computer is opened in the desktop client.įirst, we have what looks to be a less-optimized example. Here at Automation Theory, we like to have measurable results. This explains why 27% of the stock indexes are not used by the database at all. MySQL can only use one index per query in most cases, so any queries filtering by multiple disparate indexes (like locationid and clientid in the computers table) would be forced to pick one index, or to forego the use of the indexes altogether. 98% of the indexes that ship with Connectwise Automate are single-column, and this results in non-optimal retrieval of data. However, not all indexes are created equal. The Automate database ships with ~1100 indexes by default.
It contains a total of 42 composite indexes spread across 30 tables, and it’s designed to be an entry-level optimization measure for the Connectwise Automate MySQL database for on-premise and cloud-hosted servers. Database Index Packs is a collection of composite indexes for the Connectwise Automate database.