… is pretty simple approach I often use called to optimize web application performance if problem happens with few pages. If we have… which you can use. Just remember avoiding accessing database is the best way you can optimize database access. This applies to anything else – if… retrieved from the database matches information you display Way to often much more information is retrieved from the database than used to…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… 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… have Web application and just added some new feature, ie chat application which increases load on your web server but does not really affect database…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… working set (normally only fraction of your database) fits in memory. What is fast when …than you should target for web applications. So designing your application think what kind of application are you designing ? … the query and these rows are “random access” to large tables (so chances they would …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… some of applications, which tend to access same data read from database multiple times. Examining MySQL full query logs from many applications seeing several… can provide. Of course for your real queries cost of database access will normally be larger. Results I got from my envinronment… caches. use APC Cache for single node applications If you have just one web server or your data set is small so…
Post: Data mart or data warehouse?
July 15, 2010 By 13 Comments
… might be an ERP application, the logs from a web application, data from manufacturing systems…of gigabytes of information is accumulated. Accessing this data outside of summarized form…when it comes to designing database schemata for database warehouse applications. These two methodologies approach…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… are checked first time it is accessed. This option is however rather painful to use with web applications – users may issue different queries… bug (1%) Innodb recovery should be automatic and bring your database to consistent state. Depending on innodb_flush_lot_at_trx… – Binary log may become corrupted and out of sync with database content. This will sometimes break replication but if you’re…
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 … uncommon someone uploads a really badly designed application, which runs queries not using indexes or …
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… cover a lot of the basic usage patterns of databases in a web type environment, that InnoDB can actually be much faster… MyIsam was the fastest for read access especially in the very read heavy world of Web applications and that InnoDb was only used…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… query you never run.” Data access is expensive for your application. It often requires CPU, network and disk access, all of which can… you avoid performing work in the database. Eventually the cache contents expire. When this happens, the application attempts to get the cached… of log table, such as a log of clicks, a web access log, metric data from a monitoring system, or the like…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… switch 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… believe improving scalability is a continuous process for all major database brands. Q37: We have a fairly large Innodb table (150GB…
