Jump to content
MaxCheaters Official Group on Discord
--> Place your ad text here <--
  • 0

Mysql Optimization

GLO

Asked by GLO,

 Share

Question

GLO Explorer

GLO

Posted
Posted

As the tittle says, im looking for someone who know or can optimize the database to work better.

 

Who is free for that lemme know and i can give more details..

 

Thanks

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0
GLO Explorer

GLO

Posted
  • Author
Posted

Someone who know to optimize database , know what im talking about.

 

Every database need to be optimized for the server it runing for and also optimized for the machine spects.

Link to comment
Share on other sites
  • 0
Stewie Newbie

Stewie

Posted
Posted

Someone who know to optimize database , know what im talking about.

 

Every database need to be optimized for the server it runing for and also optimized for the machine spects.

 

While i'm online @ skype you do that post?

Oki doki.

O.o

Link to comment
Share on other sites
  • 0
Intrepid Newbie

Intrepid

Posted
Posted

Since we talk l2j heres what i would do...

 

Switch from c3p0 to BoneCP, look at these http://jolbox.com/index.html?page=http://jolbox.com/benchmarks.html

Use onboot table optimalization.

Proper configuration(lazy init, connection wrapper setup,caching).

 

And when thats done and you still need more, you can optimize the mysql server itself.

Link to comment
Share on other sites
  • 0
Tryskell Rising Star

Tryskell

Posted
Posted

Since we talk l2j heres what i would do...

 

Switch from c3p0 to BoneCP, look at these http://jolbox.com/index.html?page=http://jolbox.com/benchmarks.html

Use onboot table optimalization.

Proper configuration(lazy init, connection wrapper setup,caching).

 

And when thats done and you still need more, you can optimize the mysql server itself.

In fact a bad configuration of BoneCP can lead to a DISASTER in term of performances. There is notably one thread on BoneCP forums regarding someone getting really lame performance (-30%), and managed to discover it was because of poor properties. I can also name L2JFrozen adaptation which was a failure, as big as they decided to keep a switch between c3p0 and boneCP, defaulted to c3p0.

 

Finally, benchmarks are nothing more than numbers. You present a benchmark, ok, but what's the impact on a LIVE L2J server. No numbers before / after doesn't show anything. You could be surprised to don't see that benchmark performance boost on a LIVE server, or even, as I said higher, a DROP in term of performances if you tweak it bad.

 

Also, c3p0 made his proofs over years.

 

Anyway both my answer and your is kinda offtopic. The guy asks mySQL optimization tips, not change his db pooler.

Link to comment
Share on other sites
  • 0
Intrepid Newbie

Intrepid

Posted
Posted

In fact a bad configuration of BoneCP can lead to a DISASTER in term of performances. There is notably one thread on BoneCP forums regarding someone getting really lame performance (-30%), and managed to discover it was because of poor properties. I can also name L2JFrozen adaptation which was a failure, as big as they decided to keep a switch between c3p0 and boneCP, defaulted to c3p0.

 

Finally, benchmarks are nothing more than numbers. You present a benchmark, ok, but what's the impact on a LIVE L2J server. No numbers before / after doesn't show anything. You could be surprised to don't see that benchmark performance boost on a LIVE server, or even, as I said higher, a DROP in term of performances if you tweak it bad.

 

Also, c3p0 made his proofs over years.

 

Anyway both my answer and your is kinda offtopic. The guy asks mySQL optimization tips, not change his db pooler.

 

Bad configuration leads to disaster no matter what you use. I said these things because it has great impact and its pretty essential in my opinion.

Link to comment
Share on other sites
  • 0
Intrepid Newbie

Intrepid

Posted
Posted

So as i see, i better keep it as i have..Cuz it still runs ok.

I tought that someone can improve it simply :D

Thanks for answers anyway

 

