High Mysql Usage - Githubissues

jchristn / Less3

Less3 is an S3-compatible object storage server that runs on your laptop, servers, just about anywhere!

MIT License

49 stars 9 forks source link

High Mysql Usage #5

Closed Undrego closed 8 months ago

Undrego commented 1 year ago

Good Day. Firstly thank you for a great s3 server

I have one small issue i cant seem to get past.

I setup the less3 server on a ubuntu box with mysql as db. this works great but when traffic picks up then mysql load skyrockets to 100% and when viewing mysql processes this is displayed.

Can you give me any advise on how to resolve this. Apologies for the bother and thank you once again

jchristn commented 8 months ago

Hi, sorry I'm just now seeing this. I'd recommend adding indices to each field in each table that are often used in queries, essentially anything with a GUID and certain other keys.