… couple few questions on how to tackle application performance. These questions are: Should we Optimize Application or get more Hardware ? Should we… problems, and even though I just spoke about scaling and performance optimization it goes far beyond this. Hiring us is of course… variety of companies on he market offering services around MySQL and LAMP and MySQL is one of them. Plus for large companies…
Page: Consulting for MySQL
July 31, 2006 By
…: MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL… – 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: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… often the cause of MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid these problems… we stick to simple MySQL using multiple indexes on most selective columns would be good idea for performance of such queries. For… JOIN MySQL still will not be able to use it as Optimizer is not smart enough yet to detect such cases: mysql> explain…
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
… queue, message parsing, search systems etc being important components besides MySQL. MySQL is important component but just a component, though due to… from the client prospective where our new service – front end performance optimization comes to play. We look to reduce number of requests…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 14 Comments
… and workaround this limitation, though it of course comes with performance penalty. This approach is however still faster than running 2… inside MySQL. Why am I looking on reporting performance optimization ? It is for ClickAider project which is growing rapidly and use of MySQL for… lot of other black magic to keep things as optimal as possible though performance is still far from our goal of real…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
Performance optimization is never ending story, you can virtually always find something else to optimize but while on generic system, not tuned by… set up. For smaller systems lets say running couple of MySQL servers running another couple can be cheaper than serious application… minor face lifting such as MySQL Server settings tuning, changing indexes and queries is enough to deliver performance required in cost efficient…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to … better performance. Lets see if it is really best strategy: To check things out I’ve created table with simple structure: mysql… query to perform full table scans, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select…
Post: Using UNION to implement loose index scan in MySQL
August 10, 2006 By 15 Comments
One little known fact about MySQL Indexing, however very important for successfull MySQL Performance Optimization is understanding when exactly MySQL is going to use index… query looks much more complicated MySQL is able to execute it much faster, delivering us expected performance. You can also use this…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
MySQL has a great feature called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query Cache…
