…” 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 30 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…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… of stability in MySQL 4.0 But now get back to the question of using MySQL. I’m obviously biased and focused more on Web applications rather than Enterprise applications (though these are merging…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… look boring and obvious but it is extremely important for MySQL Performance Optimization. In fact I probably have to touch it… way more than you should target for web applications. So designing your application think what kind of application are you designing ? Can you make it… for majority of performance problems. Let me illustrate it on simple case. Assuming you have Web application which has some form of messaging between…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… with with console MySQL tools. Some people get best of both worlds by taking COMPRESS/UNCOMPRESS functions from the MySQL code and having them work on the application side as well which gives you best of both approaches. One… than reducing it. However it works great for many standard Web application needs – storing blog posts, product descriptions, forum posts (if they…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… nature of standard replication solution is causing problems with it. Lets first think about properties of simple components we fail over – web servers, application… down complete cluster. A lot of decisions which would be taken by HA system in case of MySQL Replication is handled by cluster…
Page: Consulting for MySQL
July 31, 2006 By
… – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL High Availability… – MySQL Security, MySQL Upgrades, Backup and recovery practices, fault tolerance and recovery. LAMP Performance Optimization In many cases web application performance issues lie outside of MySQL…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… the web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications now… though it is not exceptional to see it with number of people jumping from version 5.0 straight to 5.5… might be application changes which might not be practical for old applications. For the same reasons we often see old MySQL versions not…
Post: Fixing column encoding mess in MySQL
December 18, 2007 By 32 Comments
…. Most of the data was in proper cp1251 national encoding indeed. However, because of web application failure to properly set the encoding, some of the…. Simply using CONVERT(column USING xxx) did not work because MySQL treated the source data as if it was in cp1251… issues, I suppose. But, of course, ideally you’d always properly set the encoding in the Web application and avoid these issues at…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
MySQL is known for its stability but as any other application it has bugs so it may crash sometime. Also operation … accessed. This option is however rather painful to use with web applications – users may issue different queries which may trigger check/repair… use tiny script which moves out all MyISAM tables out of MySQL database directory, checks them with MyISAMchk and moves them back…
