The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#21
|
||||
|
||||
Quote:
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. |
2 благодарности(ей) от: | ||
CAG CheechDogg, kylek |
#22
|
||||
|
||||
Quote:
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. |
#24
|
||||
|
||||
Quote:
If your mysql server is taking 6 hours to alter a 1.5 million records User table, then its badly broken. |
#25
|
||||
|
||||
Quote:
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. |
#26
|
||||
|
||||
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.
Quote:
Quote:
Source? Hopefully that's the case, but I wouldn't count on it. Especially with DB tech providing a viable replacement. |
#27
|
||||
|
||||
Quote:
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. |
#28
|
||||
|
||||
Ah I forgot about that one. I stand corrected.
|
#29
|
||||
|
||||
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. |
#30
|
||||
|
||||
Quote:
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. |
Благодарность от: | ||
RichieBoy67 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|