Compliments of the season to everyone and I hope that this mail finds all well.
I am trying to find out a bit more regarding the archiving storage engine.
We currently have an archiving process that the dev team wrote for archiving of data.
However, management has requested that we move the archived data on the archive server to a database using tables create with the Archive storage engine.
This also counts for all new data.
After reading up on it, the dev team have a few concerns and thus I would like to find out from people who may have had experience with the storage engine.
From what we can see it stores unindexed data, thus reading from these tables will be slow as it uses full table scans.
The current archiving process however copies data over to the archive server, then it does integrity checks between the archive server and live data to confirm that the data did in fact copy correctly before it removes the data from the live server.
The concern is that moving to the archive storage engine will slow down the process as all selects for the integrity checks will become slower due to no indexes being available, etc...
Can anyone please advise on this ? Any info will be greatly appreciated.
Regards
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jul 27
Bjorn Munch MySQL Community Server 8.0.12 has been released (part 2/2)
Jul 27, 2018; 19:49
Bjorn Munch
MySQL Community Server 8.0.12 has been released (part 2/2)
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!