… IOs it can handle. Imagine for example data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL… in case your data RAID volume was trashed. Regarding SWAP – I tend to have it but not optimize for it, putting it on shared drive…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… with RAID’ed EBS volumes and MySQL, versus RDS machines. …due to the way InnoDB handles I/O. If you…how much memory and disk resources are required. The application’s access patterns can be just as powerful a lever. Thus, careful design can… its performance, but if you can fit your working set of data…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… data …it can be quite nasty, so how can… much to…volume of updates may be very high and ask for optimization. Thinking about this and some other problems I found it…it will handle real-time counters very efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…how we can get a word out where and how…volume. So it is again similar to the time when I worked for MySQL…MySQL Performance the scope of our work proved to be much larger. We handle a lot of architecture design for MySQL…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…it is able to take advantage of all available resources in order to handle the workload. One reason that it…data and fetching rows from the buffer pool, with respect to a single query, but it can… how much improvement could be made to MySQL …much better than regular MySQL as the volume of data…
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
…much advice which could be found in Dell documentation about handling RAID with two failed hard drives. The impression is it…data sets take time Restoring 1.5TB volume is likely to take hours can you afford it…
Post: Innodb Fuzzy checkpointing woes
May 10, 2006 By Leave a Comment
…how much disk IO system is loaded and compare it to constant. However the shared drive at shared MySQL…well as disk volume itsef.  Should…can combine this data with device queue sizes and average request execution time to get some decent values. Anyway it…say this device can handle 1000 requests …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql) Are there alternatives? Yes. Can you have separate partitions for Innodb log volumes, etc.? Sure. Is it work doing much…handled…
