Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 34437 10 Older Entries
MySQL, Percona, MariaDB long running processes clean up one liner
+0 Vote Up -1Vote Down

There are tools like pt-kill from the percona tool kit that may print/kill the long running transactions at MariaDB, MySQL or at Percona data instances, but a lot of backup scripts are just some simple bash lines.
So checking for long running transactions before the backup to be executed seems to be a step that is missed a lot.

Here is one line that might be just added in every bash script before the backup to be executed
Variant 1. Just log all the processlist entries and calculate which ones were running longer than TIMELIMIT:

$ export TIMELIMIT=70 && echo "$(date) : check for long …


  [Read more...]
Optimizer hints in MySQL 5.7.7 – The missed manual
+1 Vote Up -0Vote Down

In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is:

  • It is now possible to provide hints to the optimizer by including /*+ ... */ comments following the …
  [Read more...]
OurSQL Episode 207: Looking Forward
+0 Vote Up -0Vote Down

PodcastsLearning

In this penultimate episode, we talk about what's coming in MySQL 5.7 and MariaDB 10.1. Ear Candy is about a new MySQL 5.7 utility to generate the SSL RSA keys to encrypt MySQL communications, and At the Movies is about MySQL's new features.

SSL/TLS in 5.6 and 5.5 – oCERT Advisory
Employee +1 Vote Up -0Vote Down

Today, oCERT published advisory 2015-003 describing a TLS vulnerability in MySQL and derivative products.  The content isn’t exactly news – it is documented legacy behavior and the subject of an earlier blog post describing how MySQL Server 5.7 solves the problem.  That said, the efforts of Duo Security are certainly appreciated and welcomed – it provides a meaningful context to discuss how to properly …

  [Read more...]
Introducing the Power of Notifications
+1 Vote Up -0Vote Down

Since VividCortex launched its database monitoring platform, many users have requested some type of notification system. To address this, we took particular care in building a feature that proactively warns users of potential problems without sending multiple false alerts.

We are excited to announce notifications via email, PagerDuty and VictorOps. This post addresses basic functionalities, but please explore the feature and provide feedback to support@vividcortex.com.

What triggers a notification? Our events dashboard records behaviors such as high swap activity, disc faults, replication stopping, mysql server …

  [Read more...]
Percona Acquires Tokutek : My Thoughts #2 : TokuMX and TokuMXse
+0 Vote Up -0Vote Down

A few days ago I wrote up my thoughts about the Percona acquisition of Tokutek with respect to TokuDB. In this blog I'm going to do the same for TokuMX and TokuMXse. And in a few days I'll wrap up this trilogy by sharing my thoughts about Fractal Tree Indexes.

Again, when I'm writing up something that I was very involved with in the past I think it's important to disclose that I worked at Tokutek for 3.5 years (08/2011 - 01/2015) as VP/Engineering and I do not have any equity in Tokutek or Percona.

  [Read more...]
Generated (Virtual) Columns in MySQL 5.7 (labs)
+2 Vote Up -0Vote Down

About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns.

The idea is very simple: if we store a column

`FlightDate` date

in our table we may want to filter or group by year(FlightDate), month(FlightDate) or even dayofweek(FlightDate). The “brute-force” approach: use …

  [Read more...]
Netbeans 8 – Fedora
+0 Vote Up -0Vote Down

Some of my students want to use the Fedora image that I built for my database classes in my Java software development life cycle course. As a result, they wanted a Java development environment installed. I examined JDeveloper 11g (11.1.1.7.0) and 12c (12.1.3) but resolved on the more generic Netbeans 8 (8.0.2) IDE.

JDK 7 with Netbeans 8 Download

You can download the generic Netbeans 8 IDE, the JDK 7 with Netbeans, or the …

  [Read more...]
Daily Reports Send Top Queries to Your Inbox
+0 Vote Up -0Vote Down

We know you are busy, and checking the VividCortex interface is not always on the top of your priority list. That’s why we implemented our proactive reporting feature.

Each day, your team will receive a recap of the top ten queries of each environment from the day prior. You can see at a glance whether systems were running smoothly or if you need to look into performance.

If daily reports are creating too much noise, you can subscribe to weekly reports instead. These will show the top ten queries of each environment from the week prior.

Of course, if you do not wish to receive the reports, simply unsubscribe.

This is …

  [Read more...]
Catena: A High-Performance Time-Series Storage Engine
+0 Vote Up -0Vote Down

There are plenty of storage engines out there, but none of them seem to offer fast and efficient time series storage and indexing. The existing options like RRDtool and Whisper aren’t very fast, and the fast options like LevelDB aren’t specifically made for time series and can lead to harsh operational issues. Instead of hacking on something like LevelDB to suit his needs, Preetam Jinka, one of the team’s brainiacs, decided to write his own storage engine.

Join us Tuesday, June 2nd at 2 PM EST (6 PM GMT), as Preetam Jinka covers the unique characteristics of time series data, time series indexing, and the basics of log-structured merge (LSM) …

  [Read more...]
10 Newer Entries Showing entries 121 to 130 of 34437 10 Older Entries

Planet MySQL © 1995, 2015, 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.