Dear,
I am making my own logs for everything now (swap inventory slots, buying a car, on and off duty), littery everything is being logged. What is the best way to log these events? I think MySQL is not a great option for this.
What is your view about this?
Sincerely,
ConstructedDamage
I use a mix of MySQL and local file writes. SQL for important stuff that I might want to show on UCP as well, local files for log dumps like mission / job completes, every kind of currency transfer, tebex transactions or every use of the [/ragequit] command.
A database would literally die with that much data (just think of how many calls you’ll have with at least 20-30 players, lol); you may use Discord via webhooks for the logs and it used to be most common solution due how easy it is to implement, however if you want to delve into more in-depth stuff you can use something like Fivemanage to store (and export for analysis as needed) your logs with the relevant API calls.
Ox Lib also has a logger interface with support for common log services such as Datadog and Fivemanage.
A database is limited to 64 billion records. Even with 50’000 records / day, you would still have 3500 years of runtime. Even if all 50 users or even 1’000 users would have 1 transaction per second, your database is able to handle about 10k writes / second.