Mackerel blog #mackerelio

The Official Blog of Mackerel

【Spec Change Notice】New metric targets for AWS / ElastiCache Integration

Mackerel team CRE Inoue (id:a-know) here. Today we are announcing some new specification changes.

As stated in the title, newly obtainable metric targets are being added for AWS / ElastiCache Integration.

These changes may affect your usage fee regarding micro host conversion, particularly when using Redis. Continue reading below for more information.

Specification changes

Host Level metrics

The following metrics will be added.

  • elasticache.network_packets.out

For more information, please refer to the AWS documentation.

Redis metrics

The following metrics will be added.

  • Commands
    • elasticache.redis.commands.eval_based
    • elasticache.redis.commands.geo_spatial_based
    • elasticache.redis.commands.hyper_log_log_based
    • elasticache.redis.commands.pub_sub_based
    • elasticache.redis.commands.stream_based
  • Commands Latency
    • elasticache.redis.commands_latency.get_type
    • elasticache.redis.commands_latency.set_type
    • elasticache.redis.commands_latency.key_based
    • elasticache.redis.commands_latency.string_based
    • elasticache.redis.commands_latency.hash_based
    • elasticache.redis.commands_latency.list_based
    • elasticache.redis.commands_latency.set_based
    • elasticache.redis.commands_latency.sorted_set_based
    • elasticache.redis.commands_latency.eval_based
    • elasticache.redis.commands_latency.geo_spatial_based
    • elasticache.redis.commands_latency.hyper_log_log_based
    • elasticache.redis.commands_latency.pub_sub_based
    • elasticache.redis.commands_latency.stream_based
  • Other
    • elasticache.redis.active_defrag
    • elasticache.redis.cache_hit_rate
    • elasticache.redis.memory_percentage
    • elasticache.redis.average_ttl
    • elasticache.redis.fragmentation_ratio
    • elasticache.redis.replication_bytes
    • elasticache.redis.replication_lag
    • elasticache.redis.save_in_progress

For more information, please refer to the AWS documentation.


As a result of these specification changes, the maximum number of obtainable metrics will increase as outlined below.

  • ElastiCache / Memcached
    • The current number of 39 metrics will increase to 41 metrics.
  • ElastiCache / Redis
    • The current number of 22 metrics will increase to 50 metrics.

Please note, particularly with Redis, that exceeding the metric limit will cause the number to be converted into 2 micro hosts. (For more information regarding host conversion, refer to Handling of host conversion when plan limits are exceeded – Mackerel Support)

You can freely choose which metrics to obtain with AWS integration in the settings. These metrics will be obtained by default, so be sure to manage this as needed.

Scheduled release date

The release which includes these specification changes is scheduled for Monday, September 7th, 2020 (JST) .

These changes were implemented at the request of Mackerel users. We look forward to your feedback (feel free to contact our support team via the Mackerel Web Console).

Alert status can now be selected when an alert occurs with host connectivity monitors and more

Hello. Mackerel team CRE Inoue (id:a-know) here with another update announcement.

Alert status can now be selected when an alert occurs with host connectivity monitors

Among the various monitors that can be configured with Mackerel, ‘Host connectivity monitoring’ can detect when metric transmission from the agent (mackerel-agent) gets interrupted and issues an alert. However up until now, the status of this alert was fixed to critical. With this update, it is now possible to choose the status of an alert when it occurs.

Some users may not even be aware of host connectivity monitoring due to the fact that it’s already configured from the get-go. We recommend reviewing the page linked below.

New obtainable metrics added for AWS/RDS Integration

With this update, now up to 52 metrics are available for RDS Aurora, up to 51 for Aurora Serverless, and up to 24 metrics are available for other services. Be sure to check out the differences detailed in the link below. Also, please note that some metrics are supported for certain database engines while others may not.

OSS Updates


A bug in mackerel-plugin-linux that prevented some OS versions (Debian 10 / RHEL 8 / Ubuntu 20.04) from retrieving disk stats was fixed.


In check-log, {} is now supported for --file option specification (glob format). It is now possible to specify commands like the one below.

command = ["check-log", "--file", "/var/log/{secure,cron}", "-p", "timeout"]

