[Перевод] Переиндексация в Manticore Search с использованием mysqldump

Эта статья написана Мариусом Матилионисом, старшим разработчиком и экспертом по Manticore Search в компании Ivinco . Ivinco специализируется на предоставлении передовых решений для поиска, оптимизации баз данных, управлении инцидентами и настройке систем мониторинга, помогая бизнесам достигать более быстрых, эффективных и масштабируемых операций.

https://habr.com/ru/articles/874280/

#таблицы_данных #переиндексация #mysqldump #оптимизация_таблиц #базы_данных #дисковое_пространство #производительность

Переиндексация в Manticore Search с использованием mysqldump

Эта статья написана Мариусом Матилионисом, старшим разработчиком и экспертом по Manticore Search в компании Ivinco . Ivinco специализируется на предоставлении передовых решений для поиска, оптимизации...

Хабр

#Methodically and #meticulously transferring #development #server files from (oh, let's say a juvenile-aged dev, as was born late spring '24) Linux box to a general 2TB storage device-- one of two 2TB drives purchased in 2021-- to which I'd planned transferring all files of any nature from anywhere, till [milk blood] running out.

One thing I did forget to do, however seems to be impacting productivity. Wonder why.

Oh? It should be nothing.
Just the #database
haha.
I was watching #Shatner and forgot #mySQLDump
(get it? heh heh... 🦗 🦗 )

oh well.
Oh there's a good song about that probably.
Momentarily not musical, my friends.

Can you believe it?

my wiki dump is still running - has used up about 250gb but i think i am less than halfway through - there are 6m article on wiki #mysqldump #vzdump

php initSiteStats.php --update
Refresh Site Statistics

Counting total edits...7594040
Counting number of articles...2656103
Counting total pages...7173448
Counting number of users...2
Counting number of images...0

Updating site statistics...done.

Done.

Today, for the first time, I sent a pull request to the #mysql #server repository with tiny change to #mysqldump.

I am curious how the process will be and whether the change will be accepted. Wish me luck :)

https://github.com/mysql/mysql-server/pull/524

Remove unnecessary whitespace in mysqldump by staabm · Pull Request #524 · mysql/mysql-server

before this PR when mysqldump was used to create INSERT or REPLACE statements with additional table-options, one unnecessary space was written to the dump for each INSERT or REPLACE before this PR:...

GitHub

Just came across this:

https://mysqldump.guru

Quite helpful!

#sql #MySQL #mysqlDump

mysqldump.guru

Learn how to use mysqldump like a guru.

Hint for a future me - before backuping Friendica (and other software) instance to migrate to another server: purge blocked domains and subdomains - the backup will be much smaller and restore will happen much faster. #sysadmin #mysqldump
Some good #mysql #backup and #restore examples for those of us who need to do it only every second year:
https://linuxize.com/post/how-to-back-up-and-restore-mysql-databases-with-mysqldump/
#mysqldump
Hey @admins

I just learned that after some updates of #mariadb I need to run #mysql upgrade, I never did that before, but it seems that had to be done now. Not sure why.
However, it solved this problems during a #mysqldump
mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'friendica'': Cannot load from mysql.proc. The table is probably corrupted (1728) mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'mysql'': Cannot load from mysql.proc. The table is probably corrupted (1728) mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'phpmyadmin'': Cannot load from mysql.proc. The table is probably corrupted (1728)

#friendica

Frage mysqldumb

Wie kriege ich es hin mit #mysqldump mehrere Datenbanken zu sichern, welche jeweils mit der gleichen Bezeichnung beginnen (z. B. muster_db1, muster_db2...) ohne jede aufzuführen. Ich möchte in einem Rutsch alle Datenbanken, welche mit muster_ beginnen sichern.
#followerpower https://f.praschnig.com/display/b8c357bb-405e-90bd-2840-130442195880

Frage mysqldumb

Wie kriege ich es hin mit #mysqldump mehrere Datenbanken zu sichern, welche jeweils mit der gleichen Bezeichnung beginnen (z. B. muster_db1, muster_db2...) o...

@f2k1de Ich nutze dazu immer #mysqldump
Exportiert den gesamten Inhalt inkl. der Tabellenbeschreibung. Kommt halt immer auf die Größe der DB an.