Today I got some jobs (made by a coleague) which had a runtime of up to 75 seconds down to under 0.01s all by inserting some index on the Db table.
The job had several 7s long read on a 1M+ row table which added up fast.
Now they are blazing fast 🤩 #Php#Laravel#Mysql#mysqlOptimization
por fin encontré la causa de un pinche bug de la muerte en Cierto software que estoy reparando™
sospechaba que era una regresión causada por el cambio de base de datos de #mysql a #postgresql y era cierto!
también sospechaba que la razón por la que no lo podía encontrar tan fácilmente era que se escondía detrás de un try-catch tragatodo y ¡También era cierto!
It seems #MariaDB and #MySQL have entirely diverted into two separate products.
While #Shopware6 lists MariaDB and MySQL in their requirements, their recommendation is MySQL8 - which would be okay, you can have a favorite child.
On the other hand, developers now use functions that are exclusive to MySQL8 - completely disregarding the existence of MariaDB and thus breaking Shopware compatibility with MariaDB itself.
So you #HomeAssistant (ab)users: Why is it recommended to purge the #MySQL Database and prune stuff older than X days?
I am keeping all my data; not even filtering. I have every value, every state and every statistic. I can See how much I need to crank my #HeatPump up with the outside temperature so it gets cozy. I see my PV array and can compare.
I never said "I wish I had a smaller DB.". Size is only 80gb. For 4 years of precious data.
@brevebase is a new MySQL Database client for macOS. Connect to multiple databases, both local and remote. Additionally, it offers the convenience of quickly charting your tables.
Friends, now that people are aggregating together, which conferences should I keep an eye on for submissions? My content goes beyond databases fundamentals, language agnostic. I can cover automation, schema tracking, observability, etc.
Due to a #SQL compatibility issue of an application, the underlying #MariaDB database needed to be replaced by a #MySQL 8 community database. But when the dump was about to be restored from MariaDB (10.5) into MySQL 8.x, the data import failed.
I think of doing a web app for managing your personal comic-book collection. It should let you add titles with essential data (writer(s), artist(s), editor, cover art, ratings (with stars), reviews...), read, edit, and delete those data.
It would be made with #Java+#SpringBoot, server-side rendered with a templating engine (#Thymeleaf), and use a #MySQL DBMS. This way you could run it locally, self host privately and/or share everywhere. FOSS licensed of course.
I'm running small MySQL 8 instances in Kubernetes, and
they don't use any replication at all, ever, and
they have an RPO of several hours in the past (meaning: if they break, they can just be redeployed and re-populated from a backup that is a few hours old, and there is an automated procedure for that, which runs several times a day),