…: 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 High Availability design and implementation Design of High Availability architecture which matches your…
Post: Time for Zero Administration effort at MySQL ?
January 8, 2012 By 4 Comments
Preparing Optimizing MySQL Configuration talk for Percona Live in Washington,DC I noticed how many Variables did MySQL get over years – it is pushing… rather than command line options (like much of Performance Schema configuration). Innodb settings alone push 100. True you do not need… with surely a lot of architecture changes to make it right. Yet I believe this is something MySQL surely needs at this…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly…bring big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures,…. If we see that the application’s overall architecture needs to be changed, that’s something to …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…lets talk about optimizing application vs getting better hardware. With application optimization typically you have… it comes even more serious application architecture changes such as sharding which unlike… past certain hardware configuration – some of these issues may be MySQL related and others …
Post: Announce: Front End Performance Optimization
October 10, 2008 By 8 Comments
…MySQL driven web site its properties will likely depend on a lot of factors – good web side configuration… Then it comes to efficient web application architecture and code – being scalable, efficient, highly available… our new service – front end performance optimization comes to play. We look to …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor …-0) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== ==== … not different MySQL configurations, I didn’t try out different MySQL versions or settings…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… more in terms of performance due to architecture optimizations. The other big issue is using MySQL 5.0.27 which has Innodb scalability… least 800 JOPS on updated software and hardware configuration, so I would argue MySQL is Slower. On the other hand It does… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
…’s new with the MySQL query cache? You may know that it still has the same fundamental architecture that it’s always… our forum to the fact that the query cache was configured far too large. This might have taken a lot longer… to InnoDB Architecture and Performance Optimization. These detailed presentations will give you the hands-on experience you need to take your MySQL understanding…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… truly optimal for…MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation systems, RAID Configuration…MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation will talk about architecture…
Page: Presentations
May 3, 2006 By
…MySQL Performance Optimization Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007 Short presentation about MySQL Performance Optimization. Slides are in Russian. Download Distributed Architecture…
