Today I read The Surprising Impact of Medium-Size Texts on PostgreSQL Performance which popped up on reddit.
Category Archives: Database
Null
Stumbled upon the Null (SQL) Wikipedia article. Looks interesting. Will read.
MariaDB Sequences
Today I discovered sequences in MariaDB. Gonna take them for a spin!
watch catting together HTML head/foot and MySQL information_schema.processlist
This came up back on August 9th 2020 in #lobsters on freenode. They were doing a system upgrade and providing a report by using `watch` to `cat` together a HTML header and footer with `mysql -e ‘select * from information_schema.processlist’` to provide a status report. Thought that was a neat hack.
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.