Speeding up your Server 101 (Windows)

FiveM Resource Development & Modding Modding Tutorials
,
29

that’s standard nothing to worry about.

30

Can somebody help me, i dont know what indexes to make :slight_smile: [MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_addoninventory] [446ms] SELECT * FROM items
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_addonaccount] [446ms] SELECT * FROM addon_account
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_vehicleshop] [408ms] SELECT * FROM vehicle_categories
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_datastore] [371ms] SELECT * FROM datastore
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_boat] [351ms] UPDATE owned_vehicles SET stored = true WHERE stored = false AND type = ‘boat’
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_property] [347ms] SELECT * FROM properties
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [esx_society] [337ms] SELECT * FROM jobs
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [es_extended] [324ms] SELECT * FROM items
[MariaDB:10.3.17-MariaDB] [Slow Query Warning] [es_extended] [324ms] SELECT * FROM jobs

1 Like
31

Can I do the part with “New Index -> KEY” for linux as well ?

32

Yes, that part is database related independent from the OS.

33

I have the same issue when i start my server.
If someone know how to solve that i would be good.

34

Could someone tell me what would cause this image

35

Same problem, I need to know too why shows that.

36

This happen with the newest version of esx_vehicleshop, just revert to a older version.

37

alright thank you!

38

Would this be the same thing as the vehicle shop

image
image1509×78 46.4 KB

39

Capasdsadsadaure
Capasdsadsadaure930×107 3.95 KB

40

image
image849×633 102 KB

What about this?

42

conseguiu resolver?

43

Revert to previous version to fix this.

44

Capture
Anyone have any sort of idea as to what this could be? I know Badger Essentials take a bit but its a hefty script so I’m not too worried about it.

46

Hey @zr0iq,

thanks for that awesome tutorial!
Im currently trying to use UI for ETW on my Windows Server.
Im starting my FxServer.exe via a .bat file.
The Problem i have right now is that after recording in UIforETW and opening it in WPA i cannot see the “FXServer.exe” or any other process i can only see “UIforETW.exe”. Ive tried an older version of UIforETW but that didnt help :(. Any ideas why that might be ?

3 Likes
47

Good afternoon!
Were you able to verify it somehow? I don’t find the FXServer.exe process in Generic Events, only in CPU Usage. I’m having network thread hitch warning issues with about 400~600 players connected, causing about 95% of them to disconnect.

I’m using TXAdmin

48

I am having the same issue, fxserver.exe only shows in the CPU Usage. It doesn’t show in the Generic Events. Only the UIforETW.exe shows. Any ideas? TIA.

49

Hey generally for profiling there is no need for ETW anymore :slight_smile:
You can use the serversided resmon (only on windows) by typing svgui in the txadmin console and then going to your cmd window. Or you can use the profiler (profiler record 200 and then profiler view)

50

There is most definitely a need for ETW. Why is it that whenever I save an ETL file the event names don’t show up in the list anymore like others have shown? I need to use this to diagnose some network thread hitches that I am having and without the event data anymore this is unhelpful. What changed that made the event names stop showing?