Latest training class schedule & events calendar just published
We’re excited to see that it’s going to be a busy time for the
MySQL & MariaDB communities over the coming months! Plenty of
community events are taking place, and we’re doing our best to
support and attend most of them.
With that in mind, this is where you’ll find the SkySQL Team,
often in cooperation with the MariaDB Team, at the following
events in the coming months:
Today I took the first day of MySQL for Beginners from Oracle’s Training on Demand offerings. From the course overview,
“This hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool. The course is suitable for new or existing users of MySQL who have little or no previous experience with a relational database management system.”
(For more details on this course, and other training offerings and formats, go to http://education.oracle.com .)
Here are some of my opinions and observations:
The class came up very easily for me, no glitches or waiting. (I used Firefox today. I’ll try IE tomorrow, then others.)
It feels a bit like being in an Oracle University classroom – you watch video of the instructor (Brent Dayley) giving the class. Brent Dayley is a great …
[Read more]The improved Performance Schema in MySQL 5.6 provides a new way of investigating issues in the database. Many issues that previously required tools such as strace, dtrace, etc. can now be investigated directly from inside MySQL in a platform independent way using standard SQL statements.
The Performance Schema is enabled by default starting from the latest milestone release, 5.6.6. You have instruments which are the things you can measure, and consumers which are those that use the measurements. Not all instruments and consumers are enabled out of the box, however once the plugin is enabled, individual instruments and consumers can be switched on and off dynamically.
As an example take the case mentioned in What’s the innodb main thread really doing? where the main InnoDB thread appears to be stuck in “doing …
[Read more]
Since MySQL Connect is just around the corner and
several of the sessions are related to the
replication features in MySQL 5.6, I figured I
would put together a quick MySQL Replication 101 Overview for any
of the new users.
Topology
First you must decide what type of Topology will be serve you and
your applications needs. Below are a list of …
Next Wednesday, September 19 at 10:00 AM PDT I will present a webinar on Percona XtraDB Cluster. The webinar focuses on the basics of XtraDB Cluster, we will install it, break it, fix it, and use HaProxy with it.
If you are looking to deploy XtraDB Cluster, or just curious about the basics, register for this free webinar at http://www.percona.com/webinars/percona-xtradb-cluster-installation-and-setup.
If you register for the webinar but cannot attend, you will still receive a link to the presentation recording and slides by email soon after the webinar so sign up now.
Ten years ago today the first public bug was filed on bugs.mysql.com.
As we also stumbled across an unfixed bug today that was reported almost exactly two years ago i came up with the idea of writing a little script that would report all bugs filed on exactly the same day one or more years ago that are still in an "active" state (open, verified, etc.).
The list for today can be found at
http://php-groupies.de/mysql-bugs/2012-09-12.html
And as i was already on it i also created a RSS feed for this at
I’ve mentioned this before, but I’m delivering a tutorial on Percona XtraDB Cluster / Galera at Percona Live NY 2012 right in midtown-Manhattan on October 1st.
I really want this tutorial to be hands-on, not just a 3 hour lecture, so you can actually see how a cluster operates and interact with it. So, I have come up with a set of walkthroughs for different features and areas of learning PXC using a common set of Virtual Machines setup with Vagrant and Puppet (which works on Linux, OSX, or Windows). This sounds complicated, but it basically means we can create a test environment with a full 3-node cluster on …
[Read more]pt-slave-delay is another great utility in the Percona Toolkit. Percona recently published a quick guide to using it, including how it can be helpful when somebody screws up.
http://www.mysqlperformanceblog.com/2012/09/11/how-to-lag-a-slave-behind-to-avoid-a-disaster
Monday evening, Max Mether from SkySQL came to the Boston MySQL User Group and presented “MariaDB: A MySQL Replacement?” We did take video and will link to it when it’s uploaded. That usually takes a while, so I figured I would link to the PDF slides, which Max has graciously shared.
Note that on slide 26, “All highly speculative” is a bit misleading when taken out of context. We know that MariaDB is working on all those things (including a Cassandra storage engine and Multi-source replication) because their worklogs and bug tracking system are 100% open, so that’s not the “highly speculative” part. We just do not know if they will be in the next production release of MariaDB.
If you’ve ever looked at the lsof or listing of
/proc/$pid/fd for a running MySQL server, you’ve
probably seen files like these:
# ls -l /proc/$(pidof mysqld)/fd/* | grep tmp
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/18 -> /var/lib/mysql/tmp/ibDOy0eD (deleted)
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/323 -> /var/lib/mysql/tmp/MLhfWsbz (deleted)
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/6 -> /var/lib/mysql/tmp/ib65H6A5 (deleted)
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/7 -> /var/lib/mysql/tmp/ibllu2yi (deleted)
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/8 -> /var/lib/mysql/tmp/ib9yRYwv (deleted)
lrwx------ 1 root root 64 Sep 12 10:21 /proc/17222/fd/9 -> /var/lib/mysql/tmp/ibhUCeRO (deleted)
What are those? It’s not hard to find out, actually. Just open
them and look at them! The ib* files are InnoDB’s
temporary …