Hi, we're in a situation where we have >10GiB worth of test report data per 48 hour period. Aside from increasing the size of the MySQL database, what are some options for this scale of data storage? We are looking at having itestcli output the reports as HTML and put them on a fileserver for later access. Is anyone using other DBs like Oracle?
I believe we can check the size of iTest external database from "reportitem.ibd" file. ![![alt text]] We can free up the size occupied by database file with a command "OPTIMIZE TABLE " from command line. Eg: OPTIMIZE TABLE reportitem Before doing the optimize check the size of reportitem.ibd file.And then go to mysql command line, enter the reports db, run "optimize table reportitem". Ex: mysql> optimize table reportitems; After execution check the size of reportitem.ibd. it should be decrease.We could find the utilization of The "OTIMIZE" command in below links
http://dev.mysql.com/doc/refman/5.6/en/optimize-table.htmlhttp://dev.mysql.com/doc/refman/5.6/en/innodb-multiple-tablespaces.html : /storage/temp/4620-reportitem.ibd.jpg