Join the community today
Register Now

Mydumper-0.6.1

Discussion in 'Other Centmin Mod Installed software' started by dorobo, Jun 7, 2014.

  1. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    Code:
    $ cmake .
    ....
    ....
    -- Configuring done
    -- Generating done
    -- Build files have been written to: /usr/local/src/mydumper-0.6.1
    $ make
    Scanning dependencies of target mydumper
    [ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
    [ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o
    [ 60%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o
    [ 80%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o
    Linking C executable mydumper
    [ 80%] Built target mydumper
    Scanning dependencies of target myloader
    [100%] Building C object CMakeFiles/myloader.dir/myloader.c.o
    Linking C executable myloader
    [100%] Built target myloader
    
    Code:
    $ /usr/local/bin/mydumper
    -bash: /usr/local/bin/mydumper: No such file or directory
    $ /usr/bin/myloader
    -bash: /usr/bin/myloader: No such file or directory
    $ updatedb
    $ locate myloader
    /usr/local/src/mydumper-0.6.1/myloader
    /usr/local/src/mydumper-0.6.1/myloader.c
    /usr/local/src/mydumper-0.6.1/myloader.h
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/C.includecache
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/DependInfo.cmake
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/build.make
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/cmake_clean.cmake
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/depend.internal
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/depend.make
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/flags.make
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/link.txt
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/myloader.c.o
    /usr/local/src/mydumper-0.6.1/CMakeFiles/myloader.dir/progress.make
    /usr/local/src/mydumper-0.6.1/docs/myloader_usage.rst
    Where is it? Why does it seem that it's not installed?
     
  2. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    ok noob mistake.

    forgot $ make install

    [​IMG]
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    heh. you got mydumper to install properly on CentOS 6.x ? it has a long standing bug that usually prevents source compiles :(
     
  4. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    • Like Like x 1
  5. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    Strange I tried that patch and didn't work for me. Might try it again

    thanks :D
     
    • Like Like x 1
  6. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    just tried it and it works just like 0.5.2

    # /usr/local/bin/mydumper -V
    mydumper 0.6.1, built against MySQL 5.5.37-MariaDB

    :)
     
    • Like Like x 1
  7. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    wow indeed it now strangely works !

    the mydumper docs if anyone needs them are at http://centminmod.com/mydumper.html

    Code:
    patch -p0 < mydumper-static-libmysql-link.patch
    patching file CMakeLists.txt
    patching file cmake/modules/FindMySQL.cmake
    Hunk #1 succeeded at 85 (offset 1 line).
    
    cmake .              
    -- The C compiler identification is GNU
    -- The CXX compiler identification is GNU
    -- Check for working C compiler: /usr/bin/ccache
    -- Check for working C compiler: /usr/bin/ccache -- works
    -- Detecting C compiler ABI info
    -- Detecting C compiler ABI info - done
    -- Check for working CXX compiler: /usr/bin/ccache
    -- Check for working CXX compiler: /usr/bin/ccache -- works
    -- Detecting CXX compiler ABI info
    -- Detecting CXX compiler ABI info - done
    -- Using mysql-config: /usr/bin/mysql_config
    -- Found MySQL: /usr/include/mysql, /usr/lib64/libmysqlclient_r.a;/usr/lib64/libpthread.so;/usr/lib64/libz.so;/usr/lib64/libm.so;/usr/lib64/librt.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;/usr/lib64/libdl.so
    -- Found ZLIB: /usr/lib64/libz.so
    -- checking for one of the modules 'glib-2.0'
    --   found glib-2.0, version 2.26.1
    -- checking for one of the modules 'gthread-2.0'
    --   found gthread-2.0, version 2.26.1
    -- checking for module 'libpcre'
    --   found libpcre, version 7.8
    -- Found PCRE: /usr/include
    
    WARNINGUnable to find Sphinx documentation generator
    -- ------------------------------------------------
    -- MYSQL_CONFIG = /usr/bin/mysql_config
    -- CMAKE_INSTALL_PREFIX = /usr/local
    -- BUILD_DOCS = ON
    -- RUN_CPPCHECK = OFF
    -- Change a values with: cmake -D<Variable>=<Value>
    -- ------------------------------------------------
    --
    -- Configuring done
    -- Generating done
    -- Build files have been written to: /svr-setup/mydumper-0.6.1
    
    make -j2
    Linking C executable myloader
    Linking C executable mydumper
    [ 20%] [100%] Built target myloader
    Built target mydumper
    
    make install
    [ 80%] Built target mydumper
    [100%] Built target myloader
    Install the project...
    -- Install configuration: ""
    -- Installing: /usr/local/bin/mydumper
    -- Installing: /usr/local/bin/myloader
    Code:
    mydumper --help
    Usage:
      mydumper [OPTION...] multi-threaded MySQL dumping
    
    Help Options:
      -?, --help                  Show help options
    
    Application Options:
      -B, --database              Database to dump
      -T, --tables-list           Comma delimited table list to dump (does not exclude regex option)
      -o, --outputdir             Directory to output files to
      -s, --statement-size        Attempted size of INSERT statement in bytes, default 1000000
      -r, --rows                  Try to split tables into chunks of this many rows. This option turns off --chunk-filesize
      -F, --chunk-filesize        Split tables into chunks of this output file size. This value is in MB
      -c, --compress              Compress output files
      -e, --build-empty-files     Build dump files even if no data available from table
      -x, --regex                 Regular expression for 'db.table' matching
      -i, --ignore-engines        Comma delimited list of storage engines to ignore
      -m, --no-schemas            Do not dump table schemas with the data
      -k, --no-locks              Do not execute the temporary shared read lock.  WARNING: This will cause inconsistent backups
      --less-locking              Minimize locking time on InnoDB tables.
      -l, --long-query-guard      Set long query timer in seconds, default 60
      --kill-long-queries         Kill long running queries (instead of aborting)
      -b, --binlogs               Get a snapshot of the binary logs as well as dump data
      -D, --daemon                Enable daemon mode
      -I, --snapshot-interval     Interval between each dump snapshot (in minutes), requires --daemon, default 60
      -L, --logfile               Log file name to use, by default stdout is used
      --tz-utc                    SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.
      --skip-tz-utc            
      --use-savepoints            Use savepoints to reduce metadata locking issues, needs SUPER privilege
      --success-on-1146           Not increment error count and Warning instead of Critical in case of table doesn't exist
      -h, --host                  The host to connect to
      -u, --user                  Username with privileges to run the dump
      -p, --password              User password
      -P, --port                  TCP/IP port to connect to
      -S, --socket                UNIX domain socket file to use for connection
      -t, --threads               Number of threads to use, default 4
      -C, --compress-protocol     Use compression on the MySQL connection
      -V, --version               Show the program version and exit
      -v, --verbose               Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
    

    Code:
    mysqladmin ver
    mysqladmin  Ver 9.0 Distrib 5.5.37-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.
    
    Server version          5.5.37-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 10 hours 12 min 19 sec
    
    Threads: 1  Questions: 1  Slow queries: 0  Opens: 0  Flush tables: 2  Open tables: 26  Queries per second avg: 0.000
     
    Last edited: Jun 8, 2014
    • Like Like x 1
  8. Zykov

    Zykov Member

    31
    7
    8
    May 28, 2014
    Ratings:
    +7
    Local Time:
    2:35 AM
    Nginx 1.7.1
    MariaDB 10
    Did patched version works with MariaDB 10 ?
     
  9. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    Haven't tried lately, last time it didn't work :(
     
  10. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    just tried it and no go

    Code:
    Scanning dependencies of target mydumper
    [ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
    [ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o
    In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27:
    /usr/include/mysql/sql_common.h:24:18: error: hash.h: No such file or directory
    In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27:
    /usr/include/mysql/sql_common.h:45: error: expected specifier-qualifier-list before ‘HASH’
    make[2]: *** [CMakeFiles/mydumper.dir/binlog.c.o] Error 1
    make[1]: *** [CMakeFiles/mydumper.dir/all] Error 2
    make: *** [all] Error 2
    + make install
    [ 20%] Building C object CMakeFiles/mydumper.dir/binlog.c.o
    In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27:
    /usr/include/mysql/sql_common.h:24:18: error: hash.h: No such file or directory
    In file included from /usr/local/src/mydumper-0.6.1/binlog.c:27:
    /usr/include/mysql/sql_common.h:45: error: expected specifier-qualifier-list before ‘HASH’
    make[2]: *** [CMakeFiles/mydumper.dir/binlog.c.o] Error 1
    make[1]: *** [CMakeFiles/mydumper.dir/all] Error 2
    make: *** [all] Error 2
     
    • Like Like x 1
  11. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    Yeah that was basically what I ran into for MariaDB 10 ages back when I tried heh
     
  12. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    If myloader is currently not compatible with MariaDB 10, what do you intend to use when you switch to 10? any alternative (except for mysqldump)?
     
  13. Zykov

    Zykov Member

    31
    7
    8
    May 28, 2014
    Ratings:
    +7
    Local Time:
    2:35 AM
    Nginx 1.7.1
    MariaDB 10
    I'm going to try Percona's XtraBackup when I'll have the spare time. They claim really good speed and features. If you'll try this first - don't hesitate to write here :)
     
    • Like Like x 1
  14. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    mysqldump and Percona XtraBackup http://www.percona.com/software/percona-xtrabackup the other main alternatives. Percona XtraBackup documentation http://www.percona.com/doc/percona-xtrabackup/2.2/

    As of 1.2.3-eva2000.04, I already included Percona YUM repository for such http://centminmod.com/changelog.html#123eva200004

     
    • Like Like x 1
  15. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
  16. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
  17. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    i think that is because Percona folks test mydumper on Ubuntu/Debian OS and not CentOS which is part of the problem with mydumper compatibility with CentOS + MariaDB 10.x

    edit: yup Debian https://bugs.launchpad.net/mydumper/+bug/1267483
     
  18. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +161
    Local Time:
    1:35 AM
    latest
    latest
    No love for CentOS :(

    By the way George, aside from the original Centminmod being made for CentOS, any reason why you chose it instead of Debian?
     
  19. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    As to centos vs debian - more familar with CentOS

    @dorobo and @Zykov heads up mydumper's trunk dev version 0.6.3 seems to compile fine on CentOS 6.5 with MariaDB 10.0.14 MySQL Data Dumper in Launchpad

    Finally! :D

    Code:
    cat /etc/redhat-release
    CentOS release 6.5 (Final)
    Code:
    mydumper -V
    mydumper 0.6.3, built against MySQL 10.0.14-MariaDB
    
    myloader -V
    myloader 0.6.3, built against MySQL 10.0.14-MariaDB
    mydumper 0.6.3 trunk build

    Code:
     cmake .
    -- The C compiler identification is GNU
    -- The CXX compiler identification is GNU
    -- Check for working C compiler: /usr/bin/ccache
    -- Check for working C compiler: /usr/bin/ccache -- works
    -- Detecting C compiler ABI info
    -- Detecting C compiler ABI info - done
    -- Check for working CXX compiler: /usr/bin/ccache
    -- Check for working CXX compiler: /usr/bin/ccache -- works
    -- Detecting CXX compiler ABI info
    -- Detecting CXX compiler ABI info - done
    -- Using mysql-config: /usr/bin/mysql_config
    -- Found MySQL: /usr/include/mysql, /usr/lib64/libmysqlclient_r.so;/usr/lib64/libpthread.so;/usr/lib64/libz.so;/usr/lib64/libm.so;/usr/lib64/librt.so;/usr/lib64/libssl.so;/usr/lib64/libcrypto.so;/usr/lib64/libdl.so
    -- Found ZLIB: /usr/lib64/libz.so
    -- checking for one of the modules 'glib-2.0'
    --   found glib-2.0, version 2.26.1
    -- checking for one of the modules 'gthread-2.0'
    --   found gthread-2.0, version 2.26.1
    -- checking for module 'libpcre'
    --   found libpcre, version 7.8
    -- Found PCRE: /usr/include
    
    WARNINGUnable to find Sphinx documentation generator
    -- ------------------------------------------------
    -- MYSQL_CONFIG = /usr/bin/mysql_config
    -- CMAKE_INSTALL_PREFIX = /usr/local
    -- BUILD_DOCS = ON
    -- WITH_BINLOG = OFF
    -- RUN_CPPCHECK = OFF
    -- Change a values with: cmake -D<Variable>=<Value>
    -- ------------------------------------------------
    --
    -- Configuring done
    -- Generating done
    -- Build files have been written to: /usr/local/src/mydumper
    Code:
    make
    Scanning dependencies of target mydumper
    [ 25%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
    [ 50%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o
    [ 75%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o
    Linking C executable mydumper
    [ 75%] Built target mydumper
    Scanning dependencies of target myloader
    [100%] Building C object CMakeFiles/myloader.dir/myloader.c.o
    Linking C executable myloader
    [100%] Built target myloader
    [root@centos65np mydumper]# make install
    [ 75%] Built target mydumper
    [100%] Built target myloader
    Install the project...
    -- Install configuration: ""
    -- Installing: /usr/local/bin/mydumper
    -- Installing: /usr/local/bin/myloader
    Code:
    ln -s /usr/local/bin/mydumper /usr/bin/mydumper
    ln -s /usr/local/bin/myloader /usr/bin/myloader
    Code:
    mydumper --help
    Usage:
      mydumper [OPTION...] multi-threaded MySQL dumping
    
    Help Options:
      -?, --help                  Show help options
    
    Application Options:
      -B, --database              Database to dump
      -T, --tables-list           Comma delimited table list to dump (does not exclude regex option)
      -o, --outputdir             Directory to output files to
      -s, --statement-size        Attempted size of INSERT statement in bytes, default 1000000
      -r, --rows                  Try to split tables into chunks of this many rows. This option turns off --chunk-filesize
      -F, --chunk-filesize        Split tables into chunks of this output file size. This value is in MB
      -c, --compress              Compress output files
      -e, --build-empty-files     Build dump files even if no data available from table
      -x, --regex                 Regular expression for 'db.table' matching
      -i, --ignore-engines        Comma delimited list of storage engines to ignore
      -m, --no-schemas            Do not dump table schemas with the data
      -k, --no-locks              Do not execute the temporary shared read lock.  WARNING: This will cause inconsistent backups
      --less-locking              Minimize locking time on InnoDB tables.
      -l, --long-query-guard      Set long query timer in seconds, default 60
      -K, --kill-long-queries     Kill long running queries (instead of aborting)
      -D, --daemon                Enable daemon mode
      -I, --snapshot-interval     Interval between each dump snapshot (in minutes), requires --daemon, default 60
      -L, --logfile               Log file name to use, by default stdout is used
      --tz-utc                    SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.
      --skip-tz-utc    
      --use-savepoints            Use savepoints to reduce metadata locking issues, needs SUPER privilege
      --success-on-1146           Not increment error count and Warning instead of Critical in case of table doesn't exist
      --lock-all-tables           Use LOCK TABLE for all, instead of FTWRL
      -U, --updated-since         Use Update_time to dump only tables updated in the last U days
      -h, --host                  The host to connect to
      -u, --user                  Username with privileges to run the dump
      -p, --password              User password
      -P, --port                  TCP/IP port to connect to
      -S, --socket                UNIX domain socket file to use for connection
      -t, --threads               Number of threads to use, default 4
      -C, --compress-protocol     Use compression on the MySQL connection
      -V, --version               Show the program version and exit
      -v, --verbose               Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
    Code:
    myloader --help
    Usage:
      myloader [OPTION...] multi-threaded MySQL loader
    
    Help Options:
      -?, --help                        Show help options
    
    Application Options:
      -d, --directory                   Directory of the dump to import
      -q, --queries-per-transaction     Number of queries per transaction, default 1000
      -o, --overwrite-tables            Drop tables if they already exist
      -B, --database                    An alternative database to restore into
      -e, --enable-binlog               Enable binary logging of the restore data
      -h, --host                        The host to connect to
      -u, --user                        Username with privileges to run the dump
      -p, --password                    User password
      -P, --port                        TCP/IP port to connect to
      -S, --socket                      UNIX domain socket file to use for connection
      -t, --threads                     Number of threads to use, default 4
      -C, --compress-protocol           Use compression on the MySQL connection
      -V, --version                     Show the program version and exit
      -v, --verbose                     Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
    my mydumper documentation at Mydumper & Myloader Documentation

    MySQL backup benchmarks



    2GB Linode 2 cpu thread quick test to backup staging server's mysql database which is 116.84MB in siz and MariaDB 5.5.40 server

    mysqldump vs mydumper multi-threaded
    • mysqldump backup time = 2.24 seconds or 116.84/2.24s = 52.16MB/s backup speed
    • mydumper backup time = 0.49 seconds or 116.84/0.49 = 238.45MB/s backup speed = 4.57x times faster
    Code:
    ------------------------------
    XENFORODB Index Size = 12.46 MB
    ------------------------------
    XENFORODB Data Size = 104.38 MB
    ------------------------------
    Total XENFORODB dtabase size = 116.84 MB
    
    Code:
    mysqldump XENFORODB > mysqldump.sql
    real: 2.24s cpu: 44% maxmem: 25600 KB cswaits: 6124
    
    Code:
    ls -lah
    total 55M
    drwxr-xr-x  2 root root 4.0K Oct 23 07:56 .
    drwxr-xr-x 11 root root 4.0K Oct 23 07:49 ..
    -rw-r--r--  1 root root  55M Oct 23 07:56 mysqldump.sql
    
    Code:
    mydumper -B XENFORODB
    real: 0.49s cpu: 84% maxmem: 62224 KB cswaits: 1210
    
    Code:
    ls -lah export-20141023-080052/
    total 56M
    drwx------ 2 root root  20K Oct 23 08:00 .
    drwxr-xr-x 3 root root 4.0K Oct 23 08:00 ..
    -rw-r--r-- 1 root root   75 Oct 23 08:00 metadata
    -rw-r--r-- 1 root root  361 Oct 23 08:00 XENFORODB.cta_ft_featured_threads_dismissed-schema.sql
    -rw-r--r-- 1 root root  627 Oct 23 08:00 XENFORODB.cta_ft_featured_threads-schema.sql
    -rw-r--r-- 1 root root  11K Oct 23 08:00 XENFORODB.cta_ft_featured_threads.sql
    -rw-r--r-- 1 root root  497 Oct 23 08:00 XENFORODB.dp_spy-schema.sql
    -rw-r--r-- 1 root root  592 Oct 23 08:00 XENFORODB.dp_spy.sql
    -rw-r--r-- 1 root root  939 Oct 23 08:00 XENFORODB.nat_options-schema.sql
    -rw-r--r-- 1 root root 1.5K Oct 23 08:00 XENFORODB.nat_options.sql
    -rw-r--r-- 1 root root  840 Oct 23 08:00 XENFORODB.xf_addon-schema.sql
    -rw-r--r-- 1 root root  12K Oct 23 08:00 XENFORODB.xf_addon.sql
    -rw-r--r-- 1 root root  543 Oct 23 08:00 XENFORODB.xf_admin_log-schema.sql
    -rw-r--r-- 1 root root  23K Oct 23 08:00 XENFORODB.xf_admin_log.sql
    -rw-r--r-- 1 root root  676 Oct 23 08:00 XENFORODB.xf_admin_navigation-schema.sql
    -rw-r--r-- 1 root root  12K Oct 23 08:00 XENFORODB.xf_admin_navigation.sql
    -rw-r--r-- 1 root root  274 Oct 23 08:00 XENFORODB.xf_admin_permission_entry-schema.sql
    -rw-r--r-- 1 root root  528 Oct 23 08:00 XENFORODB.xf_admin_permission_entry.sql
    -rw-r--r-- 1 root root  374 Oct 23 08:00 XENFORODB.xf_admin_permission-schema.sql
    -rw-r--r-- 1 root root  981 Oct 23 08:00 XENFORODB.xf_admin_permission.sql
    -rw-r--r-- 1 root root  333 Oct 23 08:00 XENFORODB.xf_admin-schema.sql
    -rw-r--r-- 1 root root  298 Oct 23 08:00 XENFORODB.xf_admin_search_type-schema.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_admin_search_type.sql
    -rw-r--r-- 1 root root  659 Oct 23 08:00 XENFORODB.xf_admin.sql
    -rw-r--r-- 1 root root  364 Oct 23 08:00 XENFORODB.xf_admin_template_compiled-schema.sql
    -rw-r--r-- 1 root root 2.3M Oct 23 08:00 XENFORODB.xf_admin_template_compiled.sql
    -rw-r--r-- 1 root root  300 Oct 23 08:00 XENFORODB.xf_admin_template_include-schema.sql
    -rw-r--r-- 1 root root 3.7K Oct 23 08:00 XENFORODB.xf_admin_template_include.sql
    -rw-r--r-- 1 root root  428 Oct 23 08:00 XENFORODB.xf_admin_template_modification_log-schema.sql
    -rw-r--r-- 1 root root  768 Oct 23 08:00 XENFORODB.xf_admin_template_modification_log.sql
    -rw-r--r-- 1 root root  739 Oct 23 08:00 XENFORODB.xf_admin_template_modification-schema.sql
    -rw-r--r-- 1 root root  33K Oct 23 08:00 XENFORODB.xf_admin_template_modification.sql
    -rw-r--r-- 1 root root  316 Oct 23 08:00 XENFORODB.xf_admin_template_phrase-schema.sql
    -rw-r--r-- 1 root root 165K Oct 23 08:00 XENFORODB.xf_admin_template_phrase.sql
    -rw-r--r-- 1 root root  486 Oct 23 08:00 XENFORODB.xf_admin_template-schema.sql
    -rw-r--r-- 1 root root 4.4M Oct 23 08:00 XENFORODB.xf_admin_template.sql
    -rw-r--r-- 1 root root  938 Oct 23 08:00 XENFORODB.xf_attachment_data-schema.sql
    -rw-r--r-- 1 root root 109K Oct 23 08:00 XENFORODB.xf_attachment_data.sql
    -rw-r--r-- 1 root root  758 Oct 23 08:00 XENFORODB.xf_attachment-schema.sql
    -rw-r--r-- 1 root root  19K Oct 23 08:00 XENFORODB.xf_attachment.sql
    -rw-r--r-- 1 root root  226 Oct 23 08:00 XENFORODB.xf_attachment_view-schema.sql
    -rw-r--r-- 1 root root  206 Oct 23 08:00 XENFORODB.xf_ban_email-schema.sql
    -rw-r--r-- 1 root root  960 Oct 23 08:00 XENFORODB.xf_bb_code_media_site-schema.sql
    -rw-r--r-- 1 root root 2.0K Oct 23 08:00 XENFORODB.xf_bb_code_media_site.sql
    -rw-r--r-- 1 root root  633 Oct 23 08:00 XENFORODB.xf_bb_code_parse_cache-schema.sql
    -rw-r--r-- 1 root root 3.6M Oct 23 08:00 XENFORODB.xf_bb_code_parse_cache.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_bb_code-schema.sql
    -rw-r--r-- 1 root root  655 Oct 23 08:00 XENFORODB.xf_bb_code.sql
    -rw-r--r-- 1 root root  267 Oct 23 08:00 XENFORODB.xf_bdattachmentstore_delay-schema.sql
    -rw-r--r-- 1 root root  364 Oct 23 08:00 XENFORODB.xf_bdpushover_push_queue-schema.sql
    -rw-r--r-- 1 root root  411 Oct 23 08:00 XENFORODB.xf_calendar-schema.sql
    -rw-r--r-- 1 root root  175 Oct 23 08:00 XENFORODB.xf_calendar.sql
    -rw-r--r-- 1 root root  356 Oct 23 08:00 XENFORODB.xf_captcha_log-schema.sql
    -rw-r--r-- 1 root root  445 Oct 23 08:00 XENFORODB.xf_captcha_question-schema.sql
    -rw-r--r-- 1 root root  693 Oct 23 08:00 XENFORODB.xf_code_event_listener-schema.sql
    -rw-r--r-- 1 root root  56K Oct 23 08:00 XENFORODB.xf_code_event_listener.sql
    -rw-r--r-- 1 root root  279 Oct 23 08:00 XENFORODB.xf_code_event-schema.sql
    -rw-r--r-- 1 root root  31K Oct 23 08:00 XENFORODB.xf_code_event.sql
    -rw-r--r-- 1 root root  486 Oct 23 08:00 XENFORODB.xf_content_spam_cache-schema.sql
    -rw-r--r-- 1 root root  341 Oct 23 08:00 XENFORODB.xf_content_type_field-schema.sql
    -rw-r--r-- 1 root root 6.3K Oct 23 08:00 XENFORODB.xf_content_type_field.sql
    -rw-r--r-- 1 root root  290 Oct 23 08:00 XENFORODB.xf_content_type-schema.sql
    -rw-r--r-- 1 root root 7.0K Oct 23 08:00 XENFORODB.xf_content_type.sql
    -rw-r--r-- 1 root root  954 Oct 23 08:00 XENFORODB.xf_conversation_master-schema.sql
    -rw-r--r-- 1 root root  28K Oct 23 08:00 XENFORODB.xf_conversation_master.sql
    -rw-r--r-- 1 root root  699 Oct 23 08:00 XENFORODB.xf_conversation_message-schema.sql
    -rw-r--r-- 1 root root 273K Oct 23 08:00 XENFORODB.xf_conversation_message.sql
    -rw-r--r-- 1 root root  426 Oct 23 08:00 XENFORODB.xf_conversation_recipient-schema.sql
    -rw-r--r-- 1 root root 8.8K Oct 23 08:00 XENFORODB.xf_conversation_recipient.sql
    -rw-r--r-- 1 root root  846 Oct 23 08:00 XENFORODB.xf_conversation_user-schema.sql
    -rw-r--r-- 1 root root  14K Oct 23 08:00 XENFORODB.xf_conversation_user.sql
    -rw-r--r-- 1 root root  475 Oct 23 08:00 XENFORODB.xf_cron_entry-schema.sql
    -rw-r--r-- 1 root root 6.7K Oct 23 08:00 XENFORODB.xf_cron_entry.sql
    -rw-r--r-- 1 root root  239 Oct 23 08:00 XENFORODB.xf_data_registry-schema.sql
    -rw-r--r-- 1 root root 4.0M Oct 23 08:00 XENFORODB.xf_data_registry.sql
    -rw-r--r-- 1 root root  583 Oct 23 08:00 XENFORODB.xf_deferred-schema.sql
    -rw-r--r-- 1 root root  180 Oct 23 08:00 XENFORODB.xf_deferred.sql
    -rw-r--r-- 1 root root  483 Oct 23 08:00 XENFORODB.xf_deletion_log-schema.sql
    -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_deletion_log.sql
    -rw-r--r-- 1 root root  494 Oct 23 08:00 XENFORODB.xf_draft-schema.sql
    -rw-r--r-- 1 root root  553 Oct 23 08:00 XENFORODB.xf_edit_history-schema.sql
    -rw-r--r-- 1 root root  65K Oct 23 08:00 XENFORODB.xf_edit_history.sql
    -rw-r--r-- 1 root root  371 Oct 23 08:00 XENFORODB.xf_email_template_compiled-schema.sql
    -rw-r--r-- 1 root root 273K Oct 23 08:00 XENFORODB.xf_email_template_compiled.sql
    -rw-r--r-- 1 root root  428 Oct 23 08:00 XENFORODB.xf_email_template_modification_log-schema.sql
    -rw-r--r-- 1 root root  762 Oct 23 08:00 XENFORODB.xf_email_template_modification-schema.sql
    -rw-r--r-- 1 root root  301 Oct 23 08:00 XENFORODB.xf_email_template_phrase-schema.sql
    -rw-r--r-- 1 root root  13K Oct 23 08:00 XENFORODB.xf_email_template_phrase.sql
    -rw-r--r-- 1 root root  815 Oct 23 08:00 XENFORODB.xf_email_template-schema.sql
    -rw-r--r-- 1 root root 368K Oct 23 08:00 XENFORODB.xf_email_template.sql
    -rw-r--r-- 1 root root  616 Oct 23 08:00 XENFORODB.xf_error_log-schema.sql
    -rw-r--r-- 1 root root  589 Oct 23 08:00 XENFORODB.xf_es_search_failed-schema.sql
    -rw-r--r-- 1 root root  391 Oct 23 08:00 XENFORODB.xf_faq_category-schema.sql
    -rw-r--r-- 1 root root  402 Oct 23 08:00 XENFORODB.xf_faq_category.sql
    -rw-r--r-- 1 root root  935 Oct 23 08:00 XENFORODB.xf_faq_question-schema.sql
    -rw-r--r-- 1 root root 3.7K Oct 23 08:00 XENFORODB.xf_faq_question.sql
    -rw-r--r-- 1 root root  348 Oct 23 08:00 XENFORODB.xf_feed_log-schema.sql
    -rw-r--r-- 1 root root  82K Oct 23 08:00 XENFORODB.xf_feed_log.sql
    -rw-r--r-- 1 root root  909 Oct 23 08:00 XENFORODB.xf_feed-schema.sql
    -rw-r--r-- 1 root root 2.2K Oct 23 08:00 XENFORODB.xf_feed.sql
    -rw-r--r-- 1 root root  333 Oct 23 08:00 XENFORODB.xf_flood_check-schema.sql
    -rw-r--r-- 1 root root  289 Oct 23 08:00 XENFORODB.xf_forum_prefix-schema.sql
    -rw-r--r-- 1 root root  713 Oct 23 08:00 XENFORODB.xf_forum_prefix.sql
    -rw-r--r-- 1 root root  502 Oct 23 08:00 XENFORODB.xf_forum_read-schema.sql
    -rw-r--r-- 1 root root  881 Oct 23 08:00 XENFORODB.xf_forum_read.sql
    -rw-r--r-- 1 root root 1.9K Oct 23 08:00 XENFORODB.xf_forum-schema.sql
    -rw-r--r-- 1 root root 6.0K Oct 23 08:00 XENFORODB.xf_forum.sql
    -rw-r--r-- 1 root root  444 Oct 23 08:00 XENFORODB.xf_forum_watch-schema.sql
    -rw-r--r-- 1 root root  159 Oct 23 08:00 XENFORODB.xf_forum_watch.sql
    -rw-r--r-- 1 root root 1012 Oct 23 08:00 XENFORODB.xf_image_proxy-schema.sql
    -rw-r--r-- 1 root root  287 Oct 23 08:00 XENFORODB.xf_import_log-schema.sql
    -rw-r--r-- 1 root root  444 Oct 23 08:00 XENFORODB.xf_install_upgrade_login-schema.sql
    -rw-r--r-- 1 root root  418 Oct 23 08:00 XENFORODB.xf_ip_match-schema.sql
    -rw-r--r-- 1 root root  645 Oct 23 08:00 XENFORODB.xf_ip-schema.sql
    -rw-r--r-- 1 root root 441K Oct 23 08:00 XENFORODB.xf_ip.sql
    -rw-r--r-- 1 root root  495 Oct 23 08:00 XENFORODB.xf_keywordalert_keyword-schema.sql
    -rw-r--r-- 1 root root  338 Oct 23 08:00 XENFORODB.xf_keywordalert_queue-schema.sql
    -rw-r--r-- 1 root root  663 Oct 23 08:00 XENFORODB.xf_language-schema.sql
    -rw-r--r-- 1 root root  12K Oct 23 08:00 XENFORODB.xf_language.sql
    -rw-r--r-- 1 root root  724 Oct 23 08:00 XENFORODB.xf_liked_content-schema.sql
    -rw-r--r-- 1 root root  51K Oct 23 08:00 XENFORODB.xf_liked_content.sql
    -rw-r--r-- 1 root root  295 Oct 23 08:00 XENFORODB.xf_link_forum-schema.sql
    -rw-r--r-- 1 root root  239 Oct 23 08:00 XENFORODB.xf_link_forum.sql
    -rw-r--r-- 1 root root  534 Oct 23 08:00 XENFORODB.xf_link_proxy-schema.sql
    -rw-r--r-- 1 root root  438 Oct 23 08:00 XENFORODB.xf_login_attempt-schema.sql
    -rw-r--r-- 1 root root  340 Oct 23 08:00 XENFORODB.xf_mail_queue-schema.sql
    -rw-r--r-- 1 root root  364 Oct 23 08:00 XENFORODB.xf_moderation_queue-schema.sql
    -rw-r--r-- 1 root root  503 Oct 23 08:00 XENFORODB.xf_moderator_content-schema.sql
    -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_moderator_log-schema.sql
    -rw-r--r-- 1 root root  67K Oct 23 08:00 XENFORODB.xf_moderator_log.sql
    -rw-r--r-- 1 root root  350 Oct 23 08:00 XENFORODB.xf_moderator-schema.sql
    -rw-r--r-- 1 root root 2.3K Oct 23 08:00 XENFORODB.xf_moderator.sql
    -rw-r--r-- 1 root root  220 Oct 23 08:00 XENFORODB.xf_multiview-schema.sql
    -rw-r--r-- 1 root root  355 Oct 23 08:00 XENFORODB.xf_multiview.sql
    -rw-r--r-- 1 root root  855 Oct 23 08:00 XENFORODB.xf_news_feed-schema.sql
    -rw-r--r-- 1 root root 1.4K Oct 23 08:00 XENFORODB.xf_news_feed.sql
    -rw-r--r-- 1 root root  327 Oct 23 08:00 XENFORODB.xf_news-schema.sql
    -rw-r--r-- 1 root root  251 Oct 23 08:00 XENFORODB.xf_node_ignore-schema.sql
    -rw-r--r-- 1 root root 1.6K Oct 23 08:00 XENFORODB.xf_node-schema.sql
    -rw-r--r-- 1 root root  12K Oct 23 08:00 XENFORODB.xf_node.sql
    -rw-r--r-- 1 root root  601 Oct 23 08:00 XENFORODB.xf_node_type-schema.sql
    -rw-r--r-- 1 root root  849 Oct 23 08:00 XENFORODB.xf_node_type.sql
    -rw-r--r-- 1 root root  345 Oct 23 08:00 XENFORODB.xf_notice_dismissed-schema.sql
    -rw-r--r-- 1 root root  577 Oct 23 08:00 XENFORODB.xf_notice_dismissed.sql
    -rw-r--r-- 1 root root  694 Oct 23 08:00 XENFORODB.xf_notice-schema.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_notice.sql
    -rw-r--r-- 1 root root  367 Oct 23 08:00 XENFORODB.xf_option_group_relation-schema.sql
    -rw-r--r-- 1 root root  27K Oct 23 08:00 XENFORODB.xf_option_group_relation.sql
    -rw-r--r-- 1 root root  381 Oct 23 08:00 XENFORODB.xf_option_group-schema.sql
    -rw-r--r-- 1 root root 3.2K Oct 23 08:00 XENFORODB.xf_option_group.sql
    -rw-r--r-- 1 root root  795 Oct 23 08:00 XENFORODB.xf_option-schema.sql
    -rw-r--r-- 1 root root 149K Oct 23 08:00 XENFORODB.xf_option.sql
    -rw-r--r-- 1 root root  667 Oct 23 08:00 XENFORODB.xf_page-schema.sql
    -rw-r--r-- 1 root root  537 Oct 23 08:00 XENFORODB.xf_page.sql
    -rw-r--r-- 1 root root  399 Oct 23 08:00 XENFORODB.xf_permission_cache_content-schema.sql
    -rw-r--r-- 1 root root 445K Oct 23 08:00 XENFORODB.xf_permission_cache_content.sql
    -rw-r--r-- 1 root root  428 Oct 23 08:00 XENFORODB.xf_permission_combination-schema.sql
    -rw-r--r-- 1 root root  46K Oct 23 08:00 XENFORODB.xf_permission_combination.sql
    -rw-r--r-- 1 root root  386 Oct 23 08:00 XENFORODB.xf_permission_combination_user_group-schema.sql
    -rw-r--r-- 1 root root  315 Oct 23 08:00 XENFORODB.xf_permission_combination_user_group.sql
    -rw-r--r-- 1 root root  852 Oct 23 08:00 XENFORODB.xf_permission_entry_content-schema.sql
    -rw-r--r-- 1 root root 4.2K Oct 23 08:00 XENFORODB.xf_permission_entry_content.sql
    -rw-r--r-- 1 root root  652 Oct 23 08:00 XENFORODB.xf_permission_entry-schema.sql
    -rw-r--r-- 1 root root  17K Oct 23 08:00 XENFORODB.xf_permission_entry.sql
    -rw-r--r-- 1 root root  276 Oct 23 08:00 XENFORODB.xf_permission_group-schema.sql
    -rw-r--r-- 1 root root  690 Oct 23 08:00 XENFORODB.xf_permission_group.sql
    -rw-r--r-- 1 root root  370 Oct 23 08:00 XENFORODB.xf_permission_interface_group-schema.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_permission_interface_group.sql
    -rw-r--r-- 1 root root  660 Oct 23 08:00 XENFORODB.xf_permission-schema.sql
    -rw-r--r-- 1 root root  15K Oct 23 08:00 XENFORODB.xf_permission.sql
    -rw-r--r-- 1 root root  294 Oct 23 08:00 XENFORODB.xf_phrase_compiled-schema.sql
    -rw-r--r-- 1 root root 1.3M Oct 23 08:00 XENFORODB.xf_phrase_compiled.sql
    -rw-r--r-- 1 root root  459 Oct 23 08:00 XENFORODB.xf_phrase_map-schema.sql
    -rw-r--r-- 1 root root 760K Oct 23 08:00 XENFORODB.xf_phrase_map.sql
    -rw-r--r-- 1 root root  676 Oct 23 08:00 XENFORODB.xf_phrase-schema.sql
    -rw-r--r-- 1 root root 961K Oct 23 08:00 XENFORODB.xf_phrase.sql
    -rw-r--r-- 1 root root  485 Oct 23 08:00 XENFORODB.xf_poll_response-schema.sql
    -rw-r--r-- 1 root root 3.9K Oct 23 08:00 XENFORODB.xf_poll_response.sql
    -rw-r--r-- 1 root root  674 Oct 23 08:00 XENFORODB.xf_poll-schema.sql
    -rw-r--r-- 1 root root 5.5K Oct 23 08:00 XENFORODB.xf_poll.sql
    -rw-r--r-- 1 root root  435 Oct 23 08:00 XENFORODB.xf_poll_vote-schema.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_poll_vote.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_post-schema.sql
    -rw-r--r-- 1 root root 4.1M Oct 23 08:00 XENFORODB.xf_post.sql
    -rw-r--r-- 1 root root  664 Oct 23 08:00 XENFORODB.xf_profile_post_comment-schema.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_profile_post_comment.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_profile_post-schema.sql
    -rw-r--r-- 1 root root 1.9K Oct 23 08:00 XENFORODB.xf_profile_post.sql
    -rw-r--r-- 1 root root  339 Oct 23 08:00 XENFORODB.xf_registration_spam_cache-schema.sql
    -rw-r--r-- 1 root root  674 Oct 23 08:00 XENFORODB.xf_report_comment-schema.sql
    -rw-r--r-- 1 root root  252 Oct 23 08:00 XENFORODB.xf_report_comment.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_report-schema.sql
    -rw-r--r-- 1 root root  467 Oct 23 08:00 XENFORODB.xf_report.sql
    -rw-r--r-- 1 root root  327 Oct 23 08:00 XENFORODB.xf_resource_category_prefix-schema.sql
    -rw-r--r-- 1 root root 1.8K Oct 23 08:00 XENFORODB.xf_resource_category-schema.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_resource_category.sql
    -rw-r--r-- 1 root root  547 Oct 23 08:00 XENFORODB.xf_resource_category_watch-schema.sql
    -rw-r--r-- 1 root root  561 Oct 23 08:00 XENFORODB.xf_resource_download-schema.sql
    -rw-r--r-- 1 root root  282 Oct 23 08:00 XENFORODB.xf_resource_download.sql
    -rw-r--r-- 1 root root  298 Oct 23 08:00 XENFORODB.xf_resource_feature-schema.sql
    -rw-r--r-- 1 root root  334 Oct 23 08:00 XENFORODB.xf_resource_field_category-schema.sql
    -rw-r--r-- 1 root root  837 Oct 23 08:00 XENFORODB.xf_resource_field-schema.sql
    -rw-r--r-- 1 root root  335 Oct 23 08:00 XENFORODB.xf_resource_field_value-schema.sql
    -rw-r--r-- 1 root root  288 Oct 23 08:00 XENFORODB.xf_resource_prefix_group-schema.sql
    -rw-r--r-- 1 root root  597 Oct 23 08:00 XENFORODB.xf_resource_prefix-schema.sql
    -rw-r--r-- 1 root root 1.2K Oct 23 08:00 XENFORODB.xf_resource_rating-schema.sql
    -rw-r--r-- 1 root root 2.3K Oct 23 08:00 XENFORODB.xf_resource-schema.sql
    -rw-r--r-- 1 root root  617 Oct 23 08:00 XENFORODB.xf_resource.sql
    -rw-r--r-- 1 root root 1008 Oct 23 08:00 XENFORODB.xf_resource_update-schema.sql
    -rw-r--r-- 1 root root  23K Oct 23 08:00 XENFORODB.xf_resource_update.sql
    -rw-r--r-- 1 root root  873 Oct 23 08:00 XENFORODB.xf_resource_version-schema.sql
    -rw-r--r-- 1 root root  239 Oct 23 08:00 XENFORODB.xf_resource_version.sql
    -rw-r--r-- 1 root root  442 Oct 23 08:00 XENFORODB.xf_resource_watch-schema.sql
    -rw-r--r-- 1 root root  343 Oct 23 08:00 XENFORODB.xf_resource_watch.sql
    -rw-r--r-- 1 root root  558 Oct 23 08:00 XENFORODB.xf_rotating_ads_item-schema.sql
    -rw-r--r-- 1 root root 7.4K Oct 23 08:00 XENFORODB.xf_rotating_ads_item.sql
    -rw-r--r-- 1 root root  554 Oct 23 08:00 XENFORODB.xf_route_filter-schema.sql
    -rw-r--r-- 1 root root  432 Oct 23 08:00 XENFORODB.xf_route_prefix-schema.sql
    -rw-r--r-- 1 root root  12K Oct 23 08:00 XENFORODB.xf_route_prefix.sql
    -rw-r--r-- 1 root root  700 Oct 23 08:00 XENFORODB.xf_search_index-schema.sql
    -rw-r--r-- 1 root root 334K Oct 23 08:00 XENFORODB.xf_search_index.sql
    -rw-r--r-- 1 root root  848 Oct 23 08:00 XENFORODB.xf_search-schema.sql
    -rw-r--r-- 1 root root  609 Oct 23 08:00 XENFORODB.xf_session_activity-schema.sql
    -rw-r--r-- 1 root root  560 Oct 23 08:00 XENFORODB.xf_session_activity.sql
    -rw-r--r-- 1 root root  325 Oct 23 08:00 XENFORODB.xf_session_admin-schema.sql
    -rw-r--r-- 1 root root  319 Oct 23 08:00 XENFORODB.xf_session-schema.sql
    -rw-r--r-- 1 root root  305 Oct 23 08:00 XENFORODB.xf_smilie_category-schema.sql
    -rw-r--r-- 1 root root  149 Oct 23 08:00 XENFORODB.xf_smilie_category.sql
    -rw-r--r-- 1 root root  650 Oct 23 08:00 XENFORODB.xf_smilie-schema.sql
    -rw-r--r-- 1 root root  22K Oct 23 08:00 XENFORODB.xf_smilie.sql
    -rw-r--r-- 1 root root  734 Oct 23 08:00 XENFORODB.xf_spam_cleaner_log-schema.sql
    -rw-r--r-- 1 root root  392 Oct 23 08:00 XENFORODB.xf_spam_cleaner_log.sql
    -rw-r--r-- 1 root root  638 Oct 23 08:00 XENFORODB.xf_spam_trigger_log-schema.sql
    -rw-r--r-- 1 root root  265 Oct 23 08:00 XENFORODB.xf_statistics-schema.sql
    -rw-r--r-- 1 root root  292 Oct 23 08:00 XENFORODB.xf_statistics.sql
    -rw-r--r-- 1 root root  299 Oct 23 08:00 XENFORODB.xf_stats_daily-schema.sql
    -rw-r--r-- 1 root root  26K Oct 23 08:00 XENFORODB.xf_stats_daily.sql
    -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_style_property_definition-schema.sql
    -rw-r--r-- 1 root root 150K Oct 23 08:00 XENFORODB.xf_style_property_definition.sql
    -rw-r--r-- 1 root root  574 Oct 23 08:00 XENFORODB.xf_style_property_group-schema.sql
    -rw-r--r-- 1 root root 5.0K Oct 23 08:00 XENFORODB.xf_style_property_group.sql
    -rw-r--r-- 1 root root  450 Oct 23 08:00 XENFORODB.xf_style_property-schema.sql
    -rw-r--r-- 1 root root 217K Oct 23 08:00 XENFORODB.xf_style_property.sql
    -rw-r--r-- 1 root root  774 Oct 23 08:00 XENFORODB.xf_style-schema.sql
    -rw-r--r-- 1 root root 258K Oct 23 08:00 XENFORODB.xf_style.sql
    -rw-r--r-- 1 root root  550 Oct 23 08:00 XENFORODB.xf_tapatalk_users-schema.sql
    -rw-r--r-- 1 root root  339 Oct 23 08:00 XENFORODB.xf_tapatalk_users.sql
    -rw-r--r-- 1 root root  409 Oct 23 08:00 XENFORODB.xf_template_compiled-schema.sql
    -rw-r--r-- 1 root root  19M Oct 23 08:00 XENFORODB.xf_template_compiled.sql
    -rw-r--r-- 1 root root  555 Oct 23 08:00 XENFORODB.xf_template_history-schema.sql
    -rw-r--r-- 1 root root 1.1M Oct 23 08:00 XENFORODB.xf_template_history.sql
    -rw-r--r-- 1 root root  314 Oct 23 08:00 XENFORODB.xf_template_include-schema.sql
    -rw-r--r-- 1 root root  46K Oct 23 08:00 XENFORODB.xf_template_include.sql
    -rw-r--r-- 1 root root  460 Oct 23 08:00 XENFORODB.xf_template_map-schema.sql
    -rw-r--r-- 1 root root 189K Oct 23 08:00 XENFORODB.xf_template_map.sql
    -rw-r--r-- 1 root root  422 Oct 23 08:00 XENFORODB.xf_template_modification_log-schema.sql
    -rw-r--r-- 1 root root 5.7K Oct 23 08:00 XENFORODB.xf_template_modification_log.sql
    -rw-r--r-- 1 root root  733 Oct 23 08:00 XENFORODB.xf_template_modification-schema.sql
    -rw-r--r-- 1 root root  84K Oct 23 08:00 XENFORODB.xf_template_modification.sql
    -rw-r--r-- 1 root root  318 Oct 23 08:00 XENFORODB.xf_template_phrase-schema.sql
    -rw-r--r-- 1 root root 824K Oct 23 08:00 XENFORODB.xf_template_phrase.sql
    -rw-r--r-- 1 root root  772 Oct 23 08:00 XENFORODB.xf_template-schema.sql
    -rw-r--r-- 1 root root 7.8M Oct 23 08:00 XENFORODB.xf_template.sql
    -rw-r--r-- 1 root root  303 Oct 23 08:00 XENFORODB.xf_thread_prefix_group-schema.sql
    -rw-r--r-- 1 root root  183 Oct 23 08:00 XENFORODB.xf_thread_prefix_group.sql
    -rw-r--r-- 1 root root  613 Oct 23 08:00 XENFORODB.xf_thread_prefix-schema.sql
    -rw-r--r-- 1 root root 1.5K Oct 23 08:00 XENFORODB.xf_thread_prefix.sql
    -rw-r--r-- 1 root root  518 Oct 23 08:00 XENFORODB.xf_thread_read-schema.sql
    -rw-r--r-- 1 root root  165 Oct 23 08:00 XENFORODB.xf_thread_read.sql
    -rw-r--r-- 1 root root  410 Oct 23 08:00 XENFORODB.xf_thread_redirect-schema.sql
    -rw-r--r-- 1 root root 3.6K Oct 23 08:00 XENFORODB.xf_thread_redirect.sql
    -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_thread-schema.sql
    -rw-r--r-- 1 root root 231K Oct 23 08:00 XENFORODB.xf_thread.sql
    -rw-r--r-- 1 root root  331 Oct 23 08:00 XENFORODB.xf_thread_user_post-schema.sql
    -rw-r--r-- 1 root root  25K Oct 23 08:00 XENFORODB.xf_thread_user_post.sql
    -rw-r--r-- 1 root root  210 Oct 23 08:00 XENFORODB.xf_thread_view-schema.sql
    -rw-r--r-- 1 root root  154 Oct 23 08:00 XENFORODB.xf_thread_view.sql
    -rw-r--r-- 1 root root  385 Oct 23 08:00 XENFORODB.xf_thread_watch-schema.sql
    -rw-r--r-- 1 root root  16K Oct 23 08:00 XENFORODB.xf_thread_watch.sql
    -rw-r--r-- 1 root root  415 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tagged_content-schema.sql
    -rw-r--r-- 1 root root  38K Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tagged_content.sql
    -rw-r--r-- 1 root root  800 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag-schema.sql
    -rw-r--r-- 1 root root 208K Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag.sql
    -rw-r--r-- 1 root root  398 Oct 23 08:00 XENFORODB.xf_tinhte_xentag_tag_watch-schema.sql
    -rw-r--r-- 1 root root  318 Oct 23 08:00 XENFORODB.xf_trophy-schema.sql
    -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_trophy.sql
    -rw-r--r-- 1 root root  255 Oct 23 08:00 XENFORODB.xf_trophy_user_title-schema.sql
    -rw-r--r-- 1 root root  224 Oct 23 08:00 XENFORODB.xf_trophy_user_title.sql
    -rw-r--r-- 1 root root  414 Oct 23 08:00 XENFORODB.xf_upgrade_category-schema.sql
    -rw-r--r-- 1 root root  173 Oct 23 08:00 XENFORODB.xf_upgrade_category.sql
    -rw-r--r-- 1 root root  385 Oct 23 08:00 XENFORODB.xf_upgrade_log-schema.sql
    -rw-r--r-- 1 root root  240 Oct 23 08:00 XENFORODB.xf_upgrade_log.sql
    -rw-r--r-- 1 root root  250 Oct 23 08:00 XENFORODB.xf_user_alert_optout-schema.sql
    -rw-r--r-- 1 root root  211 Oct 23 08:00 XENFORODB.xf_user_alert_optout.sql
    -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_user_alert-schema.sql
    -rw-r--r-- 1 root root  318 Oct 23 08:00 XENFORODB.xf_user_authenticate-schema.sql
    -rw-r--r-- 1 root root  25K Oct 23 08:00 XENFORODB.xf_user_authenticate.sql
    -rw-r--r-- 1 root root  503 Oct 23 08:00 XENFORODB.xf_user_ban-schema.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_ban.sql
    -rw-r--r-- 1 root root  526 Oct 23 08:00 XENFORODB.xf_user_change_log-schema.sql
    -rw-r--r-- 1 root root  661 Oct 23 08:00 XENFORODB.xf_user_change_log.sql
    -rw-r--r-- 1 root root  684 Oct 23 08:00 XENFORODB.xf_user_change_temp-schema.sql
    -rw-r--r-- 1 root root  413 Oct 23 08:00 XENFORODB.xf_user_confirmation-schema.sql
    -rw-r--r-- 1 root root  388 Oct 23 08:00 XENFORODB.xf_user_external_auth-schema.sql
    -rw-r--r-- 1 root root 9.4K Oct 23 08:00 XENFORODB.xf_user_external_auth.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_field-schema.sql
    -rw-r--r-- 1 root root 1.1K Oct 23 08:00 XENFORODB.xf_user_field.sql
    -rw-r--r-- 1 root root  323 Oct 23 08:00 XENFORODB.xf_user_field_value-schema.sql
    -rw-r--r-- 1 root root  13K Oct 23 08:00 XENFORODB.xf_user_field_value.sql
    -rw-r--r-- 1 root root  393 Oct 23 08:00 XENFORODB.xf_user_follow-schema.sql
    -rw-r--r-- 1 root root  346 Oct 23 08:00 XENFORODB.xf_user_follow.sql
    -rw-r--r-- 1 root root  334 Oct 23 08:00 XENFORODB.xf_user_group_change-schema.sql
    -rw-r--r-- 1 root root  881 Oct 23 08:00 XENFORODB.xf_user_group_change.sql
    -rw-r--r-- 1 root root  502 Oct 23 08:00 XENFORODB.xf_user_group_promotion_log-schema.sql
    -rw-r--r-- 1 root root  991 Oct 23 08:00 XENFORODB.xf_user_group_promotion_log.sql
    -rw-r--r-- 1 root root  444 Oct 23 08:00 XENFORODB.xf_user_group_promotion-schema.sql
    -rw-r--r-- 1 root root  289 Oct 23 08:00 XENFORODB.xf_user_group_promotion.sql
    -rw-r--r-- 1 root root  381 Oct 23 08:00 XENFORODB.xf_user_group_relation-schema.sql
    -rw-r--r-- 1 root root 2.1K Oct 23 08:00 XENFORODB.xf_user_group_relation.sql
    -rw-r--r-- 1 root root  553 Oct 23 08:00 XENFORODB.xf_user_group-schema.sql
    -rw-r--r-- 1 root root  573 Oct 23 08:00 XENFORODB.xf_user_group.sql
    -rw-r--r-- 1 root root  313 Oct 23 08:00 XENFORODB.xf_user_ignored-schema.sql
    -rw-r--r-- 1 root root  432 Oct 23 08:00 XENFORODB.xf_user_news_feed_cache-schema.sql
    -rw-r--r-- 1 root root 102K Oct 23 08:00 XENFORODB.xf_user_news_feed_cache.sql
    -rw-r--r-- 1 root root 1.4K Oct 23 08:00 XENFORODB.xf_user_option-schema.sql
    -rw-r--r-- 1 root root 7.7K Oct 23 08:00 XENFORODB.xf_user_option.sql
    -rw-r--r-- 1 root root  809 Oct 23 08:00 XENFORODB.xf_user_privacy-schema.sql
    -rw-r--r-- 1 root root 9.6K Oct 23 08:00 XENFORODB.xf_user_privacy.sql
    -rw-r--r-- 1 root root 1.3K Oct 23 08:00 XENFORODB.xf_user_profile-schema.sql
    -rw-r--r-- 1 root root  35K Oct 23 08:00 XENFORODB.xf_user_profile.sql
    -rw-r--r-- 1 root root 2.7K Oct 23 08:00 XENFORODB.xf_user-schema.sql
    -rw-r--r-- 1 root root  24K Oct 23 08:00 XENFORODB.xf_user.sql
    -rw-r--r-- 1 root root  331 Oct 23 08:00 XENFORODB.xf_user_status-schema.sql
    -rw-r--r-- 1 root root  232 Oct 23 08:00 XENFORODB.xf_user_status.sql
    -rw-r--r-- 1 root root  350 Oct 23 08:00 XENFORODB.xf_user_trophy-schema.sql
    -rw-r--r-- 1 root root 2.8K Oct 23 08:00 XENFORODB.xf_user_trophy.sql
    -rw-r--r-- 1 root root  597 Oct 23 08:00 XENFORODB.xf_user_upgrade_active-schema.sql
    -rw-r--r-- 1 root root  544 Oct 23 08:00 XENFORODB.xf_user_upgrade_expired-schema.sql
    -rw-r--r-- 1 root root  775 Oct 23 08:00 XENFORODB.xf_user_upgrade_log-schema.sql
    -rw-r--r-- 1 root root 120K Oct 23 08:00 XENFORODB.xf_user_upgrade_log.sql
    -rw-r--r-- 1 root root 1.7K Oct 23 08:00 XENFORODB.xf_user_upgrade-schema.sql
    -rw-r--r-- 1 root root 2.5K Oct 23 08:00 XENFORODB.xf_user_upgrade.sql
    -rw-r--r-- 1 root root  490 Oct 23 08:00 XENFORODB.xf_warning_action-schema.sql
    -rw-r--r-- 1 root root  575 Oct 23 08:00 XENFORODB.xf_warning_action_trigger-schema.sql
    -rw-r--r-- 1 root root  580 Oct 23 08:00 XENFORODB.xf_warning_definition-schema.sql
    -rw-r--r-- 1 root root  237 Oct 23 08:00 XENFORODB.xf_warning_definition.sql
    -rw-r--r-- 1 root root  900 Oct 23 08:00 XENFORODB.xf_warning-schema.sql
    -rw-r--r-- 1 root root  266 Oct 23 08:00 XENFORODB.xf_widgetframework_widget_page-schema.sql
    -rw-r--r-- 1 root root  509 Oct 23 08:00 XENFORODB.xf_widget-schema.sql
    -rw-r--r-- 1 root root  11K Oct 23 08:00 XENFORODB.xf_widget.sql
    

    MySQL restore backup benchmarks



    mysql vs myloader multi-threaded restore database
    • mysql default restore backup = 6.77 seconds
    • myloader multi-threaded restore backup = 3.95 seconds = 1.71x times faster
    Code:
    mysql restoredb < mysqldump.sql
    real: 6.77s cpu: 13% maxmem: 39520 KB cswaits: 4047
    
    
    Code:
    myloader -d /home/mydumperdata/export-20141023-080052/ -B restoredb
    real: 3.95s cpu: 7% maxmem: 39920 KB cswaits: 4489
    
     
    Last edited: Oct 23, 2014
    • Like Like x 2
  20. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,785
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,137
    Local Time:
    3:35 AM
    Nginx 1.13.x
    MariaDB 5.5
    Mydumper 0.9 in the house !

    Code:
    mydumper -V
    mydumper 0.9.0, built against MySQL 10.0.19-MariaDB
    
    Code:
    myloader -V
    myloader 0.9.0, built against MySQL 10.0.19-MariaDB
    
    Code:
    mydumper --help
    Usage:
      mydumper [OPTION...] multi-threaded MySQL dumping
    
    Help Options:
      -?, --help                  Show help options
    
    Application Options:
      -B, --database              Database to dump
      -T, --tables-list           Comma delimited table list to dump (does not exclude regex option)
      -o, --outputdir             Directory to output files to
      -s, --statement-size        Attempted size of INSERT statement in bytes, default 1000000
      -r, --rows                  Try to split tables into chunks of this many rows. This option turns off --chunk-filesize
      -F, --chunk-filesize        Split tables into chunks of this output file size. This value is in MB
      -c, --compress              Compress output files
      -e, --build-empty-files     Build dump files even if no data available from table
      -x, --regex                 Regular expression for 'db.table' matching
      -i, --ignore-engines        Comma delimited list of storage engines to ignore
      -m, --no-schemas            Do not dump table schemas with the data
      -d, --no-data               Do not dump table data
      -G, --triggers              Dump triggers
      -E, --events                Dump events
      -R, --routines              Dump stored procedures and functions
      -k, --no-locks              Do not execute the temporary shared read lock.  WARNING: This will cause inconsistent backups
      --less-locking              Minimize locking time on InnoDB tables.
      -l, --long-query-guard      Set long query timer in seconds, default 60
      -K, --kill-long-queries     Kill long running queries (instead of aborting)
      -D, --daemon                Enable daemon mode
      -I, --snapshot-interval     Interval between each dump snapshot (in minutes), requires --daemon, default 60
      -L, --logfile               Log file name to use, by default stdout is used
      --tz-utc                    SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.
      --skip-tz-utc            
      --use-savepoints            Use savepoints to reduce metadata locking issues, needs SUPER privilege
      --success-on-1146           Not increment error count and Warning instead of Critical in case of table doesn't exist
      --lock-all-tables           Use LOCK TABLE for all, instead of FTWRL
      -U, --updated-since         Use Update_time to dump only tables updated in the last U days
      --trx-consistency-only      Transactional consistency only
      -h, --host                  The host to connect to
      -u, --user                  Username with privileges to run the dump
      -p, --password              User password
      -P, --port                  TCP/IP port to connect to
      -S, --socket                UNIX domain socket file to use for connection
      -t, --threads               Number of threads to use, default 4
      -C, --compress-protocol     Use compression on the MySQL connection
      -V, --version               Show the program version and exit
      -v, --verbose               Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2
    
    Code:
    myloader --help
    Usage:
      myloader [OPTION...] multi-threaded MySQL loader
    
    Help Options:
      -?, --help                        Show help options
    
    Application Options:
      -d, --directory                   Directory of the dump to import
      -q, --queries-per-transaction     Number of queries per transaction, default 1000
      -o, --overwrite-tables            Drop tables if they already exist
      -B, --database                    An alternative database to restore into
      -s, --source-db                   Database to restore
      -e, --enable-binlog               Enable binary logging of the restore data
      -h, --host                        The host to connect to
      -u, --user                        Username with privileges to run the dump
      -p, --password                    User password
      -P, --port                        TCP/IP port to connect to
      -S, --socket                      UNIX domain socket file to use for connection
      -t, --threads                     Number of threads to use, default 4
      -C, --compress-protocol           Use compression on the MySQL connection
      -V, --version                     Show the program version and exit
      -v, --verbose                     Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2