30만건
Max Memory: 2048 MB
Total Memory: 512 MB
freeMemory: 461 MB
Used Memory: 50 MB
Before: 50 MB
After: 1277 MB
Memory used by API: 1227 MB
2025-04-23T11:45:55.726+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: ExcelUploadUtils.parseExcelToObject(..)
2025-04-23T11:45:55.726+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 14.5688651
2025-04-23T11:45:55.738+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: AdminSalaryService.excelUploadSalary(..)
Max Memory: 2048 MB
Total Memory: 2048 MB
freeMemory: 511 MB
Used Memory: 1536 MB
Before: 1536 MB
2025-04-23T11:45:56.752+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: ListCrudRepository.saveAll(..)
2025-04-23T11:47:22.791+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: ListCrudRepository.saveAll(..)
2025-04-23T11:47:22.791+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 86.0385429
After: 508 MB
Memory used by API: -1028 MB
2025-04-23T11:47:22.791+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: AdminSalaryService.excelUploadSalary(..)
2025-04-23T11:47:22.791+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 87.054041
2025-04-23T11:47:23.847+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: AdminSalaryController.excelUpload(..)
2025-04-23T11:47:23.847+09:00 INFO 16128 --- [nio-8080-exec-5] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 102.6899798
10만건
2025-04-23T12:16:13.108+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: AdminSalaryController.excelUpload(..)
2025-04-23T12:16:13.109+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: ExcelUploadUtils.parseExcelToObject(..)
Max Memory: 2048 MB
Total Memory: 512 MB
freeMemory: 458 MB
Used Memory: 53 MB
Before: 53 MB
After: 456 MB
Memory used by API: 403 MB
2025-04-23T12:16:16.854+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: ExcelUploadUtils.parseExcelToObject(..)
2025-04-23T12:16:16.855+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 3.7453336
2025-04-23T12:16:16.856+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: AdminSalaryService.excelUploadSalary(..)
2025-04-23T12:16:16.864+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: EmployeeRepository.findAllByEmpNoIn(..)
2025-04-23T12:16:17.404+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: EmployeeRepository.findAllByEmpNoIn(..)
2025-04-23T12:16:17.404+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 0.5404145
Max Memory: 2048 MB
Total Memory: 1015 MB
freeMemory: 386 MB
Used Memory: 628 MB
Before: 628 MB
2025-04-23T12:16:17.435+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 메서드]: ListCrudRepository.saveAll(..)
2025-04-23T12:16:42.403+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: ListCrudRepository.saveAll(..)
2025-04-23T12:16:42.403+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 24.9670936
After: 154 MB
Memory used by API: -473 MB
2025-04-23T12:16:42.403+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: AdminSalaryService.excelUploadSalary(..)
2025-04-23T12:16:42.403+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 25.5476658
2025-04-23T12:16:42.635+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [종료 메서드]: AdminSalaryController.excelUpload(..)
2025-04-23T12:16:42.636+09:00 INFO 16128 --- [nio-8080-exec-4] c.h.global.aop.GlobalLoggingAspect : [실행 시간]: 29.5271092
의문점
saveAll을 호출하기전에 메모리 사용량은 왜 1536 MB일까?
saveAll을 호출이후에는 메모리 사용량이 왜 508 MB일까?
'프로젝트' 카테고리의 다른 글
엑셀 100만건 업로드 트러블 슈팅 (1) (0) | 2025.04.17 |
---|