topic Re: 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/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 i5513 2010-07-15T06:44:50Z 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