Let us know what you think!

New cloud integration metrics and more

Hello. Mackerel team CRE Inoue (id:a-know) here with another update announcement.

New cloud integration metrics have been added

Newly obtainable metrics have been added for each of the managed services for cloud integration below.

Azure SQL Database

Metrics can now be retrieved according to price tier. See the help page below for more information on which metrics you can get at each price level.

Amazon CloudFront

With the addition of eight real-time metrics in Amazon CloudWatch, Amazon CloudFront is now supported with Mackerel's AWS integration.

The following metrics have been added.

  • ErrorRate
    • 401ErrorRate (cloudfront.error_rate.401_error_rate)
    • 403ErrorRate (cloudfront.error_rate.403_error_rate)
    • 404ErrorRate (cloudfront.error_rate.404_error_rate)
    • 502ErrorRate (cloudfront.error_rate.502_error_rate)
    • 503ErrorRate (cloudfront.error_rate.503_error_rate)
    • 504ErrorRate (cloudfront.error_rate.504_error_rate)
  • CacheHitRate
    • CacheHitRate (cloudfront.cache_hit_rate)
  • OriginLatency
    • OriginLatency (cloudfront.origin_latency)

Be sure to check out the help page below as well.

OSS Updates

mackerel-agent-plugins (v0.61.0)

Regarding the mackerel-plugin-accesslog plugin, a parsing error will no longer be output for fields included in the access log that are not used by the plugin.

mackerel-check-plugins (v0.35.0)

The check-ssl-cert plugin now also monitors the expiration date of intermediate certificates.


A bug was fixed that caused HTTP Keep-Alive to not perform under certain conditions.

We will be holding an online seminar to present the updates of the first half of 2020!

As we’ve previously stated on this blog, Mackerel is constantly making new updates. We’ve already made a ton of updates this year.

For this event, we’ll be presenting the updates made in the first half of 2020, and a Mackerel team CRE will introduce their top functions with a demo! (Only available in Japanese)

There may be some updates that you missed. Please consider participating!

An error regarding obtaining metrics with mackerel-plugin-mysql has been fixed

Hello. Mackerel team CRE Inoue (id:a-know) here. This is an announcement regarding an error that was fixed for mackerel-plugin-mysql of the official Mackerel plugin pack.

What was fixed?

The metrics obtainable with mackerel-plugin-mysql are Bytes_sent (mysql.traffic.Bytes_sent) and Bytes_received (mysql.traffic.Bytes_received). These metrics represent the number of bytes sent and received by all clients.

The plugin (1) retrieves the corresponding metrics recorded as the cumulative total value in MySQL and (2) calculates the difference and sends it to Mackerel. When browsing these metrics in Mackerel, the expected unit is bytes/sec. However, a value 60 times larger (the value of bytes/min) than the actual value was being sent. This has been corrected according to the Pull Request linked below. Now, a value that is 1/60 of the previous value will be sent.

What needs to be done?

Today we are updating Mackerel’s official plugin package mackerel-agent-plugins. Be sure to update the mackerel-agent-plugins package with your package management system (yum or apt).

With this update, the values of Bytes_sent (mysql.traffic.Bytes_sent) and Bytes_received (mysql.traffic.Bytes_received) will be sent as 1/60 of the previous values. If you’ve created a monitor for these metrics, please be sure to review the thresholds as well.

We apologize for any inconvenience this may have caused and thank you for your understanding.

Azure Database for MySQL / PostgreSQL now supported with Azure Integration!

Hello. Mackerel team CRE Inoue ( id:a-know) here with another update announcement.

Azure Database for MySQL / PostgreSQL now supported with Azure Integration


It is now possible to monitor Azure Database with Azure integration! Azure Database is Azure’s fully managed database service! Both MySQL and PostgreSQL are now supported.

Check out the help page linked below for configuration methods.

And be sure to check out each of the following help pages regarding obtaining metrics with this newly added integration.

The selected metric is now reflected when posting role metric graphs to notification channels

Now, when using the camera icon to post graphs to notification channels, the metric selection is reflected in the shared content. The same goes for host metric graphs and service metric graphs as well. We hope this is helpful!

