[CS:GO] ckSurf (1.18f, 24.11.2015) - Page 52

mazdarx8 · 10-21-2015 , 01:15 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Can someone tell me, if this normal when someone finish a map he see the points what he get after 30seconds?
Or if you type !rank and go to your profile it takes ~10seconds to show the menu.

My database is about 100 MB big - is there a limit for the database ?
mySQL utilization (CPU) is sometimes high too. Is that the reason because big database?

QQbruv · 10-21-2015 , 01:17 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Quote:

Originally Posted by mazdarx8

Can someone tell me, if this normal when someone finish a map he see the points what he get after 30seconds?
Or if you type !rank and go to your profile it takes ~10seconds to show the menu.

My database is about 100 MB big - is there a limit for the database ?
mySQL utilization (CPU) is sometimes high too. Is that the reason because big database?

Sure sounds like an issue with the host or your MySQL server isn't optimized / not localhost.
Are you with a hosting company or VPS/Dedi?

Jakeey802 · 10-21-2015 , 01:29 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Make sure your database is in the location as the server

jonitaikaponi · 10-21-2015 , 01:52 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Quote:

Originally Posted by ThanoslBsl

Just asking, how ?

so... what do i need to put in my database.cfg ?

Thanks.

... really?

Switch driver to mysql, your host to your mysql's IP, database to the database that you want to use in your mysql, user and pass to your mysql user. If you use a custom port, uncomment port and add your port to it.

Dyseptor · 10-21-2015 , 03:23 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Can anyone help me with this problem? When a time is set on the server the replay bot spawns in as a bot that just walks around randomly. It says LOCALHOST Bot instead of the player name / time.

mazdarx8 · *Last edited by mazdarx8; 10-21-2015 at 03:29.*

Quote:

Originally Posted by QQbruv

Sure sounds like an issue with the host or your MySQL server isn't optimized / not localhost.
Are you with a hosting company or VPS/Dedi?

Hello, I use a linux system with:
Intel Xeon E5-2620
2GB Ram (I had 12GB ram, but same issue too!)

I have more servers with different IP-address, I cant do it with localhost.

Warr007 · 10-21-2015 , 06:50 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Quote:

Originally Posted by Warr007

Is there any way i can add points to a person?

QQbruv · 10-21-2015 , 09:40 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

Quote:

Originally Posted by Jakeey802

Make sure your database is in the location as the server

Not actually necessary. I never run the gameservers on the same server as my database. In this case I only have ~0.3ms to the database from the gameserver however, but I've run gameservers that hookup with a MySQL server with over 200MS, it was running completely fine. No lag.

Quote:

Originally Posted by mazdarx8

Hello, I use a linux system with:
Intel Xeon E5-2620
2GB Ram (I had 12GB ram, but same issue too!)

I have more servers with different IP-address, I cant do it with localhost.

Processor is good, ram is a bit weird for such a CPU, imo. Why so low? Are you running both gameservers and MySQL on the same one?
If you're running everything off of that one server, I would assume the database is swapping and spiking the cpu and hard drive causing lag.

mazdarx8 · 10-21-2015 , 11:23 Re: [CS:GO] ckSurf (1.17, 13.7.2015)

@QQbruv:

2GB because I reduce it (I had 12GB RAM), but with 12 GB RAM I had the same issues.
On this server only homepage and mysql running.

danielc9889 · 10-21-2015 , 11:38 Re: I need some help

Now, i am a little new to the server hosting and folders and stuff so i am asking someone if they could help me with my files and folders. Cheers