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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
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

Cloudron Forum

Apps | Demo | Docs | Install

Backup: compress mysqldumps

Scheduled Pinned Locked Moved Feature Requests
backupsfeature-request
9 Posts 3 Posters 528 Views
    • 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 Online
    nebulonN Online
    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 Online
    nebulonN Online
    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

  • Login

  • Don't have an account? Register

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

  • Don't have an account? Register

  • Login or register to search.