The first icon (on the left) allows you click on the icon to download the graph as a. You will notice two icons to the right of the graph name. For this example, we will click on the “Agent Reporting Delay” graph: Next, click on the plus sign for the graph that you want to use so that MEM will draw the graph. After you have changed the Time Range settings, click on the “Filter” button. Don’t worry about the time settings that are in MEM, as we will change these settings later, but we need them so that they will be included in the URL that we will use (more on this later). Next, we will need to change the Time Range settings to “From/To”, so that we can enter the a timeline for the graph in our script. First, click on a server group in your server list on the left side of MEM. We will download the first graph for all of the servers in a particular group, and the second graph for an individual server. Open MEM in your browser, login, click on the graphs tab, and then you will see a list of all of the available graphs.įor this example, we are going to automatically download the Agent Reporting Delay and the Disk IO Usage graphs.
Let’s assume that you have already accomplished this task, and that MEM is running properly.
Of course, you have to install MEM and at least one agent. As a result, the productivity of your developers, DBAs and System Administrators is improved significantly. Its like having a “Virtual DBA Assistant” at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more. *The MySQL Enterprise Monitor (MEM) continuously monitors your MySQL servers and alerts you to potential problems before they impact your system. However, in the past I have written Perl scripts to automatically download files from web sites, so I thought I would see if it was possible with MEM. I wasn’t sure why he wanted to download the graphs (I didn’t ask), but I knew it wasn’t possible by using MEM alone. But the client asked if there was a way to automatically download graphs. Usually, you view the graphs from within the MEM Enterprise Dashboard (via a web browser).
I was demonstrating the “graphs” section of MEM, where you can monitor MySQL sessions, connections, replication latency and more with 60+ graphs. I was giving a presentation of the MySQL’s Enterprise Monitor* application to a client recently.
0 kommentar(er)
