search

cardano-foundation / cardano-graphql

GraphQL API for Cardano
Apache License 2.0
259 stars 103 forks source link

cardano-db-sync is too slow #818

Closed zhy827827 closed 1 year ago

zhy827827 commented 1 year ago

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.