Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 167 10 Older Entries

Displaying posts with tag: monitoring (reset)

(MySQL) Performance Monitoring with Prometheus [UPDATE]
+0 Vote Up -0Vote Down

In my last I was looking for a way to do performance monitoring and I stumbled upon Prometheus. Prometheus is much more than monitoring a single node service. Anyway let’s get the idea of gathering metrics using MySQL as example.

This how a simple configuration of Prometheus could look like:

global: 
  scrape_interval: 1m
  scrape_timeout: 10s
  evaluation_interval: 1m

scrape_configs:
  - job_name: mysql
    scheme: http
    target_groups:
    - targets: 
        - '10.17.148.31:9104'
      labels:
        zone: mysql

Every minute Prometheus …

  [Read more...]
Why an App-Centric View Isn't Enough
+0 Vote Up -0Vote Down

Sylvia Botros, Sendgrid’s lead DBA, recently told us about one of the ways her teams have found unique value in VividCortex. “Engineering managers and individual developers have pinged me and said, ‘Hey, I saw this in VividCortex -- what do you think?’ Some of our developers are not fully familiar with the generals of MySQL,” she explained, “but VividCortex is giving them a view into how their app is dealing with databases. And at the same time it’s teaching them DB lingo, which is good.”  

This feedback from Sylvia opens the door to one of the questions we hear a lot about …

  [Read more...]
Real time query monitoring on MySQL - with 3rd party tool and without
+0 Vote Up -0Vote Down

I've tried out Idera's MySQL Query Explorer, a free tool and I found it easy to use and simple to setup. The only improvement that can be suggested is to add, on the technical requirements page, that your MySQL instance (MySQL Server version 5.5 and newer) must be running with the performance_schema turned on. Otherwise the tool will just display an empty grid. After you've successfully set

Use VividCortex to View WiredTiger Metrics and Charts for MongoDB
+0 Vote Up -0Vote Down

VividCortex is designed to offer its users as much access and visibility into their database systems as possible. With that in mind, we're excited to let all of our MongoDB users know that VividCortex is capable of capturing, displaying, and navigating metrics and charts produced in MongoDB's powerful WiredTiger storage engine. 

Beginning with MongoDB version 3.0, users will have the option of selecting one of two storage engines: the default MMAPv1 engine, as used in prior MongoDB releases; or the new WiredTiger engine. As …

  [Read more...]
Sometimes a Variety of Databases is THE Database You Need
+0 Vote Up -0Vote Down

We were just leafing through the 2015 edition of The DZone Guide to Database and Persistence Management, and we noticed some interesting stats in the guide's included survey, about which we'd like to share some observations. The survey is one of the ebook's central features, and it includes feedback from over 800 IT Professionals, with 63% of those respondents coming from companies with over 100 employees and 69% with over 10 years of experience -- they represent a significant and important cross-section of our industry.

…  [Read more...]
Troubleshooting MySQL Performance. Step Zero: Check If You Have a Performance Problem to Troubleshoot
+0 Vote Up -0Vote Down

I lost count of the number of times I had customers come to me for a regular MySQL performance check-up saying “no, we don’t have any performance problems right now”, just to find they do actually have them, they’re just not aware of it. It’s no big surprise this happens when you’re not using your system as actively as your users are.

So let me share with you one trick I’m using to quickly check if the system I’m on has any problems that need troubleshooting. Actually, it’s dead simple. And no, it’s not a slow query log, it’s Threads_running. Let me show you.

Wait, …


  [Read more...]
PGConf Silicon Valley 2015 was Excellent - Baron Schwartz on VividCortex's PostgreSQL Sniffer
+0 Vote Up -0Vote Down

PGConf Silicon Valley was excellent this year: good organization, great speakers, and top-notch vibes in general. We were excited to see everybody visiting (and crowding!) our booth and the overall very positive community presence. Highlights included a presentation about Postgres' use at TripAdvisor, a look at Amazon RDS for Postgres, and consideration of system scalability and the future of relational database management systems.

Baron Schwartz, VividCortex's own founder and CEO, was at the Silicon Valley conference, and he's said that it was the best PGConf he's been to yet. On November 18th, …

  [Read more...]
See the Details with 1-Second Resolution Data
+0 Vote Up -0Vote Down

We've talked a lot about the high-resolution data we capture, but if you haven't experienced it yourself, it might be a little abstract. Here, look at the difference between 1-second and 1-minute data.

Are your monitoring systems glossing over important detail with low-frequency data?

All of our metrics are in 1-second granularity. That's 60x more data points per minute than most monitoring tools. It's 120x more data points per second than MongoDB Monitoring Service's premium paid tier. It's 500x more data points per minute than MySQL Enterprise Monitor at its default settings.

It's enough detail to see …

  [Read more...]
MySQL Health Check Script
+0 Vote Up -0Vote Down

Ever get called out for a MySQL issue only to realize that there was no issue?  It was a false alarm from the monitor.  We sure have and it’s frustrating, especially at 3:00 or 4:00 in the morning!

Many DBAs work in an environment where there is some sort of first level support that gets assigned tickets first.  Unfortunately, many of the times these groups are, shall we say, less than skilled in MySQL.  As a result, they quickly escalate the ticket onto the primary on-call DBA, even when there is really nothing wrong.

Much of the time, there are multiple types of MySQL topology in these environments: standalone, galera cluster, …

  [Read more...]
Track and Optimize Server Connection Methods
Employee_Team +0 Vote Up -0Vote Down

The MySQL server supports a variety of client connection methods. To summarize: you have TCP/IP (v4 and v6) on all OSes (with or without TLS/SSL encryption), Unix Domain Sockets on Unix/Linux, and Named Pipes and/or Shared Memory on Windows.

Each of these connection methods has its own set of pros and cons: speed, security, portability, and ease-of-use.…

Showing entries 1 to 10 of 167 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.