…metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as… we may expect 0.96ms response time, which increases to 1.62ms under 32 threads. The periodic …interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…_orderdate LIMIT 10; In-memory workload Now let’s see how effective are the join optimizations when the workload fits entirely… best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…_read. While MySQL 5.6 is also reporting increased numbers for the counter Handler_read_key. This is because of how status counter values are incremented when index lookup is performed….5 when compared to MySQL 5.5, and this does not make sense to me. Probably its due to a bug in how counter is…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
…Performance MySQL, 3rd Edition (worth $55 each), the recently released update to the popular second edition! This year’s MySQL…easy for you to enter the contest! Here’s how you …to the session and use the social sharing buttons on it. It is OK to enter multiple times — each time you enter increases…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to…to two nodes instead of three nodes, will it help to improve the response time ? – Do we need to increase…to see an affect of having a side on the server. For example, the famous problem with DROP TABLE performance…
Comment: Finding your MySQL High-Availability solution – Replication
April 11, 2012 By 6 Comments
… my company had 15-20GB of mysql database, we need performance to increase 500%. currently we are using free mysql version thats comes under centos linux, we are had enough resource left, RAM, CPU in server. My question is: Does mysql enterprise edition helps us? How? What are the other options we can use…
Comment: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… of how a piece of software will perform in the real world as much as possible, so they’re often coded to suit how they’ll likely be used. Your tpcc-mysql for example doesn’t use JOINs… and emphasising benchmarks that benchmark performance across the board? With the increasing emergence of drop-in replacements for MySQL like Percona and MariaDB…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL…. It is surprising how often a server …to the checks in that list, there are several others that can be performed with existing plugins, so there was no need to…example) get the incremental increase in a …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…Performance by Cary Millsap. So how we can use this data to estimate capacity of MySQL…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
…to the ones I had in MySQL Performance Landscape presentation – neither of them was match to Opteron performance in MySQL… != Performance. My expectation for performance per clock cycle was – it should be increasing … with article authors advising them how to tune MySQL and what is the reason for…
