Meziu · @meziu
0 followers · 9 posts · Server mastodon.uno
Anubhav · @anubhav
9 followers · 319 posts · Server hachyderm.io#MariaDB backup:
During backing up of databases daily, via "#mysqldump" and/or "#mariabackup" (need to see what recording the process overs ~10 days brought), INSERT queries are delayed due to table locks. That causes a swell in number of open connections, from ~5 to ~70.
One way to avoid locks with "mysqldump", is to divide backing up in 2 main steps:
- when all the tables have #InnoDB engine, dump that database via "--single-transaction" option;
- rest with normal table locks.
1/2 ...
#mariadb #mysqldump #mariabackup #innodb
lefred · @lefred
50 followers · 156 posts · Server fosstodon.org
Still using MyISAM ? It is time to switch to InnoDB !
InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!).
If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM:
MVCC,
support for ACID transactions,
row-lev
https://lefred.be/content/still-using-myisam-it-is-time-to-switch-to-innodb/
#8.0 #General #InnoDB #MyISAM #MySQL #MySQL8.0 #rss
#general #innodb #MyISAM #mysql #Mysql8 #rss
· @alejandro_du
23 followers · 31 posts · Server mastodon.online🤩 #MariaDB is truly amazing:
Transactional workloads 👉 #InnoDB
Analytical workloads 👉 #ColumnStore
Read-heavy workloads 👉 #Aria
Write-heavy 👉 #MyRocks
Sharding 👉 #Spider
Scale both reads and writes 👉 #Xpand
Use NoSQL queries or export data to Kafka 👉 #MaxScale
#maxscale #xpand #spider #myrocks #aria #columnstore #innodb #MariaDB
Manjot Singh · @manjot
15 followers · 33 posts · Server fosstodon.org
Did you know #MariaDB #ColumnStore is 90% compatible with #InnoDB?
I explain how to use ColumnStore for quick and fast analytics.
saiki 🇪🇺🇺🇦🇺🇸🇩🇪 · @saiki
164 followers · 1472 posts · Server social.tchncs.de@lars https://support.plesk.com/hc/en-us/articles/213939865-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-databases-on-Plesk-for-Linux-#:~:text=InnoDB%20corruption.,allocating%20InnoDB%20databases%20on%20it.
Ist zwar für was anderes beschrieben, aber vom Grundprinzip her: database in recovery Modus hauen. #Backup ziehen. Datenbank löschen und neu anlegen. Danach Backup rückspielen.
#recovery #innodb #mysql #backup
El Blog de Lázaro · @elblogdelazaro
282 followers · 2570 posts · Server mastodon.social
El Blog de Lázaro · @elblogdelazaro
282 followers · 2570 posts · Server mastodon.socialMotores de almacenamiento en MySQL y MariaDB https://www.ochobitshacenunbyte.com/2020/08/11/motores-de-almacenamiento-en-mysql-y-mariadb/ #Blackhole #Federated #SYSADMIN #Archive #Example #MariaDB #InnoDB #memory #MyISAM #Merge #MySQL #CSV
#blackhole #sysadmin #merge #csv #mariadb #MyISAM #mysql #archive #example #federated #innodb #memory
hellosct1@mamot.fr · @hellosct1
151 followers · 1091 posts · Server mamot.frRT @freshdaz@twitter.com
#MySQL #InnoDB Cluster - HowTo #1 - Monitor your cluster
Q: How do I monitor the status & the configuration of my cluster?
A: ...
http://dasini.net/blog/2019/04/11/mysql-innodb-cluster-howto-1-monitor-your-cluster/
