Memory Leak

Memory Flame Graph    

Your application memory usage is steadily growing, and you are racing against time to fix it. This could either be memory growth due to a misconfig, or a memory leak due to a software bug. For some applications, performance can begin to degrade as garbage collection works harder, consuming CPU. If an application grows too large, performance can drop off a cliff due to paging (swapping), or the application may be killed by the system (OOM killer). You want to take a quick look before either occurs, in case it’s an easy fix. But how?

Debugging growth issues involves checking the application config and memory usage, either from application or system tools. Memory leaks are much …

Does size matter? This question has been teasing mankind since the beginning. But now, due to improvements in technology, size doesn’t really matter. Databases now have the features to tackle all data: big, medium, small, or very small. This Log Buffer Edition is here once again to bring you your data news of all sizes.

Oracle:

Marco tells us how to create a pluggable database by cloning an existing local PDB and talks about a bug in Oracle 12c.

Niall installs …

MySQL Connect is rapidly approaching and one of the speakers is Peter Zaitsev, CEO of Percona. Peter volunteered to participate in our survey of MySQL Community Members.

What are your speaking about at your session?
I’m speaking about indexing best practices for MySQL, specifically focusing at a new ways MySQL 5.6 can use indexes and what opportunities does it bring.

Who would benefit most from attending your session?
This is a topic of broad interest. Developers and DBAs both need to be very familiar with a way MySQL can use sessions.

What other sessions would you recommend or are planning to attend?
There are a lot of wonderful sessions this year. Specifically I will look forward to the product information from Oracle team – MySQL 5.7 and direction of the MySQL group with State of the …

My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.”

This is a popular topic with news breaking routinely that yet another Internet company has leaked private data of one form or another. Ernie’s webinar will be a great overview of security MySQL from top to bottom, including changes related to security in the 5.6 release.

Topics to be covered include:

• Basic …

September 12, 2013, Reston VA

Please join us and learn how many government agencies such as NASA, Census, NARA and DoD deploy MySQL as the default database for their mission critical applications. Oracle MySQL experts will be available to introduce new features in MySQL 5.6, MySQL Cluster 7.3, and discuss the new enterprise extensions.

First I find out the first commit that is in 5.7 that isn’t in 5.6 (using bzr missing) and then look at the authors of all of those commits. Measuring the number of commits is a really poor metric as it does not measure the complexity of the code committed, and if your workflow is to revise a patchset before committing, you get much fewer commits than if you commit 10 times a day.

There are a good number of people who are committing a lot of code to the latest MySQL development tree. (Sorry for the annoying layout of “count. number-of-commits name”)

1. 1022 Magnus Blaudd
2. 723 Jonas Oreland
3. 329 Marko Mäkelä
4. 286 Krunal Bauskar
5. 230 Tor Didriksen
6. 218 John David Duncan
7. 205 Vasil Dimov
8. 197 Sunny Bains
9. 166 Ole John Aske
10. 141 Marc Alff
11. 141 Frazer Clement
12. 140 Jimmy Yang …

MySQL Connect is rapidly approaching but there is still time for you to register. Calvin Sun from Twitter is going to be speaking and is the second of prominent MySQL Community members in this blog series to show you why you should join us.

What are your speaking about at your session?
MySQL at Twitter.

Who would benefit most from attending your session?
Scaling MySQL.

What other sessions would you recommend or are planning to attend?
MySQL 5.6 at Facebook [CON7798]
MySQL Performance: Benchmarks, Tuning, and “Best” Practices [CON2971]
MySQL @ Facebook: Lots and Lots of Small Data [CON7446]
InnoDB: Table and Index Data Structures Architecture [CON6897]
The InnoDB Buffer Pool and I/O: How It All Works [CON3497]
Unlocking MySQL: Dealing with Locking in MySQL …

Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to …

MySQL Connect is very quickly approaching and I will have some insights from prominent members of the MySQL Community about why you should join us September 21st-23rd in San Francisco. Mark Callaghan of Facebook is the first subject and his answers are short, sweet, and concise.

What are your speaking about at your session?
The reasons and process of upgrading to 5.6.

Who would benefit most from attending your session?
People considering 5.6

What other sessions would you recommend or are planning to attend?
All of the sessions on InnoDB internals

Why should ‘Joe Average’ DBA or Developer attend MySQL Connect?
Learn more, network with others in the community, let Oracle know what you need in MySQL 5.7

A big thanks to Mark for being the first …

Our bigger customers where we help to deploy Galera Cluster for MySQL set-ups have some commercial hardware (e.g. F5 or Cisco) for load balancing instead of software load balancers.

For those hardware load balancer it is not possible to see if a Galera node is available or not because the MySQL daemon is still running and responding on port 3306 but the service is not available nonetheless.
So the load balancer still serves the Galera node while he feeds for example a joiner node with a SST. This would lead to application errors which is unlovely.

One can try somehow to teach the load balancer to find out if a Galera Cluster node is really available or not. But this requires a more sophisticated load balancer, know-how how to teach the load …