High Performance Tips

[Xees]

is there any high performance Tips for Windows server 2008 ,

My Machine for Both Core And MySQL in same machine

Xeon

16 gig ram

100 mb symmetric internet

HDD SAS 500 GB

Bandwidth 50 GB

im getting new Machine with same specs for MySQL soon

so it becomes 1 machine for Core and 1 machine for MySQL

[Veretos]

is there any high performance Tips for Windows server 2008

Would like to see that too

[Derex]

Here is performance tip for windows 2008 -> Install Linux.

[Xees]

Why is Linux better then windows server

[Diablox]

Why is Linux better then windows server

Because the people who make Linux wants to make high-quality stable and secure OS for free, while MS just wants to earn money.

[Xees]

Linux is easier to hack then Windows Server 2008

[rilex]

If you have to hack it to get it to work properly and well, the devs have failed.

Because the people who make Linux wants to make high-quality stable and secure OS for free, while MS just wants to earn money.

Right, because if Microsoft released highly insecure, unstable platforms, they would:

1) Be the dominate server platform

2) Wouldn't have shareholders breathing down their backs

3) Be highly successful

Oh wait...They're all of those things! My bad.

:rolleyes:

By the way, you could run MaNGOS on Microsoft Hyper-V Server, which is also free.

[Curious]

Bump as some people may need thos information, maybe take in consideration a sticky ?

[kero99]

Update post to use ACE 5.7.8 in Core Server and new install XtraDB procedure in DB Server for Ubuntu 9.10, EXT4 system is really good for mysql performance

Best Regards

[ilija]

Hey,

Im getting trouble on installing XtraDb for ubuntu lucid, get next error always

libmysqlclient16: Depends: percona-server-common (>= 5.1.47-11.1-51.lucid) but it is not installable

Hope Someone knows the solution for this

[Wowka321]

Update post to use ACE 5.7.8 in Core Server and new install XtraDB procedure in DB Server for Ubuntu 9.10, EXT4 system is really good for mysql performance

Best Regards

SSD Intel X25E, right configuration MySQL -> best perfomance for DB. Server with 5GB characters DB startup in 12 sec. All players saved ingame without any lags. Must have ^^

[ilija]

And how to get the right configuration for mysql wowka321?

[Wowka321]

Hm, many configs posted here. Nothing principial. Just take standart config for huge sql-server (exist in sources MySQL) and play a bit with InnoDB settnigs (mostly buffer_size, i set 5G). IMHO, more important fast storage.

[ilija]

So no need to install xtraDB?

[Wowka321]

As you wish ^^

For me InnoDB more than enought.

[ilija]

Could you post your config?

[Wowka321]

Could you post your config?

N.p. ))

/tmp is additional SAS disk in this case.

/data is SSD Intel Extrime

http://paste2.org/p/905527

For server 64-Bit, 24Gb RAM, 8-core CPU.

[kero99]

Update XtraDB install procedure (working to update percona server too)

[kero99]

Hey,

Im getting trouble on installing XtraDb for ubuntu lucid, get next error always

libmysqlclient16: Depends: percona-server-common (>= 5.1.47-11.1-51.lucid) but it is not installable

Hope Someone knows the solution for this

Are you use lucid percona repo instead karmic?

[ilija]

Weird it is working now , should i change something in my.conf or it is all ready good configured?

[riddick]

Just out of interest - what's the memory usage of MySQL with 3000 online? Or characters db size is the only thing that affects ram usage?

[Voldemmort]

I got a question.

I'm going to get a SSD disk of 32 Gb.

The OS, the DB and the core files must be intalled in that same disk for a better performance? Or may I install the OS in a normal 500 Gb disk, and use the DB and Core Files in the SSD disk to have more space available?

[Diablox]

Only thing you need on your SSD is mysql data folder.

[Voldemmort]

TY Diablox for your answer ^^

Now I have other question, here is my current my.ini for MySQL

http://pastebin.com/r0snxKek

My system is an intel i7 920, 12 Gb ram, 1 primary 500 Gb HD (This have the OS and programs installed), secondary 500 Gb HD (This have gameserver files, backups of DB's, apache server with some scripts for the wow), and a third 32 Gb SSD Disk with only MySQL Data files.

I have tryed to configure it myself but I feel that it is still not properly working or configured on the right way, could someone please help me configuring the MySQL for an optimal work for example for 600~ Testers?? with scripts/proyects working like Armory and MiniManager?

[Diablox]

Let it run for a while. If it runs go with this. When mysql starts to act slow then go to your config and start changing. Only thing i can point out is innodb settings

innodb_buffer_pool_size=1G
innodb_additional_mem_pool_size=128M
innodb_log_file_size=128M
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1

But i think that DB for 600 testers online is a little bigger then 1gb.