Hey Guys - not exactly a DBA, but i have setup a mysql instance on Ubuntu and loaded the data into the tables. After realizing that I can save significant space by using innodb compression I have altered a few tables to use compression.
Problem is its using the same amount of space...at least according to phpmyadmin. Also the "compression" process seems to have eaten up even more disk space and it hasnt been released. I assume it was tmp/scratch space to write out the contents temporarily.
Any ideas here?
Problem is its using the same amount of space...at least according to phpmyadmin. Also the "compression" process seems to have eaten up even more disk space and it hasnt been released. I assume it was tmp/scratch space to write out the contents temporarily.
Any ideas here?