Right, and any modification that adds columns to a table is going to lock the table while those columns are added. As others have stated it shouldn't take that long even with that many users, especially with that much hardware. Something with your mysql configuration isn't optimal or needs to be adjusted.

Also, do you mean 2.5mhz? Intel E5 processors? Not that it matters, that's still a lot of processing power.

Anyway, I have a feeling this new vbSEO management has something to do Juan's sister: http://admin-talk.com/threads/dear-v...rations.43684/

--------------- Added [DATE]1400638628[/DATE] at [TIME]1400638628[/TIME] ---------------

Umm.. how is what happened not treating their members badly? The family dispute had nothing to do with the product continuing to be sold with no support, and then the site just closing without notice. People were being strung along for an update for months. Sales were in decline, Juan jumped ship with customers still on board.

No, a 3.5 GHZ, we don't use a 2.5 GHZ.

It has nothing to do with mysql, I've said that before and i pmed Zachery who my server admin and his company is. He would know right away his reputation on WHT, so no dispute into that. You can't teach experts their job that they know inside and out.

I mean i can listen to an advise but i know what i was being told. Also DB's plugins are the only plugins that does this, i have many installed plugins and they get installed right away, why ? because they don't heavily alter many vb tables and that is a fact. If I had a small community, yes DB plugin will be installed right away.

As for Vbseo, Juan might have made mistakes but the blame comes from his sister as well and heavily but i don't want to even talk about this family dispute, the good news is that somehow things might turn out better for vbseo, will just have to see.

I wouldn't trust vbseo with any site I ever ran, ever. I am personally tired of still cleaning up after their messes for the last few years.

Table alters have to lock the table, thats pretty obvious I would have thought.

If your mysql server is taking 6 hours to alter a 1.5 million records User table, then its badly broken.

Paul, no. You can pm Zachery for my server admin company if you like and see his reputation on WHT, I don't think you will argue your point with an expert. Or may be the misunderstanding is coming from me? There was a lot of changes, tables gets locked to safely finish the changes and thousands of changes does take time. I've seen it in the logs.

People just keep saying stuff that they have no first hand knowledge of.

Like I said try any of DB's plugin on with big sites that have million of threads, posts, and registered members and see how fast your will finish important the xml. You can share the result later if you like.

So I'm assuming you have a two processor machine with 6 cores each, right (you said 12 cores)? The fastest 6 core processor that Intel makes is the E7-8893 v2 at 3.4GHz - it's brand new, very expensive, and not a lot of hosts are using it if at all. Am I missing something? Regardless, it doesn't matter, but this is telling me that you don't know what you have.

I'm sorry, I'm not here to debate someone's credentials at all, but your issue absolutely is a mySQL issue. I'm not an expert by any means, but I know a mysql bottleneck when I see it. It's possible that your guy hasn't allocated any resources to actually adding data to tables.

DB Tech is definitely not the only one that modifies tables. The alternative modifying a table (if it needs to be done) is adding a new table, which is less efficient (and requires a lot more join queries, which are expensive), and will be slower. You're kind of saying that all plugins are created equal though and that's definitely not the case. Some do not need to store data (which will naturally install more quickly) while others do.

Source? Hopefully that's the case, but I wouldn't count on it. Especially with DB tech providing a viable replacement.

Intel e5 1650v2 (Six real / 12HT cores @ 3.5ghz)
32gb ram
128gb Samsung 840 Pro SSD
600gb 15k rpm sas hdd

I know what i bought.

The reason I never share my server admin company name in this thread because of all these wrong statement flying left and right and b/c the moment i do and see you guys still arguing, i am sure a lot of WHT vets and customers will come right in disputing these because we're talking about an expert server admin with extensive knowledge in the security and server field, especially linux and has a high reputation. WHT server companies like Softlayer, Webnx and so on comes to him for big issues.

Ah I forgot about that one. I stand corrected.

That's great for him, but that doesn't mean squat when we see alter queries taking 1+ hours on fairly small tables.

I've done alters on the vBulletin (5) node table on my TINY dual core atom with 3+ million node tables in under an hour. Same goes for post/thread/users.


I pestered digitalpoint on twitter, his user table alters are mostly "quick", and he has about half as many tables as you do.

Further, being on an SSD, if the DB is actually being hosted on the SSD, 6+ hours for a million rows is just batshit insane. SOMETHING is wrong with your configuration.

Quite frankly you seem clueless on this, so let me spell it out for you again.

No mysql server, ever, should take 6 hours to run a table alter on a 1.5 million row table. Any that does is very badly broken or configured, and any "expert" who tells you otherwise is either lying through their teeth or has no idea what they are doing, and yes, I will very much argue the point.

I can run an alter on a 2.2 million row node table (Innodb as well, which takes longer) in about 30 minutes on my home PC, let alone a dedicated server (I did so yesterday, twice).

I have no intention of ever installing dbtech plugins on any site, for totally unrelated reasons.