You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/02/05 13:03:34 UTC

[GitHub] [incubator-shardingsphere] liutaohua opened a new issue #4179: ParameterMarkerExpressionSegment looks like a memory leak

liutaohua opened a new issue #4179: ParameterMarkerExpressionSegment looks like a memory leak
URL: https://github.com/apache/incubator-shardingsphere/issues/4179
 
 
   hi，
   i'm use ` sharding-jdbc-core:4.0.0-RC3` to shard data in 10-tables .
   
   table :
   ```
   CREATE TABLE `t_message_0` (
     `id` bigint(20) NOT NULL AUTO_INCREMENT,
     `message` varchar(255) DEFAULT NULL,
     `message_id` varchar(50) DEFAULT NULL,
     `params` varchar(255) DEFAULT NULL,
     PRIMARY KEY (`id`),
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   ```
   
   and insert sql :
   ```
   insert into t_message_{0...9} (message, message_id, params) values ( ?,?,? ),( ?,?,? ),( ?,?,? ),( ?,?,? )
   ```
   
   The write speed of the database is about 25,000/s ,  and the test lasts about an hour.
   
   I found the `simple.ParameterMarkerExpressionSegment` and  `dml.assignment.InsertValuesSegment`
   The total number of classes is increasing, and `GC` does not reduce the number of instances.
   
   So I guess it might be a memory leak. Did anyone else have the same problem as me? Or am I missing something?

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [shardingsphere] baimeng1758354676 commented on issue #4179: ParameterMarkerExpressionSegment looks like a memory leak

Posted by GitBox <gi...@apache.org>.
baimeng1758354676 commented on issue #4179:
URL: https://github.com/apache/shardingsphere/issues/4179#issuecomment-894048424


   > hi，
   > i'm use ` sharding-jdbc-core:4.0.0-RC3` to shard data in 10-tables .
   > 
   > table :
   > 
   > ```
   > CREATE TABLE `t_message_0` (
   >   `id` bigint(20) NOT NULL AUTO_INCREMENT,
   >   `message` varchar(255) DEFAULT NULL,
   >   `message_id` varchar(50) DEFAULT NULL,
   >   `params` varchar(255) DEFAULT NULL,
   >   PRIMARY KEY (`id`),
   > ) ENGINE=InnoDB DEFAULT CHARSET=utf8
   > ```
   > 
   > and insert sql :
   > 
   > ```
   > insert into t_message_{0...9} (message, message_id, params) values ( ?,?,? ),( ?,?,? ),( ?,?,? ),( ?,?,? )
   > ```
   > 
   > The write speed of the database is about 25,000/s , and the test lasts about an hour.
   > 
   > I found the `simple.ParameterMarkerExpressionSegment` and `dml.assignment.InsertValuesSegment`
   > The total number of classes is increasing, and `GC` does not reduce the number of instances.
   > 
   > So I guess it might be a memory leak. Did anyone else have the same problem as me? Or am I missing something?
   
   i got  the same questions,so  this will cause memory leak?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] baimeng1758354676 commented on issue #4179: ParameterMarkerExpressionSegment looks like a memory leak

Posted by GitBox <gi...@apache.org>.
baimeng1758354676 commented on issue #4179:
URL: https://github.com/apache/shardingsphere/issues/4179#issuecomment-894047366


   i have the same question


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [incubator-shardingsphere] liutaohua closed issue #4179: ParameterMarkerExpressionSegment looks like a memory leak

Posted by GitBox <gi...@apache.org>.
liutaohua closed issue #4179: ParameterMarkerExpressionSegment looks like a memory leak
URL: https://github.com/apache/incubator-shardingsphere/issues/4179
 
 
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [shardingsphere] baimeng1758354676 removed a comment on issue #4179: ParameterMarkerExpressionSegment looks like a memory leak

Posted by GitBox <gi...@apache.org>.
baimeng1758354676 removed a comment on issue #4179:
URL: https://github.com/apache/shardingsphere/issues/4179#issuecomment-894047366


   i have the same question


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org