topic Upgrading from 2.1 to 3.3, Mysql server CPU goes to 99% in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225458#M178588 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I'm trying to upgrading from Alfresco Comunity 2.1 to 3.3.</SPAN><BR /><BR /><SPAN>My database size is 90 Mb, and my repo size is 76 GB</SPAN><BR /><BR /><SPAN>Yesterday I started an Alfresco copy with 3.3 installation and withe a copy of repo and database, log show me:</SPAN><BR /><SPAN>17:06:21,219 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-7046270136065738344.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-0-create-missing-tables.sql).</SPAN><BR /><SPAN>17:06:21,489 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6919328127734969314.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).</SPAN><BR /><BR /><SPAN>And now, one day later, at 09:00 it didn't finish yet.</SPAN><BR /><BR /><SPAN>With mytop I can see next sentence is executing now (and yesterday last time I see the query):</SPAN><BR /><SPAN>EXPLAIN INSERT INTO t_alf_node_properties ( node_id, qname_id, locale_id, list_index, actual_type_n, persisted_type_n, boolean_value, long_value, float_value, double_value, string_value, serializable_value ) SELECT np.node_id, tqn.qname_id, 1, -1, ptypes_actual.type_id, ptypes_persisted.type_id, np.boolean_value, np.long_value, np.float_value, np.double_value, np.string_value, np.serializable_value FROM alf_node_properties np JOIN t_qnames tqn ON (np.qname = tqn.qname) JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = np.actual_type) JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = np.persisted_type) WHERE np.attribute_value IS NULL: </SPAN><BR /><BR /><SPAN>This is the line of mysql in top util:</SPAN><BR /><SPAN>2322 mysql&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 0&nbsp; 919m 459m&nbsp; 12m S 98.8 23.0&nbsp;&nbsp; 1094:36 mysqld</SPAN><BR /><BR /><SPAN>Should my mysql be customized for Alfresco upgrade ?</SPAN><BR /><BR /><SPAN>How can I know how many time will take Alfresco upgrade?</SPAN><BR /><BR /><SPAN>Any tip ?</SPAN><BR /><BR /><SPAN>Thanks !</SPAN></BODY></HTML> Wed, 14 Jul 2010 07:05:52 GMT i5513 2010-07-14T07:05:52Z Upgrading from 2.1 to 3.3, Mysql server CPU goes to 99% https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225458#M178588 Hi,I'm trying to upgrading from Alfresco Comunity 2.1 to 3.3.My database size is 90 Mb, and my repo size is 76 GBYesterday I started an Alfresco copy with 3.3 installation and withe a copy of repo and database, log show me:17:06:21,219 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executin Wed, 14 Jul 2010 07:05:52 GMT https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225458#M178588 i5513 2010-07-14T07:05:52Z Re: Upgrading from 2.1 to 3.3, Mysql server CPU goes to 99% https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225459#M178589 <HTML><HEAD></HEAD><BODY><SPAN>This seems like this is a known issue [1] with alfresco, but I don't known how can I count howmany nodes has my alfresco. I know about alf_node_properties has 300000 rows.</SPAN><BR /><BR /><SPAN>[1] </SPAN><A href="https://issues.alfresco.com/jira/browse/ALF-3779" rel="nofollow noopener noreferrer">https://issues.alfresco.com/jira/browse/ALF-3779</A></BODY></HTML> Thu, 15 Jul 2010 06:44:50 GMT https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225459#M178589 i5513 2010-07-15T06:44:50Z Re: Upgrading from 2.1 to 3.3, Mysql server CPU goes to 99% https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225460#M178590 <HTML><HEAD></HEAD><BODY><SPAN>We're working on a solution. It seems that you can't stop MySQL from taking out lots of record level locks on an INSERT - SELECT, even when there are table locks. We are looking at chunking the inserts into smaller transactions.</SPAN></BODY></HTML> Thu, 15 Jul 2010 11:58:25 GMT https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225460#M178590 dward 2010-07-15T11:58:25Z Re: Upgrading from 2.1 to 3.3, Mysql server CPU goes to 99% https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225461#M178591 <HTML><HEAD></HEAD><BODY><SPAN>Thank you working in this issue, I lost your reply <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Tue, 14 Sep 2010 11:17:28 GMT https://connect.hyland.com/t5/alfresco-archive/upgrading-from-2-1-to-3-3-mysql-server-cpu-goes-to-99/m-p/225461#M178591 i5513 2010-09-14T11:17:28Z