Database size

  • Resolved kinigakos

    (@kinigakos)


    5 months ago

    Hello, I had installed the plugin and noticed that the database got twice the size after converting some tables in InnoDB.

    Is this a normal behaviour? The database was already big (2.4GB) and now is 4GB.
    I’m tending to set up object cache in the near future.

    Site monitored metadata was uploaded and its id is 3jpDBk92.

    Τhank you for the great plugin, the site loads faster regardless of whether the database grew.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Yes, it’s normal for the database size to increase when you add keys to tables. It’s the oldest tradeoff in computer science: space vs. time.

    I noticed from your uploaded metadata that your MariaDB database server is far too small for your data. It has an innodb_buffer_pool_size of 128MiB, and your InnoDB tables take up 4 GiB. If you are having performance problems, see if you can get that buffer pool size increased.

    Thread Starter kinigakos

    (@kinigakos)

    Thank you for your quick response.

    I finally did set up object cache and increased the innodb_buffer_pool_size at 10GiB.

    I’ve uploaded again the last monitor, can you please do a quick check if everything is ok or if I should do anything else regarding the database?
    Site monitored metadata: 3jpDBk92.

    Thanks in advance and once again thank you for your great plugin.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.