…gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it,… choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY… you specify in the query? The tuple comparison you’re referring to is this example: WHERE…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… cpu combinations with taskset. The following chart shows a results comparison on a single-node (on the left) vs. two-node….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…Kazimieras- It’s all about performance. Suppose I have a 2TB database, but maybe my working … only 500GB. What are my options for achieving the best performance? I could by a ton of RAM, but that isn… Micron PCIe card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters…” test run as well using the base HDD MySQL configuration for purposes of comparison. Given the apparent differences in time-based flushing…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… any information how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store… cache life time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off… on SQL side. Also can you also do a comparison between performance of 5.6 memcached innodb write/read vs 5.6…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… to publish his comparison of all caches anyway, I decided to check peak performance of all caches compared to MySQL Server, by measuring… was selecting from MySQL table. Query vas very simple – lookup by primary cache, so this is kind of peak performance MySQL can provide… and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… analyzing how to implement them most efficiently with MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation systems, RAID Configuration, File… platform for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…) Notice the difference in response time. Refresh method performance comparison For demonstration purposes, I did the following: Created… | 155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ |…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… you need to consider is string comparison in MySQL is case insensitive by default while hash comparison will be done case sensitive unless… “`id` = 5″ and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5… dates? or after a date? A: Date comparisons work very similar to other comparison and same tricks may apply, for example you…
