I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program … not interrupted until the transaction is finished/committed? A example of a program is worth a 1000 instructions. Please do this…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… many web properties – too complex and too expensive to start with. In second half of 90s when MySQL appeared on the market many web applications were simple and often not using database at all. MySQL did not… web applications have to handle much higher load and much larger data sets, they are also much more complicated and performance of MySQL is…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… to reconfigure the web/application servers but that raises a first challenge, how to locate them. The listing of the web/applications servers if easily…/bin/update_mysql ubuntu@$IP sudo ./update_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE There are many ways to configure web/application servers…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… were, it wouldn’t be a great OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s…. And because MySQL is a multi-threaded database for Web usage that tends to be used in sharded environments with tons of application servers, which creates a situation with many thousands of…
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 have… links WHERE domain = ‘mysql.com’; will return only one row while may require to scan hundreds of thousands of rows (or index entries… number of columns) – this is not a good practice. However if you can reduce number of queries without a lot of complications to application…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… benefits and drawbacks for each of methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In… say you have Web application and just added some new feature, ie chat application which increases load on your web server but does not… to think about sharing MySQL and Web server at all ? Well mostly it is for cheap guys. In many applications you will find…
Post: How Web Services world affect LAMP Stack
May 22, 2006 By 1 Comment
… using them. There are also number of changes on the client application, which is frequently yet another web application: More workers required. In my… – in files or MySQL tables. There are multiple solutions available out where. In addition to improving speed of your application caching couple be…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… with different consistence guaranty and semantics… and believe me most of Web applications could live with it. They anyway read stale data from… MySQL 5.1 and Most of other items are still open. Well may be this is remainder of wild first VC-backed years of MySQL and not things are getting straightened up. I know on a lot of listed…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…” typical application would have number of low hanging fruits which are easy to fix – adding couple of proper indexes or tuning couple of MySQL settings. When low hanging fruits are fixed you end up with either fine tuning which gives little improvement or more application… the same time one would likely get couple of boxes to spread Web and Database instances and establish may be establish replication…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… if frequently with web applications and it is often indication of trouble. Not only it means you may run out of MySQL connections quicker than you expected but it also frequently indicates serious problems in the application. If you do… only helpful to debug sleeping connections with MySQL but many other cases when you see web application locking up or starting to runs…
