Oracle VM Site Review - Oracle VM Health Check
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

MySQL at SELF

The South East Linux Fest is next week in Charlotte, North Carolina and will feature a MySQL day on Friday with two FULL tracks.


MySQL Tracks for SELF

Data compression in InnoDB for text and blob fields

Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding 500MB (!!), and stored in a 100GB table. In this case we were not allowed to make any query or application logic changes so we chose to implement the Barracuda file format and utilize compressed rows as this appealed to me for this mostly-read application.

Percona at SELF

There is a great conference – SELF (South East Linux Fest) taking place in June 8-9 in Charlotte,NC
This conference has a great lineup for MySQL with 2 tracks on Friday dedicated to it. There are many great speakers both from Oracle and community on the list.
From Percona I will speak about Optimizing MySQL Configuration and Baron will talk about Forecasting MySQL Scalability from TCP Traffic.
See you there !

MySQL Innovation Day — live or webcast

MySQL Innovation Day is June 5th and you should attend in you are in the vicinity of Redwood Shores, California. But if you are not in the area, you can catch the live webcast. By the way, did I mention this is all free!

Agenda
9:00 a.m. Welcome and Introduction
9:10 a.m. Keynote: What’s New and Cool in MySQL
9:40 a.m.

Lightning Talks

Better Availability with InnoDB Online Operations

Getting rid of huge ibdata file, no dump required, part II

This post continues Getting rid of huge ibdata file, no dump required, part I, where I describe way of converting your single-tablespace InnoDB database into a file-per-table one, without the pain of exporting and importing everything at once.

In previous part we put aside the issue of foreign keys. We address this issue now.

Why I’m not an ACM member

I took a course on engineering ethics as part of my degree in computer science, and decided that it was very important for me to formally ascribe to a recognized code of conduct. This is not just a principle, but also an important legal matter in today’s litigious atmosphere. Court cases have literally been defended by engineers pointing to a code of ethics as their guidelines for actions and decisions.

MySQL 5.6 Replication – webinar replay

MySQL 5.6 Replication - Global Transaction IDs

Secure passwords being insecure

If you follow the general advices to create secure password the following ones seem to be secure, right?

  • s11P$||!sh&2
  • pr0&!!ke0
  • 3kj39|!381
  • The answer to the question is, “it depends on how you use them:)

    MySQL Cluster 7.1.22 is available for download

    The binary version for MySQL Cluster 7.1,21 has now been made available at https://www.mysql.com/downloads/cluster/7.1.html#downloads (GPL version) or

    view counter