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

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

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

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