… for MySQL 5.6, when the workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory access… little higher by a couple of seconds, when compared to MySQL 5.6. Now let’s take a look at the status counters. MySQL…-memory, in fact MRR adds extra sorting overhead which means that the queries are just a bit slower as compared to MySQL 5.5…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… volumes you have, the higher probability that one of…MySQL than it is to Percona Server. I haven’t run extensive benchmarks against RDS 5.5, Percona Server 5.5, and MySQL 5.5…cost you have, so that’s something to think about. The physical and logical database design influences greatly how much memory…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…-Up you by getting more powerful MySQL Server hardware the cost is going to be increasing dramatically after…rented server which would usually have 1-2GB of memory may be couple of SATA hard drives – something… some higher end box with few cores 16-32G of RAMs and good IO subsystem which would cost $5…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… this array instead of buying it, the cost is likely to be quite a bit higher. Now, let’s look at the… 0.3 0.2 16.2 0.0 0.0 5.5 3% 0 17.2 sdj1 0.2 0.1 12… made to work really well if the database fits in memory and isn’t write-intensive. But the high and unpredictable… that if the active set of data stops fitting in memory, or if a lot of transactional writes are required, then…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…all kinds of other things. In MySQL 5 number of Innodb performance counters …and “spin rounds”. Spin locks are low cost wait, compared to OS wait, …memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… hardware, including RAID controllers, installed memory, and so on in the boot …5 5 If you don’t know how to read these, there’s a full explanation in our book, High Performance MySQL…decision is a consideration of the costs and benefits on the system as… be made at a much higher level. If we see that …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…have large Innodb database size Memory is paramount. 16G-32G is the cost efficient value these days. From…limited concurrency helps. The actual number may be higher or lower depending on your application and …benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row level …
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… if you have enough resources (such as memory). With MySQL common sense however does not always works… table headers) is well cached so the cost of table cache miss is not very …MySQL 5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4.2 has higher…
Comment: Finding your MySQL High-Availability solution – The questions
October 19, 2009 By 36 Comments
…performance, data needs to be in memory but… that about the same with… right that I should consider the cost of the solution in term of …higher availability. @Rob: 1. Yes, for GIS I would use PostGIS, I completely agree. 2.5… between your application servers and your MySQL servers? 2.9 Good point and…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… by primary key, caching data, higher concurrency, background flushes while on…if data size is close to memory size), generally slower writes, slower blob… the MySQL server – in particular Optimizer may have harder time because costs… to MyISAM because it gives 5% performance improvement but I can …
