Archive for December 2014

UNKNOWN STORAGE ENGINE ‘FEDERATED’

You may receive the following error with MariaDB on a Windows platform when attempting to create a table using the federatedx engine. 1 queries executed, 0 success, 1 ERRORS, 0 WARNINGS QUERY: CREATE TABLE t1 ENGINE=FEDERATED CONNECTION=”server” Error CODE: 1286 UNKNOWN STORAGE ENGINE ‘FEDERATED’ Execution TIME : 0 sec Transfer TIME : 0 sec Total […]

Bash script to execute a MariaDB query multiple times

This simple bash script will execute a query 100 times against a MySQL instance. It also uses the time command to report how long the entire process took. I use this for some very simple bench-marking. The query used here creates a temporary table and inserts 100K rows into it. You need the sequence engine […]