v1.8.0 mysql metastore longevity test failed

[huangjw806]

================================================================================
longevity-test Result
================================================================================
Result               FAIL                
Pipeline Message     v1.8.0-rc-3 mysql test
Namespace            usrlngvty-20240326-094848
TestBed              medium-arm-3cn-all-affinity
RW Version           v1.8.0-rc-3         
Test Start time      2024-03-26 09:58:50 
Test End time        2024-03-26 21:51:28 
Test Queries         nexmark_q0,nexmark_q1,nexmark_q2,nexmark_q3,nexmark_q4,nexmark_q5,nexmark_q6_group_top1,nexmark_q7,nexmark_q8,nexmark_q9,nexmark_q10,nexmark_q12,nexmark_q14,nexmark_q15,nexmark_q16,nexmark_q17,nexmark_q18,nexmark_q19,nexmark_q20,nexmark_q21,nexmark_q22,nexmark_q101,nexmark_q102,nexmark_q103,nexmark_q104,nexmark_q105
Grafana Metric       https://grafana.test.risingwave-cloud.xyz/d/EpkBw5W4k/risingwave-dev-dashboard?orgId=1&var-datasource=Prometheus:%20test-useast1-eks-a&var-namespace=usrlngvty-20240326-094848&from=1711447130000&to=1711489888000
Grafana Logs         https://grafana.test.risingwave-cloud.xyz/d/liz0yRCZz1/log-search-dashboard?orgId=1&var-data_source=Logging:%20test-useast1-eks-a&var-namespace=usrlngvty-20240326-094848&from=1711447130000&to=1711489888000
Memory Dumps         https://s3.console.aws.amazon.com/s3/buckets/test-useast1-mgmt-bucket-archiver?region=us-east-1&bucketType=general&prefix=k8s/usrlngvty-20240326-094848/&showversions=false
Buildkite Job        https://buildkite.com/risingwave-test/longevity-test/builds/1202

================================================================================
Restarted/Crashed Pods Details
 ================================================================================
Pod crashed/Restarted: benchmark-risingwave-compute-c-1 restart_count:8  phase:Running status:False

[huangjw806]

It should be that the storage space of mysql is insufficient.

Now we provide 8G disks by default. It seems that etcd is enough, and pg running for 12 hours is enough. Mysql running for 11 hours is not enough, so the SQL backends storage needs to be discussed.