Hello Community i have a big problem with the the Beta 3.0 map. If anyone push the paved tiles button my mysql server craches after a while
the cpu load goes up to 99% normally are 0,1% any solutions ? all other functions are fine "Guildmanagement Trading"
CPU LOAD if pushed the button https://prnt.sc/ql0ytd
CPU LOAD normal https://prnt.sc/ql0uf6
Best regards from Hannover Germany
Re: MYSQL Error by pushing paved tiles
2Hi,
high database load during rendering of all paved tiles for the first time is normal (to a certain extent). But it shouldn't take more than 2 minutes, at most. How do you determine that your database crashes? Cause that's just very unlikely and would indicate configuration problems on the host server.
Also please supply the information asked here. Thanks.-
high database load during rendering of all paved tiles for the first time is normal (to a certain extent). But it shouldn't take more than 2 minutes, at most. How do you determine that your database crashes? Cause that's just very unlikely and would indicate configuration problems on the host server.
Also please supply the information asked here. Thanks.-
Re: MYSQL Error by pushing paved tiles
3this is not normal so I have to kill mysql at some point because your server does not stop bombing mine with requests and I work enough with databases on Linux Windows etc and i am MCSA and Linux lvl 1 and 2 and now ? that is like a SQL injection
Re: MYSQL Error by pushing paved tiles
4Hi,
I'm not sure what you are talking about exactly. I'm glad to help eleminate problems with the Livemap but there is little I can do if you`re not supplying the information needed to look into your issue.
Apart from the ones i already asked for, these things would be helpful:
- what's the total database size shown in the Server Manager or HeidiSQL
- do you see a table called `nyu_terrain_cache` ? Does it have content or is it empty?
The Livemap is open source, so if you are experienced with SQL and this kind of stuff, you can review the codebase and/or run the relevant SQL queries on your database manually to see which one is causing trouble. Loading routines for paved tiles are located here and here.
I'm not sure what you are talking about exactly. I'm glad to help eleminate problems with the Livemap but there is little I can do if you`re not supplying the information needed to look into your issue.
Apart from the ones i already asked for, these things would be helpful:
- what's the total database size shown in the Server Manager or HeidiSQL
- do you see a table called `nyu_terrain_cache` ? Does it have content or is it empty?
The Livemap is open source, so if you are experienced with SQL and this kind of stuff, you can review the codebase and/or run the relevant SQL queries on your database manually to see which one is causing trouble. Loading routines for paved tiles are located here and here.
