How much space will be used?
-
I read in a review that someone 3x’d the amount of space their database used. I don’t know how to check how much space my database uses and I don’t want to crash the server from it using too much. Any way to a) find out how much space my db uses and b) guess how much running the plugin will add.
Upload id: QEBJQUht
wp_options (2,116 rows, approximately)
wp_postmeta (1,985,374 rows, approximately)
wp_posts (587,486 rows, approximately)
-
If you look at the About tab on Tool -> Index MySQL you’ll see information about space used by your tables.
The three tables you mention, in your system, according to your uploaded metadata, are in the older slower obsolete MyISAM storage engine format.
It’s unlikely that adding the new keys will triple the space used. Usually it adds 30 – 50%. Experience, especially with WooCommerce, shows that the tradeoff of more space for less time is almost certainly worth it.
But, converting your tables to the faster InnoDB format may, in fact, make it look like you’re using more space, due to the way space usage is sometimes reported. If you want to use the high-performance keys you need to do the conversion first.
According to your metadata, you have a separate MariaDB server machine from your web server, and that server has 2GiB allocated to the InnoDB buffer pool. You may, or may not, be able to increase that allocation depending on the amount of RAM available to your MariaDB machine. The metadata doesn’t tell me that.
- The topic ‘How much space will be used?’ is closed to new replies.