well you can still read this http://dev.mysql.com/doc/refman/5.0/en/optimizing-the-server.html just in case

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing


  • Posts

    • Salty Mike
      A few ideas for MaxCheaters.com

      By Salty Mike · Posted

      While not particularly active over the years, I've been around for as long as I could remember, so here are my 2 cents too. On top of what has already been said, I'd like to touch on a few thing that might be improved upon. While it is easy to notice and say "there's lack of engagement" or "community has outgrown the ganre", I've seen numerous forums get forgotten and die while others continue to thrive to this day. The main issue, in my humble opinion, is that the sector has been commercialised to an unsustainable extent. When nobody is willing to share anything, even if it is just a rework of an open-sourced or already-shared resource, the sense of "community" gets deminished. Now back on the pressing matter. From what I've seen, the lack of engagement could be circumvented with a redesign and functionality expansion that would/could/should include: - a built-in chat functionality. - incentives for engagement/interaction, ideas of which I'll list as separate pointers, as not to limit your creativity. But just as an example, from a more user/human perspective, having an easily identifiable way to get into "the club of the cool kids on the block", figuratively speaking, is an incentive on its own. - separation of the reputation into reactions and reputation. One to be used to posts, such as up-vote and what not, while the other to be awarded as means of appreciation. - automated ranks with actual benefits/perks, not like the current ones providing nothing. - the ability to hide text for user/group of users, not just premium/no premium. - increased visibility of the HOT topics and the RECENTLY ACTIVE threads/posts. Can be also expanded to most liked posts, etc. ps.: I'll update my post when I have some free time on my hands.
    • Ave
      [Report] AVE Scamming

      By Ave · Posted

      There was no way I didn't refunded or delivered files. I don't see You on my conrtact list on Discord, can You send me a message or at least tell me for what project was this updater? I always resolve if I can't deliver on time or customer bailes.
    • Seamless
      Are Lineage 2 Players waiting for the next server listing?

      By Seamless · Posted

      @rlfem123  I’m a web developer, and I work with technologies like Next.js and React. In the last 10 years, L2 Rankzone is the only one I’ve seen that actually did something different. All the others seem to have the same source code with different templates. L2 Hopzone also did an upgrade and, for the front end, is using Vue.js. Regarding web development, we have reached a point where you can easily create websites using libraries or frameworks. Simply pick one and start working. You will learn as you go. Personally, I prefer to build my back-end APIs in Laravel if it’s a big project since the ecosystem offers everything. For smaller projects, I choose Go. Then I use either React or Next.js to call my APIs, depending on the case. Next.js also supports Server-Side Rendering (SSR) if you want to hide some things from the client. Additionally, CSS libraries have almost everything you need nowadays to start building quickly with browser compatibility. You can seriously build an L2 website with ranks, a good design, and even a simple login/register system in just 3 days. Here are some CSS libraries I personally work with: https://tailwindui.com/components   https://ui.shadcn.com/   https://mui.com/material-ui/ Regarding the top websites i dont thing its worth the time and effort.  Its pretty simple to build one and the market is already bloated. In addition l2 is dying so i suggest to build top sites for many games.  THe main problem is not the build process rather the marketing one. You can build the most awesome website iin terms of functionality but if you marketing is week you wont exceed 10 concurrent users. 
    • BabayG
      A few ideas for MaxCheaters.com

      By BabayG · Posted

      Good evening from me as well. I wouldn't recommend anyone, no matter how much love they have for the game, to try to revive it, not only because of the times but also because of the community (people who used to spend 15 hours grinding now qq for everything when they have auto-farm enabled 24/7... ) .  All the effort will be in vain. I have given all I had to this game. I have spent an incredible amount of time and over 20k the past 6 years, and the money can go to hell, but the time doesn't come back, I almost literally didn't get cancer... Also, very few people are worth collaborating with, all the rest are scammers and traitors. Unfortunately, only the projects that have been in the background for years do well.   P. S: "Once upon a time they used to be players now only complainers left" 
    • CTGavesT
      Agathions aCis 401, does not interfere with summons or pets

      By CTGavesT · Posted

      hello i use acis 401 In the video that you uploaded, the name is not visible, but it appeared to me I upload a screenshot so you can understand what I mean how can i fix it? https://prnt.sc/kTET9oxF4fos

  • Topics

×
×
  • Create New...