…do not remember significant downtime, until today we went down for few hours. All this time the site was… what is the best way to deal with clueless support stuff working for big companies/big call centers ? Of…match my timing so I went ahead and returned web site back to old server which happily was …
Post: Traffic Tricks by Hosting Providers.
October 17, 2007 By 13 Comments
… the same network. Checking with 1and1 support of course was useless – “if you shut down the web server you do not have any… which was not enough at the times. Checking with 1and1 support again I was told I’m switched to 10Mbps because… tend to check things more carefully. For example 24/7 support may not be such or it could be a guy…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…not to mention understanding all ups and downs of database management system. This sounds nice… with transactions an some with clustering) with support of partitioning stored procedures views and a…flexible data structures, handle distributed semantics of web better and are expressive in a different …
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… However as your system growths the reliability goes down. If you have 100 servers with each …frequent failures you want to recovery (like getting spare Web server and putting it online) to be …means you often do not need most expensive support agreements and Business Hours Monday-Friday is good…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… noatime mount option for your static content partition. Some web servers also support for O_NOATIME file open flag on newer Linux… not fit in memory) you can have performance to go down as request will be frequently made to the main server… I already mentioned serving different content requires different skills from web servers or different configuration, so it is good idea to…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… resulting database load may not be directly related to the web traffic some customer has. The load can also be changing… of rows support for prepared statements which all currently fall under Other_commands a few MySQL performance counters broken down by users… regular users to see their own statistics only information_schema support to allow SELECT query transformations, joins and better filtering for…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…name. Probably the most popular BI activity for web sites is click analysis. As far as … a particular measure are compared or broken down into different dimensions. For example, in a sales…stored in separate dimension tables. Some ROLAP servers support the aggregation of data into additional tables, …
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… have not much improved (really going up and down) since MySQL 4.0. This even applies to… I’m obviously biased and focused more on Web applications rather than Enterprise applications (though these are… and solve things yourself or use third party support, which indeed works as MySQL is OpenSource and…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
…be an ERP application, the logs from a web application, data from manufacturing systems or even…. This is often described as the “top-down” approach. What is a data mart? The …is in large part because commercial database software supports hash joins, bitmap indexes, table partitioning, parallel query…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…than InnoDB in reads, as InnoDB is transactional, supports Foreign Key and has an operational overhead. As…typical structure you would see in OLTP or Web applications – medium size rows, auto increment primary …better than InnoDB by 10-30% MyISAM drops down with 128-256 threads READ_KEY_RANGE_LIMIT …
