Mastodawn

PrecisionSQL 1h ago

How to Stop MySQL From Scanning With FIND_IN_SET

FIND_IN_SET bypasses indexes and burns CPU.

#mysql #findinset #performance #howto #schema #query

https://www.youtube.com/watch?v=qaLrnjZIcSE

How to Stop MySQL From Scanning With FIND_IN_SET #howto

YouTube

Show thread

Magical Cat 18h ago

@hostinger
Codee barely able to get through, and all it can do is to cry about 45% CPU usage of MySQL. Due to "non-standard" configuration from Docker installaitons "shop" of Docker Manager.
Looks like using of docker is not best choice ever, as I can't use nor terminal properly neither Codee can't operate over it directly.
I can't investigate why CPU usage skyroketed.

There is no any "table below" (see image).

#hostinger #selfHosting #WordPress #MySQL #FriendsPlugin

PrecisionSQL 1d ago

How to Prevent Slow Query Log From Filling Your Disk

One bad query. Millions of log lines.

#mysql #slowquery #log #howto #production #monitoring

https://www.youtube.com/watch?v=rmbArOL0UYQ

How to Prevent Slow Query Log From Filling Your Disk #slowquery

YouTube

PrecisionSQL 1d ago

How to Stop AUTO_INCREMENT From Reusing After Restart

Recycled IDs can break your caching.

#mysql #autoincrement #reuse #howto #ids #gotcha

https://www.youtube.com/watch?v=AMm1JExqDbU

How to Stop AUTO_INCREMENT From Reusing After Restart #mysql

YouTube

Shyim 1d ago

https://letter.3306-db.org/ #mysql

Open Letter — Invitation to Discuss the Future of the MySQL Ecosystem

The MySQL Ecosystem Needs Independent, Vendor-Neutral Governance. Add your name to the open letter.

エミリーSEレクト 1d ago

DB設計入門講座#03 トランザクション管理について【MySQL/SQL講座】

https://www.emilyselect.com/db%e8%a8%ad%e8%a8%88-%e5%85%a5%e9%96%80%e8%ac%9b%e5%ba%a703-%e3%83%88%e3%83%a9%e3%83%b3%e3%82%b6%e3%82%af%e3%82%b7%e3%83%a7%e3%83%b3%e7%ae%a1%e7%90%86%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6%e3%80%90mysq/?feed_id=5200&_unique_id=69c9bdf3b21ab&Mastodon

#DB設計 #ITエンジニア #MySQL #mysql入門 #SIer #SQL #SQL入門 #SQL初心者 #SQLとは #システムエンジニア #データベース #データベース設計 #プログラマー #プログラミング #入門講座 #未経験 #DB・SQL基礎・入門 #DB・SQL基礎・入門 #DB設計 #ITエンジニア #MySQL #mysql入門 ...

PrecisionSQL 1d ago

How to Batch INSERTs to Slash Replication Lag

One bulk insert instead of a thousand tiny ones.

#mysql #insert #replication #howto #batch #performance

https://www.youtube.com/watch?v=zS8u3pk-p4k

How to Batch INSERTs to Slash Replication Lag #insert

YouTube

Rad Web Hosting 1d ago

How to Install #ClusterControl on #AlmaLinux VPS This article provides a guide for how to install ClusterControl on AlmaLinux VPS.
What is ClusterControl?
ClusterControl is a robust #database management platform that simplifies deployment, management, and scaling of database clusters. If you’re using AlmaLinux VPS for your infrastructure, this guide will walk you through installing ClusterControl seamlessly. ...
Continued 👉 https://blog.radwebhosting.com/how-to-install-clustercontrol-on-almalinux-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.social #mysql #installguide #databasecluster