[katie hunter]

Originally Posted by tpearl5

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 is adding a new table, which is less efficient (and requires a lot more join queries, which are expensive), and will be slower.

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.