Reading about Window Functions.
Window Functions Overview
Reply
Tag Archives: mariadb
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;
ZFS performance tuning
I read The Next Gen Database Servers Powering Let’s Encrypt which mentioned how they tuned ZFS.
MariaDB Sequences
Today I discovered sequences in MariaDB. Gonna take them for a spin!
How to generate an SSL private key for use with MySQL/MariaDB and PDO
To generate an SSL private key for use with MySQL/MariaDB and PDO:
openssl genrsa -out client-key.pem 4096
MySQL Table Locking Issues
Today reading about MySQL Table Locking Issues. Of particular interest were the HIGH_PRIORITY and SQL_BUFFER_RESULT SELECT Statement options.