Mechanics of Flite

Posts

Oct 3, 2016
Replacing JSON UDF calls with native function calls in MySQL 5.7
Sep 21, 2016
Speaking at Percona Live Amsterdam 2016
Jul 22, 2016
Avoiding MySQL ERROR 1784 when replicating from 5.7 to 5.6
Jun 30, 2016
Column Level Privileges in MySQL
May 24, 2016
MySQL Keywords and Reserved Words
Apr 11, 2016
Time Zone Conversion in MySQL
Apr 1, 2016
Announcing MySQL BRO Schema
Mar 28, 2016
Simplifying MySQL partition management using common_schema
Feb 5, 2016
Finding and deleting orphaned rows in MySQL
Oct 16, 2015
Preparing your MySQL schema for a character set change
Sep 30, 2015
Prepping your MySQL indexes for a character set change
Jul 24, 2015
Testing the MySQL JSON Labs Release using MySQL sandbox
Jul 16, 2015
Using MySQL sandbox for upgrade testing
Jul 15, 2015
The downside of the MySQL 5.6 implicit temporal column format upgrade
Jul 13, 2015
Identifying temporal columns in old format in MySQL 5.6 and above
Jun 9, 2015
Hash-based workarounds for MySQL unique constraint limitations
Jun 3, 2015
Groupwise most frequent value query in Hive
Jun 2, 2015
Adding a unique constraint with more than 16 columns in MariaDB
Apr 13, 2015
Using MySQL 5.7 Generated Columns to Avoid ERROR 1070
Apr 8, 2015
Speaking at Percona Live 2015
Apr 1, 2015
Introducing pt-reanimate
Mar 12, 2015
Avoiding MySQL ERROR 1052 by prefixing column names in multi table queries
Mar 3, 2015
Updating millions of rows in MySQL with common_schema
Jan 13, 2015
Adding a unique constraint with more than 16 columns in MySQL
Dec 12, 2014
Loading large flat files into MySQL with LOAD DATA INFILE and pt-fifo-split
Dec 5, 2014
Using MySQL Sandbox to test replication behavior
Dec 4, 2014
How to safely replicate UUID values in MySQL
Nov 25, 2014
Handling invalid numeric values in Hive
Nov 24, 2014
Alternatives for chunking bulk deletes in common_schema
Oct 8, 2014
Avoiding MySQL ERROR 1069 by explicitly naming indexes
Sep 29, 2014
A workaround for MySQL ERROR 1070
Sep 12, 2014
Simulating Add Column If Not Exists in MySQL with common_schema
Jul 29, 2014
Using innodb_large_prefix to avoid ERROR 1071
Jul 28, 2014
Replacing pt-slave-delay with MASTER_DELAY in MySQL 5.6
Jul 8, 2014
Fine-Tuning MySQL Full-Text Search with InnoDB
Jul 7, 2014
Testing MySQL FULLTEXT indexes in InnoDB using pt-upgrade
Jun 3, 2014
MyISAM crash recovery, and triggers
May 22, 2014
Re-installing common_schema after upgrading to MySQL 5.6
May 1, 2014
Upgrading temporal columns from MySQL 5.5 to MySQL 5.6 format
Apr 29, 2014
Disabling binlog_checksum for MySQL 5.5/5.6 master-master replication
Apr 16, 2014
Using explode and lateral view in Hive
Apr 1, 2014
Recovering MySQL data from the BLACKHOLE storage engine
Mar 27, 2014
Avoiding data loss with older versions of pt-table-sync
Mar 26, 2014
Cloning MySQL users with common_schema
Feb 18, 2014
The difference between UDFs and stored functions in MySQL
Feb 14, 2014
Faster JSON parsing using MySQL JSON UDFs
Feb 12, 2014
Fast-forwarding a delayed MySQL replica
Feb 11, 2014
Overriding MySQL current_timestamp default on update
Jan 29, 2014
Speaking at Percona Live 2014
Jan 28, 2014
Finding and Removing Duplicate Indexes in MySQL with common_schema
Jan 8, 2014
The IN Operator in Cassandra CQL
Nov 26, 2013
Wide rows in Cassandra CQL
Nov 18, 2013
An advantage of MySQL row-based replication
Nov 7, 2013
One advantage of MySQL statement-based replication
Nov 6, 2013
MySQL binary log parsing with pt-query-digest
Nov 5, 2013
Breaking down the CQL where clause
Nov 4, 2013
Improved foreign key error messages in MySQL 5.6
Nov 1, 2013
How to do an upsert in Cassandra
Oct 2, 2013
Cassandra's search problem
Oct 1, 2013
Some thoughts on the MySQL REPLACE command
Sep 30, 2013
How to do an upsert in MySQL
Aug 13, 2013
Analyzing Apache Access Logs in Hive Without RegexSerDe
Jun 20, 2013
Executing complex deletes with common_schema
Jun 19, 2013
Counting tokens with common_schema
Jun 18, 2013
Closing the unique index null loophole
May 21, 2013
Implementing asynchronous cascade delete in MySQL
May 3, 2013
The downside of MySQL auto-reconnect
Apr 8, 2013
JSON Parsing in MySQL Using common_schema
Apr 1, 2013
Hidden Gems in Percona Toolkit
Mar 18, 2013
Helping common_schema help me
Mar 1, 2013
Enabling InnoDB compression on tables with heavy rows
Feb 21, 2013
A fail-fast first test of MySQL backup integrity
Feb 12, 2013
Why I use ONLY_FULL_GROUP_BY
Feb 5, 2013
Capturing errors and warnings from LOAD DATA INFILE
Jan 28, 2013
The other reason you need unique server_ids in MySQL replication
Jan 7, 2013
A simple way to make MySQL replication more crash-safe
Nov 15, 2012
3 Methods to Extract a Subset of Your Data Using mysqldump
Sep 27, 2012
Don't Quote me
Sep 7, 2012
Do as I Do, Not as I Say
Jul 16, 2012
Monitoring auto increment capacity in MySQL
Jul 6, 2012
Why I don't use sysdate in MySQL
Jun 29, 2012
3 Gotchas When Changing a MySQL Column Attribute
Jun 12, 2012
5 Tricks to Avoid MySQL Replication Delays