Paul, as long as you're not installing DB's plugin on a big forum and show us the result, than you can't backup what you just said.

I too can't ignore an expert server admin known among many companies and listen to you unless you show me proves.

How are you disputing Fillip's comment Paul, i think he knows more what his plugin does for big communities. He never refute it.

I'd be curious to see the output of mysqltuner...

Please do not put words in my mouth. Nothing in my comment goes against what Paul said, he and everyone else you have discussed this issue with is 100% correct.

If your server spends 6+ hours on those alters, then it would likely also spend 6 hours inserting 1.5 million rows in another table due to the serious misconfiguration on your server. That is all I said, and that is all I intended to say.

Any of the people who have argued with you on this issue could reconfigure your server to perform vastly better, that is a fact.


Fillip

vBSEO cause hostgator to shut down my vb forum. Never will use it this time around.

Ah hostgator... I remember leaving them for this very issue, there's quite a few other complaints from customers using vbseo on their forums as well.

I've moved on to flipperhost for a couple of years now and their vps plans are worth looking into.
http://flipperhost.com/

Fillip, I've quoted what you said on page 1, you said exactly this

All those who came in here saying I have a Mysql issues, haven't showed me a different result, they can install any of DB's plugins on a big vb community and share the result but they don't want to do it, so their statements holds no value other than seeing he say she say type of statements that gets no where.

I've installed 2 or 3 of DB's plugins in the past and i had to uninstall all of them and each time i had to wait that long to get rid of them or install them. None of the other plugins i installed did this and I've been with VB since 2006 and always tried different kind of plugins. You relay heavily on altering VB database which in my opinion is bad.. for big communities at least.

You didn't deny that your plugin could do that on page 1 or else you could have said something like i have clients who have big communities and they never run to similar issues similar to yours but what you said is this
Many people here wants to prove their point to be right, well you're not going to prove it unless you try it and share the result. So try it! those who claim i might have a mysql issue, try installing DB's plugin, any one on big communities and see how long it will take to import the xml product.

Try installing this plugin as a test on a popular vb community with millions of posts, threads and members and see how long it will take https://vborg.vbsupport.ru/showthread.php?t=242733 I tried fiew others and same issue i had, 6+ hours to import or uninstall.

Tried these as well (after that, i decided that i can't risk installing any of DB's plugins)
https://vborg.vbsupport.ru/showthread.php?t=236980
https://vborg.vbsupport.ru/showthread.php?t=287053
https://vborg.vbsupport.ru/showthread.php?t=298471

If you are daft enough to believe either of these statements than there is no hope for you. :erm:

Everyone else can see the issue, just not you. Feel free to stick your head in the sand and continue to suffer a badly configured server, not my issue so I really dont care. :cool:

No, I don't see any issue. I will be happy to send you my server admin company name and you can take that argument on http://www.webhostingtalk.com trying to prove that you know how to optimize Mysql more than he does, trust me, it won't be pretty =)

You really don't know what you're talking about unless you prove your point by showing the result, you don't want to do it, then don't try to prove anything. If you want to show your point, prove it.

This is the point that keeps being overlooked and there's your proof right there. Why don't you try another product that locks tables and see how long it takes, chances are it's going to take just as long. And in that case, there's your proof that it's not just DBTech's mods that are giving you issues but it's your very own server.

Yes that is what happen and the lock stays very short time, but like i said many changes after each lock happens.

You will just have to try installing DB's plugin on popular forum communities to find out.

These mods i have, it says it contain DB changes, i never see any locks or that it takes that long, mere seconds to install ( I can keep going with the list of mods i have installed = no issues )
https://vborg.vbsupport.ru/showthread.php?t=248042
https://vborg.vbsupport.ru/showthread.php?t=123415
https://vborg.vbsupport.ru/showthread.php?t=251408
https://vborg.vbsupport.ru/showthread.php?p=2325589

The issue with DB's plugin is that it affects and alter profiles, thousand of members. Few small alters is nothing compare to thousands and millions.