"Hey, Kris! We got a connection surge on $IMPORTANT_MASTER, and a short activity drop preceding that. All other graphs are flat."



and



I am looking.
Continue reading "Enemy Action"

As the title suggests, I will be giving a tutorial about MySQL Scaling Strategies for Developers.

I gave a similar tutorial last year at this conference, however, going over my old slides, I had to almost completely start from scratch.

Since last year, some things have changed  in the MySQL ecosystem and my experience and knowledge has improved as well. I also took on the feedback I had from last year and made changes:
The first part of the tutorial was slow and the second part (the more interesting part) was too fast.

This year, I promise that my tutorial will be between x2.5 to x7 better than it was last year.
Better in terms of higher quality content and better in terms of the knowledge you will remember after you leave.

I hope to see you …

To repeat myself (from “part 2″):

“a while back I wrote a post expressing a longing for wait-interface tuning”.

The original post, and “part 2″ were both written in 2007, while I was working for a startup in Pasadena, as a DBA.  Now I work for Oracle, supporting MySQL, and by now, MySQL has incorporated a wait interface.  So, to do justice, I am writing this “part 3″ and saying – it’s been done!

MySQL now has the performance schema, which instruments a vast number of events and waits.  The man page for the current GA version (5.5) is at http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html .   It’s a big chapter, as the wait interface is highly configurable and versatile.

…

Percona Live, London 2012 continues streak of “not to be missed” events in London, following the footsteps of Royal Wedding, Diamond Jubilee and Summer Olympics. We have prepared great set of Tutorials and Sessions for these two day event. Here is my personal selection of the talks I’d love to attend, though I rarely have such chance

MariaDB – All the New Features by Sergei Golubchik is a great overview of MariaDB features. If you’re interested to …

Two cons against NoSQL data stores read like this: 1. It’s very hard to move data out from one NoSQL to some other system, even other NoSQL. There is a very hard lock in when it comes to NoSQL. If you ever have to move to another database, you have basically to re-implement a lot [...]

MySQL’s SHOW STATUS and SHOW VARIABLES commands (or queries against the corresponding INFORMATION_SCHEMA tables) don’t always show what they say. In particular, SHOW STATUS contains several rows that aren’t status-related, but are really configuration variables in my opinion (and it is an opinion — sometimes the difference isn’t black and white).

Here’s a short list of some status counters that I think are really better off as configuration variables:

• Innodb_page_size
• Slave_heartbeat_period
• Ssl_cipher
• Ssl_cipher_list
• Ssl_ctx_verify_depth
• Ssl_ctx_verify_mode
• Ssl_default_timeout
• Ssl_session_cache_mode
• Ssl_verify_depth
• Ssl_verify_mode
• Ssl_version

Most of those are legacy, but Slave_heartbeat_period is a recent addition.

Can you think of others? What are your …

This webinar covers the basics of B-trees and Fractal Tree Indexes, the benchmarks we’ve run so far, and the development road map going forward.

Date: November 13th
Time: 2 PM EST / 11 AM PST
REGISTER TODAY

Topics will include:

• What is a Fractal Tree Index?
• How to Fractal Trees compare with B-Trees
• What can a Fractal Tree do for MongoDB performance
• Benchmarks + Gotchas
• What’s next

We look forward to having you join the webinar. We also hope that by sharing these results with the community we will be able to elicit people’s …

As a follow up to an earlier blog on the subject, please join us today at 0900 US PT to learn how to easily add policy-based auditing compliance to your existing MySQL applications.  This brief, informative session will provide an overview of the new MySQL Enterprise Audit plugin and will include a simple, practical step-by-step "how to" approach to get up and running with the new functionality.

You can learn more and secure your seat for the presentation here.

 Thanks for your continued support of MySQL!

This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. Why? Because your friends at Monitis.com care.

NoSQL or Traditional Database: From an APM Perspective There Isn’t Really Much Difference

Author: Michael Kopp.

If your application is executing more statements or downloading more data than is necessary, no amount of backend tuning will have your site running at the highest level of performance. This article serves as a reminder that the application accessing the data can be …

The European Organization for Nuclear Research (CERN) is one of the world’s largest and most respected centers for scientific research. Founded in 1954 and located near Geneva on the Franco-Swiss border, CERN was one of Europe’s first joint ventures. Today, it has 20 member states. The organization uses the world’s largest and most complex scientific instruments to study fundamental particles and the origin of the universe.

Challenges

• Better support the scientists associated with a CERN research program who selected MySQL as their database.
• Empower users, enabling them to be as self-reliant as possible.
• Minimize complexity and costs for the CERN IT department to support the growing number of MySQL deployments.

Solution

• Delivered a MySQL Database-as-a-Service offering to the CERN employees and the scientists associated with the organization.
…