Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Feature Requests
  3. Backup: compress mysqldumps

Backup: compress mysqldumps

Scheduled Pinned Locked Moved Feature Requests
backupsfeature-request
9 Posts 3 Posters 1.7k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • necrevistonnezrN Offline
      necrevistonnezrN Offline
      necrevistonnezr
      wrote on last edited by girish
      #1

      I realized that e.g. the mysqldump for the TT-RSS app in the backup is huge (679 MB in my case). Could you implement some compession in the database dumps like

      mysqldump #### | gzip > dump.sql.gz
      1 Reply Last reply
      1
      • girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #2

        @necrevistonnezr This can definitely be done. But it's a bit suspicious as to why it is so big. I am also a big TTRSS user. I checked my dump size and it is around 50M. I am wondering if the ttrss app is mis-configured in some way.

        If you go to the webterminal of ttrss app and press the mysql button and run this command (from this article):

        SELECT 
             table_schema as `Database`, 
             table_name AS `Table`, 
             round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
        FROM information_schema.TABLES 
        ORDER BY (data_length + index_length) DESC;
        

        I got https://paste.cloudron.io/sosuranewo.rb

        1 Reply Last reply
        0
        • necrevistonnezrN Offline
          necrevistonnezrN Offline
          necrevistonnezr
          wrote on last edited by
          #3

          @girish I get: https://paste.cloudron.io/gowefutore.rb

          0_1528532893478_20180609_102754-Screenshot.png

          I think that's "normal" if you use one of the fulltext plugins for certain feeds (readability or mercury)....

          1 Reply Last reply
          0
          • girishG Offline
            girishG Offline
            girish
            Staff
            wrote on last edited by
            #4

            @necrevistonnezr Thanks, I have opened https://git.cloudron.io/cloudron/box/issues/562 to investigate.

            1 Reply Last reply
            2
            • necrevistonnezrN Offline
              necrevistonnezrN Offline
              necrevistonnezr
              wrote on last edited by
              #5

              Many thanks!

              1 Reply Last reply
              0
              • nebulonN Offline
                nebulonN Offline
                nebulon
                Staff
                wrote on last edited by
                #6

                This will be handled further in the issue tracker

                1 Reply Last reply
                0
                • necrevistonnezrN Offline
                  necrevistonnezrN Offline
                  necrevistonnezr
                  wrote on last edited by
                  #7

                  https://git.cloudron.io/cloudron/box/blob/master/CHANGES#L1540

                  [3.6.0]

                  • Make reboot required check server side
                  • Update node to 10.15.1
                  • Enable gzip compression for large objects

                  Does that mean SQL dumps are now compressed?

                  1 Reply Last reply
                  0
                  • nebulonN Offline
                    nebulonN Offline
                    nebulon
                    Staff
                    wrote on last edited by
                    #8

                    @necrevistonnezr the gzip here is for the nginx reverseproxy configs, not related to the mysqldumps.

                    1 Reply Last reply
                    0
                    • necrevistonnezrN Offline
                      necrevistonnezrN Offline
                      necrevistonnezr
                      wrote on last edited by
                      #9

                      Maybe we could at least introduce an optimization of the databases from time to time. The size of the referenced "ttrss_entries" table went from an insane 1,238 MB (!) to 583 MB after optimization.
                      The following command, maybe via a button, should to the trick:

                      mysqlcheck -Aos --user=${MYSQL_USERNAME} --password=${MYSQL_PASSWORD} --host=${MYSQL_HOST};

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • Bookmarks
                        • Search