Very long mapchange

CSman03 · Post by **CSman03** » Mon Aug 20, 2007 4:56 am

Hi.

I am using MYSQL to save XP's and the mapchang is very long, it takes 10-15 minutes to do it. Are there too many data?Maybe i have to delete some?

http://tesco-wc3.sytes.net/

kp_downarrow · Post by **kp_downarrow** » Mon Aug 27, 2007 12:39 pm

its how mysql is

Post by **Geesu** » Wed Aug 29, 2007 10:27 pm

kp_downarrow wrote:its how mysql is

lol false - mysql isn't slow....

mannisch · Post by **mannisch** » Fri Aug 31, 2007 9:52 am

this thread belongs also to this:

viewtopic.php?t=2982

manni.

kp_downarrow · Post by **kp_downarrow** » Sun Sep 02, 2007 11:51 am

Geesu wrote:
kp_downarrow wrote:its how mysql is
lol false - mysql isn't slow....

oh yes it is, have u tried it?

Gunny · Post by **Gunny** » Tue Sep 04, 2007 9:14 am

kp_downarrow wrote:
Geesu wrote:
kp_downarrow wrote:its how mysql is
lol false - mysql isn't slow....
oh yes it is, have u tried it?

mysql, is not slow. The machine you are running it on must has some issues.

I run 5 CS server, 3 on the same machine as my mysql server and 2 that are not and you can't tell a difference between the servers.

kp_downarrow · Post by **kp_downarrow** » Wed Sep 05, 2007 10:56 pm

Gunny wrote:
kp_downarrow wrote:
Geesu wrote: lol false - mysql isn't slow....
oh yes it is, have u tried it?
mysql, is not slow. The machine you are running it on must has some issues.

I run 5 CS server, 3 on the same machine as my mysql server and 2 that are not and you can't tell a difference between the servers.

i tried it on 3 machines
and did you try it with 32 people joining at once?

mannisch · Post by **mannisch** » Thu Sep 06, 2007 9:56 am

Hi all,

also a thread about this has been startet at amxmodx.
Pls. Geesu can you take a look?

http://forums.alliedmods.net/showthread ... post527952

Maybe we can sit all together to narrow it down.

@kp_downarrow: what you mean with "slow"? Seconds, minutes?
As i have posted on amxmodx forum, Put and Get is working fine with WC3FT.
But something happens on mapchange; the server is very busy during this time.
AND: The database-Connection during this "time-out-phase" is off; It seems that something happens in WC3 AFTER the saving.

kp_downarrow · Post by **kp_downarrow** » Sun Sep 09, 2007 12:37 pm

mapchange is like 2 mins if you try to change with 20 players on mysql

kp_downarrow · Post by **kp_downarrow** » Sat Sep 15, 2007 10:39 am

well it happens to my friends too, which is on a completely different server provider

Daver · Post by **Daver** » Wed Oct 03, 2007 8:45 pm

I had problems with "Gameservers" the company with trying to run Warft from there server to my website which has my database (mysql) They could not help me get it to work so I moved to counter-Strike servers and it worked fine right away wit the same setup.... Sometimes its the host...

Daver