MySQL Performance Blog on SkySQL

23 4월

MariaDB 5.5.37 was recently released (it is the latest MariaDB 5.5), and is available for download here:

https://...

23 4월

The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those...

17 4월

If you are installing MySQL ODBC Driver and encounter the following error:

Error 1918. Error installing ODBC driver MySQL ODBC 5.1 Driver, 
ODBC error 13: The setup routines for the...
17 4월

If you attempt to use ODBC to run a MySQL application and run into the following error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an 
architecture mismatch between the...
16 4월

The biggest concern with a slave is to ensure your data is consistent with the master! End of story!

3 of the biggest things I see when dealing with out-of-sync slaves:

  1. Many...
16 4월

Warning: it turned out that I used a full debug build instead of a release one, and that seems to make a hell of a difference ... most numbers have been updated now, the old...

14 4월


Dynamic columns came to my attention a few...

14 4월

I've had my own set of autotool macros for building against different MySQL client and server APIs for quite a while. Originally created as part of my code generator projects (...

11 4월


Trade show season is in full swing again for SkySQL: The MariaDB Company. Next week we will be attending the...

10 4월


We brought our finest to Percona Live this year!

Like most of you who attended Percona Live this year...

08 4월

MariaDB 10.0.10 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10...

02 4월

In a previous post, I discussed debugging stored procedures with RESIGNAL, which is of great value when troubleshooting errors raised by your...

02 4월

I was recently debugging a stored procedure and could not easily identify the underlying reason for why it was failing.

It had a standard exit handler catch-all for SQLEXCEPTION, which was...

02 4월

MariaDB replication in general works as follows: on a master server, all updates to the database are written into the binary log as binlog events, a slave server connects to the master and reads...