MySQL Workbench Workbench is the MySQL official GUI tool to access the MySQL database engine. The tool is very user friendly and a DBA does …Read More »
Connect to MySQL Server without password in safe mode
This article contains information about mysql safe mode such as start mysql in safe mode, find mysqld_safe location, changing password. MySQL Safe Mode Sometime you …Read More »
MySQL-How to drop a large table gracefully?
Description: Drop tables is such a common content of a DBA’s daily work. Drop a small table( such as less than 100 Mega Bytes ), we …Read More »
MySQL — The DATETIME column rounding causes data inconsistency
Description: Recently, when i checked my data on two MySQL servers( version: 5.7.17 ), i found data differences between to servers, which surprised me. Because …Read More »
Alter large MySQL table without blocking reads or writes with pt-online-schema-change
pt-online-schema-change is a binary part of Percona-toolkit packages by Percona. It’s one of the most stable and efficient, tools for performing large MySQL table structure change in …Read More »
MySQL Crashed by OOM Killer (out of memory). Why? How to prevent them?
Do the operating systems kill your MySQL instances from time to time? Are some database servers swapping constantly? These are relatively common problems. Why? …Read More »
How To Install MySQL 5.7 Community on Ubuntu
Introduction MySQL, the most popular Open Source SQL database management system developed, distributed, and supported by Oracle Corporation. In this article we’ll go over …Read More »