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

Displaying posts with tag: monitoring (reset)

Why Use Slow Query Logs When There’s VividCortex?
+0 Vote Up -0Vote Down

At VividCortex, we believe that database monitoring can be much, much better than what many people currently settle for. In fact, we know that monitoring needs to be better -- more reliable and more efficient than what many engineering and operations teams currently use. Databases are getting larger and more complex all the time, and older monitoring techniques can’t …

  [Read more...]
Addressing a Problematic MySQL Query and its Effects on Amazon Aurora
+1 Vote Up -0Vote Down

Since we announced our support for Amazon Web Service's Aurora last year, we've had great experiences working with customers who use Aurora as their database system of choice. And not only is Amazon's RDS excellent, so is their team and support.

Recently, we encountered a MySQL bug, which was, in turn, having effects on Amazon’s RDS. The MySQL issue involved a problematic query that caused Aurora instances to crash under load; upon discovering this issue, we had the opportunity to work with AWS to identify the error in MySQL and fix it, so …

  [Read more...]
How VividCortex Uses the New Generated Virtual Columns Feature in MySQL
+1 Vote Up -0Vote Down

In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.

When those platforms that we monitor -- already powerful, tried and true -- equip themselves with new features, we work to discover how VividCortex can leverage those features and make our own …

  [Read more...]
(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...]
Showing entries 1 to 10 of 170 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.