Tips to help your inquiries to the support team get resolved quicker

Hello, Mackerel team CRE Nishiyama (id:tukaelu) here.

Have you ever searched through our FAQ (Frequently Asked Questions) or contacted our support team with questions regarding Mackerel? Well, the FAQ site and the Feedback form have both been recently updated!

And although the new feedback form is now more detailed than before, entering the correct information into the required fields is important if you want a speedy resolution.

Today we'll be taking a look at a few pointers that will help prompt a quick resolution when asking a question via the feedback form!

Make use of the ‘Subject’ field

The Subject field doesn’t need any new explanation per se, but one of the handy new features of the feedback form is that it now displays a list of suggested FAQ pages that seem to be relevant to the content entered in the subject line!

The suggested FAQ articles are listed like shown in the image above. Be sure to check for any articles that might be related!

Go into detail when filling in the Description

As for the Description of your inquiry, including the following points may lead to a quicker resolution.

Specify environment information

Including the following points detailing the environment of the host to which you are inquiring about will benefit the resolution turnaround.

  • OS type, version
  • Version of mackerel-agent
  • Plugin name, version (※If using an official plugin)
  • Service name for inquiries regarding various integration

Also, if you’re monitoring middleware with a plugin, inform us of the software name and version.

Specify the situation, status, etc.

Describe in detail the event or problem you are experiencing. Try to be as clear as possible about what operations were performed and what events occurred.

  • NG
    • mackerel-agent doesn’t start up. What are the possible causes?
  • OK
    • When mackerel-agent is restarted with the attached settings, the following error occurs and does not start up.

You can also attach files to the new feedback form. Attaching information like the following to your inquiry can help lead to a quicker resolution.

  • mackerel-agent logs
  • mackerel-agent.conf
    • Masking things like API keys is not a problem
  • User investigated content, executed commands, results, etc.
  • Screenshots that can be verified from the web console etc.

Include information that can be verified from the Mackerel Web Console

If what you are inquiring about can be verified from the Mackerel web console, please include the URL.

  • Host details URL
  • Alert details URL
  • Monitor details URL etc.

The review of your inquiry on our end will go a lot smoother if you can provide us with a URL that can be verified from the web console, such as a limited time graph URL. If this information is available, please make sure to attach it when contacting us.

Other Tips

In addition to the everything mentioned above, please consider the following points.

1 question per case

It may be quicker to have one question answered at a time.

If you have multiple questions that are all related, of course it’s better to consolidate them into one inquiry. But if this is not the case, you might try splitting up your questions into multiple inquiries.

An inquiry may be difficult to investigate if related to a retired host or deleted monitor

We recommend trying to reserve the resources (hosts, monitors, etc.) related to your inquiry as much as possible.

And please inform us if deleted or any changes were made.

You can add recipients (Cc) to receive a reply

You can ‘Cc’ additional recipients of the response by specifying email addresses separated by commas(,) in the "Additional email addresses to receive replies" field of the feedback form.

This can be useful for sharing the support team’s response among your team or people of concern.

Please inform us when the issue is resolved

If our support team’s response helps resolve your issue, please let us know and we can close the support case.

To close

This has been a look at a few useful pointers that can help get your inquiries to the support team resolved quicker!

If you have any questions or requests regarding Mackerel, please feel free to contact us!

An API for AWS Integration settings and more

Hello. Mackerel team CRE Inoue (id:a-know) here with another update announcement.

An API for AWS Integration settings!

Some users have been waiting expectantly for this update. The API documentation is linked below.

It is now possible to configure AWS Integration settings from the API. This includes specifying integration excludable metrics. Be sure to give this a try!

The Organizations page can now be sorted by number of alerts


The Organizations page shows a list of the organizations to which you belong. With this update, you can now rearrange this list by the number of occurred / continuing alerts. This is a nice update for those who manage a lot of organizations. We hope that you find it useful.

The Web Console’s Feedback form gets a new look!

Have you ever tried contacting our support team using the ‘Feedback’ button that’s located in the upper right corner of the web console? Well, we’ve updated the request form.

Now you can attach files to the new request form. Feel free to contact us using screenshots or configuration files that relate to your inquiry!