I happened upon the selectSQLText function in the MediaWiki source code and learned how to set a query timeout in either MySQL or MariaDB. Good to know!
Setting query timeout for MySQL or MariaDB
Reply
Tag Archives: mariadb
MySQL/MariaDB Identifier Length Limits
Two simple ways to version control your MariaDB schema changes
Over on Two simple ways to version control your MariaDB schema changes I learned a neat hack you can use to check for database schema revisions by reporting off the binlog.
The example command given was:
$ mysqlbinlog --no-defaults -R -u foo -p -d foodb -h db.home.arpa mysqld-bin.000001 > foodb.txt
Database Workbench from Upscene Productions
My copy of MySQL Workbench doesn’t play 100% nice with my MariaDB install, so I checked out the Database Workbench software recommended by MariaDB and in the end I downloaded a trial version. It runs okay under Wine, so gonna check it out.
Window Functions Overview
Reading about Window Functions.
LibreOffice Base ODBC config
Here’s some good info for configuring ODBC for MariaDB on Ubuntu for use from LibreOffice Base: LibreOffice Base and MariaDB. The same article also has some info about how to use ENGINE=CONNECT for importing JSON from web services.
SQL Query Stuck in Statistics State
I had this problem which is explained in greater depth over here.
Useful MariaDB Queries
PHP prepared statements and stored procedures
Here’s some good documentation on PHP prepared statements and stored procedures including how to call stored procedures with output parameters.
Ignoring MySQL constraints
You can disable foreign key checks with
SET foreign_key_checks = 0;
And you can disable unique index checks with
SET unique_checks = 0;