The complete mysqldump guide (with examples)
▻https://simplebackups.com/blog/the-complete-mysqldump-guide-with-examples
Détail de l’utilisation de plusieurs options utiles de mysqldump : --quick
, --single-transaction
The complete mysqldump guide (with examples)
▻https://simplebackups.com/blog/the-complete-mysqldump-guide-with-examples
Détail de l’utilisation de plusieurs options utiles de mysqldump : --quick
, --single-transaction
maxbube/mydumper: Official #mydumper project
▻https://github.com/maxbube/mydumper
What is mydumper? Why?
– Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
– Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
– Consistency - maintains snapshot across all threads, provides accurate master and slave log positions, etc
– Manageability - supports PCRE for specifying database and tables inclusions and exclusions
When it comes to backing up and restoring MySQL database, most people usually use the very popular mysqldump. Whilst, mysqldump can be very easy to use for a smaller database, it doesn’t work well with larger databases. It’s very slow for huge databases and very error prone when used for very big MySQL databases.
▻https://dotlayer.com/extremely-fast-mysql-backup-restore-using-mydumpermyloader
Semble être utilisé par wikmedia cf :
Its speed and parallelism makes it perfect to save time and load data a lot faster.
It is easier to recover single tables or rows.
It compress nicely
▻https://wikitech.wikimedia.org/wiki/MariaDB#Dumping_tables_with_mydumper
#mysqldumpslow - MariaDB Knowledge Base
▻https://mariadb.com/kb/en/mariadb/mysqldumpslow
mysqldumpslow is a tool to examine the #slow_query_log.
It parses the slow query log files, printing a summary result. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It “abstracts” these values to N and ´S´ when displaying summary output. The -a and -n options can be used to modify value abstracting behavior.