#mysqldump — Public Fediverse posts

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

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

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

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

#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.

Just came across this:

https://mysqldump.guru

Quite helpful!

#sql #MySQL #mysqlDump

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