Jake Bunce
Well-known member
An upgrade is not going to enforce table types. But if new tables are created during an upgrade then you may wish to change their types afterwards.
Donations for Shawns coffee pot...
- Thread starter Slavik
- Start date
An upgrade is not going to enforce table types. But if new tables are created during an upgrade then you may wish to change their types afterwards.
digitalpoint
Well-known member
But honestly, InnoDB is good... unless you are having problems with it currently, why muck with it?
Gladius
Well-known member
Heh, I just checked and all our tables are MyISAM as well. Which makes sense since I had InnoDB disabled pretty much everywhere in the past (good reasons for it with vB too). I don't right now though, but still using MyISAM as the default engine. Good question though, does upgrading attempt to change them to InnoDB if support for it is enabled? I would assume not but would be good to know. too late, heh
Honestly, I don't know if it's worth switching to InnoDB as long as things are running smoothly with MyISAM.
Honestly, I don't know if it's worth switching to InnoDB as long as things are running smoothly with MyISAM.
SneakyDave
Well-known member
On one of my xF installs, I can't adjust the InnoDB buffer pool space (no root access) so the InnoDB performance is crap. I might see if changing them to MyISAM helps. Probably not a very big database to notice anyway, but nice to know it might work.
intradox
Well-known member
How does one go about registering on your site? Wanted to take a look around on the user end but it said registrations are closed.
digitalpoint
Well-known member
Are you on a proxy IP or anything? That's the message you will get if you are on an IP used by a spammer recently.
digitalpoint
Well-known member
No... the servers are the same old hardware I've had for almost 7 years now. I'm planning on getting new monster hardware in the next month or so.
CTXMedia
Well-known member
"monster" sounds impressive - be sure to post the spec for the rest of us kit junkies to drool over!
Do you run anything else on the servers other than your Digitalpoint sites and services?
digitalpoint
Well-known member
The plan is for 3 of these chassis: http://www.supermicro.com/products/system/2U/2027/SYS-2027TR-H71RF_.cfm
With each server node having: E5-2690 (8 core) x2, 256GB RAM, 900GB Seagate enterprise drives (Savvio) x 6, InfiniBand interconnect (56Gbit)
So a total of 12 servers in 6U of space.
We only use servers for digitalpoint.com... There are a lot of backend things going on... Serving up Geovisitors tool, serving ads on sites using Digital Point Ads, search engine rank checking for millions of keywords from our Keyword Tracker tool, etc.
With each server node having: E5-2690 (8 core) x2, 256GB RAM, 900GB Seagate enterprise drives (Savvio) x 6, InfiniBand interconnect (56Gbit)
So a total of 12 servers in 6U of space.
We only use servers for digitalpoint.com... There are a lot of backend things going on... Serving up Geovisitors tool, serving ads on sites using Digital Point Ads, search engine rank checking for millions of keywords from our Keyword Tracker tool, etc.
Jake Bunce
Well-known member
Get some solid state. These new Intels are sexy:
http://www.computerworld.com/s/arti...hird_gen_data_center_SSD_slashes_price_by_40_
http://www.storagereview.com/intel_ssd_dc_s3700_series_enterprise_ssd_review
http://www.intel.com/content/www/us/en/solid-state-drives/solid-state-drives-dc-s3700-series.html
High and consistent performance under load, insane write life. Made for server apps.
edit - and they just recently became available to buy
http://www.computerworld.com/s/arti...hird_gen_data_center_SSD_slashes_price_by_40_
http://www.storagereview.com/intel_ssd_dc_s3700_series_enterprise_ssd_review
http://www.intel.com/content/www/us/en/solid-state-drives/solid-state-drives-dc-s3700-series.html
High and consistent performance under load, insane write life. Made for server apps.
edit - and they just recently became available to buy
digitalpoint
Well-known member
Yeah, and 72 of them (which is how many I would need) would be more than twice the cost of every other component of the servers.
The read/write speed isn't that much different... the drives I'm looking at are over 200MB/sec already, a 2,000,000 hour mean time between failure and FAR less expensive. Plus, we don't do much non-sequential reads/writes, so the high IOPS is not needed. Just not worth the money for what I'm doing. DB servers and everything else have enough memory that everything is memory resident anyway... just logs being written out basically for writes for the most part.
See above.
Adam Howard
Well-known member
Is that all? LOL (joking)
Looks like you're placed a lot of time and effort into things. Keep up the good work.
digitalpoint
Well-known member
The number of concurrent HTTP requests being served probably paints the best picture...
Obviously we aren't doing 1,000+ page views per second for the normal site.
But I run across my stuff being used everywhere randomly on other sites. For example I needed a jQuery lightbox plug-in for something earlier today... low and behold. It has our ugly Geo Visitors button on it, which our servers are serving for every page view of that site... along with about a billion, trillion other pages it's on around the Internet... (haha, well not really that many... but you get the idea).
http://leandrovieira.com/projects/jquery/lightbox/
Click on the button and you go to our site and it shows you everywhere in the world where visitors were that visited that page in the last 24 hours. It's not even that neat of a tool, but it was neat when I created it like 7 or 8 years ago... haha
Obviously we aren't doing 1,000+ page views per second for the normal site.
But I run across my stuff being used everywhere randomly on other sites. For example I needed a jQuery lightbox plug-in for something earlier today... low and behold. It has our ugly Geo Visitors button on it, which our servers are serving for every page view of that site... along with about a billion, trillion other pages it's on around the Internet... (haha, well not really that many... but you get the idea).
http://leandrovieira.com/projects/jquery/lightbox/
Click on the button and you go to our site and it shows you everywhere in the world where visitors were that visited that page in the last 24 hours. It's not even that neat of a tool, but it was neat when I created it like 7 or 8 years ago... haha
intradox
Well-known member
I was using my university's connection but waited until I came home and got the same message. I must have really bad internet ips.
