topic Alfresco Data Query in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-data-query/m-p/277456#M230586 <HTML><HEAD></HEAD><BODY><SPAN>Hi just doing some backup verification and noticed some small annonlymies with the data before and after backup.&nbsp; There are no users logged into the system as its a local VM used for testing purposes.</SPAN><BR /><BR /><SPAN>All the other tables are an exact match.&nbsp; These tables do match on the table sizes but just not on the number of records in the table.&nbsp; I'm thinking that something must happen to these file automatically?&nbsp; </SPAN><BR /><BR /><SPAN>My SQL script is as follows:</SPAN><BR /><BR /><SPAN>select table_name, table_rows, engine, data_length,data_free from information_schema.tables where information_schema.tables.table_schema = 'alfresco' INTO OUTFILE'/alf_data/Backup/tmp/MySQL_Prebackup.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';</SPAN><BR /><BR /><SPAN>Just doing a sanity check and the results of the table records are as follows:</SPAN><BR /><BR /><SPAN>Three figures all for the number of records.&nbsp; </SPAN><BR /><BR /><SPAN>One before, one after percona backup but before prepare and one after prepare.&nbsp; There has been no restore only the backup and prepare processes have been carried out.</SPAN><BR /><BR /><SPAN>alf_activity_feed&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;10</SPAN><BR /><SPAN>alf_node&nbsp;&nbsp;&nbsp;3486&nbsp;&nbsp;&nbsp;3701&nbsp;&nbsp;&nbsp;3650</SPAN><BR /><SPAN>alf_node_properties&nbsp;&nbsp;&nbsp;2119&nbsp;&nbsp;&nbsp;1495&nbsp;&nbsp;&nbsp;2119</SPAN><BR /><BR /><SPAN>When I tried this on our live environment with users in i had the following results:</SPAN><BR /><BR /><SPAN>alf_child_assoc&nbsp;&nbsp;&nbsp;1331&nbsp;&nbsp;&nbsp;1214&nbsp;&nbsp;&nbsp;1411</SPAN><BR /><SPAN>alf_node&nbsp;&nbsp;&nbsp;4387&nbsp;&nbsp;&nbsp;4648&nbsp;&nbsp;&nbsp;4406</SPAN><BR /><SPAN>alf_node_aspects&nbsp;&nbsp;&nbsp;2104&nbsp;&nbsp;&nbsp;2095&nbsp;&nbsp;&nbsp;2224</SPAN><BR /><SPAN>alf_node_properties&nbsp;&nbsp;&nbsp;3818&nbsp;&nbsp;&nbsp;4052&nbsp;&nbsp;&nbsp;4271</SPAN><BR /><SPAN>alf_transaction&nbsp;&nbsp;&nbsp;677&nbsp;&nbsp;&nbsp;571&nbsp;&nbsp;&nbsp;677</SPAN><BR /><SPAN>jbpm_log&nbsp;&nbsp;&nbsp;2275&nbsp;&nbsp;&nbsp;1865&nbsp;&nbsp;&nbsp;1861</SPAN><BR /><BR /><SPAN>This might be because users are using the system.</SPAN><BR /><BR /><SPAN>Just seems a bit weird that the table figures go up and down a bit.</SPAN><BR /><BR /><SPAN>Any ideas?</SPAN></BODY></HTML> Fri, 25 Mar 2011 13:29:00 GMT bensewell 2011-03-25T13:29:00Z Alfresco Data Query https://connect.hyland.com/t5/alfresco-archive/alfresco-data-query/m-p/277456#M230586 Hi just doing some backup verification and noticed some small annonlymies with the data before and after backup.&nbsp; There are no users logged into the system as its a local VM used for testing purposes.All the other tables are an exact match.&nbsp; These tables do match on the table sizes but just not on t Fri, 25 Mar 2011 13:29:00 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-data-query/m-p/277456#M230586 bensewell 2011-03-25T13:29:00Z Re: Alfresco Data Query https://connect.hyland.com/t5/alfresco-archive/alfresco-data-query/m-p/277457#M230587 <HTML><HEAD></HEAD><BODY><SPAN>Resolved by a simple look at the Innodb part of MySQL website.&nbsp; The record numbers are a rough estimate as InnoDB fluctuates with its use.&nbsp; The table file sizes are the same indicating that the backup was a success before and after backup.&nbsp; </SPAN><A href="http://dev.mysql.com/doc/refman/5.1/en/tables-table.html" rel="nofollow noopener noreferrer">http://dev.mysql.com/doc/refman/5.1/en/tables-table.html</A></BODY></HTML> Mon, 04 Apr 2011 09:43:23 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-data-query/m-p/277457#M230587 bensewell 2011-04-04T09:43:23Z