Archive for the ‘MariaDB’ Category

MariaDB’s federatedx engine

I’ve been experimenting a little with the federatedx engine in MariaDB. For those of you coming from MSSQL think linked servers and that’s pretty much it, albeit with a few differences. Here’s a quick primer on the basics. Firstly you might need to enable the engine… ?View Code MYSQL# Try "SHOW ENGINES" if federated isn’t […]

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 […]