dpbBryan

Yes I did, I told him to check his query log. Infact it's the second post here. When MySQL executes a really long query it begins to write what it's doing inside a log file so you can understand what's wrong with your query.

Best: 0,031 seconds Worst; 0,140 seconds 900 fresh uncached inserts, finished in rougly +/- 30 seconds to 126 (2 min) seconds (900 entries * ~0,031 seconds [0,14]): 3600 fresh uncached inserts, finished in roughly +/- 111 seconds to 504 (8,4 min) seconds (3600 entries * ~0,031 seconds [0,14]): By my estimations on my dual core AMD from 20 years ago 500 players should be done in about +/- 15,5 to 70 seconds. That seems a lot less than 18.000 doesn't it?

It's called caching. For example when you do a SELECT from your database that entry that you just searched for is placed into your RAM so that if you search for the entry a second time it will be found quicker. And yes, as you saw in that link's example that I posted each time his selection query speed improved. However this doesn't apply here. Do you remember the first time you installed your Lineage 2 database? There are a lot of rows there but it doesn't take 5 hours to install the entire thing. It's also never taken me more than a few moments to reinstall an SQL backup and I mostly develop from home on my own computers, which aren't fancy either. He doesn't need a super computer, people have been installing mysql on computers with 64MB and even 128MB ram. It's all dependent on the complexity of your data. If you're not an expert on these things fine but don't give somebody such a sad excuse for an answer. You should be giving advice to users to consider all possibilities of things other than "just accept your issue." You don't learn things by just accepting whats put infront of you, you learn things by seeing mistakes you've made or poking around the details of technical things. Also since this forum's underlying premise is pretty much software development and programming.

You're post doesn't even make sense. This guy is using linux which makes me believe he probably either had to build the binaries himself or grabbed pre-built binaries from the repositories. In that case, a portion of his configuration had to be done by him and not an automatic launcher. Theres potentionally something here he could have gotten wrong. Theres no way he should ever accept the answer 'wait'. Unless this guy had about 20 billion players the relationships between these tables are far from complex, and are simply meant to store persistent data when not in use by the gameserver. There is absolutely no reason what so ever a backup installation should take 5 hours. I work with ERP systems which have millions upon millions of entries regarding different business stuff. The most I've seen one of these take is about 8 hours (given that it's a dedicated database server, but still).

No your advice is retarded and misguiding. http://stackoverflow.com/questions/12152012/why-how-do-my-sql-queries-get-faster-with-use 1.300.000 entries based on a WHERE condition making the query more complicated. Time: 3 seconds cached to 5 minutes uncached. Sure seems like hell of a lot less than 300 minutes in comparison. GameBlonD don't accept this guys answer. There could potentionally be something wrong with your mysql instance setup or configuration. If you follow this guys advice you could be running a faulty installation without knowing. Get to the real issues of problems, don't half ass it.

I'm not trying to be a prick but is it your job to shitpost useless advice to get your post count up or something? What kinda -beep-ing dumb advice is that. You shouldn't ever have a query that takes 5 hours to finish, especially if it's just inserting data based on their key values back into the database. If you're having performance problems refer to the logs inside your mysql directory. A query log is generated by default I think of SQL queries that take longer than 15 minutes to execute so you can see for example what its trying to do.

Are you serious? Nowhere in his post did you say he was special nor did he specify what he actually wanted, it's a simple "I'm looking for a developer" thread.

Perhaps you should check your query logs to see whats going on.

The packets of information being sent from your client are not compatible with the information the server expects.

Have you enabled debugging in the gameserver configuration files? What does the gameserver console say?

"Why do you think I spent time to read all your post..." Now you want me to believe you're a compontent developer when you stormed in here, called my idea bullshit, and then when I defend it you say "yea whatever." Good way to illustrate to everybody you really know what you're doing. 1) The only things that should have a direct connection to the l2j database on a production server is the gameserver and database administrators with only the permissions they need using SSL. THE DATABASE IS ESSENTIALLY YOUR GAMESERVER, IT IS THE DATA THAT DESCRIBES IT AND MOST OF IT'S BEHAVIOR. 2) It's not significant but you shouldn't be putting anymore strain on the gameserver processes than need already be. Java already has standard objects for doing things like HTTP GET/POST requests. It'd be less strain on your SQL server and you'd be using less connections by sending an HTTP post request to your webserver and uploading a json object containing the live gameserver data which can be updated in different intervals of your chosing rather than the standard L2j database updates. You'd have to build the json object via the gameserver but once the request is sent the gameserver database or application itself won't have to worry about it.

That's what I said with option number 1. Just replace the web provider with him. Also, option 2 not allowing remote access to your database: http://www.greensql.com/articles/mysql-security-best-practices

Explain please.

Ask the people over in client modding, you have to modify the client.

The client probably doesn't have animations for certain enemy skills. For example Antharas tail attack or something, player models don't have these animations because they don't use a dragon skeleton. You probably have to adjust somewhere in the client .dat files the animation the skill uses.

http://kb.realvnc.com/questions/20/I%27m+receiving+the+error+%22Connection+Timed+Out%22+%2810060%29 "Connection timed out" indicates that no response was received from the specified IP address, even to reject the connection. 1) the ip/url is wrong 2) something within the network has been reconfigured theres are pretty much your first two obvious choices to look. How is that event a relevant question to network connection issues? Sorry bro, that ip only works with Freya. T_T

>Sells somebody a service >No idea how to run it Are you kidding me? Connection Timed Out: Connect. Use google ffs.

Try 'true' instead of 'True'. I don't know if it's case-sensitive.

2 Options 1) As your web provider or server hoster (or if you have root access) to allow remote access to your database (Not recommended) 2) Create a script on the same server as the SQL database that will listen for HTTP requests. With the script read the database for the relevant information and return it to the person calling the script via json/xml. (recommended). Option 2 will ensure read only access to your database as well from outside sources.

I'm pretty sure that's implied knowledge since it's L2java. Also, how about some more details about your project? I'm assuming it has to do with your signature.

I one time created it so that you can use any of the soulshots with any weapon disregardless of grade. It's been a few years since I last did this but I remember in maybe one of the action methods of the player it'll check your "active" soulshots/spiritshots and see if any of them are equal to your weapons grade. I just removed the weapon grade check and had it use any of the active soul shots randomly with each hit. 1) Yea because that's efficent >_> 2) The visual effect is client side, which type is determined by the server.

I always use l2acis, but: and then . If you're going to be developing custom things then I'd be less worried about things that are already implemented and instead understand how 1 pack does it and how you're going to adjust it to fit efficently with your planned features.

This is a client mod question. It doesn't belong here. http://maxcheaters.com/forum/index.php?board=61.0

A seperate server in whatever regard would work better than it being on your website server. I'm assuming you're also talking about a live server, why would you want to have them on the same server anyway other than the obvious ease of use? (Ease of use <> best option)

That's because you need to first understand how persistant data is handled on your database versus your gameserver. Gameserver data from the database is only updated during certain times: when a player disconnects for example. You won't get active data from your database. You'll have to either update the database on player death (I wouldn't recommend this) or perhaps come up with another solution. Maybe you could have instead have a json file which is written when certain things happen to the player (for example, on his death updating the file) and have the webserver read information from this file.