Chriscalender - chriscalender.com - ChriSQL - Chris on MySQL
General Information:
Latest News:
Common Errors and Resolutions for Building your own MySQL or MariaDB C/C++ Program on Windows 19 Jul 2013 | 06:19 am
In my previous post, Creating a basic C/C++ Program to Interact with MySQL and MariaDB, I ran into some errors along the way, so I wanted to share those and their resolutions. 1. fatal error C1083: C...
Creating a basic C/C++ Program to Interact with MySQL and MariaDB 19 Jul 2013 | 04:36 am
In this post, I’ll cover how to create a simple C/C++ program that interacts with MySQL using the C API (and Connector/C). I discussed in a previous post how to install the C Connector (both SkySQL an...
Setting Up Connector/C and SkySQL C Connector for MySQL and MariaDB 19 Jul 2013 | 02:15 am
I’m writing a post on how to create your first C/C++ program for MySQL (using Windows, and from the command line). A prerequisite for that is to have a C Connector, such as MySQL Connector/C or SkySQL...
Resolving Error: master and slave have equal MySQL server UUIDs 18 Jul 2013 | 08:19 am
If you’ve run into the following error, then there area couple quick fixes: To give some background first, starting in MySQL 5.6, the server generates a true UUID in addition to the –server-id suppli...
Mitigating the Effect of Metadata Lock (MDL) Contention 16 Jul 2013 | 09:52 pm
If you see the “Waiting for table metadata lock” error, you may be wondering what is the best course of action to prevent it in the future. I have briefly discussed troubleshooting metadata locks befo...
Resolving Missing sys Include Files: devpoll.h, epoll.h, event.h, and queue.h during CMake when Building MySQL on Windows 3 Jul 2013 | 05:08 am
As I mentioned in a previous post that I’d mention how I resolved some additional missing include files when building MySQL on Windows. In this post I cover 4 missing header files, as they are all re...
Another Idea to Help Foster a Vibrant Community: Please make all bugs public 2 Jul 2013 | 04:07 am
Since MySQL recently implemented the following feature request (and discussed here and here) to help foster communication among public bugs and feature requests, and to provide a way to allow the Comm...
Resolving sasl/sasl.h Not Found during CMake when Building MySQL on Windows 27 Jun 2013 | 06:48 am
When building MySQL (5.6 in this case) on Windows, if starting from a new/plain machine, there are some headers/libs/etc. missing that many distributions contain and/or are easy to add. Resolving som...
Comprehensive How-To for Enabling the Standard InnoDB Plugin in MariaDB and MySQL 25 Jun 2013 | 06:31 am
I’m always switching back-and-forth between the 2 different InnoDB flavors in MariaDB – XtraDB+ and the standard InnoDB plugin, so I thought I’d simply post all of the various combinations in a single...
Setting the TZ Environment Variable for MySQL on Windows 25 Jun 2013 | 01:36 am
Most of us are familiar with how MySQL handles timezones, and what one must do to keep up with the latest changes, etc. Most of us use the system timezone info, which is great – one less item to updat...
