…I used. EC2 Configuration I chose m2.4xlarge instance as that’s the instance type with highest memory available, and memory is what…mutexes. Another important configuration that I am using is that I am using “estimate” flushing method… Per Second. Let’s take a look at the graphs have a better view…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MariaDB 5.5 Now let’s take a look at what this optimization actually is and what benefits it brings. Multi Range Read With… chooses the wrong query execution plan. Let’s take a look at what are the good and bad query execution plans. a. Bad… with joins and specifically with Block Access Join Algorithms. So I am not going to cover it here, but will cover it…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…I felt that this should be revisited. While I am still running experiments, I would like to share earlier results what I have. I… my CentOS 6.2, so I could not test it. At this point we may decide …. In conclusion ext4 looks like an good option, providing 20% better throughput. I am still going to …
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…I do not particularly like its write performance – I wrote about it before, that’s why I am looking for comparable alternatives. Samsung 830 256GB looked…what kind of response time we should expect, I…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… that someone else can follow, I am not doing my job. I would also note that the commands I‘ll show here are the…. Next I look at a couple of all-in-one commands. For example, ‘top -n 1′ and ‘uptime’. That shows me what processes are…. Next I look at the data in the server and see what I think about it. If the server is not heavily loaded, I may even…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… basic, because beyond “fundamental” and “basic,” I am about out of descriptive words. The metrics I explained in the last post were all… the pattern we see? Let’s look at some real data and see what this looks like. I’ve grabbed some TCP packets from a… second later. This is the “echo” effect that I mentioned before. What are we looking at? It might seem that this is a small…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
…look at most popular web pages or search engine keywords which bring you most of the traffic. If you’re looking at…what if you would like to show percents not just absolute value ? For illustration purposes I… well implemented inside MySQL. Why am I looking on reporting performance optimization ? It …
Comment: Disaster: LVM Performance in Snapshot Mode
November 1, 2010 By 55 Comments
I know many of you here are talking about Databases setups … be less overall. I am talking about more general purpose setups, not pure database systems. This is what I am currently looking at now as a possible way to relieve the snapshot “blues” for our servers. Rather than having one large logical volume I am…
Comment: MySQL and Sun - Oportunity for smaller companies ?
April 4, 2008 By 10 Comments
…, but I do take issue with the idea that Pythian’s isn’t led by seasoned MySQL leadership. What am I, chopped liver? 
I hope you don’t mind if I share some Pythian trivia to set your mind at ease. Pythian… you go to web.archive.org and look up Pythian.com, you will see that I was popularizing an offsite delivery model…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at it!!  How… data in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at it!! How can that… from the database. Remember memcached needs repeatability to be helpful. I am still getting a really solid # of hits in memcached, but…
