I’m looking forward to being at Percona Live Santa Clara 2014 later this year (April 1-4 2014). You should definitely register now. Early bird ends soon, and if you’re looking for a discount, here’s a 10% discount code - SeeMeSpeak.
SkySQL will have a booth. I’m hoping the DotOrg Pavillions continue, so that MariaDB can have a booth too.
If you want to know about MariaDB 10, come to the complete tutorial given by Ivan Zoratti and me. MariaDB 10 …
[Read more]I wish more discussion happened on the internals mailing list, but if you’re interested in finding out what’s upcoming/changing in MySQL 5.7, so far the best resources I’ve found are:
I’ve blogged about metadata locks (MDL) in the past (1 2 3) and in particular discussed how best to track them down and troubleshoot threads stuck waiting on metadata locks.
If you’ve had any experience with these, you’ll know finding them isn’t always the most straight-forward task.
So I was glad to see metadata lock instrumentation added to MySQL 5.7.3 as part of performance_schema, which makes tracking these down a breeze! (Note this is only in 5.7.3 currently, and therefore is some time from being GA as of today)!
To use these, performance_schema must be enabled (i.e., performance_schema=1 in your config file).
But, also, the metadata_locks instrument is disabled by default, so even if you enable the …
[Read more]
I believe in automation as much as possible, and I'm always
working to make the day to day tasks of operations as smooth as
possible. Also I try not to be afraid to take good tools
and make them better.
Here in Database Ops at Box, we use pt-kill running as a service
to constantly monitor our servers and help protect against long
running queries. But our thresholds are pretty generous,
and in some cases it's possible for unforeseen circumstances to
cause enough queries to storm the database such that we can have
problems before any of them hit the threshold for "busy time."
Ditto for idle connections.
The response is that someone has to be available to manually run
another copy of pt-kill with much lower thresholds to clear out
these thundering herds. But what if we could let pt-kill
handle both the "normal" mode and still protect us from
herds?
That's what we've done by adding a …
ConFoo, the conference for web developers, is hosting its fifth edition. It will take place in Montreal at the Hilton Bonaventure on February 26th – 28th. These five days are packed with great technical talks and semi-private trainings on your favorite technologies.
It’s definitely a conference for IT professionals, wether you are a developer, integrator or project manager. With its 150 talks, you are sure to find a presentation that will help you grow your core skills. Among them you can find :
Meet the experts who crafted your programming language or framework, and who push the technology to a new level. Exchange …
[Read more]The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.0, the latest addition to the MySQL Installer for Windows.
MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:
MySQL for Excel is installed using the MySQL Installer for Windows. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.
You might don’t know that, but the MariaDB engines are amazing
..
More info you can find here:
https://mariadb.com/kb/en/mariadb-storage-engines/
I was teased by CONNECT engine : https://mariadb.com/kb/en/connect/
What is good for ? Well, I leave that to your imagination, as you
could have MariaDB as a spider connected and managing InnoDB
tables, flat files, MS ACCESS databases, MS Excel files … all
that in same time.
So how to use it?
By the documentation :
1. https://mariadb.com/kb/en/loading-the-connect-handler/
check if there is CONNECT already installed, if not, install it:
mysql root@mariadb-10.0.7:[Wed Jan 29 09:36:14 2014][(none)]> show …[Read more]
|
February was yet so far.. - and finally it's just tomorrow, starting with MySQL & Friends Dev Room at FOSDEM 2014 in Brussels. I have a talk about "Starting with MySQL PERFORMANCE SCHEMA" - in fact I would call it rather "Using PFS with zero configuration" ;-) -- many people are thinking PFS is complicate, while in reality it's very simple, and just need little bit of love ;-) Since MySQL 5.6 PFS is enabled by default, and as the result - there are several very useful instrumentation stats available out-of-the-box, and my talk will be about them.. Of course I'll speak about MySQL Performance as well, and feel free to ask any questions about. Also, don't miss talks from our MySQL Team : … |
As many of you know, I’ve been working in the MySQL world for quite a while now. IN fact, it was nearly 10 years ago when I first started hacking on MySQL Cluster at MySQL AB.
Most recently, I was at Percona which was a wonderful journey where over my nearly three years there the company at least doubled in size, launched several new software products and greatly improved the quality and frequency of releases.
However the time has come for something completely different. The MySQL world is rather mature, the future of …
[Read more]Oracle’s MySQL team is running Tech Tours in multiple cities across the US and Europe during the upcoming months. Register now for the following free events: