…insert performance on Amazon EC2, and I have some interesting results that I wanted to share…memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory… Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5….
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…shared_memoryblogpercona.commanual shared_memory…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than APC shared memory cache – closest competitor. In real life performance difference can be evel larger as there will be some syncronization contention while accessing shared memory…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… helpful for MySQL Performance optimization tasks but there are number of things you need to know. First let me clarify what MySQL Query… fragmented, which reduces performance. This can be seen as large value of Qcache_free_blocks relatively to Qcache_free_memory. FLUSH QUERY… fast as specially designed systems such as memcached or local shared memory. It can’t retrieve multiple objects at the same time…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers…are supposed to be dedicated to RDS, not shared with the general usage of AWS as you…go from a solely in-memory bottleneck to solely on-disk. The insert performance is quite variable, more…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…per second and higher, lots of memory, lots of CPU cores, and most…like the thread counter and other shared data. These are going to get… queries that have mostly very fast performance, and occasionally have much worse, and –…and that’s where improvements to the MySQL source code are necessary. But in…
Post: Percona Server and XtraBackup weekly news, March 19th
March 20, 2011 By 2 Comments
…. Vadim has also spent a lot of time benchmarking against MySQL 5.5. Sorry, I can’t reveal how good the… Windows. We are interested in knowing how many people using MySQL on Windows would be ready to pay for us to… improved the performance and reliability of using shared memory for the InnoDB buffer pool. We updated Percona.TV, our companion site for MySQL videos…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server … patch, which provided the ability to use a shared memory segment for the buffer pool to enable … patch which provides similar improvements in restart performance. Replacement is due to SHM buffer pool …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t…. The physical and logical database design influences greatly how much memory and disk resources are required. The application’s access patterns…/O, performance can be quite acceptable or even very good. Do you have experience running MySQL in the Amazon cloud to share with…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In …there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition… our internal IRC channel and mailing list. We share all sorts of dirty tricks and neat ideas…
