Yes, finally! This took some time, but I have been so busy with
other things, work-related as well as domestic, that I just
haven't had the time for this. But finally version 1.6 is
available for download from sourceforge. The downloads is as
usual the autoconf enabled source code and PDF documentation in
PDF.
So, what is new you ask, well there is one big new feature which
took a lot more effort than I expected. When this program was
written at first, I still have the table/use use in mind. What
this means is that I visioned JSON objects to be mapped to a
table. This is not how programmers view JSON, but this is how
data is viewed in many databases, even NoSQL ones such as
MongoDB. So I wanted an import tool for simple row-structured
JSON objects.
Now, there is a different way to look at things, which is …
Here’s the recording!
Heyo!
Now that we’ve gone through the Percona Live MySQL Conference and Expo review and had an amazing turnout to talk about it, it’s time to open up the discussion around things that DBAs want to talk about and need to be conscientious of. Join us on Wednesday at 12:00pm PDT (19:00 GMT) to take part in the discussion and share your knowledge and experience with the following topics:
- Filesystems and MySQL — Which do you use and why?
- Do you handle I/O alignment? How do you do it?
- Scheduler changes?
- Nagios checks! — Any new checks you’ve added recently?
- The worst settings in MySQL that you always change
- What are the most important variables to you, and what do you set them to?
- What will be important variables in 5.6 that …
This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who also are in a DBA role.
News
Continuent's Tungsten Replicator is now completely
open source
TokuDB is now open source
Original images from Flickr user jenniferwilliams
One of our clients, for various historical reasons, runs both MySQL and PostgreSQL to support their website. Information for user login lives in one database, but their customer activity lives in the other. The eventual plan is to consolidate these databases, but thus far, other concerns have been more pressing. So when they needed a report combining user account information and customer activity, the involvement of two separate databases became a significant complicating factor.
In similar situations in the past, using earlier versions of PostgreSQL, we've written scripts to pull data from MySQL and dump it into PostgreSQL. This works well enough, but we've updated …
[Read more]This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.”
In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks.
Other areas of focus include:
- Bottlenecks with Disk IO
- Problems with excessive temporary tables and external sorts
- Excessive internal mutex contention …
MySQL Enterprise Edition included the thread pool in its MySQL
5.5 version. We have now updated the thread pool also for the
MySQL 5.6 Enterprise Edition.
You can try it for free at trials
The MySQL thread pool is developed as a plugin and all the
interfaces needed by the thread pool are part of the MySQL
community server enabling anyone to develop their own version of
the MySQL thread pool. As part of the development of the thread
pool we did a lot of work to make it possible to deliver
stand-alone plugins using the interfaces provided by the MySQL
server. Most of these interfaces were available already in MySQL
5.1, but we extended them and made them more production ready as
part of MySQL 5.5 development. So a plugin can easily define
their own configuration variables and their own information
schema tables and also easily use performance schema extensions.
A …
The MySQL for Beginners course is your first step to getting started on the MySQL Database.
This four-day, live, instructor-led course is your chance to learn about this powerful relational database management system - MySQL is the most popular open source database in the world.
You can take this course as a:
- Training-on-Demand: Follow this class at your own pace through streaming delivery of lecture material and booking time to perform exercises.
- Live-virtual event: Participate in this class from your own desk - no travel required. Choose from a selection of events on the schedule to suit different time zones.
- In-class event: Travel to an education center to take this class. Below is s selection …
This is one close to my heart. I’ve recently written on other storage engines: Where are they now: MySQL Storage Engines, The MERGE storage engine: not dead, just resting…. or forgotten and The MEMORY storage engine. Today, it’s the turn of MySQL Cluster.
Like InnoDB, MySQL Cluster started outside of MySQL. Those of you paying attention at home may notice a correlation between storage engines not written exclusively for MySQL and being at all successful.
NDB (for Network DataBase) started inside Ericsson, originally written in a language called …
[Read more]At Open Query we steer clear of code development for clients. We sometimes advise on code, but as a company we don’t want to be in the programmer role. Naturally we do write scripts and other necessities to do our job.
Assisting with an Open Source project, I encountered three old UDFs. User Defined Functions are native functions that are compiled and then loaded by the server similar to a plugin. As with plugins, compiling can be a pest as it requires some of the server MySQL header files and matching build switches to the server it’s going to be loaded in. Consequentially, binaries cannot be considered safely portable and that means that you don’t really want to have a project rely on UDFs as it can hinder adoption quite severely.
Since MySQL 5.0 we can also use SQL stored functions and procedures. Slower, of course, but …
[Read more]Here's the recording!
Heyo!
Now that we've gone through the Percona Live MySQL Conference and Expo review and had an amazing turnout to talk about it, it's time to open up the discussion around things that DBAs want to talk about and need to be conscientious of. Join us on Wednesday at 12:00pm PDT (19:00 GMT) to take part in the discussion and share your knowledge and experience with the following topics:
- Filesystems and MySQL -- Which do you use and why?
- Do you handle I/O alignment? How do you do it?
- Scheduler changes?
- Nagios checks! -- Any new checks you've added recently?
- The worst settings in MySQL that you always change
- What are the most important variables to you, and what do you set them to?
- What will be important variables in 5.6 that you should set? …