lower #crisp api system CPU load on 14 servers by 15% by adding a LRU cache on the common authorization check done on all routes, hitting MySQL everytime and now cache hitting most of the time

improve performance of #crisp api by caching user authorization grants for 20s in a LRU cache, avoiding roundtrips to our MySQL server for every single API request

Client work: find attachments with apostrophes in the filename causing issues in S3 in MYSQL DB #upgroves

Migrated from MySQL to Postgres in every project. What made me switch: - Rich Types: Native UUIDs, Arrays & JSONB eliminate messy workarounds. - Safety: Strict data integrity & transactional DDL (no broken migrations). - Future-proof: Built-in AI (pgvector) & Geo (PostGIS). #saasmakers #resilienceclub #thecompaniesapi

keep moving everything to postgresql to ditch mysql #saasmakers #thecompaniesapi

explore MySQL database for usage data

Increase MySQL concurrent connections limit because the server is busy busy #jomo

Clean up mysql DB #villasmediterranean

look into mysql config and ask AI for optimisation help

fix mysql server #freelance

helped my son on a school assignment: create a PHP page containing a shop connecting to MySQL: shop.backl.io/

Try to migrate from MySQL to PostgreSQL

Client work: update 2 forms, check issue with forms-MySQL DB integration found while recording Purchase Order demo, PM work, tech stand-up meeting

Save some RAM on my tiny server by disabling MySQL performance_schema #life

#contracting Learn how to set up MySQL replication so we can keep our data in sync between prod and staging

recover mysql 8 from downtime since it was killed by orchestrator because it outgrew its defined memory limit, this thing is heavier than I thought #life

Wrote a simple screenshot logs ingestion logic to ClickHouse from MySQL for #screenshotone. Should I deploy to production? 🤔

Fixed a bug that caused mysql connections to pile up and never close in my php #seolabs

finished testing mysql dump import, successful #seolabs

Improving the automatic backup of mysql via script and cron following testing #seolabs