cardano-foundation/cardano-graphql

cardano-db-sync is too slow

zhy827827 opened this issue · 0 comments

zhy827827 commented

Ask a question

docker logs:

{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.76% | Asset: 100%","time":"2023-02-14T09:40:54.570Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:00.200Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:05.840Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:11.558Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:17.153Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:22.770Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:28.386Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:34.074Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:39.693Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:45.302Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:50.913Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:41:56.630Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:02.243Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:07.864Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:13.487Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:19.131Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:24.794Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:30.460Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:36.251Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:41.906Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:47.536Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:53.161Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:42:58.799Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:04.398Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:10.040Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:15.697Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:21.301Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:26.894Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:32.499Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:38.085Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:43.752Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:49.369Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:43:55.016Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:44:00.626Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:44:06.258Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:44:11.916Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.77% | Asset: 100%","time":"2023-02-14T09:44:17.526Z","v":0}
{"name":"cardano-graphql","hostname":"e1f4d5bbd9b3","pid":1,"level":30,"module":"Server","msg":"Sync Progress: cardano-db-sync: 54.78% | Asset: 100%","time":"2023-02-14T09:44:23.127Z","v":0}

curl -X POST -H "Content-Type: application/json" -d '{"query": "{ cardanoDbMeta { initialized syncPercentage }}"}' http://localhost:3200/graphql |jq
{
"data": {
"cardanoDbMeta": {
"initialized": false,
"syncPercentage": 54.79
}
}
}

Two-minute synchronization 0.01%!!!!!!!!!!!!!!
cardano-graphql7.0.2 cannot upgrade directly to cardano-graphql 8.0.0.Because there are many errors in the upgrade
But direct deployment of cardano-graphql 8.0.0., synchronization is too slow. Is there have a good plan?

with AWS server: c6gn.8xlarge: 32C64G EBS 1T iops 16000.