Bluesky Β· Hashtag

#mysql

197
posts Β· 30d
40
users
7
posts / day
4.9
posts / user
-26% vs last week

#mysql is an active hashtag on Bluesky. In the last 30 days, 40 people shared 197 posts with it β€” around 7 a day. Activity is down 26% versus the previous week, peaking on Aug 3 with 20 posts.

#mysql posts per day (last 30 days)

Posts with #mysql

Kuba Suder πŸ‡΅πŸ‡±πŸ‡ΊπŸ‡¦
@mackuba.eu
over 1 year ago
Ok, #MySQL is giving me a mindfuck… I have a DELETE that takes ~12-13s (every 30min). I did an EXPLAIN ANALYZE of that, and it runs in 2-6s. But if I do that explain a few times and then switch back to just DELETE, it deletes much more rows, so this all implies that the explain doesn't delete them?…
10 0 34
Kuba Suder πŸ‡΅πŸ‡±πŸ‡ΊπŸ‡¦
@mackuba.eu
over 1 year ago
Hypothetically, if I was building something like an AppView πŸ™ƒ would it make more sense to have foreign keys for user IDs as integers everywhere, with a user table mapping int to DID, or to have DID strings everywhere and do joins using strings? Would such string joins be slower? #mysql #postgres
11 1 24
Kuba Suder πŸ‡΅πŸ‡±πŸ‡ΊπŸ‡¦
@mackuba.eu
over 2 years ago
Very nice tool for converting an #SQLite database into #MySQL: github.com/techouse/sql.... I'm planning to experiment with switching from SQLite to MySQL or Postgres (and maybe DuckDB?) for the feeds database and see how it behaves and how the performance differs… πŸ€”
GitHub - techouse/sqlite3-to-mysql: Transfer data from SQLite to MySQL

github.com

GitHub - techouse/sqlite3-to-mysql: Transfer data from SQLite to MySQL

Transfer data from SQLite to MySQL. Contribute to techouse/sqlite3-to-mysql development by creating an account on GitHub.

1 2 18
Kuba Suder πŸ‡΅πŸ‡±πŸ‡ΊπŸ‡¦
@mackuba.eu
over 1 year ago
I feel like this might be the key thing for my #MySQL vs. #Postgres choice - MySQL seems to have something like 2.5x higher disk utilization (2-3x higher write I/O ops and throughput), which means at this rate I'd hit the disk limits with a ~2.5x higher traffic than now… Pg has more space to grow πŸ€”
Disk utilization (MySQL) now going up and down between ~25-40%, currently at 38.5%
Disk utilization (Postgres) now going up and down between ~4-18%, currently at 12.1%
4 0 16
Bruninho1997
@bruninho1997.bsky.social
9 months ago
Lia, em seus aposentos no homeoffice, sem querer querendo acabou rodando um DELETE sem WHERE, resultando na perda de milhΓ΅es de dados da empresa. Esse Γ© um desenho feito de ΓΊltima hora para um desafio que consiste em fazer seu OC trabalhando. #mysql #sql #dev #art #digitalart #artbr
0 3 15
Percona
@percona.bsky.social
2 days ago
ICYMI: The MySQL community has a new independent voice. In LinuxInsider, Jack M. Germain covers OurSQL Foundation. Vadim Tkachenko calls it β€œa platform to promote and support MySQL” while fostering broader collaboration. bit.ly/4w3pAGg #MySQL #OpenSource #OurSQL
OurSQL Foundation Gives MySQL Community an Independent Voice

bit.ly

OurSQL Foundation Gives MySQL Community an Independent Voice

A new nonprofit aims to strengthen MySQL's future by giving users and developers a stronger voice while Oracle retains ownership and development control.

0 0 1

Posts are pulled live from Bluesky and cached briefly. Posts with content labels are hidden.