MySQL Workbench 6.3.4 GA has been released
The MySQL developer tools team announces 6.3.4 as our GA release for MySQL Workbench 6.3. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html For discussion, join the MySQL Workbench Forums: http://forums.mysql.com/index.php?151 ...

Getting Started With MySQL & JSON on Windows
MySQL is getting native support for JSON.  This blog post will show you how to quickly get the MySQL server with these new features running on your Windows rig and how to write a small C# program in Visual Studio 2015 that stores a JSON document using the new native JSON data type. Schema or...

Improving the Performance of MySQL on Windows
In this blog entry I’d like to describe how you might be able to improve how MySQL performs on Windows by ensuring that you take advantage of a Windows specific configuration setting. On Unix systems, MySQL programs treat the localhost host name specially. For connections to localhost, MySQL...

The InnoDB Change Buffer
One of the challenges in storage engine design is random I/O during a write operation. In InnoDB, a table will have one clustered index and zero or more secondary indexes.  Each of these indexes is a B-tree.  When a record is inserted into a table, the record is first inserted into clustered...

Using Perl and MySQL to Automatically Respond to Retweets on Twitter
In my previous post, I showed you a way to store tweets in MySQL, and then use Perl to automatically publish them on Twitter. In this post, we will look at automatically sending a “thank you” to people who retweet your tweets — and we will be using Perl and MySQL again. Just like...

Using Perl to Send Tweets Stored in a MySQL Database to Twitter
Using twitter can sometimes feel like driving downtown, screaming what you want to say out the window, and hoping someone hears you. There might be tens of thousands of people downtown, but your message will only be heard by a few. Because of this, your best bet is to repeat your message as often...

Fedora 22 is out, and we’re ready
Fedora 22 arrived yesterday. With a cutting edge GCC (5.1), the new DNF package management system, and improved tooling for server administration, we congratulate the Fedora community on yet another innovative release. We’re following up from our side, and as of yesterday our repos offer...

Creating and Restoring Database Backups With mysqldump and MySQL Enterprise Backup – Part 2 of 2
In part one of this post, I gave you a couple examples of how to backup your MySQL databases using mysqldump. In part two, I will show you how to use the MySQL Enterprise Backup (MEB) to create a full and partial backup. MySQL Enterprise Backup provides enterprise-grade backup and recovery for...

Creating and Restoring Database Backups With mysqldump and MySQL Enterprise Backup – Part 1 of 2
Part 1 of 2: (part two) If you have used MySQL for a while, you have probably used mysqldump to backup your database. In part one of this blog, I am going to show you how to create a simple full and partial backup using mysqldump. In part two, I will show you how to use MySQL Enterprise Backup...

MySQL Repos for Debian 8
Hi, everyone. Just a quick note here to let you all know that we’ve just added Debian 8 support to our Apt repos. We have the latest MySQL Server 5.6 ready for you, as well as the latest 5.7 Development Milestone, and more of our products for Debian 8 are in our QA pipeline as...

InnoDB 전문 검색 : N-gram Parser
기본 InnoDB 전문 검색(Full Text) 파서는 공백이나 단어 분리자가 토큰인 라틴 기반 언어들에서는 이상적이지만 개별 단어에 대한 고정된 구분자가 없는 중국어, 일본어, 한국어(CJK)같은 언어들에서는 각 단어는 여러개의 문자들의...