… MySQL and Web Servers is rather good practice. It is more secure – Compromising your web server does not directly give access to your database, even though most applications have enough database access permissions to be allow…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
… is pretty simple approach I often use called to optimize web application performance if problem happens with few pages. If we… which you can use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything else – if you can avoid dynamic page generation at all and have server cache to…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… immediately and you avoid performing work in the database. Eventually the cache contents expire. When this happens, …do so. This avoids the CPU usage on your web server to create the block from the rows again … table, such as a log of clicks, a web access log, metric data from a monitoring system, or…
Post: APC or Memcached
September 27, 2006 By 21 Comments
… hit rate by caching things locally if you have many web servers. MemcacheD is relatively slow but distributed and so you do… as you need only one access to bring item into the cache, not access for each of web servers. The good thing however is… memory). Sometimes I add third level of caching – disk based (database or file based) to cache large size or persistent objects…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… helpful for some of applications, which tend to access same data read from database multiple times. Examining MySQL full query logs from… can provide. Of course for your real queries cost of database access will normally be larger. Results I got from my envinronment… have just one web server or your data set is small so it fits in memory in each of the servers APC Cache…
Comment: Death match! EBS versus SSD price, performance, and QoS
February 26, 2011 By 54 Comments
… the ephermeral drives] is reversed as suddenly you have exclusive access to those drives. 2) Scale the system in different ways… database of almost all static, rarely changing data. Why store it on a master database server? Stick all that data down on the web servers. Use SNS to push important changes in 2 key pieces of information quickly to those servers[price and...
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…-user and per-table accounting to the database, accessible with a new set of commands such …Therefore often the resulting database load may not be directly related to the web traffic some customer has… they should consider upgrading to a dedicated server because their usage is very high temporarily …
Post: Pitfall of proxying HTTP requests through Lighttpd
November 22, 2007 By 12 Comments
…of the system worked perfectly fine (e.g. databases, storage), no one started any backup in the…bit. As I already mentioned it was about web servers. Each of them was running Lighttpd that handled…from the backend server before sending to the client. And indeed I started browsing Apache access log and…
Comment: Should MySQL and Web Server share the same box ?
December 24, 2011 By 9 Comments
I feel that Web Server and Database Server should be hosted on separate Servers. When both are hosted on the same Server, it is causing a lot of delay in accessing the database and data updation.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to Oracle’s main database, I believe different applications work best on different database brands. Oracle’s main database has a very competent… access is so common in files. The wear leveling is used for flash memories. I looked up some information on the web…. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HTâ…
