… performance issue. Still MYSQL load was very high but site was not going down. Then we did some R&D on Percona MYSQL… file, site performance was good. But from second day again performance degradation started and now it is slow again. MySQL load is not… Server Details (Dedicated Server): Software: Apache Version – 2.2.15 (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… follow. A full performance audit is far more extensive than this article can cover, and might wander into Apache, networking config, caching… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… if people do not really run MySQL with high concurrency does it really matter how MySQL performs with high concurrency or is it just marketing gimmicks to promote new software versions ? Performance at High Concurrency… each having Apache configured to run up to 100 apache children concurrently each of which might open a connection to MySQL server… this…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack… and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not get where quite yet having very particular performance…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…-performance systems to do this work. Let’s see some ways you can build the functionality you need and get the performance…, pre-aggregate. Suppose your data is coming from some Apache log or similar source. Write a script to rip…, like star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload. The…
Comment: Should MySQL and Web Server share the same box ?
July 11, 2007 By 9 Comments
[...] MySQL Performance Blog » Should MySQL and Web Server share the same box ? Should MySQL and Web Server share the same box ? (tags: mysql apache server performance scaling web architecture php) [...]
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… Server and MySQL 5.5, there are still workloads in which case mutex (or rw-lock) contention is a performance limiting factor… loops is something i would consider last resort tuning, the performance improvements it provides is typically rather limited and can be… or newer MySQL version or doing application/architecture changes. Reducing number of competing threads (such as limiting number of Apache Children) as…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… of governance for many mature open source projects, such as Apache Software Foundation, Linux Foundation or FreeBSD Foundation. A Foundation structure… users to get the best performance and lowest downtime possible. We focus on compatibility with Oracle MySQL, High Quality, and small but…
Post: Life Beyond MySQL
September 27, 2006 By 3 Comments
… be doing some Web projects on my own, besides doing MySQL Consulting. I think some people thought I am just using… edges, it is also not overly optimized in terms of performance yet, but it is already becoming fun to play with… know what this size is developed on – it uses Linux/Apache/PHP/MySQL of course plus Sphinx for full text search.
