… an overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… of CPU cores you can get, and I/O performance can be highly variable. You can mask I/O problems on some… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…, and you can plug that into your favorite server and hosting provider costs to see what the CapEx and OpEx are… reached 3. One of the samples shows the performance during a period of pretty high utilization. (Note: A read concurrency of 2… causing acute performance problems for the database, manifested as epic stalls and server lockups which show up as sky-high latency spikes…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… to hear complains about MySQL interactive performance – serving simple …mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql…and as such placing high pressure on buffer pool…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… your site or hearing you say “we are a SaaS hosted application for data mining stock market transactions,” or whatever the… read these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…, completely ignoring the fact they chose shared hosting. Of course this alone is not a … their usage is very high temporarily block users having huge spike in MySQL usage Personally I …all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS… benchmarked the largest available RDS instance, which is listed as “High-Memory Quadruple Extra Large DB Instance: 68 GB of memory… workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded long…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…problems with the key buffer hit ratio, and a host of smaller ones. If you make some assumptions … or “your key cache hit ratio should be very high, ideally above 99.9%” or “if your key …instrumentation in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance, and…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL…or by hosting providers. This simply means stopping old MySQL version and starting new one. MySQL …of scalability bugs in MySQL history when issues would only happen at high load. You …
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… take care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to MyISAM… traffic to it. In case application is not highly available so there is only one server you… have hundreds of thousands of tables per database host). This one is pretty much part of cold…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… given client host blocked from accessing the server by simulating number of failed connections. This can be avoided by having high max… appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization…
