ax_peq db converted to innoDB

[Angelox]

I went ahead and converted the ax_peq DB as per suggestion of WidcardX. I've been testing it all week, and it seems much. much faster than with the old MyISAM method.
This is not recommended for anyone with anything under MySql 5x. I hope who ever trys this out, will post results.

[number6]

I converted my server (The Village) over to your new DB yesterday, and so far everything is working fine. Then again I never have that many people on it - the peak was yesterday evening with 5

I haven't forgotten about fixing up the tome handins in PoK by the way Angelo, I am just very busy at the moment!

Paul.

[cavedude]

Smaller servers won't notice a difference at all, and for several reasons you may even want to stick with MyISAM.

Larger servers, however MUST convert to InnoDB.

Also, if you wish to use InnoDB, please make sure you have the engine installed and enabled. Otherwise, you'll just be using MyISAM.

[Angelox]

I beg to differ
Beginning with MySQL 4.0, InnoDB engine is enabled by default (unless you disable it, it's there, waiting). MySql 5x has general InnoDB default settings which usually suit most users.
Although InnoDB is more effective with larger volumes of users - it does provide benefits for everyone.

Edit;
for anyone who wants to convert what they have, here's a good tutorial
http://www.tutorialized.com/tutorial...o-InnoDB/15557

[cavedude]

InnoDB uses 2 to 8 times the storage space, memory, and has increased CPU usage over MyISAM regardless of configuration. This is a fact that nobody can argue, and in my mind would be bad for small servers or especially those who wish to run minilogin and the client on the same machine.

And the reason I mentioned the second part is because I recently installed Gentoo on a test machine and the version of MySQL 5 it grabbed did not have the InnoDB engine with it, I had to dig up another package.

[wize_one]

in your make.conf file in the USE section if you have innodb there mysql builds with it

[Angelox]

Not that I want to have the last word here , put I'll finalize by saying "you'll never know tell you try". I tried it on my little hole-in-the-wall operation here, noticed improvement, didn't see any problems after a few days ( still running) , so I decided to post what I had for download, mostly so people can try it out and see if anything is different - for better or for worse. This way, if there is any problems, we can always revert, but we'll know better.
With todays CPU's and hard disks, a few more megs of space is nothing. and I really haven't noticed any problems with CPU usage.