And that's a wrap! Check out the recording:

Hello!

Coming up this Wednesday, September 18th, 2013 at 12:00pm pacific (19:00 GMT) come and join #DBHangOps to discuss:

• Data warehousing in MySQL
  • Shipping large tables from production to your Data warehouse
  • Do you use Federated engine?
  • What other solutions do you use?
• Answer some questions about MySQL-isms (requested by Tim Callaghan)
  • Why does MySQL have FRM files instead of storing them in a data dictionary table?
  • Why doesn't InnoDB support other page sizes?
  • Why do we store data in a master.info file?
• What are you excited to see at MySQLConnect?

As always, take a look at …

The plug-able storage engine architecture is a design feature that is really separates MySQL/MariaDB from the pack. This feature allows for running the storage engine, or engines that best meet your table's needs. Choosing the right storage engine for your needs can make a huge impact on the performance of your database, but like many things in MySQL there can sometimes be too many options available to make the right choice clear.

read more

The MySQL Reference Manual advises:

Use a CREATE TABLE statement to specify the layout of your table:
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
...
Several types of values can be chosen to represent sex in animal records, such as 'm' and 'f', or perhaps 'male' and 'female'. It is simplest to use the single characters 'm' and 'f'.

I will supplement that with this post about representing sex (gender) in people records. I have to consider the name, the possible values, the data type, and the constraints. It won't be simplest.

Should the column name be 'sex'?

First consider …

Crap… ok. Looking at the notes – it’s fixed in mysql 5.6.13, but cluster 7.3.2 comes with 5.6.11.
I’m not knowledgable about compiling… so I’m only going to take 1 stab at extracting 5.6.13 source into the mysql-cluster-gpl-7.3.2 directory – then try to compile it.
Otherwise I’ll be doing 7.3.0! 🙂

aha you beat me to it.. i tried 7.3.2 and it wouldn’t compile.. so am assuming it would need a similar patch applied..

Nevermind! Found it.
http://bugs.mysql.com/bug.php?id=62769

The file ID for the patch is 17637. Do you know the bug number? I’m wondering if it is fixed in 7.3.2

Just mentioning it here because hard work deserves to be recognised and mentioned: Andrew McDonnell is doing an awesomely good job of testing, understanding and fixing bugs in OQGraph... which is no mean feat because the core of the code is based on the Boost Graph Library which isn't a trivial C++ library.

Back in my days at MySQL we had a lot of issues with test failures. We had lots of platforms, and would try to run and maintain our regression test suite on all of them. I remember spending days investigating issues on some obscure OS (Mac OS, mainly, Windows was taken care of) or hardware (little-endian, mainly) .
With Tarantool, we never got to do that. We do run buidls on lots of platforms, and someone always screams when they break, since we only run builds on platforms which are in actual use. And they do break, so it's a lot of hassle. But we haven't had time to maintain the regression tests on some of these platforms. Ugly? Yes. Yet we know which systems people use in production, and do take care of these. This set is much more narrow than the set of systems which people play with.
And also, we don't pay attention to test failures caused by, essentially, bad tests. If a test fails once in a while on a busy box, well, this is kind …

Back in my days at MySQL we had a lot of issues with test failures. We had lots of platforms, and would try to run and maintain our regression test suite on all of them. I remember spending days investigating issues on some obscure OS (Mac OS, mainly, Windows was taken care of) or hardware (little-endian, mainly) .
With Tarantool, we never got to do that. We do run buidls on lots of platforms, and someone always screams when they break, since we only run builds on platforms which are in actual use. And they do break, so it's a lot of hassle. But we haven't had time to maintain the regression tests on some of these platforms. Ugly? Yes. Yet we know which systems people use in production, and do take care of these. This set is much more narrow than the set of systems which people play with.
And also, we don't pay attention to test failures caused by, essentially, bad tests. If a test fails once in a while on a busy box, well, this is kind …