… an overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… affected by the shared nature of EBS storage, which can provide variable bandwidth at different times. It is widely speculated on… 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
… the performance of two real customer systems running web applications. Let’s begin with a system running in a popular hosting provider‘s…, and you can plug that into your favorite server and hosting provider costs to see what the CapEx and OpEx are for… output of iostat.) I would characterize this as very good performance. Sub-millisecond latencies to disk, pretty much consistently, for reads…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…with different result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade …small simple systems or by hosting providers. This simply means stopping old MySQL version and starting new one. MySQL always was very good …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… same is true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for… appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
…year we had pretty good track record with MySQL Performance Blog – there were times when site was slow …console, backup etc. Plus we had one server hosted with them in Europe for couple of …problem being resolved and which feedback one would provide. Of course there may be internal ticket created…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads… 0 0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… the patch features will surely be a great help for hosting providers to produce detailed reports on how each customer utillizes the… fed into scripts to bring you automated reports or to perform actions such as: list users by the number of queries… statements which all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans, disk…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO … can’t always analyze the local system performance independently from anything else. Performance This is perhaps the most interesting one. …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… cluster For best performance, there should be … 2010′; mysql> use ontime1; Database changed mysql> show table … that RLE techniques provide. I have not …hosts.internal [host list omitted] Now you need to set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software developers, hosted service providers, and appliance developers. We perform paid and unpaid…’s research in part, but not perform the full and balanced disclosure that Percona would perform, then that is acceptable as long…
